QuickBooks
How to get a vendor statement out of QuickBooks Online
If you've been looking for a "send vendor statement" button in QuickBooks Online, you can stop looking — it doesn't exist. Intuit's own support moderators say so plainly in the community forums, where the question has been asked, and answered with workarounds, every year since 2020. The official suggestion is always the same: run the Transaction List by Vendor report and customise it.
That report is honest raw material, but it isn't a statement. What a supplier actually needs is every bill, credit note and payment in date order with a running balance and a stated closing figure — the same thing a proper supplier statement contains.
What QuickBooks Online gives you instead
| Report | What it shows | Why it isn't a statement |
|---|---|---|
| Transaction List by Vendor | Every transaction for one vendor over a period | No running balance; layout not meant for sending out |
| Aged Payables | Unpaid bills bucketed by age | What you owe and when — not the shared history |
| Vendor Balance Summary | Current balance per vendor | A snapshot, no detail, no narrative |
The gap between the first row and a real statement is the running balance and the sendable layout — exactly the part you rebuild in Excel every month. The two views also answer different questions, which is worth understanding before you reconcile.
Option 1: Transaction List by Vendor + Excel
The workaround most bookkeepers actually run:
- Run the report for the vendor and period, export to Excel.
- Sort by date; add Debit and Credit columns and sort bills vs payments into each.
- Add a Balance column with a running formula; verify the last row against the vendor's own statement.
- Format it until it looks like something you'd put your letterhead on.
It works, and it's free — but it's 15–30 minutes per vendor per month, and a mistyped formula is invisible until the vendor queries the number. If you do this once a year for one vendor, Excel is the right answer.
Option 2: Cloud reconciliation tools
AutoEntry and Dext both handle supplier statements as part of document processing. They work, and they automate the whole pipeline — in exchange for uploading your statements and ledgers to their servers. Pricing is by volume: AutoEntry bills monthly credits (about $13/month at the entry tier, with credits that expire), and Dext charges per document with a client minimum that small practices complain about. If you're already paying either for invoice capture, use what you're paying for.
If your constraint is client confidentiality — data that can't leave your machine — no cloud tool qualifies regardless of price. The full comparison is on its own page.
Option 3: Generate the statement locally, from the export
The middle path: keep the export you already have, skip the upload, skip the spreadsheet. The flow is the same Transaction List by Vendor export from option 1, minus all the manual steps:
- Drag the CSV or XLSX export into Statemint — nothing is uploaded; it's parsed in the browser tab.
- Confirm the column mapping once (Date, Type, Reference, Debit, Credit). The same export shape is remembered for next month.
- The statement comes out with the running balance, the closing figure, and a layout meant to be printed or saved as PDF.
The same engine also diffs your export against the statement the vendor sent you, which is usually the actual reason you need this at month end. Everything up to printing is free to try with your own files — the $29 early bird license ($39 regular) only unlocks printing and PDF export. No credits, no minimums, nothing that expires.
Which option fits you
- One vendor, once a year: Excel. Any tool is overkill.
- Already paying for AutoEntry or Dext: use what you're subscribed to.
- Monthly, multiple vendors, or confidentiality-constrained: that's the case Statemint was built for.