Reconciling Supplier Credits Against Vendor Statements

AP Automation
Vendor statements are the most direct way to surface credits the buyer is missing. Most AP teams either do not run the reconciliation or run it inconsistently.

A vendor statement is a periodic summary issued by a supplier showing every invoice billed, every payment received, every credit issued, and the resulting balance owed.

Comparing the vendor statement against the AP ledger surfaces discrepancies that almost never appear any other way. Invoices the buyer never received, payments that did not reach the vendor, credits the vendor issued that the buyer never posted.

The reconciliation discipline exists at most companies in theory, in vendor master setup or AP procedure documents. In practice, it is run inconsistently, often only for high spend vendors, and the findings are not always followed through to the root cause.

Why Vendor Statement Reconciliation Surfaces Missing Credits

Most credits go missing on the buyer side because they arrive through unstructured channels. The vendor, however, has the credit in their AR system from the moment they issue it. The vendor statement shows that credit unambiguously.

A buyer that compares the statement against the ledger will see a credit on the vendor side that does not have a matching credit on the buyer side. That gap is the recovery opportunity. Without the comparison, the gap remains invisible.

What a Good Reconciliation Looks Like

A vendor statement reconciliation is not just a balance match. The balances on both sides may match even when individual transactions do not. The reconciliation should compare at the transaction level, not the balance level.

Three way comparison

Match every invoice on the statement against an invoice on the ledger. Match every payment on the statement against a payment on the ledger. Match every credit on the statement against a credit on the ledger.

The differences fall into four categories: items on the statement not on the ledger, items on the ledger not on the statement, items on both with different amounts, and items on both with different dates that affect period reporting.

Frequency

High spend vendors warrant monthly reconciliation. Mid tier vendors quarterly. Smaller vendors annually or at year end only. The frequency choice should be informed by spend volume, not by which vendors are easiest to reconcile.

The Common Discrepancy Types

Most reconciliation findings fall into one of five categories. Knowing the categories helps prioritize follow up work.

Credits issued but not received or posted

The most valuable category for recovery purposes. The vendor has issued a credit, posted it to their AR, and reflected it on the statement. The buyer never received or posted the credit note. Follow up: request the credit note from the vendor, validate it, post it.

Invoices issued but not received

The vendor billed for a transaction that the buyer has no record of. This may be a legitimate invoice that was lost or sent to the wrong address, or it may be a billing error. Follow up: request the invoice, investigate the underlying transaction, determine whether to pay or dispute.

Payments made but not received

The buyer shows a payment that the vendor does not show as received. This typically indicates a remittance issue, payment to a wrong account, or a check that was never cashed. Follow up: investigate the payment trace and confirm with the vendor.

Amount discrepancies

Both sides show the transaction but at different amounts. This is often a partial payment that was treated as full settlement on one side, or a price adjustment that one side posted and the other did not. Follow up: identify which side has the correct amount and post the adjustment.

Timing differences

The same transaction appears on both sides but in different periods. This is usually a cutoff issue rather than a substantive problem, but it can mask other discrepancies and should be cleared in the reconciliation.

Where the Reconciliation Typically Breaks Down

Three failures account for most of the cases where reconciliation either does not happen or does not produce findings.

No process to request statements

Many vendors do not send monthly statements proactively. The buyer needs to request them, which means having a current contact at the vendor and a defined cadence. Without these, statements arrive sporadically or not at all.

Manual matching at scale is unrealistic

Reconciling a statement with hundreds of line items against an AP ledger manually is slow and error prone. Most teams that try end up matching only the highest dollar items and missing the smaller credits that often accumulate to more value.

Findings do not lead to action

The reconciliation surfaces findings, but the follow up on each finding (requesting credit notes, investigating missing invoices, escalating amount discrepancies) requires sustained effort that often does not happen. The findings list grows, ages, and eventually gets discarded.

Structuring the Reconciliation for Reliability

A reliable statement reconciliation discipline has four components.

  • A defined vendor segmentation that determines reconciliation frequency. The top 20 to 50 vendors by spend are usually monthly. The next tier is quarterly. Below a defined spend threshold, annual or year end only.
  • A standardized statement request process. Vendors are told the cadence and the format. Statements arrive at consistent points each period.
  • A consistent comparison methodology. Whether done manually or with tools, the comparison should be transaction level, not balance level, and should categorize findings the same way each time.
  • A findings follow up workflow. Each finding gets an owner and a target close date. Open findings get reviewed in the same cadence as the reconciliation itself.

Where Automation Changes the Equation

Statement reconciliation is one of the AP workflows most improved by automation. The matching work that takes hours manually can be done in minutes with software designed for the task.

What automation cannot do is handle the follow up. Once the reconciliation surfaces a list of unmatched items, those still require human action: contacting the vendor, requesting documents, validating findings, posting adjustments. The automation compresses the discovery step but does not eliminate the workflow.

The benefit of automation is mostly in expanding the scope. With manual reconciliation, most teams only review their top vendors. With automation, the reconciliation can run across the full vendor base, which is exactly where the long tail of small credits accumulates.

Start Here

Start with a single high spend vendor. Request a current statement. Run the reconciliation manually, comparing every transaction. The output will give you a clear picture of how many discrepancies exist for a vendor you might have assumed was clean.

If the first reconciliation produces meaningful findings, expand to the top ten vendors by spend. The pattern that emerges from that initial review usually justifies investing in either a structured manual process or a tool that scales the comparison across the full vendor base.

Krishna Srikanthan
Head of Growth

Table of contents

How efficient is your finance team?

Thank you! Please check your inbox.
Something went wrong while submitting the form. Please retry

See Finofo in Action

Please wait. Redirecting...
Oops! Something went wrong while submitting the form.
Watch a demo