Record-to-report: control and audit worksheet
This worksheet tests whether the controls in your month-end bookkeeping actually work. The accountant or an outside reviewer picks samples, checks the evidence and records the result and the fix. It is meant for businesses with a bookkeeper and an accountant, where one person enters the figures and another should be checking them.
When to use it
Use it every month after the soft close, and in full once a year before the accounts are finalised. Also use it when a new bookkeeper starts, when a bank account is added, or when a reconciliation difference stays open for more than one month. Treat a failed line as information, not blame: the aim is to find the weak point while it is small and fix it before the year-end accounts.
The template
Keep one worksheet per month and one row per control, and add a second set of rows if you run more than one bank account or sales channel.
| Control | What to test | Sample to pick | Evidence expected | Result | Reviewer | Corrective action |
|---|---|---|---|---|---|---|
| Bank reconciliation | Book balance agrees to the statement after listed differences | Each bank account, month end | Statement, reconciliation signed and dated | Accountant | ||
| Transaction sources | Every source of receipts and payments is in the books | Cash, card, wallet or gateway settlements for the month | Source statement matched to ledger | Bookkeeper | ||
| Unposted bills or entries | Bills received in the month are posted in the month | Five bills from the bill folder | Bill with ledger entry and date | Accountant | ||
| Accruals and closing stock | Journal is approved and has support | Each accrual and the stock entry | Approval note, workings, stock count sheet | Owner | ||
| Trial balance review | Unusual balances are explained | Three largest movements against last month | Review notes on the trial balance | Owner | ||
| Soft close and later changes | Entries after soft close are approved and listed | Every post-close entry | Change list with reason and approver | Accountant |
How to fill it
- Control: keep the six lines. If a control does not apply, write why instead of deleting it.
- What to test: one sentence describing what a pass looks like.
- Sample to pick: the reviewer chooses, and never the person who posted the entries. Write what was picked.
- Evidence expected: the actual document. Memory is not evidence.
- Result: Pass, Fail or Partly, with a reason.
- Corrective action: one fix, one person, one date. Where a correction touches tax, Check the current rule on the official portal or with your CA before acting.
Example row
| Control | What to test | Sample to pick | Evidence expected | Result | Reviewer | Corrective action |
|---|---|---|---|---|---|---|
| Unposted bills or entries | Bills received in the month are posted in the month | Five bills from the October folder, total ₹86,400 | Bill with ledger entry and date | Fail: one bill of ₹12,700 received 28 Oct posted in November | Accountant | Move the entry to October through an approved journal by 8 Nov; remind the bookkeeper to post on receipt |
Review and sign-off
- The bookkeeper fills the evidence column, the accountant tests and records the result, and the owner signs the worksheet.
- Do it monthly after the soft close. Once a year, an outside reviewer or your CA looks at the whole set.
- Escalate to the owner when a reconciliation has an unexplained difference, when an entry was posted after close without approval, or when the same control fails in consecutive months.
Keeping it up to date
- Keep the signed worksheets with the reports they tested, for the period your CA or the law requires.
- Record each corrective action's closing date and proof, and leave the original result visible.
- When you add a new bank account, a new sales channel or a new type of stock, add a control line for it in the same month.