Blog

Supplier statement reconciliation in QuickBooks: Online and Desktop

How to reconcile a supplier's statement against the supplier balance in QuickBooks Online and QuickBooks Desktop: which reports to use, how to clear each difference, and a worked example.

2026-11-18 · Invoreg · 6 min read

Short answer: QuickBooks has no screen that reconciles a supplier statement, so you do it with reports. Run Supplier Balance Detail, or Accounts payable ageing detail, for the same period as the statement the supplier sent, then tick off every bill, credit and payment that appears on both. What is left is either a timing item, usually a payment the supplier has not applied yet, or an error to fix in QuickBooks or query with the supplier.

For the method with no software in mind, see supplier statement reconciliation, step by step. Report names below come from Intuit's help pages on 18 November 2026, and QuickBooks changes labels often.

The Reconcile tool does not do this

Worth clearing up first. Intuit's article on reconciling an account in QuickBooks Online covers bank and credit card accounts: you pick the account, enter the statement ending balance and date, and tick transactions "until the Difference is $0.00". There is no equivalent for accounts payable, and nothing in Intuit's help pages describes importing a supplier's statement and matching it automatically. So this is a report job plus a person, as it is for vendor statements in Zoho Books.

Which QuickBooks Online reports you need

QuickBooks says "supplier" in the UK, Ireland, Australia and Canada and "vendor" in the US. The reports are the same.

What you need Report in QuickBooks Online
Balance per supplier at a date Supplier Balance Summary
The transactions behind one supplier's balance Supplier Balance Detail
Unpaid amounts grouped by age Accounts payable ageing summary
Open items with invoice level detail Accounts payable ageing detail, or Unpaid Bills
Which payment settled which bill Bills and Applied Payments

QuickBooks Online is moving reports to a new engine, Modern view, in stages. Most exist in both views, but Bills and Applied Payments is Classic view only, so check which view the client's company is on.

How to reconcile a supplier statement in QuickBooks Online

  1. Fix the cut-off. Note the date on the supplier's statement and run every QuickBooks report to that same date. Many puzzling differences are just a date mismatch.
  2. Write down both closing balances and the difference between them.
  3. Run Supplier Balance Detail for that supplier, or Accounts payable ageing detail filtered to it, and export it to tick items off beside the statement.
  4. Tick off bills. A bill matches when the supplier's invoice number and the gross amount both agree. Check the number is in the Bill no. field, not buried in the memo, or nothing will match cleanly next month either.
  5. Tick off payments and credits. Payments by date and amount, credit notes against supplier credits.
  6. List the one-sided items. On the statement only: invoices never booked, credit notes never recorded, bills booked to the wrong supplier. In QuickBooks only: payments in transit and bills entered twice.
  7. Correct QuickBooks using the actions below, keeping a note of each correction.
  8. Query the rest with the supplier, for example a payment received but not allocated.
  9. Rerun the report and check the corrected balance plus the timing items equals the supplier's balance exactly. "Close enough" is how a duplicate survives to next month.

How to clear each difference

  • Invoice on the statement, no bill in QuickBooks. Ask the supplier for a copy and enter the bill from that copy. Never create a bill from the statement line: a statement is a list of invoices, not an invoice, and carries no VAT detail you can rely on.
  • Credit note on the statement, nothing in QuickBooks. Select + New, then Supplier credit, and enter it with the right category or item lines. To set it against a bill, create a Pay bills transaction and select the bill: QuickBooks applies the available credit automatically, and you check the Credit Applied figure before saving.
  • Bill entered twice. Remove the duplicate rather than journalling it out, so the invoice number appears once. Duplicates are the difference most likely to cost real money, because the second copy gets paid. How duplicate invoices happen and how to stop them covers the intake side.
  • Bill booked to the wrong supplier. Open the bill and change the supplier. This one shows up twice, as a missing invoice here and an unexplained balance on the other supplier's account.
  • Payment made but not on the statement. Timing, so list it and leave it. If it is more than a few days old, chase the allocation: unallocated payments are what put an account on stop while you have in fact paid.

QuickBooks Desktop: same job, different reports

Desktop keeps its payables reports under Reports > Vendors & Payables.

  • Unpaid Bills Detail lists what is open, but by default as at today, which is wrong for a statement dated the end of last month. Open Customize Report, go to Advanced, set Open Balance/Aging to the report date option, click OK, enter the statement date, then Memorize the report so the client file keeps it.
  • Vendor Balance Detail shows the transactions behind one vendor's balance. Select the vendor, highlight a bill credit and press Ctrl + H for its transaction history, which shows which payment or credit touched a bill.

Intuit has stopped selling new QuickBooks Desktop subscriptions in the US: the deadline for a new Pro Plus, Premier Plus, Mac Plus or Enhanced Payroll subscription was 30 September 2024, with Desktop Enterprise unaffected. Existing subscribers keep renewing and still receive updates and support, so these files are not going away, but new client work will be reconciled in QuickBooks Online.

A worked example

A supplier statement at 31 October shows £6,195. QuickBooks shows £3,920. The £2,275 difference is five separate things, not one.

What it is Where it appears Action Effect on the QuickBooks balance
Invoice 10412, £1,260, still sitting in an inbox Statement only Enter the bill from a copy of the invoice +£1,260
Credit note CN-118, £340, for a short delivery Statement only Enter a supplier credit and apply it in Pay bills −£340
Invoice 10388, £615, entered twice QuickBooks only Remove the duplicate bill −£615
Invoice 10401, £870, booked to a sister company's supplier record Statement only Move the bill to the right supplier +£870
Payment of £1,100 sent 29 October QuickBooks only None, timing none

The reconciliation then reads:

£
Balance in QuickBooks, 31 October 3,920
Add: invoice 10412 not entered 1,260
Less: credit note CN-118 not recorded (340)
Less: invoice 10388 duplicate (615)
Add: invoice 10401 under the wrong supplier 870
Corrected balance in QuickBooks 5,095
Add: payment in transit, 29 October 1,100
Balance per supplier statement 6,195

Without the reconciliation the client would have paid invoice 10388 twice, missed a £340 credit and let invoice 10412 run overdue. Invoice 10401 also overstated the sister company's balance by £870, so that statement would not have agreed either.

A monthly routine for firms

  • Run Supplier Balance Summary at month end and pick the accounts to reconcile: largest balances, weekly suppliers, anyone sending reminders.
  • Ask them for statements at the same date, so every cut-off is clean.
  • Reconcile the rest quarterly, and every supplier with a balance at year end.
  • Keep each reconciliation with its statement, so next month starts from the open items.
  • Put statements into the same queue as bills. The person entering a client's bills can spot a missing invoice in seconds, and the multi-client invoice workflow guide shows one way to organise that across clients.

Four of the five differences above started when a bill was entered, or was not. Fix the intake and statements start agreeing on their own.

Where Invoreg fits

Invoreg does not reconcile supplier statements. It works on the step that creates most of the differences: it reads every supplier invoice, including scans and phone photos, line by line with the VAT rate on each line, suggests the account and tax code from the client's history, checks for duplicates against the workspace and the bills already in the accounting software, and registers the bill only after a person approves it.

Zoho Books is the live connector today. The QuickBooks Online connector is planned, one to three weeks to build once scheduled, and for Desktop, which has no comparable cloud API, the route is an import file the software already accepts. Either way invoices arrive coded, de-duplicated and approved, which is what makes a statement agree: try it on your own invoices, the first 20 invoices are free.

Sources

  1. Intuit QuickBooks, Reconcile an account in QuickBooks Online, accessed 18 Nov 2026
  2. Intuit QuickBooks, List of QuickBooks Online reports available in Modern view (UK), accessed 18 Nov 2026
  3. Intuit QuickBooks, Enter supplier credits and refunds in QuickBooks Online (UK), accessed 18 Nov 2026
  4. Intuit QuickBooks, Customize vendor reports in QuickBooks Desktop, accessed 18 Nov 2026
  5. Intuit QuickBooks, Learn what the QuickBooks Desktop stop-sell means for your business, accessed 18 Nov 2026

Questions accountants ask

How do I reconcile supplier statements in QuickBooks?

Run a supplier report for the same period as the supplier's statement, in QuickBooks Online the Supplier Balance Detail or Accounts payable ageing detail, then tick off every bill, credit and payment that appears on both. What is left is either a timing item or an error to correct in QuickBooks or query with the supplier.

Can you reconcile a supplier account in QuickBooks Online?

Not with the Reconcile tool. Intuit's help article on reconciling an account covers bank and credit card accounts only, so a supplier account is reconciled by comparing reports with the statement rather than by ticking items in a reconciliation screen.

How do I reconcile supplier statements in QuickBooks Desktop?

Use Reports > Vendors & Payables > Unpaid Bills Detail and Vendor Balance Detail. Unpaid Bills Detail can be customised under Advanced, by setting Open Balance/Aging to the report date, so it shows what was open at the statement date rather than today.

Which QuickBooks report shows what I owe each supplier?

In QuickBooks Online, Supplier Balance Summary shows the balance per supplier, Supplier Balance Detail shows the transactions behind it, and Accounts payable ageing summary groups unpaid amounts by age. QuickBooks Desktop calls the same reports Vendor Balance Summary and Vendor Balance Detail.

How do I record a supplier credit note in QuickBooks Online?

Select + New, choose Supplier credit, pick the supplier and enter the category or item lines. To set it against a bill, create a Pay bills transaction and select the bill: QuickBooks applies the available credit automatically, and you check the Credit Applied amount before saving.