Getting started

How to set a GST rate on an expense category

How to set a GST rate on an expense category, which rate to read from your invoices, and why the resulting figures are estimates to confirm with a CA.

Editorial illustration for How to set a GST rate on an expense category

To set a GST rate on an expense category, open that category in your tracker, enter the rate shown on the invoices you actually receive for that kind of purchase, and save. From then on, the tracker uses that rate to estimate how much GST sits inside what you spent in the category. The rate should come from your invoices, not from memory, because the same word, such as groceries or electronics, can cover items taxed differently.

What the rate on a category actually does

In SpendixAI, a category can carry a GST rate alongside its colour, an accounting code and flags for ITC-eligible and tax-deductible. The rate is used in reports that estimate the GST contained in your spending. You are not filing anything and not computing a liability. You are giving the report a number to work with so it can show a rough tax figure for each category and for the month.

Because the category rate is applied to every transaction in it, the quality of the estimate depends entirely on how uniform that category is. A category holding only your broadband bills will be accurate. A category holding every supermarket visit will not.

Where do I find the right rate?

Pull three or four recent invoices or bills for the category and read the tax lines. A proper tax invoice usually shows the tax split and the rate, and some show a rate per item. Write down what you see for each. Do not rely on a rate you once heard, a rate from a news headline, or a rate you assume a product has. Rates and their application to specific goods and services change, so the invoice in your hand is the evidence.

  • Utilities and services: the bill or invoice normally shows the tax charged.
  • Restaurants and online orders: check the invoice or order summary, since a bill may show tax as a lump or per item.
  • Retail and supermarkets: receipts may list several rates on one bill; that is a sign the category needs splitting.
  • No invoice, only a UPI payment: leave the rate blank or set it to nothing rather than guess.

Setting it step by step

  1. Open your category list and select the category, for example Internet and phone.
  2. Read the rate from a recent invoice and type it into the GST rate field.
  3. Decide whether this category should also be marked ITC-eligible or tax-deductible. Those are separate flags, and your CA should confirm them; do not tick them because they look useful.
  4. Save, then open a report that shows estimated GST and check that one category you know well looks right against a real bill.

Do the check in the last step. If your broadband bills are ₹1,180 each and the rate on the category is 18 percent, the GST inside each bill is 1,180 × 18 ÷ 118 = ₹180. If the report shows something very different for a month with a single bill, your rate or amount is off. The 18 percent here is only an example to show the arithmetic; use the figure on your own invoice.

What if one category has different rates inside it?

This is the common problem. Suppose a stationery shop invoice shows one rate for notebooks and another for printer ink. A single Stationery category cannot represent both. The cleaner answer is sub-categories: Stationery paper and Stationery ink, each with its own rate. If that feels like too much admin, accept an approximate rate on the parent category and treat the output as a rough guide.

SituationWhat to do
Category uses one rate on every invoiceSet that rate on the category
Invoices show two or three ratesCreate sub-categories and give each its own rate
Mix is unpredictable (supermarket)Leave the rate off, or use a rough one and note it is rough
No invoices, only UPI entriesDo not guess; leave the rate blank

A habit worth keeping

Once a quarter, pick one category and compare the report's estimated GST with the tax shown on three real bills. If they drift apart, adjust the rate or split the category. It takes ten minutes and keeps the numbers believable, which matters more than precision you cannot verify.

SPENDIXAI JOURNAL

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

Explore your reports