Learn practical e filing ,accounting and taxation from one of the best CA Faculty in the field of practical training, Unlike other institutes which teach theoretical taxation,here it is a practical workshop where you will be actually made to pass entries from real bills in tally,make computation in excel for various tax payments,e -deposit challans and file online returns of various taxes like Vat,Servicetax,TDS,Excise,Payroll,PF,ESI. Also you will learn how to do Balance Sheet finalization and prepare MIS Reports This will help you to clear technical rounds of the interview with ease and get good job offers Practical Work of CA firm is also given on request to the interested students Tally and Excel are taught simultaneously with all topics

Topics Covered

DETAILED SYLLABUS INCLUDED TDS Non Salary 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 Service Tax Service Tax on Normal Charge Service Tax on Reverse Charge/Partial Reverse Charge Cenvat Credit Admissibility Online Deposit of GAR 7 Challans E-Filing of ST 3 Return Service tax with TDS PAYROLL-(PF,ESI AND TDS-Salary) PF Computation and Deposit of ECR ESI Challan Deposit and Return (Form 5) Taxability of Different Allowances and Perquisites Deductions (Tax Savings) under Chapter VI A E-Filing TDS Salary Return Form 24Q and Challan 281 Excise Applicability Cenvat Credit Admissability Deposit of GAR 7 Challans E Filing of ER 1 Return Excise Records to Be Maintained Vat & CST Applicability Input Vat Admissability Deposit of DVAT AND CST Challan E filing DVAT Return Form 16 and CST Return Form 1 E filing DVAT Annexures 2A-2D Applicability of Different Sales Tax Forms EXCEL Basic Excel and Excel Shortcuts Vlook up and H look up Pivot tables, Goal Seek and Macros If Command, Nested if, Countif, Sumif etc Balance Sheet Finalization Passing Routine and Book Closure Entries in Tally ERP 9 Preparation of Bank Reconciliation Statement (BRS) in Tally ERP 9 Preparation of P & L Balance Sheet as per Revised Schedule VI MIS and Reporting Ratio Analysis Preparation of Projections 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 Accounting Process Overview AR Process AP Process Fixed Asset Accounting Revenue Recognition Cash Handling Travel Bills Reimbursement

Who should attend

Ideal for BCOM,MCOM,CA/CS/CWA/MBA

Pre-requisites

Graduation Or Pursuing BCOM

What you need to bring

Laptops if available and Notebook

Key Takeaways

Practical Exposure in E filing,Accounts,taxation,,clear interview round easily