EIFA-CERTIFIED

PROFESSIONAL ACCOUNTANT (CPA):

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 ERP 9 PLUS+

Accounting with GST in Tally ERP 9
  • Tally Gateway and its elements

  • Company formation

  • Working in Accounts Master in Tally ERP 9

  • Finalizing and reporting of various accounts books and financial statement

  • Working in Inventory Masters & Inventory Vouchers in Tally ERP 9

  • 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

Duration:-

Maximum 6 Months

  • YouTube
  • Facebook
  • Twitter
  • LinkedIn

EDUHOME INSTITUTE

3rd Floor, Above Indian Overseas Bank, Cemetery Road,Fountain Chowk, Civil Lines, Ludhiana, Punjab 141001

©2020 by Eduhome