Certification Course Financial Statements Masterclass by CA Archit Agarwal

Session Plan

Preparation of Complete IND AS Financial Statements in Excel for Listed Entities
Preparation of Profit & Loss, Balance Sheet, Cash Flow Statements, Notes to Accounts with Explanatory Information from Trial Balance and Formatting as per Latest Schedule III
Disclosure Requirements and Notes to Accounts as per respective IND AS
Latest changes in Schedule III

IND AS 109- Financial Instruments- Discounting and Fair Value Computation Practically, Preparation of Excel Templates for Security Deposits, Staff Advances
Trade Receivables - Expected Credit Loss Matrix Calculation, ECL Matrix
IND AS 116- Leases Computation and Accounting
How to Create ROU and Lease Liability Recognition, Amortisation of ROU Asset

Analytical Procedures at Financial Statements Level
Variance Analysis
Learning Top- Down Testing Approach
Deep Dive into Abnormalities & Unusual Variances

Ratio Analysis
HUL Case Study
Learning Top- Down Audit Testing Approach
Identification of Diversion of Funds and Siphon Off Cases
Checking Vendor Kick Backs

Basics: Who has to follow IND AS
Objective of IND AS 101
Opening IND AS Balance Sheet and Single Transition
Key Adjustments on Transitions
First IND AS Financial Statements Must Include
Adoption of Board Policy for first time adoption of IND AS
Practical Working on MS Excel - Schedule III, Trial Balance, IND AS Adjustments and Balance Sheet Preparation as per IND AS

Meet Your Instructor

CA Archit Agarwal

Archit is a former Deloitte professional with 10+ years of experience, founder Thinking Bridge and who has trained over 60,000+ learners in finance domains like Statutory Audit. As a partner at a leading New Delhi firm, he has led audits and consulting for listed companies, top banks, and PSUs. A specialist trainer in Statutory Audit. As a partner at a leading New Delhi firm, he has led audits and consulting for listed companies, top banks, and PSUs. A specialist trainer in Statutory Audit.