Accounts, Tax, GST Training & E-Filing Course

This course will be taught in GST Demo Website/Real Government Website - GST Demo Portal

Here we will give you different data and help you practically file different challan and returns namely -

• E-Filing GSTR3B Return - Monthly Return of Regular Taxpayers
• E-Filing GSTR1 Return - Monthly/Quarterly Return of Regular Taxpayers through Offline Utility & Tally
• GSTR 4 - Annual return to be filed by Composition Dealers
• GST CMP-01 Return - Quarterly return for Composition Dealers
• GSTR 9 - Annual Return to be filed by All Dealers
• GST Challan E-payment Procedure
• E-way bill Generation from Tally
• Interest and Late Fees Calculation and Deposit at GST Portal
• Electronic Cash and Credit Ledger Online Checking and Computation
• Accounting in Tally Prime of GST Transactions from Real Bills
• Clearing Mismatch Reports in Tally for GSTR3B/GSTR1
• Making GST Reconciliation Matching GSTR2A, 3B and Tally Data and Adjustment of Differences
• GST Amendment - Adjustment of Mistakes in GST Return 3B and GST
• GST Portal Features - How to register, How to download Registration Certificate, How to make changes in return, Where to download various returns, How to check return filing status, How to check whether Quarterly/ Monthly Scheme to be opted, How to check, register and use Digital Signature (DSC) etc.

We will also be providing you practical assignments incorporating

• Basic Concepts of GST and its Applicability
• Accounting in Tally GST of different Sales and Purchase Transactions
• Making GST Tax Computations in Excel after adjustment of CGST, SGST, IGST Credit
• Understanding GST Input Tax Credit Implications
• Concept of Job worker in GST
• Concept of Input Service Distributor in GST
• Reverse Charge Mechanism Section 9(3) and Section 9(4) both
• Billing and Invoicing in GST-Tax Invoice/Bill of Supply/Revised Invoice
• TDS and TCS Implications in GST
• Comparison between Normal and Composition Scheme in GST
• Time of Supply and Place of Supply in GST
• Calculation of Late Fees and Interest in Various Scenarios
• Latest amendments and Interview Questions of GST

Practical Assignments in

• Accounting for TDS Receivable and Payable in Tally Prime
• TDS Rates - Deducting TDS as per different Rates of Income Tax
• Filing TDS Return Form 26Q
• Checking of Form 26AS to check TDS Deducted
• Procedure of Form 15CB and 15CA and Form 27Q
• Issue of TDS Certificates
• Concept of 15G and 15H Form
• Certificate of Lower Deduction
• Issue of TAN No
• TDS Late payment Interest and Penalty Calculation
• Form 26QB-TDS on Sale of Property
• Form 26QC-TDS on Personal Rent
• Form 27EQ –TCS Return for Tax Collected at Source
• Calculation of Late Fees and Interest Liability
• Checking Various TRACES Features like checking Interest-Penalty, Revision of TDS Returns Online And Offline
• Latest amendments and Interview Questions of TDS

• E-Filing ITR For Salaried Business from Real Form 16
• Advance Tax and Self Assessment Tax Computation and Deposit
• E-Filing ITR For Small Proprietorship through Software/Excel Utility
• Deduction for Partnership Salary/interest and E-Filing ITR For Partnership Business
• Deductions under Chapter VIA -Treatment of Various Savings
• Practical implications of Important Points of Different Incomes like Capital Gain (ITR2),2 House Property (ITR2),Single Rented or Self Occupied Property(ITR1),Sale of Shares and property
• Understanding Different points of Expense Disallowed
• Current Tax and Deferred Tax Computation for Companies
• Challan 280 Online and Offline Procedure
• ITR for Audit Case –Optional (ITR3 for Proprietorship,ITR5 for Partnership,ITR6 For Company,ITR 7 for NGO)

Practical Assignments in

• Deduction of TDS on Different Allowances and perquisites Salary components
• Deductions under Chapter VIA -Treatment of Various Savings of Employees
• Making Salary Structure for Employees-For Lowest Tax Liability
• Preparation of PF Computation and Online deposit of PF ECR
• Computation and Online deposit of ESI
• Making Salary Sheet and Disbursement of Salary
• Important forms/records to be maintained for handling Payroll
• Understanding Treatment of PF/TDS/ESI in case of Leave /New Joining
• Using Relevant Advanced Excel formulas for Payroll Processing
• Latest amendments and Interview Questions of payroll(TDS Salary/PF/ESI)
• Download of TDS Certificate Form (Form 16-Part A and B) for Employees
• E-filing of Form 24Q Return (Including Annexure II) for Quarter 4
• Calculation of Late Fees and Interest Liability
• Checking Various TRACES Features like checking Interest-Penalty, Revision of TDS Returns Online And Offline

Practical Assignments incorporating

• Passing Routine and Book Closure Entries in Tally Prime, clearing of suspense and Finalizing Data with GST TDS Returns
• Provisioning for Different Expenses and Payables
• Preparing Depreciation Chart as Per Companies Act and Income Tax Act
• Current and Deferred Tax Computation and its Provisioning
• Preparation of Bank Reconciliation Statement (BRS) in Tally Prime
• Ledger Scrutiny, Correction and Exporting Data in Excel
• Preparation of P&L A/C and Balance Sheet as per schedule III with notes to accounts
• Checking and Verification of Data as per Revised Schedule III

Practical Assignments in

• Accounting in Tally Prime with Different Taxes like GST and TDS
• Passing of Entries from Real Purchase Sales Bills and Bank Statements
• Billing and Invoicing from Tally-Generating Tax invoce and Bill of Supply
• Learning GST Settings in Tally and Clearing GST Mismatch Reports
• Bank Reconciliation in Tally and Debtor Aging in Tally
• Cost Center Reporting in Tally for Segment /Product Reporting
• Inventory Features in Tally And Godown Maintenance
• Using Tally Shortcuts, Understanding different Ledger Groups & Voucher Types
• Exporting and Importing Data from Tally to Excel

• Understanding Requirement of Tax Audit and Statutory Audit for Different Businesses
• Real-life examples of company audits and ROC filings
• Tax audit walkthroughs with real data and filing of Forms 3CA/3CB, Audit Report Under Section 44AB
• Appointment of Auditor – Form ADT-1
• KYC of Directors – Form DIR-3 KYC and Web KYC
• Filing ROC forms (AOC-4, MGT-7, DIR-12)
• Practical tax audit procedures using Real Data
• Audit Checklist-How to Validate Data for Audit
• How to File Form 3CA/3CB + Annexure Form 3CD
• Company Incorporation/firm registration (Optional)

• MIS for Finance - Creating daily/weekly/monthly financial dashboards
• Profitability analysis using pivot tables and charts
• Sales Report - Forecast vs. Actual
• Techniques for sales forecasting
• Creating a Sales Report in Excel
• Analyzing sales performance and forecast accuracy
• Overview of costing methods: absorption and variable costing
• Creating a Costing Report in Excel
• Analyzing cost structures and determining profitability
• Identifying segments and cost centers in an organization
• Allocating costs and creating comprehensive reports
• Analyzing performance metrics for decision-making
• Various financial forecasting techniques
• Creating a Financial Projection Report in Excel
• Using historical data for predictive modeling
• Managing accounts receivable and payable
• Creating Debtor and Creditor Aging Reports in Excel
• Performing reconciliations for financial accuracy
• Effective inventory management strategies
• Creating Inventory Reports to track stock levels and turnover
• Creating Inventory reorder and Level in excel
• Analyzing inventory costs for better control
• Creating a Cash Budget to project inflows and outflows
• Preparing Budget for income, expense and Branch wise
• Variance analysis of Actual vs budgeted

• Introduction to AI and Chat-GPT
• Chat-GPT login and basic usage
• Effective prompt engineering techniques
• Using Chat-GPT for Excel:
  • Formula generation and customization
  • Task automation (Data entry, Formatting, Calculations)
  • Report and dashboard generation
  • Troubleshooting and error handling
• Integration with MS Office:
  • Available Add-Ins and their limitations
  • Future integration possibilities

• Fund Flow Statement
• Cash Flow Statement
• Finance Ratio Analysis
• Finance - Term Loan Assignment
• Depreciation and Tax Calculation
• Projections Assignment
• MPBF Calculation
• CMA data Punching in Bank real Format

• Creating A New Company/Edit
• Creating a Chart/Ledger Of Accounts in SAP FICO
• Day to Day Income and Expense accounting entry with GST/TDS
• Reversal Entry for Corrections in SAP
• General Ledger Reports in SAP FICO
• Cash and Bank Accounting In SAP FICO
• Accounts Payable in SAP FICO
• Accounts Receivable in SAP FICO
• Fixed Assets Accounting in SAP FICO
• Month end Closing Process in SAP FICO
• Profit and Loss Report in SAP FICO
• Balance Sheet Report in SAP FICO

• Basics of Excel
• Excel Shortcuts and Tricks for faster work
• Basic of Vlookup
• Vlookup Advanced and using other formula with Vlookup
• Hlookup real case use
• If Command and Nested if
• Filtre, Countif, Countifs advanced case
• Conditional Sum,Sumif,Sumifs and Filters
• In Depth working in Pivot Tables and Charts
• What if Analysis Scenario Manager, Goal Seek
• Formatting and Sorting
• Password Protection of excel
• Index and Match
• Xlookup Basics and Advanced uses
• Data Validation
• Concatenate advanced use
• Text to Columns advanced use
• Conditional formatting basic and advanced uses
• Mixed Formula Assignment and large data set for Test and Interview preparation