Thred
All posts

Supplier statement reconciliation, step by step with a worked example

A packaging supplier says you owe €12,100.00, your ledger says €8,591.00. Here is how to walk that gap down to two queries, with the correcting journals and the email.

David van Duijn7 min read

Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.

Book a demo
On this page

A supplier statement reconciliation is the check that catches a wrong price, a disputed delivery or a double payment before it costs you money. You set the open items your supplier lists against the open items in your creditors ledger, account for every euro of the difference, and end with a short list of points to settle with the supplier.

If you are the finance lead or controller in a growing company, you know the symptoms of skipping it. A reminder for an invoice nobody has seen. A supplier who insists a price was agreed that you never agreed. A cost line that is a few hundred euros too high every month and nobody knows why. Each of those is cheaper to find in a monthly check than in a dispute.

Below is the method we recommend, followed by a complete example in euros where every number ties out.

What does a statement reconciliation catch?

Your creditors ledger only contains what reached your books, in the form it reached them. The statement shows the supplier's version. Comparing the two surfaces five kinds of problem, roughly in order of how much money they tend to cost.

  • Price and quantity differences. The invoice does not match the quote or the order. You booked what you agreed, the supplier kept what they charged, and the gap sits there until someone looks.
  • Disputed deliveries. Goods arrived damaged or short, you rejected the invoice, and the supplier never issued the credit note. On their side you are simply overdue.
  • Invoices approved but never booked. An invoice was approved in a purchasing or approval tool, but the hand-off to the ledger failed or was never set up. Your margins look better than they are until someone spots it.
  • The same invoice booked twice. A reminder or reissued copy carries a slightly different number, such as a suffix, and gets booked as a new invoice. Left alone, it gets paid twice.
  • Credit notes on one side only. The supplier issued a credit you never received, or you booked one they have not issued yet.

It is also one of the best month-end checks you have. If statements from your ten largest suppliers reconcile, your creditors balance is very likely right.

Which suppliers should you reconcile, and how often?

Not all of them. Rank suppliers by spend and by risk, then pick:

  • The largest suppliers by annual spend, every month
  • Any supplier who sends reminders or has disputed items, every month until clean
  • Suppliers with many small invoices, such as logistics, packaging or contractors, monthly or quarterly
  • Everyone else, at year-end before the books close

Many suppliers only send a statement when they are chasing you. For the ones on your list, request an overview of open items as at a fixed date every month, so you are working from the same cut-off each time. In Dutch this overview is often called a rekeningoverzicht or, when an auditor requests it formally, a saldobevestiging.

How do you reconcile a supplier statement, step by step?

  1. Fix the date. Run the supplier's account in your ledger at exactly the statement date. Comparing a 31 May statement with a 4 June ledger creates differences that are not real.
  2. Agree the opening point. If you reconciled last month, start from the agreed balance. If not, start from the oldest open item on either side.
  3. Tick the matches. Match invoices, credit notes and payments on both sides by document number and amount. Matching on number alone hides price differences.
  4. Sort what is left into three groups. Timing items, your errors and their errors or disputes.
  5. Correct your own side. Post missing invoices, reverse duplicates and fix wrong amounts in your ledger, with a note on each entry.
  6. Walk the gap down. Start from the total difference, take out the timing items, then take out your own corrections. What remains must equal, to the cent, the items you are querying.
  7. Send one query, not five. List every open point in one message with document numbers, amounts and what you need from them.

Step 6 is the one people skip. Without it, you have a list of differences. With it, you have proof that the list is complete.

A worked example: where does a €3,509.00 gap come from?

Your company buys boxes and pallet wrap from Verpakking Oost B.V., an invented supplier. Their statement at 31 May 2026 shows €12,100.00 owed. Your creditors ledger shows €8,591.00 for the same supplier on the same date. All amounts include 21% VAT.

The supplier's statement lists these open items:

  • Invoice V-2598, €3,025.00
  • Invoice V-2605, €726.00
  • Invoice V-2611, €2,541.00
  • Invoice V-2614, €1,936.00
  • Invoice V-2618, €968.00
  • Invoice V-2622, €1,815.00
  • Invoice V-2630, €1,331.00
  • Credit note CN-0112, −€242.00

Your ledger shows these open items:

  • Invoice V-2598, €3,025.00
  • Invoice V-2605, €726.00
  • Invoice V-2605-R, €726.00
  • Invoice V-2611, €2,420.00
  • Invoice V-2614, €1,936.00
  • Credit note CN-0112, −€242.00

Sorting the differences

Ticking leaves V-2598, V-2605, V-2614 and CN-0112 agreed on both sides. Five items remain, and we start with the two that cost money.

  • Price difference, €121.00. You agreed €2,000.00 plus VAT for V-2611 and booked that. The supplier invoiced €2,100.00 plus VAT. A query.
  • Disputed delivery, €968.00. One pallet on V-2618 arrived crushed and went back with the driver. You never booked the invoice, the supplier never credited it. A query.
  • Approved but not booked, €1,815.00. V-2622 was approved in your purchasing tool, but the sync to the ledger failed that week. Your error.
  • Reminder copy booked as a new invoice, €726.00. The supplier resent V-2605 as V-2605-R with a payment reminder, and it was booked a second time. Your error.
  • Goods not yet arrived, €1,331.00. The supplier invoiced V-2630 on 31 May for a delivery that arrives on 3 June. You book it on receipt. Timing.

Walking the gap down

Instead of adjusting two balances side by side, walk the single difference down until only the queries are left.

  • Statement €12,100.00 less ledger €8,591.00 leaves a gap of €3,509.00
  • Take out the timing item V-2630, −€1,331.00, which leaves €2,178.00
  • Post the missing V-2622, which raises your ledger and shrinks the gap by €1,815.00, leaving €363.00
  • Reverse the duplicate V-2605-R, which lowers your ledger and widens the gap by €726.00, leaving €1,089.00
  • Queries raised with the supplier, €121.00 + €968.00 = €1,089.00

The remainder equals the query list to the cent. Nothing is left unexplained.

Which journals do you post?

Only correct your own side. Never book the supplier's view of a disputed item just to make the balances agree.

Reverse the duplicate V-2605-R

  • Debit Accounts payable €726.00
  • Credit Packaging materials €600.00
  • Credit Input VAT €126.00

Book the unsynced invoice V-2622

  • Debit Packaging materials €1,500.00
  • Debit Input VAT €315.00
  • Credit Accounts payable €1,815.00

The VAT on V-2622 is deductible in the return for the period in which you hold the invoice. If the period of the invoice date is already filed, your accountant can tell you whether to include it in the current return or correct the earlier one. The reversed duplicate needs the same care: if its VAT was deducted in a filed return, it must come back out.

V-2630 needs no journal yet. You book it in June, when the goods arrive. The two queries also need no journal for now. If the supplier issues credit notes for V-2611 and V-2618, book those documents when they arrive.

What goes in the query to the supplier?

Keep it factual and complete, so one reply closes everything.

  • Your reference and the statement date
  • Invoice V-2611, quoted at €2,000.00 excluding VAT, with a request for a credit note of €121.00 or the approval behind the higher price
  • Invoice V-2618, one pallet returned damaged on delivery, with a request for a credit note of €968.00
  • A note that V-2605-R duplicates V-2605, so they can remove it from their reminders

Record the date you sent it. Next month, the reconciliation starts from the agreed balance plus whatever is still open from this list.

How do AI agents change supplier statement reconciliation?

The method is easy. The pain is collecting statements, extracting the lines from PDFs, matching dozens of documents and remembering what was queried last month. That is the reason most teams only do it at year-end, when the damage has already been done. Each of those steps is now work an agent can do.

  • Collect and read. Statements arrive by email in every layout imaginable. An agent picks them up from the finance inbox and reads the lines, whatever the format.
  • Match and sort. It ticks matches on number and amount, then sorts what is left. An invoice number with a suffix that matches an existing amount is a likely duplicate. A statement line with no booking behind it triggers a search of the approval tool and the connected mailboxes.
  • Walk the gap and prepare. It runs the walk from the example above, drafts the correcting journals for your approval and writes the query to the supplier with every open item listed.
  • Remember. Next month it starts from the agreed balance and checks whether last month's queries were answered.

You still decide what to accept and what to dispute. You stop doing the ticking.

This is the kind of work Thred's agents are built to take on. Supplier invoices are captured, checked against orders and contracts and routed for approval, and bank payments are matched as they come in, so the ledger side of the reconciliation is already clean. Because you can configure agents for any task that comes back every month, the statement check can become one of them, following your rules and surfacing only the exceptions that need a decision. With Thred Layer this runs on top of Exact Online or the ledger you already use, and the corrections flow back there. For an accounting firm, the same check can run across every client administration instead of only the ones with time left over.

If supplier statements only get reconciled when someone complains, book a demo and see the monthly version.

Frequently asked questions

Which suppliers should I reconcile every month?

Start with your largest suppliers by spend and any supplier with open disputes or reminders. Suppliers that send many small invoices can follow monthly or quarterly. Every other supplier with a balance should be checked at least once before the year-end close.

Why is a supplier's balance higher than the one in my ledger?

Usually because the supplier charged a different price than you booked, still shows an invoice you rejected, or sent an invoice that never made it into your ledger. Goods invoiced just before the statement date but delivered after it also widen the gap for a few days.

Should I book a disputed supplier invoice to make the balances agree?

No. Only correct errors on your own side. A disputed invoice stays out of your ledger until the dispute is settled, and you list it as an open item in the reconciliation and in your query to the supplier.

What is a saldobevestiging?

A saldobevestiging is a balance confirmation: a written statement of the balance between two parties on a given date. Auditors often request them from customers and suppliers at year-end. A supplier's regular account overview is usually called a rekeningoverzicht.

What happens to VAT when I reverse a duplicate purchase invoice?

The reversal removes the cost and the input VAT. If the duplicate VAT was already deducted in a filed return, it has to be corrected, either in the next return or through a correction of the earlier one depending on the amount. Check the right route with your accountant.

Sources

  1. Invoice requirements, Business.gov.nl
  2. Btw aftrekken, Belastingdienst
  3. Keeping business records, Business.gov.nl

Read next

Keep reading

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo