E-ACCOUNTING & TAXATION - Contents
Module 1 - M.I.S (Management information System)
E-ACCOUNTING & TAXATION
MS - WORD
GETTING STARTED WITH MS-WORD
- Navigate in Microsoft Word
- Create and Save Word Documents
- Manage Your Workspace
- Edit Documents
- Preview and Print Documents
- Customize the Word Environment
FORMATTING TEXT & PARAGRAPHS
- Apply Character Formatting
- Control Paragraph Layout
- Align Text Using Tabs
- Display Text in Bulleted or Numbered Lists
- Apply Borders and Shading
WORKING MORE EFFICIENTLY
- Make Repetitive Edits
- Apply Repetitive Formatting
- Use Styles to Streamline Repetitive Formatting Tasks
MANAGING LIST
- Sort a List
- Format a List
ADDING TABLES
- Insert a Table
- Modify a Table
- Format a Table
- Convert Text to a Table
INSERTING GRAPHICS & OBJECTS
- Insert Symbols and Special Characters
- Add Images to a Document
CONTROLLING PAGE APPEARANCE
- Apply a Page Border and Color
- Add Headers and Footers
- Control Page Layout
- Add a Watermark
- Learn to set the page orientation as portrait or landscape.
- Learn to set the print size of the paper.
- Learn to split your text into multiple columns.
- Learn to add page breaks.
- Learn to add section breaks.
ADVANCED MAIL – MERGE
- Beginning a Mail Merge
- Using Excel for Mail Merge Data
- Previewing Merge Letters
- Selective Merge Records
- Filtering
- IF Then Else Fields
- Include Text Fields
- Mail Merge to Email
PREPARING TO PUBLISH A DOCUMENT
- Check Spelling, Grammar, and Readability
- Use Research Tools
- Check Accessibility
- Save a Document to Other Formats
- The Macro Recorder
- Recording Macros
- Testing Macros
- Running Macros
ADVANCE MS - POWERPOINT
CREATING PRESENTATION
- Blank & Sample Templates
- Adding Text
- Bullet & Numbered Lists
ADDING GRAPHICS
- Capture Images & Insert Pictures
- Photo Album
- Drawing Shapes
- Advanced Shapes
- Merge Shapes
- WordArt
- SmartArt Graphics
MODIFY OBJECTS
- Crop, Resize & Style Objects
- Formatting Objects
- Grouping Objects
- Object Ordering & Layering
- Gridlines & Guides
TABLES
- Insert & Formatting Tables
- Insert Table from Word
- Manipulating PowerPoint Tables
- Inserting a Word Table
- Inserting an Excel Spreadsheet
- Adjusting Rows, Columns, Cells
- Table Styles and Borders
CREATE & MODIFY CHARTS
- Inserting a Chart
- Working with Datasheets
- Applying a Chart Type, Style and Layout
- Displaying Chart Analysis
- Picture Charts
- Formatting Chart Background
TEMPLATES , THEMES & LAYOUTS
- Creating a Custom Layout
- Applying a Theme
- Applying a Background Style
- Saving a Custom Theme
- Arranging and Printing Section
CUSTOM DESIGN TEMPLATES
- Slide Master
- Background Graphics
- Custom Slide Layouts
- Advanced Custom Themes
- Add Headers & Footers
- Modify Notes Master
- Edit Handout Master
- Create Custom Template
EDITING SLIDE MASTERS
- Slide Master, Title Master
- Formatting the Masters
- Adding Header and Footer Information
- Notes and Handout Masters
ANIMATINS & TRANSITIONS
- Animation Schemes
- Animating Text and Objects
- Custom Animations and timing
- Inserting Sounds and Video
- Editing Media Clips
SETTING UP THE SLIDESHOW
- Setting Automatic Slide Timings
- Setting Up a Continuous Loop
- Hiding a Slide
- Rehearsing Slide Transition Timings
CUSTOM SHOWS & INTERLINKED SHOWS
- Creating a Custom Show
- Setting Up a Custom Show as the Default
- Creating a Hyperlink
- Using a Hyperlink
- Using an Action Buttons
- Jumping to Another Presentation
PACKAGING PRESENTATIONS
- Embedding the Fonts in a Presentation
- Using the PowerPoint Viewer
- Formatting a Presentation for the Web
- Inspecting the Document
- Annotating a Presentation
- Sending in PDF Format
USING SMARTART
- Inserting a SmartArt Object
- Formatting a SmartArt Object Color
- Resizing/Repositioning a SmartArt Object
- Inserting Text into a SmartArt Object
- Formatting Text Within a SmartArt Object
- Adding Shapes to a SmartArt Object
- Grouping SmartArt Objects
INSERTING A PHOTO ALBUM
- Inserting Pictures from a File
- Adding Captions
- Applying a Theme to your Album
- Customizing the Album Layout
SPECIAL EFFECTS
- Insert, Trim, Fade & Bookmark Audio
- Insert, Trim, Fade & Bookmark Videos
- Advanced Animation
- Motion Paths
CUSTOMIZING PRESENTATION
- Insert, Trim, Fade &
- Custom Slide Shows
- Setup Slide Show & Presenter View
- Secure PowerPoint Show
- Hyperlinks
- Action Buttons & Link Actions
- Annotate
- Record Narration
- Rehearse Timings
COLLBORATING
- Merge & Compare
- Insert Comments
- Slide Library
- OneDrive & Coauthoring
SECURE & DISTRIBUTE
- Merge & Compare
- Present Online
- Create Video Files
- Package Presentation
- Publish to PDF or XPS
- Document Properties
- Document Inspector
- Password Protect
- Digital Signature
- Mark as Final
- Screen Recording
- Closed Caption
- Equations & Ink
ADVANCE MS - EXCEL
MATHEMATICAL & STATICAL FUNCTIONS
- Sum
- Product
- Average
- Ceiling
- Floor
- Round
- Round Up
- Round Down
- Power
- Count
- Counta
- Maximum
- Minimum
- Mode
- Median
- Log
- Dollar
- Average A
- Mina
- Maxa
- Large
- Sqrt
- Mod
- Roman
- Rank
- Rank Average
- Rand
- Rand Between
LOGICAL FUNCTIONS
- If
- Nested if
- SumIf
- Sumifs
- Averageif
- Averageifs
- Countif
- Countifs
- Or
- Not
- And
- If error
- If Function & Nested If Statements And & Or Functions
- Maxifs
- Minifs
TEXT FUNCTIONS
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Mid
- Concatenate
- Proper
- Trim
- Substitute
- Search
- Find
DATE & TIME FUNCTIONS
- Days360
- Date
- Network days
- Now
- Today
- Weekday
- Effect
- Eomonth
- Edate
- Workdays
- Datedif
LOOKUP & REFERENCES FUNCTIONS
- Index
- Match
- Lookup
- Choose
- Offset
- Offset with Match
- Xlookup
- Transpose
- Hlookup For Single Worksheet
- Vlookup For Single Worksheet
- Hlookup & Vlookup For Multiple Sheet
- Match and Find Record by Vlookup And Hlookup
- Approximate Match with Vlookup
- Exact Match with Vlookup
- Nesting Lookup Function
- Show Formula
- Choose Function with Vlookup
- Indirect
LOOKUP & REFERENCES FUNCTIONS
- Pmt
- Rate
- Ppmt
- Ipmt
- Fv
- Pv
- Coupdays
- Coupnum
- Ispmt
- Sln
- Cumprinc
- Cumipmt
- Ddb
- Db
- Received
DATABASE FUNCTION’S
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
WORKING WITH CHARTS >
- Creating a Chart with the 2D or 3D
- Create Column Chart, Pie Chart
- Create Pateros Charts
- Create Speed- O-Meter Chart
- Moving a Chart One to another Sheet
- Resizing a Chart, Changing a Chart Type
- Editing Chart Text, Modifying Chart Options
- Formatting Category & Value Axis Data
- Formatting a Data Series
- Changing a Chart’s Source Data
FORMAT CELLS
- Cell Format.
- Data Bars, Color Scales & Icon Sets.
- Sorting basic.
- Sorting based on Customized List.
- Customized Sorting (Advanced).
CONDITIONAL FORMATTING WITH RULES & COLOR SCALES
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
- Conditional formatting with formulas
- Conditional formatting with Form Controls.
DATA MANAGEMENT WITH DATA VALIDATION
- Data Validation and dealing with Invalid Data.
- Group and Outline Data
- Data Consolidation.
- Data text to column.
- Custom Views
DATA ANALYSIS
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
SUMMRAZING DATA BY SUBTOTAL WITH GROUPING
- Adding Subtotals to a List
- Nesting Subtotals
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Text to Column
SORTING & FILTERING
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
- Applying Advance Filters
PREVENTING EXCEL WORKBOOK & SHEETS
- Locking/Unlocking Cells in a worksheet
- Protecting a Worksheet
- Protecting a Workbook
- Creating a Shared Workbook
- Tracking Changes to a Workbook
- Accepting & Rejecting Changes to a Workbook
- Password Protecting a Workbook
- Merging Workbooks
WHAT IF – DATA ANALYSIS
- Using Goal Seek
- Using Data Table
- Creating & Displaying Scenarios
Working with List
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
WORKGROUP COLLABORATION
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
CUSTOMIZING MACRO
- Creating a Macro with Condition
- Running a Macro, Editing a Macro
- Adding a menu to the Menu Bar
- Adding a Commands to a Menu
- Adding Buttons to a Toolbar
WORKING WITH PIVOT TABLES
- Page Break
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
REPORTING PAYROLL STATEMENTS
- MIS Report
- Profit & Loss a/c statement
- Balance sheet
- Worker contribution statement
- Cash flow statement
- Debtor’s & Creditors statement
- Inventory statement
- BRS Statement
- Fixed Assets & fund statement
- Payroll Report
- P.F & E.S.I Report
ADVANCE PASTE & SPECIAL TECHNIQUES
- Paste Formula’s, Paste Formats
- Paste Validations
- Transpose Tables
- Paste data
SPECIAL ORIENTATION
- Find record by drop down list according To condition
- Dash Board
- Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
- Speed o Meter
PRINT SETTINGS
- Page Break
- Print Area
- Print Titles
- Background
Module 2
ADVANCED ACCOUNTING
- Accounting terminology
- Activities and user of Accounting Information
- Assumption of Accounting
- Principal of Accounting
- Accounting cycle and source/Accounting document
- Accounting equation Classification of Account
- Types of Expenditure
- Compound Entry
- Subsidiary book and types of book
- Trial balance & Objectives
- Rectification of Error
- Provision & Reserve
- Inventory & cost for Inventory Valuation
- Suspense Account
- Share capital of company
- Kind of Share, forfeiture of share
- Over Subscription & Pro-rata allotment
- Accounting voucher
- Journal, cash book, ledger and trial balance
- Bills of exchange
- Depreciation
- Bank Reconciliation Statement
- Financial Statements
- Ratio Analysis
- Cash Flow Statement
- MIS Report
- Budget & Types of Budget
- Accounting Standard
Module 3
E-accounting & taxation training in west delhi
TAXATION
- Residential Status & Slab rate of Taxes
- Certain Incomes Exempt from Tax
- Income under Head Salary
- Income under the Head House Property
- Profit & Gains from Business & Profession
- Income under the Head Capital Gains
- Income under the head Other Sources
- Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
- Agricultural Income, Illustration on Computation of Total Income & Liability
- Assessment of Firms, Return of Income & Assessment of individual
- TDS/TCS-Types of Forms, return filing
- Tax Deduction of Source, Advance Tax,
- Interest, Refund, Penalty,
- Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
- Legal Documentation
- GST (GOODS AND SERVICE TAX)
- Legal Documentation For GST
Module 4
E-accounting & taxation training
BUSY
GENERAL FEATURES
- Completely Codeless
- Multi-Company Accounting
- Context-Sensitive On-Line Help
- Flexible Voucher Numbering
- Multiple Voucher Series for each Voucher Type
- Voucher entry while viewing reports and Vice-versa
- User-definable Optional Fields in Masters and Vouchers
- Unlimited level of Grouping of Accounts, Items, Material Centers and Cost Centers
- Option for adding Images & Notes in Account & Item Masters
- Draft Mode Printing for every Report and Document
- Voucher Cancellation
- Powerful Query System
- SQL Query Executor
- Print Preview
- Landscape Mode Printing
- Bird’s Eye View of Account
- ENTERPRISE FEATURES
- Voucher / Master Approval
- Message centre
FINANCIAL ACCOUNTING
- All books of Accounts & Final Results
- Balance Sheet with various Schedules
- Columnar Account Registers (Configurable)
- Daily / Monthly Summaries of Accounts, Account Groups and Cost Centers
- Bill-wise Outstanding with Ageing Analysis
- Payment Reminder Letters (Configurable)
- Statement of Account (Configurable)
- Handling of Post-dated Cheques
- Broker-wise Reporting
- Royalty Calculation
- Interest Calculation (Multiple Slabs based on Amt. & Days)
- Bank Interest Calculation
- Bank Re-conciliation
- Depreciation Chart (As per Companies Act / IT Act)
- Multi-Currency Accounting
- Cost Centre-wise Reporting
MULTI – LOCATION INVENTORY
- All books of Inventory
- Stock Status (Multi-location)
- Sales / Purchase Challans
- Columnar Inventory Registers (Configurable)
- Stock Valuation on Multiple Methods
- Separate Stock Valuation Method for each Item
- Item Serial No. Tracking
- Stock Ageing Analysis
- Allocation of Expenses to Items
- Daily / Monthly Summaries of Items and Item Groups
- Automatic Round-off in Vouchers
- Primary and Alternate Unit for each Item
- Batch-wise Inventory with Expiry Date
- Provision for Free Qty in Inventory Vouchers
- Provision for entering Sales / Purchase Return in Sales / Purchase Vouchers
- Production / Un-assemble
- BOM / Production Planning
- Critical Level Reporting
- Multiple Price-list for Items
- Multiple Price Structures (Party / Qty / Category-wise)
- Provision to update Item Prices on various Criterion
SALES / PURCHASE ORDER PROCESSING
- Pending Sales Orders (Party / Item-wise)
- Pending Purchase Orders (Party / Item-wise)
- Order Cancellation
- Invoice / Challan Generation from Orders
- USER-CONFIGURABLE INVOICING
FULLY – USER CONFIGURABLE
- Use Plain / Pre-printed Stationery
- Option for Fonts, Colors& Logos
- Option to Print Outer Box, Horizontal & Vertical Lines
- Multiple-taxes in Single Invoice
- Tax Inclusive / MRP Billing
- Point-of-Sale (POS) Billing
- Mfg. Excise Invoicing
- Trading Excise Invoicing
USER CONFIGURABLE DOCUMENT
- Use Plain / Pre-printed
- Accounting Vouchers
- Purchase Invoice
- Sales Return / Purchase Return Invoice
- Receipt / Payment Advice
- Debit / Credit Note
- Sales / Purchase Order
- Delivery Note / Goods Receipt Note
- Stock Transfer Memo
SALES TAX REPORT
- Sales Tax Forms Receivables / Issuable
- Sales Tax Forms Reminder Letters
- Forms Received / Issued Register
- Sales Tax / Purchase Tax Summary
- Sales Tax Surcharge
- Sales Tax Registers
GST REPORT
- GST Computation / Summary
- GST Invoicing (Tax / Retail)
- GST Returns (State-wise)
- GST Registers (State-wise)
- Columnar GST Registers (Configurable)
- Party-wise / Item-wise GST Summary
- Party-wise / Item-wise GST Summary
- Sales Re-conciliation as per Accounts and GST
- GST R1
- GST R2
- GST 3B
SERVICE TAX
- Input Service Tax Register
- Output Service Tax Register
- Service Tax Summary
- ST-3 (Service Tax Return)
TDS REPORT
- TDS Calculation
- TDS Warning Alarms
- TDS Challans
- TDS Certificate (Form 16-A)
- TDS Return (Form 26-Q)
- Annexures to Form 26-Q
- e-TDS with TDS 27-A
- TDS Audit Report
- TDS Deduction Details Report
FRINGE BENEFIT TEST
- Mark Expenses as FBT
- Expense-wise Taxable Value
- Option to charge FBT on Account Groups
- Fringe Benefit Tax Report
MIS REPPORT
- Cash Flow / Funds Flow
- Budgets / Targets / Credit Limits
- Ratio Analysis
- Sales / Purchase Analysis on various combinations
- Issue / Receipt Analysis
- Consumption Analysis
- Data Check List
- Profitability Reports (Item / Bill / Party / Batch / MC wise)
- Multi-Company Final Results / Reports
MIS REPPORT
- Cash Flow / Funds Flow
- Budgets / Targets / Credit Limits
- Ratio Analysis
- Sales / Purchase Analysis on various combinations
- Issue / Receipt Analysis
- Consumption Analysis
- Data Check List
- Profitability Reports (Item / Bill / Party / Batch / MC wise)
- Multi-Company Final Results / Reports
UTILITIES
- Data Freezing
- Pop-up Calculator
- Notes / Task Manager
- User-definable Access Rights
Module 5
E-accounting & taxation course online
TALLY
INTRODUCTION OF TALLY
- Company information
- Create a new company
- Current period, current date
- Company creation (accounts maintain, financial year, security control, tally vault)
- Accounts info
- Group ledger
- Ledger
BOOK KEEPING
- Entries with dr. And cr.
- Using cash account in journal
- Debit & Credit note
- Voucher types
- Select company
- Shut company
- Alter company
- Delete company
- Group company
- Change tally vault
FINANCIAL REPORT
- Balance sheet
- Profit & loss a/c
- Ratio analysis
FUND MANAGEMENT
- Trial balance
- Accounts book
- Statement of account
- Cash/fund flow
- Day book
- List of account
MODE OF INVOICE BILLING
- Bill wise detail with (new reference, against ref, advance, on account)
- Display (statement of a/c
- Bills payable, Receivables
- outstanding ledger, group)
INVENTORY MANAGEMENT
- Stock group
- Stock item
- Unit of measure
- Voucher entries –goods in, goods out
- Alternate unit and standard rate
- Opening balance, stock summary
PURCHASE & SALES ORDER PROCESSING
- Stock group
- Purchase and sale order
- Create purchase order
- Alter purchase order
- Delete purchase order
- Create sale order
- Alter sale order
- Delete sale order
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
- How can we do reject in reject our entry & use option
- Delivery note & Receipt note
- Give challan number in item
MULTI – GOD CREATION
- Godown/location
- Create godown
- Alter godown
- Removing companies
- Copy company
TAS DEDUCTED AT SOURCE (TDS)
- Tds
- Transaction of tds
- Ledger for tds
- Payment voucher
- Preparing tds challan
- Deposit of tds to govt
TAS COLLECTED AT SOURCE (TDS)
- Understanding TCS
- Creating TCS Masters & Practical Examples
- TCS Payment, Reports, & Forms
GOODS & SERVICES TAX
- GST
- Ledger for GST
- Transaction of GST
- Adjustment of GST
- Payment of GST
PAYROLL ACCOUNTING FUNCTION
- Payroll (payroll info)
- Employees and salary detail
- Maintain attendance register of employees
- Employees group
- Create attendance type
- Unit of leave (payroll)
MANUFACTURING VOUCHERS
- BOM (bill of material)
- Create Item of BOM
- How to create voucher after
- Ledger of BOM
- Transaction of BOM
- Alter of BOM
- After ledger for excise duty
VOUCHERS TYPES & CLASS
- Voucher Type
- Voucher Class-Sales
- Inclusive Tax Class
- Customer pay their payment
- How to create voucher with discount & freight charg
Module 6 - E-FILLING
E-accounting & taxation training institute in west delhi
GST FORMS
- GSTR-1
- GSTR-2
- GSTR-3
- GSTR-4
- GSTR-5
- GSTR-6
- GSTR-7
- GSTR-8
INCOME TAX RETURN FORMS
- ITR-1
- ITR-2
- ITR-3
- ITR-4
- ITR-5
