FD-FAB F-TEC Diploma in Finance & Banking

(Training Duration: 12 Months (576 Hours))

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 ERP 9. 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. This is a F-TEC Certified program which leads to One Year F-TEC Diploma.

Module – 1

Manual Accounting

  • Commonly Accepted Accounting Principles
  • Book Keeping

MS Excel

  • Introduction to MS-Excel Interface
  • Navigating Around in an Excel Spreadsheet
  • Working on Simple Calculations
  • Functions; Organize & Process Statistical, Mathematical, Financial & Logical Data
  • Link Worksheets
  • Using Data Tab; Organize, Analyze & Present Data for various purposes
    • Filtering
    • Grouping
    • Sub-Totalling
    • Consolidate
  • Perform “what-if” & Data Analysis for Developing Financial & Marketing Plans
    • Scenario
    • Goal Seek
    • Data Table
  • Tools & Techniques to Process & Enhance the Usefulness of Data
    • Data Validation
    • Conditional Formatting
  • Using PivotTable for Tabulating & Managing Data
  • Translating Data Analysis into Meaningful Charts & Graphs
  • Sheet Protection
  • Printing Techniques

Functional Communication

  • Understand the Importance of Effective Communication
  • Verbal Communication – Smart Talk
  • Communicate Effectively Over Telephone
  • Write Right – Thumb Rules
  • Office & Business Correspondence

 

Module – 2

Computerized Accounting Using Tally ERP 9
Basic Concept of Tally ERP9

  • Creation, Modification, Deletion, – Company Group & Ledgers.
  • Company Merging & Splitting

Banking Process in Tally ERP9

  • Cash & Bank Transaction in Tally

Working in Tally

  • Handle different types of vouchers and recording of transactions
  • Inventory Management – Create and maintain inventories
  • Maintain bills/invoice details and track receivables and payables
  • Create and maintain cross-centres & budget
  • Understand and apply funds flow & cash flow statements
  • Ratio analysis & compute commonly used ratios
  • Analyze financial statements
  • Maintain data accuracy, consistency & backups

Personality Plus

  • Personality Enhancement & Personal effectiveness for good impressions

Module – 3

Payroll Process

  • Creating Payroll Masters
  • Processing Payroll – Attendance & Payroll Vouchers
  • Accounting for PF, ESI Contribution
  • Generating Payroll Reports
  • EPF, TDS on Payroll Process

Work Readiness

  • Planning & Organizing
  • Decision Making
  • Time Management

Introduction to Marg / BUSY

 

Module – 4

Taxation

  • Understand Taxation
  • TDS, PAN, TAN etc.
  • Understand GST, TDS

E-Filing of Taxes

  • Implement GST in Tally. ERP 9
  • Process of E-File GST Returns Generate
  • Reports in GST
  • Process of E-File TDS Returns
  • Generate TDS reports & Challans

Security & Data Management 

  • Tally Vault – Implement Security of Financial Transactions
  • Data Management/Data Backup & Financial Year End Process in Tally. ERP 9

Interview Plus

  • Preparing for Interview
  • Resume Preparation
  • Mock Interviews

Project Work