A Debtor Report Is Not a Collection Plan

The debtor report is full of money the business has earned. The bank account is waiting for money it can spend. A useful collection plan explains how the first becomes the second.

That requires more than sorting invoices by age. Someone needs to know why a payment is outstanding, what has been agreed and which week the money can reasonably enter the cash forecast.

A balance is not a payment date. Give each material receipt a reason, an owner and a next action.

Begin with the accounting record

Accounts receivable represents customer amounts owed to the business. An ageing report helps organise unpaid invoices by their age or overdue status; check the basis used by your report. Xero's receivables guide explains the underlying concept and common ageing buckets.

Take a dated export or report as the starting point. Confirm that recent receipts, credits and adjustments have been allocated. A collection task for an invoice already paid wastes the team's time and can damage the customer relationship.

Keep the invoice identifier alongside the customer, outstanding amount and contractual due date. Then add operational fields: expected collection date, evidence, responsible person, dispute status and the next contact date. Preserve the contractual date rather than overwriting it with a hopeful forecast date.

Convert the balance into a dated expectation

Illustrative example. A service business has A$180,000 outstanding. The four customer balances below are fictional. All amounts are cash amounts in A$000; the example assumes any applicable invoice tax is included.

From receivables to expected collections — illustrative A$000

Customer	Outstanding	Current evidence	Collection plan
A	60	Payment date confirmed	60 in week 1
B	40	Two instalments agreed	20 in week 2; 20 in week 4
C	50	Delivery dispute unresolved	Separate recovery scenario
D	30	Current invoice; normal payment assumption	30 in week 3

The base collection plan totals A$130,000 across four weeks, not A$180,000. It includes A$60,000, A$20,000, A$30,000 and A$20,000 in weeks one to four respectively. Customer C's A$50,000 is shown separately until there is a supportable resolution assumption.

Customer D remains less certain than a confirmed receipt, even though it is included in this illustrative base case. Label that difference. A base forecast is an estimate, not a guarantee that every included customer will pay on time.

Excluding the disputed amount from a short-term cash case does not, by itself, write off the accounting receivable. Collection assumptions and accounting impairment are separate decisions. Ask your accountant to determine the appropriate treatment in the books.

Resolve the cause, not just the reminder

A customer waiting for a purchase-order number needs a different response from one disputing delivery. A customer who says an invoice never arrived needs a delivery check, not a tougher tone. A payment promise that has been missed needs a fresh conversation and a revised expectation.

Attach a specific next action to the cause: resend the invoice to the correct address, obtain acceptance evidence, reconcile the disputed line or confirm the agreed instalment. Use a short factual note rather than an unstructured history nobody will read.

Any revised commercial terms should be agreed through the business's approval process. Do not assume that a collection workflow authorises fees, legal threats or unilateral changes to the contract.

Connect collections without duplicating revenue

The invoice is already a receivable. Adding its expected payment to the cash forecast must not create another sale in the profit forecast. Likewise, a deal that has become an invoice should not remain in a separate weighted pipeline layer contributing the same money again.

Use the original invoice identifier to match the expectation to the eventual receipt. Once a payment is reconciled, replace the forecast movement with the actual movement and retain any remaining balance.

The pipeline-to-cash guide describes this handoff. The profit versus cash guide explains why earning the revenue and collecting the cash are not the same event.

Review the items that could change a decision

At the weekly review, begin with receipts that have slipped, large balances and items affecting the lowest forecast cash point. Add new evidence rather than mechanically moving every overdue invoice into next week.

Measure promises kept, amounts collected and unresolved causes. A rising number of reminders is not necessarily progress. The useful outcome is a more realistic cash assumption and a customer issue that someone is actually resolving.

Bring the resulting dates into your 13-week cash forecast. Explore MagicHub for our approach to linking operational ownership with financial planning.

General business education only, not accounting, tax, legal or financial advice. Worked examples are fictional and simplified, not customer results or industry benchmarks. Confirm the assumptions and obligations that apply to your business with your adviser.