How to Convert Mercury Bank Statements (PDF) to Excel for QuickBooks Online

Mercury was built for startups and modern tech businesses, and it shows: their statement design is clean, their CSV export is excellent, and their API access is best-in-class among US banks. For ongoing bookkeeping work, you'll almost never need to convert a Mercury PDF — the CSV export gives you everything.

But for historical periods, audits, or when a client hands you a PDF instead of granting account access, PDF conversion still comes up. This guide covers the Mercury-specific things to know.

Mercury statement specifics

1. Mercury Treasury activity

Mercury Treasury invests idle cash in money market funds. If your client uses Treasury, you'll see periodic sweeps from checking into Treasury and back. These appear as transfers, not expenses or income — but the yield earned within Treasury appears separately as TREASURY INTEREST credits.

For QBO: Treasury sweeps route to a transfer (separate Treasury account in QBO), and the yield credits route to Interest Income.

2. Investor wire transfers

Mercury is a popular startup bank, so many statements include wire transfers from investors (seed funding, Series A, etc.). These show as inbound wires with the investor entity name in the description. These are equity events, not revenue — route to Owner's Equity or a specific Funding account in QBO, not to Sales.

Get this wrong and your startup client's P&L will dramatically overstate revenue.

3. Multi-account structure

A Mercury "account" typically has multiple sub-accounts (Checking, Savings, sometimes specific tax holding accounts). The PDF statement may bundle all sub-accounts under one statement file. Treat each sub-account as a separate QBO bank account and split the statement during conversion.

Three ways to do the conversion

Option 1: Manual copy-paste

Open the PDF, select the transaction table, paste into Excel, use Text-to-Columns, manually merge any continuation rows, drop extras, reformat the date, save as CSV. Works for one statement; tedious for more.

Option 2: Generic PDF-to-Excel tools

Adobe Acrobat, Smallpdf, Tabula will extract the table but won't merge continuation lines or skip the running balance. Output usually needs cleanup.

Option 3: A bank-statement-specific converter

Purpose-built tools recognize the Mercury format, handle the quirks above automatically, and reconcile to the statement totals before download.

Common errors and fixes

"My client's startup looks profitable but they're burning cash"

You probably miscoded investor wire transfers as revenue. Find any inbound wires labeled with investor entity names and recategorize them to Owner's Equity (or the appropriate funding account). This is one of the most common errors in startup bookkeeping.

"QBO is rejecting my date format"

QBO requires MM/DD/YYYY. If your conversion output uses a different format, fix it in Excel before importing using =TEXT(A1,"MM/DD/YYYY").

Importing the converted file into QuickBooks Online

Once you have a clean Excel or CSV file from a Mercury statement, the QBO import is the same as for any other bank. QBO expects three columns: Date (MM/DD/YYYY), Description (plain text), Amount (decimal, negative for debits).

To import:

1. Go to Bookkeeping → Transactions → Bank transactions
2. Pick the bank account, click the dropdown next to "Link account," and choose Upload from file
3. Drag in the CSV, map the columns, click Next
4. Spot-check the preview
5. Confirm and import

Final checklist before importing your Mercury file

• Three columns only: Date, Description, Amount
• Date format MM/DD/YYYY
• Debits are negative
• No empty rows or unmerged continuation lines
• Amount total equals Statement Ending minus Beginning balance

For more on the reconciliation discipline that makes this kind of work tractable, see our catch-up bookkeeping playbook.