What Supplier statement reconciliation means, why it matters, and how finance teams control it in practice.
Comparing a supplier's statement of account with your payables ledger and explaining every difference.
Typical differences are payments in transit, credit notes you raised that the supplier has not yet recorded, and invoices on the statement that are missing from your ledger.
Statements reveal missing invoices, duplicate entries and unapplied credits before they become late payment charges or overpayments.
Reconcile key suppliers monthly, keep each type of difference on its own line instead of netting them, and log genuine queries for follow-up rather than writing them off as timing. Request statements directly from the supplier's accounts team, not from the person who placed the orders, and keep each reconciliation with its statement so the trail is complete.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
The Supplier Statement Reconciliation Template keeps payments in transit, credit notes not yet on the statement and statement items not yet in your ledger as three separate reconciling items, and logs genuine queries instead of netting them into one difference. Excel, no macros, one-time price.
All glossary terms · All reconciliations guides
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.