1. Home
  2. Calculators
  3. GST Inclusive vs Exclusive Split Calculator

GST Inclusive vs Exclusive Split Calculator

For Indian shopkeepers, accountants and freelancers who need the GST part of a bill split out line by line.

Free, no sign-up. Runs in your browser: nothing is uploaded.

How to use GST Inclusive vs Exclusive Split Calculator

  1. Enter your numbers, or press a sample to see an example.
  2. Read the results and the table under them.
  3. Copy the results or download the table as a CSV file.

Features

  • Prices that include or exclude GST
  • A different rate on any line
  • CGST and SGST halves, or IGST between states
  • Rounded lines that always add up to the invoice total
  • Rates for older invoices kept in the list

Supported formats

Input

  • Typed lines
  • Pasted text

You get

  • On-screen results
  • CSV

Private by design

Everything you enter is processed by your browser on this device. Nothing is sent to openWorkstand or anyone else, so the GST Inclusive vs Exclusive Split Calculator is safe for private and work data. After you have used it once while online, it also works without an internet connection. How local processing works

Good to know

  • It applies the rate you choose and does not look up the rate for a product.
  • Cess, TCS and reverse charge are not modelled.

Guide

Splitting GST out of prices: taxable value, CGST, SGST and IGST line by line

An Indian shop bill often carries a single total, but accounts, returns and filings need the tax split out: how much is the taxable value, how much is CGST and SGST, or IGST if the sale crosses a state line. Doing it by hand for a list of items, some with different rates, invites errors of a few paise that add up. This page splits a whole list at once and keeps the lines consistent with the total.

Inclusive and exclusive prices

Choose whether the prices you typed include GST or not. If they include it, the taxable value is the price divided by one plus the rate, and the GST is what is left: 1,499 at 5% is 1,427.62 plus 71.38. If they exclude it, the GST is the price times the rate, and the total is higher than what you typed. The same list can be run both ways to check a supplier’s quoted total.

Entering items

One item per line: a name, a pipe and the price, and optionally another pipe and the rate for that line. Lines without a rate use the rate selected above. The default list is a cotton kurta at 1,499 using the default 5%, a book at 250 with a 0% rate, and a gift box at 118 with an 18% rate. A line that cannot be read is named in the error message with an example.

CGST, SGST and IGST

For a sale within one state the tax is split equally between the central and state GST. For a sale between states the whole tax is IGST. Choose the supply type and the table’s columns change to match. Each line’s tax is rounded to the paisa, and for CGST and SGST the SGST takes any odd paisa, so the halves never differ from the tax by even a paisa.

A worked example

The default bill has prices that include GST. The kurta has a taxable value of 1,427.62 and tax of 71.38; the book is 250.00 with no tax; the gift box has a taxable value of 100.00 and tax of 18.00. The taxable value is 1,777.62, GST is 89.38 and the invoice total 1,867.00. CGST is 44.69 and SGST 44.69. The page also shows the total rounded to the nearest rupee, 1,867. The second sample adds 18% GST between states to a website design at 25,000 and hosting at 6,000, both excluding GST: the taxable value is 31,000.00, the IGST 5,580.00 and the total 36,580.00.

Rates

The list shows 5%, 18%, 40%, 3% for gold and silver, 0.25% for rough diamonds and 0%. The older 12% and 28% rates are kept for invoices from before the 2025 rationalisation, and an “Another rate” box takes any other figure. A note on the page says that rates change by notification and differ by product, so look up your own goods or service on the CBIC website before you rely on any of them.

Edge cases

A price of zero is allowed and produces zero tax. A negative price or a rate above 100 is rejected. An empty list gives an error asking for at least one item. Rates written with a percent sign, such as 18%, are accepted on a line. Because each line is rounded separately, the total may differ by a paisa from rounding the whole bill once.

Limits

The page applies the rate you choose; it does not know which rate a product carries, and it does not model cess, tax collected at source, reverse charge, composition dealers or place-of-supply rules. It does not issue a tax invoice either. Use it to check and split figures, and put the results into your billing software or an invoice.

Checked against the current version of the GST Inclusive vs Exclusive Split Calculator on .

Troubleshooting

The download did not start

Look for your browser’s download bar or icon. Some browsers ask once before a site may download files; allow it and click the button again.

Frequently asked questions

Why does the SGST take the rounding remainder?

Each line’s tax is rounded to the paisa first. When that tax does not halve evenly, for example a tax of 0.05, CGST takes the rounded half, 0.03, and SGST takes what is left, 0.02. Rounding both halves separately could leave the two a paisa away from the tax, so the page never does that.

Which rates are in the list?

The list has 5, 18 and 40 percent, 3 percent for gold and silver, 0.25 percent for rough diamonds and 0 percent, with 12 and 28 percent kept for invoices from before the 2025 change. Tax rates change by notification, so confirm the rate for your item on the official site.

How is GST taken out of a price that includes it?

Divide the price by one plus the rate to get the taxable value, then the tax is the price minus that value. A price of 1,050 at 5% is 1,000 plus 50.

When do I charge IGST instead of CGST and SGST?

IGST applies when the supplier and the place of supply are in different states, and CGST plus SGST when they are in the same state. The page just applies the choice you make.

Keep working with the result

After you download, choose “Save to Workstand” to keep the result in a folder on your computer, attach it to a project and create a follow-up task. It is saved by your browser, not uploaded.