Business

GST-inclusive vs GST-exclusive price: how to record each

GST-inclusive vs GST-exclusive price: how the same ₹11,800 payment is stored as a base amount plus a tax field, with the rate taken from your invoice.

Editorial illustration for GST-inclusive vs GST-exclusive price: how to record each

A GST-inclusive price already has the tax inside it; a GST-exclusive price shows the base and leaves the tax to be added on top. To record either properly, store three numbers: base amount, tax amount, and total. The total is what left your bank, and the other two come from the invoice.

The same ₹11,800, two ways

An illustrative rate of 18 per cent is used here only to show the arithmetic. The real rate for a purchase is on the invoice and varies by item, so never copy this one. Say you paid ₹11,800 for a service.

StyleWhat the price saysBase (₹)Tax (₹)Total (₹)
Inclusive11,800 including tax10,0001,80011,800
Exclusive10,000 plus tax10,0001,80011,800

For an inclusive price, the base is the total divided by 1 plus the rate: 11,800 divided by 1.18 is 10,000. The tax is the total minus the base, so 1,800. For an exclusive price, the tax is the base times the rate: 10,000 times 0.18 is 1,800, and the total is 11,800.

How do you separate GST from a total in a sheet?

Put the total in column C and the rate as a decimal in column D, such as 0.18. In Excel or Google Sheets:

  • Base amount in E2: =ROUND(C2/(1+D2),2)
  • Tax amount in F2: =C2-E2
  • For an exclusive price, tax in F2: =ROUND(E2*D2,2), and total in C2: =E2+F2

Copy the formulas down. Check that base plus tax always equals the total.

Why store the tax separately?

A single total tells you what you spent, but not how much of it was tax. If you need to show your CA a split, or compare tax charged across vendors, the separate field saves hours at the year end. It also helps when you review a bill, because the tax should match the printed figure.

What if the invoice shows two tax lines?

Many invoices show the tax as two equal halves, or as one combined figure, depending on where the buyer and seller are. Whatever the layout, record the sum of the tax lines as the tax amount, and keep the invoice as proof. Do not recalculate from a rate you remember; use what the document says.

Whichever way you start, finish by re-adding the three numbers. If base plus tax does not equal the total, you have likely read a digit wrong or the bill includes a charge, such as packing or freight, that is listed on a separate line.

A second example with a purchase at a different rate

Take a bill where the tax is printed as ₹450 on a base of ₹9,000. Here the total is 9,000 plus 450, which is ₹9,450, and the implied rate is 450 divided by 9,000, which is 5 per cent. Working backwards like this is a good check, because if the implied rate looks odd, you may have misread a line. Do not quote the implied rate as the right one for the item; it only checks your arithmetic.

What if the numbers do not divide cleanly?

Real invoices round per line, so a small difference of a few paise or a rupee can appear between your calculation and the printed figure. Trust the invoice, not your formula, and note the rounding in the entry.

Where SpendixAI fits

In SpendixAI a category can carry a GST rate, and reports estimate the GST inside your spending. These are estimates, so check them against your invoices and confirm with your CA.

Before you save an entry

  1. Read the total on the bill.
  2. Read the base and tax lines.
  3. Check base plus tax equals total.
  4. Save all three, and file the bill.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports