Formula to arrive at tax value when price is inclusive of tax

Formula to arrive at tax value when price is inclusive of tax

Product version:

6.5 Update 6 or 6.6


Problem Statement:

Formula to arrive at tax value when price is inclusive of tax

Proposed Solution:


The tax value calculation when price is inclusive of GST is:

Tax amount = Value inclusive of tax X tax rate ÷ (100+ tax rate)

Let us discuss few examples to understand this:

Mr. Ram in Karnataka supplies a television to Mr. Shyam in Maharashtra. The television’s price inclusive of GST is Rs. 50,000. Mr. Ram wants to arrive at the value of tax.Here, GST rate applicable to television is 18%. Since this is an interstate supply, type of tax applicable is IGST.

Let us arrive at the value of IGST in this case: 

Value inclusive of tax= Rs. 50,000 

Tax rate= 18 

Hence, IGST amount= 50,000*18/118= Rs. 7627


Steps if any:

NA


Constraints/Scenarios:

NA


    • Related Articles

    • Tax number field locked

      Environment: iVend 6.6 Patch: 7989 Problem Description: Tax number field locked Scenario: Unable to edit the Tax number field in customer Master, even though validation rule in not set for the particular field. Solution: 1) Go to Retail Profile >> ...

    • Unable to provide discount more than 90% using Bonus Buy for Tax Inclusive items

      ********************************** Internal to citixsys ***************************************************** Problem Statement Unable to provide discount more than 90% using Bonus Buy for Tax Inclusive items Issue details Please consider below ...

    • Item marked as Inclusive-Tax with the sale tax code but for special delegates tax must be removed.

      Environment : iVend 6.6 with SAP B1 Problem Statement : Item marked as Inclusive-Tax with the sale tax code but for special delegates tax must be removed. Resolution/Work Around : In Customer Master, we have the option Tax-Free for special customers. ...

    • Price Lists and Special Price Lists

      Price Lists and Special Price Lists iVend Retail provides a comprehensive and multifaceted pricing engine. There is a great array of flexible features that can add a depth of highly configurable methods for setting prices that can be used at the ...

    • How value in price column gets populated

      ********* Article is for Partners /CXS reference only ******** Environment: iVend 6.5 update onward Query: Query was raised related to details of whereabouts of the Price column in invinventryitem table Scenario: The field Price in the ...