Tech-Driven Bank Audit Mastery Virtual Workshop

24th to 28th March, 2025  

Monday to Friday  

5:30 to 7:30 pm Daily

Visit 

www.connecteasy.in

Fees :Early Bird ₹. 1999 on or before 20th March ; thereafter ₹. 2499

Register @

https://imjo.in/GMmNcb

Coverage:

Day 1: Importing & Cleaning Bank Data  

Learn to Extract, Clean, and Organize Bank Data  

Exercises:  

✅ Import CBS Reports (Excel, CSV, PDF to Excel conversion)  

✅ Power Query for Data Transformation  

✅ Clean Data (Remove Duplicates, Handle Missing Values, Fix Date Formats)  

Practice: Convert a Bank Statement PDF to Excel

Day 2: Excel Functions for Audit Analysis  

Master Excel Functions for Analyzing Bank Transactions.  

Exercises:  

✅ VLOOKUP, XLOOKUP, INDEX-MATCH for Transaction Extraction  

✅ SUMIF, COUNTIF, IF Formulas for Identifying Exceptions  

✅ Conditional Formatting for Overdue Loans and Irregular Accounts  

Practice: Identify Frequent Overdraft Accounts

Day 3: Loan & NPA Report Analysis  

Automate and Analyze Loan Performance.  

Exercises:  

✅ Pivot Tables for NPA and Overdue Loan Summaries  

✅ Interest Calculations with Excel Formulas  

✅ Track Repayment Patterns and Irregularities  

Practice: Analyze a Loan Portfolio and Identify NPAs  

Day 4: LFAR Report Automation  

Automate LFAR Data Extraction and Reporting  

Exercises:  

✅ Use Power Query for Key LFAR Figures  

✅ Generate Exception Reports with Pivot Tables and Data Filters  

✅ Automate Report Formatting with Macros (Basic VBA)  

Practice: Create and Populate an LFAR Template with Sample Data 

Day 5: Audit Reporting & Final Submission  

Finalize LFAR Reports and Learn Audit Documentation Best Practices.  

Exercises:  

✅ Prepare LFAR Reports using Pre-built Templates  

✅ Cross-Check Key Figures with Automated Checks  

✅ Format Reports for CA Firm Submission

Practice: Complete a Draft LFAR Report using Audit Data

This Hands-on Training ensures Practical Experience with Real-world Audit Scenarios.

Faculty: CA. Keyur Doshi

Kindly Share with all Your Professional Friends, Colleagues, and Other Connects.

To Your Success!