E-Accounting & E-Taxation Program

150 students

E-Accounting, E-Taxation and E-GST Programme Modules

 

E-Accounting, E-Taxation and E-GST(Goods and Services Tax) Training Course

Module 1 – GST- Goods and Services Tax- By Chartered Accountant- (Indirect Tax)

Module 2 – Income Tax and TDS – By Chartered Accountant (Direct Tax)

Module 3 – Finalization of Balance sheet/ preparation of Financial Statement- By Chartered Accountant

Module 4 – Customs / Import and Export Procedures – By Chartered Accountant

Module 5 – Advanced Tally ERP 9

Module 6 – Advanced Excel and MIS For Accounts and Finance- By MIS Analyst

Module 7 – Payroll Processing – By HR Manager

Module 8 – Banking and Finance Instruments – By Chartered Accountant

Module 9 – SAP FICO

E-Accounting, E-Taxation and E-GST(Goods and Services Tax) Training Course

 

 

 

Module 1.1 – Basic of GST Overview of Model GST Law

  • Principles
  • Important Definitions. (Section 2)
  • Why GST is Necessary?
  • Impact of GST.
  • Benefits/ Demerits.
  • Different Rates of GST.
  • FAQ

Module 1.2 GST Migration and Registration under Model GST Law with GST Rules and Formats

  • Migration of Existing Dealer.
  • Registration Structure under GST.
  • Persons required to be registered.
  • Process of Registration.
  • Amendment in Registration.
  • Cancellation of Registration.
  • Forms for GST Registration
  • GST REG-01- Application.
  • GST REG-02- Acknowledgement.
  • GST REG-06- Certificate.
  • REG-01 to REG-30
  • FAQ

Module 1.3 – Returns Under GST Section (37-48) with GST Rules and Formats – 10 Hrs

  • Definition and 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, 3B
  • FAQ

Module 1.4 – Refunds – Section 54-58 with GST Rule

  • 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)
  • FAQ

Module 1.5 – Input Tax Credit – Section 16-21 with GST Rules

  • Eligibility and 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)
  • FAQ

Module 1.6 – Electronic Commerce in GST – Section 52

  • Definitions
  • Collect of Tax at Source – E Commerce
  • FAQ

Module 1.7 – Job Work and Composition Levy in GST

  • Special Provision for Job Worker
  • Composition Levy Section 10
  • Quarterly Return for Compounding Taxable Person GSTR-4
  • FAQ

Module 1.8 – Other Topics – with GST Rules and Formats

  • Payment of Tax, Interest, Penalty and other charges Section 49
  • Interest on delayed payment of tax Section 50
  • Tax Deduction at source Section 51
  • Tax Invoices Section 31
  • Time and Value of Supply Section (12-15) Chapter IV
  • Transitional Provisions Section (139-142) Chapter XX
  • FAQ

Module 1.9 – Government to Roll out E-way Bill

  • Identify E-Way Bill Generation Scenarios Under GST
    • Identify -various movements which take place on daily basis
    • Sale, purchase – goods sent for repairs, job work, sales return, purchase return, imports and exports
    • Transactions with unregistered dealers etc.
  • Fix Responsibility Fore-Way Bills
    • Agreements with business participants on roles/responsibilities
    • Updating E-Way Bill in case of change in conveyance
    • Breakdown of conveyance
    • Expiry of validity of E-Way Bill
    • Return of goods from customer premises without acceptance, etc.
  • Obtain GST Registration Number
    • Prerequisite for generation of E-Way Bill
  • ID From Transporters
    • Transporter ID needs to be available before goods are dispatched
  • Update Pin Codes
    • Pin codes are mandatory field in E-Way Bill formats
  • Generation login id password on E-Way Bill portal
  • Assess Personnel Requirement For Generation E-Way Bills
  • Assess Personnel Requirement For Generation E-Way Bills
    • Manpower which will require to undertake E-Way Bill compliances
    • Additional manpower particularly for initial few months till system stabilizes
  • Stay updated with developments in E-Way Bill
  • FAQ released by the government
  • regular updates from government

 

Module 2.1 Basic Concepts

  • Person V/S Assessee
  • Advance Tax
  • Advance Tax
  • Interest under section 234A/B/C
  • Gross Total Income and Its Components
  • Salary
    • Basic Salary
    • Allowances (Exempted and Non Exempted)
    • Perquisites –(Valuation)
  • House Property
    • GAV
    • M.Taxes
    • NAV
    • Deduction u/s 24 (Statutory and Interest)
  • Profit and Gains From Business Profession
    • Expenses Allowed and Expenses Disallowed
    • Depreciation and Additional depreciation
    • TDS Compliances and computation of business income
    • Expenses allowed on actual basis
    • Cash Payment in excess of Rs.10,000.
    • Payment to related person
    • Deemed income
    • Presumptive income
    • Set off and carry forward of Business Loss
    • Carry Forward of unabsorbed depreciation
    • Maintenance of Books of accounts
    • Audit of Books of accounts
    • Introduction to ICDS
  • Capital Gain
    • Charging Section
    • Intro To Capital Assets, Holding Period and Transfer
    • Full Value Consideration
    • Cost of Acquisition
    • Sec 50C Stamp Value to be adopted as FVC
    • Capital Gain on Transfer of Shares and Debentures
    • Rates of Taxes on Capital Gain
    • Exemption under section 54
    • Set off and Carry Forward of capital loss
  • Other Sources
    • Income liable under other Sources
    • Deduction Available

Module 2.2 Deductions Under Chapter Via

  • Deduction on The Basis Of Payment
    • LIC,F.D, PPF, ELS,Tution Fee, House Loan ,NPS, etc (Sec 80C/80CCC/80CCD/80CCE)
    • Medical Insurance (Sec 80 D)
    • Deduction for handicapped dependent (80DD)
    • Deduction for Education Loan Interest (80 E)
    • Deduction for House Loan Interest (80 EE)
    • Deduction for Donation (80G)
    • Deduction for handicapped assessee (Sec 80U)
  • Deduction on the basis of Income (Home Assignment)
  • Other Deductions

Module 2.3 Income Tax Return Preparation

  • 3 ways to prepare Return and filing of Return
    • Filing of return through ITR Utility
    • Filing of Return through Software (Taxman) utility
    • Filing of Return through Tax Cloud Computing System
  • General Information Required in all type of ITR
    • Assessee Type Selection
    • Residential Status
    • Section under which return is to be filed
  • ITR-1
    • Low Value Assesse but doesn’t have Business Income
    • Documents Required for ITR-1 (Form 16/26AS/Bank Statement/Investment Detail)
    • Discussion on Different fields of ITR-1 and Assignment.

Module 2.4 Income Tax Return Preparation ITR-2

  • High value asessessee but no business income
  • 26 AS Reconciliation
  • Capital Gain Computation and supporting Documents
  • Demat Account Detail (If Applicable)
  • Bank Statement Detail
  • Income from Other Sources other than Interest
  • Address of properties bearing income
  • Schedule of Set off and carry forward of losses
  • EMI schedule from bank of Housing Loan

Module 2.5 Income Tax Return Preparation ITR-3

  • Assesee having business income
  • 26 AS Reconciliation
  • Capital Gain Computation and supporting Documents
  • Demat Account Detail (If Applicable)
  • Bank Statement Detail
  • Income from Other Sources other than Interest
  • Address of properties bearing income
  • Schedule of Set off and carry forward of losses
  • EMI schedule from bank of Housing Loan
  • Profit and Loss Account and Balance Sheet with Schedule
  • Audit Report

Module 2.6 Income Tax Return Preparation

  • ITR-4 (Applicable for Assessee who opted for Presumptive income)
  • ITR-5 (Applicable for Assessee other than Individual, HUF, Company and person filing return in ITR 7)
  • ITR-7 (Applicable for Specified Assessee availing Exemption under section 11/12)

Module 2.7 Income Tax Return Preparation ITR-6 (Applicable for Companies)

  • Introduction to Company
  • MAT an Introduction
  • Special Provision Applicable for Companies
  • Depreciation Schedule
  • 26 AS Reconciliation
  • Audited Profit and Loss account and Balance Sheet
  • Audit Report
  • Applicability of ICDS and its impact
  • Dividend Distribution Tax

Module 2.8 Tax Deducted At Sources

  • Introduction to TDS
  • Related and other linked provision
  • Lower TDS
  • TDS on Salary (Sec 192)
  • TDS on Interest (Sec 194A)
  • TDS on Commission (Sec 194H)
  • TDS on Professional Services (Sec 194J)
  • TDS on Rent (Sec 194I)
  • TDS on Contract (194C)
  • Section 195 to be read with Section 9 for Non Resident
  • Other provisions of TDS

Module 2.9 Tax Deducted At Sources

  • TDS Payment
  • TDS Return on Taxman Software
  • TDS return Practice on Cloud computing System
  • TDS return through Return Prepare Utility (PPT)
  • Consequences for Non Deposit of TDS
  • Consequences for Non Filing of TDS Return
  • TDS demand and resolution

Module 2.10 Tax Deducted At Sources

  • TRACE online Introduction
  • Downloading the Conso. File from TRACES
  • Filing Correction Statement (Challan Mismatch and PAN Mismatch)
  • Downloading Form 16/16A
  • Registering DSC on TRACE
  • Revised Return
  • Application For TAN

 

  • 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.
  • An overview of Indian GAAP(Generally Accepted Accounting Principles) and Ind AS and its applicability on Finalization of accounts.
  • 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)

 

Customs:

  • How to Deal with Import and Export
  • Import and Export Procedure
  • Import Documents
  • Import Procedure
  • How to Release the Dollar from Banks to Pay Outside India A-1/A-2
  • Export Procedure
  • Export Document
  • Bill of Entries
  • Bill of Lading

Module 5.1 – Basic of Tally 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 and Reports

Module 5.2 – Tally ERP 9 and Inventory Management

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

Module 5.3 -Accounting Management Through Advanced Tally ERP 9

Module 3A – Bill –Wise Details

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

Module 3B – Accounting Ledgers Details

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

Module 3C – Cost Centres and Cost Categories

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

Module 3D – Voucher Classes

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

Module 3E – Multiple Currencies

Module 3F – Interest Calculations

Module 3G – Budget and Controls

Module 3H – Banking

Module 5.4 – Production and Stock Management Through Tally ERP 9

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

Module 5.5 – TDS

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

Module 5.6 – Payroll Management in Tally ERP 9

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

Section B

Module 5.1 – Tally ERP 9 and GST Compliance

  • 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 Ledgers
  • 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
  • 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
  • OBJECTIVE:
  • Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools
  • Topics Covered:
  • Advanced Excel
  • Lookup and Reference Functions:-VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’sSum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct.
  • Text Functions and Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.
  • Logical Functions:-And, Or, If, Iferror, Not, Nested If, Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min
  • Data Management:- Data Collection Method With Data Quality, Collaboration and 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,
  • Advanced Chart, Graph and Dashboard:- Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table
  • Advanced Filter, Validation and Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split.
  • Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
  • PF Computation and Deposit of ECR
  • ESI Challan Deposit and Return
  • Taxability of Different Allowances and Perquisites
  • Deductions (Tax Savings) Under Chapter VI A
  • Salary (PF, ESI, Basic, HRA, DA, MA etc)
Module 8 – Banking and Finance Instruments
  • 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

 

Curriculum is empty
₹75,000.00 ₹27,500.00

Leave a Reply

Please Subscribe

 

PLEASE SUBSCRIBE FOR MORE EDUCATIONAL NEWSLETTER & UPDATES

Recent Posts

E-Global India Institute vision 2026
E-Global India Institute vision 2026

STUDENT RESULT

EGIIT RESULTS