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