(Duration : 12 Months)
Certified Professional Accountant program aims to develop student into a complete accountant, working on accounting related software on computers. This program basically caters to Commerce graduates as well as people who are interested to make career in computerized accounting. The minimum qualification required for enrolment in this program is HSC. The program has modular pattern of teaching and examination.
Professional Corporate Accountants, Tally Professional, Account Assistant, Tax Process Executive, Teaching Professional for Tally and Taxations, Jobs in Stock Market, Self-
Employment in Tally – GST Work.
MODULE 1 – Certificate Course in Operating System & Application Management
- Windows. Multimedia & E-Commerce, Ms Outlook
- Networking Concepts, Ms Word, Ms Access (Basic Level)
- Computer Viruses And Internet, Ms Excel
- Utility of Computers to Business, Ms PowerPoint
MODULE 2 – Certificate Course in Advance Excel
Introduction To Excel, Introduction to Excel Environment, Explanation about data calculation in excel, Use of shortcuts, Formatting and Conditional Formatting working with Formulas-logical and Text Function, Understanding about Sorting, Filtering & Data Validation Data Analysis using Pivot Tables Introduction to Charts & Functions Understanding of Mathematical, Statistical Function Worksheet and Workbook Protection and Security Understanding of Name Ranges Introduction of form Controls Understanding of Data Tools Panel Basics of Macro Recording Dashboard Designing Overview of Dashboards Deciding on Dashboards Trends and Scenarios Using Charts Advanced Charting techniques Using Thermometer. Doughnut, Pareto, Panel and Step Charts Designing Sample Dashboard Using Form Controls Tips and Tricks to enhance Dashboard Designing.
MODULE 3 – Computerized Accounting Using Tally Prime
Accounting Concepts / Accounting Principles / Golden Rules of Accounting / Account Fundamentals /Charts of Accounts. Accounting Masters / Inventory Masters / Units of Measures / Accounting & Inventory Vouchers / Purchase & Sales /Receipt & Payment / Contra & Journal / Debit Note & Credit Note / Stock Journal & Physical Stock / Stock Summary / Trial Balance / Profit & Loss Account / Balance Sheet.
Interest Calculations / Stock Categories / Order Processing / Batchwise Details / Manufacturing Journal Additional Cost -of Purchase / Multiple BOM / Voucher Class / Budgets and Controls / Credit Limit / Cost Center & Cost Category. Multiple Currencies / Stock Valuation Methods / Bank Reconciliation Statement / F11-Features / F12-Configuration. Security Controls and Tally Vault / Tally Audit / Financial / Inventory Reporting / Printing from Tally.
Scenario Management / Optional & Post Dated Vouchers / Reversing Journal / Price List / Simple & Compound UOM / Export of Data / Import of Data / Export Formats / ODBC in Tally / Consolidation & Split of Accounts / Company Logo-Printing / Bill Settlement / Receipt and Payment Statement / Web Browser / E-mail & Uploading / Backup& Restore / Multi Linguistic Features.
Statutory Info / Exception Reports / Statistics / Cash Flow and Funds Flow / Intro. to GST & Model of GST / GST Classification / GST Master / Stock Creation / GST Different Tax Rate / GST Invoice / GST report / GST Challans / Returns / TDS (Tax Deducted at Source / TCS (Tax Collected at Source) / POS (Point of Sale) / Payroll / Income Tax / Advance Banking Features / Setting Up Tally / Migrating Data / Advance Configurations in Tally.
MODULE 4 – Certificate Course in Tax Administration (Subject to Change)
Introduction to Income Tax Act / Permanent Account Number (PAN) / Income Tax Department Online Features Income Tax Return Forms / E-Filling Features of Income Tax / T.D.S. (Tax Deducted at Source) ITR Filing / Goods & Service Tax Law (GST) / GST Registration & Returns / Reverse Mechanism under GST E-Way Bill / Payment and Refund under GST / GST in TallyPrime / Exercise MODULE 5 – CERTIFICATE COURSE IN BANKING & BUSINESS MANAGEMENT Basics of banking / banking practises & procedures.