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
GST Demo Portal

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 Prime 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 Prime
• 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 Prime
• 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 Prime
• 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 Prime 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