Convert a Mercury bank CSV export to a QuickBooks .qbo file in under a minute. Import Mercury checking, savings, and IO card activity into QuickBooks Online or Desktop cleanly.
No account needed for your first conversions. We never store your bank login.
Short answer: Mercury is a financial technology company, not a bank, so it offers no OFX Direct Connect and QuickBooks Desktop cannot pull from it automatically. The dependable route is to export your Mercury activity as a CSV and convert it here. Upload the CSV and the converter builds a QuickBooks Web Connect (.qbo) file with every deposit, transfer, and card charge signed correctly. QuickBooks Online imports the .qbo directly, and QuickBooks Desktop reads it through File, Utilities, Import, Web Connect Files.
Mercury is built for startups and growing companies, and its banking services are provided by partner banks. That fintech setup is convenient, but it changes how transactions reach your books. Mercury does have a native QuickBooks Online integration, and for going-forward checking activity it works well. The gaps show up with QuickBooks Desktop, with history that predates the connection, and when the account will not link at all. Converting a CSV to a .qbo covers every one of those cases without waiting on a feed.
Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.
The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.
Every transaction is parsed and checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
Mercury offers a native QuickBooks Online integration that syncs new checking transactions going forward. It does not offer Direct Connect, so QuickBooks Desktop has no automatic way to pull Mercury activity. When you need Desktop support, historical transactions, or the account simply will not link, exporting a CSV and importing a converted .qbo gets Mercury data into QuickBooks without depending on the integration.
Because a fintech connection routes through partner banks and an aggregation layer, the link can refuse to authorize or reconnect without pulling transactions. Mercury business users have reported exactly this in the QuickBooks community. When the connection stalls, you do not have to troubleshoot it to keep your books current. Download a CSV from Mercury, convert it to a .qbo, and import that file into the matching account instead.
In Mercury, open the account and export its transaction history as a CSV. Mercury even offers a QuickBooks-formatted CSV, but a raw CSV still forces QuickBooks Online through column mapping and a 350 KB upload cap, and QuickBooks Desktop cannot read a CSV at all. Convert the CSV to a .qbo on this page and you skip the mapping screen, avoid the size limit, and get a file both editions accept.
Sign in to Mercury, open the checking, savings, or card account you want, and choose the export option on the transactions view. You can export a single account or bulk-export statements and CSVs for a date range from Mercury Business. Pick the CSV format and the period you need to record, then upload that file in the converter at the top of this page.
Upload the exported CSV in the converter above. The tool detects the date, description, and amount columns, normalizes dates to the format QuickBooks expects, strips dollar signs and commas, and checks the parsed total against your file before it writes the .qbo. Download the .qbo and import it into the matching Mercury account in QuickBooks. The whole pass takes under a minute, with nothing typed by hand.
The right choice depends on which QuickBooks edition you run and how much history you need. This table lays out what a Mercury account supports today and what each option means for your books.
| Method | Works with Mercury? | QuickBooks Desktop? | Best for |
|---|---|---|---|
| Native QuickBooks Online sync | Yes, going forward | No | New checking activity in QBO |
| Direct Connect (.qbo, automatic) | Not offered by Mercury | No | Not available |
| Raw CSV upload to QBO | Yes, with column mapping | No | Small files under 350 KB |
| CSV export, convert to .qbo (this page) | Yes, every account | Yes | Desktop, history, and clean reconciliation |
The native sync only brings in activity from the day you connect it, so anything earlier has to be imported by file. Export the older period from Mercury as a CSV, convert it to a .qbo here, and import that into the matching account. A .qbo is not held to the QuickBooks Online raw-CSV size cap, so you can backfill a full year of Mercury activity in one file rather than splitting it into pieces.
Yes. Mercury checking, Mercury savings, and the Mercury IO card all export activity as a CSV, and the converter handles each one. Set checking and savings up as Bank accounts in QuickBooks and the IO card as a Credit Card account, so charges increase the balance you owe and payments reduce it. Convert the exported CSV to a .qbo and import it into the matching account, and the running balance reconciles against your Mercury statement.
In QuickBooks Online, open Transactions, then Bank transactions, select the matching Mercury account, and use the upload option to add the .qbo file from your computer. QuickBooks reads the file, shows the transactions for review, and posts them once you accept. Because it is a Web Connect file rather than a raw CSV, you skip the column-mapping screen that raw CSV uploads force you through.
In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files, and choose the .qbo you downloaded here. Desktop has no native import for a plain CSV of bank transactions, so a converted .qbo is the only file it accepts for Mercury activity. Match it to the correct account when prompted and the transactions post straight to that register.
Yes, and the accuracy check is the point. Before the .qbo downloads, the converter totals every transaction it parsed and compares that against your Mercury file. If a row is missing or misread, you see it in the preview instead of during reconciliation weeks later. The tool only reads the transaction rows, date, description, and amount, to build the file, and never asks for your Mercury login.
Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Related guides: convert any bank or card file with the CSV to QBO converter, batch several exports at once with the bulk CSV to QBO converter, set signs correctly with the credit card CSV to QuickBooks guide, understand the file itself in the QuickBooks Web Connect file converter guide, and follow the Mercury to QuickBooks walkthrough.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
