Guardian
Business intelligence
← Blog

How to Reconcile a Vendor Statement Against Your Payments

A vendor statement shows what they think you owe. Comparing it with your own records is the fastest way to catch overcharges, missing credits and unrecorded bills.

Your vendors keep their own record of what you owe. You keep yours. In a perfect world they match. In practice they drift apart, a little at a time, and the gap is where overcharges, missed credits and bills you have never seen can hide.

A vendor statement reconciliation is the routine of putting those two records side by side. It's one of the most useful checks in accounts payable, and many small businesses never do it.

What a vendor statement is

A statement of account is a summary from the vendor listing the invoices they've issued to you, the payments they've received, any credits, and the balance they believe you owe. It's different from an invoice, which covers a single purchase. The statement covers the whole relationship over a period.

Most established vendors can send one on request, often monthly. If a vendor doesn't send statements automatically, ask for one.

How to reconcile a statement, step by step

You need three things: the vendor's statement, your own record of that vendor's bills, and your record of payments to them.

1. Start with the statement's closing balance. This is the number the vendor expects you to pay. Write it down.

2. Tick off each statement line against your records. For every invoice on the statement, find the matching bill in your books. For every payment the vendor shows, find the matching payment in yours.

3. Sort what doesn't match into four groups.

  • On their statement, not in your books. An invoice you've never recorded. You may have lost it, or you may never have received it, or it may not be yours.
  • In your books, not on their statement. A bill you recorded that they don't list. It may not have been invoiced yet, or it may be filed under the wrong vendor.
  • Different amounts. Same invoice number, different totals. This is where price changes, errors and unauthorized extras show up.
  • A payment they haven't credited. You paid it, but their statement still shows the invoice as open. This is the one to resolve before paying again.

4. Check credits. If the vendor issued credit memos (also called credit notes), confirm they've been applied on both sides. A credit that exists on paper but has never been deducted from a payment is money you haven't recovered yet.

5. Explain the difference. Your closing balance and theirs should differ only by items you can name. Anything you can't explain gets a question to the vendor.

What to do with each kind of mismatch

  • Unrecorded invoice: ask the vendor for a copy and proof of delivery before paying or recording it.
  • Amount higher on their side: don't pay the difference until they explain what changed.
  • Amount lower on their side: your records may be overstated, or you may have paid more than they billed. Check the invoice.
  • Payment not credited: send proof of payment and ask them to credit it. If they can't find it, the payment may have gone to a wrong account, and the bank should be involved.
  • In your books but not on theirs: hold off paying until you've confirmed the bill is real and filed correctly.

How often to do it

Monthly is a sensible rhythm for your main vendors, and quarterly for the rest. If you only do one thing, reconcile the vendors you pay the most, because that's where mistakes cost the most.

Where this gets hard

The method is simple, but it's a lot of matching: every line on every statement against every bill and payment in your books. Doing it for ten vendors is a day's work, and it's easy to skip.

How Guardian reconciles vendor statements

You give Guardian your vendor bills and payments, and optionally a vendor's statement, as spreadsheet or CSV exports. Guardian compares them and raises findings for the same kinds of mismatch described above: an invoice on their statement that's missing from your books, an amount that's higher or lower than yours, a payment you made that their statement still shows as open, and a bill in your books that their statement doesn't list.

Each finding includes the amount, the records involved, the reason it was flagged, and what to do next. The checks are rules, not guesses, so the same files always give the same result, and you can see exactly why something was flagged.

See the kind of findings Guardian produces in the sample demo →

Guardian compares the records you give it. It doesn't contact your vendors, and it can't know about an invoice that appears in neither set of records. The follow-up with the vendor is still yours.

What this does not replace

FAQ

Can I do this without a vendor statement? Partly. You can still check your payments against your bills for duplicates and overpayments, but a statement lets you catch what the vendor thinks versus what you recorded.

What if the vendor won't send statements? Ask for an "account history" or "ledger" for a period you choose. Many will provide one even if they don't send them regularly.

Is this the same as a bank reconciliation? No. A bank reconciliation compares your books with your bank. A vendor statement reconciliation compares your books with a vendor's records.

How do I handle a vendor who bills in a different currency? Compare in the vendor's billing currency and keep the exchange-rate difference separate, so a currency change isn't mistaken for an overcharge.

Keep reading

See what Guardian can find

Walk through a sample business and see the kind of findings Guardian surfaces — no signup required.

Try the demo →
Related articles

How to Find Duplicate Payments in Your Business Accounts

Paying the same invoice twice is easy to do and easy to miss. Here is how to check your own records for duplicate payments, and what to do when you find one.

How to Find Duplicate Vendor Invoices and Overpaid Bills

The same invoice entered twice, or a bill paid for more than it was worth, quietly costs money. Here is how to find both in your own books and fix them.

How to Find Vendor Credits You Never Applied

A credit memo from a vendor is money you're owed, but it only helps if it's deducted. Here is how to find credits sitting unused in your records.