EIFA-CERTIFIED
FINANCE PROFESSIONAL (CFP)

COMPUTER OPERATING & MANAGEMENT

Logical Functions, Data Management:- 

Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality

​

Analysis:- 

Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table

​

Lookup and Reference Functions:-

Retrieve approximate matched value instead of position, find the value in the last non-empty cell in a row or column, etc.

How to retrieve the value at the position returned by MATCH & INDEX function?

How to map cell values directly to cell ranges

Retrieving value, based on a text string.

Mathematical Functions, Text Functions and Data Validation, Date & Time Functions:-

Storing and manipulating dates and times in Excel, inserting days and months to particular dates; create dynamic date-based fields; and perform complex time-based calculations.

Mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

Advanced Chart, Graph and Dashboard:- 

Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table

Advanced Sort &Filter, Validation and Pivot Table:- 

Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split.

Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

​

INDUSTRIAL CORPORATE ACCOUNTING

• An overview of Indian GAAP(Generally Accepted Accounting Principles) and Indian AS and its applicability on Finalization of accounts.

• Real World demo of Grouping of Heads of income and expenses through trial balance.

• Analysis of Balance Sheet and its components as per Revised Schedule of Companies Act 2013.

• Logical Process of preparing balance sheet on Excel of a company registered under companies Act.

• Comparative Analysis of provisions of Depreciation in Income Tax Act and Companies Act.

• Bank Reconciliation Statement and its importance for finalization.

• Year End Adjustment entries, Deferred Tax.

• Practical demo on linking skill of cells in Excel and preparation Financial Statement on multi excel sheet with its other component.

• Financial Analysis (how to read the financial accounts of a Company – important ratio analysis)

Tally Prime PLUS+

Accounting with GST in Tally Prime

• Tally Gateway and its elements

• Company formation

• Working in Accounts Master in Tally Prime

• Finalizing and reporting of various accounts books and financial statement

• Working in Inventory Masters & Inventory Vouchers in Tally Prime

• Generating Inventory Books and Reports

• Introducing BOM – Bill of Materials

• Setting Up GST Rates for Your Company

• Working in Inventory items with effect of GST

• Updating Party GSTIN

• Creating GST Ledgers

• Other Scenarios

• Sales – Nil Rated, Exempt, SEZ, and Deemed Export

• Working in Debit Note & Credit Note

• Cost Accumulation & Cost Management

• Recording Direct Cost & Indirect Cost

INVENTORY MANAGEMENT & ACCOUNTING

• Management Reports

• Aging stock Analysis

• Batch-wise or lot-wise Inventory with Expiry

• Re-Order Levels

• Stock categories

• Multiple godowns

• Stock transfers to Locations/godowns

INDIRECT TAX LAWS

Overview of Model GST Law

• Overview of Indirect Taxes & GST

• Important Definitions under GST

Registration Structure under GST

• When GST is required?

• Voluntary registration & compulsory registration

• Guidelines and principles in the process of Registration under GST

• Amendment &Cancellation of Registration.

• Various Forms for GST Registration

• Practical case study of registration under GST from virtual documents.

GST charging sections

• How GST is charged?

• When GST is charged?

• Where GST is charged?

• On which goods & services GST will be charged?

• Exempted services

Input Tax Credit - Section 16-21 with GST Rules

• Eligibility and Conditions for taking ITC (Section-16)

• Rules regarding Block Credit (Section-17)

• Availability of Credit in Special Cases (Section-18)

• Guidelines of ITC for Job Work (Section-19)

• ITC Distribution by ISD (section-20)

Time of supply of Goods & Services

Place of supply of Goods & Services

Valuation of supply of Goods & Services

GST bills / E-Way bills / Accounts & records to be maintained in GST

• How to generate E-way bills?

• Concepts of HSN code, Turnover and many more…..

• Journal entries of adjustment of ITC and many more……

Returns under GST Section (37-48) with GST Rules and Formats

• Overview on return filing procedure, rules & formats

• Types of Returns. (Annual Return, First Return, Regular Return)

• Regulations & Actions for Return Defaulters.

• Levy of Late Fee.

• Various Return Form (GSTR-I, II ,III, 3B)

DIRECT TAX LAWS

Overview of IT law

How to apply PAN card

Practical cases of applying PAN card

COMPUTATION OF INCOME UNDER VARIOUS HEADS OF INCOME

Computation of income from Salary

• Computation of  Salary

• Valuation of salary concerning Allowances (Exempted and Non Exempted) and Perquisites

• Practical case studies of filing various IT returns for salaried person

Computation of income from House Property

• How to compute income from House Property

• Standard Deduction

• Interest on borrowed capital

• Practical case studies of filing various IT returns with income from House Property

Computation of income from Profit and Gains from Business Profession

• Expenses Allowed and Expenses Disallowed

• Rules regarding Depreciation and Additional depreciation

• TDS Compliances and computation of business income

• Set off and carry forward of Business Loss

• Carry Forward of unabsorbed depreciation

• Practical case studies of filing various IT returns under income from Business & Profession

Computation of income from Capital Gain

• Introduction To Capital Assets, Holding Period and Transfer

• Full Value Consideration, Cost of Acquisition

• Capital Gain on Transfer of Shares and Debentures

• Different Rates of Taxes on Capital Gain

• Exemption under section 54, Set off and Carry Forward of capital loss

• Practical case studies of filing various IT returns under income from Capital Gain

Computation of income from Other Sources

• Income liable under other Sources

• Deduction Available

• Practical case studies of filing various IT returns under income from other sources

INCOME TAX RETURN PREPARATION

E-filing & uploading of various returns

Tax planning

Various deductions & rebate to save tax with Practical case studies

PLANNING & COMPUTATION OF INCOME TAX

• Tax Planning by Understanding Your Pay slip

• Objectives of Tax Planning

• Types of Tax Planning

• Results  of good tax planning

E-COMMERCE ACCOUNTING

• Place of Supply for E-Commerce

• Digital goods such as E-Books& its Invoicing

• How does an e-commerce sale work?

• E-commerce benefits both customers and sellers

• Registration Procedure under GST for E-Commerce

• Issues faced by the E-Commerce Sector in present scenario

• GST Return Filing for E-Commerce

​

BANKING AND FINANCE 

• Introduction to Banking

• Retail Banking

• Wholesale Banking

• KYC Norms

• How to Get Various Types of Loan Like CC, OD, Housing Loan, Mortgage Loan Etc.

• Project Analysis

• Risk Management

• MIS Reporting

• Record Keeping of Banks

• Project

​

INSURANCE

• Overview

• Life Insurance

• General Insurance

• Health Insurance

• Reinsurance

• How to Start Insurance Business

​

Advance Excel

• Advance Number Formatting

• Advance Conditional Formatting

• Match & Index

• Financial Functions

• Array Formulas

• Power Pivot

• Power View

• Power Map

• Power Query

• Dashboard 

• Macro

• Google Drive

• VIVA

​

Advance Accounting

• Accounts Reconciliation

• Bank Reconciliation

• Advanced Journal Entries

• Ledger Scrutiny

• Accounts

• Finalisation

• Company Final Accounts

​

Formation of Society & Trust

• Overview of Society & Trust

• Rules & Regulations of Society & Trust

• Co-Operative Society

• Charitable Society

• Registration of Society & Trust

• Retirement or Joining of a Member & Trustee

• How to Make Changes 

• Public Trust

• Charitable Trust

• Project

​

ESI & Provident Fund

• Basic Concept of ESI & PF

• Applicability

• Employees Contribution

• Employer's Contribution

• Methods of Payment 

• Maintenance of Register under ESI & PF

• Returns

• Penalties

• Benefits to Employee & Their Family

• Exemptions 

• Project

​

Business Communication & Interview Preparation

• Resume Building

• Workplace Etiquette

• Interper-Sonal Skills

• E-mail Etiquette

• Interview Skills

• Goal Setting & Time Management

​

Personality Development

• Meeting People

• Asking Questions

• Holidays Getaway

• Food for thought

• Making Friends

• Buying Things

• Home Improvement

• Know Your Planet

• Better Than the Best

• Leisure Time

• Who's This

Duration:-
Maximum 12 Months