Reconciliation

Supplier and Vendor Statement Reconciliation

Supplier and Vendor Statement Reconciliation

Hamilee Repasa

MCMS Physician Connect Partner and MyRepsoft

A simple guide to what it is, why it matters, and how it differs from other reconciliations.

Supplier statement reconciliation and vendor statement reconciliation usually mean the same thing: comparing a supplier statement with your accounts payable or ERP records and explaining the differences.


What is supplier or vendor statement reconciliation?

Reconciliation is the process of comparing two sets of records to confirm that they agree and to identify differences. In accounts payable, supplier or vendor statement reconciliation compares the statement received from a supplier with the company's AP ledger or ERP records.

The goal is not only to confirm the ending balance. It is to find the items that explain why the two records differ. Common exceptions include:

  • Invoices shown by the supplier but missing from the AP system

  • Credit notes that have not been recorded or applied

  • Payments that have not been matched correctly

  • Duplicate or inconsistent entries

  • Timing differences or disputed amounts


Why does it matter?

The ERP shows the company's internal record. The supplier statement shows the supplier's view. A difference between the two can point to a missing document, an unapplied credit, a payment issue, or a balance that needs investigation.

Regular reconciliation helps finance teams find these issues earlier, before they become supplier disputes, urgent payment requests, credit holds, or month-end surprises.


A simple reconciliation process


  1. Collect the records: Obtain the supplier statement and the related AP or ERP data for the same period.

  2. Compare the transactions: Match invoices, credits, payments, references, dates, and amounts.

  3. Separate matches from exceptions: Matched items need little attention. Unmatched or inconsistent items need review.

  4. Investigate and resolve: Confirm the cause, obtain missing documents, apply credits, correct records, or follow up with the supplier.

  5. Keep the evidence: Retain the reconciliation result and supporting documents for control, close, and audit purposes.


Different types of reconciliation

Reconciliation is used across finance. The records being compared change depending on the account or process.


Type
What is compared
Main purpose

Supplier / Vendor Statement

Supplier statement vs AP or ERP records

Find missing invoices, credits, payment issues, and balance differences.

Accounts Payable

AP subledger or aged payables vs the GL control account

Confirm that recorded liabilities are complete and agree to the general ledger.

Bank

Bank statement vs cash ledger

Explain deposits, payments, fees, timing differences, and errors.

Accounts Receivable

Customer balances, receipts, and supporting records

Confirm customer balances and identify unapplied cash or invoice differences.

Intercompany

Transactions and balances between related entities

Ensure both entities record the same intercompany activity.

Credit Card / Expense

Card statements vs receipts and expense records

Confirm business spending is recorded, supported, and coded correctly.

Inventory

Inventory records vs stock counts or supporting movement records

Identify quantity, valuation, or movement differences.

Balance Sheet / GL Account

GL balance vs supporting schedules or source records

Support month-end close and confirm that account balances are valid.


Where MyRepsoft fits

MyRepsoft focuses on supplier and vendor statement reconciliation. The platform compares supplier statements with AP or ERP records, moves matched items out of the way, and brings forward the exceptions that need finance review.

It can start as a standalone process using supplier statements and an AP export. Integration can follow later when the business is ready. This lets teams improve reconciliation without replacing the ERP.


Know what needs attention. Stay in control.

A good reconciliation process does not require finance to inspect every line. It should make the matched items clear and direct attention to the exceptions that need action.

Circle
Circle

Bring us the documents your current workflow struggles with.

See how MyRepsoft can extract, validate, reconcile and deliver usable results from a focused document sample.

Circle
Circle

Bring us the documents your current workflow struggles with.

See how MyRepsoft can extract, validate, reconcile and deliver usable results from a focused document sample.

Circle
Circle

Bring us the documents your current workflow struggles with.

See how MyRepsoft can extract, validate, reconcile and deliver usable results from a focused document sample.