E-Accounts & E-Taxation Training With Advanced Excel/TallyERP & SAP FICO By Chartered Accountant

Course Duration: 150 - 160 HRS with Highly Skilled 3 - 5 Corporate Trainers
(CA/HR Manager/MIS Analyst/SAP Consultant) for 10 Modules

SLA Consultants E-Accounts & E-Taxation Training Course Delivery Method:

• Web / Desktop Base
• Instructor-Led Classroom Sessions
• Presentations/Demonstration/Practical's of concepts
• Handouts/Assignments/Real-time Exposure to work on Clients

NOTE: Classes Are Also Available On Module Basis

Module 1 - Finalization of Balance sheet/ preparation of Financial Statement- By Chartered

Accountant

• Preparation of Balance sheet According to Revised Schedule III (Schedule VI of company act 1956) Of Company ACT 2013
• Preparation of Balance Sheet of SME Accounts
• Preparation of Balance Sheet of Large and Medium Entrepreneur
• Composition of Annual Final Accounts of Company (New Topic Added)
• Indian Gaaps Compliances (Account Standard) (New Topic Added)
• Depreciation Chart as per Income Tax & Company Act (New Topic Added)
• Depreciation Rate Comparison (New Topic Added)
• Inventory Control (New Topic Added)
• Bank Reconciliation Statement

Module 2 - Banking & Finance - By Chartered Accountant

• Documentation in  by SavePass v2.2" style="border: none !important; display: inline-block !important; float: none !important; font-weight: bold !important; height: auto !important; margin: 0px !important; min-height: 0px !important; min-width: 0px !important; padding: 0px !important; text-transform: uppercase !important; text-decoration: underline !important; vertical-align: baseline !important; width: auto !important; background: transparent !important;">FINANCE for
• CC Limit/OD Limit
• Project Reports
• CMA Data
• Practical Analytical Review of Reports
• Stock Statement
• LC(Letter of Credit)
• Letter of Credit- How to Open the LC
• How to Sanction the LC Limit from Bank
• Documentation for LC Limit
• NEFT/RTGS
• Ratio Analysis
• Bank Guarantee (Usage & Format)
• DD/Cheque
• Online Payment Of Taxes

Module 3 - TDS - By Chartered Accountant

• PAN Application
• TAN Application
• Deduction under sec.192 to 196
• Deposit challan 281/280/26 QB
• TDS Return 24Q / 26Q
• Digital Signature for Filling TDS  Returns
• Form 16/16A
• 26 AS.
• Foreign remittance 15CA/15CB
• Lower deduction /No deduct – form 13/15G-H
• Interest & Penalty calculation
• Journal Entry in Tally (Free)

Module 4 - Service Tax - By Chartered Accountant

• Notification & Circulars Understanding (New Topic Added)
• Negative list
• Exempted services – Notification 25/2012 (New Topic Added)
• Declared Services (New Topic Added)
• Pops Rules – Export/Import (New Topic Added)
• Point of tax-  Journal entry & concept
• Valuation Including Abatement
• RCM / PRCM [Reverse charge mechanism]
• Payment of S.T (GAR 7 CHALLAN) , Interest, Penalty
• Calculation of Interest, Penalty (New Topic Added)
• Registration – [ST1 & ST2]
• E-Filing of ST 3 Return
• Journal Entry in Tally (Free)

Module 5 - VAT (Value Added Tax) - By Chartered Accountant

• VAT-DVAT/HVAT/ CST
• Applicability
• Input/output Provisions.
• Schedule of VAT rate (New Topic Added)
• Registration DVAT 04, Haryana, Document Required
• Tax Invoice Generation, Bilty, Challan
• online Payment [DVAT-20]
• Quarterly Return [DVAT – 16]
• Online submission of road permit – (T2, 38)
• CST/ Registration, c-form/F/H/E1, E2 Online Generation
• VAT  return
• Composition Scheme In Context of WCT (New Topic Added)
• Assessment (New Topic Added)
• Journal Entry in Tally (Free)

Module 5.1 - WCT (New Module Added)

• Applicability
• Service tax /Income tax /VAT provision  WCT
• TAN Application under DVAT
• Journal entry in WCT
• TDS IN WCT

Module 6 - Excise / Customs / Import & Export Procedures - By Chartered Accountant

Excise:

• Excise Registration
• CETA (central excise tariff act) (New Topic Added)
• Valuation
• CCR-2004 (credit rules) (New Topic Added)
• How to File Monthly Return(ER-1/ER-6/ER-4)
• Annual Return(ER-5)
• How to Preparation of Registration under Excise
• RG-1,RG-23A-Part-I,Part-II,RG 23C Part-I,II
• How to Make Payment of  Excise 
• Excise Entries in Books of Accounts Tally ERP 9.0
• Registration online A1
• Payment GAR-7

Customs:

• How to Deal with Import and Export
• Import and Export Procedure
• Import Documents
• Import Procedure
• How to Release the Dollar from Banks to Pay Outside India A-1
• Export Procedure
• Export Document
• Bill of Entries
• Bill of Lading

Module 7 - Payroll Processing - By HR Manager

• PF Computation and Deposit of ECR
• ESI Challan Deposit and Return
• Taxability of Different Allowances and Perquisites
• Deductions (Tax Savings) Under Chapter VI A

Module 8 - MIS Advanced Excel - By MIS Analyst

• Objective:
  Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools

  TOPICS COVERED

  • Introduction, Basic Understanding , Sum, Count, Count, Count blank, Average, Max, Large Min, Abs, Sumif, Countif, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EOmonth, Edate, Net workdays, Today, Weekday, Week number, Workday, Find, Search.
  • V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formatting, Dated if, What If Analysis, Match Index, Offset Function, User form Function in Excel, Data Validation, Advance Filter, Sorting, Group & Ungroup, Data split, Text Function (Data Separation), Substitute

Module 9 - Advanced Tally ERP 9

Session 1 - Basic Accounting in Tally ERP 9

• Basics Of Accounting
• Fundamentals of Tally.ERP 9
• Create Accounting Masters in Tally.ERP 9
• Accounting Vouchers
• Financial Statements and Accounting Books & Reports

Session 2 - Basic Inventory Management in Tally.ERP 9

• Creating Inventory Masters in Tally.ERP 9
• Inventory Vouchers
• Generating Inventory Books & Reports 

Session 3 - Technical Features in Tally.ERP 9

• Multilingual Capabilities
• Technological Advantages of Tally.ERP
• Tally.NET and Remote Capabilities
• Application Management and
• Online Help and Support 

Session 4 - Advanced Accounting in Tally.ERP 9

• Bill –wise Details
• Cost Centres and Cost Categories
• Voucher Classes
• Multiple Currencies
• Interest Calculations
• Budget &Controls
• Scenario Management
• Banking

Session 5 - Advanced Inventory management

• Order Processing 
• Reorder Levels5 
• Tracking Numbers 
• Batch – wise Details 
• Additional Cost Details 
• Bill of Materials (BoM) 
• Price Levels and Price Lists 
• Stock Valuation 
• Zero Valued Entries 
• Inventory Ageing Analysis 
• Different Actual and Billed Quantities 
• Job Costing 
• Job Order Processing

Module 10 - SAP FICO

• Hands on Training on Account Payable and Account Receivable
• Setting up Purchase & Sales Process
• Vendor & customer Management
• Cash & Credit Management
• Liquidity Management
• Delivery and Invoice Management