Tax Audit Working Sheet in Excel Format

Updated Tax Audit working sheet Version 1.5

The workbook titled “Tax Audit Working – V1.5” is a structured tax audit working paper containing various annexures designed to assist in the collection, verification, reconciliation, and reporting of financial and tax-related information.

Annexure C is a balance confirmation working sheet for sundry creditors and debtors. It contains fields for serial number, party name, balance as per the counterparty’s ledger, and balance as per the entity’s books of account. The annexure is intended to facilitate reconciliation of balances between the books and external confirmations.

Annexure 8 relates to requirements under Section 43B. It provides columns for the nature of payment, outstanding amount, and date of payment. The annexure is designed to capture information regarding payments that may require verification under the relevant tax provisions.

Annexure 9 covers PF and ESIC payments. The sheet contains separate fields for the month, due date of payment, actual date of payment, amount due, amount paid, difference in payment dates, and whether the payment is treated as allowed or disallowed. The annexure serves as a tracking mechanism for statutory dues and their payment status.

Annexure 10 deals with particulars of loans or deposits exceeding the limits specified under Section 269SS. The annexure captures details such as the lender or depositor’s name, address, PAN, Aadhaar number, amount of loan or deposit, whether the loan or deposit was squared up during the year, maximum outstanding amount during the year, and the mode through which the loan or deposit was accepted. The sheet includes classifications relating to account payee cheques, account payee bank drafts, electronic clearing systems, credit cards, debit cards, net banking, IMPS, and other specified modes. The annexure is structured to record information necessary for examining compliance with the prescribed requirements relating to acceptance of loans and deposits.

Annexure 11 is a bank balance confirmation sheet. It contains fields for bank name, account number, account type, closing balance as per books of account, closing balance as per bank statement, and differences, if any. Various account categories such as savings accounts, current accounts, cash credit accounts, overdrafts, vehicle loans, home loans, and other loans are listed for reconciliation purposes.

Annexure 12 contains a comparison statement and instructions for updating or refreshing the working sheet. The annexure includes comparative financial information and references a working for Clause 44. It is intended to facilitate analytical review and comparison of financial figures between reporting periods.

Overall, the workbook functions as a tax audit documentation and verification tool. It consolidates multiple annexures covering balance confirmations, statutory payments, loan and deposit reporting, bank reconciliations, and comparative financial analysis, thereby providing a structured framework for audit-related data collection and review.

(Republished with Amendments)