Mercury CSV to QuickBooks Desktop: exports, dates and QBO checks

Mercury documents CSV, XLSX and QuickBooks CSV exports. A QuickBooks CSV preset does not establish a downloadable Web Connect file.

Last checked: November 9, 2026

Choose between Mercury's transaction and monthly exports

Mercury's business export article lists ordinary CSV and XLSX downloads plus QuickBooks CSV and NetSuite CSV presets. For transaction activity, open Transactions, select Export all, or apply filters and select Export filtered, choose .csv or .xlsx, then Download. For a monthly software CSV, open Documents & Data, choose Statements and the account, then use the three-dot menu at the end of the statement row to select QuickBooks CSV or NetSuite CSV. Choose the route that matches the period you need, keeping the downloaded original before making any spreadsheet edits. A software name in this menu describes the CSV preset.

Keep attachment limits separate from transaction coverage

The Mercury article limits bulk attachment downloads to a 31-day range and gives the download link a 48-hour lifetime. Those are attachment-handling limits, not evidence that a transaction CSV can reach only 31 days into the past. The oldest CSV or XLSX transaction date and PDF statement retention are not documented on Mercury's public help pages we checked (Nov 2026) — check the Download/Export menu in online banking. Record the range actually returned by Export filtered. For a historical cleanup, compare that coverage with the months you need before assembling a larger import; a successful attachment download does not establish transaction completeness.

QuickBooks CSV and QuickBooks Online are separate evidence

Mercury documents a QuickBooks CSV that can be uploaded manually, and its integration article separately describes a QuickBooks Online account integration. Neither establishes that the website supplies a .qbo Web Connect download for Desktop. Such a download is not documented on Mercury's public help pages we checked (Nov 2026) — check the Download/Export menu in online banking. Confirm that your destination is Desktop before following an Online setup instruction. Preserve the .csv or .xlsx extension on the original download; renaming a QuickBooks CSV to .qbo would leave its underlying content unchanged and would not construct a Web Connect statement.

Prepare the downloaded records

Before importing another file, compare its transactions with entries already recorded in Desktop. CSVQBO cannot inspect your company file, and duplicate prevention must be checked in the destination software. Shared preparation checklist

Try a real free conversion See one-time packs FAQ

Written by Zijian Xiao; verify the Mercury sources and your original records before using an export.