5.00
(3 Ratings)

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

Categories: EXCEL, GST

About Course

GST a big revolution in the taxation system of India, This course is designed in a way that you can get complete knowledge of GST and can start your own practice in GST

GST Course Content

  1. Introduction to GST
    • Types of Taxes, Pre-GST, History, Benefit and Concept of GST in India
    • Constitutional Amendment
    • GST Definition
    • Important Website links for GST work
    • GST Council
    • GST Hierarchy
    • Detailed explanation of Important Definitions – Goods, Services, Consideration, Business, Related persons, Distinct Persons under GST
    • Components of GST
  2. Supply under GST
    • Concept of supply with examples
    • Sh I, Sh II, SH III
    • Composite and mixed Supply
    • Taxability of composite & mixed Supply
    • GST Tax Structure
    • GST compensation to states act (Cess)
  3. Levy of GST
    • Levy & collection of Tax
  4. Time of Supply in GST
    • TOS in case of Goods
    • TOS in case of Services
    • TOS in case of RCM
    • Change in Rate of Tax treatment
    • Special time of supply for real estate sector
  5. Value of Supply in GST
    • Valuation detailed concept
    • Valuation Rules to calculate taxable value in different type of businesses i.e. lottery betting and gambling, money changer, Air travel agent, life insurance business, sale purchase of second hand goods, Vouchers, pure agent,

6.       Payment of  Tax

    • Section 49: Payment of Tax, Interest, penalty and other amount
    • Electronic credit ledger
    • Electronic cash ledger
    • Electronic liability ledger
    • Section 50 etc.
  1. Place of Supply in GST
    • POS of goods within India
    • POS of imported and exported goods
    • POS of services within India
    • Place of supply of telecommunication services
    • Exempted Goods under GST
    • Exemption Service under GST
  2. Input Tax Credit in GST
    • Detailed knowledge of definition of Exempt supply, Zero rated supply, Aggregate Turnover, Input tax Credit
    • Sec 16 Eligibility & Conditions for ITC with rule 36
    • Sec 17 apportionment & Block Credits with rule 42 and 43
    • Sec 17(5) Block Credits in GST
    • Rule 42 apportionment of input & input services
    • Rule 43 apportionment of capital goods
    • Sec 18 ITC in special circumstances
    • Section 49A & 49B read with rule 88A
    • Rule 86A Condition of use of electronic credit ledger
    • Rule 86B Restriction on use of electronic credit ledger
  3. Registration in GST
    • Detailed knowledge of definition of Casual taxable person, nonresident taxable person
    • Person liable for GST registration
    • Persons not liable for registration
    • Compulsory registration
    • Procedure for registration
    • Practical session on GST Registration
    • Deemed registration
    • Special provisions relating to casual taxable person and non resident taxable person
    • Section 28: Amendment of Registration (Core & Non Core )
    • Cancellation or suspension of registration
    • 30 : Revocation of Cancellation of Registration
    • Documents required for GST Registration
  4. TDS & TCS, Tax Invoice, Debit Note & Credit Note in GST
    • TDS & TCS under GST
    • Tax Invoice provisions and rules
    • Delivery challan
    • Debit note and Credit note provisions
    • e invoicing
  5. RCM in GST
    • RCM on goods
    • RCM on Services
    • RCM from unregistered purchase
  6. QRMP scheme in GST
    • Types of GST returns
    • GST returns filing structure
    • QRMP scheme detailed coverage with case studies
    • IFF and mode of payment
    • Interest & Late fee
  7. ISD , ACCOUNTS & RECORDS, E WAY BILL
    • Input service distributor concept detailed coverage with GSTR6
    • Principal place of business
    • Place of business
    • Accounts and records
    • E-way bill detailed conceptual and practical coverage
  8. COMPOSITION SCHEME, JOB WORK , E INVOICE

o    Composition levy for traders & manufactures

o    Composition levy for restaurant services

    • Composition levy for other services
    • Job work
    • E-invoice complete coverage
  1. Import, Export, Deemed Export and Refund in GST
    • Import of Goods
    • Import of services
    • Export of Goods and services with or without payment of tax
    • Deemed Export
    • Special exporters
    • Merchant export
    • Different types of refunds under GST
    • Relevant date
    • Process of Refund in different situations i.e. SEZ, Deemed export, inverted duty structure, Zero rated supply,

 

  1. Assessment & Audit in GST
    • Self assessment in GST
    • Provisional assessment in GST
    • Scrutiny of returns
    • Assessment of non filers of GST returns
    • Assessment of unregistered person
    • Summary assessment in GST
    • Audit by authorities
    • Special Audit
  2. Inspection, Search and Seizure in GST
    • Power of inspection, search & seizure
    • inspection of goods in movement
    • Power to arrest
    • Power to summon
    • Access to business premises
    • Officers to assist proper officers
  3. Demand & Recovery in GST
    • Determination of Tax under section 73
    • Determination of Tax under section 74
    • Tax collected but not deposited
    • Recovery proceedings
    • Transfer of property to be void
    • Tax to first charge on property
    • Provisional attachment to protect revenue interest
  4. Appeal in GST
    • Appeals to Appellant Authority
    • Powers of Revisional Authority
    • Appellant tribunal under GST
    • Mandatory deposit of pre deposit
    • Procedure of additional evidence before Appellant Authority
    • Appeal to High Court
    • Appeal to Supreme Court
    • Appeal not to be file in certain cases
  5. Advance Ruling in GST
    • Question for which Advance ruling can be sought
    • AAR and AAAR
    • Procedure for obtain Advance Ruling
    • Rectification of mistake
    • Advance ruling to be void in certain cases
  6. Types of Returns in GST
    • Overview of GSTR 1
    • Overview of GSTR 2A
    • Overview of GSTR 2B
    • Difference between GSTR 2A and 2B
    • Overview GSTR 3B
    • Overview of GSTR 4
    • Overview of CMP 08
    • Overview of GSTR 5
    • Overview of GSTR 6
    • Overview of GSTR 7
    • Overview of GSTR 8
    • Overview of GSTR 9 (Annual Return)
    • Overview of GSTR 9C
    • Overview of GSTR 10 (Final Return)
  7. Practical session on GSTR 2A and GSTR 2B

·         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

·         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)

  1. Practical sessions on GSTR 1, 6 ways of filing of GSTR-1
  2. Practical session on GSTR 3B (Regular)
  3. Practical session on GSTR 3B (QRMP)
  4. Practical session on GST Computation
  5. Complete coverage of GST Annual Return (GSTR 9) and GSTR-9C

·         Detailed Explanation of GSTR-9 Form.

·         Basics of GSTR-9/9C

·         who is to file GSTR-9/9C

·         When to file GSTR-9/9C

·         Required Records for GSTR-9

·         Reporting & Optional Tables of GSTR-9

·         Spill over effects of  2021-22, 2022-23 and 2023-24 MORE THAN 22+ EXAMPLES (TO PROVIDE SOLUTION FOR ALL MISTAKES RELATED TO INPUT (ITC) & OUTPUT (sale)

·         Impact of Debit and credit note of F.Y. 2021-22, 2022-23 and 2023-24

·         RCM

·         What is GSTR-9C

·         GSTR-9C form (Part A and Part B)

·         Table 12 of GSTR-9C with practical examples

·         Table 5 of GSTR-9C detailed explanation

·         All other tables of GSTR-9C with Auditors checklist and certification part

Case Studies :

·         HOW TO SHOW DATA IN GSTR-9 RELATED TO F.Y. 2021-22 CLAIMED IN 2022-23

·         HOW TO SHOW DATA IN GSTR-9 RELATED TO F.Y. 2021-22 CLAIMED IN 2022-23

·         HOW TO SHOW DATA IN GSTR-9 RELATED TO F.Y. 2022-23 NOT CLAIMED TILL DATE

·         HOW TO CORRECT ITC CLAIMED IN WRONG HEAD

·         HOW TO CORRECT OUTPUT TAX PAID IN WRONG HEAD

·         Debit note, Credit notes treatment and many more

·         Table 12C of GSTR-9C practical case studies

28.  Practical session on GSTR 6,7,8

  1. Practical session on GSTR 10
  2. Practical session on E- invoice
  3. Practical session on E-way bill

And many more coverages

Automation of balance sheet course:

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.

After learning this course you can achieve one level up at your workplace

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 minutes

 

 

 

 

How you can watch the course? 
Course is having Recorded Lectures (Non-Downloadable) so user can watch anytime, anywhere and from any device as per his or her convenience & comfort zone.

Course is having study material in PDF, Excel or Word format (Downloadable)

After you buy the course, it will be activated in your dashboard, click on start learning to watch

 

What is course validity?

You can watch unlimited times with in validity period of 90 days as you per your convenience. It can be watch on Mobile/Tab/Desktop/Laptop.

Why there is limited validity on courses:

Validity is for your benefit, Long validity period have its own cons – students cannot be able to make schedule to complete the course timely.

How can I ask queries?

What’s up your query at 9150010800, you will get reply within 24 to 48 hours and in case you did not get solution on whats up then you can call on the same number

Is this include Certificate?

Yes, Course completion certificate can be downloaded after watching all the sessions 100%

 

 

 

 

 

 

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 & Download Study material

  • Intro Download Study material
    08:10

Introduction & History of GST, Supply under GST

Levy & collection of Tax, Time of Supply

Valuation, Payment of Tax

Place of Supply, Power to grant Exemption from tax

Changes in Exemptions of Goods & Services from 18 July 2022

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

GSTR-1 Meaning, Table details and 6 way to file GSTR-1

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 Electronic Credit Reversal and Reclaimed Statement – sep 2023

Mismatch in GSTR-3B vs 2A/2B

New GST return compliance DRC-01B

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

GST Notice ASMT 10, Reply in ASMT 11, Order ASMT 12

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

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

GSTR-9/9C (F.Y 2021-22) & (FY 2022-23)

Advance Ruiling, Appeal & Revision, Offence & penalties

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

GST amendments in year 2023

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
11 months ago
TOO GOOD ALL COVER TOPIC F GST
VV
1 year ago
It is practical course and very helpful
error: Content is protected !!