The GST calculator formula helps you compute tax amounts accurately before creating an invoice. There are two scenarios — exclusive GST (where tax is added on top of the base price) and inclusive GST (where the price already includes tax and you need to extract the base and tax separately). Both are used regularly in Indian business transactions.
By Arjun Sharma· GST & Tax Compliance Specialist···Reviewed for GST accuracy
No signup required₹3.60 Cr+ invoice value processedTrusted by 300+ businessesFree forever
Free Tool — No Login Required
Calculate GST Easily
Auto CGST/SGST/IGST split
PDF in 30 seconds
No signup needed
Free forever
What you get:
GST-compliant PDF
Shareable invoice link
UPI QR on invoice
GSTIN validation
Exclusive GST Formula (Tax Added on Top)
Use this when your quoted price is the taxable value (before GST) and you need to add GST on top. Formula: GST Amount = Taxable Value × GST Rate ÷ 100. Total Invoice Amount = Taxable Value + GST Amount. Example: A consultant quotes Rs 50,000 for a project with 18% GST. GST Amount = 50,000 × 18 ÷ 100 = Rs 9,000. Total invoice = 50,000 + 9,000 = Rs 59,000. On the invoice, show CGST = 4,500 and SGST = 4,500 (or IGST = 9,000 if interstate).
Inclusive GST Formula (Tax Embedded in Price)
Use this when the price already includes GST and you need to find the taxable base and the tax amount separately. Formula: Taxable Value = Total Amount ÷ (1 + GST Rate ÷ 100). GST Amount = Total Amount − Taxable Value. Example: A product is sold at Rs 1,180 inclusive of 18% GST. Taxable Value = 1,180 ÷ 1.18 = Rs 1,000. GST Amount = 1,180 − 1,000 = Rs 180. Split as CGST Rs 90 and SGST Rs 90 for intra-state.
Skip the manual work
Use Free GST Calculator
Instead of manually formatting invoices in Excel, generate GST-compliant invoices instantly — automatic CGST, SGST & IGST calculation, PDF download, and shareable link.
For intra-state supplies (seller and buyer in the same state), the GST amount is split equally between CGST and SGST. Each component is exactly half the total GST rate. At 18%: CGST = 9% and SGST = 9%. At 12%: CGST = 6% and SGST = 6%. At 5%: CGST = 2.5% and SGST = 2.5%. For inter-state supplies, do not split — show only IGST at the full rate. Example: Invoice for Rs 50,000 at 18% inter-state → IGST = Rs 9,000. Same invoice intra-state → CGST = Rs 4,500, SGST = Rs 4,500.
Why Correct GST Calculation Matters
A calculation error on your invoice — even by a few rupees — creates a mismatch when your buyer files their GSTR-2A and tries to claim ITC. The GST portal matches every invoice amount against what you reported in GSTR-1. Any discrepancy leads to notices and potential ITC denial for your client. Using a validated GST calculator or invoice generator eliminates rounding errors and ensures every CGST, SGST, or IGST figure is precise. For businesses filing monthly GSTR-1, consistent calculation accuracy across all invoices avoids reconciliation headaches at quarter-end.
FAQs
What is the inclusive GST formula?
Taxable value = Total amount ÷ (1 + GST rate/100). GST amount = Total amount − Taxable value. For example, at 18% GST on Rs 11,800: taxable value = 11,800 ÷ 1.18 = Rs 10,000. GST = Rs 1,800.
What is the exclusive GST formula?
GST amount = Taxable value × GST rate ÷ 100. Total = Taxable value + GST. For Rs 10,000 at 18%: GST = Rs 1,800, total = Rs 11,800.
Can I use the same formula for 5%, 12%, and 18%?
Yes — the formula is the same, only the rate value changes. Substitute the applicable rate and the calculation works for any GST slab.
How to avoid manual calculation errors?
Use our free GST calculator or invoice generator — both auto-apply the correct formula and split CGST/SGST or IGST based on the states involved.
Why Businesses Stop Using Excel for GST Invoices
Manual GST calculation mistakes
One wrong CGST/SGST split or a misapplied rate triggers notices and ITC denial for your buyer.
Slow invoice creation
Copying last month's Excel file, updating dates, recalculating — 20 minutes for what should take 30 seconds.
Formatting breaks on every device
Excel invoices look different on every printer and PDF converter. Clients complain about unreadable layouts.
No easy sharing or payment link
Sending PDFs over WhatsApp with no way for clients to pay directly slows down collections.
Incorrect tax type (IGST vs CGST+SGST)
Excel can't auto-detect intra vs inter-state supply. Wrong tax type = ITC rejected for your buyer.
Disclaimer: The information in this article is for general informational purposes only and does not constitute professional tax, legal, or financial advice. GST rules and rates are subject to change. Consult a qualified CA or tax professional before making compliance decisions.
Create GST Invoice Instantly
Create professional GST invoices instantly — no Excel, no manual calculations.