What it means
An old credit on a customer account can come from an overpayment, a credit note or an agreed price adjustment, and before deciding whether to use or return it finance must know whether the ledger total matches the source transactions. Reconciliation establishes that bridge without deciding the customer's rights.
Start with the opening balance and list every posted movement in the period, matching credit notes to original invoices, applications to later invoices and refunds to verified payment records. Keep uncertain, disputed and promotional balances separate, because a credit is not automatically cash refundable, nor is an unapplied cash receipt the same as an invoice credit; Stripe distinguishes customer invoice credit balances from cash balance mechanics.
Follow the actual contract, ledger system and applicable rules before settling or writing off amounts. Report unmatched movements, stale source links and differences between the customer subledger and control account, since aging can prioritise old items but a recent difference can be urgent if a large refund was recorded twice, and record owner, evidence and resolution for every exception.
Set a reporting date and freeze the ledger snapshot, so a credit created after cutoff is not used to explain an earlier balance, and if a transaction was backdated keep both the effective and posting dates available for review. Work at the level of each source transaction where possible, because a net customer balance can hide two unrelated credits and an erroneous debit, and matching individual items helps identify whether a refund or application used the intended credit.
Check the sign convention in the system, since some ledgers show a credit as a negative number while operational screens describe the same amount as positive money available to the customer, and a sign error can turn a reconciliation into a false write-off recommendation. A partial application needs an allocation rule: if a $300 credit is applied $100 today and $200 later, the remaining amount and source date must remain traceable, and the origin age should not reset simply because the residual appeared on a new screen.
A bank refund should be matched to the specific approved credit and successful payment status, since a request sent to a processor is not the same as funds settled, and failed, pending and reversed refunds stay in exception status until their effect is known. Reconcile aggregate reports with the control account after customer-level review, because a balanced total can mask offsetting differences across customers.
Currency conversion, tax adjustments and migrated records may require separate explanations rather than a plug entry. When an exception remains, write down what is known and who will investigate without manufacturing an aging bucket, customer owner or expiry date, because a documented unresolved balance is better than a falsely clean report.
A customer may have several currencies on one account, so do not net them until the system and agreement permit conversion under a defined rate and date, as otherwise a balanced home-currency total can hide a live credit in one currency and an unpaid invoice in another. Look for duplicate source references, since a credit note imported twice can be offset by an unrelated debit and leave the account total apparently correct, so check document identity and approval alongside arithmetic.
After fixing a difference, record the posting and review date, and start the next reconciliation from the adjusted, approved closing balance while preserving the old exception and its resolution trail. A clean balance should be reproducible by another reviewer.
In practice
Real-world examples.
Example
A customer overpays an invoice by $250 and the surplus sits as a credit on its account. Finance traces the overpayment to the bank receipt, confirms it was not allocated elsewhere, and records the $250 in the roll-forward as a new eligible credit. The customer can then choose between application to a later invoice and a permitted refund.
Example
A distributor's opening credit balance for a customer is $1,000. During the month the roll-forward lists a $3,000 credit note, a $600 application to a later invoice and a $1,000 refund that has settled at the bank. A $1,000 refund that was only requested from the processor would stay in exception status until it settles.
Example
A subledger report shows 40 customers with credits, and its total agrees with the control account. Reviewing individual customers, finance finds one account with a $700 credit note imported twice and another with an unrelated $700 debit, which offset each other. The matching total had concealed two errors.
Formula
Calculation
Illustrative closing credit = Opening credit + New eligible credits - Valid applications - Settled refunds + or - documented corrections. A $1,000 opening credit plus $3,000 issued, less $600 applied and $1,000 refunded, leaves $2,400. Confirm signs and categories under the actual ledger.
Worked example. Using those figures, the roll-forward is $1,000 + $3,000 - $600 - $1,000 = $2,400, with no documented corrections.
- If the ledger also shows $2,400, the account reconciles and each movement is traced to its source document.
- If the ledger instead shows $2,900, there is an unexplained difference of $2,900 - $2,400 = $500.
- Investigation finds a $500 credit note imported twice, so the correction is -$500 with a documented reason, and the corrected ledger balance of $2,400 now matches the roll-forward.Case study
Seen in the real world.
This illustrative and entirely fictional example follows Harbor Tools, an invented supplier. Its ledger shows a $2,400 credit on a customer account, and finance builds a roll-forward from an opening balance of zero. It finds a $3,000 credit note and $600 applied to a later invoice, with no refund, so $3,000 - $600 = $2,400 and the balance is explained.
Staff then separately review whether the customer prefers application or a permitted refund, because reconciling the balance does not decide the customer's rights. The reviewer also records the sources, the reporting date and the owner so another person could reproduce the result. This fictional check does not authorise either action.
Watch out
Common mistakes.
- Netting unrelated cash and invoice credits without tracing the source.
- Treating a balanced total as proof every application was appropriate.
- Writing off an old credit because its owner cannot be found quickly.
Questions
People also ask.
How is reconciliation different from aging?
Reconciliation traces amounts and movements; aging groups unresolved credit by age.
Does a reconciled credit have to be refunded?
No. The proper treatment depends on the underlying rights, terms and applicable rules.
What if the totals agree but source records do not?
Keep the item open for review; matching totals can conceal offsetting errors.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%