top of page

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

 

Maximum Duration:-
6 Months, 90 Minutes Class

bottom of page