Course Curriculum
- Computer Fundamental
- Paint
- Notepad
- Wordpad
- MS-Word
- MS-Excel
- MS-Powerpoint
- Practical Knowledge
- Sum
- Count
- Count blank
- Average
- Max
- Large Min
- Round
- Abs
- Sumif
- Count if
- Lower
- Upper
- Proper
- Trim
- Len
- Left
- Right
- Mid
- Subtotal
- And
- Or
- Day
- Year
- month
- Net workdays
- Today
- Weekdays
- Find
- Search
- V-lookup
- H-lookup
- Day and Time
- Numeric Calculation
- If Logical Condition
- Dynamic Pivot
- Dynamic Chart
- Conditional Formatting
- Dated if
- What If Analysis
- Match Index
- Offset Function
- User form Function in Excel
- Data Validation
- Advance Filter
- Sorting
- Group & Ungroup
- Data split
- Text Function (Data Separation)
- Substitute
- Goal seek
- Chart
- Table
- Pie Bar
- Voucher Preparation
- Daybook Writing
- Cash book Preparation
- Ledger writing
- Journal Register
- Stock Register update Purchase Register Preparation
- Sales Register Preparation
- Invoice Preparation
- Purchase order and Sales Order preparation
- Quotation preparation
- Fixed Asset register Preparation
- Trading and Profit & Loss Account
- Balance Sheet preparation
- Bank reconciliation Cheque Preparation and Deposit slips
- Rectification Entries
- Depreciation Entries
- Cheque Preparation and Deposit slips
- Balance Sheet Review
- Creation of Master
- Accounting Vouchers
- Inventory Vouchers
- Stock Journal transactions with Vouchers
- Advanced Features
- Configuration
- Remote Access
- Synchronization
- Invoice Formation Online Database Connectivity (ODBC) Various analytical Reports etc.
- Financial Reports
- Balance Sheet
- Profit & Loss Account
- Account Books
- Group Summary
- Group Vouchers
- Generation of Reports
- Generation of Employee database
- Salary Structure & Calculation
- Attendance & Leave Details
- Salary silp Generation PF
- ESI
- Gratuity
- Bonus Professional Tax
- various Analytical Reports etc
- TDS
- TCS
- Form - 16A
- Challans
- Return Forms
- VAT
- E-GST etc.
- Accounts Reconciliation
- Ledger Scrutiny
- Accounts Finalisation
- Company Final Accounts
- Busy
- Master's, Balance Sheet
- Stock Items
- Voucher Entry
- BOM
- POS
- TDS
- TCS
- Multi Currency
- Batch Wise Details
- GST Single
- Multi Rates GST
- Pay Roll
- Interest Calculation
- Depreciation
- Introduction Of Banking
- Define Of Bank
- Historical Background
- Constitution Of RBI Settings
- Bank Document
- Cheque
- Development
- Bank
- RRBS Setting Up
- Banking Cleaning System
- Banking Instruments
- Cash Flow
- Bank Accounts
- Plastic Money
- KYC
- E-Banking
- ATM, Bill Discounting
- Hypothecation
- Pledge
- Mortgage
- ECS Electronic
- Cleaning System
- Rigs Real Time Gross Statement
- Mutual Fund
- Money Market
- Position
- Of Banking System Indian Banking Industry,
- Loans
- Money Londring
- Accounting Cycle
- TDS (e-filing of TDS)
- AN Application,TAN Application
- Deduction under sec.192 to 196
- Deposit challan 281/280/26 QB
- TDS Return 24Q / 26Q
- Digital Signature for Filling TDS Returns
- Form 16/16A, 26 AS
- Foreign remittance 15CA/15CB
- Lower deduction /No deduct – form 13/15G-H
- Interest & Penalty calculation
- Journal Entry in Tally
- Introduction to Income Tax
- Brief about Various Sources of Income (with illustrations)
- Introduction of 'e' Filing of Income Tax Returns Generation of IT Form ITR 01(SAHAJ)
- ITR 02 ITR 03, ITR 04, ITR 4S(SUGAM)
- ITR 05 and ITR06 How To Register PAN
- TAN
- TIN and DIN online or manual
- Practical exposure to www.incometaxindiaefiling.gov.in portal.
- How to file Return Electronically on portal with or without Digital Signature Certificate.
- How to Pay Tax online through Net Banking.
- How to Generate challans online or Manual
- Preparation of schedule VI B/S & P&L A/C.
- with Import Balance Sheet and Profit and Loss A/c from TALLY
- How to view Tax Credit through 26AS
- Principles, Important Definitions, Why GST is Necessary?
- Impact of GST, Benefits/ Demerits, Different Rates of GST.
- Definition & Important Notes to Return.
- Types of Returns. (Annual Return, First Return, Regular Return)
- Notice to Return Defaulters.
- Levy of Late Fee.
- Goods and Services Tax Practitioners
- Various Return Form
- e. GSTR-I, II ,III
- Refund of Tax (Section-54)
- Refund in Certain Cases (Section-55)
- Interest on Delayed Refunds (Section-56)
- Consumer Welfare Fund (Section-57)
- Utilization of Fund (section-58)
- Eligibility & Conditions for taking ITC (Section-16)
- Block Credit (Section-17)
- Availability of Credit in Special Cases (Section-18)
- ITC for Job Work (Section-19)
- ITC Distribution by ISD (section-20)
- Important Definitions. Section 2
- Determination of Nature of Supply (Section 7-9)
- Place of Supply of Goods and/or Services (Section 10-14)
- Zero Rated Supply (Section 16)
- PF Computation and Deposit of ECR
- ESI Chillan Deposit and Return
- Taxability of Different Allowances and Perquisites
- Deductions (Tax Savings)
- Under Chapter VI A
