To export Mercury transactions to QuickBooks, open the transactions view in your Mercury dashboard, filter to one account and a date range, and export the file in the QuickBooks (QBO) format if it is listed, or as CSV. Upload it in QuickBooks under Bank transactions. If QuickBooks lists Mercury for bank connection, a feed can replace the files.
Where the Mercury transaction export sits in the dashboard
Mercury is an online business banking service, so everything happens in its web dashboard. The export starts from the transactions view, where you narrow the list to one account and a date range, then use the export or download control. This post does not quote Mercury's exact menu labels, because they change. Follow your screen.
The general sequence:
- Sign in to Mercury in a desktop browser.
- Open the transactions view.
- Filter to a single account. Checking, savings and any card spending should each be exported on their own.
- Set the date range.
- Use the export control and choose a file format.
- Save the file with a name that says which account and which dates it holds.
Filtering matters more here than at many banks. A dashboard that shows all accounts in one list makes it easy to export everything together, and a combined file put into one QuickBooks account mixes the balances of several. One account per file avoids that.
If the export control is missing, try again from the account owner's login, then ask Mercury's support team what your login can export.
Mercury CSV or QBO: which file should QuickBooks get?
Pick QBO when the export offers it, because QuickBooks reads it without column matching. Pick CSV when QBO is not listed, when you want to check the data in a spreadsheet first, or when the books are in Xero. Either works with QuickBooks Online. QuickBooks Desktop needs QBO.
Intuit's page on uploading transactions manually lists the transaction file types QuickBooks Online accepts: CSV, TXT, QBO and OFX, plus Quicken QFX files. It names QBO as the suggested one. For a CSV, it expects either three columns (date, description, amount) or four (date, description, credit, debit).
What changes between the two:
- QBO. You choose the QuickBooks account, review the lines and accept. Dates and amounts are already in the shape QuickBooks wants.
- CSV. QuickBooks asks you to match each column to a field and to say how amounts are laid out. You also pick the date format. A wrong choice puts deposits in as withdrawals or reads March 4 as April 3.
A CSV export from a modern bank often has more columns than QuickBooks needs, such as a category, a note or a counterparty name. That is fine. Map the date, description and amount, and leave the rest unmapped.
The same choice comes up at traditional banks. Downloading a QBO file from Chase shows the pattern at a large high-street bank, which makes a useful comparison if you hold accounts at both.
Setting the Mercury export date range so nothing doubles
Start the export the day after the newest Mercury transaction already in that QuickBooks account, and end it a day or two before today. For a first import, start on the date of the account's opening balance in QuickBooks. Touching ranges with no overlap mean every day comes in once.
Intuit's guide to uploading transactions manually gives the same rule: for an account that already has transactions, use the day after the last one, and for an empty account, match the opening balance date. It also limits each upload to 1,000 lines and 350 KB, so a long range for a busy account should be split.
Why stop short of today? Recent card transactions may still be pending, and a pending line can change amount or disappear. Leaving the last day or two for the next export keeps those changes out of your books.
Keep a short log of each export: the account, the From and To dates, and the number of lines. When something looks wrong months later, the log shows at once whether a range was skipped or repeated.
Transfers between two Mercury accounts
A move from Mercury checking to Mercury savings shows up in both exports: as money out of one and money in to the other. Import both files, then record the pair as a single transfer in QuickBooks rather than as an expense and an income. If you only import checking, the transfer looks like spending, and your profit comes out lower than it really was.
Mercury file upload or a direct QuickBooks bank feed?
A bank feed connects QuickBooks to Mercury so new transactions arrive without exporting. A file upload is manual each time but gives exact control over dates. If you import every month, the feed can save the most time once it works, with files kept for filling gaps or catching up.
| Bank feed | File upload | |
|---|---|---|
| Effort each month | None once connected | Export, upload, review |
| Control over dates | Set once, at connection | Every file |
| History on first connection | Set by the bank and QuickBooks | Whatever the export allows |
| When it breaks | Lines stop arriving until you reconnect | Nothing to break between uploads |
| Risk of duplicates | If you also upload files for the same days | If file ranges overlap |
To try a feed in QuickBooks Online, search for Mercury on the bank connection screen. If it is listed, sign in through it. Intuit's guide to connecting bank and card accounts says the history pulled in on first connection varies by bank, from 90 days to 24 months, and that you pick the start date from a dropdown.
The rule that matters most: do not run a feed and file uploads into the same account for the same days. If you switch from files to a feed, set the feed's start date to the day after your last uploaded file.
A first Mercury import into QuickBooks Online, worked through
Here is a whole first import with invented numbers. A two-person design studio opened its Mercury checking account on March 1, 2026, and is setting up QuickBooks Online on October 16. It wants every transaction since the account opened, and it averages about 120 transactions a month.
The plan:
- Create the account in QuickBooks as a bank account with an opening balance of zero on March 1, since the Mercury account was new.
- Work out the line count. About seven and a half months at 120 a month is roughly 900 lines, close to the 1,000-line limit. Split it to be safe.
- Export two files from Mercury:
- File 1: March 1 to June 30, 2026, about 480 lines.
- File 2: July 1 to October 14, 2026, about 420 lines.
- Upload File 1 under Bank transactions, choose the Mercury checking account in QuickBooks, review and accept.
- Upload File 2 the same way.
- Check the balance. The QuickBooks balance for the account should now equal Mercury's balance at the end of October 14.
- Decide on the future. Either connect the feed with a start date of October 15, or keep exporting monthly.
If step 6 does not agree, compare the two files' date ranges first, then look for a missing month. A difference equal to one transaction usually points to a line that was pending at export time.
For the months of any account opened elsewhere before Mercury, statements from the old bank fill the gap. SimpleBankConvert is being built to turn a PDF statement into a CSV or QBO file for QuickBooks Online and is in early access. You can join the early access list.
Mercury exports for QuickBooks Desktop users
QuickBooks Desktop takes Mercury data only as a .qbo Web Connect file, not as a CSV bank upload. You import it from the File menu, and the first import asks which Desktop account the file belongs to. Intuit's Desktop bank feeds page states that Web Connect works only with .qbo files.
Two Desktop points differ from Online. First, Intuit says you cannot download the same transactions into the same company file more than once, so keep each file's range clean. Second, Intuit advises backing up the company file before each download. Make the backup a habit.
Choosing the dates for each Desktop file has its own quirks, especially when a previous import ended partway through a day. Setting the Web Connect date range in QuickBooks Desktop goes through how to pick From and To dates for each new file.
When the Mercury export offers only a Quicken file
If the export lists a Quicken format but no QuickBooks one, QuickBooks Online can take the Quicken (QFX) file as it is, or a CSV. For Desktop, do not rename the Quicken file and hope; convert it properly. A Quicken file is close to a QBO file inside, but Desktop checks the type.
What to do when your bank only offers a Quicken download covers the options in detail: a CSV upload, a careful conversion, or a bank feed instead. For most Mercury users on QuickBooks Online, uploading the QFX or a CSV is the shortest route. For Desktop users, who cannot upload a CSV as a bank file, a proper conversion or the feed is the way through.
Whatever route you take, finish with the same check: the QuickBooks balance for the Mercury account should match the balance Mercury shows for the last day you imported.