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.