How to Import Mercury Transactions into QuickBooks (Online Bank Feed and Desktop)
Mercury connects to QuickBooks Online directly. QuickBooks Desktop isn’t covered: Mercury’s help center says “We also don’t currently support QuickBooks Desktop.” Mercury doesn’t list a QuickBooks (.qbo) download either. Its exports are CSV and XLSX, so Desktop users need one conversion step. Here are both paths.
Option 1: QuickBooks Online bank feed
- In the Mercury dashboard on the web, click your company name in the top left corner.
- Go to Settings → Integrations, hover over QuickBooks and click Connect.
- Follow the steps to connect Mercury to your QuickBooks bank feed, and map each Mercury account to an account in your chart of accounts.
- Click Complete. QuickBooks now shows as Active on the Integrations page.
During setup Mercury offers Enrichment: it pulls your QuickBooks GL codes into Mercury so you can categorize transactions there and sync classes, locations, receipts, notes and vendors along with them. You can skip it and connect the bank feed only. Mercury says enrichment isn’t available on the QuickBooks Solopreneur plan.
Things Mercury’s guide points out:
- With enrichment on, transactions you mark Ready on the Accounting page sync to QuickBooks once a day. If a sync fails, it isn’t retried: re-sync those transactions by hand from the Accounting page.
- The sync is one way. Edits you make in QuickBooks don’t go back to Mercury.
- Treasury accounts are linked from QuickBooks: Transactions → Bank transactions → Link account (the button, not the arrow), search for Mercury, pick the Treasury account and map it. If you linked Treasury before April 2025, choose a start date after the last Treasury transaction already in QuickBooks to avoid duplicates.
- If the feed stops working, reset both sides: disconnect in Mercury under Integrations, then in QuickBooks go to Bank Transactions → Link Account ▾ → Manage Connections and turn off every account under each Mercury connection. Then connect again from Mercury.
Mercury’s article doesn’t say how far back the first sync goes. If older months are missing, upload them from a file (Option 2) for exactly the dates the feed doesn’t cover.
Option 2: export a file (QuickBooks Desktop, or Online without the feed)
Mercury has two exports, both on the web dashboard:
Monthly statements as a QuickBooks CSV: go to Documents & Data → Statements, choose the account(s) in the drop-down, click the vertical dots at the end of a statement row and pick QuickBooks CSV. Mercury calls it a pre-formatted file for your bookkeeping software. It’s still a CSV, not a .qbo file.
Any date range (CSV or XLSX): on the Transactions page, click Export all, or apply filters (account, dates) and click Export filtered. Choose .csv or .xlsx and click Download. Use this for the current month or for dates that don’t line up with a statement.
Import into QuickBooks Desktop: Desktop only imports bank transactions as a Web Connect (.qbo) file, so convert the Mercury file first with CSV to QBO, or Excel to QBO for the .xlsx. Mercury doesn’t document the columns, so check the preview: money out should be negative and money in positive. Then go to File → Utilities → Import → Web Connect Files, pick Use an existing account and choose your Mercury account.
Import into QuickBooks Online: Banking → Link account ▾ → Upload from file and choose the CSV. You map the columns by hand on each upload.
Tips
- Don’t import the same dates through the bank feed and a file. Start each file the day after the last transaction already in QuickBooks.
- Statement CSVs cover whole months. For the days since the last statement, use Export filtered on the Transactions page.
- To check what’s in a .qbo file before importing it, open it in QBO to Excel.
- Receipts and attachments are a separate download (Documents & Data → Receipts & Attachments), limited to 31 days per download.
- For other business accounts that only export CSV or OFX, see which banks offer QuickBooks Web Connect downloads.
Sources
Read November 12, 2026: Mercury help center, Integrating with QuickBooks Online and Bulk-export statements, receipts, and CSVs.