Accounts and Taxation Training & Efiling Course (Including Goods and Services Tax)

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

• Accounting in Tally ERP 9
• 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

Practical Efiling Practice of Different GST Challan and Returns like

• 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 compounding taxable person
• GSTR 5 - Return for Non-Resident foreign taxable person
• GSTR 6 - Return for Input Service Distributor (ISD)
• GSTR 7 - Return for authorities deducting tax at source
• GSTR 8 - Details of supplies effected through e-commerce operator and the amount of tax collected
• GSTR 9 - Annual Return

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

Practical Assignments in

• Making Service Tax Computation
• Efiling ST-3 Returns
• Depositing GAR 7 Challans

Incorporating

• Point of Taxation Rules
• Exemptions and Abatement
• Reverse Charge and Partial Reverse Charge
• Service Tax Rate Changes
• Important Service Tax Forms
• Service Tax Registration
• Amendment of Registration
• Late Payment and Interest Calculation

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

• Preparing Vat CST Computations
• Generating DVAT and CST Challans
• E-Filing Annexure 2A 2B 2C 2D
• Efiling DVAT 16 and CST Form 1

Incorporating

• Different CST Forms (C, F, H, C+E1)
• Debit Note and Credit Note
• Tax Invoice and Retail Invoice
• Billing from Tally
• Checking Input Admissibility
• Registration 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

• Ratio Analysis
• Preparation of Projections/Budgets
• Preparation of Fund Flow Statement and Cash Flow Statement
• Cost Centre Reporting in Tally ERP 9
• Debtor and Creditor Aging Report in Tally ERP 9

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

Practical Assignments in

• Applicability And Cenvat Credit Admissability
• Deposit of GAR 7 Challans
• E Filing of ER 1-ER 3 Return and New Annual Returns
• Excise Records to Be Maintained(RG 23A/RG 23C etc)
• Efiling Dealers Returns for First Stage and Second Stage Dealers
• Understanding Concept of PLA
• Treatment of CVD SAD on Import in Excise
• Treatment of Removal of Inputs Capital Goods as such and after use
• Registration Procedure in Excise

• 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