Accounting
Course – Advanced Excel
Duration – 30 Day / 45 Hrs
Course Description
Week 1: Introduction to Advanced Excel Functions
Day 1: Review of Basic Excel Concepts (1.5 hrs)
- Review basic functions: SUM, AVERAGE, MIN, MAX
- Introduction to cell referencing (relative, absolute, mixed)
Day 2: Logical Functions (1.5 hrs)
- IF, AND, OR functions
- Nested IF statements
Day 3: Text Functions (1.5 hrs)
- CONCATENATE, TEXTJOIN
- LEFT, RIGHT, MID
- UPPER, LOWER, PROPER, TRIM
Day 4: Lookup and Reference Functions (1.5 hrs)
- VLOOKUP, HLOOKUP
- INDEX and MATCH
- XLOOKUP (if available)
Day 5: Date and Time Functions (1.5 hrs)
- TODAY, NOW
- DATE, YEAR, MONTH, DAY
- DATEDIF, NETWORKDAYS
Week 2: Data Analysis and Visualization
Day 6: Data Validation and Conditional Formatting (1.5 hrs)
- Data validation rules
- Conditional formatting with formulas
Day 7: PivotTables Basics (1.5 hrs)
- Creating and formatting PivotTables
- Using PivotTable fields and filters
Day 8: Advanced PivotTables (1.5 hrs)
- Calculated fields and items
- PivotTable slicers and timelines
Day 9: Charts and Graphs (1.5 hrs)
- Creating basic charts: Column, Line, Pie
- Customizing charts and adding data labels
Day 10: Advanced Charting Techniques (1.5 hrs)
- Combo charts
- Sparklines
- Using secondary axes
Week 3: Advanced Data Manipulation
Day 11: Array Formulas and Functions (1.5 hrs)
- Introduction to array formulas
- Using array functions: TRANSPOSE, MMULT
Day 12: Data Tables and What-If Analysis (1.5 hrs)
- Creating and using data tables
- Scenario Manager and Goal Seek
Day 13: Power Query Basics (1.5 hrs)
- Introduction to Power Query
- Importing and transforming data
Day 14: Power Pivot Basics (1.5 hrs)
- Introduction to Power Pivot
- Creating data models and relationships
Day 15: Review and Practice Session (1.5 hrs)
- Review topics from Weeks 1-3
- Practice exercises and Q&A
Week 4: Advanced Data Analysis and Automation
Day 16: Introduction to Macros (1.5 hrs)
- Recording and running macros
- Assigning macros to buttons
Day 17: Introduction to VBA (1.5 hrs)
- VBA editor and basic syntax
- Writing simple VBA scripts
Day 18: Advanced VBA Techniques (1.5 hrs)
- VBA for data manipulation
- Error handling and debugging
Day 19: Advanced Data Analysis with Power Pivot (1.5 hrs)
- DAX functions and measures
- Advanced calculations and KPIs
Day 20: Dashboards and Reports (1.5 hrs)
- Designing interactive dashboards
- Combining PivotTables, charts, and slicers
Week 5: Project Work and Final Review
Day 21: Project Work (1.5 hrs)
- Define project scope and objectives
- Start working on individual/group projects
Day 22: Project Work (1.5 hrs)
- Continue project development
- Provide guidance and support
Day 23: Project Work (1.5 hrs)
- Finalize projects
- Prepare for presentations
Day 24: Project Presentations (1.5 hrs)
- Present projects to the class
- Provide feedback and discuss learning points
Day 25: Final Review and Q&A (1.5 hrs)
- Review key topics and concepts
- Address any remaining questions or issues
Week 6: Additional Topics and Certification Preparation
Day 26-30: Optional Sessions (1.5 hrs each)
- Custom topics based on class needs
- Certification exam preparation
- Advanced data visualization techniques
- Specialized Excel tools (Power BI integration, etc.)
Certification: Upon successful completion of the course, participants will receive the certificate.
Course –Computerized Accounting (Tally ERP 9.0)
Duration – 30 Day / 45 Hrs
Course Description
Week 1: Introduction and Basic Features (09 hours)
Day 1 (1.5 hours):
- Introduction to Computerized Accounting and Tally ERP 9.0
- Basics of computerized accounting
- Overview of Tally ERP 9.0
- Installation and setup
- User interface and navigation
Day 2 (1.5 hours):
- Company Creation and Management
- Creating a new company
- Configuring company settings
- Altering and deleting company details
Day 3 (1.5 hours):
- Basic Accounting Masters
- Ledger creation and management
- Group creation and categorization
Day 4 (1.5 hours):
- Voucher Entry Basics
- Types of vouchers in Tally
- Recording transactions: Receipts, Payments, and Journals
Day 5 (1.5 hours):
- Practical Session on Basic Features
- Practice ledger and voucher entries
- Q&A and recap of the week
Day 6 (1.5 hours):
- Trial Balance and Basic Reports
- Generating trial balance
- Understanding basic financial reports
Week 2: Inventory Management and Advanced Accounting (09 hours)
Day 7 (1.5 hours):
- Inventory Management Basics
- Stock groups and categories
- Stock items and units of measure
Day 8 (1.5 hours):
- Godowns and Stock Valuation
- Creating and managing godowns
- Different methods of stock valuation
Day 9 (1.5 hours):
- Purchase and Sales Order Processing
- Creating and managing purchase orders
- Sales order entry and tracking
Day 10 (1.5 hours):
- Recording Purchase and Sales Transactions
- Entering purchase and sales vouchers
- Managing credit notes and debit notes
Day 11 (1.5 hours):
- Bill-wise Details and Tracking
- Activating bill-wise details
- Managing outstanding reports
Day 12 (1.5 hours):
- Practical Session on Inventory and Advanced Accounting
- Practice sessions on inventory and order processing
- Q&A and recap of the week
Week 3: Payroll, Taxation, and Compliance (09 hours)
Day 13 (1.5 hours):
- Introduction to Payroll in Tally
- Setting up payroll in Tally
- Creating employee masters
Day 14 (1.5 hours):
- Payroll Processing
- Attendance and payroll vouchers
- Payroll processing and statutory deductions
Day 15 (1.5 hours):
- Introduction to GST in Tally
- GST basics and configuration in Tally
- GST classifications
Day 16 (1.5 hours):
- GST Transactions
- Recording GST-compliant sales and purchase transactions
- Generating GST reports
Day 17 (1.5 hours):
- Other Taxation and Compliance Features
- TDS and TCS management
- Other statutory compliance features
Day 18 (1.5 hours):
- Practical Session on Payroll and GST
- Practice sessions on payroll and GST entries
- Q&A and recap of the week
Week 4: Reporting, Data Management, and Project Work (9 hours)
Day 19 (2 hours):
- Financial Statements and Reports
- Generating Balance Sheet and Profit & Loss Account
- Cash/Bank Book, Day Book, and other primary books
Day 20 (2 hours):
- Advanced Reporting and Analysis
- Ratio analysis and MIS reports
- Budgeting and variance analysis
Day 21 (1 hour):
- Exporting Data and Reports
- Exporting reports to different formats
- Data synchronization
Day 22 (1 hour):
- Security and User Management
- User creation and access control
- Security settings in Tally
Day 23 (1 hour):
- Backup and Restore
- Procedures for backing up data
- Restoring data in Tally
Day 24 (2 hours):
- Comprehensive Practice Session
- End-to-end accounting cycle
- Real-life scenarios and problem-solving
Week 5: Project Presentation and Review (9 hours)
Day 25 (2 hours):
- Project Assignment
- Individual or group projects: Setting up a company, recording transactions, and generating reports
Day 26 (2 hours):
- Project Work: Continued
- Assistance and supervision of project work
Day 27 (2 hours):
- Project Presentation
- Presentation and review of project work
Day 28 (2 hours):
- Mock Test and Practical Evaluation
- Conducting a mock test to assess understanding
- Practical evaluation of skills
Day 29 (1 hour):
- Discussion and Feedback
- Career opportunities in computerized accounting
- Further learning paths and advanced courses
Day 30 (1 hour):
- Course Completion
- Final Q&A session
- Certificate distribution and course completion ceremony
Certification: Upon successful completion of the course, participants will receive the certificate.
Course –Core Accounting
Duration – 30 Days / 45 Hrs
Course Description
Week 1: Introduction to Accounting Principles (7.5 hours)
Day 1 (1.5 hours):
- Introduction to Accounting
- Definition and purpose of accounting
- Users of financial information
- Basic accounting terminology
Day 2 (1.5 hours):
- Accounting Principles and Concepts
- GAAP (Generally Accepted Accounting Principles)
- The Accounting Equation (Assets = Liabilities + Equity)
- Double-entry bookkeeping
Day 3 (1.5 hours):
- The Accounting Cycle
- Steps in the accounting cycle
- Journalizing transactions
Day 4 (1.5 hours):
- Ledger Accounts and Posting
- Creating and managing ledger accounts
- Posting journal entries to ledgers
Day 5 (1.5 hours):
- Practice session on journalizing and posting
- Practical exercises and examples
- Q&A and recap of the week
Week 2: Financial Statements and Adjustments (7.5 hours)
Day 6 (1.5 hours):
- Trial Balance
- Preparing a trial balance
- Identifying and correcting errors
Day 7 (1.5 hours):
- Adjusting Entries
- Types of adjusting entries (accruals, deferrals, estimates)
- Preparing and posting adjusting entries
Day 8 (1.5 hours):
- Adjusted Trial Balance
- Preparing an adjusted trial balance
- Ensuring accuracy and completeness
Day 9 (1.5 hours):
- Financial Statements
- Income Statement
- Balance Sheet
- Statement of Cash Flows
Day 10 (1.5 hours):
- Practice session on preparing financial statements
- Practical exercises and examples
- Q&A and recap of the week
Week 3: Detailed Accounting Topics (7.5 hours)
Day 11 (1.5 hours):
- Cash and Bank Reconciliation
- Managing cash accounts
- Bank reconciliation process
Day 12 (1.5 hours):
- Accounts Receivable and Payable
- Managing receivables and payables
- Recording and tracking transactions
Day 13 (1.5 hours):
- Inventory Accounting
- Inventory valuation methods (FIFO, LIFO, Weighted Average)
- Recording inventory transactions
Day 14 (1.5 hours):
- Depreciation and Fixed Assets
- Depreciation methods (Straight-line, Declining Balance, Units of Production)
- Recording asset acquisitions and disposals
Day 15 (1.5 hours):
- Practice session on detailed accounting topics
- Practical exercises and examples
- Q&A and recap of the week
Week 4: Advanced Topics and Applications (7.5 hours)
Day 16 (1.5 hours):
- Introduction to Managerial Accounting
- Difference between financial and managerial accounting
- Cost behavior and cost-volume-profit analysis
Day 17 (1.5 hours):
- Budgeting and Forecasting
- Preparing budgets
- Variance analysis
Day 18 (1.5 hours):
- Financial Analysis
- Ratio analysis
- Horizontal and vertical analysis
Day 19 (1.5 hours):
- Ethics in Accounting
- Importance of ethics in accounting
- Ethical dilemmas and resolutions
Day 20 (1.5 hours):
- Practice session on advanced topics
- Practical exercises and examples
- Q&A and recap of the week
Week 5: Practical Applications and Review (6 hours)
Day 21 (1.5 hours):
- Comprehensive practical session: Full accounting cycle
- Real-life scenarios and problem-solving
- Preparation of a complete set of financial statements
Day 22 (1.5 hours):
- Project assignment: Individual or group projects
- Set up a hypothetical company, record transactions, and generate reports
Day 23 (1.5 hours):
- Project work: Continued
Day 24 (1.5 hours):
- Project presentation and review
Final Day: Wrap-up and Review (9 hours)
Day 25 (2 hours):
- Final revision of all topics
- Addressing any remaining doubts
Day 26 (1.5 hours):
- Mock test and practical evaluation
- Review and discuss results
Day 27 (1.0 hours):
- Discussion on career opportunities in accounting
- Further learning paths and certifications
Day 28 (2 hours):
- Final Q&A session and feedback collection
Day 29 (1.0 hours):
- Future Opportunities and Career Guidance
Day 30 (1.5 hours):
- Graduation, certificate distribution, and course completion ceremony
Certification: Upon successful completion of the course, participants will receive the certificate.
Course – GST
Duration – 30 Days / 45 Hrs
Course Description
Week 1: Introduction to GST (6 hours)
Day 1 (1 hour):
- Introduction to GST: Overview, Objectives, and Key Features
- Historical background and evolution of GST in India
Day 2 (1 hour):
- Types of GST: CGST, SGST, IGST, and UTGST
- GST structure and framework
Day 3 (1 hour):
- GST registration process
- Eligibility and requirements for GST registration
Day 4 (1 hour):
- Understanding GST rates and slabs
- GST Council and its role
Day 5 (1 hour):
- Practice session on registration and rates
- Q&A and recap of the week
Week 2: GST Mechanism and Operations (7.5 hours)
Day 6 (1.5 hours):
- Supply under GST: Intra-state and Inter-state supply
- Place of Supply, Time of Supply, and Value of Supply
Day 7 (1.5 hours):
- Input Tax Credit (ITC) mechanism
- Conditions for availing ITC
Day 8 (1.5 hours):
- Tax Invoice, Credit Note, and Debit Note
- Billing and invoicing under GST
Day 9 (1.5 hours):
- Reverse Charge Mechanism (RCM)
- Composition Scheme under GST
Day 10 (1.0 hours):
- Practice session on supply, ITC, and invoicing
- Q&A and recap of the week
Week 3: GST Compliance and Returns (10 hours)
Day 11 (2 hours):
- GST returns: Types and filing process
- GSTR-1: Details of outward supplies
Day 12 (2 hours):
- GSTR-2A and GSTR-2B: Details of inward supplies
- GSTR-3B: Monthly summary return
Day 13 (2 hours):
- Annual return: GSTR-9 and GSTR-9C
- GST audit and reconciliation
Day 14 (2 hours):
- Late fees, interest, and penalties under GST
- Overview of GST portal and e-filing
Day 15 (2 hours):
- Practice session on filing GST returns
- Q&A and recap of the week
Week 4: Specialized Topics and Practical Applications (09 hours)
Day 16 (2 hours):
- GST on e-commerce
- GST implications for export and import
Day 17 (2 hours):
- Job work and its compliance under GST
- E-way bill: Generation, validity, and compliance
Day 18 (1.5 hours):
- Anti-profiteering provisions under GST
- GST and its impact on different sectors
Day 19 (2 hours):
- Advanced GST topics: Transitional provisions, refund mechanism
- GST assessments and adjudication process
Day 20 (1.5 hours):
- Practice session on specialized topics
- Q&A and recap of the week
Week 5: Practical Sessions and Project Work (5 hours)
Day 21 (2 hours):
- Comprehensive practical session: Case studies and real-life scenarios
- Solving GST-related problems
Day 22 (1 hour):
- Project assignment: Individual or group projects on GST compliance for a business, filing returns, and claiming ITC
Day 23 (1 hour):
- Project work: Continued
Day 24 (1 hour):
- Project presentation and review
Final : Wrap-up and Review (8 hours)
Day 25 (1.5 hours):
- Final revision of all topics
- Addressing any remaining doubts
Day 26 (1.5 hours):
- Advanced tips and tricks for GST compliance
- Discussion on GST amendments and updates
Day 27 (1.5 hours):
- Mock test and practical evaluation
Day 28 (1.5 hours):
- Discussion on career opportunities in GST and further learning paths
Day 29 (1.0 hours):
- Final Q&A session and feedback collection
Day 30: (1.0 hours)
- Graduation, certificate distribution, and course completion ceremony
Certification: Upon successful completion of the course, participants will receive the certificate.
Course – Income Tax Under All Income Heads
Duration – 30 Days / 45 Hrs
Course Description
Week 1: Introduction and Salary Income (10 hours)
Day 1 (2 hours):
- Introduction to Income Tax in India
- Basic concepts: Assessee, Assessment Year, Previous Year
- Overview of income tax laws and key terminologies
Day 2 (2 hours):
- Residential status and its impact on tax liability
- Scope of total income
Day 3 (2 hours):
- Income from Salary: Definition and components
- Allowances: Taxable, partially exempt, and fully exempt
Day 4 (2 hours):
- Perquisites and their valuation
- Profit in lieu of salary
Day 5 (2 hours):
- Deductions from salary income: Standard deduction, Entertainment allowance, Professional tax
- Computation of income from salary
Week 2: House Property and Capital Gains (10 hours)
Day 6 (2 hours):
- Income from House Property: Basis of charge
- Annual value determination
Day 7 (2 hours):
- Deductions from house property income: Section 24
- Treatment of self-occupied and let-out properties
Day 8 (2 hours):
- Introduction to Capital Gains
- Types of capital assets: Short-term and Long-term
Day 9 (2 hours):
- Calculation of capital gains: Cost of acquisition, Cost of improvement, Indexed cost
- Exemptions under sections 54, 54EC, 54F
Day 10 (2 hours):
- Special cases: Capital gains on depreciable assets, Transfer of assets between spouses
- Practice session on computation of house property income and capital gains
Week 3: Business and Profession Income (10 hours)
Day 11 (2 hours):
- Income from Business or Profession: Basis of charge
- Accounting methods: Cash and mercantile systems
Day 12 (2 hours):
- Deductions allowable: General deductions under section 37
- Specific disallowances
Day 13 (2 hours):
- Depreciation: Concepts and computation
- Treatment of expenses: Repairs, Insurance, Rents
Day 14 (2 hours):
- Presumptive taxation schemes: Sections 44AD, 44ADA, 44AE
- Maintenance of books of accounts
Day 15 (2 hours):
- Practice session on computation of income from business or profession
- Case studies and problem-solving
Week 4: Income from Other Sources and Set-off & Carry Forward (10 hours)
Day 16 (2 hours):
- Income from Other Sources: Basis of charge
- Interest, Dividends, Winnings from lotteries, races, etc.
Day 17 (2 hours):
- Deductions allowable: Section 57
- Treatment of casual income
Day 18 (2 hours):
- Clubbing of Income: Provisions and implications
- Aggregation of income
Day 19 (2 hours):
- Set-off and carry forward of losses: Intra-head and inter-head adjustments
- Specific provisions for different heads of income
Day 20 (2 hours):
- Practical session on computation of income from other sources
- Q&A and recap of the week
Week 5: Deductions, Filing, and Assessment (10 hours)
Day 21 (2 hours):
- Deductions under Chapter VI-A: Section 80C to 80U
- Section 80C: Investments and payments
Day 22 (2 hours):
- Sections 80D, 80DD, 80E, 80G, 80TTA, etc.
- Planning for tax savings
Day 23 (2 hours):
- Procedure for filing income tax returns
- Types of ITR forms and their applicability
Day 24 (2 hours):
- E-filing process and documentation required
- Overview of Form 16, 16A, 26AS
Day 25 (2 hours):
- Assessment procedure: Self-assessment, Regular assessment
- Rectification, revision, and appeal procedures
Final Week: Practical Application and Review (5 hours)
Day 26 (2 hours):
- Comprehensive practical session: End-to-end tax computation for an individual
- Real-life scenarios and problem-solving
Day 27 (1 hour):
- Project assignment: Preparation of a complete income tax return for a hypothetical individual
Day 28 (1 hour):
- Project work: Continued
Day 29 (1 hour):
- Project presentation and review
Final Day: Wrap-up and Review (5 hours)
Day 30:
- Final revision of all topics (2 hours)
- Mock test and practical evaluation (2 hours)
- Final Q&A session and feedback collection (0.5 hour)
- Graduation, certificate distribution, and course completion ceremony (0.5 hour)
Certification: Upon successful completion of the course, participants will receive the certificate.
Course – Payroll Management
Duration – 30 Days / 45 Hrs
Course Description
Week 1: Introduction to Payroll Management (15 hours)
- Day 1 (3 hours):
- Course Overview
- Introduction to Payroll Management
- Key Terminologies in Payroll
- Day 2 (3 hours):
- Understanding Employment Laws and Regulations
- Types of Employment
- Day 3 (3 hours):
- Payroll Systems and Software Overview
- Manual vs. Automated Payroll Systems
- Day 4 (3 hours):
- Employee Classification
- Salary and Wage Calculation
- Day 5 (3 hours):
- Practical Session: Setting up a Payroll System
- Q&A and Recap of Week 1
Week 2: Payroll Processing and Calculations (15 hours)
- Day 1 (3 hours):
- Payroll Cycle and Timeline
- Collecting Employee Data
- Day 2 (3 hours):
- Gross Pay Calculations
- Overtime and Bonuses
- Day 3 (3 hours):
- Deductions: Taxes, Benefits, and Other Withholdings
- Day 4 (3 hours):
- Net Pay Calculation
- Issuing Paychecks and Direct Deposits
- Day 5 (3 hours):
- Practical Session: Payroll Calculation Examples
- Q&A and Recap of Week 2
Week 3: Compliance and Reporting (15 hours)
- Day 1 (3 hours):
- Understanding Tax Obligations
- Federal, State, and Local Taxes
- Day 2 (3 hours):
- Reporting Requirements
- Payroll Tax Forms (e.g., W-2, 1099, etc.)
- Day 3 (3 hours):
- Year-End Reporting and Reconciliation
- Filing Deadlines and Penalties
- Day 4 (3 hours):
- Record Keeping and Data Security
- Best Practices in Payroll Documentation
- Day 5 (3 hours):
- Practical Session: Filing Tax Forms
- Q&A and Recap of Week 3
Week 4: Advanced Payroll Topics and Practical Applications (15 hours)
- Day 1 (3 hours):
- Handling Special Payroll Situations (e.g., Leave, Terminations)
- Garnishments and Levies
- Day 2 (3 hours):
- International Payroll Considerations
- Multi-State Payroll Issues
- Day 3 (3 hours):
- Payroll Audits and Fraud Prevention
- Internal Controls in Payroll
- Day 4 (3 hours):
- Implementing Payroll Policies and Procedures
- Continuous Improvement in Payroll Processes
- Day 5 (3 hours):
- Practical Session: Case Studies and Real-Life Scenarios
- Final Q&A and Course Recap
Total: 45 hours
Notes:
- Interactive Sessions: Each practical session will involve hands-on exercises, case studies, and role-playing scenarios to ensure that learners can apply theoretical knowledge.
- Assessments: Incorporate quizzes, assignments, and a final project to assess understanding and application of the course content.
- Resources: Provide additional reading materials, online resources, and access to payroll software tools for practice.
- Flexibility: Allow some flexibility in the schedule to accommodate different learning paces and provide additional support where needed.
Certification: Upon successful completion of the course, participants will receive the certificate.