A tracker estimates GST by taking the amount you paid, assuming it already includes tax, and backing out the tax part using the GST rate set on that transaction's category. For a ₹1,180 bill at a rate of 18 percent, the GST inside is ₹180. It is arithmetic on your own numbers, so it is only as good as the rate and the assumption behind it.
The formula, in plain words
If a price includes tax, the amount paid equals the pre-tax price multiplied by one plus the rate. So the tax inside the amount is the amount paid times the rate, divided by 100 plus the rate. Written out: GST = amount × rate ÷ (100 + rate).
Notice what this is not: it is not the amount times the rate. That would apply the percentage to a figure that already contains the tax, and overstate it. Say you paid ₹1,180 and take 18 percent of that: you get ₹212.40, which is wrong. The correct figure is 1,180 × 18 ÷ 118 = ₹180.
Three categories, worked through
The rates below are examples to show the sums, not a statement about what any product is charged. Your invoices decide your real rates.
| Category | Amount paid | Example rate | GST inside |
|---|---|---|---|
| Internet | ₹1,180 | 18 percent | 1,180 × 18 ÷ 118 = ₹180 |
| Stationery | ₹2,240 | 12 percent | 2,240 × 12 ÷ 112 = ₹240 |
| Packaged food | ₹2,100 | 5 percent | 2,100 × 5 ÷ 105 = ₹100 |
Total spending is 1,180 + 2,240 + 2,100 = ₹5,520, and the estimated GST is 180 + 240 + 100 = ₹520. The report might then show that about ₹520 of your ₹5,520 was tax. That figure is an estimate built from the three rates.
What the estimate assumes
- The amount you paid includes GST. If a bill showed the tax on top of the price, the amount on your statement already includes it, so this holds. Be careful with anything you entered by hand as a pre-tax figure.
- Every purchase in a category carries that category's rate.
- Nothing in the category is exempt or taxed differently.
- Discounts and rounding do not change the proportion.
Each assumption is a place the estimate can drift. That is fine for a rough picture and not fine for anything formal.
How does SpendixAI do it?
In SpendixAI each category can hold a GST rate along with the ITC-eligible and tax-deductible settings and an accounting code. Reports estimate the GST inside your spending from those rates. The figures are estimates; check them against your invoices and confirm anything important with a CA. Uploading a statement does not tell the tracker what was on the bill, so the rate comes from your category, not from the invoice.
Where do I find out how much GST I actually paid?
The invoice. A tax invoice shows the tax charged, and the sum of your invoices is the real figure. A bank row only shows the total. If you want actual tax figures, collect the invoices and attach them to their transactions, then add them up, or ask your accountant to.
Getting more reliable estimates
- Set rates from real invoices, not memory.
- Split mixed categories into sub-categories with their own rates.
- Leave the rate blank where you have no idea, rather than guessing.
- Compare a few invoices against the report each quarter and adjust.
- Keep business and personal categories apart so the numbers mean something.
One last check on any estimate: reverse the sum. If the tax inside ₹1,180 is ₹180, then ₹1,180 minus ₹180 leaves ₹1,000, and 18 percent of ₹1,000 is ₹180 again. If the two do not agree, the formula or the rate has gone wrong somewhere.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

