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

         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

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.        Country , State and Dealer Type not Specified

                        7.4.2.4.3.         Tax Rate / Tax Type not Specified

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

7.4.2.4.5.         Incorrect tax type selected in tax ledger

7.4.2.4.6.         Mismatch due to tax amount modified in voucher

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

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

7.4.2.4.8.         Exception Types

7.4.2.4.8.1.      Item Exceptions

7.4.2.4.8.2.      Ledger Exceptions

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

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.         Country, State and Dealer Type not                         Specified

7.5.1.4.3.         Tax Rate/ Tax Type Not specified

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

7.5.1.4.5.         Incorrect Tay Type Selected in Tax Ledger

7.5.1.4.6.         Mismatch due to Tax Amount Modified in Voucher

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

7.5.1.4.8.         Exception Types

7.5.1.4.8.1.      Item Exceptions

7.5.1.4.8.2.      Ledger Exceptions

7.5.2.   Table-wise Format  GSTR-2

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

Interest Calculations

 

 

CHAPTER-14

Voucher Classes & Voucher Types ( Creations)

14.1.    Voucher Types

14.2.    Voucher Classes

 

CHAPTER-15

POS - Point of Sale ( POS Invoicing )

 

CHAPTER – 16

Short-Cut Keys

 

Common Across Screens

Gateway of Tally

Inventory Master Creation/Alteration Screen

Accounting Voucher Creation/Alteration Screen

Inventory Voucher Creation/Alteration Screen

 

 

Book on
Simplified GST in Tally.ERP9
(Release 6.1)

1.         Activating GST for Your Company

2.         Setting Up GST Rates

3.         Updating Stock Items and Stock Groups for GST Compliance

3.1.      Updating a Stock Item

3.2.      Updating a Stock Group

3.3.      Non-GST Goods

3.4.      Setting MRP Details

3.5.      Setting Slab-wise GST Details ( Tax on Item Rate)

3.6.      Mapping UoM to UQC

4.        Updating Sales and Purchase Ledgers for GST Compliance

4.1.      Updating a Sales Ledger

4.2.      Updating a Purchase Ledger

5.         Providing GST Details

6.         Restarting Voucher Numbering

7.         Updating Party GSTIN/UIN

8.         Creating GST Ledgers

9.         Creating Expense and Income Ledgers in GST

10.       Recording GST Sales and Printing Invoices

10.1.   Local Sales

10.1.1.            Local Sales Using Item Rate

10.1.2.            Local Sales with MRP

10.3.   Interstate Sales

10.4.   Sales of Goods and Services in a Single Invoice

10.5.   Sales in the Accounting Invoice Mode

11.       Sales Invoice Printing Configuration

12.       Recording Purchases under GST

            12.1.   Local purchase

12.2.   Interstate purchase

13.      Recording Sales of Composite Supply Under GST            (Expense Apportioning)

14.       Recording Sale of Mixed Supply Under GST

15.      Purchase from Unregistered Dealer (URD) in GST             under Reverse Charge

15.1.   Updating your Party Ledgers

15.2.   Recording a Purchase Invoice  

15.3.   Recording a Journal Voucher to Raise the Tax Liability

15.4.   Claim Tax Credit On Reverse Charge Liability Raised

16.      Recording an Advance Payment to an Unregistered Dealer (URD) for the Purchase of Goods on a Future Date in GST under Reverse Charge.

16.1.   To Record An Advance Payment

16.2.   Raising Liability For Advance Payments

16.3.   Recording Purchase Invoice By Adjusting It With Advance Payment

16.4.   Claiming Tax Credit

16.5.   Reversing The Tax Liability Raised On Advance Payment  Made To Unregistered Dealer

17.       Accounting for Refund of Advance Payments made to an Unregistered Dealer (URD) and Reversal of Tax under GST

17.1.   To Record A Refund Voucher

17.2.   To Reverse The Tax Liability

18.       GST Liability on Advance Receipts

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

20.      Map UoM (Unit of Measurement) – UQC (Unit Quanity            Code) of GST

21.       HSN/SAC Summary

22.       Challan Reconciliation Report for GST Payments

23.       Different Forms To Be Filed And The Current Filing              Dates Under GST?

24.       How to Set Off Input Tax Credit Against Tax Liability in             the GST Regime

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

26.       GST Sales - Nil Rated, Exempt, SEZ, Deemed Export, Consumer, Consignee Sales, and Works Contract

26.1.    Nil-rated Sales

26.2.    Exempt Sales

26.3.    SEZ Sales

26.4.    Deemed Export

26.5.    Sales to consumers - Taxable and Exempt

26.6.    GST Sales Involving Consignee (Ship To) and Buyer (Bill To)

26.7.    Sale of works contract services

27.       Using Multiple Addresses for Ledger Accounts under GST

27.1.   Use Multiple Addresses in Transactions

28.       Print  Multiple Addresses in Reports

            28.1.   Print Multiple Addresses in Vouchers and Invoices

29.      FAQ on GSTR1, GST Invoicing and Printing, GST Features and Tax Calculations, Unregistered Dealer (URD), HSN / SAC for GST, Recording Transactions under GST, Licensing and Migration for GST

29.1.   FAQ  on GSTR 1

29.2.   FAQ  on GST Invoicing and Printing

29.3.   FAQ  on GST Features and Tax Calculations

29.4.   FAQ  on Unregistered Dealers under GST

29.5.   FAQ  on HSN/SAC for GST

29.6.   FAQ  on Recording Transactions under GST

29.7.   FAQ  on Others

 

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 : 09853349238, 09437264738
Website Designed, Hosted, Owned by: www.BalasoreCity.Com