Export from BillingMart to QuickBooks
Give your accountant your invoice lines and bill lines in QuickBooks Online's import layout, and every other record as a CSV file.
On this page
If your accountant keeps your books in QuickBooks, BillingMart can hand them your records as files. Invoice lines and bill lines can be written in the column layout of QuickBooks Online's own invoice and bill imports. Everything else comes as a plain CSV file. BillingMart does not connect to QuickBooks or sync with it: you download a file, and you or your accountant imports it.
What you can export
| Records | Layouts |
|---|---|
| Invoice lines | CSV, or QuickBooks Online invoice import |
| Bill lines | CSV, or QuickBooks Online bill import |
| Invoices, estimates, customer payments, the receivable ledger | CSV |
| Bills, bill payments (recorded), expenditure (bills and expenses) | CSV |
| Clients and vendors | CSV, as of the end date |
| Receivable ageing and payable ageing, one row per open invoice or bill | CSV, as of the end date |
Export a file
- Open Reports, then the Export tab.
- Under Records, choose what to export.
- Under Layout, choose CSV. For invoice lines or bill lines you can choose the QuickBooks Online layout instead.
- Choose a Month, or enter From and To dates.
- Select Run report, then download the file that appears. It shows how many rows it holds.
One file covers up to 366 days and holds up to 5,000 rows. When there are more, a warning says "More records than one export returns", so choose a shorter window for the rest. The export is available on plans that include the accounting export, and it covers the whole workspace.
What the QuickBooks layouts contain
- Invoice import: InvoiceNo, Customer, InvoiceDate, DueDate, ItemDescription, ItemQuantity, ItemRate, ItemAmount, ItemTaxAmount and Currency, one row per invoice line, with US dates.
- Bill import: BillNo, Vendor, BillDate, DueDate, Memo, Account, LineDescription, LineAmount, LineTaxAmount and Currency, one row per bill line, with US dates.
A bill's category is written in the Account column as text. Your accountant maps it to an account in QuickBooks.
Customer payments have no QuickBooks layout, because QuickBooks Online has no payments file import. They come as a plain CSV.
Note: The QuickBooks layouts follow the column names of QuickBooks Online's import templates. They have not been tried in a live QuickBooks company. Match the columns on QuickBooks' import screen and check the first import before you rely on it.
Amounts and currencies
Every row carries its currency, and no total mixes currencies. Amounts are exact decimals. Text that starts with a formula character such as = or + gets a leading apostrophe, so a spreadsheet shows it as text.
From the API or an assistant
Plans that include API access can read the same records as rows, without the QuickBooks layout, from the accounting export in the REST API or the accounting_export tool of the MCP server.
Related articles
- Move from QuickBooks to BillingMartExport customers, products and open invoices from QuickBooks Online or Desktop, import them, confirm your clients and send your first statements.
- Client statementsShow one client's account for a month or a year, download or email it, where customers read it in the portal, and why a statement is held back.
Still need help? Contact us
Tell us what you were trying to do, and the BillingMart team will take it from there.