Back to the subscription dictionary

Accounts receivable overview

An accounts receivable overview shows outstanding customer balances at a specified date. It can separate not-yet-due balances from overdue items using non-overlapping ageing bands. It supports reconciliation and follow-up rather than guaranteeing when money will arrive.

Prepared with AIContent updated

A snapshot at a fixed date

State the report date, customer ID, invoice reference, due date, currency and open balance. Import and allocate receipts and credit notes through the same cut-off. A later receipt should not silently alter a historical report.

Where are outstanding balances concentrated?

Illustrative ageing at a reporting date, measured in days past due.

Not yet due
£12,000
1–30 days overdue
£6,000
31–60 days overdue
£3,000
61+ days overdue
£1,000
Total outstanding£22,000

Bands do not overlap. Age alone does not establish the probability of collection.

Ageing without overlap

Decide whether age is measured from invoice date or due date. Days past due are often more useful for collections. Separate not-yet-due items and use bands such as 1–30, 31–60 and 61+ days overdue.

Reconcile outstanding balances

Sum open items with consistent signs and reconcile to the receivables control account in the general ledger. Investigate unallocated cash, duplicates, credit notes and currency differences before using the balance for reminders.

Turn the report into actions

Prioritise amounts, age, disputes and known circumstances rather than the total alone. Assign an owner and next action and record payment arrangements. An old balance is not automatically lost and a recent one is not necessarily secure.

Cash forecasts and metrics

Expected receipt dates need assumptions about actual ability to pay and arrangements. DSO can be used as a scoped ratio, but there is no universal receivables-to-MRR threshold. MRR measures subscription value rather than cash received.

Questions and answers

Are all open balances overdue?

No. Show invoices not yet due separately so they do not trigger inappropriate follow-up.

Is the overview always real time?

No. Freshness depends on integrations, imports and allocation. State the update time and reconcile missing events.

Do overdue balances automatically change MRR?

No. Use subscription status and metric policy for MRR, and open items for collections. Investigate relationships rather than assuming them.

Sources and documentation

We update our content regularly and do our best to keep it accurate. If you find an error or think something is missing, please tell us. We are always looking for ways to improve the content.

Found an error? Let us know