Automation of Balance Sheet,Trial से Automatically Balance Sheet/P&L बनाना सीखें

Speaker/Expert:

CA POOJA GUPTA  is a member of Institute of Chartered Accountants of India since 2009, Qualified ISA and M.Com. Also, She is ICAI faculty and Famous YouTuber with Channel name “CAGURUJI” having approx. 665000 subscribers. 

She delivers educational videos on Income TAX, GST and EXCEL. She has more than 10 year experience in Indirect taxation, Direct taxation and specialize in all aspect of GST, Income Tax, VAT, Service Tax, Excise etc.

 

 

To Save time in Today’s Busy life It is most useful for :

Chartered Accountants (CAs), Tax Consultants, Tax Professionals, Accountants, Businessmen and Students etc.

 

Content of Course :

1. Powerful Excel Formulas (Most powerful Excel formula sikhaye jayenge jo aapko sirf B.Sheet banane mein hi nhi balki har jagah kaam aayenge)
2. Checking of Trial Balance to correct mistake if any
3. Trial Balance arrangements using Excel for Automation
4. Creation of Masters and Groups
5. Preparation of Automated Balance Sheet and Profit & Loss with Trial Balance
6. Full automation of B.Sheet ( iska matlab ek baar automation ke baad aap chahen toh daily balance sheet bana sakte hain woh bhi bus 5 minute mein, yaani agar Trail mein koi change ho jaaye toh bhi aapko koi pareshani na ho aapka bahut sare ghanto ka kaam minutes mein hone lagega)
7. Checking of Opening Trial Balance with Closing Trail Balance before finalization of Balance sheet is must and we will let you know how you can do this in minutes

Additional Content

How to find, if any change happened in Books of Accounts up to last month.

 

Validity of Accessibility :

unlimited 15 Days access

 

Duration of Video :

only 2 Hours

 

Course Material :

1 Excel Formula file with Practice sheet – 12 Nos

2 Automated Balance Sheet Formats for following categories : – 5 Nos

• Balance sheet : As Per Company Act and Income tax Act
• Balance sheet for Individual and Proprietorship firm
• Multinational businesses having Head Office and Multiple Branches.
• Monthly Balance Sheet Format

3 Trial Balance Formats for Comparison of Opening Balance with Closing Balance – 2 Nos

4 Steps of Automation of Balance Sheet and Profit & Loss Account. – 1 Nos.

 

Prerequisite:

A Computer/Laptop with MS Office