Mercury Bank Statement to QuickBooks: Convert PDF to QBO and IIF

Turn a Mercury bank statement into a QuickBooks-ready QBO file. Download the monthly statement from your Mercury dashboard, upload it here, and let PDFQBO read every transaction into a clean QBO for QuickBooks Online or an IIF file for QuickBooks Desktop. Ideal for the catch-up months a live sync never touches.

Quick answer

Mercury has a native QuickBooks Online integration that syncs new transactions daily, but it works with QuickBooks Online only and does not backfill the months before you connected it. For catch-up bookkeeping, a prior year, a closed account, or QuickBooks Desktop, download the Mercury statement as a PDF, convert it to a QBO file with PDFQBO, and import it under Bank transactions.

No software to install QBO and IIF output Batch upload

Last updated July 2026

Convert your Mercury statement

Upload a Mercury PDF statement and get a QBO file for QuickBooks.

No credit card required to try your first statement.

QBO + IIF

QuickBooks Online and Desktop

Browser based

Nothing to download

Batch ready

Many statements at once

Auto delete

Files removed after conversion

How to convert a Mercury PDF statement to QBO

Four steps take you from a Mercury PDF statement to transactions sitting inside QuickBooks. No retyping, no copy and paste.

Upload the Mercury PDF

Drag the Mercury statement you downloaded into the converter above, or select several months at once for a batch. Statements from the Mercury portal and scanned copies both work.

Read every transaction

PDFQBO finds the date, description, and amount on each line and keeps deposits and withdrawals on the right side. Running balances, headers, and inserts are ignored so only real transactions remain.

Review and confirm

Check the extracted transactions in a simple table before you export. Edit anything that needs a tweak so the numbers tie out to the Mercury statement total before the file leaves the page.

Download and import

Export a QBO file for QuickBooks Online or an IIF file for QuickBooks Desktop. Import it through the Banking screen and your Mercury transactions are ready to categorize and reconcile.

How to download your Mercury statement as a PDF

Mercury is a digital business bank, so there are no paper statements: every monthly statement downloads as a PDF from your Mercury dashboard and the mobile app, with your full account history on file. You need that PDF before you convert it, so grab the months you want first. The menu is usually called Statements.

1
Sign in to your Mercury dashboard at mercury.com and open the account you need.
2
Go to the Statements area for that account (usually under the account menu or Settings).
3
Pick the month you want; the statement downloads as a PDF you can save.
4
Repeat for each month, or download the statement PDF from the Mercury mobile app.

Once the PDF is on your computer, upload it to the converter at the top of this page to turn it into a QBO file.

A Mercury to QuickBooks converter built for clean books

Manual entry of a Mercury statement is slow and easy to get wrong. PDFQBO produces an import file that matches the statement, so reconciliation goes faster.

Reads the Mercury layout

PDFQBO recognizes the transaction table on a Mercury statement, captures the posting date, full description, and signed amount, and keeps debits and credits on the correct side. Because it reads the text rather than guessing, you avoid the transposed digits and misread amounts that creep in with manual entry.

Every Mercury account type

Mercury checking and savings accounts, Mercury Treasury balances, and the Mercury credit card all produce monthly PDF statements PDFQBO can read and convert. Checking, savings, and credit card statements all follow the same upload, so you can keep every Mercury account in QuickBooks the same way.

QBO and IIF output

Export a standards based QBO (Web Connect) file for QuickBooks Online or an IIF file for QuickBooks Desktop Pro, Premier, and Enterprise. Dates, amounts, and decimal formatting follow what QuickBooks expects, so the import goes through without the formatting errors that block CSV uploads.

Catch up months in one batch

Behind on the books? Upload a year of monthly Mercury statements together and convert them in one pass. Each statement is tracked on its own so you can see exactly which files converted cleanly and which need a quick look.

Scanned statements welcome

If your only copy is a scan or a photo of a paper Mercury statement, PDFQBO uses optical character recognition to read the printed text. Clear scans convert reliably, so old archive statements are not stuck as flat images you would otherwise have to type out.

Private by default

Mercury statements carry sensitive account data. Uploads and downloads run over encrypted connections, files are processed on secure servers, and they are deleted automatically once your QBO file is ready. Your statement data is never sold or used to train anything.

Why convert a Mercury statement instead of relying on the live sync

The Mercury bank feed only reaches so far

Mercury connects to QuickBooks Online, NetSuite, and Xero and syncs transactions automatically several times a day, which is great for keeping current books up to date. What the live sync does not do is backfill the months before you turned it on, reach a closed Mercury account, or feed QuickBooks Desktop, which the integration does not support. Whenever a startup finally sets up its books, hands the file to a new accountant, or needs QuickBooks Desktop, those earlier transactions live only in the Mercury PDF statement. Converting the statement to a QBO file imports every line with the dates and amounts already formatted, so the books tie out to the statement total.

What about uploading the PDF straight to QuickBooks?

QuickBooks Online added a built-in upload that uses AI to read a PDF or image statement, which is handy for a quick one-off. It has real limits, though: each file is capped at 1,000 transactions and 350 KB, it is QuickBooks Online only so it does nothing for Desktop, and you cannot review the parsed transactions before they post. Converting the Mercury statement to a QBO file first removes those caps, lets you check the data against the statement total, handles batches and scans, and works on both Online and Desktop.

QBO versus CSV import

QuickBooks Online can also take a three column CSV, but CSV imports are fragile. You have to map columns by hand every time, fix date formats, and split a single amount column into debit and credit. A QBO file carries that structure already, so the import is faster and far less likely to fail. For a clean one shot import of a Mercury statement, the QBO route is the smoother one.

Who converts Mercury statements to QuickBooks

Anyone who keeps books in QuickBooks but only has the Mercury statement as a PDF.

Bookkeepers catching up the books

A startup that has banked with Mercury for a year before setting up QuickBooks needs every prior month, not just the activity a live feed captures going forward. Download the stack of Mercury statement PDFs and PDFQBO converts each one to its own QBO file, so a full year of catch-up bookkeeping imports in one sitting instead of being keyed in by hand.

Accountants and CPA firms

Firms juggle many client files and many banks. A Mercury to QBO converter gives one consistent way to get a client's Mercury statement into their books, including closed accounts and older periods the live feed will not reach.

Small business owners

If your Mercury connection drops or only pulls recent history, you can still get every transaction into QuickBooks by converting the PDF statement yourself. It keeps your books current without waiting on support.

Historical and year-end imports

When you need older Mercury transactions for a year end, an audit, or a loan application, converting the archived PDF statements to QBO is the reliable way to backfill the gap in QuickBooks.

Mercury to QuickBooks: frequently asked questions

Does Mercury connect to QuickBooks?

Yes. Mercury has a native QuickBooks Online integration that syncs transactions automatically several times a day. It works with QuickBooks Online only, not Desktop, and it syncs activity going forward rather than backfilling older months. For history, a closed account, or Desktop, convert the Mercury PDF statement to a QBO file.

How do I import Mercury transactions into QuickBooks?

Two ways. Turn on Mercury built-in QuickBooks Online integration for ongoing daily sync, or, for the months before you connected it and for QuickBooks Desktop, download the Mercury statement as a PDF, convert it to a QBO file with PDFQBO, and upload it under Bank transactions in QuickBooks.

Does Mercury work with QuickBooks Desktop?

Mercury built-in accounting integration supports QuickBooks Online only. To get Mercury transactions into QuickBooks Desktop, download the statement PDF and convert it to a QBO (Web Connect) file or an IIF file with PDFQBO, then import that in Desktop the same way you would any bank statement.

How do I download a statement from Mercury?

Sign in to your Mercury dashboard, open the account, go to the Statements area, and choose the month; the statement downloads as a PDF. The Mercury mobile app can download the same statement. Save the PDF and upload it to the converter at the top of this page.

Can I get a QBO file from Mercury?

Mercury exports CSV and offers a live QuickBooks Online sync, but it does not hand you a downloadable QBO (Web Connect) file. To get a QBO file, run the Mercury PDF statement through PDFQBO, which reads every transaction and exports a QBO you can import into QuickBooks Online or Desktop.

How do I catch up a year of Mercury bookkeeping in QuickBooks?

Download each monthly Mercury statement as a PDF and convert them with PDFQBO. Each statement becomes its own QBO file, so a full year of catch-up imports in one sitting, with the dates and amounts already formatted for QuickBooks. It is faster and more reliable than typing transactions in by hand.

Is it safe to upload my Mercury statement?

Uploads and downloads run over encrypted connections, files are processed on secure servers, and they are deleted automatically once your QBO file is ready. Your Mercury statement data is never sold or used to train anything.

Convert your Mercury statement now

Upload a Mercury PDF, get a QuickBooks ready QBO file, and skip the manual data entry. Your first conversion is on us.

Convert a statement View pricing