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 type | Typical trigger | Source record | Usual owner |
|---|---|---|---|
| Unmatched bank entry | Bank statement line with no voucher, or voucher with no bank line | Bank statement, cash book | Accounts executive |
| Wrong ledger head | Expense or receipt posted to the wrong account | Voucher, bill, ledger | Accounts executive |
| Missing document | Entry exists but bill, challan or receipt is not filed | Voucher file, scanned copy | Person who raised the spend |
| Party balance mismatch | Customer or supplier statement differs from your ledger | Party statement, ledger | Accounts manager |
| Stock or asset difference | Physical count or asset list differs from books | Count sheet, stock register | Store or operations head |
| Late or duplicate entry | Same bill booked twice, or booked after the period was locked | Purchase register, lock log | Accounts manager |
Table 2: the register itself. Copy these headings into your sheet and add one row per exception.
| Ref | Date found | Period | Exception type | Details | Amount (₹) | Cause | Fix planned | Owner | Target date | Date closed | Checked 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
| Ref | Date found | Period | Exception type | Details | Amount (₹) | Cause | Fix planned | Owner | Target date | Date closed | Checked by |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EX-014 | 03-Nov-2026 | Oct 2026 | Unmatched bank entry | Bank debit of 12-Oct for freight, no voucher found | 18,400 | Driver paid by transfer, bill not submitted | Get bill from transporter, book to freight inward | Meena (accounts) | 08-Nov-2026 | 07-Nov-2026 | Rakesh (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.