Pay Bill
"Confused about GST calculations? Learn the GST calculation formula with easy examples and understand how CGST, SGST, and IGST are calculated in India."
Published: 13 May 2026
Business owners and freelancers working with invoices and consumers wanting to verify tax amounts need to know how GST is calculated. A wrong figure on a single invoice can impact pricing, invoicing, and tax reporting.
This guide explains the GST calculation formula, how CGST and SGST work on state-level transactions, and how to set up the calculation in Excel in detail.
GST is a percentage-based tax charged on the price of goods or services. The general GST calculation formula is:
GST = (Original Price x GST Rate) / 100
Total Price = Original Price + GST Amount
It also runs GST across three slabs: 5%, 18%, and 40% (effective from September 22, 2025). Below are the clear examples based on each slab.
A grocery store sells packaged food worth ₹2,000. The applicable GST rate is 5%.
GST Amount = (2,000 x 5) / 100 = ₹100
Total Invoice Amount = 2,000 + 100 = ₹2,100
A freelance consultant charges ₹10,000 for a project. Professional services attract 18% GST.
GST Amount = (10,000 x 18) / 100 = ₹1,800
Total Invoice Amount = 10,000 + 1,800 = ₹11,800
A shop sells an air conditioner priced at ₹35,000. The GST rate for this category is 28%.
GST Amount = (35,000 x 40) / 100 = ₹14,000
Total Invoice Amount = 35,000 + 14,000 = ₹49,000
The steps below clearly mentions on how to calculate GST manually
Start with the price before tax. This is the amount on which GST is applied. If a discount is allowed before tax, reduce it first.
India runs GST across four slabs: 5%, 18%, and 40%. Some items attract 0%. The rate for any product depends entirely on its category as defined by the GST Council.
Multiply the taxable value by the GST rate and divide by 100. For example:
₹12,000 × 18 ÷ 100 = ₹2,160
This means the GST amount is ₹2,160. The total invoice value is ₹14,160. That is the full working of the GST calculation formula in a manual bill.
Once GST is calculated, add it to the taxable amount to get the invoice total. This helps buyers see the final payable amount clearly and helps sellers maintain proper records.
When a sale happens within one state, the GST collected does not go to a single account. Half goes to the Central Government as CGST, and the other half goes to the State Government as SGST. Cross-state sales are different here; the full rate applies as IGST(international goods and services tax), and the Center collects it entirely.
Example: A ₹5,000 product sold within the same state at 18%:
Follow the steps below to calculate GST in Excel
Open a blank Excel sheet and label the first row. Keep it simple: Column A is for the item name, Column B for the base price, C for the GST rate. Column D will hold the GST amount, E for the invoice total, and F and G for CGST and SGST, respectively.
In D2, type =B2*C2/100. The formula picks the base price and rate from Columns B and C and returns the tax figure. Move to E2 and type =B2+D2 for the invoice total. Now go to F2 and type =D2/2, then do the same in G2. For any sale within the same state, the GST splits equally between CGST and SGST, so both columns will carry identical values.
Select D2 through G2. Drag the selection down to cover all the rows needed. Add the item name in Column A, base price in Column B, and GST rate in Column C for each row. Columns D, E, F, and G fill in automatically. The GST amount, invoice total, CGST, and SGST are calculated for every item in the sheet.
Follow the steps below to calculate GST from the total amount using the GST amount formula.
Original Price = (Total Amount x 100) / (100 + GST Rate)
For example, a receipt shows ₹1,180, and the GST rate is 18%.
Original Price = (1,180 x 100) / 118 = ₹1,000
GST Paid = Total Amount - Original Price
GST Paid = 1,180 - 1,000 = ₹180
In this example, ₹1,000 was the actual product price, and ₹180 was the GST included in the total.
Understanding the GST calculation formula prevents billing errors. Whether the task is adding tax to a quoted price, separating CGST and SGST for a state-level invoice, or finding the tax within a total bill, each situation has a clear method, and the numbers are not complicated once the right approach is applied.
My Mudra helps business owners manage the financial side of running a business. With access to over 70 lenders across India, the platform covers personal loans and business loans through a fully digital process. Eligibility checks are quick, documentation is minimal, and approvals move faster than most traditional loan processes. For business owners who need credit alongside managing their GST obligations, My Mudra is worth exploring.
To remember the GST calculation formula, use taxable value × GST rate ÷ 100. Then add the result to the base price to get the total amount. That is the simplest working method for most invoices.
Yes, the calculation method is the same, but the applicable GST rate may differ based on classification. The rate should always be checked before applying tax.
Yes. Excel is useful for handling many entries at once, especially when you need to calculate tax, totals, or reverse tax from invoice values.
Use the reverse method to remove tax from the total amount first, then subtract the base value from the total. This gives the GST amount accurately.
It refers to the reverse calculation used to separate the tax from a price that already includes GST. This comes up often in retail billing, supplier quotations, and e-commerce orders where the listed price is the final amount.
💬 Comments
Leave a comment or ask a question!
Please Enter Your Name
Please Enter Your Email
Please Enter Your Phone
Please Write Your Comment