Vendor Reconciliation: How to Match the AP Ledger to the Supplier Statement

What is vendor reconciliation?

Vendor reconciliation is the process of matching the balance and open items in your accounts payable ledger for one supplier with the statement that supplier sends you, then explaining every difference. It is also called supplier reconciliation or supplier statement reconciliation.

The goal is not to make two numbers equal. The goal is to know why they differ: which items are only timing, which are disagreements with the supplier, and which are mistakes in your own books. Only the mistakes are corrected with journal entries.

Why vendor balances don't match

A supplier statement and your AP ledger record the same relationship from two sides and at different moments. Almost every difference falls into one of three groups:

• Timing differences. The supplier has invoiced goods you have received but not yet approved, or you have paid and the money has not reached the supplier before the statement date. These clear themselves.
• Open disputes. A return waiting for the supplier's credit note, a price the supplier charged above the purchase order, a short delivery. Neither side is wrong yet; the difference stays until the dispute is settled.
• Errors. A duplicated invoice, a payment allocated to the wrong supplier, a wrong amount keyed in. These are corrected in your books, or you ask the supplier to correct theirs.

The classification decides the action. Posting an entry for a timing difference creates a second error; ignoring an error because “it is probably timing” is how duplicate payments happen.

Vendor reconciliation process, step by step

1. Get the supplier statement for a clear cut-off date, ideally the month end you are closing.
2. Run your AP ledger for the same supplier and the same date: open invoices, credit notes and unapplied payments, not just the balance.
3. Match document by document using the supplier's invoice number, not your internal reference. Tick every item that appears on both sides with the same amount.
4. List what is left on each side: items only on the statement, items only in your ledger, and items on both sides with different amounts.
5. Classify each difference as timing, dispute or error, and record the cause.
6. Post only the error corrections in your ledger. Timing items get no entry; disputes get an owner and a follow-up date.
7. Prove the reconciliation: statement balance, minus and plus the listed differences, must equal your ledger balance to the cent.
8. Sign off and keep the worksheet with the statement, so the next month starts from known open items.

Vendor reconciliation example

At 30 September, Supplier S-104 sends a statement showing a balance of €48,600. Your AP ledger for the same supplier shows €41,350. The difference is €7,250. Matching the documents leaves five unmatched items:

The proof: €48,600 − €6,200 − €5,000 − €1,450 − €200 + €5,600 = €41,350, which is exactly the AP ledger balance. Every euro of the €7,250 difference now has a cause.

Only item 5 is an accounting error in your books. Items 1 and 2 will disappear on their own next month. Items 3 and 4 will not disappear by themselves: someone has to get the credit note and settle the price.

Journal entries for reconciliation differences

The entries below follow a common perpetual-inventory setup where a goods receipt credits a GRNI (goods received not invoiced) account and the supplier invoice clears it. Account names and the exact postings depend on your chart of accounts and ERP configuration.

Item 5: reverse the duplicated invoice

Reverse the second posting against the same account the original invoice cleared. Then check that the duplicate was not already paid: if it was, the reversal leaves a debit balance and you need a refund or an offset against the next invoice.

Item 1: post the invoice when the match is complete

This is not a reconciliation adjustment. It is the normal invoice posting, made when the invoice passes approval. Until then the €6,200 correctly sits in GRNI. Our guide to GRNI accounting explains that balance.

Item 4: if you accept the higher price

Whether the €200 goes to a variance account, to inventory or to cost of goods sold depends on the costing method and on how much of the stock is still on hand. See purchase price variance for the options.

Items 2 and 3: no entry now

The payment in transit is already in your books. The return was already recorded when you reduced the payable; when the supplier's credit note arrives, you match it to that return instead of posting it a second time.

Where the differences really start: receipts, returns and price holds

Look at the example again. Four of the five differences did not start in accounts payable. They started earlier in the purchasing flow:

• Goods received, invoice not yet approved. The receipt and the invoice travel separately. If nobody watches the GRNI balance per purchase order, these items pile up and look like supplier errors at month end.
• Returns without a credit note. The warehouse sends goods back, AP reduces the payable, and nobody chases the supplier's credit note. The difference then survives for months.
• Price and quantity differences. Three-way matching catches an invoice that does not agree with the purchase order and the receipt. Catching it is half the job; the other half is settling it with the supplier.
• Duplicates. The same invoice arrives by email and by post, or with a slightly different number. A hard check on supplier plus supplier invoice number stops the obvious cases.

That is why a clean purchase-to-pay process matters more than a faster reconciliation spreadsheet. When the receipt, the invoice, the return and the payment are linked documents, most differences are visible before the supplier statement arrives.

Vendor reconciliation format (template)

A reconciliation worksheet needs one row per unmatched item. These columns are enough for most companies:

Keep the worksheet with the statement. Next month, open items from this worksheet should appear first on the new one, so an old dispute cannot silently drop off.

How often to reconcile and what to automate

Reconcile your largest and most active suppliers every month, as part of the month-end close. Smaller suppliers can be reconciled quarterly or when they send a statement. Reconcile any supplier immediately when they chase a payment you believe you made.

Automation helps with the matching: comparing thousands of lines by document number and amount is exactly what software is good at. It does not settle disputes. The credit note still has to be requested, and the price difference still has to be agreed with the supplier. Automate the matching, and give the disputes an owner.

How Gruvero solves vendor reconciliation

Gruvero's operating core keeps accounts payable as linked documents, not as one balance per supplier. Every supplier invoice, credit note and payment carries its own open amount, so the reconciliation starts from a document list that already explains the balance:

• Open items per supplier document. Invoices, credit notes and payments are tracked individually with their open amount, so an unapplied payment or credit is visible instead of hidden in a net balance.
• Payments and credits allocated to specific invoices. A payment or credit note is offset against the invoice it settles, which keeps the supplier's document list and yours comparable line by line.
• Vendor statement report and AP aging per supplier, with CSV export, ready to compare with the statement the supplier sends.
• Duplicate invoices blocked. A second invoice with the same supplier and supplier invoice number is rejected, which stops the most expensive difference in the example before it is posted.
• Three-way matching before approval. The purchase order, goods receipt and supplier invoice are compared with quantity, price and amount tolerances; an invoice outside tolerance cannot go to approval.
• GRNI from the goods receipt. The receipt posts the goods-received-not-invoiced accrual and the matched invoice clears it, so an invoice in transit already has its counterpart in the ledger.

FAQ

What is vendor reconciliation in accounts payable?

It is the comparison of the AP ledger for one supplier with that supplier's statement at the same date. Every difference is explained as timing, an open dispute or an error, and only errors are corrected with journal entries.

What is the difference between vendor reconciliation and bank reconciliation?

Bank reconciliation compares your cash ledger with the bank statement. Vendor reconciliation compares your payable to one supplier with that supplier's statement. The method is the same; the documents are invoices, credit notes and payments instead of bank transactions.

Who performs vendor reconciliation?

Usually the accounts payable team, with a reviewer in finance signing off. Purchasing and the warehouse help settle disputes about prices, quantities and returns.

What if the supplier statement shows an invoice we never received?

Ask the supplier for a copy and check whether the goods or services were received. If they were, the invoice is a timing item until it is approved. If they were not, it is a dispute. Do not post an invoice just because it appears on a statement.

How should an old unapplied credit be handled?

Find the document it belongs to. A credit note should be allocated to the invoice it reduces; an overpayment should be offset against a future invoice or refunded. An unapplied credit that nobody can explain is itself a reconciliation item.

How often should vendor reconciliation be done?

Monthly for key and high-volume suppliers, as part of the close; quarterly or on request for the rest; and immediately when a supplier disputes a payment.

Conclusion

A €7,250 difference between a supplier statement and the AP ledger turned out to be five items: two timing differences, two open disputes and one duplicated invoice. Only the duplicate needed a correcting entry. The rest needed follow-up, and most of them started before accounts payable, in receipts, returns and price checks. When those documents are linked, the reconciliation stops being a monthly investigation and becomes a short confirmation.