https://help.tallysolutions.com/docs/te9rel63/Tax_India/gst/calculation_on_price_range_or_cess_on_quantity_gst.htm

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

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.

GST on slab rate by considering the value of apportioned additional ledger

GST on slab rate by excluding the value of apportioned additional ledger

GST rate on slab rate - same stock item at different price per unit

Cess based on value and quantity

Cess based on quantity

GST on slab rate by considering the value of apportioned additional ledger

To configure a stock item for GST calculation based on slab rate by considering additional ledger value

1. Go to Gateway of Tally > Inventory Info. > Stock Items > Create or Alter .

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 GS T Details screen.

Specify the Description and HSN/SAC .

Select On Item Rate as the Calculation Type .

Set the option Consider additional expense/income ledger for slab rate calculation to Yes in the Tax on Item Rate screen.

Enter the price range under Rate , and the percentage of Integrated Tax Rate .

Accept the screen, and return to the GS T Details screen.

5. A ccept the Stock Item Creation screen.

To record a sales invoice for calculating GST based on slab rate arrived at after considering the additional ledger value

1. Go to Gateway of Tally > Accounting Vouchers > 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. Click A : Tax Analysis .

6. In the Tax Analysis screen, click F1 : Detailed to view the tax break-up for the stock item. The GST is calculated on item rate by considering the additional ledger values.

7. Press Esc to return to the sales invoice.

8. Press Ctrl+A to save.

GST on slab rate by excluding the value of apportioned additional ledger

To configure a stock item for GST calculation based on slab rate by excluding additional ledger value

1. Go to Gateway of Tally > Inventory Info. > Stock Items > Create or Alter .

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 GS T Details screen.

Specify the Description and HSN/SAC .

Select On Item Rate as the Calculation Type .

Set the option Consider additional expense/income ledger for slab rate calculation to No in the Tax on Item Rate screen.

Enter the price range under Rate , and the percentage of Integrated Tax Rate .

A ccept the GS T Details screen.

5. A ccept the Stock Item Creation screen.

To record a sales invoice for calculating GST based on slab rate by excluding the additional ledger value

1. Go to Gateway of Tally > Accounting Vouchers > 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. Click A : Tax Analysis .

6. In the Tax Analysis screen, click F1 : Detailed to view the tax break-up for the stock items. The GST is calculated on item rate without considering the additional ledger values.

7. Press Esc to return to the sales invoice.

8. Press Ctrl+A to save.

Defining the GST rate based on slab rate or price range - same item of different price per unit

To configure a stock item for GST calculation based on the slab rate or price range

1. In the stock item master, set the option GST Applicable to Applicable .

2. Enable the option Set/alter GST Details? to open GS T Details screen.

Specify the Description and HSN/SAC .

Select On Item Rate as the Calculation Type . Enter the price range under Rate , and the percentage of Integrated Tax Rate .

A ccept the GS T Details screen.

3. A ccept the Stock Item Creation screen.

To record a sales invoice for a stock item configured with GST on price range

1. Go to Gateway of Tally > Accounting Vouchers > 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. Click A : Tax Analysis .

5. In the Tax Analysis screen, click F1 : Detailed to view the tax break-up for the stock items selected in the invoice.

6. Press Esc to return to the sales invoice.

7. 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. Press F12: Configure , and set

Use common ledger account for item allocation - No

Allow modification of tax details for GST? - Yes

Note: Retain Use common ledger account for item allocation as Yes , if you want to set a common tax rate for all the stock items selected at the invoice level.

2. On selecting the stock item, in the Tax Classification Details screen, set F12: Configure > Override tax rate - Yes , and press Enter.

3. Enter the tax rate applicable based on the rate slab of the stock item.

Calculating Cess B ased on Value and Quantity

To configure a stock item for the calculation of cess based on value and quantity

1. Go to Gateway of Tally > Inventory Info. > Stock Items > Create or Alter .

2. Specify the required details in the fields Name , Under , and Units .

3. Set the option GST Applicable to Applicable .

4. Enable the option Set/alter GST Details? to open the GS T Details screen.

Specify the Description and HSN/SAC .

Select On Value as the Calculation type , and Taxability as Taxable .

Enter the percentage of Integrated Tax Rate .

For Cess :

o Enter the percentage of Integrated Tax . The Central Tax and State Tax rates are displayed.

o For Cess , the cursor moves to the Rate column. Press Backspace to select the Valuation Type as Based on Value and Quantity . Enter the cess Rate and cess rate per unit.

Note: You can also select the Valuation Type of cess as Based on Value and Quantity in the GST Rate Details screen of Tax Rate History .

Accept the GST Details screen.

5. A ccept the stock item master.

To record a sales invoice for a stock item configured with cess based on value and quantity

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

2. Select the central and state tax ledgers, or integrated tax ledger (for interstate sales), and cess ledger. The taxes are calculated based on the cess rate and cess rate per unit defined in the stock item master.

3. Click A : Tax Analysis .

4. In the Tax Analysis screen, click F1 : Detailed to view the tax break-up for the stock items selected in the invoice.

5. Press Esc to return to the sales invoice.

6. Press Ctrl+A to save.

Changing the valuation type of cess in the invoice

You can override the valuation type of cess at the transaction level.

To override the cess details in the invoice

1. Click F12: Configure , and set:

Use common ledger account for item allocation - No

Allow modification of tax details for GST? - Yes

Note: Retain Use common ledger account for item allocation as Yes , if you want to set a common cess rate for all the stock items selected at the invoice level.

2. Select the stock item, then the sales ledger. In the GST Details screen, click F12: Configure > Override tax rate - Yes > Allow override cess valuation type/tax rate based on quantity - Yes , and press Enter .

3. Select the Valuation Type of Cess as Based on Value and Quantity , and enter the cess rate and cess rate per unit.

Defining cess amount based on quantity

To configure a stock item for calculating cess based on quantity

1. Go to Gateway of Tally > Inventory Info. > Stock Items > Create or Alter .

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 GS T Details screen.

5. Click F12: Configure and set the option Select valuation type? to Yes , and accept the Configuration screen.

6. In the GST Details screen

Specify the Description and HSN/SAC .

Set the Calculation Type as On Value .

Set the Valuation Type of Cess as Based on Quantity , and enter the Rate per unit.

Press Enter to save, and return to the Stock Item Creation screen .

7. Accept the stock item master .

To record a sales invoice for a stock item configured with cess amount charged per unit

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

2. Select the GST ledgers. The taxes are calculated based on the rates defined in the stock item master.

3. Select the cess ledger. The cess is calculated based on the rate per unit defined in the stock item master.

4. Click A : Tax Analysis .

5. In the Tax Analysis screen, click F1 : Detailed to view the tax break-up for the stock items selected in the invoice.

6. Press Esc to return to the sales invoice.

7. Press Ctrl+A to save.