How to Reconcile Supplier Statements in QuickBooks Online

Can you use the Reconcile screen for a supplier statement?

Reconcile and a supplier statement check are different jobs. The Reconcile tool in QuickBooks asks you to pick a bank or credit card account, then enter the ending balance and ending date from the bank’s statement. You tick off transactions until the difference is zero. Intuit’s help page for it is written entirely around bank and card statements.

A supplier statement answers a different question. It is the supplier’s own record of what you owe them, so what you are checking is your payables balance for that one supplier, not your bank balance. Reconcile has no way to do that.

People ask whether there is a report they have missed. In February 2021 an Intuit moderator answered the same question with "we’re unable to create a vendor statement" and suggested the Transaction List by Vendor report instead. We haven’t found a newer Intuit page that says different (last looked 30 October 2026).

Intuit also describes a newer reconciliation workflow that is included on some plans. It is described for bank statements, and nothing in the help applies it to supplier statements.

What you need before you start

You need the statement, its date, its closing balance and access to Reports in QuickBooks. Take the date from the printed page, not the email. Statements often arrive days after their date, and your report has to be run as at the printed one.

Statements come in three layouts, and the layout changes what counts as a problem.

The worked example later on uses an open-item statement. If you want the definitions, the glossary explains an open item statement in a paragraph.

Pull every QuickBooks number as at the statement date, whatever else you do. Run the report for today and any bill entered since will send you chasing a gap that does not exist.

Step 1: Which QuickBooks report do you run for the statement date?

Start with Vendor Balance Detail. It lists each open bill and credit for each vendor, with an open balance column. In the current Intuit help the route is Reports, then Standard reports. Type "balance detail" in the search bar and pick the report. Set the date to the statement date, filter to the one supplier, and run it.

To export the result, use the Export dropdown on the report and choose Export to Excel or Export to PDF. You will want Excel. Sorting by reference is the quickest way to line the two documents up.

If Vendor Balance Detail is not what you want, a second report gives you the activity view. Transaction List by Vendor shows each bill, payment and credit as its own row over a date range, which is closer to the shape of a balance-forward statement. The steps below come from Intuit Community answers: open Reports, find Transaction List by Vendor, group by vendor, then filter the supplier and dates.

Bills and the vendor reports are not on every plan. Check Intuit’s plan comparison for yours.

Aged payables is the report people often run instead, and it does not replace this check. It shows what is overdue, which is a different question from whether the supplier agrees. Aged payables is called aged creditors in some countries; the glossary entry covers both.

Step 2: Compare the two totals and write the gap down

The gap is the supplier’s closing balance minus the QuickBooks balance, both as at the statement date. Write it down with its sign. A negative gap means QuickBooks says you owe more than the supplier does. A positive gap means the reverse.

Decide your tolerance before you start. Many teams let a gap of a few cents go if it is rounding on a foreign-currency or tax line, and chase anything bigger. That threshold is your own policy, not a QuickBooks setting, so write it at the top of the working page.

The table below shows one way to set the bands. The amounts are examples only, so replace them with your own.

A matching total proves less than it looks. Here is an account where both sides come to 4,634.15 and two lines are still wrong.

The supplier raised an invoice for 598.30 and later credited the same amount. You recorded neither, so the totals agree while QuickBooks is wrong twice. If the invoice was a genuine charge that the credit note cancelled, no harm done. If the credit was for something else, such as a return or a price dispute, you will want the paperwork. The total will not tell you.

Step 3: Check every line, not just the total

Match on the supplier’s invoice number first, then the date, then the amount, and only call it a match when all three agree. Don’t match on amount alone. A duplicate bill carries the same amount as the original, so you would tick both and never notice.

This only works if the supplier’s invoice number is in the bill number field when you enter the bill. Many people type their own sequence there and then cannot find anything later. Put the supplier’s number in every time and next month’s matching is mostly sorting. The rule for two candidates that both fit is in how statement lines are matched.

1. 1

   Export the report and put the statement beside it

   Two columns of references, sorted the same way. A spreadsheet is fine, and so is a printout and a pen.

2. 2

   Tick each pair that agrees on reference, date and amount

   Use one colour for matched lines. Do not tick a pair that agrees on amount only.

3. 3

   Sort what is left into three piles

   On the statement only. In QuickBooks only. On both, but different. Every untouched line is one of these.

4. 4

   Give each leftover a cause and an owner

   Write the cause next to the line. If you cannot name one, you have not finished.

Payments are the awkward case. A payment you made on the 29th may show on your report and not on the statement, because some suppliers post a payment only when the money reaches their bank. A payment still in transit is the supplier’s to apply, not an error on your side. Check the date it cleared in your bank feed before you decide whose side is wrong.

Steps 1 to 3 on one statement: a $962.75 gap and five problems

Tidewater Coffee Roasters buys from Larkfield Restaurant Supply. Both are made up for this page. Larkfield’s statement is dated 30 September 2026 and closes at $8,166.35. Tidewater’s Vendor Balance Detail for the same date shows $9,129.10. QuickBooks is higher by $962.75, so the gap, statement minus QuickBooks, is −962.75.

Here is the statement. Three lines carry a marker because nothing in QuickBooks matches them.

The statement is an open-item layout, so there is no opening balance. The balance column is a running total of what is still open. Now the line-by-line check, where the QuickBooks column is Vendor Balance Detail as at 30 September.

Four lines tick cleanly. Five do not. Three are on the statement only (LF-2198, LF-2203, LF-C071) and two are in QuickBooks only (the second LF-2236, which is why that reference appears twice in the QuickBooks column, and LF-2255). To prove those five explain the gap, walk from the QuickBooks balance to the statement balance one item at a time. If you end anywhere else, a cause is still missing.

Three items push QuickBooks above the statement by $3,342.35 (the duplicate, the timing difference and the credit note). Two push it the other way by $2,379.60 (the bill never entered and the payment still listed). They net to $962.75. Had you only looked at the total, you would have gone hunting for one invoice of $962.75 that does not exist.

The free template lays this out in columns, with a cause for each line. The academy has more worked examples to practise on.

What do you do about each difference, and who does it?

Three of the five differences in the example are yours to fix, one belongs to the supplier, and one belongs to nobody because it fixes itself.

When both sides carry the same reference but different amounts, look at the size of the difference. If it equals a tax line, suspect a tax split. If it is a few cents, suspect rounding. If every line is out by the same ratio, suspect currency. In each case you check the invoice against your bill before you write to anyone. The academy cheat sheet lists all the exception types on one page.

A reconciliation is easier to rely on later if the working page is kept with it. Save the Vendor Balance Detail report as run on the statement date, the statement itself, the list of differences with a cause and an owner for each, and the name and date of whoever prepared and whoever checked it. Treat a difference as material when it is large enough to change what you pay or what you report, and set that amount for each supplier at the top of the page with the tolerance rule. How long to keep the file is set by your own record retention policy and local rules, so check those rather than copying a period from a guide.

Once the fixes are made, both sides should land on the same figure. Here is where the example ends up.

You cannot edit the supplier’s statement. The adjustment on that row shows what it will say once they apply your payment and issue LF-2255 on 2 October. Both items clear by themselves, so you correct nothing.

Step 4: Fix your side inside QuickBooks

If a line puzzles you, run it through the flow below. The questions are the ones the example answered.

Enter a missing bill

Intuit’s current help starts new transactions from + Create. Older answers call it + New, and Intuit is mid-rename, so use whichever your screen shows. Choose Bill (this step comes from Intuit Community answers), pick the vendor and put the supplier’s invoice number in the bill number field. Date the bill as the supplier dated it. If you use today’s date it lands in the wrong month and the report won’t agree with the statement.

Record a credit note (a vendor credit) and apply it

Entering a vendor credit doesn’t apply it, and people miss that. Step one: + Create, then Vendor credit. Pick the vendor, add the category or item details and save. Step two: + Create, then Pay bills, select the bill and look for Credit Applied showing the amount you expect before you save.

From Intuit’s help: a credit applied to one bill is not available for another, and a credit that covers the whole bill produces a payment of 0.00 and marks the bill paid.

Open vendor credits show up in Vendor Balance Detail, so look there before each payment run if the supplier sends credit notes often. If a credit note really is missing from your records, missing credit notes and duplicate payments covers the chase.

When the supplier refunds in cash

If you overpaid and the supplier sends the money back, the credit and the refund have to be linked. Intuit’s method:

1. Create the vendor credit.
2. Create a bank deposit with the vendor as Received From and the account set to Accounts Payable (A/P).
3. Use Pay bills and select the deposit, so that Credit Applied equals it and the total payment is 0.00.

Intuit says you must select Accounts Payable (A/P) to link the deposit to the vendor credit. Leave it out and the deposit is not linked to the credit.

If you use QuickBooks Online outside the US

The UK and Australian editions use different words. A vendor credit is usually a supplier credit or credit note, and the report that does the same job as Vendor Balance Detail is called Supplier Balance Detail. Intuit’s list of reports for its international English help also names Transaction List by Supplier, Unpaid Bills and Accounts payable ageing detail. Menus and report names differ by edition, and we checked only the US menus, so search for the report by name.

VAT and GST also change the comparison. A supplier statement normally shows gross amounts, including tax, so compare it with a report that also shows gross. A few cents of rounding on tax lines is common and falls under your tolerance rule, not under an error to chase.

Delete a duplicate bill

Before you delete anything, open the second bill and see whether it has a payment against it. If it does, move that payment to the original bill first, or the payment is left with nothing to apply to. Then delete the extra bill. In the example that was the one entered on 27 August.

To stop it happening again, QuickBooks has a setting. Under Account and settings, Advanced, Other preferences, look for the warning about bill numbers already used for that vendor. In Intuit’s US Test Drive company on 31 October 2026 it read "Warn me if I enter a bill number that’s already been used for that vendor", and it was switched off. Intuit says advanced settings vary by region, so the label may differ in yours.

The payment that is in the wrong place

This is the one that makes totals agree and bills disagree. A payment was recorded, but against the wrong bill, or against none. The vendor’s total is right and the individual bills are wrong, so a total-only check passes.

Find it in Vendor Balance Detail. An old bill that you know you paid still shows open, and a newer bill shows partly paid. A common fix is to open the payment, remove the wrong bill, and apply it to the right one. If the bill was never entered at all, enter it first. Menus differ by edition, so start from Vendor Balance Detail and look for the payment in question.

The Automation settings under Account and settings, Advanced include automatic application of credits and debits. Intuit documents this setting for customer credit memos. Check what it does to your vendor credits on a test bill before relying on it.

Step 5: What do you ask the supplier?

Only two kinds of difference are the supplier’s to answer: a payment they have not applied, and a document you do not have. Send one line per item, not the whole reconciliation.

If the supplier says they never applied a payment, send the statement date, the invoice reference, the amount, the date you paid and the bank reference (or the remittance PDF). In the example that is LF-2198, $1,017.60, paid 29 September. Ask them to confirm it is applied, and to send a new statement if it went against the wrong invoice.

The wording for each case, including the allocation request, is in common supplier statement problems.

Step 6: Keep a record and decide how often to check

Keep one page per supplier per month. It needs the statement date and balance, the QuickBooks balance, the gap, each difference with its cause and owner, and the adjusted balances. Save it with the statement PDF. If an auditor or a new colleague asks why a number moved, the page answers it.

How often you do this is your decision; nothing in QuickBooks requires it. A reasonable pattern is monthly for the suppliers you spend the most with, and before a payment run for the rest. The month-end checklist sets out a full cadence if you want one.

For a statement of about 30 lines, plan on roughly 20 minutes per supplier. That figure is our own estimate, not a measurement, and it grows when there are many unmatched lines.

Keep these four items together for each supplier and month:

• The statement PDF, saved under its printed date.
• The QuickBooks report export, with the as-at date it was run for.
• Any email to or from the supplier about a difference.
• The working page, with the date you finished and who did it.

Before you close the working page, check these six things:

1. The report was run as at the printed statement date.
2. The gap is written down with its sign.
3. Every statement line is ticked or has a named cause.
4. Every QuickBooks-only line is ticked or has a named cause.
5. Each cause has an owner: you, the supplier, or nobody.
6. The adjusted balances agree, and the page is saved with the statement PDF.

What if the statement is too long to tick by hand?

One page for one supplier is a short job. A statement with 80 lines, or twenty suppliers on the same Friday, is not, and the temptation is to check the total and call it done.

We make Statement Zen, so weigh this section accordingly. A spreadsheet works fine until you have more statements than Fridays. After that you can forward the supplier’s PDF to Statement Zen and it does the matching. It reads QuickBooks Online read-only and the result shows in your dashboard. The page for QuickBooks says what it connects to, and pricing has its own page.

To judge it on a real statement before deciding, forward one and see the result.

Questions people ask

Sources

• Intuit: Reconcile an account in QuickBooks Online (updated 5 Aug 2026), read 30 Oct 2026
• Intuit Community: How can I get a supplier statement off QB (11 Feb 2021), read 30 Oct 2026
• Intuit: Print customer or vendor register and balance detail reports, read 30 Oct 2026
• Intuit: Run a report for vendor totals and export it, read 30 Oct 2026
• Intuit: Enter a vendor credit and refund, read 30 Oct 2026
• Intuit: Apply vendor credits when paying bills, read 30 Oct 2026
• Intuit: Set advanced account settings, read 30 Oct 2026

What changed

• 30 Oct 2026: First published. Menu names checked against Intuit help pages; not tested in a live QuickBooks Online company.
• 30 Oct 2026: Next check due 2026-11-30: Intuit is renaming + New to + Create, so menu names will be rechecked then. Added a supplier email template, a closing checklist, a tolerance rule and a note for non-US editions.
• 31 Oct 2026: Removed an unverified claim about how Accounts payable aging detail ages items. Added tables for tolerance bands, the six template columns and further exception types, a time estimate and a list of what to keep.
• 31 Oct 2026: Reworded the Accounts payable aging detail row to say we have not verified how it ages items. Added exception rows for a supplier under two vendor records, a bill held for approval and a supplier account on hold, and a paragraph on materiality and keeping the working page.
• 31 Oct 2026: The opening note now says the main menus were clicked through in Intuit’s Test Drive sample company on 31 October 2026.