Reconcile a Customer Account Step by Step: Where to Begin

What does customer-account reconciliation mean?

Reconciliation compares the transactions and balance in your record with the customer's record or confirmed understanding for a defined period. The objective is to explain each difference, establish the correct entries and accept the resulting balance, rather than finding any way to make two totals agree.

You may need it when a customer disputes a balance, before following up a substantial amount, when closing a period, or after discovering an invoice or payment that was entered late. Regular reconciliation also prevents small differences from becoming a difficult backlog.

Do not begin with the closing balance alone

A common shortcut is to compare two final totals and search for one transaction equal to the difference. That can produce a plausible but incorrect explanation: several entries or different cutoff dates may be involved.

Begin at an established point in time and work forward. A sound reconciliation connects the opening balance to each subsequent event so that another authorized reviewer can follow the result.

Step one: define the account and period

Record the customer name, internal reference and period. Agree on the start and end dates and whether the final date includes the whole day or a particular cutoff time. Two records may legitimately show different balances if their cutoffs differ.

Separate branches, distinct accounts and currencies before comparing entries. Also state whether the review covers all activity or only specified invoices. Combining unrelated accounts in one table creates avoidable uncertainty.

Step two: gather the documents

Export your statement and request the customer's statement or transaction list. Gather supporting documents in an organized set rather than relying on isolated images in messages.

These may include:

• Current and previous account statements.
• Relevant invoices or sales orders.
• Receipt documents or transfer references.
• Return documents and credit notes.
• Approved discounts and adjustments.
• Correspondence confirming an amount or date.
• A previous statement accepted by both parties.

Use stable names or references for the documents. Do not accept an unidentified transfer image or a payment covering several accounts without establishing whose money it is and which entries it relates to.

Step three: establish the opening balance

Compare the opening figures at the same date. If they agree, record that starting point and proceed. If they differ, investigate the earlier period until you find the most recent agreed position.

An opening difference may involve an older omitted payment, an invoice not received by the other party, an unapproved return or a carry-forward error. Document the cause and correction. A general entry called ‘previous difference’ may conceal the issue rather than resolve it.

Step four: use a consistent comparison format

Arrange transactions in a common table with date, reference, type, description, amount and balance effect. Standardize date and currency formats, and distinguish increases from reductions.

Your customer invoice may appear as an increase in your receivable while the customer presents it as an amount payable to a supplier. Compare the economic meaning, not merely the names of the columns.

Step five: match confirmed transactions

Start with entries carrying clear references. Match each invoice by number, date and value, and each payment by reference, receipt date and amount. Mark the corresponding entries in both records.

The amount alone is insufficient because invoices and regular payments can share the same value. Reference, date and recipient also matter. Where dates differ because of transfer or entry timing, note that before treating the item as missing.

Useful classifications include:

• Fully matched.
• Present on both sides with a difference to explain.
• Present only in your record.
• Present only in the customer's record.
• Supporting documentation is incomplete.
• Awaiting approval or correction.

Step six: investigate differences by type

After setting aside matched entries, investigate the remaining items individually. Common causes involve timing, omission, value and account selection.

Timing differences

A transfer initiated on the final day may arrive the next day. Do not change dates arbitrarily. Apply the agreed cutoff and record the event in the appropriate period, with an explanatory note when needed.

An unrecorded transaction

The customer may have evidence of a payment missing from your record, or your invoice may be absent from theirs. Verify the document and the event, then enter the missing item through the authorized process.

A different amount

If the same invoice has different values, inspect the original document and any tax, discount or return components. A brief message alone is not a sufficient basis for changing a supported figure.

The wrong account

A payment may have been assigned to another customer or an invoice to the wrong branch. Correct the effect on the relevant accounts and preserve a reference explaining what happened.

A duplicate or canceled item

Check for double-entered invoices or receipts and for canceled transactions still affecting the balance. Keep a reviewable explanation of the correction rather than removing the history without context.

Step seven: require evidence for a correction

Each change needs a reason, supporting document or appropriate approval. For a claimed payment, verify receipt and the beneficiary. If a discount is requested to close the difference, treat that as a separate commercial decision; it does not prove that the previous record was wrong.

For each difference, document:

• The disputed transaction.
• The amount shown by each party.
• The documents reviewed.
• The identified cause.
• The required action.
• The person authorized to approve it.
• The correction date.
• The resulting balance.

A worked example with more than one cause

Suppose your statement opens with 1,200 dinars due from the customer. During the period you add invoices totaling 1,800 and record receipts of 900. Your closing balance is therefore 2,100 dinars.

The customer sends a record showing 1,750. The difference is 350, but looking for one invoice of 350 would miss the actual explanation. Comparing entries reveals:

• A payment of 200 made on the last day, supported by a verified transfer reference, has not been entered in your record.
• An approved credit note of 150 for returned goods was issued by sales but never applied to the account.
• The other invoices and payments match.

After verification, record the 200 receipt, reducing the balance from 2,100 to 1,900. Apply the documented credit note of 150, reducing it to 1,750. The difference is explained by two supported events, not an unexplained adjustment of 350. The credit note is not an additional cash receipt.

Step eight: generate a fresh statement

After corrections are approved, generate the new statement from the underlying account record. Do not manually edit the PDF to make its total look right while leaving the source account unchanged.

Check that the corrected entries and references appear, and that the opening figure, totals and final balance agree. Distinguish the new file with a date or version so that no one accidentally reviews the superseded statement.

Step nine: request explicit confirmation

Send the updated statement with a short explanation of the differences resolved. Ask the customer to confirm the balance through a specific date or identify any entry still disputed. Do not label the issue ‘resolved’ if the customer has not reviewed the result.

If disagreement remains, separate agreed entries from those still under investigation. It may be possible to confirm most of the account while one item stays open, avoiding a complete restart at every contact.

Retain the confirmation and the exact statement version reviewed. This provides a reliable starting point for the next reconciliation.

Prevent the same differences from recurring

Use reconciliation to improve the working process. Repeated missing receipts may indicate a problem in how transfer notifications reach the person entering payments. Repeated missing invoices may require a clearer document-delivery process.

Schedule regular reviews of active accounts. Give invoices, receipts and returns distinct references and record events promptly. The shorter the gap between an event and its review, the easier it is to locate the source and responsible person.

A reconciliation checklist

• Define the customer, account, currency and period.
• Agree on the data cutoff date and time.
• Gather both statements and supporting documents.
• Establish the last agreed opening balance.
• Standardize transaction formats and sign conventions.
• Match invoices by references, not just values.
• Verify payments against transfers or receipt documents.
• Separate returns, discounts and adjustments.
• Classify unmatched transactions.
• Check timing differences and wrong-account entries.
• Document each correction's reason and approval.
• Make corrections in the authoritative account record.
• Generate an updated statement rather than editing the PDF manually.
• Request confirmation of the balance and date.
• Retain the reconciliation and related documents.
• Address the working-process cause of recurring differences.

A supported result, not a compromise number

Customer-account reconciliation is an evidence-based review. Begin with a defined period and verified opening position, match transactions using references and documents, and resolve each difference according to its cause. After correcting the source account, issue a new statement and request confirmation. The resulting balance should be explainable and provide a dependable starting point for the next period.