Accounting & Taxation Training Course

  Module-1 MS Office
Lecture-1 Fundamentals of Computer 
·      Introduction of Computer

·      Introduction to paint

·      Introduction of Notepad

·      Introduction of WordPad
Lecture 2-9 Microsoft Word 
·      Introduction to MS Office                   

·      Selecting & Editing Data                       

·      Modifying Pictures       

·      Getting Help from Office

·      Typing Text in Word

·      Formatting Text

·      Designing your Pages

·      Inserting TOC

·      Footnote & End Note

·      Linking Documents

·      Mail Merge
Lecture 10-17 Microsoft Excel 
·      The Basics of spread sheets

·      Playing with formulas

·      Charting and Analysing Data

Lecture 18-22 Microsoft PowerPoint 
·      Creating PowerPoint Presentation

·      Adding Color and Pictures

·      Showing off a presentation
Lecture 23-27 Microsoft Outlook & Internet 
·      Managing E-Mail with Outlook

·      Calendar, Contacts and Tasks

·      Internet Concepts

  Module-2 Advance Excel
Lecture 1: Getting started with Excel 
·      Identifying the different Excel

·      Identifying new features of Excel

·      Working with the ribbon

·      Customizing the Excel program window

·      Zooming in on a worksheet

·      Arranging multiple workbook windows

·      Adding buttons to the Quick Access Toolbar

·      Customizing the ribbon

·      Maximizing usable space in the program window

·      Modifying workbooks

·      Modifying worksheets

·      Inserting rows, columns, and cells

·      Merging and unmerging cells           
Lecture 2: Working with data and Excel tables 
·      Entering and revising data

·      Managing data by using Flash Fill

·      Moving data within a workbook

·      Finding and replacing data

·      Correcting and expanding upon worksheet data

·      Defining Excel tables
Lecture 3: Performing calculations on data 
·      Naming groups of data

·      Creating formulas to calculate values

·      Summarizing data that meets specific conditions

·      Working with iterative calculation options and automatic workbook

·      calculation

·      Using array formulas

·      Finding and correcting errors in calculations       
Lecture 4: Changing workbook appearance 
·      Formatting cells

·      Defining styles

·      Applying workbook themes and Excel table styles

·      Making numbers easier to read

·      Changing the appearance of data based on its value

·      Adding images to worksheets    
Lecture 5: Focusing on specific data by using filters 
·      Limiting data that appears on your screen

·      Filtering Excel table data by using slicers

·      Manipulating worksheet data

·      Selecting list rows at random

·      Summarizing worksheets by using hidden and filtered rows

·      Finding unique values within a data set

·      Defining valid sets of values for ranges of cells    
Lecture 6: Reordering and summarizing data 
·      Sorting worksheet data

·      Sorting data by using custom lists

·      Organizing data into levels

·      Looking up information in a worksheet
Lecture 7: Combining data from multiple sources 
·      Using workbooks as templates for other workbooks

·      Linking to data in other worksheets and workbooks

·      Consolidating multiple sets of data into a single workbook   
Lecture 8: Analyzing data and alternative data set 
·      Examining data by using the Quick Analysis Lens

·      Defining an alternative data set

·      Defining multiple alternative data sets

·      Analyzing data by using data tables

·      Varying your data to get a specific result by using Goal Seek

·      Finding optimal solutions by using Solver

·      Analyzing data by using descriptive statistics       

Lecture 9: Creating charts and graphics 
·      Creating charts

·      Customizing the appearance of charts

·      Finding trends in your data

·      Creating dual-axis charts

·      Summarizing your data by using sparklines

·      Creating diagrams by using SmartArt

·      Creating shapes and mathematical equations       
Lecture 10: Using PivotTables and Pivot Charts 
·      Analyzing data dynamically by using PivotTables

·      Filtering, showing, and hiding PivotTable data

·      Editing PivotTables

·      Formatting PivotTables

·      Creating PivotTables from external data

·      Creating dynamic charts by using Pivot Charts

Lecture 11: Printing worksheets and charts 
·      Adding headers and footers to printed pages

·      Preparing worksheets for printing

·      Previewing worksheets before printing

·      Changing page breaks in a worksheet

·      Changing the page printing order for worksheets

·      Printing worksheets

·      Printing parts of worksheets

·      Printing charts

Lecture 12: Working with other Office programs 
·      Linking to Office documents from workbooks

·      Embedding workbooks into other Office documents

·      Creating hyperlinks

·      Pasting charts into other Office documents          

Lecture 13: Collaborating with colleagues 
·      Sharing workbooks

·      Saving workbooks for electronic distribution

·      Managing comments

·      Tracking and managing colleagues’ changes

·      Protecting workbooks and worksheets

·      Authenticating workbooks

·      Saving workbooks as web content

·      Importing and exporting XML data

·      Working with SkyDrive and Excel Web App

  Module - 3 Manual accounting
Lecture - 1 Understanding an Accounting Manual 
·         Components of an Accounting Manual

·         Example of an Accounting Manual

·         What Is Accounting?

·         How Accounting Works

·         Types of Accounting

·         Requirements for Accounting

  Module - 4 TallyPrime
Lecture 1: Accounting Introduction 
·      What is Commerce?

·      Why Accounting is needed?

·      Basic concept of accounting

·      Types of accounts

·      Golden Rules of Accounts

Lecture 2: Introduction to Tally Prime & Company Creation 
·      Introduction to Tally Prime

·      Top 10 Tally Prime Features

·      What’s New in Tally Prime

·      Comparison between Tally ERP 9 and Tally Prime

·      Gateway of Tally

·      Company Creation in Tally Prime

·      Alter/Delete Company Details

·      Introduction to Company Menu

·      Company Features

·      Tally Company Configuration
Lecture 3: Chart of Accounts, Groups & Ledgers in Tally Prime 
·      Create Account Groups Single/Multiple

·      Creating a Single/Multiple Ledger

·      Maintain Balances Bill-by-Bill & Default Credit Period

·      Ledgers with Opening Balances

·      Balance Sheet

Lecture 4: Journal Entries 
·      Examples of Journal Entries

Lecture 5: Introduction to Vouchers 
·      Contra

·      Payment

·      Receipt

·      Journal

·      Sales

·      Purchase

·      Debit note

·      Credit note

Lecture 6: Vouchers Exercise 
·      Accounting Problems for Practice
Lecture 7: Cost Center & Cost Category 
·      Cost Centers Allocation

·      Cost categories for parallel allocation

·      Cost center class

·      Report related to cost center/category

Lecture 8: Budget & Scenario 
·      Create/Alter a Budget

·      View Budget Variance

·      Delete a Budget

·      Create/Alter a Scenario

·      Use Optional Vouchers in Scenarios

·      Use Scenarios in Reports
Lecture 9: Interest Calculation 
·      Calculate Interest Using Simple Parameters

·      Calculate Interest Transaction-by-Transaction

·      Calculate Interest Using Advanced Parameters

·      Calculate Interest on Group

·      Calculate Interest on Ledger Balances

·      View Interest Amount on Invoices

·      Record Transaction for Interest Calculation

Lecture 10: Accounting Reports 
·      Balance Sheet

·      Profit & Loss

·      Cash Flow

·      Funds Flow

·      Receivables

·      Payables

·      Trial Balance

·      Day Book

·      Cash Book

·      Bank Book
Lecture 11: Inventory Creation in TallyPrime 
·      Creating a Single Stock Group

·      Modifying / Deleting a Single Stock Group

·      Creating a Multiple Stock Group

·      Creating Single/multiple Stock category

·      Creation of Units of Measure

·      Simple Units of Measure

·      Compound Units of Measure

·      Alternation / Deletion of Stock Units

·      Creation of Single Stock Items

·      Inventory storage using godown

Lecture 12: Bill of Materials 
·      Setup Bill of Materials (BOM)

·      Creating a Manufacturing Journal
	
Lecture 13: Batches and Expiry date 
·      Set Up Batches for Stock Items

·      Sell Stock Items from Batches

·      Batches for Purchased Stock Items

·      Batch Summary

·      Batch Vouchers

Lecture 14: Inventory Vouchers and Order Processing 
·      Purchase Order Processing in Tally.ERP9

·      Receipt Note Voucher (GRN) against Purchase Order

·      Rejection Out Voucher against Purchase Order

·      Purchase Voucher against Receipt Note Voucher (GRN)

·      Sales Order Processing

·      Delivery Note Against Sales Order

·      Rejection In Against Sales order

·      Sale Invoice Against Delivery Note

Lecture 15: Job order processing- Material in/Material out 
·      Job Work

·      Job Work Masters

·      Principal Manufacturer (Job Work Out)

·      Job Work In

·      Material In/ Material Out Voucher

Lecture 16: Advance features in Tally 
·      Track Additional Cost of Purchase

·      Zero valued Transactions

·      Use Different Actual & Billed Quantity

·      Transaction using Stock journal with purchase/sales:

·      Separate Discount Column in Invoices
Lecture 17: Price Levels and Price List in TallyPrime 
·      Price Levels

·      Create Price Levels

·      Assign Price Levels to Ledger Accounts

·      Price List

·      Use Price Levels & Price List during Voucher Entry

Lecture 18: Pre closure of Orders 
·      Complete cancellation of order

·      Partial cancellation of order

·      Record Quotation

Lecture 19: POS-Point of Sale 
·      Record a POS Invoice

·      POS Invoice with Multiple Modes of Payment

·      Faster Data Entry for POS Invoice

·      POS Register
Lecture 20: Inventory Reports 
·      Track Your Inventory | Stock Summary

·      Location/Godown Summary

·      Movement Analysis

·      Stock Ageing Analysis

·      Stock Query

·      Physical Stock Register

·      Stock Cost Estimation

Lecture 21: Other Utilities 
·      Group Company

·      Multi Currency

·      Multiple Addresses for Ledger

·      Specify Credit limit

·      Use Security Control

·      Creating Users and Passwords

·      TallyVault Password

·      Backup/ Restore Company data

·      Splitting Company Data

·      Import/Export data
Lecture 22: TallyPrime with Banking 
·      Cheque printing

·      Cheque Register

·      Banking Transaction Types

·      Post Dated Cheque

·      Deposit Slip

·      Payment Advice

·      Bank Reconciliation

Lecture 23: Payroll Processing 
·      Introduction to Payroll

·      Payroll in TallyPrime

·      Enable Payroll in TallyPrime

·      Payroll Transactions

·      Generate Pay Slips

  Module - 5 TallyPrime with GST
Lecture 24: GST in TallyPrime 
·      GST Introduction

·      SGST, CGST and IGST Terms

·      GST – What is HSN and SAC

·      GST Classifications

·      Enable & Recording GST Transactions

·      Recording GST Transactions - Multi Tax Rates

·      GST Payment

·      Recording GST on Item Rate

·      Recording GST Services

·      Recording GST Expenses

·      Recording GST Assets

·      GST on Reverse Charge Mechanism (RCM)

·      GST Advance Receipts
Lecture 25: Introduction to GST Returns 
·      GSTR-1 Filing

·      GSTR-3B Filing

Lecture 26: GST Report 
·      GSTR-1

·      GSTR-2

·      GSTR-3B

·      GST Annual Computation Report

Lecture 27: E-Way Bill 
·      Setup e-Way Bill

·      Generate JSON of E-Way Bill

·      Record invoice with details required for e-Way Bill, and create JSON

·      Step to generate e-Way Bill on the e-Way Bill Portal

·      Print the invoice with e-Way Bill number
	
Lecture 28: TDS- Tax Deducted at Source 
·      Enable TDS

·      TDS Nature of Payment

·      TDS Ledger- Expenses Ledger, Party Ledger

·      Record TDS Transactions

·      Generate TDS Reports

Lecture 29: TCS- Tax Collected at Source 
·      Set Up Your Books For Tax Collected at Source

·      Record TCS Transactions

·      Generate TCS Reports

  Module - 6 QuickBooks
Lecture 1: Creating a company file 
·      Create New Company In QuickBooks

·      Opening an Existing Company

·      Modify Company Info

·      Practical Exercise

Lecture 2: Getting around in QuickBooks 
·      QuickBooks Menu

·      Icon bar

·      Home page

·      Practical Exercise

Lecture 3: Setting up chart of accounts 
·      Planning the Chart of Accounts

·      Creating Accounts and Subaccount

·      Practical Exercise
Lecture 4: Creating customers, jobs & vendors 
·      Creating Customers  in QuickBooks

·      Creating Jobs, Creating Vendors

·      Working with customers, jobs & vendors

·      Managing Leads

·      Practical Exercise

Lecture 5: Setting up items 
·      Creating Items

·      Service Items

·      Product Items

·      Creating other types of Items

·      Practical Exercise

Lecture 6: Data entry shortcuts for lists 
·      Adding & editing multiple records

·      Importing information

·      Practical Exercise
Lecture 7: Setting up other lists 
·      Price Levels

·      Customer profile lists

·      Vendors profile lists

·      Fixed Item List

·      Practical Exercise

Lecture 8: Tracking Time and Mileage 
·      Setting up Time Tracking

·      Tracking Mileage

·      Generating Mileage Reports

·      Practical Exercise

Lecture 9: Billing 
·      Viewing payables with bill tracker

·      Entering Bills

·      Paying Bills- Deposit to a Vendor

·      Handling Reimbursable Expenses

·      Writing Checks & Other Payment Methods

·      Practical Exercise
Lecture 10: Invoicing 
·      Creating Invoice

·      Deposits, Down Payments and Retainers

·      Estimating Jobs, Creating Progress Invoices

·      Handling Customer Refunds and Credits

·      Practical Exercise

Lecture 11: Producing Statements 
·      Generating Statements

·      Practical Exercise

Lecture 12: Transaction Timesavers 
·      Memorizing Transactions

·      Finding Transactions

·      Practical Exercise
Lecture 13: Managing Accounts Receivables 
·      Receiving Payments, Cash Sales

·      Making Deposits

·      Practical Exercise

Lecture 14: Bank Accounts 
·      Entering Transactions in Account Register

·      Transferring Funds

·      Reconciling Accounts

·      Managing Loans

·      Practical Exercise

Lecture 15: Payroll 
·      Payroll in QuickBooks

·      Practical Exercise
Lecture 16: Journal Entries 
·      Balancing Debit & Credit amounts

·      Creating Journal Entries

·      Checking Journal Entries

·      Reclassification & corrections

·      Practical Exercise

Lecture 17: Year-End tasks 
·      Generating Financial Reports

·      Generating Tax Reports

·      Closing the books for the year

·      Practical Exercise
Lecture 18: Track of Financial Tasks 
·      Tracking To-Dos

·      Reminders

·      Practical Exercise

Lecture 19: Managing Files 
·      Backing up files

·      Restoring Backups

·      Practical Exercise

Lecture 20: Inventory 
·      Setting Up Inventory Items

·      Purchasing  Inventory

·      Selling Inventory

·      Practical Exercise
	
Lecture 21: Sales Tax 
·      Working with Sales Tax

·      Paying Sales Tax

·      Practical Exercise

Lecture 22: Budgeting 
·      Creating Budgets in QuickBooks

·      Filling in budget values

·      Running budget reports

·      Practical Exercise

Lecture 23: Tracking Finances 
·      Tracking Finances with Reports and Graphs

·      Practical Exercise

Lecture 24: Online Banking 
·      Online Banking with QuickBooks

·      Practical Exercise
Lecture 25: Preferences 
·      Configuring Preferences

·      Practical Exercise

Lecture 26: Integration & Customization 
·      Integrating QuickBooks with Other Programs

·      Customizing QuickBooks

·      Practical Exercise

Lecture 27: Security 
·      Data Security in QuickBooks

·      Practical Exercise

  Module - 7 Business Communication
Lecture 1-20 Introduction to Business English Communication 
·         Business Dress Code

·         Business Ethics

·         Business Etiquette

·         Business Negotiation Skills

·         Business Writing Skills

·         Business Emails Writings

·         Cracking Interviews

·         Effective Communication

·         Interpersonal Skills

·         Career Development Planning

  Module-8 Income Tax
Lecture 1-10 Basics of Income Tax 
·         Defining the ‘Previous year’

·         Assessment Year

·         Understanding your Salary

·         Income on which you pay Tax?

·         Deductions

·         Make Section 80C your best friend

·         TDS or Tax deducted at source?

·         Calculating Tax Payable

·         Standard Deduction

·         Illustration on salary TDS

  Module - 9 Practical Accounting & Taxation
	
E-Filling Practicals 
Now a days all Govt returns are filed through internet. E-filing of all GST, TDS, IT, PF, ESI returns are now mandatory and hence every accountant should learn to file these returns with in the specified time. Every Firms, Company, business need Accountants with this knowledge, we advise you to study this Course along with Tally ERP Expert Course.

GST
Overview of Goods & Services tax, Overview of GST – Introduction, Implementation of GST, Liability of the tax payers, GST network, GST council, Levy of and exemption from tax, Levy of GST – Introduction, Composition scheme, Remission of tax/duty, Registration, Registration-introduction, Registration procedure, Important points, Special persons, Cancellation/amendment, Meaning and scope of supply, Taxable supply, Supply of goods and supply of services, Course or furtherance of business, Special transactions, Time of supply, Time of supply-goods, Time of supply-services, Time of supply-other points, Valuation in GST, Valuation in GST, Valuation rule, Payment of GST, Payment of GST- Introduction, Time of GST payment, How to make payment of GST, Challan generation, TDS & TCS, Electronic commerce, Tax collection at source, Procedure for e-commerce operator, Job work, Input tax credit, Job Worker, Input service distributor, Legal formalities-Input service distributor, Distribution of credit, E-Way bill & rules, Returns in gst, Introduction, GSTR-1 GSTR-2, GSTR-3 Other taxable persons, Annual return, Overview of the IGST act, IGST act-other provisions, Place of supply of goods & service, Introduction, Registered and unregistered persons, GST common portal, Introduction, GST eco-system, GST suvidha provider(gsp), Uploading invoices

Practical E-filing
SGST, CGST & IGST, Input Tax Credits, Monthly Returns, GSTR 1,1A,2,2A,3, E-way bill and other Returns, Annual Returns. Due date of Returns, Penalties & Interest to be paid, Payment by Challans.

ESI
Monthly Return, Challan payment, Due date of filing, Employees & Companies Covered, Share of Employees and Companies.

PF
Monthly Return, Challan payment, Due date of filing, Employees & Companies Covered, Share of Employees and Companies.

TDS
24Q, 26Q, Revised Returns, Downloading Form 16, Form 16A, Justification Report, Challan payment, Due date of payment of TDS and filing returns, TDS on various payments, Percentage TDS on Monthly Salary.

Income tax-Salary Return of all Online Return Filing
Form ITR-1 and ITR-2, Challan payment, Due date of filing returns, Deductions available under Chapter VI A : 80C, 80CCA, 80G etc.

  Module - 10 Corporate Communication
Corporate Documents 
·      Official Correspondences

·      Online Correspondences

·      Mastering various deeds

·      Partnership deeds, Joint Venture Agreements

·      MOU

·      Gift deeds

  Module - 11 Internship