lamp.
ResourcesPricingAbout
4 min readBy

Record-to-report: exception and recovery register

Month-end books go wrong in small, repeated ways: a bill posted to the wrong head, a bank entry with no match, a stock count that disagrees with the ledger. This register gives your accounts person one place to log each exception, say who will fix it and by when, and prove it was closed. The owner or finance head uses it to see what is holding up the close.

When to use it

Start a new line the moment anyone spots a mismatch between a source document and the books, or between two reports that should agree. Keep it open through the whole cycle, from daily entries to the month-end close and the hand-over to your CA. If an item cannot be fixed before the books are locked, it stays on the register with its carry-forward reason.

The template

Table 1: the kinds of exception to log, with what to capture.

Exception typeTypical triggerSource recordUsual owner
Unmatched bank entryBank statement line with no voucher, or voucher with no bank lineBank statement, cash bookAccounts executive
Wrong ledger headExpense or receipt posted to the wrong accountVoucher, bill, ledgerAccounts executive
Missing documentEntry exists but bill, challan or receipt is not filedVoucher file, scanned copyPerson who raised the spend
Party balance mismatchCustomer or supplier statement differs from your ledgerParty statement, ledgerAccounts manager
Stock or asset differencePhysical count or asset list differs from booksCount sheet, stock registerStore or operations head
Late or duplicate entrySame bill booked twice, or booked after the period was lockedPurchase register, lock logAccounts manager

Table 2: the register itself. Copy these headings into your sheet and add one row per exception.

RefDate foundPeriodException typeDetailsAmount (₹)CauseFix plannedOwnerTarget dateDate closedChecked by
EX-001

How to fill it

  • Ref: a running number such as EX-001, never reused, so a closed item can still be traced.
  • Period: the books month the exception affects, not the day you noticed it.
  • Details: write what you saw, with the voucher or bill number, in one or two plain sentences.
  • Amount (₹): the money at stake. Use the gross difference, and note in Details if tax is involved.
  • Cause: the real reason, such as "bill sent by courier, reached late". Avoid "error" alone.
  • Fix planned: the correcting entry or action, for example a reversal and rebooking, or a request to the supplier for a credit note.
  • Date closed and Checked by: fill only after a second person confirms the books now agree with the document.

If an exception touches GST, TDS, PF or ESI, note it in Details and do not correct it on your own. Check the current rule on the official portal or with your CA before acting.

Example row

RefDate foundPeriodException typeDetailsAmount (₹)CauseFix plannedOwnerTarget dateDate closedChecked by
EX-01403-Nov-2026Oct 2026Unmatched bank entryBank debit of 12-Oct for freight, no voucher found18,400Driver paid by transfer, bill not submittedGet bill from transporter, book to freight inwardMeena (accounts)08-Nov-202607-Nov-2026Rakesh (finance head)

Review and sign-off

  • The finance head or owner reviews the open items, oldest first, before the books for the month are locked.
  • Review weekly during the last fortnight of the month, and once more on the day before the close is signed off.
  • Escalate to the owner when an item is past its target date, when the same cause appears three months running, or when the amount is large enough to change the month's profit.

Keeping it up to date

  • Close an item only after the corrected entry is posted and the supporting document is filed under the same reference.
  • Review the causes every quarter and change the daily routine where one cause keeps coming back.
  • Keep the register and its documents for the period your CA or the law requires, and do not delete closed rows.
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 →