Add to Favourites

Calculation of GST Based on Slab Rate, Cess on Quantity and Value

This content is valid for TallyPrime Release 2.1 and earlier versions. 

You can define the percentage of GST for a particular price range with/without additional ledgers, or the cess amount per unit, or cess on quantity and value, in the stock item master. These rates will get applied while recording the purchase or sale of the stock items.

If you are using TallyPrime Release 3.0 and later versions, refer to the Supplies with Cess, Discount, MRP Inclusive of GST, Slab Rate topic. 

GST on Slab Rate by Considering the Value of Apportioned Additional Ledger

Stock Item

1. Gateway of Tally > Alter > type or select Stock Item > and press Enter.
   Alternatively, press Alt+G (Go To) > Alter Master > Stock Item > and press Enter.
2. Specify the required details in fields Name, Under, and Units.
3. Set the option GST Applicable to Applicable.
4. Enable the option Set/Alter GST Details to open GST Details screen.
5. Specify the Description and HSN/SAC.
6. In the GST Details screen , press F12(Configure) > set Allow HSN/SAC details to Yes.
7. Select On Item Rate as the Calculation Type. The Tax on Item Rate screen appears.
8. If you want to consider the additional expenses or incomes as part of item value, to arrive at the applicable slab rate, set the option Consider additional expense/income ledger for slab rate calculation to Yes. Based on the slab rate in which the calculated amount falls, the corresponding GST rate will appear in your invoice.
9. Enter the price range under Rate, and the percentage of Integrated Tax Rate
   • Accept the screen, and return to the GST Details screen.
10. Accept the screen. As always, you can press Ctrl+A to save.

Sales invoice

1. Gateway of Tally > Vouchers > press F8 (Sales).
   Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
2. Select the stock item, and enter the quantity and rate per unit.
3. Select the additional ledger enabled for apportionment, and enter the amount.
4. Select the GST ledgers. The taxes are calculated on the slab rate arrived at by considering the value of apportioned additional ledger to stock item rate.
5. To display the Tax Analysis screen
   Press Ctrl+O (Related Reports) > type or select GST – Tax Analysis> and press Enter.
   

   If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
   Press Ctrl+I (More Details) > type or select GST – Tax Analysis> and press Enter.

   • Press Alt+F5 (Detailed) in the Tax Analysis screen to view the tax break-up for the stock item. The GST is calculated on item rate by considering the additional ledger values.
     
6. Press Esc to return to the sales invoice.
7. Accept the screen. As always, you can press Ctrl+A to save.

GST on Slab Rate by Excluding the Value of Apportioned Additional Ledger

Stock item

1. Gateway of Tally > Alter > type or select Stock Item > and press Enter.
   Alternatively, press Alt+G (Go To) > Alter Master > Stock Item > and press Enter.
2. Specify the required details in fields Name, Under, and Units.
3. Set the option GST Applicable to Applicable.
4. Enable the option Set/Alter GST Details to open GST Details screen.
5. Specify the Description and HSN/SAC.
6. Select On Item Rate as the Calculation Type. The Tax on Item Rate screen appears.
7. If you want to consider the additional expenses or incomes as part of item value to arrive at the applicable slab rate, retain the option Consider additional expense/income ledger for slab rate calculation as No. Based on the item rate, the corresponding GST rate will appear in your invoice.
   
8. Enter the price range under Rate, and the percentage of Integrated Tax Rate.
9. Accept the GST Details screen. As always, you can press Ctrl+A to save.

Sales invoice

1. Gateway of Tally > Vouchers > press F8 (Sales).
   Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
   
2. Select the stock item, and enter the quantity and rate per unit.
3. Select the additional ledger enabled for apportionment, and enter the amount.
4. Select the GST ledgers. The taxes are calculated on the slab rate arrived at by excluding the value of apportioned additional ledger.
5. To display the Tax Analysis screen
   Press Ctrl+O (Related Reports) > type or select GST – Tax Analysis> and press Enter.
   

   If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
   Press Ctrl+I (More Details) > type or select GST – Tax Analysis > and press Enter.

   • Press Alt+F5 (Detailed) in the Tax Analysis screen to view the tax break-up for the stock item. The GST is calculated on item rate by considering the additional ledger values.
     
6. Press Esc to return to the sales invoice.
7. Accept the screen. As always, you can press Ctrl+A to save.

Define GST Rate Based on Slab Rate or Price Range – Same Item of Different Price per Unit

Stock item

1. In the Stock Item Alteration screen, set the option GST Applicable to Applicable.
2. Enable the option Set/Alter GST Details to open GST Details screen.
3. Specify the Description and HSN/SAC.
4. Select On Item Rate as the Calculation Type. Enter the price range under Rate, and the percentage of Integrated Tax Rate.
   
5. Accept the GST Details screen. As always, you can press Ctrl+A to save.

Sales invoice

1. Gateway of Tally > Vouchers > press F8 (Sales).
   Alternatively, press Alt+G (Go To) > Create Voucher > press F8 (Sales).
2. If you are selling the same stock item at a different price per unit depending on the stock available, you can select the same stock item twice in the invoice and enter the applicable rate per unit.
3. Select the GST ledgers. The taxes are calculated based on the price range defined in the stock item master.
4. To display the Tax Analysis screen
   Press Ctrl+O (Related Reports) > type or select GST – Tax Analysis> and press Enter.
   

   If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
   Press Ctrl+I (More Details) > type or select GST – Tax Analysis> and press Enter..

   • Press Alt+F5 (Detailed) in the Tax Analysis screen to view the tax break-up for the stock item. The GST is calculated on item rate by considering the additional ledger values.
     
5. Press Esc to return to the sales invoice.
6. Accept the screen. As always, you can press Ctrl+A to save.

Tax rate calculation for change in rate slab

If the rate slab of your stock items changes due to any applicable discounts, you can override the tax rates at the transaction level. To override tax rate defined for the stock items, in the invoice

1. In the Sales invoice, Press F12 (Configure), Set Modify Tax Rate details of GST to Yes.
2. On selecting the stock item, in the Tax Classification Details screen, Press F12 (Configure), set Override tax rate to Yes. and press Enter.
3. Enter the tax rate applicable based on the rate slab of the stock item.