IT Tools + Financial Accounting + Tally Prime ( 9 months)
Course : Short Term Courses
I.T. Tools: 2 Months
Introduction: Introduction of Computer, Types of Computer, Operating Software, Trouble Shooting, Internet.
MS Word: Formatting Text, Editing Images, Shapes & Charts, Hyperlink, Cross Reference, WordArt, Page Setup, Watermark, Mail Merge, Compare, Protection.
MS PowerPoint: Slide Preparation, Insert, Smart-Art, Charts, Design, Transitions, Animations, Slide Show, Review.
MS Excel: Preparing Salary Sheet, Mark Sheet using Sum, Average, Maximum, Minimum, Count, Counta, Logical Functions, Financial Functions, Date & Time Functions, Math & Trig. Functions, Text Functions etc.
Advance Excel: 1 Month
Lookup & References: HLOOKUP, VLOOKUP, VLOOKUP with LARGE MAX, VLOOKUP with SUBTOTAL, Multiple VLOOKUP, Approximate VLOOKUP, VLOOKUP with MATCH, INDEX with MATCH Function etc., Absolute/Fixed, Relative & Mixed References.
Others: Advance Filter, Pivot Table & Charts, Hyperlink, Data Validation, Scenario Manager, Goal Seek, What-if-Analysis, COUNTIFS, SUMIFS, SUMPRODUCT, Loan Sheet, Attendance Sheet, Calendar, Advance Conditional Formatting, More than 100 Shortcut keys
Advantage: To achieve excellence in office work using MS Office. An e-Accountant gets lot of work in MS Excel, hence expertise in Advance Excel is essential to succeed as an e-Accountant.
Financial Accounting: 2.5 Months
Fundamentals: Accounting Concepts, Revenue Recognition, Golden Rules of Accounts, Journal, Ledgers [Practical], Cash Book [Practical], Depreciation Chart [Practical with Fixed Asset Register], Bank Reconciliation Statement [Practical], Adjustment Entries, Trial Balance, Profit & Loss A/c and Balance Sheet.
Advance: Consignment, Hire-Purchase, Partnership, Valuation of Inventories [As2], Property, Plant & Equipment [AS10]
Tax Deducted at Source: 15 Days
Law: TDS Law under Income Tax, Accounting Treatment of Transactions having TDS, Computation of TDS.
Practical Work: Online Payment of TDS, Quarterly Online TDS Returns using Govt. of India Software, Downloading TDS Certificate from TRACES Website
Advantage: Practical application of accounting concepts and standards in day to day accounting is the launching pad to reach the sky of success. Practical knowledge of TDS is also very important for a successful e-Accountant.
Tally Prime: 3 Months
Part-I: Installation, Company Creation, Configuration & Features, Groups, Ledgers, Stock Items, Godown, Voucher Entries, Manufacturing Process (BOM), Job Costing, Interest Calculation, Multi Currency, Forex Gains/Loss, Cost Centre & Class, Budget, Price List & Level, POS, Backup, Restore, Export & Import of Data, Splitting Company, Control Centre & Support Centre
Part-II: Transactions having GST [CGST, SGST & IGST] and TDS/TCS.
Part-III: Reports, Balance Sheet, Profit & Loss A/c, Ratio Analysis, Trial Balance, Day Book, Cash Book, Purchase & Sales Register, Inventory Books, Cash Flow & Fund Flow Statement.
Part-IV: Payroll: Employees & Pay Heads Creation, Income Tax, EPF & ESI Compliance, Payroll Vouchers, Increment & Arrears, Pay Slips & Statutory Reports.
Advantage: Tally is the most popular accounting software in the world. In India, Accounting is done using Tally in most of the Government Departments and Corporate world. Expertise in Tally is the guarantee of success.