DIPLOMA IN E-ACCOUNTING & TAXATION ( M-02 )

DETAILED COURSE DESCRIPTIONS

 

1.           Basic & Advanced Computers

 

·        Knowledge of Basic Computer

·        Fundamentals of Operating System

·        Desktop settings

·        Windows7/8/10 operating settings

·        Windows format and Install

·        Keyboard Fingering

·        Notepad

·        WordPad

·        MS-Paint

·        MS-Word Training

·        MS-Excel Training

·        MS-PowerPoint Training

·        Basic Designing

·        Using Google Sheets, Docs, Slide.

·        Using Internet and Browsers

 

2.           Manual Accounting

 

·        Basics of Accounting

·        Rules of Debit/Credit

·        Single/Double Entry System of Accounting

·        Sources of Documents (Cash Memo, Invoices of Bill, Receipts, Pay-in-Slip, Cheques etc.)

·        Vouchers Preparation, Daybook writing, Cash Book Preparation, Petty cash book etc.

·        Cheques & Deposit slip preparation.

·        Journal Entries

·        Ledgers & Groups

·        All Adjustment and year end entries.

·        Preparation of Trading and Profit/Loss Account.

·        Preparation Account Balance Sheet, Rectification Entries, Depreciation Entries.

·        Balance sheet Review/Analysis.

 

3.           Advance Tally Prime Training with GST

 

                  i.        Basic of Tally Prime

·        What is Tally

·        History & Versions of Tally

·        Overview of Software

·        Introducing Gateway and its elements

·        Fundamentals of tally

               ii.        Company Info

·        How to Create company & Alter company

·        How to Select company & Shut company

·        How to apply Security control

·        How to Change tally vault

·        How to Split company data

·        How to take Back up & Restore Back up

 

             iii.        Vouchers Entries

·        Payment voucher entry 

·        Receipt voucher entry

·        Journal voucher entry

·        Sales voucher entry

·        Purchase voucher entry

·        Debit note voucher entry

·        Credit note voucher entry

·        purchase order entry

·        Sales order entry

·        Receipt note entry

·        Delivery note entry

·        Rejection out entry

·        Rejection in entry

·        Stock journal entry

·        Manufacturing journal entry

·        Physical stock voucher entry

 

              iv.        Accounts & Inventory Information

·        How to use Accounting features 

·        How to use Inventory features

·        How to activate Functions in accounts info. Menu

·        How to prepare Ledgers & Groups Tally Prime

·        How to set Inventory configurations & features Inventory info. Menu

·        How to set up Stock groups

·        How to set up Stock categories

·        How to create Stock items

·        How to create Units of measurement

·        How to create Bills of materials Locations / Godown 

·        Inventory voucher types

·        How to create cost categories & cost Centre’s

·        How to configure Cheque printing

·        How to set Credit limits

·        How to do Bank Reconciliation

                v.        Advanced Accounting in Tally Prime

·        Bill wise details.

·        Cost Centre’s and Cost categories

·        Voucher classes

·        Interest Calculations

·        Budgets & Controls

·        Banking

 

              vi.        Advanced Inventory in Tally Prime

·        Order Processing

·        Sales/purchase Order

·        Multiple Price Level

·        Batch-wise Details

·        Bill of Material (BOM)

·        Multiple Price Level & Price Lists

·        Stock Valuation

·        Zero Valued Entries

·        Different Actual and Billed Quantities

·        Job Order Processing

·        POS (Point of Sales)

·        Security Control

 

           vii.        GST (Goods & Services Tax)

·        Activating GST for your company.

·        GST Tax Invoice

·        Multiple Tax Invoice

·        Creating Sales (Nil Rated, Exempt, Zero Rated) invoice

·        Setting up GST Rate

·        Updating GST in Stock Items & Groups

·        Updating Party GSTIN

·        Reverse Charge Mechanism (RCM) in GST

·        GSTR-3B, GSTR-1

·        Understanding GSTR-2A/2B

·        GST Tax Adjustment Entries

·        GST Refund Adjustment Entries

·        GST Tax Adjustment Entries with Cash/Credit Ledgers

 

         viii.        Payroll

·        How to Enabling payroll in tally

·        How to generate pay slip

·        How to Create Payroll Masters, salary structure & leave details

·        How to pass Payroll Voucher Entry

·        How to view Statements of payroll

·        How to Create/view Attendance-Reports

·        How to view Payroll Statutory Reports

·        Payroll Statutory Computation Employees Provident Fund (EPF) Reports Employees State -Insurance  (ESI) Reports Professional Tax Report

 

             ix.        TDS (Tax Deducted at Source)

·        What is TDS Process

·        Enable/Activate TCS for Your Company

·        How to prepare and Issue of TDS

·        Enabling TDS

·        What is Nature of TDS related payments Deductee types 

·        How to Create TDS Masters (Expense ledger, Party Ledger, Tax ledger) 

·        How to pass TDS Voucher Entries/Transactions

·        How do pass TDS on expenses (Journal Voucher) 

·        How to pass Expenses partly subject to TDS (Journal voucher) 

·        How to do Accounting multiple expenses and deducting TDS later 

·        How to record TDS on advance payments 

·        How to do Adjusting advances against the bill 

·        How to Changes in TDS Percentage Computation 

·        TDS Challan Reconciliation

 

                x.        TCS (Tax Collected at Source)

·        What is TCS Process

·        Enable/Activate TCS for Your Company

·        How to prepare and Issue of TCS

·        Enabling TCS

·        Record TCS Advance Receipt Entry

·        Record TCS Receipt Entry

·        Record TCS on Sales with GST

·        Record TCS on Purchase with GST

 

             xi.        Display of Reports

·        Accounting Reports, Trial Balance, Profit & Loss, Balance Sheet.

·        Inventory Reports, Stock Summary

·        Sales & Purchase Register

·        Tax Reports-Challans, Registers

·        E-Filling GST(GSTR-3B, GSTR-1)

·        Payroll Reports pay slips, Salary Register, MIS Reports.

·        Receivables and Payables

 

4.           Advance BUSY Accounting Software Training with GST

 

              i.        Company Setup in Busy

·        Introduction of Busy

·        Downloading & Installation of Software

·        Creating company

·        Edit & Delete a Company

·        Overview of Software

·        Company Backup & Restore

·        Understanding Features & Options

·        Introducing Gateway and its elements

 

           ii.        Administration in Busy

·        Creating Masters

·        Creating Ledgers and Groups

·        Alternation & Deletion of Masters, Ledgers & Groups

·        How to merge different Masters

·        Creating Accounts/Accounts Groups/Std. Narrations.

·        Creating Item, Item Groups, Unit

·        Creating Sale/Purchase Type

·        Creating Tax Category

 

         iii.        Passing Transaction in Busy

·        Passing Sales/Purchase voucher entry

·        Passing Receipt/Payment voucher entry

·        Passing Journal voucher entry

·        Passing Debit note/ Credit note voucher entry

·        Passing Sales/Purchase order entry

·        Passing Transaction with Cost Centre’s & Categories

·        Passing Sale and Purchase transaction

·        Creating Budgets Entries

·        Passing transaction related to Budget.

·        View Budget variance

·        Creating BOM (Bill of Materials) for Manufacturing Goods.

·        Passing Goods Assembling Entry

·        Creating & Passing Service Bills

 

          iv.        Features & Options in Busy

·        Vouchers Configurations

·        Master Configurations

·        Account/Documents Printing

·        Accounts Vouchers Printing

·        Bank Reconciliations

·        Export and Import Data in Busy

·        Stock Management

·        Background and LOGO Setup in Busy

·        User management

·        Other Reports

 

            v.        GST(Goods & Services Tax)

·        GST Tax Invoice

·        Multiple Tax Invoice

·        Creating Sales (Nil Rated, Exempt, Zero Rated) invoice

·        Setting up GST Rate

·        Updating GST in Stock Items & Groups

·        Updating Party GSTIN

·        Reverse Charge Mechanism (RCM) in GST

·        GSTR-3B, GSTR-1

·        Understanding GSTR-2A/2B

·        GST Tax Adjustment Entries

·        GST Refund Adjustment Entries

·        GST Tax Adjustment Entries with Cash/Credit Ledgers

·        E-Way Bills

 

          vi.        Payroll Management in Busy

·        How to Enabling payroll in tally

·        How to generate pay slip

·        How to Create Payroll Masters, salary structure & leave details

·        How to pass Payroll Voucher Entry

·        How to view Statements of payroll

·        How to Create/view Attendance-Reports

·        How to view Payroll Statutory Reports

·        Payroll Statutory Computation Employees Provident Fund (EPF) Reports Employees State -Insurance  (ESI) Reports Professional Tax Report

 

       vii.        TDS (Tax Deducted at Source

·        What is TDS Process

·        Enable/Activate TDS for Your Company

·        How to prepare and Issue of TDS

·        What is Nature of TDS related payments Deductee types 

·        How to Create TDS Masters (Expense ledger, Party Ledger, Tax ledger) 

·        How to pass TDS Voucher Entries/Transactions

·        How do pass TDS on expenses (Journal Voucher) 

·        How to pass Expenses partly subject to TDS (Journal voucher) 

·        How to do Accounting multiple expenses and deducting TDS later 

·        How to record TDS on advance payments 

·        How to do Adjusting advances against the bill 

·        How to Changes in TDS Percentage Computation 

·        TDS Challan Reconciliation

 

     viii.        TCS (Tax Collected at Source)

·        What is TCS Process

·        Enable/Activate TCS for Your Company

·        How to prepare and Issue of TCS

·        Enabling TCS

·        Record TCS Advance Receipt Entry

·        Record TCS Receipt Entry

·        Record TCS on Sales with GST

·        Record TCS on Purchase with GST

 

         ix.        MIS Reports & Display of Reports

·        Accounting Reports, Trial Balance, Profit & Loss, Balance Sheet.

·        Inventory Books & Stock Register

·        Sales & Purchase Register

·        Material Inward and Outwards Reports.

·        Tax Reports-Challans, Registers

·        TDS Reports

·        Payroll Reports Pay slips, Salary Register, MIS Reports.

·        Receivables and Payables

·        Printing and Export in PDF, EXCEL etc.  all types of Reports, Transaction in Busy.

 

5.           GST(Goods & Services Tax)      Training on Portal

 

              i.        Introduction

·        GST Introduction

·        Overview of GST

·        Impact of GST

·        Different rates and provision of GST

·        Introduction of GST Council

·        Introduction of GST Returns

 

           ii.        GST Registrations

·        Overview of GST Registrations

·        Types of GST Registrations

·        Documents of GST Registrations

·        GST Registrations on Portal (Practical)

·        Amendment in GST Registration in Core Fields (Business Name, Business Reg. Address, Additional Place etc.) (Practical)

·        Amendment in GST Registration in Non-Core Fields(Promoters/Partners/Director details, Mobile No., Mail ID, Bank Accounts, HSN/SAC Codes. (Practical)

·        Cancellation of GST Registrations (Practical)

·        GST Registration-Filling Clarification(Practical)

·        GST Registration-Tracking Submitted Applications(Practical)

·        GST Registration-Viewing Submitted Applications(Practical)

·        Opting/Withdrawal of Composition Levy in GST Portal(Practical)

 

         iii.             GST Ledgers & Invoice

·        Make GST Invoice for Regular & Composite Dealer (Practical).

·        Record and maintain of Invoice in Bill to Ship to Transactions (Practical).

·        Prepare and understand Cash & Credit Ledgers(Practical)

·        GST Set off Rule of Payable/Refund Management. (Practical)

 

          iv.        Model IGST Law

·        Important Definitions

·        Determinations of supply

·        Place/Time/Value of supply

·        Zero Rated Supply

·        Composite & Mixed Supply

 

            v.         Input Tax Credit(ITC)

·        Eligibility & Conditions for taking ITC(Section-16)

·        Adjustment ITC Set off Rule (Practical)

·        ITC for Job Work

·        Block Credit Under GST(Section 17)

·        ITC Distributions of ISD(Input Service Distributions)

 

          vi.        GST Payments

·        GST Payments(Tax, Penalty, Interest, Late fees and other) (Practical)

·        Creation of Challans (Practical)

·        Mode of GST Payments(Cash, Cheques, NEFT/RTGS, E-Payment, etc,) (Practical)

       vii.        GST Returns

·        Make GST Computation(Practical)

·        Calculate Tax Liability(Practical)

·        Filling of Nil GST Returns(Practical)

·        Filling of GSTR-1(Practical)

·        Filling of GSTR-3B(Practical)

·        Filling of GSTR-9/9C(Practical)

 

     viii.        Assessment & Audits

·        Understanding GSTR-2A/2B(Practical)

·        Reconciliation of Sale with GSTR-1(Practical)

·         Reconciliation of Purchase with GSTR-2A/2B(Practical)

·        Documents Required during Assessment

 

         ix.        Miscellaneous Topics

·        Filling of Different Refund Forms(Practical)

·        Understanding Refund Process

·        TDS/TCS in GST

·        Input Service Distributor

·        Filling of LUT(Letter of Undertaking) Forms for Export Cases(Practical)

 

            x.        E-Way Bill & E-Invoice

·        E-way Bill Overview

·        E-way Bill Registration(Practical)

·        E-Way Bill Creation, Alter & Cancellation Online(Practical)

·        Update Part-B(Vehicle Information) (Practical)

·        Extend E-Way Bill Validity(Practical)

·        E- Invoicing Under GST

·        E-Invoice Limits and Applicability

·        Process of Getting E-Invoice

·        E-Invoice Benefits

 

6.           Income Tax E-Filling Training

 

                       i.            Introduction of Income Tax

                     ii.            Basic Concept of Income Tax

                   iii.            Introduction of Different ITR Forms

                   iv.            Selection of ITR Forms

                     v.            Registration on Income Tax Portal(Practical)

                   vi.            View/Download form 26AS(Practical)

                 vii.            Heads of Income & Computation of Income Tax(Practical)

               viii.            Income under Head Salaries

                   ix.            Income under Head House Property

                     x.            Income under Head Profits and Gains of Business or Profession

                   xi.            Income under Head Capital Gains

                 xii.            Income under Head Income from other Sources

               xiii.            Set Off and Carry Forward of Losses

               xiv.            Deductions in Computing Total Income

                 xv.            Calculation of Tax Liability (As per Slab Rate)(Practical)

               xvi.            Calculate and Payment of Advance Tax, Self Assessment Tax etc.(Practical)

             xvii.            E-Filling of Income Tax Returns ITR-1 & 4 (Practical)

           xviii.            Downloading Previous Returns(Practical)

               xix.            Verification of ITR(Practical)

                 xx.            Points to be kept in Mind for Avoiding Income Tax Notices, Demands & Penalty.

       xxi.        Other Miscellaneous Topics

 

7.           TDS Return Filling Training

 

                       i.            Introduction of TDS

                     ii.            Introductions of TDS on Various Services

                   iii.            Different Entries of Calculations of TDS

                   iv.            Calculation of TDS on Salary(Practical)

                     v.            Calculation of TDS on Non-Salary (Rent, Work Contract, Professional Service, etc.) (Practical)

                   vi.             Payment of TDS through Challan(Practical)

                 vii.            Check form 26AS(Practical)

               viii.            Understanding Form 16/16A

                   ix.            Preparation and calculation of TDS Data. (Practical)

                     x.            Download TDS Return Preparation Utility(Practical)

                   xi.            Filling of TDS Return Filling (Form 24Q, 26Q) (Practical)

                 xii.            Generation of FVU Files and Submission on Income Tax Portal(Practical)

               xiii.            Downloading filed Returns(Practical)

 

8.           Advance Excel Training

 

              i.        Basic Excel

·        Introduction of Excel

·        Basic understanding menu & toolbars.

·        Sorting & filtering

·        Find & Replace, Go to & Paste Special

·         Tabs & Options

 

           ii.        Advance Excel

·        Introduction about Formulas & Functions.

·        About Operator & their uses.

·        Working with formulas & functions.

·        Introduction of Home Tab (Paste Special & Format Painter, Cell formatting, Text Controls, Advanced conditional Formatting(with Formulas), Sorting & Filtering, Advanced Find & Go to Special etc.)

·        Insert, View & Page Layout Tab (Creating & Running Macros, Chart, Picture, Smart art, Screenshot, Insert Links, and Header & Footers, Page Setup, Margins, Print Settings, Print Area, Workbook views, Freeze Panes, Scale to fit, Sheet Options & Print titles, etc.)

·        Review Tab (Insert Comments, Spelling & Grammar, Protect sheet & Workbook, Share Workbook, Track Changes etc.)

 

         iii.        Advance Excel : Formulas & Functions

·        Math’s & Trig Numeric Information’s: Abs,Gcd,Lcm.

·        Mathemical Operations: Sum, Product, Power, Sqrt, Mod, Aggregate.

·        Conditionals Sums : Sumif, Sumifs

·        Advanced mathematical Operations: SumProduct, Sumsq etc.

·        Other Operations: Round, Roundup, Round down, Rand, Randbetween, Fact, Roman etc.

·        Text Functions: Len, Left, Right, Mid, Lower, Upper, Proper, Rept, Substitute, Trim, Value, find, Concatenate, Replace etc.

·        Financial Functions: Pmt, Ppmt, Ipmt, Pv, Fv, Rate etc.

·        Date & Time Functions: Day, Hour, Minute, Month, Now, Today, etc.

·        Logical & Reference Functions: Vlookup, Hlookup, Match, Get Pivot Table, And, or, True, False, Address, Index, Offset, Hyperlink, Transpose, Formulatext etc.

·        Statistical Functions: Max, Min, Count, Counta, Countblank, Countif, Countifs, Average, Agerageif, Mode, Frequency, Rank, Etc.

 

          iv.        Advance Excel : Features & Techniques

·        Advanced Conditional Formatting using functions.

·        Advanced filter, filter, to cross sheet and workbook.

·        What if Analysis (Goal Seek, Data Tables, Scenario Manager).

·         Searching Technique with Go To Special.

·        Lookup to Left with Index & Match.

·        Loan EMI Calculator in Excel.

·        Tax calculator in Excel.

·        Interest Calculations various Types

·        Bank Statement & Calculations

·        Creating Payroll & Salary Sheet.

·        Salaries calculate in Excel.

 

            v.        Advance Chart Techniques

·        Advanced Chart Technique

·        How to make Dynamic Charts, Bar Charts, Pie Charts, Pie Charts, Scatter Charts, Line Charts, Column Charts, Speedometers charts, etc.

 

          vi.        Advance Excel Security

·        Protecting Excel file, Protecting worksheets, Workbooks, Enable/Disable Range.

·        Allow user to edit range, protecting users to edit range.

·        Filed Controls using customized user access.

 

       vii.        Macros

·        What is Macros?

·        Creating Excel Macro.

·        Running Macros and Editing.

·        Automating Tasks with micro.

 

9.           Interview Preparations & Personality Development Training

 

                       i.            Guide and help for cracking any interview.

                     ii.            Improve your personality while facing interviews.

                   iii.            Mock interviews

                   iv.            Help in build resume.

                     v.            How to introduce your self

                   vi.            Give different types of method to crack an interview.

 

10.  Important Miscellaneous Topics

 

                       i.            How to make and use Google Word & Excel Sheets.

                     ii.            How to make PAN/TAN Applications on NSDL and UTTITSL Websites.

                   iii.            How to apply for GST Certificate.

                   iv.            How to apply for MSME/ Udyam Certificate.

                     v.            How to apply for an Import Export Certificate (IEC).

                   vi.            How to apply for food license (FSSAI).

                 vii.            How to apply for GEM (Govt. E-Marketplace).

               viii.            How to apply for and Startup Registrations.

Point of Distinction	NR Computer Academy	Other Training Institute
Learning data	Actual Real Company Data	Dummy Data
Learning Methodology	Practical Concept	Theoretical aspect
Trainer	Professional & Corporate Trainers	Teacher
Course Content	Real Accounting & Practical Data, Tax knowledge with Actual e-filling of returns and practice to gain expertise.	Learning on dummy data, slide show presentation & without practice.
Live Projects	Actual Company data to finalise Accounts and filling of returns	Dummy project data
Tax Training	Live on Government Portal with real login id & passwords of our client	On Taxation software, 3rd Party Software or on replica website
Software used while Training	On licenced version Software	On Educational Version Software
E-filling	On Government online portals e.g. Income Tax, GST Etc.	Replica website
Practice	Daily additional hrs & Weekends	Not allowed or provided

Course Eligibility:-10+2 or equivalent and above.

Job & Work Profile: - Accountant, Account Executive, Accounts Trainee, Billing Executive, Tax professionals & Consultants etc.

After course knowledge level:- Able to operate computer and manage all Accounting in Tally or Busy in different companies & firms, prepare & file GST Returns online/offline, Income Tax E-filling, TDS/TCS Payments and Returns online, prepare and manage MIS Reports in excel etc.

Duration: - 6 to 8 months

·        Regular Classes- 5 Days in Week (Morning, Day time & Evening)

·        Weekends Classes- (Saturday, Sunday & Holidays)

·        Fast-Track classes also available.

Course Fees:-13999/-