HomeTallyPrimeTaxation ComplianceIndia GST - RegularGST SalesSales with Cess, Discount, MRP & Slab Rate

 

Explore Categories

 

 PDF

Supplies with Cess, Discount, MRP Inclusive of GST, Slab Rate

In your business, for some goods, you might have to charge a cess along with GST as per Section 8 of The Goods and Services Tax (Compensation to State) Act, 2017. This topic covers the recording of the sale of items with cess and also the sale of goods or services with discounts. Additionally, you can set the slab rates of stock items based on MRP or Item rates before recording the sales voucher. Later, you can record the sales transaction with the defined slab rates. You can also sell goods and services with an MRP Inclusive of tax. MRP stands for Maximum Retail Price and it is the highest price that can be charged for a product as decided by the manufacturer. If MRP is listed as Inclusive of Tax, it means the price of the product already includes the applicable taxes and the customer does not have to pay the tax separately.

GST cess is a compensation cess that is charged on both local and interstate supply of goods and services. Cess is charged to compensate for the loss of revenue in a state. If you are selling certain goods like tobacco, cigarettes, aerated water, and more, you need to pay cess to the government. In TallyPrime, there is more than one way to calculate cess for the sale of goods and services. You can record the sale by calculating cess either on the value or on quantity or on both. If you are selling goods, then you can calculate cess based on quantity or based on value and quantity. On the other hand, if you are selling services then cess is calculated based on value. Once you record the transaction, you can print the cess details in your invoice. If required, you can also override the cess valuation for your transaction.

While selling goods or services, you might want to give discounts to your customers as part of your business policy. Such discounts can be either for each item separately or on the total invoice amount. In both cases, the tax is calculated after deducting the discount amount.

You can also create a voucher class and include the tax details. Going forward, when you record the sales transaction, with the voucher class, the total amount is calculated including the tax. From the voucher alteration screen, you can view the breakup of your total amount, displaying the sales and tax ledgers. You can create slab rates based on MRP or item rates even before recording the transactions. You might be selling a product whose tax rate depends on the product rate. In such cases, you can set up a slab rate and define the slab-wise item rate along with the tax rate for each slab. Once you start recording the transaction, depending on the rate you select for the item, the tax gets calculated based on the rate defined in the slab rate.

In TallyPrime, you can record all the above-mentioned transactions using a sales voucher. You just need to configure your Sales ledger and your stock items, and you can record the transactions with ease.

Record Sales of Items with Cess

If you are in the business of selling tobacco, cigarettes, pan masala, coal, and more, you might have to charge cess along with GST. The cess is calculated based on either value, quantity, or both. While creating the stock item, you need to select the cess valuation type along with the cess rate. At the time of recording the sales voucher, once you select the cess ledgers, the amount gets calculated as per the rate defined. As per the new Notification No. 02/2023 issued by the Government of India, there is a change in the calculation of compensation cess for Pan Masala and Tobacco products. The notification introduces a retail sale price-based compensation cess system. 

In this section

Record Sales of Items with Cess on Value and Quantity

When you are recording the sales voucher with cess, you need to create the stock item by configuring the cess details. You can record the sale of items by calculating the cess based on value and quantity.

  1. Configure the stock items for the calculation of cess based on quantity and value.
    1. In the Stock Item Alteration screen, update the HSN/SAC & Related Details and GST Rate & Related Details.
    2. Select Cess Valuation Type as Based on Value and Quantity.
    3. Under Cess Rate, enter the cess percentage and cess rate per unit.
      stock item creation for cess
    4. Press Ctrl+A to accept the screen.
  2. Open the sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) > select Item Invoice.
  3. Enter the Party A/c nameSales ledger and stock item details.
  4. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  5. Select the cess ledgers defined with valuation types Based on Quantity and Based on Value.
    The taxes are calculated based on the cess percentage and cess rate per unit defined in the stock item master.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for cess on quantity and value
  7. Press Esc to return to the sales invoice.
    Record transaction with cess on quantity and value
  8. As always, press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. Configure the stock items for the calculation of cess based on quantity and value.
    1. In the Stock Item Alteration screen, enable Set/Alter GST Details.
    2. Update the HSN/SAC Details and Tax Details.
    3. Press F12 (Configure) and enable Select Valuation Type.
    4. Select Valuation Type for Cess as Based on Value and Quantity.
    5. Under Rate for Cess, enter the cess percentage and cess rate per unit.
      Cess-based-on-value-quantity
    6. Press Ctrl+A to accept the screen.
  2. Open the sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) > select Item Invoice.
  3. Enter the Party A/c nameSales ledger and stock item details.
  4. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  5. Select the cess ledgers defined with valuation types Based on Quantity and Based on Value.
    The taxes are calculated based on the cess percentage and cess rate per unit defined in the stock item master.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  7. Press Esc to return to the sales invoice.
  8. As always, press Ctrl+A to save the sales voucher.

You have now recorded sales both with cess on value and quantity.

Record sales of items with cess on quantity or value

When you are recording the sales voucher with cess, you need to create the stock item by configuring the cess details. You can record the sale of items by calculating the cess based on value or quantity whichever is higher. In this case, we have considered cess calculation based on quantity.

  1. Configure stock items for the calculation of cess based on quantity or value.
    1. In the Stock Item Alteration screen, update the HSN/SAC & Related Details and GST Rate & Related Details.
    2. Select Cess Valuation Type as Based on Quantity.
    3. Under Cess Rate, enter cess rate per unit.
      stock item creation for cess on quantity
    4. Press Ctrl+A to accept the screen.
  2. Open the sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) > select Item Invoice.
  3. Enter the Party A/c nameSales ledger and stock item details.
  4. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  5. Select the cess ledgers defined with valuation types Based on Quantity. The taxes are calculated based on the cess rate per unit defined in the stock item master.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for cess on quantity
  7. Press Esc to return to the sales invoice.
    Record transaction with cess on quantity
  8. As always, press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. Configure the stock items for the calculation of cess based on quantity and value.
    1. In the Stock Item Alteration screen, enable Set/Alter GST Details.
    2. Update the HSN/SAC Details and Tax Details.
    3. Press F12 (Configure) and enable Select Valuation Type.
    4. Select Valuation Type for Cess as Based on Quantity.
    5. Under Rate for Cess, enter the cess rate per unit.
    6. Press Ctrl+A to accept the screen.
  2. Open the sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) > select Item Invoice.
  3. Enter the Party A/c nameSales ledger and stock item details.
  4. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  5. Select the cess ledger defined with valuation types Based on Quantity.
    The taxes are calculated based on the cess rate per unit defined in the stock item master.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  7. Press Esc to return to the sales invoice.
  8. As always, press Ctrl+A to save the sales voucher.

You have now recorded sales with cess on quantity.

Compensation Cess for Pan Masala and Tobacco Products

The Government of India has issued Notification No. 02/2023- Compensation Cess (Rate) dated March 31, 2023, to change the compensation cess on tobacco and pan masala products. The new notification replaces the existing ad valorem system and introduces a retail sale price (RSP) based compensation cess system.

To comply with this new system, you need to calculate the compensation cess on your tobacco and pan masala products based on their retail sale price and the applicable compensation cess rate, which can be found in the Schedule mentioned in the notification.

For instance, if you want to calculate the compensation cess on Pan Masala, you can refer to the notification to find that the GST compensation cess rate is 0.32R per unit, where R is the retail sale price of the product. You can then apply this rate to the retail sale price of your product to calculate the cess.

Illustration

To calculate the Compensation Cess on tobacco and pan masala products, you need to follow the steps outlined below:

Step 1: Understand the new notification – Notification No. 02/2023- Compensation Cess (Rate) dated March 31, 2023 has been issued to change the compensation cess on tobacco and pan masala from ad valorem to RSP based. This means that the compensation cess will now be based on the retail sale price (RSP) of the product.

Step 2: Check the compensation cess rate for the specific product – The compensation cess rate for pan masala and all unbranded/branded goods other than pan masala containing tobacco ‘gutkha’ and “Homogenised” or “reconstituted” tobacco, bearing a brand name, has been changed. You can find the updated compensation cess rate in the Schedule mentioned in the notification.

Step 3: Calculate the Compensation Cess – To calculate the compensation cess on a specific product, you need to know its retail sale price and the applicable compensation cess rate.

For example, let’s calculate the compensation cess on Pan Masala using the details mentioned in the notification:

The rate of GST compensation cess is 0.32R per unit
The retail sale price of one unit (pouch) of Pan Masala is Rs. 10
So, the GST compensation cess leviable would be 0.32R = 0.32*10 = Rs. 3.2 per unit (pouch)

If Pan Masala is sold in cartons/boxes, you can follow one of the below calculation methods to configure the cess in the item master:

Method 1: Cess per unit calculation

If the MRP of the unit is Rs. 13
Each box contains 144 units (1 box = 144 units)
The government cess rate is 0.43 per pouch
In the item master configuration, the cess per unit can be mentioned as 13*0.43 = 5.59

Method 2: Cess on carton/box calculation

If the MRP of 1 box (which contains 144 units) is Rs. 1872 (13Rs*144units)
The government cess rate is 0.43 per pouch
In the item master configuration, the cess per carton/box can be mentioned as 1872*0.43 = 804.96

Please note that this new notification will come into force on the 1st day of April, 2023, and you must ensure that your item master is updated accordingly.

Compensation Cess per unit calculation in TallyPrime

You can configure a stock item with compensation cess and record an invoice.

  1. Configure the stock item for Cess calculation
    1. In the Stock Item Alteration screen, update the HSN/SAC & Related Details and GST Rate & Related Details.
    2. Select Cess Valuation Type as Based on Quantity.
    3. Under Cess Rate, enter cess rate per unit.
      Here in this example, cess is defined on 1box of Pan Masala containing 144 pouches
        – If the MRP of 1 box (which contains 144 units) is Rs. 1872 (13Rs*144units)
        – The government cess rate is 0.43 per pouch
        – The cess per carton/box can be mentioned as 1872*0.43 = 804.96
      Compensation-cess
    4. Press Ctrl+A to accept the screen. 

      If your selling unit of Pan Masala is 1 pouch then you can mention Cess as 5.59 / unit as explained below
      – If the MRP of the unit is Rs. 13
      – The government cess rate is 0.43 per pouch
      – The cess per unit can be mentioned as 13*0.43 = 5.59

  2. Open the sales voucher in Item Invoice mode.
    1. Press Alt+G (Go To) > Create Voucher > press F8 (Sales).
      Alternatively, Gateway of Tally > Vouchers > press F8 (Sales).
    2. Press Ctrl+H (Change Mode) > select Item Invoice.
  3. Enter the Party A/c nameSales ledger and stock item details.
  4. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  5. Select the cess ledgers defined with valuation types Based on Quantity.
    The taxes are calculated based on the cess rate per unit defined in the stock item master.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis.
    If you are on TallyPrime Release 1.1.3 or earlier, follow the step:
    To view the GST – Tax Analysis screen, press Ctrl+I (More Details) > type or select GST – Tax Analysis > and press Enter.
  7. Press Alt+F5 (Detailed) to view the detailed mode of tax break-up for the stock item selected in the invoice. The GST – Tax Analysis screen appears as shown below:
  8. Press Esc to return to the sales invoice.
  9. Accept the screen. As always, you can press Ctrl+A to save.

Print cess in the sales invoice

  1. On the sales voucher, press Ctrl+P to open the Voucher Printing screen.
    • Press C (Configure) for print configurations screen
    • Show GST Analysis – Set this option to Yes.
  2. Press Esc and press P (Print) to print. The printout of the sales invoice appears as shown below, with the cess values.
    Printing cess on quantity and value

GST Sales of Goods and Services with Item Level Discount

While selling goods or services, you might want to give discounts to your customers as part of your business policy. Such discounts can be either item level-wise or even on the total amount. In both cases, the tax is calculated after deducting the discount amount.

In this section

Sale of goods with discount

You can record the sale of goods after giving a discount at the item level and the tax gets calculated after considering the discount.

  1. While creating the discount ledger under Indirect Expenses, ensure the Type of Ledger is selected as Discount.
    Creation of discount ledger
  2. While recording sales of goods with the discount ledger.
    1. In the sales voucher, press F12 (Configure) > set Provide Cash/Trade Discount to Yes.
    2. Enter the stock item details along with Quantity and Rate.
    3. Below each stock item, in the Discount field, enter the discount rate or the discount amount applicable for the stock item.
    4. Select the Discount ledger. The total discount amount is displayed.

      You can alter the total discount amount if required. For example, if you want to allow a maximum discount of Rs 50,000 on a bill, and your total discount amount exceeds this amount, you can alter the final amount. The discount will be apportioned according to the discount given at the item level.

  3. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  4. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for discount on sale of goods
  5. Press Esc to return to the sales invoice.
    Recording transaction with discount
  6. As always, press Ctrl+A to save the sales voucher.
  7. Print the invoice.
    1. In the sales voucher, press Ctrl+P.
      Alternatively, press Alt+P (Print) > Current.
    2. Press I (Preview) to preview the invoice before printing or press P (Print) to print the voucher.
      Printing sale of goods with discount

You have recorded a sales voucher for the sale of goods with a discount.

Sales of services with discount

You can record the sale of services after giving a discount and the tax gets calculated after considering the discount.

  1. Create a discount ledger for services under Indirect Expenses.
    1. In the Ledger Alteration screen, set Include in assessable value calculation to GST.
    2. Select Services in the Appropriate to field.
      There are 3 options in Include in assessable value calculation for Appropriation.
      • Goods
      • Goods and Services
      • Service.
        When you select Services and Goods and Services, the Method of calculation is automatically set to Based on Value.However, for Goods, the user needs to choose the Method of calculation.
        • Based on Quantity: Apportions the expense value based on quantity of the stock item. More quantity means more share of expense value.
        • Based on Value: Apportions the expense value based on value of each stock item/service ledger more value means more share of expense value.Creation of discount on service ledger
    3. As always, press Ctrl+A to save the ledger creation.
  2. While recording sales of services with the discount ledger.

    1. Select the service ledger and enter the Amount.
    2. Select the Discount ledger and enter the discount in percentage with a minus sign.
      The discount gets calculated under Amount.
  3. Select the appropriate GST ledgers. CGST and SGST for local sales and IGST for interstate sales.
  4. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for discount on sale of services
  5. Press Esc to return to the sales invoice.
    Recording transaction with discount on services
  6. As always, press Ctrl+A to save the sales voucher.
  7. Print the invoice.
    1. In the sales voucher, press Ctrl+P.
      Alternatively, press Alt+P (Print) > Current.
    2. Press I (Preview) to preview the invoice before printing or press P (Print) to print the voucher.
      Printing sale of services with discount

You have recorded a sales voucher for the sale of services with a discount.

Invoices with MRP Inclusive of Tax

MRP stands for Maximum Retail Price and it is the highest price that can be charged for a product as decided by the manufacturer. If MRP is listed as Inclusive of Tax, it means the price of the product already includes the applicable taxes and the customer does not have to pay the tax separately.  In your business, you can supply goods at MRP Inclusive of Tax by creating a voucher class. Once you have created or altered a voucher class with the necessary configurations, you can record sales with MRP Inclusive of Tax in TallyPrime. When you select the voucher class, there is no need to select the tax ledgers separately.

In this section

Create/Alter voucher class for MRP inclusive of tax

In order to record the supply of goods at MRP Inclusive of Tax, you need to create the voucher class in the Sales Voucher type.

  1. In the Voucher Type Alteration screen of Sales, press Enter on the Name of Class and add the voucher class name. 
    Creation of voucher class for all tax
  2. Configure the Default Accounting Allocations.
    1. Set the option Enable default accounting allocations to Yes.
      • Enable Set/Alter Default Accounting Entries. The Default Accounting Entries screen appears.
      • Press F12 (Configure) > enable Allow to change default Accounting Allocation method.
      • Press Ctrl+A to save.
    2. Under Adjust Allocation Difference (if any) to, select First Ledger and press Enter.
      Once you set First Ledger under Adjust Allocation different (if any) to, you cannot apply Rounding Method to the First Ledger as the adjustment is already set to it.
    3. Set up the sales and tax ledger with percentages.
      Voucher class adjust allocation
    4. Press Ctrl+A to save the voucher class.

      The change in configuration as demonstrated in the above procedure will not be applicable to the transactions you have already recorded. However, you can correct the tax calculation manually in the transactions.

Configure accounting allocations in the stock item master

Before you start recording the sales voucher, you need to configure the accounting allocation in the stock item master.

  1. Open the stock item alteration screen.
    1. Enable Set/modify default ledgers for invoicing.
      If this option is not visible, press F12 (Configure) > enable Set default Accounting Allocations for Stock Items (in Invoice Mode).
      Configuration for stock item master
    2. In the Default Accounting Allocations for Sales Invoice screen, press F12 (Configure) > set Allow to change default Accounting Allocation method to Yes and press Enter.
      Configuration
    3. Under Adjust Allocation difference (if any) to, select First Ledger and press Enter.
      Once you set First Ledger under Adjust Allocation different (if any) to, you cannot apply Rounding Method to the First Ledger as the adjustment is already set to it.
    4. Set up the sales and tax ledger with percentages.
      stock master adjust allocation
    5. Press Ctrl+A to save the voucher class.

Record sales with MRP inclusive of GST

After the voucher class is created and the stock item master is configured, you can record the sales with MRP Inclusive of GST after selecting the voucher class in the sales voucher.

  1. Record the sales voucher with the Voucher Class created.
    1. In the sales voucher, select the Voucher Class.
    2. Provide the stock item details along with Quantity and Rate.
      There is no need to select the GST ledgers.
      Recording transaction with voucher class
  2. To view the tax calculation, open the invoice in alteration mode.
    Press Enter on the Amount column.
    You can view the auto-calculated value for the default ledgers along with the tax breakup.
    Accounting details for stock item

You now know how to create voucher class, make configurations for accounting allocations and finally record the sales.

Sales of Stock Items with Slab-wise Tax Rates

In your business, you might be selling goods whose tax rate depends on the rate of the goods. In such cases, you can set up a slab rate and define the slab-wise item rate along with the tax rate for each slab. Once you start recording the transaction, depending on the rate you select for the item, the tax gets calculated based on the rate defined in the slab rate. You can create slab rates based on MRP or item rates even before recording the transactions.

You can also choose the applicability of the slab rate based on MRP in the item master. For example, the tax rate of 5% is applicable to an item if the price is less than Rs.500, and 12% when the price is Rs.500 or above. If you have two different prices for the item—the MRP and the rate manually entered in the invoice, you can choose to apply the slab rate based on the MRP or the item rate. TallyPrime allows you to sell stock items at a slab rate based on MRP, item rate, and price range.

In this section

Slab rate based on MRP

The MRP is the highest price at which a product is sold in the market. The MRP of a stock item is considered for GST rate calculation when slab rates are applicable. However, the tax amount still gets calculated on the selling price of the item. In the highlighted case, the rate per unit is the MRP of Rs 550, which appears in the slab range of Rs. 500 and above. Therefore, GST gets calculated at 12%. The slab rate needs to be set in the stock item master.

  1. Set up the slab rates based on MRP rates in the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Update the MRP Rate per unit.
    3. Set the option GST applicability to Applicable.
    4. Under GST Rate & Related Details, select Specify Slab-Based Rates.
      Stock item with slab based rate
    5. In the Slab-Based Tax Rate Details screen, update the slab rates.
      Press F12 (Configure) and enable Consider MRP while calculating slab-based tax rate.
      Slab rate based on MRP
    6. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the stock item, and enter the MRP/Marginal price and Quantity.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for supply with slab rate based on MRP
  6. Press Esc to return to the sales invoice
    Recording Supply with Slab rate based on MRP
  7. Press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. Set up the slab rates based on MRP rates in the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option GST applicability to Applicable.
    3. Enable Set/Alter GST Details to update the GST and HSN/SAC details.
    4. Select the Calculation type as On Item Rate.
    5. On the Tax on Item Rates screen, update the slab-based tax rate details.
    6. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Set Consider MRP while calculating slab-based tax rate as Yes.
      • Update the MRP Rate per unit.
    7. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the stock item, and enter the MRP/Marginal price and Quantity.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  6. Press Esc to return to the sales invoice
  7. Press Ctrl+A to save the sales voucher.

Slab rate based on Item rate

Item rate is the price at which a particular item is offered for sale. At the time of creating the stock item, you can set up the slab rate based on the item rate and set up the tax rate against the item rates. While recording the sales voucher the tax is calculated as per the tax rate defined for the item rate.

  1. Set up the slab rates based on item rates in the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Update the MRP Rate per unit.
    3. Set the option GST applicability to Applicable.
    4. Under GST Rate & Related Details, select Specify Slab-Based Rates.
      Stock item with slab based rate with item rate
    5. In the Slab-Based Tax Rate Details screen, update the slab rates.
      Ensure Consider MRP while calculating slab-based tax rate is set to No.
      Slab rate based on Item rate
    6. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the stock item, and enter the MRP/Marginal price and Quantity.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for supply with slab rate based on item rate
  6. Press Esc to return to the sales invoice.
    Recording Supply with Slab rate based on Item rate
  7. Press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. Set up the slab rates based on MRP rates in the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option GST applicability to Applicable.
    3. Enable Set/Alter GST Details to update the GST and HSN/SAC details.
    4. Select the Calculation type as On Item Rate.
    5. On the Tax on Item Rates screen, update the slab-based tax rate details.
    6. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Set Consider MRP while calculating slab-based tax rate as No.
      • Update the MRP Rate per unit.
    7. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the stock item, and enter the MRP/Marginal price and Quantity.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  6. Press Esc to return to the sales invoice
  7. Press Ctrl+A to save the sales voucher.

Slab rate based on price range – same item of different price per unit

You can set the slab rate based on the price range. 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. The tax gets calculated as per the slab rate set for the different price ranges. 

  1. Set up the slab rates based on the price range of the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Update the MRP Rate per unit.
    3. Set the option GST applicability to Applicable.
    4. Under GST Rate & Related Details, select Specify Slab-Based Rates.
    5. In the Slab-Based Tax Rate Details screen, update the slab rates.
    6. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the same stock item twice and enter the Quantity.
    Enter different Rate per unit for both stock items.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for supply of same item with different price
  6. Press Esc to return to the sales invoice.
    Sales voucher for slab rate based on price range
  7. Press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. Set up the slab rates based on MRP rates in the stock item.
    1. In the Stock Item Alteration screen, press F12 (Configure) > set Provide MRP Details to Yes.
    2. Set the option GST applicability to Applicable.
    3. Enable Set/Alter GST Details to update the GST and HSN/SAC details.
    4. Select the Calculation type as On Item Rate.
    5. On the Tax on Item Rates screen, update the slab-based tax rate details.
    6. Set the option Set/Alter MRP details to Yes.
      • Set Allow MRP modification in voucher as Yes.
      • Set Consider MRP while calculating slab-based tax rate as No.
      • Update the MRP Rate per unit.
    7. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher, press F12 (Configure) > set Modify MRP in vouchers to Yes.
  3. Select the same stock item twice and enter the Quantity.
    Enter different Rate per unit for both stock items.
  4. Select the appropriate tax ledgers.
  5. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  6. Press Esc to return to the sales invoice
  7. Press Ctrl+A to save the sales voucher.

Tax rate calculation for change in slab rate

If the slab rates of stock items change due to any applicable discounts, you can override the tax rates at the transaction level.

  1. While recording the sales voucher, press F12 (Configure) > set Modify GST & HSN/SAC related details to Yes.
  2. Select the Party A/c name and the Sales ledger.
  3. Select the stock item, and enter quantity and rate.
  4. In the GST Rate and Related Details screen, enter the tax rate applicable based on the slab rate of the stock item.
  5. Select the appropriate tax ledgers.
  6. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for override tax rate for slab based supply
  7. Press Esc to return to the sales invoice.
    Tax rate calculation for change in slab rate
  8. Press Ctrl+A to save the sales voucher.

If you are in TallyPrime Rel 2.1 or earlier, click  here.

  1. While recording the sales voucher, press F12 (Configure), 
    1. Set Modify Tax Rate details of GST to Yes.
    2. Set Select common Ledger Account for Item Allocation to Yes.
  2. Select the Party A/c name and the Sales ledger.
  3. Select the stock item, and enter quantity and rate.
  4. In the Tax Classification Details screen that appears after selecting the stock item, press F12 (Configure) > set the option Override tax rate to Yes, and press Enter.
  5. In the GST Details screen, enter the tax rate applicable based on the slab rate of the stock item.
  6. Select the appropriate tax ledgers.
  7. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
  8. Press Esc to return to the sales invoice.
  9. Press Ctrl+A to save the sales voucher.

Slab rate with apportioned additional ledger value/Calculation based on including expenses

While recording the sale of goods, if there is any additional ledger then the slab rate can be set by including the additional ledger. Hence the GST gets calculated after considering the additional ledger value.

  1. Provide slab rate in the stock item.
    1. In the Stock Item Alteration screen, under GST Rate & Related Details, select Specify Slab-Based Rates.
    2. In the Slab-Based Tax Rate Details screen, update the slab rates.
      Press F12 (Configure) and enable Include GST expenses/incomes to calculate the slab-based tax rate.
      Slab rate for apportioned expenses
    3. As always, press Ctrl+A to accept the stock item.
      If you are on Rel 2.1 and earlier, click here.
      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.
  2. While recording the sales voucher with the additional ledger.
    1. Select the stock item, and enter the quantity and rate.
    2. Select the additional ledger enabled for apportionment based on quantity, and enter the amount.
      Defining additional ledger to be apportioned based on quantity
  3. Select the appropriate GST ledgers. The taxes are calculated on the slab rate arrived at by considering the value of apportioned additional ledger to the stock item rate.
  4. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for additional ledger apportioned
  5. Press Esc to return to the sales invoice.
    Recording transaction with additional ledger
  6. Press Ctrl+A to save the sales voucher.

Slab rate without apportioned additional ledger value/Exclude apportion value

While recording the sale of goods, if there is any additional ledger and you don’t want to include that value while the slab rate is set, you can still record the sales voucher in TallyPrime. In such a case, the GST gets calculated after excluding the additional ledger value.

  1. Provide slab rate in the stock item.
    1. In the Stock Item Alteration screen, under GST Rate & Related Details, select Specify Slab-Based Rates.
    2. In the Slab-Based Tax Rate Details screen, update the slab rates.
      Press F12 (Configure) and disable Include GST expenses/incomes to calculate slab-based tax rate.
      If you are on Rel 2.1 and earlier, you can see the option as Consider additional expense/income ledger for slab rate calculation.
    3. As always, press Ctrl+A to accept the stock item.
  2. While recording the sales voucher with the additional ledger.
    1. Select the stock item, and enter the quantity and rate.
    2. Select the additional ledger enabled for apportionment based on quantity, and enter the amount.
  3. Select the appropriate GST ledgers. The taxes are calculated on the slab rate arrived at by excluding the value of apportioned additional ledger.
  4. To view the Tax Analysis, press Ctrl+O (Related Reports) > GST Tax Analysis. Press Alt+F5 (Detailed) to view the detailed breakup of the tax.
    GST Analysis for additional ledger without apportioned
  5. Press Esc to return to the sales invoice.
    Recording transaction with additional ledger without apportioned
  6. Press Ctrl+A to save the sales voucher.
Post a Comment

Is this information useful?
YesNo
Helpful?