--- title: "Vendor Statement Reconciliation in QuickBooks, Step by Step" description: "Match a supplier or vendor statement to your payables line by line: the report to run in QuickBooks Desktop, Online or Xero, plus a worked example." url: "https://mcc-solutionsnj.com/bookkeeping/guides/vendor-statement-reconciliation" --- Bookkeeping guide · Updated October 12, 2026 # Vendor Statement Reconciliation for Accounts Payable Your records show what you think you owe. The vendor's statement shows what they think you owe. Comparing the two finds mistakes on both sides before they become disputes or late fees. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** Compare the vendor's statement to your payables line by line to catch bills you never recorded, duplicates, misapplied payments and forgotten credits. Neither QuickBooks Desktop nor QuickBooks Online has a statement-matching tool: run Vendor Balance Detail (or Unpaid Bills Detail) for the statement date and tick off each item. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Trial balance explained](/bookkeeping/guides/trial-balance-explained) · [Owner contribution or loan](/bookkeeping/guides/owner-equity-and-capital-contributions) · [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings) **Free tools:** [Early payment discount calculator](/bookkeeping/early-payment-discount-calculator) · [How many sales do I need to break even?](/bookkeeping/break-even-calculator) Prefer a file to work in? The [Month-End Close Workbook](/toolkits/month-end-close-workbook) runs the whole close in Excel and tells you when a reconciliation does not tie. [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## 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. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online)[### Xero Bookkeeping and reconciliation in Xero for New Jersey small businesses, including cleanup and moving from spreadsheets or another program. Xero →](/bookkeeping/software/xero)[### Zoho Books Bookkeeping and reconciliation in Zoho Books for New Jersey businesses, especially those already using other Zoho apps. Zoho Books →](/bookkeeping/software/zoho-books) More guides - [Job Costing for Service Businesses and Contractors](/bookkeeping/guides/job-costing-for-service-businesses) - [Tracking Income Streams With Classes and Locations](/bookkeeping/guides/classes-and-locations-to-track-income-streams) - [Voiding vs Deleting Transactions in Accounting Software](/bookkeeping/guides/voiding-vs-deleting-transactions) - [How to Prepare Your Records for a Tax Preparer](/bookkeeping/guides/how-to-prepare-records-for-your-tax-preparer) Free tool - [Bookkeeping health check](/bookkeeping/health-check) Related - [Free vendor statement reconciliation template (Excel)](/bookkeeping/templates/vendor-statement-reconciliation-template) - [In QuickBooks Desktop and Enterprise](/bookkeeping/guides/vendor-statement-reconciliation-quickbooks-desktop) - [In MYOB AccountRight](/bookkeeping/guides/vendor-statement-reconciliation-myob-accountright) - [In MYOB Exo Business](/bookkeeping/guides/vendor-statement-reconciliation-myob-exo) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Month-End Close Workbook A real month-end close in one Excel file. It tells you when a rec does not tie, which variances still need an answer, and when the period is ready to lock. [See what's inside ($19)](/toolkits/month-end-close-workbook)14-day full refund Course: [Small Business Bookkeeping Basics](/courses/small-business-bookkeeping-basics) ($49) covers chart of accounts, reconciliations, the monthly close, payroll and 1099 basics for owners. It is training with a certificate of completion, not a credential. [![Cover of Bookkeeping Fundamentals (ebook) by Matthew Colt](/img/toolkits/bookkeeping-fundamentals-ebook/cover.webp)](/toolkits/bookkeeping-fundamentals-ebook) From the bookshelf ### Bookkeeping Fundamentals A college-level bookkeeping course, without the tuition. By Matthew Colt, $9.99 as an ebook (EPUB and PDF). [See the book](/toolkits/bookkeeping-fundamentals-ebook) [Read the first pages free](/toolkits/bookkeeping-fundamentals-ebook#free-starter) Free tool ### Vendor statement reconciliation template A free template to match a vendor's statement to the bills in your books. It runs in your browser and nothing you enter is saved. [Open the vendor statement reconciliation template](/bookkeeping/templates/vendor-statement-reconciliation-template) Reviewed by a person ### Books Health Review Send us one period of reports from QuickBooks, Xero or Excel. A person reads them and emails a written list of what to fix, in order. [See what is included ($129)](/bookkeeping/books-health-review) Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)