RMS: Tax Computation Method (To be implemented)

Modified on Thu, 6 Apr, 2023 at 5:49 PM

This document describes the change in Tax computation method in RMS and will go live on 13-April-2023

Summary:

  • Previously, we used to compute tax on per unit values. And then multiply by quantity to get total values.
  • From now on, we will be computing tax on total values, and divide by quantity to get the unit values. 
  • This is because in invoices and while sending data to Cleartax, all operations are on total values and not on per unit values. So, we should have more precision in the total values and not the per unit values.


Terminology

Name

Description

From GSTIN

The Seller GSTIN

To GSTIN

The Buyer GSTIN (required in case of B2B Transactions)

From Zip

The Seller Address Zip

To Zip

The Buyer Address Zip

Actual Selling Price Per Unit

The Per Unit price at which the item is sold(tax amount is included)

Actual Selling Price Total

The total selling price (after multiplying with quantity)

Base Selling Price Per Unit

The Per Unit Base price of the item (excluding tax amount)

Base Selling Price Total

The total base price (excluding tax amount)

Tax Amount Per Unit

The tax amount applicable on the item (per unit)

Tax Amount Total

The total tax amount

Tax Rate

The rate that is applicable for tax calculation

Input

  • The following fields are provided to RMS for tax computation

    • From GSTIN and To GSTIN

    • From Zip and To Zip

    • Line Item Details

      • Actual Selling Price Per Unit

      • Tax Rule (refer tax rule documentation)

      • Quantity

Old Tax Computation Algorithm

  • The From GSTIN and To GSTIN are compared. If they are same, then 0% tax rate is applied. 

  • Tax Rate is determined from Tax Rule.

  • The From and To Zip values are used to determine the category of sub tax values.

    • If Intra State → SGST and CGST tax is applicable

    • If Inter State → IGST tax is applicable

  • From actual selling price per unit, tax per unit is calculated

    • (actual selling price unit - (actual selling price unit/(1+(rate/100)))

  • The tax amount per unit is rounded off to 2 decimal places.

  • If it is an Interstate transaction, then IGST tax amount per unit will be the same as tax amount per unit.

  • If it is an Intra state transaction, then the tax amount per unit is divided by 2 to get the SGST and CGST tax amount per unit values. And then the tax amount per unit is re-calculated by summing up the SGST and CGST tax amounts.

  • Then base selling price per unit is calculated (actual selling price per unit - tax amount per unit).

  • And then the total values are calculated by multiplying the per unit values with quantity.

    • actual selling price total = actual selling price per unit * quantity

    • base selling price total = base selling price per unit * quantity

    • tax amount total = tax amount per unit * quantity

    • IGST total = IGST amount per unit * quantity

    • CGST total = CGST amount per unit * quantity

    • SGST total = SGST amount per unit * quantity

New Tax Computation Algorithm

  • The From GSTIN and To GSTIN are compared. If they are same, then 0% tax rate is applied. 

  • Tax Rate is determined from Tax Rule.

  • The From and To Zip values are used to determine the category of sub tax values.

    • If Intra State → SGST and CGST tax is applicable

    • If Inter State → IGST tax is applicable

  • First actual selling price total is calculated (actual selling price per unit*quantity).

  • Then the total tax amount is calculated

    • (actual selling price total - (actual selling price total/(1+(rate/100)))

  • The total tax amount is then rounded off to 2 decimal places.

  • If it is an Interstate transaction, then total IGST tax amount will be the same as total tax amount.

  • If it is an Intra state transaction, then the total tax amount is divided by 2 to get the SGST and CGST tax amount values. And then the total tax amount is re-calculated by summing up the SGST and CGST tax amounts.

  • Then base selling price total is calculated (actual selling price total - tax amount total)

  • Tax Amount per unit is calculated by dividing the total tax amount by quantity and rounding it off to 2 decimal places.

  • Base Selling Price per unit is calculated by dividing the total base selling price by quantity and rounding it off to 2 decimal places.

 

Examples

Example 1

actualSellingPricePerUnit = 1050.01

Rate = 12

quantity = 50

Old Calculation Method

intermediate tax per unit = 112.5

cgst and sgst amounts per unit = 56.25

final tax amount per unit = 56.25 + 56.25 = 112.5

base amount per unit = 937.51

final tax amount total = 5625.00

base selling price total = 46875.5

actual selling price total = 52500.5

 

New Calculation Method

actualSellingPriceTotal = 52500.5

intermediate tax total = 5625.053571 = 5625.05(rounded off)

cgst and sgst values (per unit) = 2812.525 = 2812.52(rounded off)

final tax total = 2812.52 + 2812.52 = 5625.06

base selling price total = 52500.5 - 5625.06 = 46875.44

Tax per unit = 112.5012 = 112.50 (rounded off)

Base selling price per unit = 937.5088 = 937.51(rounded off)

 

Example 2

actualSellingPricePerUnit = 488.95

Rate = 5

quantity = 380

Old Calculation Method

intermediate tax per unit = 23.28

cgst and sgst tax (per unit) = 11.64

final tax amount per unit = 23.28

base amount per unit = 465.67

tax amount total = 8846.4

base amount total = 176954.60

actual selling price total = 185801

New Calculation Method

actualSellingPriceTotal = 185801

intermediate tax total = 8847.66667 = 8847.67(rounded off)

cgst and sgst values = 4423.835 = 4423.84(rounded off)

final tax total = 4423.84 + 4423.84 = 8847.68

base selling price total = 185801 - 8847.67 = 176953.32

Tax per unit = 23.28336842 = 23.28 (rounded off)

Base selling price per unit = 465.6666316 = 465.67(rounded off)

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article