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

 

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

 

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

     Step-1  :  Activating GST for Your Company

     Step-2  : Setting Up GST Rates

     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

     Step-9 : Recording GST Sales and Printing Invoices

 

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

  4.1. Table-Wise Format (Department  Format)

 4.2.    Returns Summary ( GSTR-1)

  4.2.1 Total number of vouchers for the period

  4.2.2. Included in returns

  4.2.3. Not relevant for returns

4.2.4.Incomplete/mismatch in information (to be resolved)

      (SUMMARY OF EXCEPTIONS – GSTR-1)

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

       4.2.4.2.  Country , State and Dealer Type not Specified

      4.2.4.3.Tax Rate / Tax Type not Specified

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

4.2.4.5.  Incorrect tax type selected in tax ledger

4.2.4.6.Mismatch due to tax amount modified in voucher

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

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

4.2.4.9.  Exception Types

     4.2.4.9.1. Item Exceptions

     4.2.4.9.2. Ledger Exceptions

4.3. GSTR-1 Particulars ( Computation Details)

     4.3.1. Outward Supplies

 

5.  Status Reconciliation (GSTR-1)

5.1.  Set Status

5.2.  Status-wise View

 

6.  Challan Reconciliation Report for GST Payments

7. Creating Income and Expenses Ledger in GST

 
8. 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 Unregistered 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

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

9.1.  Advance Receipt exclusive of tax adjusted against Sales Invoice in the same month

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

9.1.2.     Sales Invoice Linked to an Advance Receipt Voucher in the same month as above.

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

9.2.1.  Advance receipt voucher

9.2.2. Journal voucher to raise the liability

9.2.3. Sales Invoice against Advance Receipt of Previous Month

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

9.3.  Reversal of GST on account of Cancellation of Advance Received.

9.3.1.  To exclude a transaction

9.3.2. To reverse the liability on cancellation of a transaction

 

10. Recording An Advance Payment To Supplier Under GST

 
11. Transferring Tax Credits of VAT, Excise, and Service Tax to GST
 
12. Recording Sales of Composite Supply under GST
(Expenses Apportioning)
 
13. ‘Nil-Rated Sales’ on GST in Tally.ERP9
 
14. ‘Exempt Sales’ on GST in Tally.ERP9
 
15. FAQ on GST in Tally.ERP 9
 
16. Common Queries About GST in Tally.ERP9
 

GST on Tally.ERP 9 ( With Practical Assignment )

In Tally.ERP 9

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

         Step-1      :        Activating GST for Your Company

         Step-2      :        Setting Up GST Rates

         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

         Step-9      :        Recording GST Sales and Printing Invoices

 


3.    GST on Tally.ERP 9

Let us take the above example and see how it works on Tally.ERP. The procedure for implementation of GST in Tally.ERP is very simple. Follow the steps given below :

 

Step-1

Activating GST for Your Company :

To use Tally.ERP 9 for GST compliance, you need to activate the GST feature. Once activated, GST-related features are available in ledgers, stock items, and transactions, and GST returns can be generated.

 

To activate GST

1.    Open the company for which you need to activate GST.

2.    Press F11 > F3.

3.         Enable Goods and Services Tax (GST) - Yes.

4.         Set/alter GST details - Yes.

State: Displays the state you have selected for your company. Helps in identifying local and interstate transactions. If you change the state, it will be updated in the company details.

5.         Specify the GSTIN/UIN for the business. This can be printed in the invoices as required. You can specify this later.

6.         Specify Applicable from date. GST will be applicable for your transactions from this date onwards.

You can record transactions using the ledgers with GST details, and print invoices with GSTIN.

Step-2

Setting Up GST Rates :

Quickly set up GST rates for your company, stock item-wise or stock group-wise, using the GST Rate Setup option. You must enable GST in your company to provide GST rates. You can set up GST rates at the company level, stock group level, stock item level, ledger group level, and ledger level.

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

1.         Go to Gateway of Tally > Display > Statutory Reports > GST > GST Rate Setup

2.         Select the stock group or stock item, and press Alt+S to provide the applicable tax rates. You can press Spacebar to select multiple stock groups or stock items. Set the tax rates and save.

The rate entered for integrated tax will be equally divided between central tax and state tax.

To view the history of tax rate changes, press Alt + L.

B-      Updating Stock Items and Stock Groups for GST Compliance

If the items you sell have different tax rates, update your stock item masters or stock groups with the applicable GST rates, and select the type of supply, as applicable.

To Update a Stock Item

In case you need different tax rates for different items, modify the stock items to include the applicable tax rates.

1.         Go to Gateway of Tally > Inventory Info. > Stock Items > Alter > select the item

2.    Set/alter GST Details : Yes to specify the details in the GST Details screen, and save.

Note: If you have modified the tax rates before, press Alt + L to view the history of tax rate changes.

3.    Select the Type of supply.

4.    Press Ctrl + A to save.

 

To Update a Stock Group

 

1.    Go to Gateway of Tally > Inventory Info. > Stock Groups > Alter > select the group.
2.    Set/alter GST Details: Yes to specify the details in the GST Details screen, and save.

Integrated Tax: When you enter the integrated tax, state tax and central tax are calculated as half of the integrated tax specified. You can change state tax or central tax by using F12 configuration.

3.    Press Ctrl + A to save

Step-3

Updating Sales and Purchase Ledgers for GST Compliance :

If many items you sell have the same tax rate, specify the tax rate and other GST details in your sales ledger. Similarly, if the items you purchase have the same tax rates, update your purchase ledger.

If you sell items with multiple tax rates, you can still maintain a single Sales Ledger, and record all GST details at the stock item or stock item or stock group level. You can create a single Purchase Ledger similarly.

A.      Updating or Creating a Sales Ledger : Sales @ 18%

To Create a Sales Ledger i.e. Sales @ 18%

1.         Go to Gateway of Tally > Accounts Info. > Ledgers > Create.

2.         Enter the Name of the Sales ledger i.e. Sales @ 18%

3.         Select  Sales Account  from the List of Groups in the Under field.

4.         Set the option Inventory values are affected? to Yes ,.

5.         Is GST Applicable - Applicabl

6.         Set/alter GST Details - Yes, specify the details in the GST Details screen, and save.

To view the history of tax rate changes, press Alt + L.

To specify further GST-related details, click F12: Configure.

4.         Select the Type of supply. By default the type of supply is set to Goods.

5.         Press Ctrl + A to save.

Similarly…you can create all following Sales Ledgers as per our Practical Examples by specify the Tax Rate and other GST details as above :

  • Sales @ 28%
  • Sales @ 12%

B.      Updating or Creating a Purchase Ledger : Purchase @ 18%

To Create a Purchase Ledger i.e. Purchase @ 18%

●          Follow the steps used for updating the sales ledger, with the nature of transaction and rates for purchase.

While recording a sale or purchase transaction, you can select the respective ledger.

Similarly…you can create all following Purchase Ledgers as per our Practical Examples by specify the Tax Rate and other GST details as above :

  • Purchase @ 28%
  • Purchase @ 12%

C.      Updating or Creating a Inter-State Purchase Ledger : Inter-State Purchase @ 18%

To Create a Inter-State Purchase Ledger i.e.  Inter-State Purchase @ 18%

●          Follow the steps used for updating the sales ledger, with the nature of transaction and rates for purchase.

While recording a sale or purchase transaction, you can select the respective ledger.

Similarly…you can create all following Purchase Ledgers as per our Practical Examples by specify the Tax Rate and other GST details as above :

  •  Inter-State Purchase @ 12%

D.      Updating or Creating a Inter-State Sales Ledger : Inter-State Sales @ 12%

To Create a Inter-State Sales Ledger i.e.  Inter-State Sales @ 12%

●          Follow the steps used for creating or updating the sales ledger, with the nature of transaction and rates for purchase.

While recording a sale or purchase transaction, you can select the respective ledger.

Similarly…you can create all following Purchase Ledgers as per our Practical Examples by specify the Tax Rate and other GST details as above :

Step- 4

Restarting Voucher Numbering for GST Transactions :

 It is recommended that you restart voucher numbering for GST transactions to ensure that unique voucher numbers are used for all your vouchers. If Automatic (Manual Override) is set as the method of voucher numbering, it ensures that unique voucher numbers are set for your vouchers.

You can restart voucher numbering for any voucher type.

To restart voucher numbering

1.         Go to Gateway of Tally > Accounts Info. > Voucher Types > Create.

2.         Method of Voucher Numbering? - Automatic (Manual Override).

Note:   For GST transactions, it is recommended that you restart voucher numbering to ensure that unique voucher numbers are used for all your vouchers. If Automatic (Manual Override) is set as the method of voucher numbering, it ensures that unique voucher numbers are set for your vouchers.

3.         Set the option Use Advance Configuration? to Yes.

4.         Press Enter to save. The Voucher Type Alteration (Secondary) screen appears as shown below:

●          Enter the number of the voucher in the Starting Number field.

●          Enter the required value in the Width of Numerical Part field.

●          Set the option Prefill with zero? to Yes, to add zero to the voucher number. If this option is set to No, the voucher number is left blank.

For example, if the Width of Numerical Part is specified as 3, and if Pre-fill with zero? is set to Yes, then the voucher number appears as Sales Invoice No: 001.

●          Enter the Applicable From date in the Restart Numbering column. You can specify more than one restart dates.

●          Select the required interval from the Types of Periods list in the Particulars field.

●          Define the Prefix Details in the Particulars field. Examples of prefix details are: Month of the voucher, i.e.,  April/, company information like SE/, and even fixed number series like 1000.

Note:   The numeric section begins immediately after the prefix information. Therefore, a slash (/) or some other special character is used to highlight a separation; for example, April/. The slash would cause the voucher number to appear as April/001, otherwise it would appear as April001. This simplifies fixed number series appearing, for example, as 200100001 where 2001 is the prefix, and 00001 is the starting number with a width of 5, and with leading zeros.

You can choose different prefix information for different periods, or you can continue with one. The prefix continues from the date mentioned under Applicable from to the date mentioned under Applicable from.

●          Define the Suffix Details for the voucher number. The same rules apply as that for Prefix Details.

5.         Press Enter to save.

The Sales Invoice voucher number appears as shown below:

Step- 5

Updating Party GSTIN/UIN :

Quickly update the GSTIN/UIN details for your parties group-wise from the Update Party GSTIN/UIN report. You can also provide this at the individual party ledger level. Use the Import Party GSTIN tool to import GSTINs for several parties in one shot.

To update party GSTIN or UIN

1.    Go to Gateway of Tally > Display > Statutory Reports > GST > Update Party GSTIN/UIN

2.         Select the group and ledger for which you want to update the GSTIN/UIN.

3.         In the Update Party GSTIN/UIN screen, enter the GSTIN/UIN number for each party.

Click F5 to toggle between Show All and Show Pending.

Show All: Lists all the parties.

Show Pending: Lists the parties with missing details, such as country, state, registration type, or GSTIN/UIN.

Once you have updated the GSTIN/UIN for your parties, you can print the GSTIN details in your invoices for filing returns.

Step- 6

Creating GST Ledgers :

 

To account for the different taxes to be paid under GST (central tax, state tax, union territory tax, integrated tax, and cess), you have to create a tax ledger for each tax type.

 

In our above Practical Examples….the following GST Ledgers will be created :

i.          Input SGST                  [ State Tax at the time of Purchase Locally ]

ii.         Input CGST                 [ Central Tax at the time of Purchase Locally ]

iii.        Input IGST                   [ Integrated Tax at the time of Purchase from Outside State ]

iv.         Output SGST               [ State Tax at the time of Sale Locally ]

v.          Output CGST              [ Central Tax at the time of Sale Locally ]

vi.         Output IGST                [ Integrated Tax at the time of Sale in Outside State ]

i.        To create ‘Input SGST’ ledger

1.         Go to Gateway of Tally > Accounts Info. > Ledgers > Create.

2.    In Under, select Duties & Taxes.

3.    Select GST as the Type of duty/tax.

4.    Select State Tax as the Tax type.

Note : Percentage of Calculation should be 0% ( Don’t Change ) due to multiple Tax Rat

Similarly, you can create ledgers of all above 5 GST Ledgers ( ii to vi ) by selecting the relevant Tax type under GST.

Step- 7

Creating Party Ledgers for GST :

You need to create party ledgers to record business transactions with various parties such as suppliers, customers, and so on.

On this page as per our Practical Examples ….

  • Supplier Ledger :

>>       Raj Infotech

>>       Microtek India Ltd.

  • Customer Ledger

>>       Rajib Roy & Sons

>>       H. Goenka Traders

Supplier Ledger

To create a supplier ledger i.e. Raj Infotech

1.         Go to Gateway of Tally > Accounts Info. > Ledgers > Create.

2.         Enter the Name of the supplier's ledger i.e. Raj Infotech .

3.         Select Sundry Creditors from the List of Groups in the Under field.

4.         Set the option Inventory values are affected? to No,.

5.         In Mailing details, the State is your default local State. You can change name of State from the State List  if your Suppliers belongs to Outside State.

5.         Enable the option Set/Alter GST Details? to open the GST Details screen.

o           Select the relevant Registration Type from the List of registration Types.

o          Enter the 15-digit GSTIN or UIN issued by the tax authority.

o          If the supplier is an e-commerce operator, then enable the option Behave as e-COmmerce Operator?

The GST Details screen appears as shown below:

o     Press Ctrl+A to accept.

The Ledger Creation screen appears as shown below:

8.    Press Enter to save.

Similarly…. Create the Supplier Ledger ‘ Microtek India Ltd. ‘ as per above ,

Customer Ledger

To create a Customer ledger i.e Microtek India Ltd.

1.         Go to Gateway of Tally > Accounts Info. > Ledgers > Create.

2.         Enter the Name of the supplier's ledger i.e. Mircrotek India Ltd. .

3.         Select Sundry Debtors from the List of Groups in the Under field.

4.         Set the option Inventory values are affected? to No.

5.         In Mailing details, the State is your default local State. You can change name of State from the State List  if your Suppliers belongs to Outside State.

6.         Enable the option Set/Alter GST Details? to open the GST Details screen.

o           Select the relevant Registration Type from the List of registration Types.

o          Enter the 15-digit GSTIN or UIN issued by the tax authority.

o          If the supplier is an e-commerce operator, then enable the option Behave as e-COmmerce Operator?

The GST Details screen appears as shown below:

o     Press Ctrl+A to accept.

The Ledger Creation screen appears as shown below:

8.    Press Enter to save.

Similarly…. Create the Customer Ledger ‘H. Goenka Traders ‘ as per above ,

 

Step- 8

Recording Purchase under GST :

Once you activate GST in your company, you can record the purchase of goods and services that attract GST using a purchase voucher. Ensure that you provide unique voucher numbers for your purchase vouchers, and use a new series of voucher numbering.

A.         Local purchase

B.         Interstate purchase

A.      Local Purchase

The purchase of goods or services from a supplier in the same state attracts central tax and state tax.

To record a local purchase transaction

As per our Practical Example No. 1

Purchase from Raj Infotech, 5 CDs of Antivirus Software @ Rs. 800 each, with Input GST rate @ 18%. i.e. Rs.. 720 - [ CGST (9%) Rs.360 and SGST (9%) Rs.360 ]

 1.         Go to Gateway of Tally > Accounting Vouchers > F9: Purchase.

Supplier invoice no.: Displays the sales invoice no. of the supplying party.

Date: Displays the date on which the sales invoice was passed by the supplier.

2.          In Party A/c name, select the supplier's ledger or the cash ledger.

3.          Select the Purchase Ledger applicable for local taxable purchases.

4.         Select the required items, and specify the Quantities and Rates.

5.          Select the central and state tax ledgers.

You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.

As per our Practical Example No. 2

Purchase from Microtek India Ltd. , 10 Monitors @  Rs. 4000 each, with Input GST @ 28% i.e. Rs.11,200 – [ CGST (14%) Rs.5600 and SGST (14%) Rs. 5600. ]

  

B.      Inter-State Purchase

As per our Practical Example No. 3

Purchase 2 ‘Hp-Laptop’ @ Rs. 45,000 with Input IGST @ 18% i.e. Rs. 16,200

and

2 Mi-Note 4 Mobiles @ Rs. 10,000 each with Input IGST 12% i.e. Rs.2,400 –  in Cash from  Outside State – West Bengal from Registered Shop

In the above example…Purchase of Multiple Items GST Rates in one Purchase Bill.

1.         Go to Gateway of Tally > Accounting Vouchers > F9: Purchase.

Press F12 :  Make ‘No’ to Use common ledger account for item allocation as follow :

●     Follow the steps used for recording a local purchase transaction, with the following changes:

o     In Party A/c name, select Cash ledger i.e. Cash .

The Supplementary Details should be as below  with Address, State, GST Registration Type , GSTIN/UIN & Type of Dealer :

o     Select the purchase ledger applicable for interstate purchases for each item i.e. Inter-state Purchase @ 18% for Hp-Laptop &  Inter-state Purchase @ 12% for Mi Note 4 Mobiles.

o     Select the integrated tax ledger i.e. Input IGST.

Depending on the location of the supplier, you can record a local or interstate purchase transaction with the applicable GST rates

 

You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.

Step- 9

Recording GST Sales and Printing Invoices :

Once you activate GST in your company, you can record the sale of goods and services that attract GST using a sales voucher. Ensure that you provide unique voucher numbers for your sales vouchers, and use a new series of voucher numbering.

A.         Local sales

B.         Printed invoice format

C.         Interstate sales

A.      Local Sales

The sale of goods or services to customers in the same state attract central tax and state tax.

To record a Local Sales Transaction

1.    Go to Gateway of Tally > Accounting Vouchers > F8: Sales.

As per our Practical Example No. 4

Sale of 5 Antivirus CDs @ Rs.1500 to Rajib Roy & Sons with output GST 18% i.e. Rs. 1350 – [CGST (9%) Rs. 675 and SGST (9%) Rs.675 ]

  

2.          In Party A/c name, select the customer ledger or the cash ledger.

3.         Select the sales ledger.

4.         Select the required items, and specify the quantities and rates.

5.         Select the central and state tax ledgers.

You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.

6.         In the sales invoice, press Alt+P to print the invoice in the required format.

For multiple copies: Press Alt+P and then Alt+C to select the number of copies.

B.      Printed Invoice Format

As per GST guidelines, details such as the applicable taxes and tax rates, and the GSTIN/UIN of the company and the customer will be captured. Depending on your requirements, you can include additional details in your invoice by clicking F12: Configure

 

As per our Practical Example No. 5

Sale of 10 Monitors @ Rs.4500 , to H. Goenka Traders with Output GST @ 28% i.e. Rs. 12600 – [ CGST (14%) Rs. 6300 and SGST (14%) Rs. 6300 ]

  

The above Local Sales Invoice will be as below :

You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.

As per our Practical Example No. 6

Sale of 2  ‘Hp-Laptop’ @ Rs 50,000 with Output GST @ 18% i.e. Rs.18,000 [ CGST (9%) Rs.9,000 and SGST (9%) Rs.9,000 ] in Cash within Odisha

 

The above Local Sales Invoice will be as below :

You can view the tax details by clicking A: Tax Analysis. Click F1: Detailed to view the tax break-up.

C.      Inter-State Sales

Sale of goods or services to a customer in another state attract integrated tax.

To record an interstate sale

●          Follow the steps used for recording a local sales transaction. The only difference is that you have to select the integrated tax ledger instead of central tax and state tax.

As per our Practical Example No. 7

Sale of 2  Mi-Note 4 Mobiles Outside State @ Rs. 15,000 each with Output IGST 12% i.e. Rs. 3600  in Cash to a Party in Andhra Pradesh

The above Local Sales Invoice will be as below :

Depending on the location of the party, you can record a local or interstate sales transaction with the applicable GST rates, and print the invoice.

 
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 :

GST on Tally.ERP9, TallyERP9 GST, 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.

 
Simplest way to learn GST in Tally.ERP9
Get TallyERP9 Book with GST Updated for Rs.450
 
Get TallyERP9 Book with GST Updated for Rs.450 Get TallyERP9 Book with GST Updated for Rs.450 Tally.ERP9 Book + GST for Tally Book CONTENTS