lamp.
ResourcesPricingAbout
4 min readBy

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.

ControlWhat to testSample to pickEvidence expectedResultReviewerCorrective action
Bank reconciliationBook balance agrees to the statement after listed differencesEach bank account, month endStatement, reconciliation signed and datedAccountant
Transaction sourcesEvery source of receipts and payments is in the booksCash, card, wallet or gateway settlements for the monthSource statement matched to ledgerBookkeeper
Unposted bills or entriesBills received in the month are posted in the monthFive bills from the bill folderBill with ledger entry and dateAccountant
Accruals and closing stockJournal is approved and has supportEach accrual and the stock entryApproval note, workings, stock count sheetOwner
Trial balance reviewUnusual balances are explainedThree largest movements against last monthReview notes on the trial balanceOwner
Soft close and later changesEntries after soft close are approved and listedEvery post-close entryChange list with reason and approverAccountant

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

ControlWhat to testSample to pickEvidence expectedResultReviewerCorrective action
Unposted bills or entriesBills received in the month are posted in the monthFive bills from the October folder, total ₹86,400Bill with ledger entry and dateFail: one bill of ₹12,700 received 28 Oct posted in NovemberAccountantMove 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.
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 →