CERTIFICATE IN PROFESSIONAL ACCOUNTING ( PA )

Module – 1

Manual Accounting

o    Commonly Accepted Accounting Principles

o    Book Keeping

MS Excel

o    Introduction to S-Excel Interface

o    Navigating Around in an Excel Spreadsheet

o    Working on Simple Calculations

o    Functions; Organize & Process Statistical, Mathematical, Financial & Logical Data

o    Link Worksheets

o    Using Data Tab; Organize, Analyze & Present Data for various purposes

o    Filtering

o    Grouping

o    Sub-Totalling

o    Consolidate

o    Perform “what-if” & Data Analysis for Developing Financial & Marketing Plans

o    Scenario

o    Goal Seek

o    Data Table

o    Tools & Techniques to Process & Enhance the Usefulness of Data

o    Data Validation

o    Conditional Formatting

o    Using PivotTable for Tabulating & Managing Data

o    Translating Data Analysis into Meaningful Charts & Graphs

o    Sheet Protection

o    Printing Techniques

Functional Communication

o    Understand the Importance of Effective Communication

o    Verbal Communication – Smart Talk

o    Communicate Effectively Over Telephone

o    Write Right – Thumb Rules

o    Office & Business Correspondence

Module – 2

Computerized Accounting Using Tally Prime
Basic Concept of Tally Prime

o    Creation, Modification, Deletion, – Company Group & Ledgers.

o    Company Merging & Splitting

Banking Process in Tally Prime

o    Cash & Bank Transaction in Tally

Working in Tally

o    Handle different types of vouchers and recording of transactions

o    Inventory Management – Create and maintain inventories

o    Maintain bills/invoice details and track receivables and payables

o    Create and maintain cross-centres & budget

o    Understand and apply funds flow & cash flow statements

o    Ratio analysis & compute commonly used ratios

o    Analyze financial statements

o    Maintain data accuracy, consistency & backups

Personality Plus

o    Personality Enhancement & Personal effectiveness for good impressions

Module – 3

Payroll Process

o    Creating Payroll Masters

o    Processing Payroll – Attendance & Payroll Vouchers

o    Accounting for PF, ESI Contribution

o    Generating Payroll Reports

o    EPF, TDS on Payroll Process

Work Readiness

o    Planning & Organizing

o    Decision Making

o    Time Management

Module – 4

Taxation

o    Understand Taxation

o    TDS, PAN, TAN etc.

o    Understand GST, TDS

E-Filing of Taxes

o    Implement GST in Tally. Prime

o    Process of E-File GST Returns Generate

o    Reports in GST

o    Process of E-File TDS Returns

o    Generate TDS reports & Challans

Security & Data Management 

o    Tally Vault – Implement Security of Financial Transactions

o    Data Management/Data Backup & Financial Year End Process in Tally. Prime

Interview Plus

o    Preparing for Interview

o    Resume Preparation

o    Mock Interviews

Project Work

This is a comprehensive program, which covers a wide range of topics to make the learner become employment ready in Banking and Finance Sector. Besides equipping the learner on accounting principles, MS Excel and BUSY; it helps the learner develop in depth knowledge and skills in Tally Prime. This program helps the learner explore Tally not just as a basic accounting package, but as a complete business management tool by covering advanced concepts like payroll management and taxation including GST through Tally. It also emphasises on building mandatory soft skills and interview handling skills.