A receivable ageing report that excludes credit-balance customers needs a reconciliation to the complete customer ledger. Do not assume the report is the full control-account balance or offset unrelated customers to make the totals agree.

Accounting records, calculator and glasses on a desk
Illustrative photograph by Cht Gsml.

Read the report settings

Record the report date, currency, entity, customer scope and filters. Identify options that suppress credit balances, zero balances or unallocated receipts. Export the complete ledger for the same date and keep the original report unchanged.

A customer can have a net credit while still showing unpaid individual invoices. Review document allocation before interpreting that balance as a refund due. The cause may include an advance, overpayment, credit note or posting error.

Explain the omitted balances

Build a bridge from the ageing total to the receivables control account. List each omitted customer and the underlying documents. Match credits to receipts or approved credit notes and check whether cash has already been refunded.

For example, an ageing report shows S$50,000 due and suppresses customers totalling S$3,000 in credit. The difference should be explained as a separate component, not removed through a general write-off. Presentation and any permissible offset need the accountant's review.

Use the corrected view

Give collection staff the relevant unpaid invoices and dispute status rather than a misleading net list. Refer possible customer liabilities, allocation errors and refunds to the authorised owner. A report filter is not approval to issue a refund.

Keep the reconciled report, settings and approved adjustments in the month-end file. Reconcile again after posting corrections. This helps the company distinguish collection exposure from customer credits without losing the document-level evidence.

Related practical guidance

For the surrounding records and responsibilities, see bookkeeping basics, company records to keep, bookkeeping and accounting.

Official guidance: the relevant official guidance.

Help with your company records

For accounting, bookkeeping and related compliance support, contact Raffles Corporate Services at [email protected] or WhatsApp +65 8501 7133. Tell us which records or process need attention so we can discuss the relevant next steps.