The estimate is a calculation from one category-wide rate, while your invoice records the tax actually charged line by line. They will differ whenever a category mixes items taxed at different rates, includes items with no tax, or involves rounding and discounts. The difference is not a bug. It tells you where the category is too blunt.
The most common cause: mixed rates under one category
Suppose a department store bill has two lines. Item A has a pre-tax price of ₹1,000 and tax of ₹180. Item B has a pre-tax price of ₹2,000 and tax of ₹100. The bill totals ₹3,280, and the tax actually charged is ₹280.
Now say your category rate is 18 percent, because the first item made you pick that. The estimate is 3,280 × 18 ÷ 118 = ₹500.34. The invoice says ₹280. The estimate is ₹220.34 too high, purely because the cheaper-tax item was treated as if it were the same as the other one.
| Cause | What happens | What to do |
|---|---|---|
| Mixed rates in one category | One rate cannot fit every line | Split into sub-categories |
| Exempt or nil-tax items | Estimate shows tax that was never charged | Separate them or lower the rate |
| Rounding | Invoice rounds per line; estimate rounds once | Expect small paise gaps |
| Discounts and offers | Tax may be charged on the discounted price | Compare against the invoice total |
| Amount entered pre-tax by hand | Estimate assumes tax is included | Enter the amount actually paid |
Exempt items, rounding and discounts
Some purchases carry no tax at all. If they sit in a category with a rate, the report will show tax that was never paid. Putting such items in a category of their own with the rate left blank solves it.
Rounding is smaller but real. An invoice may round each line to the nearest paisa, and the tracker rounds a single figure. Over a month the paise gaps are negligible. If the difference is more than a rupee or two on a single bill, look elsewhere for the cause.
Discounts matter more. If a store gives a discount at the till, the tax may be charged on the lower price. The amount you paid is lower, so the estimate drops too, and usually matches reasonably. It goes wrong when a discount applies after tax or only to part of the bill, so check the invoice itself.
How do I find which bills are off?
- Pick the category with the biggest gap between the report's estimate and your invoices.
- Take three or four recent invoices and write down the tax actually charged on each.
- Compare each with the estimate for the same transactions.
- Look at the pattern: are the gaps always in one direction, or only on mixed bills?
- Decide whether to split the category, change the rate, or accept the gap.
Adjusting the category
In SpendixAI, a category's GST rate can be changed, and you can create sub-categories each with their own rate. If one category is the main culprit, split it. If the bills are mostly one rate with an occasional odd item, keep the rate and write a short note against the exceptional transactions, so you remember why the estimate is off.
Do not chase every rupee. The report estimates GST inside spending from category rates, and the product itself says to check figures against invoices and with a CA.
A quick checklist
- Does the category mix purchases that could carry different rates?
- Are there items on the invoice with no tax?
- Was the amount entered as paid, not as pre-tax?
- Is the gap more than rounding on a single bill?
- Have you noted the exceptions or split the category?
A small gap on a rough report is normal. A large one is worth ten minutes, once, and the fix usually lasts for months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

