Ledger Scrutiny by Excel Automation (VBA)

Course Description

Ledger scrutiny is one of the most important procedures in audit, taxation, and financial analysis. This practical session will demonstrate how Microsoft Excel can be effectively used to automate (by AI codes) ledger review, identify exceptions, and improve the efficiency and accuracy of financial scrutiny.

Topics Covered:

Trial Balance Review using Excel
Debtors & Creditors Ledger Review
Practical case studies with live demonstrations
Ready-to-use Excel templates and automation techniques

Target Audience:

Chartered Accountants
Tax Professionals
Internal & Statutory Auditors
Finance Professionals
Accountants
CA, CMA and Commerce Students

Meet Your Instructor

CA Varun Parmar

I am a Chartered Accountant specializing at the intersection of Taxation and Technology, with strong expertise in GST audits, compliance management, and end-to-end indirect tax processes.

My work focuses on delivering accurate, efficient, and insight-driven solutions in indirect taxation. I have developed strong capabilities in data reconciliation, statutory compliance reviews, and identifying tax optimization opportunities that add real value to businesses.

With hands-on experience in Excel automation and process design, I build practical tools that streamline workflows, improve reporting accuracy, and reduce manual intervention. I strongly believe that the future of tax lies in integrating domain knowledge with smart technology.

I am passionate about creating scalable, user-friendly solutions that simplify complex GST processes for professionals and businesses. My goal is to drive efficiency through automation while strengthening compliance systems.

I continue to grow with a vision of becoming a trusted advisor in Tax, Technology, and Process Transformation, helping organizations move towards smarter and more structured financial ecosystems.

₹530 (Incl. of GST)

Enroll Now

Start Date: 22 August 2026

Time: 3 PM - 5 PM

Medium: Hinglish

Course feature :