Skip to content
Docs/Reports

Export reports and the QuickBooks file

Download Deals, Payments, and Gross CSVs, and generate the balanced QuickBooks journal-entry file for your bookkeeper.

Who: Any signed-in team memberPlan: All plans

Reports has two kinds of export: plain CSV downloads (deals, payments, gross) that anyone signed in can pull, and the QuickBooks file — balanced double-entry journal entries — that Owners, Managers, and Accounting can hand to a bookkeeper.

Every export uses the date range you have selected at the top of Reports. Set the range first, then export.

Pick the date range first

The date range applies to every export. The picker lives in the toolbar at the top of every Reports tab.

  1. Go to Reports.
  2. Pick a preset: This month, Last month, Last 30 days, Last 90 days, Year to date, or All time.
  3. For a specific window, click Custom range, pick a start date, then an end date, and click Apply.

The range you choose shows up in the downloaded file name (for example deals_2026-06-01_to_2026-06-30.csv), so the file still makes sense later in your Downloads folder.

Export the CSV reports

These three CSV downloads each cover exactly the selected range. Deals CSV and Payments CSV live in the toolbar at the top (on every tab); Gross CSV is a section action on the Sales and Financial tabs, not in the toolbar.

  1. From any Reports tab, find the toolbar at the top.
  2. Click Deals CSV for every sold deal in the range (vehicle, customer, deal type, selling price, tax, doc fee, other fees, who sold it).
  3. Click Payments CSV for every deal payment in the range, including voided ones, for bank reconciliation.
  4. On the Sales tab (under Sales by make & model) or the Financial tab (under Gross by salesperson), click Gross CSV for per-vehicle front-end gross (selling price, acquisition cost, added costs, gross, margin %).

Deals CSV, Payments CSV, and Gross CSV are available to anyone signed in. The QuickBooks file below is restricted to Owner, Manager, and Accounting roles.

Generate the QuickBooks file

The QuickBooks export turns the period's financial activity — sold deals, COGS, down payments, BHPH principal and interest, and floor-plan interest — into balanced journal entries you import into QuickBooks.

  1. Set your date range (see above).
  2. Open the Financial tab.
  3. Scroll to the QuickBooks export section.
  4. Click Journal entries (CSV) to download the file.
  5. In QuickBooks, import the CSV and map the account names (Vehicle Sales Income, COGS — Vehicle, Sales Tax Payable, Notes Receivable — BHPH, and so on) to your own chart of accounts.

Rows that share a Journal No make up one journal entry, and every entry balances to the cent by design — if a balance ever broke, the export refuses to generate rather than hand QuickBooks a file it would reject.

This is a file export, not a live QuickBooks connection. There is no QuickBooks login or sync — you download the CSV and import it yourself. You can re-run the export any time for any range; nothing is sent to QuickBooks automatically.

The figures are for management books and your tax accountant — not audited GAAP statements. Sales are recognized on an accrual basis at the time of sale, and BHPH interest is counted as it is collected. Sales-tax remittance and opening balances are not included. Have your accountant adjust as needed.

Gross figures are front-end only (selling price minus acquisition and reconditioning cost). F&I / back-end income such as warranties, GAP, and finance reserve isn't tracked in the DMS, so it isn't in these reports or the QuickBooks file.

Are these files safe to open?

Yes. Every CSV this app produces is run through a formula-injection guard before download. A cell that begins with a spreadsheet formula trigger (=, +, -, @) is automatically neutralized, so a stray value typed into a vehicle field or imported from an auction sheet can't execute when you open the file. Genuine numbers like -500 are left untouched.

FAQ

Who can download the QuickBooks file?

Owners, Managers, and the Accounting role. The QuickBooks export section only appears on the Financial tab for those roles. The plain Deals CSV, Payments CSV, and Gross CSV are open to anyone signed in.

Does this connect to my QuickBooks account?

No. It produces an importable CSV of journal entries. There is no QuickBooks sign-in or automatic sync — you download the file and import it into QuickBooks (or send it to your bookkeeper).

My export came up short or empty — why?

The export only includes activity inside the selected date range. Widen the range (try All time) and check that the relevant deals are actually marked sold and that payments are recorded in that window.

Why isn't sales tax I owe, or my opening balances, in the QuickBooks file?

By design. The file covers deal-driven activity (sales, COGS, collections, BHPH and floor-plan interest). Sales-tax remittance and opening balances aren't part of it — set those up directly in QuickBooks with your accountant.

Which date format do the files use?

Dates are written as YYYY-MM-DD, and the file is UTF-8 with a byte-order mark so Excel on Windows opens names and special characters correctly without prompting.

Can I export a single custom period, like one quarter?

Yes. Click Custom range, pick the start and end dates, click Apply, then run any export. The download will cover exactly that window.