• Module 1.1 – Basic of GST Overview of Model GST Law
• Module 1.2 – E-GST Registration with GST Rules & Format
• Module 1.3 – Levy and Collection with Time of Supply (Section 7 ,8 and 9 with GST SCH-I,II and III)
• Module 1.4– Input Tax Credit – Section 16-21 with GST Rules
• Module 1.5 – Electronic Commerce in GST – Section 52
• Module 1.6 – Job Work & Composition Levy in GST
• Module 1.7 – Returns Under GST Section (37-48) with GST Rules & Formats
• Module 1.8 – Government to Roll out E-way Bill
• Module 1.9 – IGST LAW- (Total Chapter IX, Total Section 1-25)
• Module 1.10 – Refunds – Section 54-58 with GST Rules
• Module 1.11 – GST Annual Return

• Module 2.1 – Integration of Interdependent Legal Terms of Direct Tax
• Module 2.2 – Dependent of Gross Total Income
• Module 2.3 – Rates Applicable on Income
• Module 2.4 – TDS -Receivable Reporting in Return
• Module 2.5 – Introduction of Return Forms (ITR)
• Module 2.6 – ITR-3 for Individual Having Income from Business and Profession
• Module 2.7 – .Concept of Business Profession through ITR-3
• Module 2.8 – Working on PART A-OI of ITR-3 (Row 1 to 4)
• Module 2.9 – Income Tax Reports
• Module 2.10 – Salary, House Property and Other Sources through ITR-3
• Module 2.11 – Discussion of ITR-4
• Module 2.12 – ITR-5
• Module 2.13 – ITR-6
• Module 2.14 – Basic Discussion on ITR-7

• Module 3.1 – Tax Deducted at Sources
• Module 3.2 – Tax Collection at Sources

• Analysis of Balance Sheet and its components as per Revised Schedule of Companies Act 2013.
• Logical Process of preparing balance sheet on Excel of a company registered under companies Act.
• Comparative Analysis of provisions of Depreciation in Income Tax Act and Companies Act.
• Bank Reconciliation Statement and its importance for finalization.
• Year-end Adjustment entries. (New Topic)
• Deferred Tax (New Topic)
• Real World demo of Grouping of Heads of income and expenses through trial balance.
• Practical demo on linking skill of cells in Excel and preparation Financial Statement on multi excel sheet with its other component.
• Financial Analysis (how to read the financial accounts of a Company – important ratio analysis) (New Topic)

• Documentation in Finance for CC Limit/OD Limit
• Project Reports
• CMA Data
• Practical Analytical Review of Reports
• Stock Statement
• LC(Letter of Credit)
• Letter of Credit- How to Open the LC
• How to Sanction the LC Limit from Bank
• Documentation for LC Limit
• Ratio Analysis
• Bank Guarantee (Usage and Format)
• Online Payment of Taxes

Module 6.1

• Introduction to export and import
• Going through Legal Integration of CBIC,Fema , DGFT and RBI
• Foreign Trade Policy-An Introduction

Module 6.2

• Basic Procedure to Export and Import
• Various Duties Applicable on Import
• Introduction to- Shipping Bill and Bill of Entry
• Concept of CHA and Its Working

Module 6.3

• Settlement of Consideration through Authorized Dealer
• A complete Practical Discussion

Module 6.4

• Export Incentive under FTP
• Duty Draw Back
• Remission of Duty
• MEIS &EPCG
• Advance Autorisation
• Scrips

Basic of Tally Prime & ERP 9

• What is Tally
• Overview of Software
• Introducing Gateway and its elements
• Creation of Company
• Basics Of Accounting
• Fundamentals of Tally ERP 9
• Create Accounting Masters in Tally ERP 9
• Accounting Vouchers
• Financial Statements and Accounting Books & Reports

Inventory Management- Tally Prime & ERP 9

• Creating Inventory Masters in Tally ERP 9
• Inventory Vouchers
• Generating Inventory Books & Reports
• Introducing BOM – Bill of Materials
• Accounting with Inventory

Accounting Management Through Advanced Tally Prime & ERP 9

Bill –Wise Details

• Types of Bill can be created through Tally
• Debit Note/Credit note through Tally
• Accounting Memos

Cost Centre and Cost Categories

• Cost Accumulation
• Defined cost unit
• Cost Management
• Direct Cost Vs Indirect Cost

Accounting Ledgers Details

• When to create ledger
• Information required while creating ledger
• Grouping and sub grouping of Ledger
• Importance of tax information in ledger

Voucher Classes

• Sale Voucher
• Purchases Voucher
• Receipt
• Payment
• Journal Voucher
• Others

Multiple Currencies

Budget & Controls

Interest Calculations

Banking

Production and Stock Management Tally Prime & ERP 9

• Order Processing
• Multiple Price Level
• Batch – wise Details
• Additional Cost Details
• Bill of Materials (BoM)
• Price Levels and Price Lists
• Stock Valuationl
• Zero Valued Entries
• Inventory Analysis
• Different Actual and Billed Quantities
• Job Costing
• Job Order Processing

TDS

• TDS Payable Computation & Reconciliation
• TDS Receivable Computation & Reconciliation
• Payment of TDS
• Reporting on TDS Compliance

Payroll& Salary Management

• Generation of Employee Database
• Salary Structure
• Calculation Attendance & Leave Details
• Salary Slip Generation
• PF, ESI, Gratuity Bonus
• Professional Tax
• Various Payroll Reports

GST in Tally

• Upgrading to Tally.ERP 9 Release 6.4
• Start Using Tally.ERP 9 for GST Compliance
• Activating GST for Your Company
• Setting Up GST Rates
• Updating Stock Items and Stock Groups for GST Compliance
• Updating a Services Ledger for GST Compliance
• Updating Sales and Purchase Ledgers for GST Compliance
• Updating Party GSTIN
• Creating GST Ledgers
• Creating Income and Expense Ledger
• Recording Sales and Printing Invoices
• Recording Purchases
• Recording a Tax Payment
• Transferring Tax Credits of VAT, excise and services tax to GST
• Other Scenarios
• Sales – Nil Rated, Exempt, SEZ, and Deemed Export
• Recording Sales Returns
• Recording Purchase Returns
• Debit Note
• Credit Note
• Particulars (Computation Details)
• Summary of Exceptions
• Introduction to- Shipping Bill and Bill of Entry
• Table-wise GSTR-1
• Challan Reconciliation
• Recording Export Sales
• Reverse Charge under GST
• Recording an Advance Receipt from Customer
• Recording an Advance Payment to Supplier
• Recording Journal Vouchers for Adjustments Against Tax Credit
• Recording a Journal Voucher for TDS Adjustment
• Recording a Journal Voucher for TCS Adjustment
• Recording a Journal Voucher for Refund of Tax Credit
• Recording a Journal Voucher for ISD Credit
• Recording a Journal Voucher for Transitional Credit
• Recording Journal Vouchers for Other Liabilities
• Recording Journal Vouchers for Reversal of Tax Credit
• GSTR-1
• Returns Summary
• Status Reconciliation
• Exporting GSTR-1
• GSTR – 3B
• Annual Return

IntroductiontoExcel

• Basic Understanding Menu and Toolbar
• Introduction to different category of functions
• Basics, Mathematical and Statistical
• Date and Time, Logical
• Lookup and References
• Text and Information

Mathematical Functions

• Sum, Sumif, Sumifs,
• Count, Counta, Countblank, Countif, Countifs
• Average, Averagea, Averageif, Averageifs,
• Subtotal, Aggregate, Rand, Randbetween,
• Roundup, Rounddown, Round, Sumproduct

Date & Time Function

• Date, Day, Month, Year,
• Edate, Eomonth, Networkdays,
• Workday, Weeknum, Weekday,
• Hour, Minute, Second,
• Now, Today, Time

Text Function

• Char, Clean, Code, Concatenate
• Find, Search, Substitute, Replace
• Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large
• Small Filters (Basic, Advanced, Conditional)
• Sort (Ascending, Descending, Cell/ Font Color)

Data Validation

• Conditional Formatting,
• Data Validation, Group & Ungroup
• Data split

Statistical Function & Other Functions

• Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext
• Max, Min, Len, Right, Left
• Mid, ,Maxa, Maxifs, Median, Minifs, Mina
• Vara, Correl

Logical Function

• And
• Or
• If
• Iferror
• Not
• Nested If

Lookup & Reference Functions

• VLookup, HLookup, Index, Match,
• Offset, Indirect, Address,
• Column, Columns, Row, Rows, Choose,
• Arrays Concept In Lookup Formula’s,
• Past Special, Past link

Pivot Table – MIS, Data Analysis & Visualization

• Pivot Table
• What-if Analysis
• Graphs & Charts
• Analysis Tool Pack, Solver, Histogram, Pareto, Water Fall,
• Import and Export data
• Protect/Unprotect sheets/workbooks
• Worksheet formatting and Print Display

Date & Time Function

• Date, Day, Month, Year,
• Edate, Eomonth, Networkdays,
• Workday, Weeknum, Weekday,
• Hour, Minute, Second,
• Now, Today, Time

Data Collection Method

• With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis Single/Multidimensional Analysis

• Like Three Dimensional (3D) Tables
• Sensitive Analysis Like Data Table
• Manual What-If Analysis
• Threshold Values
• Goal Seek
• One-Variable Data Table
• Two-Variable Data Table

Advanced Dashboard in Excel

• Overview of Chart types
• Chart Formatting
• Active X Form Controls
• Principle of great dashboard design
• Selecting Correct Chart to display data
• Interactive Charts with Form Controls
• Combo box, Check Box, Scroll Bar and Radio Button
• Interactive Dashboard with Form Controls, Form Controls for reports automation
• Data Modeling

• Tell me About Yourself.
• Tell me about the gap in your resume.
• How Has Your Experience Prepared You for This Role?
• How would you rate yourself on a scale of 1 to 10?
• SWhat are your greatest strengths and weaknesses?
• What is your biggest achievement so far?
• What do you know about the company?
• Where do you see yourself in 5 years?
• What Are Your Salary Expectations?
• Why are you looking for a change?
• How Do You Handle Stress and Pressure?

SAP FICO Analyst

Module 1: Introduction

• ERP & SAP Overview
• SAP FICO role in financial operations
• FI vs CO overview

Module 2: General Ledger (GL)

• Organizational structure in FI
• Chart of Accounts, Fiscal Year Variant
• Document posting & posting keys
• Recurring entries, Accrual/Deferral
• Foreign currency & parallel ledgers
• Financial reporting

Module 3: Accounts Payable (AP)

• Vendor master data
• Invoice posting, credit memo, down payments
• Payment terms & Automatic Payment Program (APP)
• Withholding Tax / TDS
• Vendor reports

Module 4: Accounts Receivable (AR)

• Customer master data
• Invoice posting, credit memo, incoming payments
• Dunning & interest calculation
• Customer credit management
• AR reports

Module 5: Asset Accounting (AA)

• Asset master data
• Acquisition, transfers, retirement
• Depreciation keys & depreciation run
• Integration with GL
• Asset reports

Module 6: Controlling (CO)

• Cost element accounting
• Cost center accounting
• Internal orders
• Profit center accounting
• Profitability analysis (CO-PA)
• Product costing

Module 7: Advanced Topics

• Financial Closing Cockpit
• Consolidation basics
• Cash & Bank accounting
• Integration with SD, MM, PP
• Taxation (GST/VAT basics)

SAP S/4 HANA Finance with AI

Module 1: Overview of S/4HANA

• Difference between SAP ECC vs S/4HANA
• Data model simplification
• Universal Journal (ACDOCA)
• Business Partner approach

Module 2: General Ledger (GL) in S/4HANA

• Ledger approach with multiple currencies
• Real-time FI-CO integration
• Universal Journal postings
• Parallel accounting

Module 3: Accounts Payable in S/4HANA

• Vendor as Business Partner
• Invoice processing
• Advanced Payment management
• Integration with Treasury

Module 4: Accounts Receivable in S/4HANA

• Customer as Business Partner
• Cash application (Machine Learning)
• Predictive collections
• Real-time reconciliation

Module 5: Asset Accounting in S/4HANA

• New depreciation calculation engine
• Real-time postings to Universal Journal
• Parallel valuation in assets

Module 6: Controlling in S/4HANA

• Margin Analysis vs Costing-based CO-PA
• Real-time CO reporting
• Simplified cost elements

Module 7: Advanced S/4HANA Finance

• Group Reporting (Consolidation)
• Central Finance basics
• Cash management & liquidity planning
• Treasury & Risk management basics

Module 8: Reporting & Analytics

• Fiori apps for Finance
• Embedded Analytics with HANA
• Real-time dashboards

Module 9: AI in Finance (Basic Layer)

• SAP AI Business Services overview
• Document Information Extraction (OCR for invoices)
• Predictive Accounting in S/4HANA
• AI-based Cash Forecasting
• Chatbots

• Employees’ Provident Fund – EPF
• Employees’ State Insurance -ESI
• Payment of Bonus
• Payment of Gratuity

• The Pay Structure
• Basic, HRA, DA, Conveyance, Medical Allowance, OT, LTA,Lunch Allowance etc.
• Salary Break up and Designing CTC.
• Calculation of Gross , Net Salary & CTC
• Discussion on Compensation and Benefits.
• Attendance & Leave Management (CL, EL, SL, and ML)
• Preparation of Salary Sheet, Pay Slip, Full n Final Financial Statement Versions