Supplier statement reconciliation checklist

A repeatable checklist is what turns supplier statement reconciliation from an ad-hoc scramble into a reliable control. It keeps the process consistent across people and periods, makes hand-offs easy, and ensures nothing slips through before you pay. Use the checklist below each time you reconcile a supplier statement against your accounts-payable ledger — every item includes the why, not just the what.

How to use this checklist

Work top to bottom for each supplier, once per statement period. Treat it as a gate: do not release a supplier's payment until its reconciliation is complete and every exception is explained. Keep the completed checklist and working papers on file for audit and dispute history.

1. Preparation

• Confirm the period. Make sure the statement and your ledger cover the same date range, so timing differences are not mistaken for errors.
• Gather both documents. The supplier statement (PDF, Excel, or CSV) and your AP ledger / aged-payables report for that supplier.
• Normalise the data. Remove currency symbols and separators from amounts, and standardise invoice-number formats (leading zeros, prefixes, spacing).
• Have source documents handy. Purchase orders, goods-receipt notes, and payment records, so you can investigate without stopping.

2. Match the lines

• Match by invoice number. Pair each statement line with the corresponding entry in your ledger using the invoice number as the key.
• Compare amounts. Check the total on every matched invoice — small differences often hide tax or rounding issues.
• Flag statement-only invoices. Anything on the statement but not in your ledger.
• Flag ledger-only invoices. Anything in your ledger but not on the statement.

3. Investigate the exceptions

Every difference falls into one of these buckets. Work through each:

• Amount mismatches. Price, quantity, or tax differences — compare to the PO and original invoice.
• Duplicate invoices. The same invoice billed twice; the most expensive error if it reaches payment.
• Unapplied credit notes. Credits you are owed that have not been deducted.
• Invoices in dispute or on hold. Confirm status so they are not paid prematurely.
• Timing differences. An invoice or payment in transit between the two records — explainable, not an error.
• Unexpected or unrecognised charges. Anything you cannot tie to a PO or goods receipt — investigate for error or fraud.

4. Resolve and close

• Record missing invoices in your ledger before period close.
• Request corrections. Ask the supplier for a corrected invoice or credit note where they are at fault.
• Apply credits. Make sure owed credit notes are deducted against the right invoices.
• Document everything. Note each exception and its resolution for the audit trail.
• Sign off. Once every difference is explained, sign off the reconciliation and release payment.

Common mistakes to avoid

• Only reconciling big suppliers — small accounts hide errors and duplicates too.
• Reconciling after the payment run instead of before it.
• Forcing the totals to match instead of explaining each individual difference.
• Skipping documentation, so the same dispute is re-investigated next month.
• Ignoring timing differences and chasing the supplier over invoices simply in transit.

A simple monthly cadence

• Early in the month: collect supplier statements as they arrive.
• Mid-month: reconcile each statement against the ledger and log exceptions.
• Before the payment run: resolve exceptions, apply credits, and sign off.
• At close: confirm all valid invoices are recorded and file the working papers.

Automating the checklist

The matching and exception-finding steps (2 and 3) are exactly what software does best. VendorRecon takes the supplier statement and your ledger in any common format, matches every line automatically, and produces the exceptions list for you — so your team spends its time on investigation and resolution, not manual cross-referencing.

Frequently asked questions

How often should the checklist be run?

Most teams run it monthly, aligned to when suppliers issue statements and just before the payment run. High-volume or high-risk vendors may be reconciled more frequently.

Who should own the reconciliation checklist?

Typically an accounts-payable clerk or bookkeeper performs it, with a controller or owner reviewing exceptions and signing off.

What is the most important step?

Reconciling before the payment run. Catching duplicates and overcharges after you have already paid turns a quick fix into a slow recovery.

Do I need to reconcile every supplier?

Ideally yes — small suppliers hide errors too. At minimum, reconcile every supplier that sends a statement and all high-spend accounts each period.