Get..Tally.ERP9 Book + GST Assignment @ Rs. 550

Tally.ERP 9 Book
Tally.ERP 9 Book (Advanced Usage)
(GST Updated)


Getting Functional with Tally.ERP 9


1.1.            Tally.ERP 9 Start-Up

1.2.            Tally.ERP 9 Screen Components

1.3.            Mouse / Keyboard Conventions

1.4.            Quitting Tally.ERP 9  



Company Info


2.1.            Company Creation

2.2.            Opening (Loading ) of Tally.ERP 9

2.3.            Modification of Company

2.4.            Deletion of Company

2.5.            Shut (Close ) a Company

2.6.            Company Selection



Set-Up of Accounts


>>        Introduction

>>        Unit Objectives

>>        Assets, Liabilities, Income & Expenses

3.1.            The Group

      3.1.1.   Creating Group

                    Creating a Group with Advanced Usage

                    Creating Multiple Groups

3.1.2.   Altering or Modifying Group

3.1.3.   Permanently Deleting a Group

3.1.4.   Displaying a Group

3.2.            The Ledger

3.2.1.   Creating a Single Ledger

A-        Creating a Purchase / Sales Ledger

B-        Creating a Expenses / Income Ledger

C-        Creating a Party Ledger

D-        Creating Bank Account

E-        Creating Duties and Taxes Ledger

F-         Creating a Current Liabilities / Assets Ledger

3.2.2.   Creating a Multiple Ledger

3.2.3.   Displaying or Alter a Single Ledger Account.

3.2.4.   Deleting a Single Ledger Account

3.3.            Vouchers Types

3.3.1.   Accounting Vouchers      Contra Vouchers (F4)      Payment Voucher (F5)      Receipt Voucher (F6)      Journal Voucher ( F7)      Sales Vouchers (F8)

3.3.2.   Pre-defined Voucher Types in Tally.ERP 9      Alter a Pre-defined Voucher Type




Inventory / Items & Goods / Stock


>>        Meaning :

4.1.      Creating a Single Stock Group

4.1.1.   Modifying a Single Stock Group

4.1.2.   Displaying a Stock Group

4.1.3.   Deleting a Single Stock Group

4.2.      Creating a Multiple Stock Group

4.3.      Creation of Stock Units

4.4.      Alternation / Deletion of Stock Units

4.5.      Stock Items

4.5.1.   Creation of Single Stock Item

4.5.2.   Creation of Multiple Stock Item

4.5.3.   Modification and Deletion of Stock Item


___Questions & Exercises



Features of Tally.ERP 9 and Their Uses ( F11)

>>        Introduction

>>        Unit Objectives

5.1.      Accounting Features

5.2.      Inventory Features

5.3.      Statutory & Taxation Features




Accounting Vouchers in Tally.ERP 9


>>        Introduction

>>        Unit Objectives

>>        Types of Vouchers

6.1.      Contra Voucher (F4)

6.2.      Payment Vouchers (F5)

6.3.      Receipt Vouchers (F6)

6.4.      Journal Vouchers (F7)

6.5.      Sales Vouchers (F8)

6.6.      Credit Note Voucher (Ctrl + F8) – Sales Return

6.7.      Purchase Vouchers (F9)

6.8.      Debit Note Vouchers (Ctrl + F9)- Purchase Return

6.9.      Memo Voucher (Ctrl + F10)



GST ( Goods and Service Tax )  in Tally.ERP 9


7.1.   Introduction to GST ( IGST . CGST, SGST )

7.2.   Calculation of GST ( IGST, CGST & SGST) (Practical Assignment )

7.3.   GST on Tally.ERP 9 ( With Practical Assignment )

         Step-1  :  Activating GST for Your Company

         Step-2  : Setting Up GST Rates

              A-        To Set GST Rates for Stock Groups and Stock Items

              B-        Updating Stock Items and Stock Groups for GST Compliance

              C-        Setting MRP Details

              D-        Mapping UoM to UQC

         Step-3  :   Updating/Creating Sales and Purchase Ledgers for GST Compliance

                        A-        Updating / Creating a Sales Ledger : GST Sales

     B-        Updating or Creating a Purchase Ledger : GST- Purchase

         Step-4  :   Restarting Voucher Numbering for GST Transactions

         Step-5      :           Updating/Creating Party GSTIN/UIN

         Step-6      :           Creating GST Ledgers

         Step-7      :           Creating Party Ledgers for GST

         Step-8      :           Recording Purchase under GST

               A- Local Purchase  ( inside State)

               B- Inter-State Purchase ( outside State)

         Step-9 :   Recording GST Sales and Printing Invoices

              A – Local Sale

              B- Printed Invoice Format

              C- Inter-State Sales (Outside State)

              D- Sale of Goods and Services in a Single Invoice

   E- Ledgers for any Indirect Expenses like… Discount on Sale, Packing Charges etc. can be created and to be included in GST Sale Invoice

7.4.   Generate GSTR-1 Returns / Reports under Tally.ERP9

7.4.1.   Table-Wise Format (Department Format)

7.4.2.   Returns Summary ( GSTR-1)

              Total number of vouchers for the period

              Included in returns

              Not relevant for returns

              Incomplete / Mismatch in information (to be resolved)

                        (SUMMARY OF EXCEPTIONS – GSTR-1)         No. of voucher with incomplete / mismatch in information

                      UoM (S) Not Mapped To Unit Quantity Code                                                            (UQC)

                       Country , State and Dealer Type not                                                             Specified

                       Tax Rate / Tax Type not Specified         Nature of transaction, taxable value, rate of tax modified in voucher         Incorrect tax type selected in tax ledger         Mismatch due to tax amount modified in voucher      Voucher with incomplete / incorrect adjustment details ( SGTR-2)         Information required for generating table-wise details not provided

                7.4.3.   GSTR-1 Particulars ( Computation Details)

              Outward Supplies

7.4.4.   Status Reconciliation (GSTR-1)            Set Status            Status-wise View

7.4.5.   Exporting GSTR-1

7.5.      Generate GSTR-2 Returns / Reports under Tally.ERP9

7.5.1.   Returns Summary            Total Number Of Vouchers For The Period            Included in the Returns            Not Relevant for Returns            Incomplete / Mismatch in information ( to be resolved)

[ SUMMARY OF EXCEPTIONS – GSTR-2 ]         No. of voucher with incomplete /                         mismatch in information         UoM not mapped to Unit Quantity Code                         (UQC)         Country, State and Dealer Type not                         Specified         Tax Rate/ Tax Type Not specified         Nature Of Transaction, Taxable Value, Rate Of Tax Modified In Voucher         Incorrect Tay Type Selected in Tax Ledger         Mismatch due to Tax Amount Modified in Voucher         Voucher with incomplete / incorrect Adjustment Details (GSTR-2)         Information required for Generating Table-Wise details not Provided

7.5.2.   File GSTR-2  

              Download GSTR-2 file from the GST portal            Load the GSTR-2 file in Tally.ERP9            Reconcile the Status for Invoice in GSTR-2 File            Generate the return in JSON format and file the return

7.6.      Generating Form GSTR-3B

7.6.1.   Summary View ( GSTR-3B)

7.6.2.   Generate GSTR-3B and File Returns

7.7.      Challan Reconciliation Report for GST Payments

7.8.      Creating Income and Expenses Ledger in GST

7.9.      Reverse Charge on Purchase from Unregistered Dealer (URD) | Reverse Charge in GST in Tally

7.10.    GST On Advance Payment Received From Customer in Tally | GST in Tally.ERP 9

7.10.1. Advance Receipt exclusive of tax adjusted against Sales Invoice in the same month          To record a receipt voucher for advance receipt from customer exclusive of tax          Sales Invoice Linked to an Advance Receipt Voucher in the same month as above.

7.10.2. Advance Received and Sales Invoice recorded in different months.

                        Advance Receipt Voucher

                        Journal Voucher to Raise the Liability          Sales Invoice against Advance Receipt of Previous Month

7.10.3. Journal Voucher to Reverse the Tax Liability raised  for the Advance Received of the Previous Month

                        To exclude a transaction          To reverse the liability on cancellation of a transaction

7.11.    Recording An Advance Payment To Supplier Under GST

7.12.    Transferring Tax Credits of VAT, Excise, and Service Tax to GST

7.13.    Recording Sales of Composite Supply under GST ( Expenses Apportioning)

7.14.    Nil-Rated Sales

7.15.    Exempt Sales

7.16.    Adjustment & Set-off  the Liability of GST (Tax) Credit under GST

7.17.    Recording Journal Vouchers for Interest, Penalty, Late Fee and Other             Dues in GST

7.18.    e-Way Bill in Tally.ERP9

7.18.1. (Step-1)  :         Setup e-Way Bill in Tally.ERP9

7.18.2. (Step -2) :       Record invoice with details required for e-Way Bill, and create JSON in                                      Tally.ERP9

7.18.3. (Step -3):          Print the invoice with e-Way Bill number in Tally.ERP9 in Tally.ERP9

         7.18.4. (Step - 4) :     Export for e-Way Bill Report in Tally.ERP9
                  Status-wise View of e-Way Bill Report
                            A-        Exception: HSN Code not specified
                            B-        Exception: Information required for e-Way Bill not provided
                            C-        Invoices Ready for Export
                            D-        Invoices Exported
                 Voucher-wise View of e-Way Bill Report

7.18.5. (Step - 5) :     Update e-Way Bill Information in Tally.ERP9

7.18.6. (Step -6) :      e-Way Bill Report in Tally.ERP9

                  Invoices with e-Way Bill Information
                  Consolidated e-Way Bill View
                  Export Data to JSON preparation tool, and Create JSON

7.18.7. (Step -7) :       Enter e-Way Bill Details Directly on the Portal         Generate the e-Way Bill number         Print e-Way Bill later         Update invoices in Tally.ERP 9 with e-Way Bill numbers and print         Generate e-Way Bill using JSON Preparation Tools, and upload to Portal



Advanced Inventory Vouchers in Tally.ERP 9

  • Introduction
  • Unit Objectives
  • Standard Vouchers

8.1.      Order Processing

            8.1.1.   Purchase Order Processing

            8.1.2.   Altering a Purchase Order

            8.1.3.   Sales Order Processing

            8.1.4.   Altering a Sales Order

            8.1.5.   Display Order Position

            8.1.6.   Display Columnar Orders & Stock Details

            8.1.7.   Adjusting Orders

8.2.      Re-Order Levels

            8.2.1.   Defining Re-Order Levels

            8.2.2.   Display Re-Order Status

8.3.      Tracking Numbers

            8.3.1.   Using Tracking Numbers

            8.3.2.   Display Purchase Bill Pending

8.4.      Batch-wise Details

            8.4.1.   Activating Batch-wise Details

            8.4.2.   Using Batch-wise Details in Sales Invoice

8.5.      Bill of Materials ( BoM)

            8.5.1.   Creating Bill of Materials

            8.5.2.   Creating a Manufacturing Journal

            8.5.3.   Using Bill Of Materials

8.6.      Price Levels and Price Lists

            8.6.1.   Activating Price Lists and Defining Price Lists

            8.6.2.   Using Price Lists

8.7.      Zero Valued Entries

            8.7.1.   Creating Zero Valued Entries

8.8.      Inventory Ageing Analysis

            8.8.1.   View Inventory Ageing Report

8.9.      Different Actual and Billed Quantities

            8.9.1.   Using Different Actual and Billed Quantities

8.10.    Physical Stock Voucher ( Alt + F10)

8.11.    Rejection In ( Ctrl + F6)

8.12.    Rejection Out ( Alt + F6)

8.13.    Stock Journal ( Alt + F7)




9.1.      Maintain Bill-wise Details

9.2.      Cost Center and Cost Category

9.3.      Interest Calculation

9.4.      Reversing Journal

9.6.      Post-Dated Voucher

9.6.      Memo (Memorandum) Voucher

9.7.      Optional Voucher



Tally.ERP 9 Reporting


  • Introduction
  • Unit Objectives

10.1.    Modifying Reports (Options)

10.2.    Balance Sheet

10.3.    Profit & Loss Account

10.4.    Stock Summary

10.5.    Trial Balance

10.6.    Day Book

10.7.    Books of Accounts

10.7.1. Cash Book

10.7.2. Petty Cash Book

10.7.3. Bank Book

10.7.4. Journal Register

10.7.5. Ledger

  • Group Summary
  • Group Voucher

10.7.6. Purchase Register

10.7.7. Sales Register

10.8.    Statement of Accounts

10.8.1. Outstanding

            Ledger-wise view of Outstanding Reports

            Group (Outstanding)

10.8.2. Interest Calculations          Interest Receivable          Interest Payable

10.8.3. Cost Centers          Cost Category Summary          Group Break-Up

10.8.4. Statistics

10.9.    Inventory Books

10.9.1. Inventory Group Summary

10.9.2. Stock Transfers

10.9.3. Physical Stock Register

10.9.4. Sales Order Book

10.9.5. Purchase Order Book

10.10.  Statutory Reports

10.11.  List of Accounts ( Chart of Accounts)

10.12.  Exception Reports

10.12.1. Negative Stock

10.12.2. Negative Ledgers

10.12.3. Overdue Receivables

10.12.4. Overdue Payable

10.12.5. List of Memorandum Vouchers

10.12.6. List of Reversing Journal

10.12.7. List of Optional Voucher

10.12.8. List of Cancelled Vouchers

10.12.9. List of Post Dated Voucher

10.13.  Printing Reports

10.13.1. Using the Print Button

10.13.2. Multi-Accounting Printing





MIS and Other Reports


11.1.    Receivable and Payable Statement Report

11.2.    Ageing Report

11.3.    Godown wise Stock Report

11.4.    Movement Analysis

11.5.    Transaction wise Profitability Analysis

11.6.    Stock Summary

11.7.    Bank Reconciliation

11.8.    Stock Category wise Report

11.9.    Sales Order Pending Register

11.10.  Purchase Order Pending Register

11.11.  Sales Bill Pending Register

11.12.  Product Register 





12.1.    Back Up / Restore

12.2.    Split Company Data

12.2.1. How to Split Financial Years

12.3.    Tally.ERP 9 Vault

12.4.    Exporting Master Data

12.5.    Importing Data

12.6.    Consolidation of Accounts

12.6.1. Create a Group Company

12.7.    Password or Security Control

            12.7.1. Types of Security ( security or authority levels)

            12.7.2. Users and Passwords

12.8.    Credit Limites

            12.8.1. Setting Credit Limits

            12.8.2. Exceeding Credit Limits




Voucher Classes & Voucher Types ( Creations)



POS - Point of Sale ( POS Invoicing )



TDS (Tax Deducted at Source) using Tally.ERP9


15.1.    Enabling TDS in Tally.ERP9

15.2.    Creating TDS Nature of Payment

15.3.    Creating Master Ledgers with TDS Transactions

            A-        TDS on Expenses

            B-        TDS on Advance Payment against Expenses

            C-        Recording TDS Payment Transaction

15.4.    TDS Reports

            A-        Form 26Q (TDS)

            B-        Form 27Q (TDS)

            C-        TDS Reconciliation Report

            D-        TDS Outstanding Report


Short-Cut Keys


Common Across Screens

Gateway of Tally

Inventory Master Creation/Alteration Screen

Accounting Voucher Creation/Alteration Screen

Inventory Voucher Creation/Alteration Screen

Simplified GST in Tally.ERP9

"Practical Assignment"

1. Company Creation
2. Modification of Company
3. Deletion of Company
4. Shut (Close) a Company
5. Creating Accounts GROUP
  A- Creating Single Groups
  B- Creating Multiple Groups
6. Creating Accounts  “Single LEDGER”
7. Creating a Multiple LEDGER
8. Creating a Expenses / Income LEDGER
9. Creating a Single Stock Group
10. Creating a Multiple Stock Group
11. Creation of Stock Units
12.  Creation of Single Stock Item
13.  Voucher Entry ( Receipt Voucher – F6 )
14.  Payment Transactions (Payment Voucher - F5)
15.  Contra Voucher (F4)
16.  Journal Vouchers (F7)
17.  GST ( Goods and Service Tax ) on Tally.ERP9
  17.1.    Activating GST for Your Company
  17.2.    Setting Up GST Rates (Stock Group-wise)
  A- To Set GST Rates for Stock Groups and Stock Items
  B- To Update a Stock Item
  17.3.    Recording GST Purchase (Local)
  Creating a Purchase Ledger : Purchase @ 18%
  Creating GST Ledger for Purchase (Local)
  A- To create ‘Input SGST’ ledger
  B- To create ‘Input CGST’ ledger
  Creating / Altering Supplier (Sundry Creditor) Ledger (Local)
  Updating Party GSTIN/UIN
  Recording Local Purchase (F9) under GST
  A. Local Purchase
  Method-1 : To Record a Local Purchase Transaction
[ Using Common Ledger Account for all items with same Tax Rate]
  Method-2 : To Record a Local Purchase Transaction
[  Without Using Common Ledger Account for all items due to Different Tax Rate ]
  17.4.    Inter-State Purchase (Outside State)
  A. Updating or Creating a Inter-State Purchase Ledger : Inter-State Purchase @ 18%
  B. Creating GST Ledger for Inter-State Purchase (Outside)
  17.5.    Recording GST Sales (Local) and Printing Invoices
  Creating a Sales Ledger (Local) : GST Sales
  Updating Party GSTIN/UIN
  Creating GST Ledger for Sale (Local)
  A- Creating Sundry Debtor Ledger
  B- Updating Party GSTIN/UIN
  Step- 12
  Restarting Voucher Numbering for GST Transactions
  Step- 13
  Recording GST Sales (Local)
  Step- 14
  To Create a Inter-State Sales Ledger i.e.  IGST-Inter-State Sales




October – 2017





Get..Tally.ERP9 Book + GST Assignment @ `. 550 !

15 Chapters in Tally.ERP9 Book + 21 Chapters in GST Practical Assignment on GST in Tally.ERP9 & All features are described with Practical Problems with Solutions.

Buy Now

Disclaimer :
The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :
Tally,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID :
Web :
Mob : 09437264738

© 2019 :

Tally.ERP9 Book CONTENT Tally.ERP9 Book ORDER