How to Convert a Mercury PDF Statement to CSV or Excel
Mercury's export is better than most. The gaps are narrow, specific, and worth knowing before they cost you a reconciliation.
Mercury does most of this well
It is worth being straight about that up front, because a page arguing you need a converter for Mercury would be overselling. Mercury has direct integrations with QuickBooks Online, NetSuite and Xero. It offers pre-formatted QuickBooks and NetSuite CSVs so you are not remapping columns. Its Advisor Portal gives accounting firms a single login across clients, and its bookkeeper role can view all accounts and transactions without being able to move money, which is exactly the permission model Novo lacks.
If you have account access and you are working on a recent period, use the export. It is the better tool and this page is not for you.
Quick answer: use Transactions → Export all or Export filtered for anything recent. Convert the statement PDFs when you are working from what a client sent you, when you need the statement as the formal document, or when you are past what the export covers.
The three details that catch people
Dates are in UTC
Mercury states it plainly in the Statements header: all dates in UTC. For a company operating on Eastern or Pacific time, that means a transaction made in the evening can land on the next calendar day in the statement relative to what the app showed.
Eleven months a year this is a curiosity. At a month end, and especially at a year end, it moves transactions between periods. If a Mercury reconciliation is out by one or two items and they are all near midnight on the last day, this is why.
The credit card flips the signs
Mercury notes that on its IO credit card statements, charges and balances display as positive values while payments and refunds display as negative — and says outright that this differs from the Transactions page. Two Mercury documents, opposite sign conventions. Anything that consumes both needs to know which it is reading.
The API caps statements at three months
Mercury's transactions endpoint is generous, returning up to 1,000 results per call with date filters. The statements endpoint is not: the maximum date range supplied via start and end is three months total, and treasury and credit accounts are not supported on it at all. Anyone building an automated pull of a full year's statements hits that wall on the first attempt.
Converting the statements (4 steps)
- Try the export first
On the Transactions page, use Export all or apply filters and use Export filtered, then choose .csv or .xlsx. - Or take the pre-formatted CSV
If you are importing to QuickBooks or NetSuite, Mercury offers a CSV already formatted for each. - Otherwise download the statements
Open Statements, pick the year, and download the monthly PDF for each month you need. - Convert them
Go to reconcileiq.com/tool, upload the statements, verify against the statement totals, and download the CSV.
One number to ignore
You will see Mercury's "31 days" quoted as an export limit. It is real, but it applies to bulk attachment downloads — receipts and documents — not to transaction exports, which have no published cap. It is one of the more commonly misapplied figures in this corner of the internet.
Similarly, retention. Mercury publishes no statement retention figure. Any page telling you Mercury keeps statements for a specific number of years is guessing, and we are not going to join in.
What comes out
Mercury does not publish the column structure of its statement PDFs, so this page will not describe one. What comes back from the converter is consistent regardless: one normalized sortable date column, descriptions with wrapped lines rejoined, one correctly signed amount column, and the running balance kept separate.
Given the UTC convention, it is worth checking the first and last rows against the statement's stated period before you import anything. If a transaction sits outside the range the statement claims to cover, that is the timezone shift showing up, not an extraction error.
Convert Your Mercury Statement
Upload the PDF, check it against the statement's own opening and closing balance, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Yes, and Mercury's export is one of the better ones. From the Transactions page you can Export all, or filter first and Export filtered, choosing .csv or .xlsx. Mercury also offers pre-formatted QuickBooks CSV and NetSuite CSV downloads that you upload straight into your bookkeeping software. There is no OFX or QBO format.
Mercury does not publish a retention figure, so this page will not invent one. What Mercury does state is that monthly statements are generated for each account between the 1st and 3rd of each month, that you can generate custom statements covering a narrower range within the current month, and that accounts created after the 1st will not have a statement until the following month.
Because Mercury states all dates on the Statements page in UTC. If your business runs on US Eastern or Pacific time, a late-evening transaction can appear on the following day relative to what you saw in the app. This matters most at month and year boundaries, where a single transaction shifting a day moves it into a different period. Check the first and last rows of any converted statement against the statement's own date range.
Not for statements. The transactions endpoint returns up to 1,000 results per call with start and end filters, but the statements endpoint states that the maximum date range supplied via start and end is three months total, and that treasury and credit accounts are not supported on that endpoint. Note also that Mercury's widely quoted 31-day limit applies to bulk attachment downloads, not to transaction exports.
Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what allows scanned and photographed statements to work as well as native PDFs.