Invoice-to-cash: control and audit worksheet
This worksheet lets an owner, accountant or sales manager test whether sales are really turning into cash the way you think. You pick a handful of invoices, trace each one from the order to the bank entry, and note where the trail breaks. It suits distributors, factories, shops with credit customers and service firms that bill after the work.
When to use it
Use it monthly on a small sample, and again after a large write-off, a dispute or a change in the accounts team. It also helps before a CA review, a bank loan discussion or a customer asking for a statement. If the sample throws up a tax invoicing, TDS or other statutory point, act on it carefully. Check the current rule on the official portal or with your CA before acting.
The template
| Control | What the reviewer checks | Evidence to look at | Reviewer |
|---|---|---|---|
| Invoice matches approved work | Quantity, rate and customer details agree with the order and the delivery or job record | Order, delivery challan, job card | Accounts clerk |
| Terms and method recorded | Credit days, payment method and any advance are noted for the customer | Customer ledger, quote | Sales manager |
| Invoice sent | Date and mode of sending are noted, with the payment details given | Email, message or courier record | Accounts clerk |
| Follow-up on overdue amounts | Each overdue bill has a dated contact and a promised date | Follow-up log | Sales manager |
| Receipt matched | Bank credit is linked to the right invoice, including part payments | Bank statement, receipt entry | Owner |
| Closure | The invoice shows zero balance, or the difference is explained | Customer ledger | Owner |
Findings sheet:
| Sample invoice | Control tested | Result | Gap found | Corrective action | Owner | Due date |
|---|---|---|---|---|---|---|
| Met / Partly met / Not met |
How to fill it
- Sample invoice: choose a mix of paid, part paid and overdue, from different customers and staff.
- What the reviewer checks: follow the paper trail. Do not accept a verbal answer.
- Result: Met, Partly met or Not met, with a gap note for Partly met.
- Corrective action: one task with a named person and a date.
- Reviewer: someone other than the person who raised the invoice.
Example row
| Sample invoice | Control tested | Result | Gap found | Corrective action | Owner | Due date |
|---|---|---|---|---|---|---|
| INV-2184 | Receipt matched | Partly met | ₹42,000 credit received against a ₹46,500 bill, ₹4,500 difference not explained | Ask the customer for the payment advice and record the reason | Accounts clerk | 20 November |
Review and sign-off
- The owner signs the worksheet. The reviewer should not be the person who handled the sampled invoices.
- Run it monthly, and after any dispute above your set rupee limit.
- Escalate to the owner when an invoice cannot be traced, a receipt sits unmatched, or the same gap repeats for two months.
Keeping it up to date
- Add a control when a loss shows a step you were not checking.
- Carry unresolved findings forward until each is closed.
- Keep worksheets and evidence 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 →