Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...
Tally.ERP 9 Book
CONTENTS
Tally.ERP 9 Book
(GST Updated)

CHAPTER - 1

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  

 

CHPATER – 2

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

 

CHAPTER – 3

Set-Up of Accounts

 

>>        Introduction

>>        Unit Objectives

>>        Assets, Liabilities, Income & Expenses

3.1.            The Group

      3.1.1.   Creating Group

                  3.1.1.1.            Creating a Group with Advanced Usage

                  3.1.1.2.            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

3.3.1.1.      Contra Vouchers (F4)

3.3.1.2.      Payment Voucher (F5)

3.3.1.3.      Receipt Voucher (F6)

3.3.1.4.      Journal Voucher ( F7)

3.3.1.5.      Sales Vouchers (F8)

3.3.2.   Pre-defined Voucher Types in Tally.ERP 9

3.3.2.1.      Alter a Pre-defined Voucher Type

 

 

CHAPTER – 4

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

___Summary

___Questions & Exercises

 

CHAPTER – 5

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

 

 

CHAPTER – 6

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)

 

 CHAPTER – 7

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

             C-        Updating or Creating a Inter-State Purchase Ledger :                     Inter-State Purchase

             D-       Updating or Creating a Inter-State Sales Ledger :                    GST-Inter-State Sales

         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)

            7.4.2.1.            Total number of vouchers for the period

            7.4.2.2.            Included in returns

            7.4.2.3.            Not relevant for returns

            7.4.2.4.            Incomplete / Mismatch in information (to be resolved)

                        (SUMMARY OF EXCEPTIONS – GSTR-1)

7.4.2.4.1.         No. of voucher with incomplete / mismatch in information

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

                        7.4.2.4.3.         Country , State and Dealer Type not                                                             Specified

                        7.4.2.4.4.         Tax Rate / Tax Type not Specified

7.4.2.4.5.         Nature of transaction, taxable value, rate of tax modified in voucher

7.4.2.4.6.         Incorrect tax type selected in tax ledger

7.4.2.4.7.         Mismatch due to tax amount modified in voucher

7.4.2.4.7.1.      Voucher with incomplete / incorrect adjustment details ( SGTR-2)

7.4.2.4.8.         Information required for generating table-wise details not provided

7.4.2.4.9.         Exception Types

7.4.2.4.9.1.      Item Exceptions

7.4.2.4.9.2.      Ledger Exceptions

                7.4.3.   GSTR-1 Particulars ( Computation Details)

            7.4.3.1.            Outward Supplies

7.4.4.   Status Reconciliation (GSTR-1)

7.4.4.1.            Set Status

7.4.4.2.            Status-wise View

7.4.5.   Exporting GSTR-1

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

7.5.1.   Returns Summary  

7.5.1.1.            Total Number Of Vouchers For The Period

7.5.1.2.            Included in the Returns

7.5.1.3.            Not Relevant for Returns

7.5.1.4.            Incomplete / Mismatch in information ( to be resolved)

[ SUMMARY OF EXCEPTIONS – GSTR-2 ]

7.5.1.4.1.         No. of voucher with incomplete /                         mismatch in information

7.5.1.4.2.         UoM not mapped to Unit Quantity Code                         (UQC)

7.5.1.4.3.         Country, State and Dealer Type not                         Specified

7.5.1.4.4.         Tax Rate/ Tax Type Not specified

7.5.1.4.5.         Nature Of Transaction, Taxable Value, Rate Of Tax Modified In Voucher

7.5.1.4.6.         Incorrect Tay Type Selected in Tax Ledger

7.5.1.4.7.         Mismatch due to Tax Amount Modified in Voucher

7.5.1.4.8.         Voucher with incomplete / incorrect Adjustment Details (GSTR-2)

7.5.1.4.9.         Information required for Generating Table-Wise details not Provided

                 7.5.1.4.9.1.      Party Ledger Level Corrections

                 7.5.1.4.9.2.      Voucher Level Corrections

7.5.1.4.10.         Exception Types

7.5.1.4.10.1.      Item Exceptions

7.5.1.4.10.2.      Ledger Exceptions

7.5.2.   Status Reconciliation ( GSTR-2)

7.6.      Generating Form GSTR-3B

7.6.1.   Default View

7.6.2.   Table-wise View

7.6.3.   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

Step-1:   Create Supplier Ledger i.e. Supplier (L) URD – Local

Step-2:   Similarly.. Create Supplier Ledger of Outside State i.e. Supplier                           (O) URD- Interstate

Step-3:   Create  Local Purchase Ledger i.e. “Purchase from URD-Local”

Step-4:   Similarly.. Create  Outside Purchase Ledger i.e. “Purchase from URD-Interstate

            Step-5:   Recording an Invoice for Purchase from Unregistered                           Dealer- Local

            Step-6 :  Similarly, You can Record an Invoice for Purchase from                Unregistere Dealer-Interstate (Outside State)

Step-7 :  View Total Tax Liability under Reverse Charge GST in GSTR2

Step-8 :  Recording a Journal Voucher Transaction for Increase in Tax Liability on Purchase from Unregistered Dealers

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

7.10.1.1.          To record a receipt voucher for advance receipt from customer exclusive of tax

7.10.1.2.          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.

                        7.10.2.1.          Advance Receipt Voucher

                        7.10.2.2.          Journal Voucher to Raise the Liability

7.10.2.3.          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

                        7.10.3.1.          To exclude a transaction

7.10.3.2.          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

 

CHAPTER – 8

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)

 

CHAPTER – 9

 

9.1.      Advance Usage of Vouchers

9.2.      Maintain Bill-wise Details

9.3.      Cost Center and Cost Category

9.4.      Interest Calculation

9.5.      Reversing Journal

9.6.      Post-Dated Voucher

9.7.      Memo (Memorandum) Voucher

9.8.      Optional Voucher

 

CHAPTER – 10

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

            10.8.1.1.          Ledger-wise view of Outstanding Reports

            10.8.1.2.          Group (Outstanding)

10.8.2. Interest Calculations

10.8.2.1.          Interest Receivable

10.8.2.2.          Interest Payable

10.8.3. Cost Centers

10.8.3.1.          Cost Category Summary

10.8.3.2.          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

 

 

 

CHAPTER – 11

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 

 

CHAPTER – 12

Utility

 

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

 

 

CHAPTER-13

Voucher Classes & Voucher Types ( Creations)

14.1.    Voucher Types

14.2.    Voucher Classes

 

CHAPTER-14

POS - Point of Sale ( POS Invoicing )

 

CHAPTER – 15

Short-Cut Keys

 

Common Across Screens

Gateway of Tally

Inventory Master Creation/Alteration Screen

Accounting Voucher Creation/Alteration Screen

Inventory Voucher Creation/Alteration Screen

 

 

"Practical Assignment"
Simplified GST in Tally.ERP9
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
Assignment
6. Creating Accounts  “Single LEDGER”
7. Creating a Multiple LEDGER
8. Creating a Expenses / Income LEDGER
Assignment
9. Creating a Single Stock Group
10. Creating a Multiple Stock Group
Assignment
11. Creation of Stock Units
12.  Creation of Single Stock Item
Assignment
13.  Voucher Entry ( Receipt Voucher – F6 )
Assignment
14.  Payment Transactions (Payment Voucher - F5)
Assignment
15.  Contra Voucher (F4)
Assignment
16.  Journal Vouchers (F7)
Assignment
17.  GST ( Goods and Service Tax ) on Tally.ERP9
  Step-1
  17.1.    Activating GST for Your Company
  Step-2
  17.2.    Setting Up GST Rates (Stock Group-wise)
 
  A- To Set GST Rates for Stock Groups and Stock Items
 
Assignment
  B- To Update a Stock Item
 
Assignment
  17.3.    Recording GST Purchase (Local)
  Step-3
  Creating a Purchase Ledger : Purchase @ 18%
  Step-4
  Creating GST Ledger for Purchase (Local)
 
  A- To create ‘Input SGST’ ledger
  B- To create ‘Input CGST’ ledger
  Step-5
  Creating / Altering Supplier (Sundry Creditor) Ledger (Local)
  Step-6
  Updating Party GSTIN/UIN
 
Assignment
  Step-7
  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 ]
 
Assignment
  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)
 
Assignment
  17.5.    Recording GST Sales (Local) and Printing Invoices
  Step-8
  Creating a Sales Ledger (Local) : GST Sales
  Step-9
  Updating Party GSTIN/UIN
 
Assignment
  Step-10
  Creating GST Ledger for Sale (Local)
  Step-11
 
  A- Creating Sundry Debtor Ledger
  B- Updating Party GSTIN/UIN
 
Assignment
  Step- 12
  Restarting Voucher Numbering for GST Transactions
  Step- 13
  Recording GST Sales (Local)
 
Assignment
  Step- 14
  To Create a Inter-State Sales Ledger i.e.  IGST-Inter-State Sales
 
Assignment
   
 

BUSINESS  TRANSACTIONS

September-2017
   
 

BUSINESS  TRANSACTIONS

October – 2017
   
 

BUSINESS  TRANSACTIONS

November-2017
   
 

BUSINESS  TRANSACTIONS

December-2017
18. Filing GSTR-3B
19. Making Payments towards GSTR-3B
20. File GSTR-1
  Step-1 :     Download and install the GST Offline Tool
 
Step-2 :     Export GSTR-1 data from Tally.ERP 9
  Step-3 :     Generate the JSON file
 
Step-4 :     File returns on the GST portal
21. Recording Journal Vouchers for Interest, Penalty, Late Fee and Other Dues in GST
Disclaimer :.

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

Trademark :

Tally, Tally 9, 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 not associated with any product or vendor mentioned in this Website.

 
GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Website Designed, Hosted, Owned by: www.BalasoreCity.Com