Accounts Payable

Supplier Statement of Account Reconciliation: Steps and Automation

Every month, suppliers send statements which disagree with your books. This guide shows how to reconcile them quickly and stop the same breaks recurring.

Khushbu Adav

Product at Predflow

Supplier statement matched against the AP ledger with differences flagged

Every month, suppliers send statements which disagree with your books. This guide shows how to reconcile them quickly and stop the same breaks recurring.


Supplier statement matched against the AP ledger with differences flagged

A statement of account is a summary a supplier sends showing every invoice, payment and credit note on your account for a period, and the balance the supplier says you owe. Supplier statement reconciliation means comparing the statement line by line with your accounts payable ledger and explaining every difference.

The two rarely agree on the first pass. Invoices sit in transit and payments land after the statement date. Credit notes go missing, and the occasional invoice gets posted twice. This guide covers why statements and ledgers differ, the reconciliation steps, a worked example with the six common breaks, a month-end process for 50 to 500 suppliers, and how to automate the work.

Why Do Supplier Statements and Your AP Ledger Differ?

What is supplier statement of account reconciliation? Supplier statement reconciliation compares the statement a supplier sends with your accounts payable ledger, line by line, and explains every difference. Most differences come from invoices in transit, missing credit notes or duplicate postings, along with price differences. The goal is to fix real breaks before the next payment run.

Your supplier and your AP team record the same transactions at different times and from different documents.

  • Timing. The supplier records an invoice on the issue date. You record the invoice on receipt or after approval, sometimes weeks later.

  • Payments in transit. You record a payment on the transfer date. The supplier records the payment when the money arrives and gets allocated.

  • Credit notes. The supplier issues a credit note and shows the credit on the statement. Your team never received the credit note, or never posted the credit.

  • Errors. Duplicate postings, wrong amounts, invoices posted to the wrong supplier.

  • Disputes. You short-paid an invoice because of a price or quantity issue. The supplier still shows the full amount.

Every difference falls into one of two groups: timing, which clears on its own, and real breaks, which need action.

How Do You Reconcile a Supplier Statement of Account?

Follow the same order for every supplier.

  1. Agree the opening balance. Start from a balance both sides accepted, usually last month's reconciled closing balance. If the opening balance differs, fix the old difference first.

  2. Match invoices. Tick every invoice on the statement against your ledger by invoice number and amount.

  3. Match payments. Tick every payment by date, amount and reference.

  4. Match credit notes. Tick every credit note on both sides.

  5. Identify timing differences. List items on one side only, with dates near the statement date. Invoices in transit and payments in transit usually explain these.

  6. Investigate unexplained items. Everything left over is a real break. Give each one a cause and an owner.

The reconciliation is complete when the statement balance, adjusted for timing items and real breaks, equals your ledger balance.

Worked Example: Six Common Breaks

Supplier: Sample Packaging LLC. Statement date: 31 October 2026. Statement balance: AED 184,600. Your ledger balance: AED 142,350. Difference: AED 42,250.

Item

Statement

Your ledger

Difference (AED)

Cause

Action

INV-8812 dated 28 Oct

18,900

Not posted

18,900

Missing invoice, received by supplier email but not by AP

Request copy, post after approval

INV-8650

12,600

Posted twice, 25,200

-12,600

Duplicate posting from email and portal

Reverse the duplicate

Payment 25 Oct

Not shown

-30,000

30,000

Payment in transit, unapplied by supplier

Timing item, send remittance advice

CN-0412 for returned goods

-6,300

Not posted

-6,300

Credit note not received by AP

Request credit note, post after approval

INV-8701

22,050

21,000

1,050

Price difference, supplier billed old rate

Raise query, request credit note

INV-8590 in USD

11,300

11,000

300

FX difference on conversion

Agree rate, post FX adjustment

Total



31,350



The six items explain AED 31,350. AED 10,900 remains unexplained, and the next step is to request the supplier's detailed ledger for the period and match again. Reconciliation stops only when every dirham has a cause.

The six breaks in short:

  • Missing invoice: on the statement, not in your ledger.

  • Duplicate posting: in your ledger twice, once on the statement.

  • Unapplied payment: paid by you, not yet allocated by the supplier.

  • Credit note not received: on the statement, not in your ledger.

  • Price difference: both sides hold the invoice at different amounts.

  • FX difference: both sides convert at different rates.


Six Breaks in a Supplier Statement Reconciliation

The infographic above summarises the worked example table.

How Do You Reconcile 50 to 500 Suppliers at Month End?

Reconciling 500 statements by hand every month is not realistic, so prioritise.

Tier

Which suppliers

Frequency

Tier 1

Top suppliers by balance, usually 20 to 50, covering most of your spend

Every month

Tier 2

Suppliers with balances above a set value or with open disputes

Every month or every quarter

Tier 3

Small balances and inactive suppliers

Quarterly or at year end

Also prioritise by age. A difference older than 90 days usually means a real break, and old breaks get harder to resolve as people forget and documents get lost. Request statements on a fixed day each month, and chase suppliers who do not send them.

How Do You Automate Supplier Statement Reconciliation?

Statement reconciliation is repetitive and rule-based, a strong fit for an AI agent. Predflow builds agents to run the work on your ERP and email. A typical flow:

  1. Collect statements. The agent reads supplier statements from the AP inbox or supplier portals, in PDF or Excel, in Arabic or English.

  2. Extract lines. The agent pulls every invoice, payment and credit note line with dates, references and amounts.

  3. Match to the ledger. The agent matches each line to your AP ledger by reference, amount and date, with rules for partial references and rounding.

  4. Classify differences. The agent labels each unmatched item: timing, missing invoice, duplicate, unapplied payment, missing credit note, price difference or FX.

  5. Draft supplier queries. For each real break, the agent drafts an email to the supplier asking for the missing document or explaining the difference.

  6. Prepare adjustments. The agent prepares reversal or adjustment entries for your team to approve.

Your team reviews the classified differences and approves actions. The same approach works for marketplace payouts. See how one brand recovered 1 to 3% of marketplace revenue in our settlement reconciliation case.

Linking Reconciliation to Payment Runs

Do not pay against an unreconciled statement. A payment run built on an unreconciled ledger risks paying duplicates, paying invoices already credited, or missing invoices the supplier expects.

Set a simple rule: Tier 1 suppliers must have a reconciled statement for the previous month before their invoices enter the payment run. Exceptions need finance lead approval. The rule also gives suppliers a reason to send statements on time.

For the wider AP flow, read our guide to the accounts payable process. For the full procurement cycle, read our procurement process guide. Our goods received note guide covers the matching step where many statement breaks begin.

Getting Suppliers to Send Statements on Time

Reconciliation depends on statements arriving. Many suppliers send them late, in different formats, or only when chasing payment.

  • Ask for a fixed date. Request statements by the fifth working day of each month, in writing, from every Tier 1 supplier.

  • Ask for one format. Excel or CSV with invoice number, date, amount, payments and credit notes in separate columns saves more time than any PDF.

  • Use one inbox. Send all statements to a shared AP address, not to individual buyers.

  • Link to payment. Tell suppliers the payment run uses reconciled statements. Statements start arriving on time.

  • Request statements from portals. Some large suppliers publish statements on a portal. Download them on the same day each month.

Reconciliation Mistakes to Avoid

Mistake

Why the mistake hurts

Better practice

Reconciling only the closing balance

Hides offsetting errors

Match line by line

Ignoring small differences

Small items pile up into large write-offs

Set a threshold, but log every item below the threshold

Posting adjustments without documents

Weakens audit trail

Attach the supplier document or approval to every adjustment

Reconciling once a year

Old breaks become impossible to resolve

Monthly for Tier 1 suppliers

Leaving disputes with no owner

Disputes age past payment terms

Assign each dispute to a named person with a date

Supplier Statements Under E-Invoicing

E-invoicing from 2027 removes some causes of statement differences. When suppliers send invoices as structured data through their ASP, invoices stop getting lost in email, and typing errors on amounts disappear.

Other causes remain. Payments still land on different dates on each side, and disputes over price or quantity still lead to short payments. Suppliers below the AED 50 million threshold join e-invoicing only from July 2027.

Expect the mix of breaks to shift, with fewer missing and mistyped invoices while timing differences and disputes stay. Adjust your reconciliation rules after the first quarter of e-invoicing, and track which break types fall and which stay flat.

Using Reconciliation Results to Improve the Process

Each month's breaks tell you where your process leaks. Log the cause of every break in a simple register, then review the register every quarter.

Patterns show up quickly. Missing invoices from one supplier often point to a wrong email address. Duplicate postings usually point to invoices arriving by both email and portal.

Fix the cause behind the most common break first. One process change often removes a fifth of the monthly differences.

How Does Predflow Help With Statement Reconciliation?

Predflow is an AI agent development company. Predflow builds and runs AI agents for businesses in the UAE, India and the US, on the ERP and tools each business already uses, to save time and cost on repetitive work. Predflow builds reconciliation agents which match each statement line to your ledger and draft supplier queries for your team to approve. For a premium beauty brand, a Predflow reconciliation agent checks every marketplace payout within 48 hours of receipt. Read the settlement reconciliation case.

Conclusion

A supplier statement reconciliation compares the supplier's view of your account with your ledger and explains every difference. Start from an agreed opening balance and match every line. Separate timing items from real breaks, and give every break an owner.

Prioritise large balances and old differences, and link reconciliation to payment runs before you automate the matching. Your team then spends the month-end on resolving breaks, not on ticking lines.

Sources

Bring 5 supplier statements to a 30-minute reconciliation teardown

We will match your actual statements against your AP ledger on the call, find the breaks, and show you how an agent drafts the supplier queries. No prep beyond the statements and a ledger export.

Frequently Asked Questions

What is a statement of account?

A statement of account is a document a supplier sends to a customer listing invoices, payments and credit notes for a period, with the closing balance the supplier says the customer owes. Customers use the statement to check their own accounts payable records and find missing or wrong entries.

How often should supplier statements be reconciled?

Reconcile your largest suppliers every month, ideally before the month-end payment run. Reconcile medium suppliers monthly or quarterly, and small or inactive suppliers at least once a year. Reconcile any supplier with an open dispute every month until the dispute closes.

Who sends the statement of account?

The supplier sends the statement of account to the customer, usually monthly. If suppliers do not send statements on their own, your AP team should request them on a fixed day each month. Some suppliers publish statements on a supplier portal instead of by email.

What causes differences in supplier statement reconciliation?

The common causes are invoices not yet received or posted, duplicate postings, payments not yet allocated by the supplier, credit notes not received, price differences and FX conversion differences. Timing differences clear on their own, while the others need action.

Can supplier statement reconciliation be automated?

Yes. An AI agent reads statements in PDF or Excel and matches each line to your AP ledger. The agent then classifies the differences and drafts queries to suppliers. Your team reviews and approves. Automation works best when supplier and invoice references are consistent in your ledger.

What should we do if a supplier does not send a statement?

Request the statement in writing on a fixed day each month. If the supplier still does not send one, reconcile from your own ledger and send the supplier a list of open items to confirm. A confirmed open-items list serves the same purpose as a statement.

More on: