Topics Covered
GST
This course will be taught in GST Demo Website/Real Government 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-Filing GSTR3B Return - Monthly Return of Regular Taxpayers
- E-Filing GSTR1 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 and Adjustment of Differences
- GST Amendment - Adjustment of Mistakes in GST Return 3B and GST
- 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 to be opted, How to check, register and use Digital Signature (DSC) etc.
We will also be providing you practical assignments incorporating
- Basic Concepts of GST and its Applicability
- Accounting in Tally GST of different Sales and 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
TDS Non-Salary & TCS
Practical Assignments in
- Accounting for TDS Receivable and Payable in Tally Prime
- TDS Rates - Deducting TDS as per different Rates of Income Tax
- 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
Income Tax
- E-Filing ITR For Salaried Business from Real Form 16
- Advance Tax and Self Assessment Tax Computation and Deposit
- E-Filing ITR For Small Proprietorship through Software/Excel Utility
- Deduction for Partnership Salary/interest and E-Filing 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)
Payroll Processing
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
Accounting & Balance Sheet Finalization
Practical Assignments incorporating
- Passing Routine and Book Closure Entries in Tally Prime, clearing of suspense and Finalizing Data with GST TDS 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 A/C and Balance Sheet as per schedule III with notes to accounts
- Checking and Verification of Data as per Revised Schedule III
Advanced Excel and MIS
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
Tally Prime/Busy
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
You can also Download our brochure
