WORDPAD
MS WORD
MS POWER POINT
MS EXCEL
INTERNET

Advanced Excel

STATICAL FORMULAS
AVERAGEA
MAXA
MINA
COUNTA
LARGE
SMALL
MEDIAN
MODE
RANK
COUNTIFS
AVERAGEIFS
SUMIFS
FORECAST
FREQUENCY
MATHS & TRIG
ABS
MAXA(A1,0)
MIN(A1,0)
IF(A1>0,A1,””)
IF(A1<0,A1,””)
SUMIF(A1:A9,”>0”)
SUMIF(A1:A9,”<0”)
FACTDOUBLE(5)
FACTDOUBLE(6)
SUBTOTAL
SUMPRODUCT
DATABASE FORMULAS
DSUM
DAVERAGE
DPRODUCT
DMAX
DMIN
DCOUNT
DCOUNTA
DGET
SUMSQ(3,4)
CONVERT
ERROR.TYPE
DATE TIME FORMULAS
DAY
MONTH
YEAR
DATE
HOUR
MINUTE
SECOND
TIME
DAYS360
NETWORKDAYS.INTL
YEARFRAC
WEEKDAY
WEEKNUM
EDATE
EOMONTH
WORKDAY.INTL
DATEVALUE
TIMEVALUE
LOGICAL FORMULAS
IF (OK PENDING)
IF(A2=A1)
IF(STD LOCAL)
IF(TRUE)
IF(FALSE)
AND
OR
NOT
TEXT FORMULAS
CHAR
CODE
CLEAN
REPLACE
SEARCH
T
TEXT
VALUE
INFORMATION FORMULAS
ISBLANK
ISERROR
ISEVEN
ISODD
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISTEXT
ISREF
CELL
INFO
N
LOOKUP FORMULAS
ADDRESS
CHOOSE
HYPERLINK
TRANSPOSE
COLUMN
COLUMNS
ROW
ROWS
INDEX
OFFSET
MATCH
INDIRECT
LOOKUP
VLOOKUP (COLUMN)
VLOOKUP (MATCH)
INDEX (MATCH)
OTHER SHEET VLOOKUP
OTHER BOOK VLOOKUP
VLOOKUP (MAX)
VLOOKUP (MIN)
VLOOKUP (MEDIAN)
VLOOKUP & MATCH
VLOOKUP (0,1 USE)
HLOOKUP
FINANCIAL FORMULAS
RATE
NPER
PV
IPMT
PPMT
CUMPPMT
CUMIPMT
DB
SLN

Basic Accounts

Accounting Terms

Accounting Concepts and Principles

Type of Accounts

Golden Rules of Accounting

Journalizing and Posting of Transactions

Recording of Business Transaction

Transactions in Books of Original Entry

Tally Prime 

Getting Started with Tally Prime
 Company Creation / Shut / Open / Alter etc.
 Company Features and Configuration
 Company Security
 Ledgers – Create – Display – alter
 Groups – Create – Display – alter
 Deleting Groups and ledgers
 Inventory Management
 Godowns
 TDS
 TCS
 Point of Sale
 Bill of Material
 PDC
 BRS
 Budget
 Discount Column Separate
 Cost Centre
 Export & Import
 Password
 Backup
 Split Company
 Description for sale/ purchase
 Decimal
 Invoice number change
 Payroll
 Credit Limit
 Cheque Printing
 Memorandum
 purchase Order
 Price Level
 Allow Zero Value
 Standard Rate
 Actual & Billed
 Batch Wise
 Interest Calculation
 Additional Cost of purchase
 Optional voucher
 Print Copies
 Alternate Unit
 Cancel Entry
 Duplicate Entry
 Suspense A/C
 Negative Ledger
 Negative Stok
 Filter
 Period

GST

 Purchase GST
 Sale GST
 GST Payable
 IGST Purchase
 IGST Sale
 Service Tax
 Service Tax Particular Mode
 Slab Rate
 Nil Rate
 Both GST
 Advance Receipt
 Import
 Export
 GST Classification
 Round Off
 Composition
 URD
 Freight Charge
 Debit/credit note
 B2C
 Currency
 Bank Details
 Bank Charge
 Item and Service
 Logo
 Tally in Pen Drive
 ITC
 MRP

Busy Accounting Software

Marg Accounting Software

GST RETURN

1. GST – Introduction of GST / GST Rates
 Purchase
 Sales
 Debit Note
 Credit Note
 Input Rules
 RCM ( Reverse Charge Mechanism)
Applicability of Law Based On Turnover
Upto 5 Crore More than 5 Crore
Online Demo GST Return
 GSTR 1
 GSTR 3 B
 GSTR 2 A
 GSTR 3 B
Reconciliation of GST Return with Books
 GST Registration
 GST Payment
 TCS Return

 INCOME TAX

 Direct Tax & Indirect Tax
 Sources of Income Tax Law in India
 Basic principles for charging Income Tax
 Assessment Year / Previous Year / Assesse
 Heads of Income
 Income from Salary
 Income from Profits and Gains of Profession or Business
 Income from Capital Gains.
 Income from Other Sources.
 Gross Total Income
 Determination of Residential Status
 Hindu Undivided Family (HUF)
 Definition of Salary
 Computation of Salary
 Gratuity / Leave Salary Encashment
 Perquisite / Leave Travel Concession
 Provident Fund / Standard Deduction
 Meaning of Business & Profession
 Filling of Income Tax Return
 Tax Deduction at Source (TDS)
 Advance Tax
 Self Assessment Tax
 Tax Payment
 Audit Rules
 Computation of Income and the Process
Followed Capital Gain – Basic Knowledge
Depreciation Calculation as per Income Tax & Companies Act

PAYROLL ACCOUNTING
 Payroll Management
 Definition of an Employee
 Employee Time Tracking
 Employee Compensation
 Employee Compensation
 Employee Benefits
 Creation of Employee & Employee Group
 Attendance / Production types
 Creating Payroll units
 Payroll Deductions
 Payroll Taxes
 Tax Remittances
 Unemployment Taxes
 Payments to Employees
 Accounting for Payroll
 Payroll Reports
 Payroll Record Keeping
 Payroll Procedures
 Payroll Controls

Provided Fund (PF) Compliance
 PF Employer
 Employee
 Mandatory Information of Compliance

ESIC (Compliance)

BANK RECONCILIATION & DAILY BANKING WORK
 Online Payment
 NEFT
 RTGS
 Draft / Pay order

Latest updates
 GST
 Income Tax
 PF
 ESI etc
Knowledge of Different Industry and different Applicable Laws.

TDS RETURN
 Basic Concepts of TDS
 TDS in Tally Prime
 Recording Transactions
 Accounting for TDS on Advance Payments
 TDS on Expenses at Lower Rate
 TDS on Expenses at Zero Rate
 Deducting TDS on Payments
 Reversal of Expenses with
 TDS Reports
 Challan Reconciliation
 TDS Outstanding
 E-Return

TRADEMARK
 Trademarking a Brand Name
 Trademark Registry
 Who Can Apply For a Trademark?
 How to Register a Trademark?
 Mark search:
 Filing application:
 Online Trademark Registration Procedure
 Status of application
 Registration
 Trademark Registration Fees
 Top 8 Things You Need to Know Regarding Trademark Registration
 Benefits of Trademark Registration in India

MSME
 What is MSME Classification?
 What is MSME Udyam Registration?
 MSME Registration Eligibility
 Documents Required for MSME Registration
 MSME Registration Fees
 MSME Registration Certificate
 MSME Registration Number
 MSME Registration Status

COMPANY REGISTRATION
 What are the types of business structures in India?
 Proprietorship Firm
 Partnership Firm
 One Person Company (OPC)
 Limited Liability Partnership (LLP)
 Private Limited Company (PLC)
 Public Limited Company
 Why is it important to choose the right business structure?
 Checklist for Company Registration
 What is the Cost of Company Registration?
 Benefits of Company Registration in India
 Name and Capital of the Compan

E-INVOICING
 What is e-Invoicing Under GST? Applicability, Limit & Implementation Date
 What is e-invoicing under GST?
 Who must generate e invoice and its Applicability?
 Turnover criteria or e Invoice limit
 Transactions and documents criteria
 Time limit to generate e-Invoice
 Process of getting an e invoice
 Benefits of e-Invoicing to businesses
 How can e-invoicing curb tax evasion?
 What are the mandatory fields of an e-invoice

BALANCE SHEET & PROFIT AND LOSS
 Balance Sheet – Importance, Examples, Components & Features
 Wish taxes were as simple as business bills?
 What is a Balance Sheet?
 Components of a balance sheet
 What are the features of a balance sheet?
 What is the importance of a balance sheet?
 Balance sheet example
 How to prepare a balance sheet?
 Profit & Loss Statement/Account – Why & How it is prepared?
 What is Profit & Loss Statement?
 How to prepare Profit & Loss Statement?
 Components of Profit & Loss Statements
 Different Formats of the Profit & Loss Account
 Format for Sole Traders & Partnership Firms
 Trading and Profit & Loss Account
 Details to be disclosed in the notes

Account Executive
 E-Accountant
 Senior Accountant
 Account Officer
 Assistant Manager
 GST Participant
 Tax Professional
 Account Auditor
 Account Manager