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

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/

Here we will give you different data and help you practically file different challan and returns namely

• E-filifng GSTR 3B Return - Monthly Return of Regular Taxpayers
• E-filifng GSTR 1 Return - Monthly /Quarterly Return of Regular Taxpayers through Offline Utility & Tally
• GSTR 4 - Annual return to be filed by Composition Dealers
• GST CMP-01 Return - Quarterly return for Composition Dealers
• GSTR 9 - Annual Return to be filed by All Dealers
• GST Challan E-payment Procedure
• E way Bill Generation from Tally
• Interest and Late Fees Calculation and Deposit at GST Portal
• Electronic Cash and Credit Ledger Online Checking and Computation
• Accounting in Tally ERP 9 of GST Transactions from Real Bills
• Clearing Mismatch Reports in Tally for GSTR3B/GSTR1
• Making GST Reconciliation Matching GSTR2A,3B and Tally Data
• Matching GST Data with Books of Accounts and Adjustment of Differences
• GST Amendment - Adjustment of Mistakes in GST Return 3B and GSTR1
• GST Portal Features - How to Register, How to Download Registration Certificate, How to Make Changes in Return, Where to Download Various Returns, How to Check Return Filing Status, How to Check whether Quarterly/Monthly Scheme opted, How to Check, How to Register and Use Digital Signature(DSC) etc
• New SAHAJ SUGAM Returns - Difference between Current Returns and New Returns and Basic Overview of How to Use New GST Offline Tool-Beta

We will also be providing you practical assignments incorporating

• Accounting in Tally GST of Different Sales Purchase Transactions
• Making GST Tax Computations in Excel after adjustment of CGST,SGST,IGST Credit
• Understanding GST Input Tax Credit Implications
• Concept of Job worker in GST
• Concept of Input Service Distributor in GST
• Reverse Charge Mechanism Section 9(3) and Section 9(4) both
• Billing and Invoicing in GST-Tax Invoice/Bill of Supply/Revised Invoice
• TDS and TCS Implications in GST
• Comparison between Normal and Composition Scheme in GST
• Time of Supply and Place of Supply in GST
• Calculation of Late Fees and Interest in Various Scenarios
• Latest amendments and Interview Questions of GST

Practical Assignments in

• Accounting for TDS Receivable and Payable in Tally ERP 9
• TDS Rates -Deducting TDS as per different Rates of Income Tax
• Preparing TDS Working and E-Payment of Challan 281
• Filing TDS Return Form 26Q
• Checking of Form 26AS to check TDS Deducted
• 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
• Form 26QB-TDS on Sale of Property
• Form 26QC-TDS on Personal Rent
• Form 27EQ –TCS Return for Tax Collected at Source
• Calculation of Late Fees and Interest Liability
• Checking Various TRACES Features like checking Interest-Penalty, Revision of TDS Returns Online And Offline
• Latest amendments and Interview Questions of TDS

Practical Assignments in

• Deduction of TDS on Different Allowances and perquisites Salary components
• Deductions under Chapter VIA -Treatment of Various Savings of Employees
• Making Salary Structure for Employees-For Lowest Tax Liability
• Preparation of PF Computation and Online deposit of PF ECR
• Computation and Online deposit of ESI
• 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 Joining
• Using Relevant Advanced Excel formulas for Payroll Processing
• Latest amendments and Interview Questions of payroll(TDS Salary/PF/ESI)
• Download of TDS Certificate Form (Form 16-Part A and B) for Employees
• E-filing of Form 24Q Return (Including Annexure II) for Quarter 4
• Calculation of Late Fees and Interest Liability
• Checking Various TRACES Features like checking Interest-Penalty, Revision of TDS Returns Online And Offline

• EFiling ITR For Salaried Business from Real Form 16
• Advance Tax and Self Assessment Tax Computation and Deposit
• EFiling ITR For Small Proprietorship through Software/Excel Utility
• Deduction for Partnership Salary/interest and EFiling ITR For Partnership Business
• Deductions under Chapter VIA -Treatment of Various Savings
• Practical implications of Important Points of Different Incomes like Capital Gain (ITR2),2 House Property (ITR2),Single Rented or Self Occupied Property(ITR1),Sale of Shares and property
• Understanding Different points of Expense Disallowed
• Current Tax and Deferred Tax Computation for Companies
• Challan 280 Online and Offline Procedure
• ITR for Audit Case –Optional (ITR3 for Proprietorship,ITR5 for Partnership,ITR6 For Company,ITR 7 for NGO)

Practical Assignments incorporating

• Passing Routine and Book Closure Entries in Tally ERP 9
• Clearing of Suspense and Finalizing Data with GST TD Returns
• 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
• Ledger Scrutiny ,Correction and Exporting Data in Excel
• Preparation of P & L Balance Sheet as per Schedule III with Notes to Accounts
• Checking and Verification of Data 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
• Learning where to use which formulas

Practical Assignments in

• Accounting in Tally ERP 9 with Different Taxes like GST and TDS
• Passing of Entries from Real Purchase Sales Bills and Bank Statements
• Billing and Invoicing from Tally-Generating Tax invoce and Bill of Supply
• Learning GST Settings in Tally and Clearing GST Mismatch Reports
• Bank Reconciliation in Tally and Debtor Aging in Tally
• Cost Center Reporting in Tally for Segment /Product Reporting
• Inventory Features in Tally And Godown Maintenance
• Using Tally Shortcuts, Understanding different Ledger Groups & Voucher Types
• Exporting and Importing Data from Tally to Excel