{"id":69800,"date":"2025-04-08T16:10:43","date_gmt":"2025-04-08T10:40:43","guid":{"rendered":"https:\/\/piceapp.com\/blogs\/?p=69800"},"modified":"2025-04-08T16:10:48","modified_gmt":"2025-04-08T10:40:48","slug":"reverse-gst-calculation-formula-in-excel","status":"publish","type":"post","link":"https:\/\/piceapp.com\/blogs\/reverse-gst-calculation-formula-in-excel\/","title":{"rendered":"Reverse GST Calculation Formula in Excel: Step-by-step Guide"},"content":{"rendered":"\n<div class=\"wp-block-group has-background\" style=\"background-color:#f2f5f9\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h3 class=\"wp-block-heading\"><strong>Key Takeaways<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reverse GST calculation helps determine the base price from a GST-inclusive amount.<\/li>\n\n\n\n<li>Use the formula: GST-inclusive price \u00f7 (1 + GST rate\/100) to find the original price.<\/li>\n\n\n\n<li>Excel simplifies reverse GST by automating price, tax, and base amount calculations.<\/li>\n\n\n\n<li>Common mistakes include using the forward formula and ignoring CGST\/SGST breakdowns.<\/li>\n\n\n\n<li>The Pice Reverse GST Calculator ensures fast, accurate, and India-specific GST breakdowns.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p>If you are someone who wants to figure out the price of an item before the application of tax, it can be very helpful to know how to reverse calculate GST. By using a <strong>reverse GST calculation formula in Excel<\/strong>, one can easily calculate the original price by referring to the total GST-inclusive amount. <\/p>\n\n\n\n<p>This facility allows businesses and business owners indulging in<a href=\"https:\/\/smartasset.com\/financial-advisor\/financial-planning-explained\" target=\"_blank\" rel=\"noopener\"> financial planning,<\/a> to keep a check of their pricing, helping individuals confirm the price that is inclusive of tax.<\/p>\n\n\n\n<p>This blog shall dive deeper into the application of the<strong> reverse GST calculation formula in Excel<\/strong>, and other associated details.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What is Reverse GST Calculation?<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/What-is-Reverse-GST-Calculation.png\" alt=\"What is Reverse GST Calculation?\" class=\"wp-image-69848\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/What-is-Reverse-GST-Calculation.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/What-is-Reverse-GST-Calculation-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/What-is-Reverse-GST-Calculation-150x84.png 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/What-is-Reverse-GST-Calculation-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>GST reverse calculation is also commonly known as GST element calculation. For beginners, it is important to understand what Reverse GST calculation means. It refers to the <a href=\"https:\/\/www.coursehorse.com\/blog\/learn\/finance\/understanding-the-differences-between-manual,-automatic,-and-partial-calculation-modes-in-excel\" target=\"_blank\" rel=\"noopener\">manual calculation<\/a> of the GST tax component of a whole amount that results (inclusive of the tax amount).<\/p>\n\n\n\n<p>Here is an example of a scenario where reverse GST calculation may be required. Say that you are informed of the price of a product\/service, quoted as &#8216;inclusive of GST\u2019. This means that the price of the item\/service already includes the tax value. In such a case, you would probably want to know the GST amount separately. So, you will be required to reverse-calculate the GST amount under this circumstance.<\/p>\n\n\n\n<p>The applicable tax rate, in this case, is usually included in the bill, which is offered to the consumer at the <a href=\"https:\/\/www.shopify.com\/blog\/what-is-retail\" target=\"_blank\" rel=\"noopener\">retail store,<\/a> the latter needing to submit the GST amount to the central government. Now, there may arise a scenario where the buyer\/recipient shall be required to pay the tax amount under the \u2018reverse charge mechanism\u2019. <\/p>\n\n\n\n<p>The vendors may have raised the respective invoices without the applicable tax rate, tagged as &#8216;tax is payable under RCM by the recipient&#8217;. It is also necessary in the case of accurate input Tax Credit (ITC) claiming, tax filing, and invoicing.<\/p>\n\n\n\n<p>These purchasers should first figure out the GST\/self-invoice, and deposit it with the government, in case the vendor is not registered under the GST law. This is again, where the knowledge of reverse GST calculation comes into play!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>The Reverse GST Calculation Formula Explained<\/strong><\/h2>\n\n\n\n<p>This section discusses the formulas that can be applied for the reverse calculation of GST.<\/p>\n\n\n\n<p>Find the price excluding GST first by using this formula:<\/p>\n\n\n\n<p>(GST inclusive price)\/(1+(GST rate\/100)) = GST exclusive price<\/p>\n\n\n\n<p>The next and final step would be to find the GST amount, by using the GST reverse calculation formula below:<\/p>\n\n\n\n<p>GST Inclusive Price \u2212 GST Exclusive Price = GST Amount<\/p>\n\n\n\n<p>The formulas shall help break down the gross amount into its components, specifying the basic amount and the GST value.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Use the Reverse GST Calculation Formula in Excel<\/strong><\/h2>\n\n\n\n<p>Here is a simple guide of the steps to use the reverse GST calculation formula in Excel:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"GST REVERSE CALCULATION  IN  MS Excel\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/4ZooRy2JrdA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><strong>Step 1<\/strong>: Apply the Formula to reverse calculate GST. For instance, if the total amount is \u20b9118 with an applied 18% GST, you must type in =118 \/ 1.18&#8242; in Excel. This will help you find the original cost price, which is \u20b9100.<\/p>\n\n\n\n<p><strong>Step 2<\/strong>: Next, you have to extract the GST amount by finding out the base price. So, calculate the GST amount by subtracting the base price from the entire amount. For instance, \u20b9118 (post-cost price) &#8211; \u20b9100 (base price) = \u20b918.<\/p>\n\n\n\n<p><strong>Step 3<\/strong>: Finally, you have to implement the same in Excel. Feel free to set up the Excel sheet with separate columns for the total price, base price, GST rate, and GST cost. This shall make the process <a href=\"https:\/\/automattic.com\/\" target=\"_blank\" rel=\"noopener\">automatic<\/a> as well as easy.<\/p>\n\n\n\n<p>The above-mentioned steps show exactly how the reverse calculations help with keeping track of prices, and following tax rules in the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Download the spreadsheet and follow along with the tutorial on Reverse Sales Tax Calculator in Excel\u00a0<\/h2>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-111b23b3-a549-4db6-9d74-f28746500866\" href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Reverse-Sales-Tax-Calculator-in-Excel.xlsx\">Reverse-Sales-Tax-Calculator-in-Excel<\/a><a href=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Reverse-Sales-Tax-Calculator-in-Excel.xlsx\" class=\"wp-block-file__button wp-element-button\" aria-describedby=\"wp-block-file--media-111b23b3-a549-4db6-9d74-f28746500866\" download>Download<\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Reverse GST Calculation in India<\/strong><\/h2>\n\n\n\n<p>To properly understand the concept of reverse GST calculation, let us take an example. The gross amount that shall be paid, inclusive of GST, is Rs.1,300. The applicable GST rate is 12%. Consider an interstate transaction in this scenario. So, here\u2019s what the accurate calculation shall look like:<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Gross Value<\/strong>: Rs.1,300<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>GST<\/strong>: 12%<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Divisor<\/strong>: 1.12 (since 1 + 0.12)<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Base Value or Actual Price<\/strong>: Rs.1,160.71 (Rs.1,300 \/ 1.12)<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Total GST Amount (IGST\/Integrated tax)<\/strong>: Rs.139.29 (Rs.1,300 &#8211; Rs.1,160.71)<\/p>\n\n\n\n<p>India, in particular, has four GST slabs. The slabs include 5%, 12%, 18%, as well as 28%. The reverse GST calculation formula can be applied to practical scenarios in India, like in the case of:<\/p>\n\n\n\n<p>Example 1: Restaurant Bill<\/p>\n\n\n\n<p>\u25cf\u00a0Total Bill: \u20b92,360 (including 18% GST).<\/p>\n\n\n\n<p>\u25cf\u00a0Base Price = \u20b92,360 \/ 1.18 = \u20b92,000<\/p>\n\n\n\n<p>\u25cf\u00a0GST = \u20b9360<\/p>\n\n\n\n<p>Example 2: Car Purchase\/ Luxury Items Purchase<\/p>\n\n\n\n<p>\u25cf\u00a0Final Price: \u20b925,60,000 (including 28% GST)<\/p>\n\n\n\n<p>\u25cf\u00a0Base Price = \u20b925,60,000 \/ 1.28 = \u20b920,00,000<\/p>\n\n\n\n<p>\u25cf\u00a0GST = \u20b95,60,000<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"171\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation-1024x171.png\" alt=\"Calculation\n\" class=\"wp-image-69831\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation-1024x171.png 1024w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation-300x50.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation-150x25.png 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation-768x128.png 768w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Calculation.png 1257w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Mistakes in Reverse GST Calculation &amp; Ways to Avoid Them<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"506\" src=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Common-Mistakes-in-Reverse-GST-Calculation-Ways-to-Avoid-Them.png\" alt=\"Common Mistakes in Reverse GST Calculation &amp; Ways to Avoid Them\" class=\"wp-image-69850\" title=\"\" srcset=\"https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Common-Mistakes-in-Reverse-GST-Calculation-Ways-to-Avoid-Them.png 900w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Common-Mistakes-in-Reverse-GST-Calculation-Ways-to-Avoid-Them-300x169.png 300w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Common-Mistakes-in-Reverse-GST-Calculation-Ways-to-Avoid-Them-150x84.png 150w, https:\/\/piceapp.com\/blogs\/wp-content\/uploads\/2025\/04\/Common-Mistakes-in-Reverse-GST-Calculation-Ways-to-Avoid-Them-768x432.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>Following are some common mistakes made during reverse GST calculation:<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Composite Tax Rates Are Ignored<\/strong>: Certain items mention the combined CGST + SGST value. It is crucial to check for the breakdown.<\/p>\n\n\n\n<p>\u25cf <strong>Forward Formula Usage<\/strong>: The Forward formula is, \u201cBase Price \u00d7 (1 + Rate) =\u00a0 Forward GST.\u201d However, the Reverse formula is different, as mentioned before.<\/p>\n\n\n\n<p>\u25cf\u00a0<strong>Errors with Rounding Off<\/strong>: Excel sheets round off decimals. However, it is important to note that GST laws require the exact values.<\/p>\n\n\n\n<p>A simple way to avoid such common reverse GST calculation mistakes is through the use of the Pice Reverse GST calculator.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why is the Pice Reverse GST Calculator Your Best Choice?<\/strong><\/h2>\n\n\n\n<p>With the Pice Reverse GST calculator, you can access instant results for the values you input. It is automatic and accurate at the same time. So, there is a much-reduced scope for any <a href=\"https:\/\/www.testquality.com\/blog\/tpost\/6tik17g0e1-why-manual-tests-are-error-prone-and-wha\" target=\"_blank\" rel=\"noopener\">manual mistake<\/a>. On top of that, you get access to India-specific rate chart support. Plus, with free access to Excel templates, make reverse GST calculation much easier for your team! Try it now and get precise results in seconds!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>By thoroughly understanding the <strong>reverse GST calculation formula in Excel<\/strong>, you can simplify your tax calculations while saving time on the other hand. By referring to the formula, that is, ((Total Amount*GST Rate)\/100) + Total Amount, easily calculate the original value of an item, before GST application. <\/p>\n\n\n\n<p>It shall, especially, be useful while dealing with invoices\/receipts that only portray the total amount of the product\/service (including GST). Thus, streamline your <a href=\"https:\/\/www.businesstoday.in\/magazine\/investment\/story\/top-10-financial-calculations-54363-2015-11-04\" target=\"_blank\" rel=\"noopener\">financial calculations<\/a> by accurately implementing the reverse GST calculation formula in Excel.<\/p>\n\n\n\n<p>Also, do you want to take precautions against possible human errors? To be extra confident and land upon accurate calculations, refer to the Pice Reverse GST Calculator readily available online!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>FAQs<\/strong><\/h3>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1744096441174\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What is Reverse GST Calculation and when is it needed?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Reverse GST calculation refers to determining the base price and the GST amount from a total price that is already inclusive of tax.<br \/>It\u2019s commonly needed when the price quoted includes GST, and you want to identify how much of it is tax. This is crucial for accurate tax filing, invoicing, and input tax credit claims. It\u2019s also helpful when dealing with unregistered vendors or reverse charge scenarios. Businesses use it to maintain transparency and control over their pricing.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1744096599102\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>How can I calculate Reverse GST using Excel?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>In Excel, you can calculate the base price using: <code>=Total Price \/ (1 + GST Rate\/100)<\/code>.<br \/>To get the GST amount, subtract the base price from the total price.<br \/>Create columns for GST rate, total price, base price, and GST amount to automate the process.<br \/>For example, for \u20b9118 at 18% GST: <code>=118\/1.18<\/code> gives \u20b9100 (base price), and \u20b918 is the GST.<br \/>Excel formulas help avoid manual errors and save time.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1744096603542\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What GST rates are commonly used in India?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>India has four primary GST slabs: <strong><strong>5%, 12%, 18%, and 28%<\/strong><\/strong>.<br \/>Each rate applies to different categories of goods and services.<br \/>For example, essential items fall under 5%, while luxury cars or high-end goods often attract 28%. It\u2019s important to know the correct rate for accurate reverse calculations.<br \/>Invoices may also reflect CGST and SGST (or IGST for interstate sales).<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1744096607997\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>What are common errors in Reverse GST Calculation and how to avoid them?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Mistaking the forward GST formula for reverse is a common slip-up.<br \/>Ignoring combined GST rates (CGST + SGST) may result in incorrect base price extraction. Rounding errors in Excel can slightly skew tax values\u2014avoid auto-rounding. Also, failing to update the tax rate can lead to miscalculations.<br \/>Using tools like the Pice Reverse GST Calculator helps reduce such risks.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1744096613398\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>Why should businesses use tools like the Pice Reverse GST Calculator?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Manual reverse calculations can be time-consuming and prone to errors.<br \/>Pice offers automatic, real-time results tailored to India\u2019s GST structure.<br \/>It supports all major GST rates, prevents common missteps, and speeds up billing processes. The calculator is especially useful for bulk invoice processing or internal audits. Plus, you can download Excel templates to standardize your workflow.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Key Takeaways If you are someone who wants to figure out the price of an item before the application of tax, it can be very helpful to know how to reverse calculate GST. By using a reverse GST calculation formula in Excel, one can easily calculate the original price by referring to the total GST-inclusive [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":69847,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-69800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gst"],"_links":{"self":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/69800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/comments?post=69800"}],"version-history":[{"count":9,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/69800\/revisions"}],"predecessor-version":[{"id":69903,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/posts\/69800\/revisions\/69903"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media\/69847"}],"wp:attachment":[{"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/media?parent=69800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/categories?post=69800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/piceapp.com\/blogs\/wp-json\/wp\/v2\/tags?post=69800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}