Reconciling a Supplier Statement: From Invoices and Payments to an Approved Balance

Why are two similar balances not enough?

Supplier reconciliation is not a search for a number close to another number. It establishes that every transaction making up the balance is understood and supported. Your balance may coincidentally equal the supplier's despite a duplicate invoice offset by a duplicate payment. Alternatively, both records may temporarily be correct even though they differ because a transfer sent on the month's final day has not yet appeared with the supplier. A good reconciliation therefore produces matched entries, explained differences, and required actions, rather than simply a “balanced” checkmark.

Regular reconciliation reveals missing invoices, unallocated payments, returns awaiting credit notes, and disputed discounts. It also prevents payment decisions based on uncertain balances. Reviewing close to the transaction date makes supporting documents and the people involved easier to find.

Fix the scope before starting

Clearly identify the supplier, currency, period, and cutoff date. Do not compare a statement ending in June with an internal report containing July entries. Do not combine branches or currencies that the supplier presents in separate accounts. Identify the opening balance and whether it comes from a previously agreed reconciliation or still requires evidence.

The scope normally includes:

• The correct legal or trading name and any supplier account reference.
• The period from the first entry after the previous reconciliation to the current cutoff.
• The currency, with a separate worksheet for each currency.
• The branches or warehouses whose invoices are included.
• The preparer and the person authorized to review and approve.
• The point after which the report is fixed and must not receive silent additions.

Resolve an opening-balance difference first. Carrying an old discrepancy into each new period makes every month unclear and can turn a small mistake into a lasting dispute.

Assemble one document pack

Request a clear supplier statement showing dates, document numbers, descriptions, debit and credit amounts, and running balances. Prepare your own supplier ledger, purchase invoices, debit or credit notes, payment vouchers, bank transfer evidence, and purchase-return records. Scattered messages should not replace original documents.

Before comparing, check data quality. Are invoice numbers formatted consistently? Is a date the invoice issue date or receipt date? Does a payment amount include transfer fees or show the net amount received? Standardizing these details reduces false differences. Retain fixed copies of both reports, since generating an updated report later may produce a different result.

Create a useful matching key

A strong matching key combines transaction type, document number, currency, and amount. Date alone is insufficient: you may record an invoice when goods arrive while the supplier records it when issued. Where a clear number is absent, combine clues such as amount, nearby date, purchase-order number, and branch name. Mark the match as manual so it receives closer review.

Match entries before totals

Start with large, clear transactions and then examine repeated or similar ones. Give each row a status: matched, present only in our records, present only in the supplier's records, or present on both sides with different values. Keep matched rows in the worksheet to demonstrate the review's scope and prevent repeated work.

Review each movement according to its effect:

• A purchase invoice increases the amount owed after its number, accepted quantity, and value are verified.
• A payment reduces the payable and must belong to the correct supplier, treasury or bank account, and currency.
• A purchase return reduces the payable once its financial effect is accepted. Physical dispatch and the supplier's credit-note date may differ.
• A discount or adjustment reduces the balance only when approved by both parties, rather than based solely on a verbal promise.
• Shipping and transfer fees may be separate entries under the agreement and should not automatically be folded into the invoice.
• The opening balance is a previous result, not a flexible line for absorbing discrepancies.

After matching rows, rebuild the balance: opening amount plus invoices and other increases, minus payments, returns, and approved discounts. If that does not reproduce the closing balance, find the missing entry, reversed sign, or arithmetic error.

Classify a difference before adjusting it

Not every difference is an error, and not every difference justifies an entry. Classification determines the next action.

Timing difference

A valid transaction may not yet appear on the other side at the cutoff, such as a late-day transfer or a return received after statement issuance. Document it, carry it to the next reconciliation, and verify that it clears. A timing difference lasting more than one cycle deserves follow-up.

Missing document

The supplier may show an invoice absent from your records, or your ledger may show a payment the supplier has not allocated. Request the document or receipt evidence and confirm that it relates to your business before recording it. An invoice appearing on a statement does not alone prove that goods or services were accepted.

Different amount or currency

Check quantity, price, discount, applicable tax, fees, and the agreed exchange basis. Do not hide a currency difference with an arbitrary discount. Keep currencies separate and explain conversion differences under a clear accounting policy.

Duplicate or incorrect allocation

An invoice may be entered twice with differently formatted numbers. A payment may belong to a similarly named supplier or the wrong invoice. Correct the source after review and appropriate authorization, preserving the change history.

Worked example: monthly reconciliation

May starts with an approved balance of 180,000 owed to the supplier. Your records show three invoices of 70,000, 45,000, and 35,000, a bank payment of 100,000, and a return of 10,000. The internal closing balance is therefore 220,000.

The supplier's statement shows 230,000. All invoices and the payment match, but the return is missing because the supplier received the goods on the final day and has not issued a credit note. The 10,000 difference is documented timing, not a reason to record another return. Attach the delivery record, request the supplier's credit-note reference, and keep the item open until the next statement.

If the credit note remains absent next month, the item needs active follow-up rather than routine carryforward. If investigation instead shows that the goods never reached the supplier, establish their location and condition rather than automatically assuming the internal balance is correct. Explaining the difference matters more than forcing equality.

Controls that prevent recurring differences

Where practical, require the supplier invoice number and keep it unique within that supplier account. Link payments to transfer references and the invoices covered. Separate purchase recording from approval of large payments when staffing permits. Before changing an old entry, assess inventory, treasury, and reporting effects; fixing only the supplier balance can create a discrepancy elsewhere.

Track simple measures: open differences, age, value, and recurring type. Late invoices suggest a receiving-document problem. Unallocated payments suggest missing transfer notices or references. Improve the process generating discrepancies, not only the reconciliation worksheet.

Approval checklist

• Supplier, account, currency, and period match across reports.
• The opening balance links to an approved previous reconciliation.
• Each invoice, payment, and return has a traceable reference.
• Matched entries remain visible within the review scope.
• Every difference has a category, owner, action, and follow-up date.
• No adjustment lacks evidence or an approved explanation.
• Post-cutoff entries have been checked for timing differences.
• The closing balance has been recalculated from its components.
• Another person has reviewed large and exceptional items.
• Both statements, the worksheet, and approval date are retained.

A practical plan for one reconciliation cycle

Day 1: prepare the records

Choose the most significant supplier by balance or purchasing volume, establish the cutoff and currency, and standardize invoice and payment references. Do not begin with every supplier if the information is disorganized.

Day 2: match and document

Match rows, classify differences, and collect evidence. Correct confirmed errors under the appropriate authority. Leave disputed items open instead of concealing them in a general adjustment.

Day 3: approve and follow up

Recalculate, obtain independent review, and send the supplier a specific list of items needing a response. Schedule the next reconciliation and turn recurring causes into purchasing or payment-process improvements.

Frequently asked questions

How often should supplier accounts be reconciled?

Frequency depends on transaction volume and risk. Large balances or daily invoices benefit from monthly reconciliation, with critical items potentially reviewed weekly. Low-activity suppliers may be reviewed quarterly, as well as before a large payment or financial period close.

Should I record an invoice that appears only on the supplier statement?

Not before checking it. Request the invoice, connect it to a real order or receipt, confirm that it belongs to your business, and rule out recording under another number. The statement is a reason to investigate, not sufficient evidence by itself.

What if the supplier rejects a return I recorded?

Separate the physical stock event from the financial dispute. Establish where the goods are and whether they left, retaining return authorization and handover evidence. Keep the amount disputed until a credit note or documented agreement resolves it.

Can I post one entry for the difference?

Not merely to close the reconciliation. An adjustment requires a specific cause, evidence, and authority. Otherwise it hides a mistake that may recur next month. Find the entries making up the difference first.

Which balance should I use for payment scheduling?

Use the confirmed balance with disputed items separated and timing differences explained, then consider invoice due dates and terms. The overall balance does not necessarily equal the amount payable today.

Conclusion

Supplier reconciliation starts with a clear scope and reliable opening balance, compares every invoice, payment, and return, and ends with explained differences and assigned actions. Avoid cosmetic equality and adjustments that conceal missing evidence. A regular process produces a sound basis for payments, negotiation, and cash planning while showing how purchasing, receiving, and payment procedures can improve.