lamp.
ResourcesPricingAbout
3 min readBy

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 typeWhat it looks likeBusiness effectUsual recovery stepOwner
Invoice disputedCustomer questions quantity, rate or qualityPayment held backCompare with the order and delivery record, then agree a credit or correctionSales manager
Short paymentAmount received is lower than the billBalance stays openAsk for the payment advice and match each deductionAccounts clerk
Deduction at source differenceCustomer paid less because of tax deductedBalance open, certificate pendingAsk for the certificate and match it to the deductionAccounts clerk
Wrong customer detailsName, address or tax number incorrect on the invoiceCustomer may refuse to payCorrect as the current rule allowsAccounts clerk
Broken promise to payPromised date passes with no paymentCash flow plan slipsFresh contact, new dated promise, escalate if repeatedSales manager
Payment bouncedCheque or transfer returnedReceipt reversedContact the customer, ask for a fresh paymentOwner

Register entries:

Date noticedInvoice no.Exception typeWhat happenedAmount at stake (₹)Recovery stepResolved onPrevention 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 noticedInvoice no.Exception typeWhat happenedAmount at stake (₹)Recovery stepResolved onPrevention step
6 OctoberINV-2150Short payment₹52,000 bill, ₹49,400 received, ₹2,600 deducted for a damaged carton2,600Asked for photos, agreed credit of ₹1,200, collected ₹1,40022 OctoberPhotograph 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 →