Best Tally Comprehensive Training Institute in Rajkot

VOLUME 1

LESSON 1

BASICS OF ACCOUNTING

Introduction

Accounting terms

Accounting Assumptions, concepts, and principles

• Assumptions

• Concepts

• Principles

Double Entry system of Accounting

Account

• Types of Account

• The Golden Rules of Accounting

Source documents for Accounting

The Accounting Equation

Financial Statements

• Profit and Loss Account

• Balance sheet

LESSON 2

GETTING STARTED WITH TALLY.ERP 9 & ELEMENTAL FEATURES

Introduction

Features of Tally.ERP 9

• Accounting

• Inventory

• Statutory & Taxation

• Tally.net

• Audit & compliances

Getting started with Tally.ERP 9

• Components of Gateway of Tally

• Mouse / Keyboard Conventions

• Switching between Screen Area

• Closing Tally.ERP 9

Creating a company in Tally.ERP 9

Select a company

Shut a company

Alter company details

Features

• Accounting features

• Inventory features

• Statutory & taxation features

• Tally.net features

• Add-on features

• Data Management & security features;

• Payroll Features

Configuration

• General

• Numeric symbols

• Accts/inventory info.

• Voucher entry

• Invoice/Order entry

• Printing

• Data Configuration

• TDI. Configuration

• Advanced configuration

• Licensing

LESSON 3

CREATING MASTERS IN TALLY.ERP 9

Creating chart of accounts

Ledgers and groups

• Ledger creation

• Group creation

Inventory Masters in Tally.ERP 9

Creating Inventory masters

• Creating a stock group

• Creating a stock category

• Creating a multiple stock categories

• Creating a godown

• Creating a simple unit of measures

• Creating a compound unit of measure

• Creating stock item

• Creating stock items with advanced configurations

Stock summary

Displaying and altering inventory

• Displaying and altering stock categories

• Displaying and altering units of measure

• Displaying and altering stock items

• Displaying and altering stock godowns

LESSON 4

VOUCHER ENTRY AND INVOICING

Accounting Voucher

• Contra voucher

• Payment voucher

• Receipt voucher

• Journal voucher

• Sales voucher

• Credit note voucher

• Purchase voucher

• Debit note voucher

• Reversing journal voucher

• Memo voucher

• Optional voucher

• Post-dated vouchers

Creating a new vouchers type

• Displaying and altering a new voucher type

• Trial balance for April 2016

Inventory vouchers

• Pure inventory transactions

• Entering inventory details in accounting vouchers

Invoicing

• Item invoice and account invoice

• Creating an item invoice

• Creating an Account invoice

LESSON 5

VOUCHER CLASS

Introduction

• Payment voucher class

• Sock journal using voucher class

LESSON 6

BILL-WISE DETAILS

Activating bill-wise details

• New reference

• Against reference

• Advance

• On account

Bill wise outstandings reports

Payment performance of debtors

LESSON 7

CREDIT LIMITS

• Activate credit limits

• Setting credit limits

• Exceeding credit limits

• Exceptiom to credit limits

LESSON 8

BASICS OF BANKING

• Cheque printing

• Single multi cheque printing

• Cheque management

• Deposit slip

• Payment advise

• Bank reconciliation

LESSON 9

INTEREST CALCULATION-SIMPLE INTEREST

Activating a simple interest calculations

• Calculation of simple interest in simple mode

Booking interest to ledgers

• Calculating interest using simple parameters

LESSON 10

COST CENTRES AND COST CATEGORIES

Getting started with cost centers and cost categories

• Creating cost centers

• Creating cost categories

Applying cost centers to ledgers accounts

Cost center reports

• Category summary

• cost center breakup

• ledger breakup

• group break up

LESSON 11

MULTI CURRENCY

• Getting started with multi-currency

• Enabling multi-currency

• Creating foreign currency

LESSON 12

REPORTS IN TALLY.ERP9

Introduction

• Basic features of displaying reports

Financial statements

• Balance sheet

• Profit and loss account

• Trial balance

• Ratio analysis

Books and registers

• Day book

• Purchase and sales registers

• Cash/bank books

Statement of account

• Outstanding

• statistics

VOLUME 2

LESSON 1

ORDER PROCESSING & PRE-CLOSURE OF ORDERS

Order processing.

• Purchase order processing

• Sales order processing

• Viewing order details

• Display columnar orders & stock details

Pre-closure of orders

LESSON 2

PRICE-LEVELS AND PRICE-LISTS

Price levels and price lists

• Activating price lists and defining price levels

• Using price lists

LESSON 3

POINT OF SALE

Feature of point of sale in tally ERP9

Configuring point of sale in tally ERP 9

Creating ledgers

• Accounting ledgers

• Inventory ledgers

Entering POS transactions

• Creating purchase invoice

• Creating POS invoice with single payment mode

• Creating POS invoice with multiple payment mode

• Creating POS invoice using voucher class

POS reports

• POS register

LESSON 4

ZERO-VALUED ENTRIES

• Creating zero valued entries

LESSON 5

DIFFERENT ACTUAL AND BILLED QUANTITIES

• Enabled different actual and billed quantities

• Using different actual and billed quantities

LESSON 6

BATCH WISE DETAILS

• Activating batch wise details

• Using batch wise details in purchase invoice

• Using batch wise details in sales invoice

LESSON 7

BILLS OF MATERIALS

• Creating bills of materials

• Creating a manufacturing journal

• Using bill of materials

LESSON 8

ITEM COST TRACKING

• Enabling item cost tracking

• Item costs analysis reports

LESSON 9

ADDITIONAL COST DETAILS

• Activating additional cost details

• Creating purchase voucher with additional cost details

• Creating purchase invoice with additional cost details

• Appropriate additional details

• Additional costs incurred after purchase

LESSON 10

BACKUP AND RESTORE COMPANY DATA IN TALLY ERP 9

• Backup and restore

• Backup

• Manual data backup

• Auto backup

• Restoring data form a backup file

LESSON 11

EXPORT AND IMPORT DATA IN TALLY ERP 9

• Export and import of data

• Exporting and importing data

• Benefits

LESSON 12

E-MAILING IN TALLY ERP 9

• E-mailing

• E-mailing a report

• Benefits

LESSON 13

WEB-PUBLISHING IN TALLY ERP 9

• Web-publishing

• Uploading report to a website

• Benefit

LESSON 14

PASSWORD POLICY IN TALLY ERP 9

Password policy

• Setting up password policy for a company

Applying a password policy

LESSON 15

TALLY.NET

• Configuring tally.net features

• Creating tally.net user

• Authorizing tally.net user

• Creating security controls for tally.net user

• Connect a company on tally.net

• Remote login

• Benefits

LESSON 16

MESSAGE CENTRE IN TALLY ERP 9

Message centre

• How to access message center

• Installing product update from message center

Other mails

• Benefits

LESSON 17

LOCAL HELP ONLINE HELP IN TALLY ERP 9

• Local and online help

• Accessing local and online help

• Benefits

LESSON 18

SUPPORT CENTER IN TALLY ERP 9

Features of support centre

• How to use support center

Adding a new issue/query on support center

Replying to an new issue

Closing an issue

• Shortcuts to change support center view

• Benefits

VOLUME 3

LESSON 1

GETTING STARTED WITH VALUE ADDED TAX (VAT)

Introduction to VAT

• General VAT terms

Configuring VAT in tally ERP 9

VAT classifications

Creating masters

• Creating accounting masters

• Creating inventory masters

• Creating voucher types

Quick set up for value added tax

• Configure VAT through quick setup

• Setup Company

• Master setup

• Voucher type setup

Recording transactions

• Purchase of taxable goods

• Sale of taxable goods

VAT Report

• VAT computation reports

• VAT registers

• VAT purchase registers

• VAT sales registers

LESSON 2

GETTING STARTED WITH SERVICE TAX

Basics of service tax

• Features of service tax

• Basic terminology

Configuring in tally ERP 9 for service tax

• Enabling service tax in tally ERP 9

• Service tax statutory matters

Creating masters

• Sundry creditor ledger

• Sundry debtor ledger

• Service tax ledger

• Sales ledger for services

• Purchase ledger for services

Quick setup

Recording transactions

• Purchase of services and payment to services

• Sale of services

Payment of service tax

Service tax reports

• Service tax computation

LESSON 3

GETTING STARTED WITH EXCISE FOR DEALERS

Basic concepts

• CENVAT credit

Getting started with dealer excise in tally ERP 9

• Salient features of dealer excise

Enabling dealer excise in tally ERP 9

Creating masters

Quick setup

Excise transactions

• Purchase from manufacturers

• Create an excise sales invoice

Excise reports

• Excise stock register

• Excise purchase bill register

• Excise CENVAT stock register

• Party wise duty extract

• Sales and purchase extract

LESSON 4

GETTING STARTED WITH EXCISE FOR MANUFACTURERS

Basics of excise specific to manufacturers

• Who is manufacturer?

• Types of excise duties

• Excise valuation methods

• Excise registration

• Central excise invoice system

• Types of duties and method of calculation

• Returns and time-lines

• Time and mode of payment of duty

Configuring excise in Tally.ERP 9

• Enabling excise in tally ERP 9

Creating masters

• Creating ledgers

• Creating excise duty ledgers

• Creating CENVAT ledgers

• Creating excise voucher types

• Creating tariff classification

• Create stock items-raw materials

• Create stock item-finished goods

Quick setup

Recording transactions

• Create an excise purchase

• Excise sales (Rule 11 invoice)

Excise reports

• Excise computation report

• Daily stock register

LESSON 5

GETTING STARTED WITH TAX DEDUCTED AT SOURCE (TDS)

Basic concepts of TDS

Configuring TDS in tally ERP 9

• Enabling TDS in tally ERP 9

• TDS statutory matters

Creating masters

• Expense ledger accounts

• TDS ledgers account

• Party ledger account

• Bank accounts

Quick setup

Recording transactions

• Booking expenses and deducting TDS

TDS reports

• Computation

VOLUME 4

LESSON 1

VALUE ADDED TAX

Recording transaction with VAT

• Purchase from URD’S

• Purchase of goods exempted from tax

• MRP purchase

• Sale of taxable goods

• Sale of goods exempted from tax

• Sale entries inclusive of VAT

• MRP sales

Return of goods

• Purchase returns

• Sales returns

Consignment / Branch transfer

• Consignment/branch transfer inward

• Consignment/branch transfer outward

Adjustments against tax payable

VAT reports

• VAT computation report

• VAT forms

• E-VAT annexures

• VAT commodity reports

• VAT registers

VAT payments

VAT for composite dealers

• Enabling VAT for composite dealers

• Composite VAT classifications

• Create required master

• Recording transactions

• VAT Composition report

• Payment for composite VAT

LESSON 2

CENTRAL SALES TAX (CST)

Introduction

Basics of central sales tax

• Rate of CST

• Forms for deductions under CST scheme

• Filling CST returns

Getting started with CST in tally ERP 9

• Creating a company

• Enabling a CST

• Creating required masters

Recording interstate transactions in tally.ERP 9

• Interstate purchase

• Interstate sale against C form

• Transit sales against E1 and E2 forms

• Branch transfers/consignment sales

• Exports against form H

• Sales to SEZ units against I forms

• Works contract

CST reports

• CST details in VAT computation reports

• Forms receivables reports

• Forms Issuable Reports

• CST purchase register

• CST sales register

• Reminder letters and covering letters

Payment of CST

LESSON 3

SERVICE TAX

Purchase of services and partial payment made to service provider

Accounting multiple services in a single voucher

Services partly subject to service tax

Accounting sale of services by professionals

Accounting for advance receipts

Sales of service exempt from service tax

• Accounting export of services

• Sale of pure agent services

Accounting import of services

• Availing input credit

• Reverse charge in service tax

• Service tax on GTA transactions

• Adjustments if service input credit towards tax liability

• Accounting for operating service tax credit

Payment of service tax

Service tax reports

Service tax computation

Service tax payables

Service tax payables

• Input credit summary

• ST 3 report

• ST 3 E-filling

• Exception reports

LESSON 4

EXCISE FOR DEALERS

Recording transactions

• Purchase from first stage dealer

• Purchase from consignment agent

• Sale of goods purchased from consignment agent

• Purchases from importer

• Sale of goods purchased from importer

Customs clearance

• Accounting for full clearance of imported goods

• Custom clearance pending

• Accounting partial clearance of imported goods

Accounting for return of goods

• Sales returns

• Purchase returns

Accounting for loss/wastage/theft of stock items

Excise reports

• Form RG 23 D

• Form-2

• E-returns

LESSON 5

EXCISE FOR MANUFACTURERS

Creating stock item masters

• Create stock item (ad quantum)

• Create finished goods

• Cresting excise opening balances

• Accounting excise duty opening balance in tally ERP

• Accounting PLA opening balances

Recording transactions

• Purchase order with excise details

• Creating excise purchases (without availing CENVAT credit)

• CENVAT credit on purchases from manufacturer (duty value alteration)

• Avail CENVAT credit on purchases (using a debit note)

• Partial availing of CENVAT credit

• CENVAT credit on capital goods

• Manufacture of multiple goods

• Excise sales (rule 11 invoice)

• Accounting for expenses

• Sales at special rate

• Removal as such

• Captive consumption

• Excise stock transfer

• Excise credit note

• Excise supplementary invoice

Export procedure

• Accounting direct export

• Sale to merchant exporters

• Sale to 100% EOQ’S

• Sale to SEZ’s

• Removal of goods to the buyer’s warehouse

Excise reports

• Excise computation reports

• Excise registers

• CENVAT registers

• Export registers

• Excise forms

CENVAT CREDIT ADJUSTMENT

G.A.R 7 Payment

LESSON 6

TAX DEDUCTED AT SOURCE (TDS)

Recording transactions

• Expenses partly subject to TDS

• Booking expenses and deducting TDS later

• Accounting multiple expenses and deducting TDS later

• Deducting TDS advance payments

• TDS on expenses at lower rate

• TDS on expenses at zero rate

• Deducting TDS on payments

• Reversal of expenses on TDS

• Reversal of excess TDS deducted

• Deducting TDS on expenses with inventory

• Payment of TDS

TDS REPORTS

• Computation

• Challan reconciliation

• Return

• E-TDS returns

• Print form 27A

• Out standings

• Exceptions reports

LESSON 7

TAX COLLECTED AT SOURCE

Introduction

• Basic concepts of TCS

Configuring Tally ERP 9 for TCS

• Enabling TCS in tally ERP 9

• TCS statutory matters

Creating masters

• Creating party ledger

• Creating TCS ledgers

Entering transactions

• Sales of TCS goods

• Sale of TCS goods at lower rates

• Sale of TCS goods at NIL rate

• TCS on transfer of right to use

• Sales returns

• Payment of TCS

Challan reconciliation

TCS REPORTS

• FORM 27D

• E-TCS Returns

• Form 27B

• MIS reports

VOLUME 5

LESSON 1

BANKING (WITH AUTO RECONCILIATION)

• Auto bank reconciliation

LESSON 2

INTREST CALCULATION – ADVANCED INTREST CALCULATION

• Using advanced parameters for interest calculation

• Calculating interest in advanced mode

LESSON 3

COST CLASS

• Cost center class

LESSON 4

MULTI CURRENCY

• Voucher entry using foreign currency

• Displaying forex gains/loss

• Adjusting forex gains/loss

LESSON 5

BUDGETS AND SCENARIOS

Budgets and controls

• Activating, creating and managing budgets

• Creating a budget

• Display budgets and variances for group budgets

Scenario management

• Getting started with scenarios

• Altering a scenario

• Deleting a scenario

LESSON 6

STOCK AGEING ANALSYS

• Stock ageing analysis

• View stock ageing report

LESSON 7

REORDER LEVEL

• Reorder levels

• Defining reorder levels

• Display reorder status

LESSON 8

JOB ORDER PROCESSING

Features of job order processing in tally ERP 9

Configuring job order processing in tally ERP 9

• Company setup

• Enabling job order processing

• Voucher type setup

Job order processing

• Job work out order

• Job work in order

Job order reports

• Job work out reports

• Job work in reports

LESSON 9

PAYROLL

Introduction

Enabling payroll in tally ERP 9

PROCESSING BASIC PAYROLL IN TALLY ERP 9

• Employee setup

• Creation of payroll units

• Attendance/production types

• Creation of pay heads

• Defining salary details for an employee

• Defining salary details for an employee group

• Payment of salary

Payroll reports

• Statements of payroll

• Attendance of reports

• Expat reports

Payroll statutory deductions and reports

• Creating statutory pay heads

• Define salary details

• Process salary

• Payment of salary

• Payroll statutory reports

Income tax

• Provide income tax details

• Process income tax

LESSON 10

TALLY VAULT

• How to use tally vault

• Benefit of tally vault

LESSON 11

TALLY AUDIT

• How to use tally audit

• Audit listing for voucher types

• Tally audit statistics for masters

• Audit listing for users

LESSON 12

SPLIT COMPANY DATA

• Important pre-split activity

• How to split the data

• Verify split data

LESSON 13

DATA SYNCHRONISATION

Data synchronization

• Data synchronization in tally ERP 9

• Communication between tally service/tally client

Steps for using data sync. Using TALLY.NET

• Exchange snapshot online

• Export snapshot online

• Import snapshot online

• Synchronization reports

Create sync rule on client – direct IP

LESSON 14

OBDC

• Outward connectivity

• How to setup OBDC

• Exceptional cases for 64 bit compatible scenarios

• Inward connectivity

• Benefits

LESSON 15

LIVE UPDATES

• Tally live updates dashboard

• Installation of product updates for single user

• Installation of product updates for multi user

LESSON 16

CONTROL CENTER

Login to control center

Control center for an account

Licensing & configuration

• Licensing and configuration for single site

• Licensing and configuration for multiple site

• Creating configuration set for a site

• TDL configuration management

Jobs and recruitment

Account profile management

• Change account admin

• Change password

• Change My Profile

• My sessions

User management

Manage data sessions

Deploying account TDLs

Unlink TDL configuration