COURSES

Files

(DICA)

Diploma in Pro Accountant

The Diploma in Pro Accounting Course is a 15-months program designed for students who desire to specialize in accounting and taxation. Students having a thorough understanding of GST and income tax are given priority by corporates these days. We focus on providing hands-on training that meets industry standards.

Module 1 : Introduction to Computer Applications

Module 2 : Advance Excel

Module 3 :Corporate Accounting

Module 4 :Tally Prime, Payroll, TDs, GST

Module 5 : Goods & Services Tax Law (GST), GSTR

Module 6 : Income Tax with TDS Filing

Module 7 : Banking and Business Law

Module 8 : BUSY

Module 9 : Interview Preparation

(CIPA)

Certificate in Pro Accountant

The Certificate in Pro Accounting is an 8 months program designed for students who desire to specialize in accounting and finance courses. Those who are proficient in Advance Excel and Tally Prime have a better chance of being hired these days. Hands-on training that meets industry standards is extremely important to us.

Module 1 : Introduction to Computer Applications

Module 2 : Advance Excel

Module 3 :Corporate Accounting

Module 4 :Tally Prime

"Module 1: Basic Computer (2 Months)"

Introduction to computer:

Types of Computer, Basic Computer Hardware & Software, Operating System, Trouble Shooting, Internet & Its Applications.

MS Paint:

Clipboard, Images Editing, Tools, Shapes, View tab.​

MS Word:

Formatting Text, Editing Images, Shapes & Charts, Hyperlink, Print and set-up, Watermark, Insert, Smart Art, Charts, Design.​

MS Power point:

Design, Transitions, Animation, Slide Show, Review Tab, Automatic PPT creation, PPT Enhancement Tools.​

MS Excel:

Basic Excel Interface, Excel Cell, Name Range, Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, Insert Formulae, Syntax, Charts.

Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, +, -, *, /,

 

Advance Excel

  • MIS Reporting,

  • Preparation of Final Accounts on Excel,

  • GSTr-2A Reconcilation,

  • TDS Reporting,

  • Maintaining Payroll

  • Custom & conditional Formatting, Data Validation, Advance Formulae like​

  • Text Function:   LEFT, RIGHT, MID, FIND, SEARCH, LEN, UPPER, LOWER, PROPER, REPLACE, SUBSITUTE, REPT, CONVERT, TRIM, TRUNC, CONCATENATE.​

  • Logical Function: IF, Nested IF, AND, OR, XOR, TRUE/FALSE.​

  • Date & Time Function: DATE, DAY, SECOND, MINUTE, HOUR, MONTH, YEAR, NOW, TODAY (), NETWORKDAY, NETWORKDAY.INTL

  • Information Function: INFO, CELL, ERROR, TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISODD, ISTEXT, ISNUMBER, ISNONTEXT, TYPE.

  • Database: DSUM, DMAX, DMIN, DAVERAGE, DGET, DCOUNT, DCOUNTA.

  •  

  • Statistical Function: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, FORECAST, COUNTA, COUNTBLANK, MAXA, MINA, AVERAGEA.​

  • Lookup & Reference Formulae: VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE, OFFSET, ROW, COLUMN​

  • Excel Tools: Auditing Tools, Flash Fill, Remove Duplicates, Go To, Hyperlinks.​

  • Excel Table & Charts: Changing table styles, Formatting, Charts, Adding to​

  • Pivot Tables, Charts & Dashboards: Creating Pivot table, Adding Fields, Adding Labels, Swapping Data, Changing Designs, Pivot Refresh, Summary, Subtotals, DASHBOARD Creation, Designing Report Creation. Workbook Protection, Running & Recording Macros, Goal Seek

 

"Module 2: Fundamentals of Accounting (2 Months)"

  • Accounting Concepts,

  • Golden Rules of Accounting,

  • Journal & Ledgers Creation,

  • Subsidiary books,

  • Rectification of Errors,

  • Bills of Exchange,

  • Depreciation,

  • Final Accounts of Sole Proprietorship,

Advance Accounting

  • Depreciation as per Schedule-II of Companies Act,2013,

  • Preparation of Final Accounts of Companies, As per Schedule-III of Companies Act,2013,

  • Accounting Standards.

 

"Module 3: TallyPrime (Latest Version) (3 Months)"

  • Introduction to TallyPrime,

  • Company creation

Accounts Management in TallyPrime

  • Groups & Ledger Creation,

  • Inventories Creation,

  • Voucher Entries,

  • Interest Calculation,

  • Cost Centres,

Inventory Management in TallyPrime

  • Stock Groups and Stock Group items Creation,

  • Godown Creation,

  • Inventory Voucher Entries

Taxation in TallyPrime

  • Enabling GST in TallyPrime,

  • Basic Concepts of GST,

  • Advance Transactions having CGST, SGST, IGST,

  • Advance GST Adjustments,

  • Enabling TDS/TCS in Tally.ERP9,

  • Basic Concepts of TDS,

  • Transactions of TDS/TCS in Tally.ERP9

Payroll Management in TallyPrime

  • Employees & Pay head Creation,

  • Basic Concepts of EPF, ESIC and EDLI,

  • Employees Salary Creation

Advance Topics in TallyPrime

  • Splitting Company Data,

  • Company Logo.

 

Backbone of Every Industry

 

"Module 4: Goods & Service Tax (GST) (2 Months)"

  • Basic Overview of CGST Act, 2017,

  • SGST Act, 2017,

  • IGST Act, 2017,

  • UTGST Act, 2017,

  • GST Rules,

Registration under GST

  • GST REG 01,

  • Registration as GST Practitioners,

CGST Law, SGST La,  IGST Law & UTGST Law

  • Important definition,

  • Determination of nature of supply,

  • Zero rated Supply,

Composition Scheme

  • Registration under composition scheme,

  • Rates under composition scheme,

Input Tax Credit

  • Eligibility and Condition for taking ITC,

  • ITC for Job Work,

Returns

Types of Returns,

  • Annual Returns,

  • First Return,

  • Regular Return,

  • GSTr-1,

  • GSTr-2A (Auto filled),

  • GSTr-3B,

  • Interest, Late Fees, Offences.

"Module 5: Income Tax (3 Months)"

Income Tax under various heads

  • Income Under Salary,

    • Allowances,

    • Perquisites,

  • Income under House property,

  • Income under PGBP,

  • Income under Capital Gains,

  • Income under other sources.

Clubbing of Income

Deduction u/s 80C to 80U Computation for Income Tax Apply for PAN

Income Tax returns – ITR Forms

  • ITR – 1 (SAHAJ),

  • ITR – 2,

  • ITR – 3,

  • ITR – 4 (SUGAM),

Tax Deducted at Sources – TDS

  • TDS on Salary,

  • TDS on other than Salary,

  • TDS Returns (24Q and 26Q),

 

"Module 6: Banking and Business Laws (1 Month)"

Banking

Types of Accounts

  • Current Accounts

  • Saving Accounts

Banking Forms

Money Transfer

  • RTRG

  • NEFT

  • IMPS

  • Demand Draft

Loans

  • Short Term Loans

  • Long Term Loans

Investment Options

  • Fixed Deposit (FD)

  • Recurring Deposit (RD)

  • Public Provident Fund (PPF)

  • Mutual Funds

Interest Calculation

Bank Reconciliation

Internet Banking

Business Laws

  • Indian Contract Act, 1872

  • Negotiable Instruments Act, 1881

  • Sales of Goods Act, 1930

  • Indian Partnership Act, 1932

 

"Banking Seminar" Conducted at IPA Studies with Different Banks 

"Module 7: Busy Accounting Software (1 Month)"

  • Financial Accounting (Multi-Currency)

  • Inventory Management (Multi-location)

  • Production / Bill of Material

  • Sales / Purchase Quotations

  • Sales / Purchase Order Processing

  • Fully User-configurable Invoicing

  • User-configurable Documents / Letters

  • User-configurable Columns in Reports

  • GST Invoicing & Reports

  • TDS & TCS