"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

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.

"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