Invoice-to-cash: exception and recovery register
This register records the cases where an invoice does not turn into cash on schedule, and how you recovered. An accounts clerk or sales manager keeps it, and the owner reads it to see which problems cost the most. Each row ends with a prevention step, so the same mistake is not paid for twice.
When to use it
Add a row as soon as an invoice is disputed, short paid, returned, sent with wrong details or promised and not paid. Review it at the monthly accounts meeting and before you change credit terms for a customer.
The template
| Exception type | What it looks like | Business effect | Usual recovery step | Owner |
|---|---|---|---|---|
| Invoice disputed | Customer questions quantity, rate or quality | Payment held back | Compare with the order and delivery record, then agree a credit or correction | Sales manager |
| Short payment | Amount received is lower than the bill | Balance stays open | Ask for the payment advice and match each deduction | Accounts clerk |
| Deduction at source difference | Customer paid less because of tax deducted | Balance open, certificate pending | Ask for the certificate and match it to the deduction | Accounts clerk |
| Wrong customer details | Name, address or tax number incorrect on the invoice | Customer may refuse to pay | Correct as the current rule allows | Accounts clerk |
| Broken promise to pay | Promised date passes with no payment | Cash flow plan slips | Fresh contact, new dated promise, escalate if repeated | Sales manager |
| Payment bounced | Cheque or transfer returned | Receipt reversed | Contact the customer, ask for a fresh payment | Owner |
Register entries:
| Date noticed | Invoice no. | Exception type | What happened | Amount at stake (₹) | Recovery step | Resolved on | Prevention step |
|---|---|---|---|---|---|---|---|
How to fill it
- Exception type: choose from the list. Add a new type only when none fits.
- Amount at stake: the money not yet received because of this exception.
- Recovery step: what you did for this invoice.
- Resolved on: the date the money was received or the balance was formally written off or credited.
- Prevention step: a change to the process, with a person and date.
- For tax on the invoice, a correction or a deduction at source: Check the current rule on the official portal or with your CA before acting.
Example row
| Date noticed | Invoice no. | Exception type | What happened | Amount at stake (₹) | Recovery step | Resolved on | Prevention step |
|---|---|---|---|---|---|---|---|
| 6 October | INV-2150 | Short payment | ₹52,000 bill, ₹49,400 received, ₹2,600 deducted for a damaged carton | 2,600 | Asked for photos, agreed credit of ₹1,200, collected ₹1,400 | 22 October | Photograph packing before dispatch |
Review and sign-off
- The sales manager reviews new rows weekly, and the owner reviews the register monthly.
- Count rows and rupees by type each month.
- Escalate to the owner for any amount above your set limit, a customer with repeated exceptions, or a write-off proposal.
Keeping it up to date
- Close a row only when the prevention step is done, not when the money arrives.
- Combine types that mean the same thing in different words.
- Keep the register for the period your CA or the law requires.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →