Quarterly review: control and audit worksheet
This worksheet tests whether each quarter-end task was really done and can be proved. The accountant or owner picks a sample for each control, looks at the evidence, and records a result with the fix. It is used by small businesses that file returns and pay taxes regularly and want to find gaps before an adviser or an officer does.
When to use it
Fill it once at the end of every quarter, after the returns and payments are done, and before the next quarter's plan is approved. Also use it after a notice, a late payment or a change of accountant.
The template
Pick the sample before you look at the evidence, and write down what you picked, so the test cannot be bent afterwards to give a pass.
| Control | What to test | Sample to pick | Evidence expected | Result | Reviewer | Corrective action |
|---|---|---|---|---|---|---|
| Quarter-end obligations listed | List covers every return, payment and reconciliation due | The checklist for the quarter against last quarter's | Dated checklist signed by the preparer | Owner | ||
| Filed returns confirmed | Each return shows a filing acknowledgement | Two returns chosen by the reviewer | Acknowledgement with date and number | Tax adviser | ||
| Books agree with the return | Figures in the return match the books for the period | One return, three figures | Reconciliation with differences explained | Accountant | ||
| Tax and payment estimate reviewed | Estimate was reviewed by the adviser before payment | The tax working | Working with the adviser's note and date | Tax adviser | ||
| Payments recorded with references | Each payment has a challan or bank reference in the books | Three payments | Payment acknowledgement and bank entry | Accountant | ||
| Next-quarter actions approved | Actions have an owner and a date | The action list | Action list signed by the owner | Owner |
How to fill it
- Control: use the six lines in this order, which follows the quarter-end work. Add a line for any task that is special to your business.
- What to test: state the thing being checked in one sentence so another person can repeat the test.
- Sample to pick: the reviewer chooses the sample, not the person who did the work. Write what was chosen.
- Evidence expected: name the document. If it is missing, the result is a fail, however sure everyone is that it was done.
- Result: write Pass, Fail or Partly, with a short reason. Do not leave a result blank.
- Corrective action: one action, one person, one date.
- Statutory items: for filings, tax payments and deductions, 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 |
|---|---|---|---|---|---|---|
| Payments recorded with references | Each tax payment has a reference in the books | Three payments, ₹42,000, ₹18,500 and ₹9,200 | Payment acknowledgement and bank entry | Partly: the ₹18,500 payment has no reference in the books | Accountant | Obtain acknowledgement from the portal and post the reference by 10 Oct |
Review and sign-off
- The accountant prepares the worksheet and the owner signs it. The tax adviser reviews the lines marked for them.
- Review once a quarter. Compare each result with the previous quarter and note whether a failed control improved.
- Escalate to the owner and the adviser the same day when a filing has no acknowledgement, when a payment cannot be traced, or when the same control fails two quarters in a row.
Keeping it up to date
- Keep each completed worksheet with the acknowledgements it relies on, for the period your CA or the law requires.
- When a corrective action closes, write the date and the proof next to it, and do not erase the original result.
- Revisit the control lines every year with your adviser, and add any obligation that is new to your business.
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 →