Skip to content
Help center home

Topics

Contact supportStart free

On billingmart.com

Help center

Getting started / Export from BillingMart to QuickBooks

Explore here

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.

Last updated Web
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

  1. Open Reports, then the Export tab.
  2. Under Records, choose what to export.
  3. Under Layout, choose CSV. For invoice lines or bill lines you can choose the QuickBooks Online layout instead.
  4. Choose a Month, or enter From and To dates.
  5. 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

Still need help? Contact us

Tell us what you were trying to do, and the BillingMart team will take it from there.