Summary of "Workshop on Bank Audit @ SIRC of ICAI on 12th March 2025."

Workshop Overview

The workshop on Bank Audit featured prominent speakers, including CA Sarin Kumar and CA Dungas Chaner, who provided insights into various aspects of bank auditing, emphasizing the importance of technology and data analysis in the process.

Main Financial Strategies and Trends:

Data Analytics and Automation: Emphasis on utilizing Data Analytics, automation tools, and Excel functionalities to streamline Bank Audit processes and enhance accuracy.
Bank Audit Statistics: Discussion on the declining percentage of audited branches in public sector banks, highlighting the competitive landscape for chartered accountants in securing Bank Audit assignments.
Risk Management: The need for auditors to focus on risk-based audits, including identifying quick mortality accounts and ensuring compliance with regulatory requirements.
Documentation and Evidence: Stressing the importance of maintaining thorough documentation and evidence for all audit processes to support findings and conclusions.

Methodology and Step-by-Step Guide:

Data Sanitization:
- Use Excel's text-to-columns feature to convert text files into structured data.
- Clean data by removing unnecessary characters or spaces that may affect calculations.
Analysis Techniques:
- Utilize functions like SUM, MIN, MAX, and AVERAGE for analyzing financial data.
- Implement IF and VLOOKUP functions to derive insights from financial records.
- Use AGGREGATE to handle errors and hidden rows in datasets.
Use of Excel Add-ins:
- Incorporate custom functions (e.g., converting numbers to words) to enhance reporting capabilities.
Sampling and Verification:
- Conduct sample testing for various accounts, ensuring a mix of current and past accounts to provide a comprehensive audit perspective.
- Document findings and maintain a record of all communications with bank management.
Reporting:
- Prepare a structured report that includes findings from the audit, emphasizing areas of concern and compliance with regulations.
- Ensure that all representations from the bank are documented and verified.

Presenters and Sources:

CA Sarin Kumar, a chartered accountant with extensive experience in bank audits and Data Analytics.
CA Dungas Chaner, known for his expertise in Forensic Accounting and technology, who provided additional insights during the second half of the workshop.
SIRC of ICAI, which organized the workshop to enhance knowledge and skills related to bank audits.