Invoice-to-cash: daily operating review pack
This pack is a ten-minute daily review of money owed to you, so that follow-up is steady and nothing goes quiet. The accounts clerk prepares it, and the sales manager and owner take decisions from it. It suits any business that sells on credit or bills after delivery.
When to use it
Hold it at the same time each working day, with the customer ledger and bank statement open. On busy days keep it to the largest balances first. Run a longer version at the end of each week to look at ageing.
The template
Review agenda:
| Review item | Input to bring | Decision for today | Owner |
|---|---|---|---|
| Work done but not yet invoiced | Delivery or job records | Raise invoices today, or note the hold reason | Accounts clerk |
| Invoices sent yesterday | Sent record, payment details | Confirm the customer received them | Accounts clerk |
| Bills falling due today or this week | Customer ledger | Who reminds whom, and how | Sales manager |
| Overdue bills and broken promises | Promise log | Next contact, or escalate | Sales manager |
| Receipts not yet matched | Bank statement | Match, or ask the customer for details | Owner |
Collection tracker:
| Customer | Invoice no. | Amount due (₹) | Due date | Days overdue | Last contact | Promised date | Next step |
|---|---|---|---|---|---|---|---|
How to fill it
- Input to bring: print or open the actual ledger. Do not rely on memory.
- Decision for today: record one clear decision for each item, even if it is "no change".
- Amount due: the balance after part payments, not the original bill.
- Days overdue: count from the due date, not the invoice date.
- Promised date: what the customer said, with who said it. Do not enter a date you guessed.
- Next step: a specific action with a person, for example "call the accounts officer at 11 am".
- For tax on the invoice or tax deducted by the customer: Check the current rule on the official portal or with your CA before acting.
Example row
| Customer | Invoice no. | Amount due (₹) | Due date | Days overdue | Last contact | Promised date | Next step |
|---|---|---|---|---|---|---|---|
| Shree Traders | INV-2201 | 38,500 | 25 October | 11 | 3 November, call with purchase head | 8 November | Sales manager calls on 8 November, asks for the payment advice |
Review and sign-off
- The sales manager signs the tracker each day, and the owner reviews it weekly.
- Count total overdue, the number of broken promises and receipts unmatched each week.
- Escalate to the owner when a large customer misses two promises, a bill is disputed, or receipts stay unmatched for more than a few days.
Keeping it up to date
- Remove a row only when the ledger shows a zero balance or the owner approves a write-off.
- Adjust the agenda if one item is never discussed or a new one keeps arising.
- Keep daily trackers 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 →