Overdue invoices: turn an ageing report into a collection plan

Complete this sheet with your own verified information. Calculations are manual. Use your browser’s Print command to save a PDF or print; entries are not submitted or automatically saved.

Ledger balance and report date

Invoice, currency and contractual due date

Undisputed amount and days overdue

Cash/credit-note reconciliation

Payment blocker and supporting evidence

Customer-confirmed commitment and confidence

Action, owner and completion date

Base and delayed cash forecast impact

Actual receipt, variance and next review

Reference example — fictional

Fictional collection plan · OMR
Working queue	Overdue / planned next week
Accepted; payment commitment obtained	12,000 / 7,000
Documents missing; selected evidence to be completed	8,000 / 3,000
Commercial dispute unresolved	2,000 / 0
Total	22,000 / 10,000
Not in first-week planning case	12,000

12,000 + 8,000 + 2,000 = 22,000; 7,000 + 3,000 = 10,000. Receipt timing is conditional, not guaranteed.

Return to the full guide and sources