All Subjects Combo- Internal Audit, Statutory Audit, Excel, Perfect Accountant & Practicing Professional by CA Tushar Makkar

EXCEL KA CHAMP

Course Curriculum

Basic excel formula

Time: 35 min 9 sec

If, Left, Right, And, Mid, Text and explained Home TAB of header

Sessions: 1 | Time: 51 min 2 sec
Sheet till lecture 2

Vlookup, Xlookup, Hlookup, Match

Time: 23 min 28 sec

Index, Pivot, Sumifs, Charts, Substitute, Replace

Time: 31 min 57 sec

Macro or VBA coding in excel | Expert level in excel

Sessions: 3 | Time: 12 min 3 sec
Final Income tax calculator_V1
Final Excel
Excel tips to make you pro

ACCOUNTS KA BADSHAH

Course Curriculum

Introduction of Accounts ka Badshah

Time: 7 min 57 sec

Be a Pro in Accounts - Part 1

Sessions: 3 | Time: 1 hour 2 min 33
Be a Pro in Accounts - Part 2 27 min 27 sec
Practice questions_accounting (3 pages)

Set up and creation of company in Tally Prime

Sessions: 1 | Time: 10 min 11 sec
Tally data_R & S

Gateway of tally prime

Time: 23 min 28 sec

Create Masters- Ledger , Group, Voucher type, Stock Group, Stock Category, TDS setup etc.

Time: 26 min 3 sec

Record transactions in Tally Prime - Sales, Purchase, Journal, Receipt, Payment, Production, BRS Part 1

Sessions: 1 | Time: 50 min 29 sec
Record transactions in Tally Prime - Sales, Purchase, Journal, Receipt, Payment, Production, BRS Part 2 24 min 58 sec

GST & TDS Basics with Tally Prime feature

Sessions: 2 | Time: 1 hour 7 min 36 sec
TDS Basics with Tally Prime Feature 26 min 2 sec
10004_TDS tally

Financial statement preparation - Balance sheet, Profit and loss, Cash flow statement, notes to accounts etc. - As per ICAI Recommended format Part 1

Sessions: 5 | Time: 46 min 52 sec
Financial statement preparation - Balance sheet, Profit and loss, Cash flow statement, notes to accounts etc. - As per ICAI Recommended format Part 2 23 min 14 sec
R & S Company Financial statement
ICAI recommended Financial statement format
Pwc_Illustratative FS_Schedule III_Applicable on Ind AS Corporate (201 pages)
Schedule III AS_Applicable on Corporate

Interview Questions and answers discussion

Sessions: 3 | Time: 25 min 42 sec
Interview questions and answers discussion 25 min 42 sec
All about tally & Important Shortcuts and many more (90 pages)
Interview questions discussed in video

PRACTICING PROFESSIONAL

Course Curriculum

Content of course explained through Story

Sessions: 1 | Time: 8 min 8 sec

Business Structure - Proprietor, Partnership firm, LLP & Corporate

Sessions: 2 | Time: 22 min 54 sec
Business Structure - Proprietor, Partnership firm, LLP & Corporate Part 1 15 min 25 sec
Business Structure - Proprietor, Partnership firm, LLP & Corporate Part 2 7 min 29 sec

Setting up of Business entity

Sessions: 7 | Time: 1 hour 25 min 17 sec
Incorporation of Company Part 1 28 min
Incorporation of Company Part 2 18 min 57 sec
Format of Main Object of Various Type of Companies
Matters which are necessary for furtherance of the objects (4 pages)
Incorporation of LLP 17 min 3 sec
Subscribers_and_consent_sheet
Establishment of Partnership & Individual and application of PAN 21 min 16 sec

Goods & Service Tax

Sessions: 5 | Time: 1 hour 20 min 20 sec
Basics of GST 18 min 15 sec
All about Filing of GST registration 15 min 38 sec
All about GSTR 1 return filing17 min 22 sec
All about GSTR 3B return filing 14 min 12 sec
All About GST Annual Return filing 14 min 51 sec

Income tax

Sessions: 6 | Time: 1 hour 52 min 30 sec
Basics of Income tax 12 min 55 sec
All about TDS Part 1 18 min 17 sec
All About TDS Part 2 37 min 33 sec
All about Advance tax 17 min 26 sec
All About Income tax Return Part 1 15 min 19 sec
All About Income tax Return Part 2 10 min 58 sec

MCA Compliances for Company & LLP

Sessions: 12 | Time: 56 min 39 sec
Company - After Incorporation compliance-Part 1 5 min 20 sec
Company - After Incorporation compliance-Part 2 7 min 46 sec
Company - After Incorporation compliance-Part 3 5 min 54 sec
Company - After Incorporation compliance-Part 4 11 min 51 sec
Company - After Incorporation compliance-Part 5 6 min 49 sec
AGM & Director's Report
Auditor report
Shareholder's List document
MGT-9 (Annual Return)
LLP - After Incorporation compliance-Part 1 (Introduction) 1 min 37 sec
LLP - After Incorporation compliance-Part 2 (Form 11 LLP) 11 min 18 sec
LLP - After Incorporation compliance-Part 3 (Form 8 LLP) 6 min 2 sec

Other Important Video for Practicing professionals

Sessions: 9 | Time: 1 hour 16 min 12 sec
All about FSSAI (Food Licence) 11 min 40 sec
FSSAI State and Central licence documents (11 pages)
FSSAI Basic registration documents (1 pages)
Process to generate the UDIN 5 min 50 sec
Employee Provident fund & Employee state Insurance 12 min 53 sec
All about International Organization for Standardization (ISO Certificate) 9 min 59 sec
Shop & Trade licence 9 min 22 sec
All about MSME 6 min 18 sec
All about Trademark 20 min 8 sec

Completion of course discussion

Sessions: 1 | Time: 6 min 53 sec
Closure discussion - The Practicing Professional 6 min 53 sec

STATUTORY AUDIT

Course Curriculum

Introduction of course and basics of statutory audit

Time: 9 min 35 sec

Planning & Pre appointment formalities in Audit

Sessions: 7 | Time: 19 min 56 sec
Independence confirmation (2 pages)
Fraud inquiry procedure format (3 pages)
Intimation to auditor appointment (1 pages)
NOC acceptance (1 pages)
NOC_Request (1 pages)
AUDITORS CONSENT AND CERTIFICATE - AGM Appointment (1)
Engagement letter format

Materiality (Most Important in Audit)

Sessions: 2 | Time: 36 min 49 sec
Dummy BS, PL & CFS

Revenue - Process flow, Test of controls, Substantive testing & Sampling Part - 1

Sessions: 6 | Time: 1 hour 51 min 43 sec
Revenue - Process flow, Test of controls, Substantive testing & Sampling Part - 2 52 min 27 sec
RCM_Revenue_Chetan Work
Dummy sales register & Sales work paper
Sample methodolgy
Samples Data
RCM_Revenue_Final

Purchase - Process flow, Test of controls, & Substantive testing

Sessions: 4 | Time: 51 min 51 sec
Purchase samples
Purchase work paper and purchase register
Purchase RCM_chetan work
Purchase RCM_Final

Inventory - Process flow, Test of controls, & Substantive testing

Sessions: 3 | Time: 50 min 36 sec
Inventory work paper & Inventory valuation sheet
Inventory RCM_Chetan work
Inventory RCM_Final

Employee benefit expenses, Property plant & equipment, Cash & Bank, Trade receivables/Trade payables

Sessions: 3 | Time: 40 min 20 sec
Employee benefit expenses, Property plant & equipment, Cash & Bank, Trade receivables/Trade payables 40 min 20 sec
Depreciation_Companies_ Act 2013
Other Areas assertions

Satyam Scandal linked with assertions

Sessions: 2 | Time: 40 min 5 sec
Case Study on Satyam Scandal 39 min 5 sec
Attachment for Satyam Case

Completion stage in Audit

Time: 15 min 14 sec

Financial analysis - Variance analysis & Ratio analysis

Time: 23 min 43 sec

Audit report - Main audit report, ICFR report & CARO report

Sessions: 7 | Time: 1 hour 52 min 46
Audit report - Main audit report, ICFR report & CARO report- Part 1 48 min 5 sec
Audit report - Main audit report, ICFR report & CARO report- Part 2 34 min 12 sec
Audit report - Main audit report, ICFR report & CARO report- Part 3 30 min 29 sec
Annual-Report
CARO guidance note
Management-representation-letter-Format
Chetan prepared_auditor report

Audit Interview - Important Questions & Answers discussion

Sessions: 3 | Time: 1 hour 11 min 2 sec
Audit Interview - Important Questions & Answers discussion Part 1 34 min 18 sec
Audit Interview - Important Questions & Answers discussion Part 2 36 min 44 sec
Interview Questions for Statutory audit

INTERNAL AUDIT

Course Curriculum

Introduction of course and Basics of Internal audit

Sessions: 1 | Time: 14 min 13 secexpand_more
Introduction of course and Basics of Internal audit 14 min 13 sec

Understand steps of Internal Audit - Planning to Reporting

Sessions: 2 | Time: 20 min 29 sec
Understand steps of Internal Audit - Planning to Reporting 20 min 29 sec
Engagement letter format

Procurement to Pay (P2P) Process

Sessions: 13 | Time: 1 hour 33 min 46 sec
Introduction of P2P, Process Understanding of P2P & Walkthrough of P2P 28 min 56 sec
RCM & TOC of P2P 27 min 9 sec
Finding Issues in P2P Process and detailed analysis of P2P 36 min 40 sec
Sample detailed analysis
TOC performed on sample
No of sample formula for TOC
P2P walkthrough sample
Process flow discussion with client_P2P
P2P data from Client_Zip Folder
P2P observation
Procurement to pay RCM_Final
Procurement to pay RCM_Work to be done
Procurement to Pay Process

Order to Cash (O2C) Process

Sessions: 9 | Time: 1 hour 6 min 22 sec
Introduction of O2C, Process Understanding of O2C & Walkthrough of O2C 33 min 29 sec
RCM & TOC of O2C 8 min 5 sec
Finding Issues in O2C Process and detailed analysis of O2C 24 min 46 sec
O2C observation
O2C walkthrough sample
Process flow understanding of O2C
O2C data from client
RCM_O2C_Final
RCM_O2C_Work to be done

Hire to Retire (H2R) Process

Sessions: 10 | Time: 1 hour 19 min 59 sec
Introduction of H2R, Process Understanding of H2R & Walkthrough of H2R 35 min 51 sec
RCM & TOC of H2R 14 min 30 sec
Finding Issues in H2R Process and detailed analysis of H2R 28 min 36 sec
H2R process flow understanding
H2R Walkthrough sample final
H2R data from Client
H2R Observation
Acts applicable for manufacturing industry
H2R_RCM _Work to be done
H2R Observation

Production & Inventory process

Sessions: 9 | Time: 1 hour 10 min 11 sec
Introduction & Process Understanding of Production & Inventory 28 min 49 sec
Walkthrough, RCM & TOC of Production & Inventory 24 min 33 sec
Finding Issues and detailed analysis of Production & Inventory 16 min 49 sec
Production & Inventory process flow understanding
Production walkthrough sample
Production & Inventory Client Data
Production & Inventory RCM_Work to be done
Production & Inventory RCM_Final
Production & Inventory observation

P2P Observation discussion with Client - Mr. Bhatnagar (Purchase Head)

Sessions: 1 | Time: 43 min 26 sec
P2P Observation discussion with Client - Mr. Bhatnagar (Purchase Head) 43 min 26 sec

O2C Observation discussion with Client - Mr. Pathak (Sales Head)

Sessions: 1 | Time: 26 min 24 sec
O2C Observation discussion with Client - Mr. Pathak (Sales Head) 26 min 24 sec

H2R Observation discussion with Client - Mr. PP Singh (HR Head)

Sessions: 1 | Time: 21 min 16 sec
H2R Observation discussion with Client - Mr. PP Singh (HR Head) 21 min 16 sec

Production & Inventory Observation discussion with Client - Mr. Jain (Production head)

Sessions: 1 | Time: 19 min 37 sec
Production & Inventory Observation discussion with Client - Mr. Jain (Production head) 19 min 37 sec

Internal Audit preparation and presenting in Audit committee meeting

Sessions: 3 | Time: 42 min 23 secexpand_more
Internal Audit preparation and presenting in Audit committee meeting 42 min 23 sec
IA Report Final
REAL CLIENT PPT IA REPORT

Internal Audit Important Interview Question and Answers

Sessions: 3 | Time: 21 min 41 sec
Internal Audit Important Interview Question and Answers discussion 21 min 41 sec
Important questions of Internal audit
ALL IMPORTANT SAP T CODE

Meet Your Instructor

CA Tushar Makkar

CA Tushar Makkar, with over 9 years of audit experience, has led large teams. Known for sharing practical audit knowledge, earned immense appreciation and over 110k followers across multiple platforms. He has the largest audit community in India. His expertise encompasses Internal Financial Control, Statutory and Internal Audit, and Bookkeeping, with a particular focus on IND AS, US GAAP & IFRS. As the founder of his own venture, he has catered to diverse global clientele, including US and beyond