Accounts, Tax, GST Training & Efiling Course - in Delhi/NCR and Pune

Practical Assignments in GST Basics, GST Accounting and making GST Tax Computations incorporating

• Accounting in Tally GST
• Making GST Tax Computations in Excel
• Applicability oF CGST, IGST, SGST, UTGST on Different Transactions
• Understanding GST Input Tax Credit Implications
• Adjustment of CGST,SGST,IGST Credit Amongst Each other
• Preparation of GST PMT Registers
• Concept of Jobworker in GST
• Concept of Input Service Distributor in GST
• Reverse Charge Mechanism in Case of Purchase from Unregisterred Dealers
• TCS and Reverse Charge Implications in case of E Commerce Transactions in GST
• Billing and Invoicing in GST
• Invoicing In GST
• TDS Implications in GST
• Composition Scheme in GST
• Time of Supply in GST
• Place of Supply in GST

This course will be taught in GST Demo Website
https://www.teachoo.com/gst/demo/dashboard/

Practical Efiling Practice of Different GST Challan and Returns like

• GSTR 3B - Monthly Return for July 2017 to March 2018
• GSTR 1 - Details of outward supplies of taxable goods and/or services effected
• GSTR 2 - Details of inward supplies of taxable goods and/or services effected claiming input tax credit
• GSTR 3 - Monthly return on the basis of finalization of details of outward supplies and inward supplies along with the payment of amount of tax.
• GSTR 4 - Quarterly return for Composition Dealers
• GSTR 9 - Annual Return to be filed by All Dealers
• GST Challan E-payment Procedure
• Use of GST Offline Utility to create JSON File
• Interest and Late Fees Calculation and Deposit at GST Portal
• Electronic Cash and Credit Ledger Online Checking

Practical Assignments in

• Accounting for TDS Receivable and Payable in Tally ERP 9
• TDS Rates and E-Payment of Challan 281
• Filing TDS Return Form 26Q
• Checking of Form 26AS
• Procedure of Form 15CB and 15CA and Form 27Q
• Issue of TDS Certificates
• Concept of 15G and 15H Form
• Certificate of Lower Deduction
• Issue of TAN No
• TDS Late payment Interest and Penalty Calculation

Practical Assignments in

• Deduction of TDS with Salary, Allowances, Perquisites
• Treatment of Deductions under Chapter VIA
• Computation and Online deposit of PF ECR
• Computation and Online deposit of ESI
• Making Salary Structure for Employees
• Making Salary Sheet and Disbursement of Salary
• Important forms/records to be maintained for handling Payroll
• Understanding Treatment of PF/TDS/ESI in case of Leave /New Joinings
• Using Relevant Advanced Excel formulas for Payrol Processing

• EFiling ITR For Salaried Business
• Advance Tax Computation and Deposit
• EFiling ITR For Small Proprietorship
• Deduction and EFiling ITR For Patnership Business
• Practical implications of Important Points of Different Incomes
• Understanding Expense Disallowed
• Current Tax and Deferred Tax Computation for Companies
• Challan 280 Online and Offline Procedure

Practical Assignments incorporating

• Passing Routine and Book Closure Entries in Tally ERP 9
• Provisioning for Different Expenses and Payables
• Preparing Depreciation Chart as Per Companies Act and Income Tax Act
• Current and Deferred Tax Computation and its Provisioning
• Preparation of Bank Reconciliation Statement (BRS) in Tally ERP 9
• Exporting Data in Excel
• Preparation of P & L Balance Sheet as per Revised Schedule III

Practical Assignments in Application of Advanced Excel formulas in different situations

• Basic Excel and Excel Shortcuts
• Vlook up and Hlook up
• Pivot tables, Goal Seek and Macros
• If Command, Nested if
• Countif, Sumif etc
• Index and Match
• Concantenate and Data Validation formulas

Practical Assignments in

• Accounting in Tally ERP 9 of Different Expenses and Income Bills with Different Taxes like Vat, Service Tax, TDS, Excise
• Billing from Tally
• Bank Reconciliation in Tally
• Debtor Aging in Tally
• Cost Center Reporting in Tally
• Inventory Features in Tally
• Exporting Data from Tally
• Using Tally Shortcuts
• AP AR Process
• Petty Cash handling Process