lamp.
ResourcesPricingAbout
4 min readBy

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.

AreaControl to testBalance per books (₹)Balance per proof (₹)Difference (₹)Proof heldOwner
Bank and cashBank reconciliation to the last day of the yearBank statement or confirmationSigned reconciliationAccounts manager
ReceivablesParty statements agree with ledgerCustomer confirmationsStatements, reply mailsAccounts manager
PayablesSupplier statements agree with ledgerSupplier statementsStatements, credit notesAccounts executive
StockPhysical count agrees with stock ledgerCount sheetsSigned count sheetsStores head
Fixed assetsAsset list agrees with ledger and existsAsset register, spot checkRegister, photosOperations head
LoansLender balance agrees with ledgerLender statementLoan statementFinance head
AccrualsExpenses of the year booked in the yearSubsequent bills and paymentsWorking with billsAccounts manager

Table 2: auditor query log.

Query no.Date raisedRaised byQueryReply and documentDate answeredStatus
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

AreaControl to testBalance per books (₹)Balance per proof (₹)Difference (₹)Proof heldOwner
PayablesSupplier statements agree with ledger6,42,5006,31,20011,300Statement of Shree Packaging Works, credit note awaitedMeena

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.
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 →