EIFA-CERTIFIED

FINANCE PROFESSIONAL (CFP)

PROFESSIONAL SKILLS IN COMPUTER

​

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:-

VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup

 

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

Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.

 

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 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

​

 COMPANY ACCOUNTS

• GST  accounting considering Intrastate supplies , Interstate supplies of goods & services

• Accounting of different forms of organizations (sole proprietorship firm , Partnership firm & other than companies)

• Opening and closing entries accounts

• Detail study of depreciation under Income Tax act, 1961

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

 

ADVANCED TALLY ERP 9

• Introducing Gateway and its elements

• Creation of Company

• Fundamentals of Tally ERP 9

• Create Accounting Masters in Tally ERP 9

• Financial Statements and Accounting Books and Reports

 

Tally ERP 9 and Inventory Management

• Creating Inventory Masters in Tally ERP 9

• Inventory Vouchers

• Generating Inventory Books and Reports

• Introducing BOM – Bill of Materials

• Accounting with Inventory

 

Production and Stock Management through Tally ERP 9

• Multiple Price Level

• Batch – wise Details

• Bill of Materials (BoM)

• Price Levels and Price Lists

• Stock Valuation

• Zero Valued Entries

• Job Costing, Job Order Processing

 

Payroll Management in Tally ERP 9

• Generation of Employee Database

• Salary Structure

• Calculation Attendance and Leave Details

• Salary Slip Generation

• PF, ESI, Gratuity Bonus

• Professional Tax

• Various Payroll Reports

 

Tally ERP 9 and GST Compliance

• Activating GST for Your Company

• Setting Up GST Rates

• Updating Stock Items and Stock Groups for GST Compliance

• Updating a Services Ledger for GST Compliance

• Updating Sales and Purchase Ledgers for GST Compliance

• Updating Party GSTIN

• Creating GST Ledgers

• Creating Income and Expense Ledgers

• Recording Purchases & Sales and Printing Invoices

• Recording a Tax Payment

• Other Scenarios

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

• Recording Sales Returns & Purchase Returns

• Debit Note & Credit Note

 

Cost Centres and Cost Categories

• Cost Accumulation

• Defined cost unit

• Cost Management

• Direct Cost Vs Indirect Cost

 

Budget and Controls

Banking

Multiple Currencies

​

INVENTORY MANAGEMENT & ACCOUNTING

• Accounting inventory methods

• Specific identification method.

• Periodic and Perpetual Inventory Systems

• Inventory Counting and Reconciliation

• Overhead Allocation

• Inventory Transactions

• Inventory Controls

• Inventory Budgeting

• Inventory Measurements

• Recall the classifications used for inventory.

• Note the characteristics of the different types of inventory fraud.

• Describe the situations in which inventory errors can lead to material misstatements.

• Describe the substantive procedures used by an auditor to audit inventory.

• Recognize the items to be reviewed as part of an inventory test count.

• Note the actions to be taken when testing inventory costs.

• Describe compilation testing.

• Cite the circumstances under which a physical inventory count can be avoided.

• Recall the details of the lower of cost or market rule.

• Note the advantages of the various inventory costing methods.

• Multi-location Stock Control

• Comprehensive Recording of Stock Movement

• 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

​

GST LAWS & CONCEPTS

Overview of Model GST Law

• Overview of Indirect Taxes & GST

• Important Definitions under GST

​​

GST Migration and Registration under Model GST Law with GST Rules and Formats

• Migration of Existing Dealer.

• Registration Structure under GST.

• Persons required to be registered.

• Process of Registration.

• Amendment & Cancellation of Registration.

• Forms for GST Registration

• GST REG-01- Application.

• GST REG-02- Acknowledgement.

• GST REG-06- Certificate.

• REG-01 to REG-30

​​

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

• Definition and Important Notes to Return.

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

• Notice to Return Defaulters.

• Levy of Late Fee.

• Goods and Services Tax Practitioners

• Various Return Form

• GSTR-I, II ,III, 3B

 

Refunds – Section 54-58 with GST Rules

• Refund of Tax (Section-54)

• Refund in Certain Cases (Section-55)

• Interest on Delayed Refunds (Section-56)

• Consumer Welfare Fund (Section-57)

• Utilization of Fund (section-58)

 

Input Tax Credit - Section 16-21 with GST Rules

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

• Block Credit (Section-17)

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

• ITC for Job Work (Section-19)

• ITC Distribution by ISD (section-20)

 

Job Work and Composition Levy in GST

• Special Provision for Job Worker

• Composition Levy Section 10

• Quarterly Return for Compounding Taxable Person GSTR-4

 

Other Topics - with GST Rules and Formats

• Payment of Tax, Interest, Penalty and other charges Section 49

• Interest on delayed payment of tax Section 50

• Tax Deduction at source Section 51

• Tax Invoices Section 31

• Time and Value of Supply Section (12-15) Chapter IV

• Transitional Provisions Section (139-142) Chapter XX

• Identify E-Way Bill Generation Scenarios Under GST

• Identify -various movements which take place on daily basis

• Sale, purchase – goods sent for repairs, job work, sales return, purchase return, imports and exports

• Transactions with unregistered dealers etc.

• Fix Responsibility For E-Way Bills

• Agreements with business participants on roles/responsibilities

• Updating E-Way Bill in case of change in conveyance

 

Refund under GST

GST payment on due date & Interest on late payment of GST

 

Annual Return - GSTR-9

• Objective and Compliance of Annual Return

• Difference Between GSTR-9, GSTR-9A, GSTR-9B and GSTR-9C

• Who is required to file GSTR-9

• Challenges in filing GSTR-9

• How to meet those Challenges

• Understanding of 6 Parts and 19 Tables of GSTR-9

• Consequences of not filing GSTR-9

• Preparation of GSTR-9 filing

• Processing of GSTR-9 at Department and Post filing Scenario.

 

DIRECT TAX COMPUTATION

• Person V/S Assesse

• Advance Tax

• Interest under section 234A/B/C

• Gross Total Income and Its Components

• Computation of Income from eligible business under presumptive basis U/S 44 AD, 44 ADA, 44 AF

• Practical case study for filing various income tax returns u/s 44 AD, 44 ADA, 44 AE.

 

Computation of income from Salary

• Basic Salary

• Allowances (Exempted and Non Exempted)

• Perquisites –(Valuation)

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

 

 

Computation of income from House Property

• GAV

• Municipal Taxes

• NAV

• Deduction u/s 24 (Statutory and Interest)

• 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

• Depreciation and Additional depreciation

• TDS Compliances and computation of business income

• Expenses allowed on actual basis

• Deemed income, Presumptive income

• Set off and carry forward of Business Loss

• Carry Forward of unabsorbed depreciation

• Maintenance of Books of accounts, Audit of Books of accounts

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

 

Computation of income from Capital Gain

• Charging Section

• Intro To Capital Assets, Holding Period and Transfer

• Full Value Consideration, Cost of Acquisition

• Capital Gain on Transfer of Shares and Debentures

• 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

 

Deduction on The Basis Of Payment

• LIC,F.D, PPF, ELS, Tuition Fee, House Loan ,NPS, etc (Sec 80C/80CCC/80CCD/80CCE)

• Medical Insurance (Sec 80 D)

• Deduction under (80DD), (80 E), (80 EE), (80G), (Sec 80U)

​

• Other Deductions with practical case studies

​

INCOME TAX RETURN PREPARATION

• 2 ways to prepare Return and filing of Return

  • Filing of return through ITR Utility

  • Filing of Return through software

 

Compulsory maintenance of books of accounts & audit u/s 44 AA, 44 AB

 

Income Tax Return Preparation ITR-1, 2, 3, 4

Tax Deducted At Sources

• Introduction to TDS

• Related and other linked provision

• Lower TDS

• TDS on Salary (Sec 192), Interest (Sec 194A), Commission (Sec 194H), Professional Services (Sec 194J), Rent (Sec 194I), Contract (194C)

• Section 195 to be read with Section 9 for Non Resident

• Other provisions of TDS

 

 

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 LAWS & FINANCIAL MANAGEMENT

• Broad holistic understanding of the Banking & Finance industry

• Detailed knowledge about various banking products and services

• Master the skills and techniques for selling banking and financial products

• Analysis of the investment needs of customers and customize their portfolios

• Tools and Techniques of Financial Analysis using Excel

• How to manage customer relationships

• How to work in retail banking, corporate investing, consulting, private equity, venture capitalism

• Work as a Business Analyst, Finance & Insurance Manager, Business Risk Manager, Investment Banker or Finance Controller

• Bank Risk Management/ Financial Risk Management

• Banking Operations

• Corporate Valuation

• Financial Markets & Institutions

• Financial Product Design

• FOREX & Treasury Management

• International Finance

• Legal Aspects of Business

• Microfinance & Developmental Banking

• Securities Analysis & Portfolio Management

 

INSURANCE LAWS

• Overview of Insurance

• Principles & Aspects of Insurance

• Nature & purview of Insurance

• Documentation & classification of Insurance

• Financial aspects of Insurance

• Introduction to underwriting & claims

• Insurance agent’s role in providing great customer service

• The proposal stage - Acceptance stage - The claim stage - Grievance Redressal

• Integrated Grievance Management System (IGMS)

• Legal aspects of an insurance

 

EXCEL SKILLS FOR BUSINESS CERTIFICATION

• Learn how to resolve a range of business problems through this Microsoft Excel Training

• Easily learn how to perform calculations using functions and formulas, creating data visualization and navigating user interface of MS Excel

• A great opportunity to take your skills to new heights

• Upgrade your skillset and handle sales/billing tasks easily

• Help you to learn how to work multiple workbooks and worksheets

• Unlock Excel shortcuts and secrets through these Basic Microsoft Excel Classes

• Get familiar with powerful analytics formulas and tools for e.g. FILTERXML, WEBSERVICE, HYPERLINK and INDIRECT

• You will learn how to handle time-consuming analytics tasks with ease.

 

ADVANCED FINANCIAL ACCOUNTING & REPORTING

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

• 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.

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

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

• Accounting operations, patterns, merger of public holding companies

• Foreign currency operations, changing financial statement prepared in foreign and local currencies.

• Advanced financial accounting issues such as lease contracts, pension funds, end of service severance payments etc.

• Financial Reporting

• Strategy And Governance

• Management Accounting

• Audit And Assurance

• Finance

• Taxation

 

FORMATION OF SOCIETY & TRUST

• Conceptualization

• Forming the governing body

• Formulation of bylaws

• Registration of Society & Trust

• Fundraising

• Rules and regulations of the trust.

• Documents required to be submitted

• Charitable societies procedure

• Processes of application

• Memorandum of association 

& many more……

​

ESI & PROVIDEND FUND LAWS

• Eligibility for PF / ESI registration

• EPF registration procedure for employers

• Registration procedure of PF account

• Documents Required for PF Registration

• Documents Required for ESI account 

• Registration procedure of ESI account 

• Rules of ESI and PF Deduction in detail

• Deduction amount for both the employee and employer

& many more…….

 

FORMATION OF COMPANY

• Types of companies

• How to create a new company

• Memorandum and register the company

• Rules regarding issuing share capital, debentures, bonds etc.

• Company in Promotion Stage

• Registration or Incorporation Stage

• Capital Subscription Stage of company

• Commencement of Business Stage.

• How to Acquire Director Identification Number(DIN) ...

• How to Acquire Digital Signature Certificate DSC): ...

• How to Create  account on MCA Portal

 

BUSINESS COMMUNICATION SKILLS

• Workplace Etiquette

• Interpersonal skills

• E-mail Etiquette

• Interview skills

• Goal setting & time management

 

PERSONALITY DEVELOPMENT

• Meeting people

• Asking questions

• Holiday getaway

• Food for thought

• Making friends

• Buying things

• Home improvement

• Know your planet

• Better than best

• Leisure time

Duration:-

Maximum 12 Months