Tally.ERP 9 Help & Tutorial
Lesson 1: Basics of Accunting
1.1 Introduction
1.1.1 Types of Accounts
1.1.2 Golden Rules of Accounting
1.1.3 Accounting Principles, Concepts and Conventions
Lesson 2: Fundamentals of Tally.ERP 9
2.1 Introduction
2.1.1 Salient Features of Tally.ERP 9
2.1.2 Functional Features of Tally.ERP 9
2.1.3 Technology Advantages
2.1.4 Payroll
2.1.5 Data Migration Capability
2.1.6 Features pertaining to Duties and Taxes
2.2 Getting Functional with Tally.ERP 9
2.2.1 Tally.ERP 9 Start-up
2.2.2 Tally.ERP 9 Screen Components
2.2.3 Mouse/ Keyboard Conventions
2.2.4 Switching between Screen Areas
2.2.5 Quitting Tally.ERP 9
2.3 Creation/ Setting up of Company in Tally.ERP 9
2.3.1 Creation of a Company
2.3.2 Base Currency Information
2.3.3 Working with Multiple Companies
2.3.4 Exercise to Create another Company
Lesson 3: Creating Accounting Masters in Tally.ERP 9
3.1. F11:Features
3.2 . F12 : Configurations
3.2.1 General
3.2.2 Numeric Symbols
3.2.3 Accts / Inventory Info.
3.2.4 Voucher Entry
3.2.5 Invoice / Orders Entry
3.2.6 Printing
3.2.7 Data Configuration
3.2.8 TDL Configuration
3.2.9 Advanced Configuration
3.2.10 Licensing
3.3 Setting up Account Heads
3.3.1 Chart of Accounts
3.3.2 Pre-defined Groups of Accounts
3.3.3 Groups and Ledgers
3.3.4 Chart of Accounts of National Traders
Lesson 4: Creating Inventory Masters in Tally.ERP 9
INTRODUCTION
4.1 Stock Groups
4.1.1 Creating Stock Group
4.2 Stock Categories
4.2.1 Creating Stock Category
4.3 Godowns / Locations
4.3.1 Creating a Godown
4.4 Units of Measure
4.4.1 Creating Units of Measure
4.5 Stock Items
4.5.1 Creating a Stock Item
4.6 "Practical Excercise" of Inventory Masters for National Traders
4.6.1 Create Stock Groups
4.6.2 Displaying and Altering Stock Groups
4.6.3 Creating Single Stock Categories
4.6.4 Creating Multiple Stock Categories
4.6.5 Displaying and Altering Stock Categories
4.6.6 Creating Units of Measure
4.6.7 Creating Compound Units of Measure
4.6.8 Displaying and Altering Units of Measure
4.6.9 Creating Godowns
4.6.10 Displaying and Altering Stock Godowns
4.6.11 Create Stock Items
Lesson 5: Voucher Entry in Tally.ERP 9
5.1 Accounting Vouchers
5.1.1 Contra Voucher (F4)
5.1.2 Payment Voucher (F5)
5.1.3 Receipt Voucher (F6)
5.1.4 Journal Voucher (F7)
5.1.5 Sales Voucher (F8)
5.1.6 Credit Note Voucher (Ctrl + F8)
5.1.7 Purchase Voucher (F9)
5.1.8 Debit Note Voucher (Ctrl + F9)
5.1.9 Reversing Journal Voucher (F10)
5.1.10 Memo Voucher (Ctrl + F10)
5.1.11 Optional Voucher
5.1.12 Post-dated Vouchers
5.1.13 Creating a New Voucher Type
5.1.14 Displaying and Altering a Voucher Type
5.1.15 " PRACTICAL EXERCISE" Recording Accounting Transactions
5.1.16 Trial Balance for April 2009
5.1.17 Trial Balance for June 2009
5.2 Inventory Vouchers
5.2.1 Purchase Order
5.2.2 Sales Order
5.2.3 Rejections Out
5.2.4 Rejections In
5.2.5 Stock Journal
5.2.6 Delivery Note
5.2.7 Receipt Note
5.2.8 Physical Stock Voucher
5.2.9 Pure Inventory Transactions
5.2.10 Recording Inventory Transactions
PRACTICAL EXERCISE
5.2.11 Stock Summary for April 2009
5.2.12 Stock Summary for June 2009
5.2.13 Entering Inventory Details in Accounting Vouchers
5.3 Invoicing
5.3.1 Item Invoice and Account Invoice
5.3.2 Walk-through to create an Item Invoice
5.3.3 Walk-through to create an Account Invoice
Lesson 6: Advanced Accounting in Tally.ERP 9
6.1 Bill-wise Details
6.1.1 Activating Bill-wise Details
6.1.2 New Reference
6.1.3 Against Reference
6.1.4 Advance
6.1.5 On Account
6.1.7 Payment Performance of Debtors
6.2 Cost Centres and Cost Categories
6.2.1 Cost Centre
6.2.2 Cost Categories
6.2.3 Activating Cost Category and Cost Centre
6.2.4 Creating Cost Categories
6.2.5 Creating Cost Centre
6.2.6 Applying Cost Centres to Ledger Accounts
6.2.7 Display Cost Centre Reports
6.3 Voucher Class and Cost Centre Class
6.3.1 Voucher Class
6.3.2 Invoice Entry using Voucher Class
6.3.3 Payment Voucher using Voucher Class
6.3.4 Stock Journal using Voucher Class
6.3.5 Cost Centre Class
6.4 Multiple Currencies
6.4.1 Creating Foreign Currencies
6.4.2 Altering Currencies
6.4.3 Deleting Currencies
6.4.4 Creating Bank Ledger
6.4.5 Voucher Entry using Foreign Currency
6.4.6 Displaying Forex Gain/Loss
6.4.7 Adjusting Forex Gain/Loss
6.5 Bank Reconciliation
6.5.1 Reconciling Bank Accounts
6.6 Interest Calculations
6.6.1 Calculating Interest in Simple Mode
6.6.2 Booking Interest to Ledgers
6.6.3 Calculating Interest on Invoices
6.6.4 Calculating Interest in Advanced Mode
6.7 Budgets & Controls
6.7.1 Creating a Group Budget
6.7.2 Display Budgets and Variances for Group Budget
6.7.3 Altering a Budget
6.7.4 Deleting a Budget
6.7.5 Creating a Ledger Budget
6.7.6 Display Budgets and Variances for Ledger Budget
6.8 Scenario Management
6.8.1 Creating a Scenario
6.8.2 Alterating a Scenario
6.8.3 Deleting a Scenario
Lesson 7: Advanced Inventory in Tally.ERP 9
7.1 Order Processing
7.1.1 Purchase Order Processing
7.1.2 Altering a Purchase Order
7.1.3 Sales Order Processing
7.1.4 Altering a Sales Order
7.1.5 Display Order Position
7.1.6 Display Columnar Orders & Stock Details
7.1.7 Adjusting Orders
7.2 Reorder Levels
7.2.1 Defining Reorder Levels
7.2.2 Display Reorder Status
7.3 Tracking Numbers
7.3.1 Using Tracking Numbers
7.3.2 Display Purchase Bill Pending
7.4 Batch-wise Details
7.4.1 Activating Batch-wise Details
7.4.2 Using Batch-wise Details in Purchase Invoice
7.4.3 Using Batch-wise Details in Sales Invoice
7.5 Additional Cost Details
7.5.1 Activating Additional Cost Details
7.5.2 Creating Purchase Voucher with Additional Cost Details
7.5.3 Creating Purchase Invoice with Additional Cost Details
7.5.4 Appropriate Addtional Costs
7.5.5 Additional Costs incurred after Purchases
7.6 Bill of Materials (BoM)
7.6.1 Creating Bill of Materials
7.6.2 Creating a Manufacturing Journal
7.6.3 Using Bill of Materials
7.7 Price Levels and Price Lists
7.7.1 Activating Price Lists and Defining Price Levels
7.7.2 Using Price Lists
7.8 Stock Valuation
7.8.1 Stock Valuation Methods
7.8.2 Display Stock Summary
7.9 Zero Valued Entries
7.9.1 Creating Zero Valued Entries
7.10 Inventory Ageing Analysis
7.10.1 View Inventory Ageing Report
7.11 Different Actual and Billed Quantities
7.11.1 Using different Actual and Billed Quantities
Lesson 8: Value Added Tax (VAT)
8.1 Configuring VAT in Tally.ERP 9
8.1.1 Company Setup
8.1.2 Enabling Value Added Tax (VAT)
8.1.3 VAT Classifications
8.2 Creating Masters
8.2.1 Creating Purchase Ledger
8.2.2 Creating Sales Ledger
8.2.3 Creating Input VAT Ledger
8.2.4 Creating Party Ledger
8.2.5 Creating Stock Items
8.3 Entering Transactions
8.3.1 Creating Purchase Voucher without Inventory
8.3.2 Creating Purchase Invoice with default VAT Class
8.3.3 Creating Purchase Invoice with Selection of VAT Class during Entry
8.3.4 Creating Purchase Invoice with Multiple VAT Rates
8.3.5 Creating Sales Voucher without Inventory
8.3.6 Creating Sales Invoice with default VAT Class
8.3.7 Printing Sales Invoice
8.3.8 Creating Sales Invoice with Selection of VAT Class during Entry
8.3.9 Creating Sales Invoice with Multiple VAT Rates
8.3.10 Creating Sales Invoice using Voucher Class
8.4 VAT Reports
8.4.1 VAT Computation Report
8.4.2 VAT Returns
8.5 Accounting for Return of Goods
8.5.1 Sales Returns
8.5.2 Purchase Returns
8.5.3 Display VAT Computation Report
8.6 Rate Difference in Purchase / Sales
8.6.1 Rate Differences in Purchases
8.6.2 Rate Differences in Sales
8.6.3 Display VAT Computation Report
8.7 Accounting for Interstate Transactions
8.7.1 Inter-state Purchases
8.7.2 Inter-state Sales
8.7.3 Display VAT Computation Report
8.8 Exempt Transactions under VAT
8.8.1 Exempted Purchases
8.8.2 Exempted Sales
8.8.3 Display VAT Computation
8.9 Purchases from Unregistered Dealers
8.9.1 Display VAT Computation Report
8.10 Claiming ITC on Capital Goods
8.11 Inter-State Branch Transfers
8.11.1 Branch Transfer Outwards
8.11.2 Adjustment of ITC on Branch Transfers
8.11.3 Branch Transfer Inwards
8.11.4 Display VAT Computation Report
8.12 VAT Reports
8.12.1 VAT Returns
8.12.2 eVAT Returns
8.12.3 Other Related Reports
8.13 VAT for Composite Dealers
8.13.1 Enabling VAT for Composite Dealers
8.13.2 Composite VAT Classifications
8.13.3 Creating Masters
8.13.4 Creating Purchases
8.13.5 Creating Sales
8.13.6 Purchases from Unregistered Dealers
8.13.7 VAT Reports
8.13.8 Payment of Composite VAT
Practice Exercise
Lesson 9: Central Sales Tax (CST)
9.1 Basics of Central Sales Tax (CST)
9.2 Enabling CST in Tally.ERP 9
9.2.1 Company Setup
9.2.2 Creating Masters
9.3 Recording Interstate Transactions in Tally.ERP 9
9.3.1 Inter-State Purchases
9.3.2 Inter-State Sales against C Form
9.3.3 Transit Sales against E1 and E2 Forms
9.3.4 Branch Transfers/ Consignment Sales against F Form
9.3.5 Exports against H Form
9.3.6 Sales to SEZ Units against I Form
9.4 Payment of CST
9.5 CST Reports
9.5.1 Forms Receivable Report
9.5.2 Forms Issuable Report
Practice Exercise
Lesson 10: Point of Sale (PoS)
10.1 Features of Point of Sale (PoS) in Tally.ERP 9
10.2 Configuring Point of Sale in Tally.ERP 9
10.2.1 Company Setup
10.2.2 Creating POS Voucher Type
10.2.3 Creating Leders
10.3 Entering POS Transactions
10.3.1 Creating Purchase Invoice
10.3.2 Creating POS Invoice with Single Payment Mode
10.3.3 Creating POS Invoice with Multiple Payment Mode
10.3.4 Creating POS Invoice using Voucher Class
10.4 POS Reports
10.4.1 POS Register
Lesson 11: Job Costing
11.1 Configuring Job Costing In Tally.ERP 9
11.1.1 Company Setup
11.1.2 Enabling Job Costing in Tally.ERP 9
11.2 Creating Masters for Job Costing
11.2.1 Creating Jobs as Job Cost Centres
11.2.2 Creating Ledgers
11.2.3 Creating Godowns dedicated to jobs
11.2.4 Creating Units of Measure
11.2.5 Creating Stock Item
11.2.6 Creating Voucher Type with Voucher Class
11.3 Recording Transactions
11.3.1 Creating Receipt Note
11.3.2 Creating Purchase Invoice
11.3.3 Creating Transfer Journal
11.3.4 Creating Consumption Journal
11.3.5 Creating Payment Voucher
11.3.6 Creating Sales Invoice
11.3.7 Creating Stock Journal for Returns of Materials
Practice Exercise
11.4 Job Costing Reports
11.4.1 Job Work Analysis Report
11.4.2 Material Consumption Summary
11.4.3 Godown Summary
11.4.4 Comparative Job Work Analysis
Lesson 12: Multilingual Capabilities
12.1 Configuring Tally.ERP 9 for Multilingual Capabilities
12.1.1 Creating a Company
12.1.2 Defining User Interface Language
12.1.3 Enabling Multilingual Support
12.2 Creating Masters
12.2.1 Using Phonetic Keyboard Layouts
12.2.2 Creating Stock Item
12.2.3 Creating Ledgers
12.3 Entering Transactions in Multiple Languages
12.3.1 Creating Purchase Invoice
12.3.2 Creating Sales Invoice
12.3.3 Printing Sales Invoice
12.4 Transliteration
12.5 Generating Reports
12.5.1 Display Stock Summary
12.5.2 Display Profit & Loss Account
12.5.3 Printing Confirmation Letters in Multiple Languages
Lesson 13: Technological Advantages of Tally.ERP9
13.1 TallyVault
13.1.1 Using TallyVault Feature
13.2 Security Control
13.2.1 Activate Security Control
13.2.2 Create Security Levels
13.2.3 Users and Passwords
13.2.4 Alter/ Display a User / Type of Security
13.2.5 Loading a Company with a User name
13.3 Tally Audit
13.3.1 Using Tally Audit Feature
13.4 Backup and Restore
13.4.1 Backup
13.4.2 Restore
13.5 Split Company Data
13.6 Export and Import of Data
13.6.1 Export of Data
13.6.2 Exporting Masters
13.6.3 Exporting Data for Re-import into another Company
13.6.4 Import of Data
13.6.5 Export to Excel
13.7 ODBC Connectivity
13.8 Web Enabled, Print Preview and Online Help
13.8.1 Web Enabled
13.8.2 Internet Publishing
13.8.3 Upload
13.8.4 Print Preview
13.8.5 Local / Online Help
13.9 Printing of Reports and Cheques
13.9.1 Display and Print
13.9.2 Print Format
13.9.3 Multi-Account Printing
13.9.4 Draft Mode Printing (Quick Format)
13.9.5 Cheque Printing
13.9.6 Printing Cheques
Lesson 14: Tally.NET and Remote Capabilities
14.1 Overview of Tally.NET
14.2 Configure Tally.NET Features
14.3 Connect Company on Tally.NET
14.4 Create Remote Users
14.5 Authorise Remote Users
14.6 Remote Access
14.6.1 Login as Remote User
Lesson 15: Application Management and Controls
15.1 Concept of Control Centre
15.1.1 Features of Control Centre
15.1.2 Advantages of Control Centre Tally.ERP 9
15.2 Installing & Activating Tally.ERP 9
15.2.1 Installing Tally.ERP 9
15.2.2 Activating Tally.ERP 9 License
15.3 Logging to Control Centre
15.4 Managing Accounts using Control Centre
15.4.1 My Tally.NET Accounts
Lesson 16: Online Help and Support
16.1 Features of Support Centre
16.2 Accessing the Support Centre
16.2.1 Local Access
16.2.2 Remote Access
16.3 Using Support Centre
16.3.1 Adding a New Issue/ Query
16.3.2 Reply to an Issue/Query
16.3.3 Close an Issue/ Query
16.3.4 Other Functions
Lesson 17: Service Tax
17.1 Basics of Service Tax
17.2 Configuring Tally.ERP 9 for Service Tax
17.2.1 Salient Features of Service Tax compliant Tally.ERP 9
17.2.2 Company Setup
17.2.3 Enabling Service Tax
17.2.4 Service Tax Statutory Masters
17.3 Creating Masters
Practice Exercise
17.4 Entering Transactions
17.4.1 Creating Purchase Invoice
17.4.2 Creating Sales Invoice
17.5 Accounting for Advance Receipts
17.6 Accounting for Opening Service Tax Credit
17.7 Payment of Service Tax
17.8 Service Tax Reports
17.8.1 Service Tax Payables
17.8.2 Input Credit Form
17.8.3 ST 3 Report
Practice Exercise
Lesson 18: Tax Deducted at Source [TDS]
18.1 Basic concepts of TDS
18.2 Configuring TDS in Tally.ERP 9
18.2.1 Enabling TDS in Tally.ERP 9
18.2.2 TDS Statutory Masters
18.3 Creation of Masters
18.3.1 Expenses Ledger Accounts
18.3.2 TDS Ledger Accounts
18.3.3 Party Ledger Accounts
18.3.4 Bank Accounts
18.4 Processing Transactions
18.4.1 Booking Expenses and Deducting TDS
18.4.2 Booking Expenses and Deducting TDS Later
18.4.3 TDS Deduction @ Lower Rate
18.4.4 TDS Deduction @ Zero Rate
18.4.5 Deducting TDS on Payments
18.4.6 Payment of TDS
18.5 TDS Reports
18.5.1 Computation
18.5.2 Challan Reconciliation
18.5.3 Return
18.5.4 eTDS Returns
18.5.5 Outstandings
18.5.6 Exception Reports
Lesson 19: Tax Collected at Source [TCS]
19.1 Basic Concepts of TCS
19.1.1 TCS Nature of Goods
19.1.2 TCS on Contracts, License and Leases
19.1.3 Time and Mode of Payment of TCS to the Government Account
19.1.4 Credit for Tax Collected at Source
19.1.5 The Issue of a TCS Certificate
19.1.6 The Issue of a Consolidated Certificate
19.1.7 TCS Returns
19.1.8 Returns
19.2 Configuring Tally.ERP 9 for TCS
19.2.1 Company Setup
19.2.2 TCS Statutory Masters
19.3 Creating Masters
19.3.1 Creating Party Ledger
19.3.2 Creating TCS Ledgers
19.4 Entering Transactions
19.4.1 Creating Sales
19.4.2 Payment of TCS
19.4.3 Challan Reconciliation
19.5 TCS Reports
19.5.1 Form 27D
19.5.2 e-TCS Returns
19.5.3 Form 27B
20: Excise for Dealers
20.1 Basic concepts
20.1.1 Salient Features of Dealer Excise
20.3 Enabling Dealer Excise in Tally.ERP 9
20.3.1 Company Setup
20.3.2 Enabling VAT
20.4 Creating Masters
20.4.1 Voucher Type Setup
20.4.2 Creating Ledgers
20.4.3 Creating Stock Items
20.5 Entering Transactions
20.5.1 Creating Purchases
20.5.2 Excise Invoicing
20.5.3 Creating Sales Invoice
20.6 Excise Reports
20.6.1 Excise Stock Register
20.6.2 Excise Purchase Bill Register
20.7 Sales and Purchase Extract
20.7.1 Form RG 23D
20.7.2 Quarterly Return - Form II
20.7.3 Accounting for Returns of Goods
Practice Exercise
21: Excise for Manufacturers
21.1 Basic Concepts of Excise Duty
21.1.1 Scope and Applicability
21.1.2 Excise Valuation Methods
21.1.3 CENVAT Credit
21.1.4 Registration of Manufacturers
21.1.5 Requirements of Excise Invoice
21.1.6 Types of Duties and Method of Calculation
21.1.7 Time and Mode of Payment of Duty
21.1.8 Returns & Timelines
21.2 Configuring Excise in Tally.ERP 9
21.2.1 Enabling Excise in Tally.ERP 9
Step 1 : Create Company
Step 2 : Enable Excise
Step 3 : Enable Value Added Tax (VAT)
21.3 Creation of Masters
21.3.1 Creating Ledgers
21.3.2 Creating Excise Duty Ledgers
21.3.3 Creating CENVAT Ledgers
21.3.4 Creating VAT Ledgers
21.3.5 Creating Expenses Ledgers
21.3.6 Creating Excise Voucher Types
21.3.7 Creating Tariff Classification
21.3.8 Creating Stock Items
21.4 Processing Transactions
21.4.1 Purchase of Excisable Goods
21.4.2 Manufacturing Excisable Goods
21.4.3 Sale of Excisable Goods
21.4.4 Return of Goods
21.4.5 Availing CENVAT Credit
21.4.6 Payment of Excise Duty
21.5 Excise Reports
21.5.1 Excise Computation Report
21.5.2 Daily Stock Register
21.5.3 PLA Register
21.5.4 Form ER 1
21.5.5 CENVAT Registers