How to reconcile supplier statements

Reconcile a supplier statement by confirming scope and period, tying balances and activity, standardizing comparable fields, separating exact evidence from review items, resolving exceptions, and retaining control totals plus a traceable workpaper.

Method last reviewed: 2026-08-22

1. Confirm the supplier and date range

Identify the supplier legal or master-data record, account number, statement date and AP cut-off. Confirm whether the AP export contains only that supplier or several suppliers. Do not begin matching until both files are intended to cover the same relationship and period.

2. Tie opening balance, period activity and closing balance

Where the statement provides balances, check the arithmetic from opening balance through invoices, credits, payments and closing balance. Independently tie the AP export to its source-system report total by currency. A row-level match cannot compensate for an incomplete export.

3. Standardize references, dates, amounts and currency

Keep invoice and credit references as text. Confirm date order, decimal and thousands separators, decimal places, parentheses or trailing-minus credits, and debit/credit direction. Preserve the original columns so every normalized value can be traced back to the source row.

4. Check unique exact matches

Start with unique one-to-one records that agree on the normalized reference, integer minor-unit amount and currency, subject to supplier and date safeguards. Duplicated keys must not be silently accepted. In SupplierRecon, only this narrow result class becomes an Exact match.

5. Review one-to-many, many-to-one and other candidates

A supplier invoice may be represented by several AP rows. Verify that every component belongs to the same supplier and currency, falls inside the period logic and sums to the statement amount. The current SupplierRecon engine can suggest one statement row to multiple AP rows; it does not automatically create many-statement-to-one-AP groups. Those cases require manual investigation outside the automatic grouping result.

6. Investigate missing invoices, credits, duplicates and timing

For each unmatched or warning item, return to the source system and supporting documents. Check posting status, supplier filters, unrecorded invoices, unapplied credits, duplicate imports, disputed items, tax or freight differences, and document-versus-posting dates. “Possible duplicate” and “possible unused credit” are review cues, not facts.

7. Complete control totals

By source and currency, confirm that valid plus excluded rows equal input rows, and that exact plus manually accepted plus unmatched rows equal valid rows. Confirm input amount equals matched, unmatched and excluded classifications. A zero classification difference proves coverage of loaded rows, not source completeness or accounting correctness.

8. Retain a reviewable workpaper

Keep source file, worksheet and row references; raw and normalized values; result code and rule version; candidates and evidence; reviewer decision, reason and note; exception category; control totals; and run parameters. Preserve the original source exports separately under your organization's retention policy.

9. Record matters requiring human judgment

Document unresolved supplier disputes, period cut-off, account coding, tax treatment, foreign-exchange handling, payment status and approvals. Exact matching does not validate invoice legitimacy, confirm the supplier balance, authorize payment or replace a qualified finance reviewer.