WORKING CAPITAL · RECEIVABLES
Overdue invoices: turn an ageing report into a collection plan
An overdue balance is a question to investigate, not a receipt date. Separate payment delays from missing documents and genuine disputes before putting the money into your forecast.
THE SHORT ANSWER
Reconcile the balance, identify what prevents payment, assign one next action and record a realistic collection date. Review promised dates against actual receipts every week; a reminder sent is not cash collected.
Find the reason behind each overdue balance
Start with an ageing report that reconciles to the receivables ledger. Use the agreed due date to measure days overdue; invoice age and overdue age answer different questions. Remove cash already received but not allocated, identify approved credit notes and investigate duplicate invoices before contacting a customer. A collector working from an incorrect balance can damage a sound relationship.
Use three working queues: an accepted invoice awaiting payment; an invoice blocked by documents or processing; and an invoice with a commercial dispute. Add a separate flag for balances whose recoverability needs accounting review. The flags are management aids, not accounting conclusions. Record invoice number, currency, due date, undisputed amount, last confirmed contact, blocker, owner and next action.
The Australian Government and Business Queensland references below support disciplined terms, invoicing and debtor processes. They are Australian sources for general management principles. They do not establish Oman or other GCC legal requirements, collection rights or tax rules.
Work the blocker, then schedule the receipt
Consider a fictional distributor with OMR 22,000 overdue. Its largest overdue invoice is not necessarily the first source of cash. Of OMR 12,000 accepted by customers, OMR 7,000 has a confirmed payment commitment for next week. Another OMR 8,000 is held up by missing delivery evidence; operations can resolve OMR 3,000 of that amount before the payment run. OMR 2,000 remains disputed.
The first-week planning case is therefore OMR 10,000, subject to both commitments being met. Do not forecast the full OMR 22,000 merely because every invoice is overdue. Keep the remaining OMR 12,000 visible with its reasons and next tests. The split and timing below are invented; they describe neither a client result nor a reliable collection rate.
| 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.
Make the next action specific enough to complete
“Follow up” is not an action specification. “Send the signed delivery record to the customer’s accounts team by Tuesday, obtain acknowledgement and confirm the next payment run” is. Assign document issues to the person who can fix them; finance should not promise a credit note, price concession or contract change it is not authorised to approve.
Prioritise by size, evidence, urgency and effort, while checking customer concentration and relationship risk. Keep undisputed and disputed amounts separate. Use approved contact channels and share only the documents the recipient needs. If an instalment proposal or changed terms could help, document the proposal and seek the appropriate internal and legal approval before agreement. This guide does not recommend a universal escalation timetable.
Review early-payment discounts as a commercial cost. On a fictional OMR 10,000 invoice, a 2% discount sacrifices OMR 200 of revenue before any relevant accounting or tax effects. Whether earlier cash is worth that cost depends on the real timing, margin, alternatives and contract. A blanket discount may pay customers who would have paid on time anyway.
Connect collection evidence to next week’s cash decision
Update the 13-week cash planner using expected receipt dates, not sales dates. Put unsupported collections into a separately labelled scenario instead of silently treating them as certain. Test a one-week delay on the largest expected receipts and check the lowest forecast bank balance. Do not change a contractual payment obligation simply to make a forecast look comfortable.
At the weekly review, compare promised receipts with banked cash, count repeated broken promises and identify recurring billing blockers. Keep a short log of what changed, who checked it and which spending decision it affects. Where overdue balances affect financial statements, refer recoverability and any impairment treatment to the responsible accountant.
Use the worksheet below for a small, reconciled group of invoices first. Once the routine works, extend it. Our month-end guide connects the same evidence to the management pack; the profit-to-cash guide explains why reported profit cannot substitute for collection timing.
TAKE THE NEXT STEP
Use the worksheet.
Open the worksheet, type your notes in the fields and use your browser’s Print command to keep a PDF or paper copy. Calculations are manual. Entries stay in your browser and are not submitted to Mizwala; reload or close without saving and they may be lost.
Questions worth checking
Should every overdue invoice be included next week?
No. Use evidence of realistic timing and separate disputed or unsupported amounts. A due date alone does not prove receipt timing.
Does this replace local debt-recovery advice?
No. Contract rights, enforcement, privacy and accounting treatment require appropriate local and professional review.
Sources & scope
Primary references checked on 4 November 2026. The calculations, examples and workflow suggestions are Mizwala’s educational illustrations; the linked organisations do not endorse this guide.
- Australian Government · Guide to managing cash flow
- Business Queensland · Cash flow, invoices and payments
This is general management information. Adapt it to your circumstances and obtain appropriate professional advice before relying on it for a material decision.