Course Duration in Hours
30
30
Module 1 Tally ERP 9.4 (Overall Accounts Entries)
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
Opening of company, new company
Account Heads
Grouping of Accounts
Configuration of Tally
Feeding of Receipts
Feeding of Payments
Feeding of Contra entries
Feeding of Sales
Feeding of Purchases
Feeding of Journal Entries
Petty Cash Book
Generation of reports from System
Bank reconciliation statement
Understanding controls in Tally
Accounting for TDS Receivable and Payable in Tally ERP 9
Vat Related transaction for input and output VAT.
Vat Reports Generation and final submission to the department.
Understanding Diff Modules like, Inventory, Accounts, Statutory, Payroll, Fixed Assets.
Export of data as such trial balance, balance sheet and profit & loss account.
Bill and invoice generation by the system.
Module 2 Taxation (Practical Exposure on Webtel Web-e tax)
(i) Income Tax
ROC (Register Of Company) Process.
Tax planning for employees.
Precautions while making payments- Voucher, Obtaining receipts, revenue stamp, payments exceeding certain amounts, etc.
TDS- Introduction to TDS & TDS chart and basic rules of deduction.
Payment of Challan.
Importance of PAN Number.
Due dates of payments.
Compilation of records for ETDS returns filing.
Coordination with Consultant/Professional.
Form no 26AS.
Issue of Certificates.
Receipt of Certificates.
Advance Tax.
Important Due dates.
Tax Audit & Requirements.
Basics on income tax returns.
Ratio Analysis.
Forecasting & Budgeting.
Knowledge of CMA
(ii) VAT & CST Returns
Applicability. Registration.
Registered Dealer & Unregistered Dealer.
Levy of Tax.
Input & Output Taxes.
Online Filing.
Due Dates.
Interest.
Penalties.
Online generation of Reports.
CST returns.
Carry Forward of VAT and Payment of VATonline.
Adjustment of CST against excess VAT .online
(iii) Service Tax
Applicability.
Registration.
Levy of Tax.
Cenvat Credit.
Online Filing.
Due Dates.
Interest.
Penalties.
Online generation of Reports.
(iv) Central Excise Tax
Applicability.
Registration.
Levy of Tax.
Cenvat Credit.
Online Filing.
Due Dates.
Interest.
Penalties.
Online generation of Reports
Module 3 HR Areas, Payroll & Labour Laws
Designing CTC break up as per offer letter.
Designing salary slip with all statutory & other deductions.
Preparing payroll summary.
Leave Calculation --- eligibility criteria for EL, CL & SL, Leave policy, Calculations, deductions & reimbursement.
Discussion on Allowances like Basic, HRA, DA, Conveyance, Medical Allowance, Food, Attire Allowance etc.
Discussion on Gross salary, Net Salary, CTC & Compensation and Benefits.
Labour Laws---PF acts, ESIC acts, Bonus acts, Gratuity acts, Professional Tax, etc.
Module 4 MIS Reports
Basic concept MIS and Excel
PF report in excel
ESI report in excel
HRA report in excel
VLookup, HLookup, Pivot Table, split & freeze.
Data fetching in excel.
Overview of Macros
How to prepare MIS report.
Tax Calculation in excel and lot of MIS report in excel.
B.A/B.COM/MBA in Finance
Skyworld, Laxmi Nagar (Delhi),Delhi,IN