Supplier Statement Reconciliation

Supplier statement reconciliation is the process of comparing a supplier's statement of account -- the list of invoices, payments, and balances the supplier says are outstanding -- against the corresponding records in the business's AP ledger. Discrepancies between the two records indicate errors, duplicate payments, disputed invoices, or potentially fraudulent transactions that have not been caught through normal AP processing.

Reconciliation is most commonly performed for high-value or high-volume suppliers where the financial exposure from undetected discrepancies is material. For a business with a supplier that issues 40 invoices per month at an average of AU$3,000 each, an undetected duplicate payment occurring twice per year represents AU$6,000 in overpayments that will not surface until someone compares what the supplier says they received against what the AP ledger says was paid.

What supplier statement reconciliation catches

The most common category of discrepancy found during reconciliation is timing differences: invoices recorded in the supplier's system but not yet processed in the business's AP ledger, or payments made by the business that have not yet been applied by the supplier. These are usually straightforward to resolve and represent normal settlement lag rather than error.

More significant discrepancies include invoices the supplier has never received payment for that appear as paid in the AP ledger -- which may indicate a fraudulent payment to a different bank account -- and invoices the supplier claims to have issued that do not appear in the AP ledger at all, which may indicate invoices lost in transit or suppressed by an internal employee to conceal a liability. Both categories require investigation rather than simple journal adjustments.

Duplicate payments are consistently surfaced through supplier statement reconciliation. The supplier's statement will show the invoice as appearing once on their records; the AP ledger will show two payments against it. If the excess payment has been applied to a future invoice by the supplier, the statement will show the credit; if not, a refund or offset needs to be arranged.

The reconciliation as a fraud detection tool

Regular supplier statement reconciliation is one of the most effective detective controls available to AP teams precisely because it uses an independent external data source -- the supplier's own records -- rather than relying solely on internal AP records that may have been manipulated. Ghost vendor schemes, phantom invoice fraud, and payment redirection fraud all require that the AP ledger show certain transactions. A fraudster who can manipulate internal records cannot manipulate what the real supplier shows on their statement.

For this reason, reconciliation should be part of the AP control framework for key suppliers, not merely a catch-up exercise when a supplier flags a discrepancy. A quarterly reconciliation schedule for top-20 suppliers by spend is a practical starting point. Monthly reconciliation for the top 5 provides stronger control for the highest-exposure relationships.

Running an effective reconciliation

An effective reconciliation process starts with the supplier statement, not with the AP ledger. The reconciler should work from what the supplier says they are owed and mark off each item against the AP record, rather than starting from internal records and looking for what is missing. This approach is harder to manipulate if an internal person is trying to conceal a discrepancy, because it forces engagement with the external data first.

Unreconciled items should be documented in a formal reconciliation workpaper that shows each discrepancy, its category, the investigation steps taken, and the resolution. This workpaper provides an audit trail that supports both internal controls testing and external audit review. Reconciliation items that cannot be resolved within a defined period -- typically 30 days -- should be escalated to the finance manager or CFO for review, regardless of their individual value, because unresolved reconciling items are a control weakness indicator regardless of their monetary amount.