5.00
(3 Ratings)

Combo – GST Course 2022 & Automation of BS and P&L

Categories: EXCEL, GST

About Course

GST course covering all aspects of GST with practical filings as per below schedule:

Day wise Schedule of Course :

Day TOPIC
DAY 1 Introduction & History of GST, Supply under GST
DAY 2 Levy & collection of Tax, Time of Supply
DAY 3 Valuation, Payment of Tax
DAY 4 Place of Supply, Power to grant Exemption from tax
DAY 5 Input Tax Credit, Manner of Utilisation of ITC, GSTR-2B
DAY 6 GST Registration Live Training, TDS & TCS under GST
DAY 7 Reverse Charge, Tax Invoice, Credit & Debit Note
DAY 8 GST Returns – GSTR-3B, GSTR-1/IFF (Live Training) with QRMP scheme
DAY 9 ISD, Accounts & Records, E-way bill (Live Training)
DAY 10 Composition Scheme , CMP-08, GSTR-4 (Live Training), Job work
DAY 11 Import, Export, Deemed Export, Refund under GST
DAY 12 GST Annual Return & Self Certified reconciliation statement (GSTR-9/9C) Live Training
DAY 13 Inspection, Search & seizure and arrest, Demand & Recovery
DAY 14 Advance Ruling, Appeal & Revision, Offense & penalties

Automation of Balance Sheet course coverage:

 

Excel is most powerful tool and if you use it in Accounting it work like wonders and help you to save lots of your time. This course provides you learning of Automation of balance sheet and Profit & loss on the basis of Trial Balance by using excel. Make sure your Trial Balance should be in excel format.

This course will also help you to match opening and closing balances in 5 minutes. Also you can prepare MIS reports, comparative reports etc. with the help of this course. you will gain so much knowledge that you can prepare balance sheet on daily basis just in 5 minutes.

It is very easy to understand.

 

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 within 2 minutes
  3. Trial Balance arrangements using Excel for Automation
  4. Creation of Masters and Groups
  5. Preparation of Balance Sheet and Profit & Loss automatically 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 Trial mein koi change ho jaaye toh bhi aapko koi pareshani nhi hogi,Ghanto ka kaam minuto 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 minute.
Show More

What Will You Learn?

  • GST Registration
  • GSTR-1
  • GSTR-3B
  • GSTR-2B
  • GSTR-4
  • CMP-08
  • IFF
  • QRMP scheme
  • Refund
  • Export
  • Import
  • GST Annual Return
  • GSTR-9C
  • E-way bill
  • E-invoice
  • Many more
  • Powerful Excel Formulas
  • Checking of Trial Balance to correct mistake if any with in 2 minutes
  • Trial Balance arrangements using Excel for Automation
  • Creation of Masters and Groups
  • Preparation of Automated Balance Sheet and Profit & Loss with Trial Balance
  • 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)
  • 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.
  • What is the meaning of GSTR 2A & 2B
  • Difference between 2A VS 2B
  • GST Returns Date and linking of these dates with 2A and 2B
  • Condition to claim ITC
  • History of ITC Rules
  • Cases of ITC which we can be claimed whether it is not in GSTR2A/2B
  • Important documents / Tables / Tools available on GST Portal for Reconciliation and How to use these tools.
  • GSTR 2B Reconciliation with GSTR 2A
  • GSTR-2B Vs Books Reconciliation benefits, Case studies and accounting adjustment entries
  • GSTR-2B Vs Books Reconciliation (Monthly)
  • Reconciliation of Books vs GSTR-2B Vs 2A (Monthly)
  • Live GSTR 3b filing with online deposit of challan, GTA Entries, Adjustment Entries after Reconciliation.

Course Content

Introduction & History of GST, Supply under GST

  • Introduction & History of GST, Supply under GST
    02:48:19

Levy & collection of Tax, Time of Supply

Valuation, Payment of Tax

Place of Supply, Power to grant Exemption from tax

Input Tax Credit, Manner of Utilisation of ITC

GST Registration Live Training

TDS & TCS under GST, Reverse Charge

GST Returns – GSTR-3B, GSTR-1/IFF (Live Training) with QRMP scheme

ISD, Accounts & Records, E-way bill (Live Training)

Composition Scheme , CMP-08, GSTR-4 (Live Training), Job work

Import, Export, Deemed Export, Refund under GST

Inspection, Search & seizure and arrest, Demand & Recovery

GST Annual Return & Self Certified reconciliation statement (GSTR-9/9C) Live Training

Advance Ruiling, Appeal & Revision, Offence & penalties

Changes in Exemptions of Goods & Services from 18 July 2022

GSTR-9/9C (F.Y 2021-22)

GSTR 2B Reconciliation with GSTR 2A and Books of Accounts

Live GSTR 3B filing with online deposit of challan, GTA Entries, Adjustment Entries after Reconciliation

New Form 3B Table Wise Explanation (New Changes Covered)

New date to claim ITC w.e.f. 1st oct 2022

TRIAL BALANCE से AUTOMATIC BS/P&L बनाना सीखें

How to do Review of Course ?

How to download Certificate ?

Student Ratings & Reviews

5.0
Total 3 Ratings
5
3 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
Very useful
AJ
5 months ago
TOO GOOD ALL COVER TOPIC F GST
VV
7 months ago
It is practical course and very helpful
Ask ChatGPT
Set ChatGPT API key
Find your Secret API key in your ChatGPT User settings and paste it here to connect ChatGPT with your Tutor LMS website.
error: Content is protected !!