Year-end: control and audit worksheet
At the close of the financial year, balances that looked fine all year get questioned by your CA or auditor. This worksheet lists the balances and controls that usually draw queries, shows what proof to hold for each, and records what the auditor asked and how you answered. The finance head fills it, and the owner reads it before the accounts are finalised.
When to use it
Open it a few weeks before the year closes and keep it going until the auditor's queries are answered and the accounts are signed. It suits any business with stock, receivables, loans or fixed assets. If your CA gives you their own checklist, use this one to prepare the evidence and then map each row to theirs.
The template
Table 1: control and balance checks.
| Area | Control to test | Balance per books (₹) | Balance per proof (₹) | Difference (₹) | Proof held | Owner |
|---|---|---|---|---|---|---|
| Bank and cash | Bank reconciliation to the last day of the year | Bank statement or confirmation | Signed reconciliation | Accounts manager | ||
| Receivables | Party statements agree with ledger | Customer confirmations | Statements, reply mails | Accounts manager | ||
| Payables | Supplier statements agree with ledger | Supplier statements | Statements, credit notes | Accounts executive | ||
| Stock | Physical count agrees with stock ledger | Count sheets | Signed count sheets | Stores head | ||
| Fixed assets | Asset list agrees with ledger and exists | Asset register, spot check | Register, photos | Operations head | ||
| Loans | Lender balance agrees with ledger | Lender statement | Loan statement | Finance head | ||
| Accruals | Expenses of the year booked in the year | Subsequent bills and payments | Working with bills | Accounts manager |
Table 2: auditor query log.
| Query no. | Date raised | Raised by | Query | Reply and document | Date answered | Status |
|---|---|---|---|---|---|---|
| AQ-001 |
How to fill it
- Balance per books: take it from the trial balance as at the year-end date, and note the report date you used.
- Balance per proof: the figure shown by the outside or physical evidence, not your own ledger.
- Difference: books minus proof. A zero is fine. Anything else needs a line in the exception register or a note.
- Proof held: name the actual file or folder, so someone else can find it.
- Status: use words that mean something, such as "answered, awaiting auditor", "open, document with supplier" or "closed".
For items linked to GST, TDS, PF, ESI, MSME dues or company law, the reporting and timing are set by rule. Check the current rule on the official portal or with your CA before acting.
Example row
| Area | Control to test | Balance per books (₹) | Balance per proof (₹) | Difference (₹) | Proof held | Owner |
|---|---|---|---|---|---|---|
| Payables | Supplier statements agree with ledger | 6,42,500 | 6,31,200 | 11,300 | Statement of Shree Packaging Works, credit note awaited | Meena |
The difference of ₹11,300 is a credit note the supplier issued in the last week of the year. Book it or explain it before the auditor asks.
Review and sign-off
- The finance head reviews every row with a difference, and the owner reviews the totals and the open queries.
- Review weekly in the last month before closing, then every few days while the auditor is on the books.
- Escalate to the owner when a difference cannot be explained, when proof is not available from a third party, or when an auditor query stays open past the date you promised.
Keeping it up to date
- Update the balances each time the trial balance changes, and show the date of each version.
- Carry forward the controls that failed this year into next year's list, with the fix you made.
- Keep the worksheet, proofs and query replies for the period your CA or the law requires.