Why compare at all
Bills get lost in the mail, entered twice or recorded for the wrong amount. Payments may be applied by the vendor to the wrong invoice. Credits can be forgotten. A statement is a quick way to spot all of these in one look.
It matters most for vendors with many invoices each month, such as suppliers, subcontractors and utilities.
Request and prepare
Ask key vendors for a monthly statement showing open invoices, payments and credits. Run your own vendor ledger or open bills report for the same date. Print or open both side by side.
Which report to run in QuickBooks Online, QuickBooks Desktop, Xero and construction software
QuickBooks Online has no reconcile button for vendors: its Reconcile tool is for bank and credit card accounts. Instead, run the Vendor Balance Detail report, or the A/P Aging Detail report dated the same day as the vendor's statement, and filter it to that vendor. The vendor's own page also lists every bill, payment and credit, which you can filter by date to match the statement period.
QuickBooks Desktop, including Enterprise, works the same way: there is no supplier statement matching tool, and Reconcile is for bank and card accounts only. Go to Reports, then Vendors & Payables, and run Vendor Balance Detail or Unpaid Bills Detail dated the statement date, filtered to the one vendor. The vendor's record in the Vendor Center shows the same bills, payments and credits if you would rather work from one screen.
In Xero, open the Aged Payables Detail report as at the statement date, or open the supplier's contact and review its activity. Bills paid in part show the remaining balance, which is the number to match.
Construction accounting systems, such as Vista by Viewpoint or Trimble Construction One, keep payables by vendor and often by job. Run the vendor's open items or payables history for the statement date, and remember that retainage held back on subcontractor invoices shows as owed on their statement but may sit in a separate retainage account in your books.
Whatever the software, the rule is the same: use a report dated the same day as the statement, for the same vendor, and match open items rather than running totals.
Match line by line
Tick off each invoice that appears on both. Note items on the statement that are not in your records, which might be missing bills. Note items in your records that the statement lacks, which might be unrecorded by the vendor or duplicates on your side.
Check amounts, dates and invoice numbers. A small difference may be a discount, a freight charge or a typo.
Resolve differences
For missing bills, request copies and enter them if valid. For duplicates, delete or void yours, or ask the vendor to correct. For payments not credited, send proof such as the check image or transfer confirmation. For disputed prices, compare with the quote or purchase order and ask for a credit memo.
Record the outcome in the bill notes and keep the email trail.
Watch credits and timing
Unapplied credits are money you are owed. Apply them to the next bill or request a refund. Also consider timing: a payment mailed late in the month may not show on the statement yet.
Reconcile the difference by listing items in transit, so the remaining gap is truly unexplained.
Do the full exercise monthly for your largest vendors and quarterly for the rest. Keep a short log of vendors reconciled and dates. Before year end, confirm balances with every vendor you owe a meaningful amount.
If your payables balance includes old amounts with no matching statement, investigate. They may be paid items entered wrongly or bills that should be written off with documentation. Your bookkeeper can handle the process if you send the statements.
A supplier statement lists an invoice you never entered, a payment you made last month that was not applied, and a credit for returned goods that has not been used. Your records, in turn, show one invoice entered twice. After sorting this out, you gain a missing bill to record, proof of payment to send, a credit to apply and a duplicate to remove. Four small fixes, found in ten minutes, that would otherwise appear as an argument months later.
Worked example with numbers
Your supplier sends a statement dated June 30 showing $4,860 owed. Your payables ledger for that vendor shows $4,310, so you are $550 apart. Match line by line. The statement lists invoice 2214 for $400, which you never entered because it was emailed to an old address. It also lists a $150 credit memo that the vendor created but has not applied against any invoice.
Enter invoice 2214, bringing your balance to $4,310 + $400 = $4,710. Ask the vendor to apply the $150 credit, bringing their figure to $4,860 - $150 = $4,710. Both sides now agree, and you have found $150 you would otherwise have overpaid. Save the statement and a note of what you changed with the month's records.
Mistakes that cost money
Paying the statement total without matching lines pays for invoices you may have already paid or never received. Ignoring unapplied credits leaves cash on the table. Forgetting payments in transit makes a gap look like an error when it is only timing: list those items so the remaining difference is real. Reconciling only when a vendor complains means errors age for months, and old disputes are harder to win.
Check your work
After reconciling, your vendor ledger balance should equal the vendor's statement balance, plus or minus a short list of items you can name and date. If the gap is unexplained, it is not reconciled yet.
Common questions
Do I need statements from every vendor?
Focus on those with frequent or large activity. Small one-off vendors can be skipped.
What if the vendor will not send statements?
Run your own ledger report and ask for an account summary on request.
Can a statement be wrong?
Yes. Statements are generated from the vendor's records, which have errors too.
This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation.
