AI Assisted Bank Audit Using Excel

AI Assisted Bank Audit Using Excel

Total Duration

10 Hours | 4 Sessions | 2.5 Hours Each

Date : 28th & 29th March, 2026

Day : Saturday & Sunday

Time: 10:30 AM to 1:00 PM & 2:30 PM to 5:00 PM

Fees : Quick Bird (Before 24th March) Rs. 1,499 ; Early Bird (Before 26th March) Rs. 1999 ; thereafter Rs. 2499

Registration @

https://imjo.in/RKBNeD

Beneficial For : 

Practicing CAs | Article Assistants | Bank Audit Teams 

Objective

Learn Practical Execution of Bank Statutory Audit Using Excel with AI Assistance.

━━━━━━━━━━━━━━━━━━━━

Session 1 – Bank Audit Data Preparation and Cleaning

Outcome: Prepare a Clean and Structured Loan Dataset Ready for Audit Testing.

Understanding Structure of CBS Loan Data

Identifying Common Issues in Bank Data Exports

Cleaning Dataset using Power Query

Standardizing Date and Number Formats

Removing Duplicates and Blank Records

Preparing Structured Loan Dataset for Audit Testing

Using AI to identify Risks Arising from Poor Data Quality

━━━━━━━━━━━━━━━━━━━━

Session 2 – Sanction Limit vs Outstanding Analysis

Outcome: Identify Loan Accounts where Outstanding Exceeds Sanctioned Limits.

Understanding Sanction Limit and Outstanding Balance

Creating Limit Breach Flag in Excel

Identifying Accounts Exceeding Sanctioned Limits

Filtering and Reviewing High Risk Loan Accounts

Using AI to Suggest Additional Audit Checks

━━━━━━━━━━━━━━━━━━━━

Session 3 – DPD Calculation, NPA Identification and Transaction Testing

Outcome: Identify Overdue Accounts and Detect Suspicious Transactions Requiring Audit Attention.

Understanding Days Past Due Concept

Calculating DPD using Excel

Classifying Accounts as Standard or NPA

Identifying Overdue Accounts Requiring Audit Attention

Understanding Bank Transaction Dataset

Checking Transactions on Sundays

Identifying High Value Transactions

Using AI to Generate Audit Queries and Fraud Indicators

━━━━━━━━━━━━━━━━━━━━

Session 4 – LFAR Support Using Excel and AI

Outcome: Extract and Prepare Data required for LFAR Reporting.

Reviewing Transactions with Missing Narration

Summarizing Suspicious Transactions using Excel

Overview of Key LFAR areas in Branch Audit

Identifying Accounts relevant for LFAR Reporting

Extracting required Data using Excel Filters and Summaries

Preparing Supporting Schedules for LFAR Points

Using AI to understand Important LFAR Reporting Checks

Faculty : 

CA. Keyur Doshi

Host :

Virag Shah

CA CMA CS CAIIB LLB

Founder - Connect Easy

Kindly Share With All Your Professional Friends, Colleagues and Other Connects.

Connect Easy @ Virag Shah @ +91 7043 154 500

To Your Success.