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