How do I reconcile a supplier statement with my records?

To reconcile a supplier statement, compare it with your own account for the same supplier and cutoff date. Match invoices, credits and payments by reference. Investigate every remaining difference, correct supported recording errors and track genuine timing items without entering them twice. Finish with an explained balance and the actual invoices still due.

A supplier statement can say $3,800 while your books say $2,400. Neither number wins because it appears on a more official-looking document. The useful answer lies in the transactions separating them.

Begin with the same account and cutoff

Confirm the supplier entity, customer account, currency and statement date. Compare that date with the balance in your own supplier ledger. Today's unpaid-invoice screen may contain transactions that did not exist at the statement cutoff.

Bring the previous reconciliation and its unresolved items. A missing credit does not stop being missing because a new statement arrived. Equally, an old outstanding payment should leave the list when appropriate evidence shows how it was settled.

ACCA's supplier-statement guidance explains that invoices, credits and payments connect the opening and closing balances. Differences can come from recording errors or timing. Use the statement to check your records, rather than treating its total as a fresh invoice.

Keep the documents behind the entries: accepted purchase terms, invoices, receiving evidence, credit notes and payment records. Matching two unsupported spreadsheet rows cannot establish that the underlying purchase was valid.

Open a fictional reconciliation

Here is an entirely fictional workshop reviewing one supplier account as of February 28, 2027. Both records begin with an agreed $3,200 owed. The amounts are complete amounts payable, with no additional tax, currency conversion, fees, discount or interest adjustments.

The workshop's ledger includes two new invoices, $1,200 and $800, an issued $300 supplier credit against an older invoice, and payments totaling $2,500. Its closing recorded liability is $2,400: $3,200 plus $2,000 invoices, less $300 credit and $2,500 payments.

The supplier statement includes the same opening balance and two invoices, plus another $600 invoice. It shows only $2,000 of payments and omits the issued $300 credit. Its closing figure is $3,800: $3,200 plus $2,600 invoices, less $2,000 payments.

The raw gap is $1,400. Booking an unexplained $1,400 charge would make the ledger match the statement while leaving the actual problems hidden. The workshop instead investigates the individual differences.

Investigate the missing invoice

The supplier provides the $600 invoice copy. It relates to a separately authorized order delivered and accepted on February 26. The workshop's order, receiving record and supplied terms establish the obligation. Its invoice copy had not reached the person maintaining the ledger.

This is a supported recording omission in the fictional branch. After appropriate accounting review, adding the $600 invoice to the supplier account raises the workshop's liability from $2,400 to $3,000.

The correction does not create another delivery or another payment. Preserve the invoice reference and original date so a later copy cannot enter as a second purchase. Keep the appropriate period and accounting treatment connected to the source records.

If the delivery had not been found or the charge did not match the terms, the supplier's appearance of confidence would not settle the question. Record it as unresolved and recover the actual evidence. Do not add an invoice merely to finish the reconciliation.

Trace the issued credit

The workshop has the supplier's issued $300 credit note, dated February 27 and referring to a specific older invoice. The supplier confirms that the credit is genuine but omitted from the statement. The workshop already recorded it correctly.

Subtracting $300 from the supplier-side comparison reduces $3,800 to $3,500. There is no second $300 credit to enter in the workshop's books.

Keep an actual issued credit separate from a credit the workshop has merely requested. Returning goods, complaining about a charge and receiving an accepted credit may be different stages. A requested allowance should not silently become a supplier-confirmed reduction.

Also distinguish a credit applied against what is owed from a cash refund. In this case, the credit reduces an old invoice; no refund is received. Adding $300 to bank cash as well as reducing the payable would invent a second benefit.

Follow the payment in transit

The workshop's $2,500 of payments consists of $2,000 already reflected by the supplier and a separate $500 payment debited from the workshop's bank on February 28. The latter has not reached the supplier statement by its cutoff.

The correct established destination and remittance reference have been verified in the fictional case. On March 2, the supplier confirms that the $500 reached and was applied to this same account. That later evidence explains the February timing difference; it does not rewrite the saved February statement.

Subtracting the $500 from the adjusted supplier-side comparison brings $3,500 to $3,000. The workshop already recorded that payment. Entering it again would reduce the ledger incorrectly to $2,500.

Calling an item in transit is not permission to leave it unexplained forever. Retain the original date and check what happens afterward. A rejected or misdirected payment needs a different resolution from one correctly received after the cutoff.

Bring the two sides together

Scroll horizontally if needed. Book corrections and statement-side reconciling items have different jobs.

The initial $1,400 difference is explained by $600 missing from the workshop's invoice records and $800 missing from the supplier-side statement comparison. The sides now agree without pretending every difference belonged in the same ledger.

This is one supplier reconciliation. It does not establish that every supplier account, the bank or the company's financial statements are correct. If the ledger correction affects broader accounting records, complete and verify the appropriate linked treatment.

Translate the balance into the payment plan

The fictional parties confirm that the remaining $3,000 comprises $400 on the older invoices after the payments and credit, plus invoices of $1,200, $800 and $600. All are due on March 15 under the supplied terms. There is no unresolved balance or agreed discount.

The workshop has $4,000 separately available for these payments after every other commitment. Its reconciliation work is funded separately: two available paid hours at $40 cost $80 against a $100 administrative allocation, leaving $20. Those hours cover record retrieval, comparison, supplier resolution and review, without unpaid owner work.

Paying the supported $3,000 through the normal approval process would leave $1,000 in the supplier-payment allocation. Paying the unreconciled $3,800 statement instead would leave $200 and send $800 more than this completed case requires.

The $800 consists of the already issued $300 credit and already recorded $500 payment. It is not a new supplier discount or a measured return on doing reconciliations. Nor would an overpayment automatically return as usable cash when another bill arrives.

Agreement on the balance does not authorize a new payment destination. If instructions change, apply the independent payment-destination check. Amount, authorization, destination and execution remain separate questions.

Test a payment that did not arrive

Consider a different branch in which the $500 payment is rejected and the bank returns it, rather than the supplier receiving it on March 2. The workshop must investigate and reverse the failed payment appropriately in its records.

Its corrected supplier liability becomes $3,500, not $3,000. The supplier-side amount after the genuine $300 credit is also $3,500. The return restores $500 to cash; it does not extinguish the supplier obligation.

Keep that branch separate from the completed-receipt case. Do not keep subtracting the $500 as an outstanding payment after evidence establishes that it failed. Conversely, do not resend it while the outcome remains uncertain without checking for duplicate-payment risk.

The bank-reconciliation guide follows cash-account timing and corrections. A supplier reconciliation follows what is owed to the supplier. A single payment can appear in both processes while answering different questions.

Match references, not just equal amounts

Two invoices can have the same value without being duplicates, and one payment can settle several invoices. Use the invoice references and allocation record rather than pairing entries because their amounts happen to match. Ask how a payment on account was applied before assuming a particular invoice is still unpaid.

Likewise, check the carried-forward balance against the previous agreed position. A current-month comparison can match every new invoice and still leave an old error inside the opening amount. Preserve the earlier exception list and evidence of its resolution; do not restart every statement as though the prior history were automatically settled.

When an amount was entered against the wrong supplier, correct the actual allocation through the appropriate review process. Do not create a second purchase on the right account while leaving the first one payable elsewhere. The correction needs to preserve the underlying transaction and remove the incorrect assignment.

Leave a short exception record

For each unmatched item, retain the reference, date, amount, explanation, supporting document, responsible person and next action. Separate a supported adjustment from a proposed one. Name the exact unresolved amount rather than allowing it to disappear into a matched-looking total.

If the supplier disagrees, preserve both positions and the relevant agreement. Resolve legitimate due payments through the actual process while the disputed portion is reviewed. Reconciliation arithmetic cannot decide an underlying contractual dispute.

The records-and-authority guide asks whether another person can follow what was agreed and what happened. A completed reconciliation should let a colleague identify the supported balance, outstanding questions and authorized next payment without reconstructing the whole month.