lamp.
ResourcesPricingAbout
3 min readBy

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

ControlWhat the reviewer checksEvidence to look atReviewer
Invoice matches approved workQuantity, rate and customer details agree with the order and the delivery or job recordOrder, delivery challan, job cardAccounts clerk
Terms and method recordedCredit days, payment method and any advance are noted for the customerCustomer ledger, quoteSales manager
Invoice sentDate and mode of sending are noted, with the payment details givenEmail, message or courier recordAccounts clerk
Follow-up on overdue amountsEach overdue bill has a dated contact and a promised dateFollow-up logSales manager
Receipt matchedBank credit is linked to the right invoice, including part paymentsBank statement, receipt entryOwner
ClosureThe invoice shows zero balance, or the difference is explainedCustomer ledgerOwner

Findings sheet:

Sample invoiceControl testedResultGap foundCorrective actionOwnerDue 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 invoiceControl testedResultGap foundCorrective actionOwnerDue date
INV-2184Receipt matchedPartly met₹42,000 credit received against a ₹46,500 bill, ₹4,500 difference not explainedAsk the customer for the payment advice and record the reasonAccounts clerk20 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 →