In simple words, input tax credit (ITC) is about the tax you have already paid on your purchases for the business. For your records, think of it as a column: the tax printed on a purchase bill, written separately from the base cost. Whether any of that tax can later be used is a question of rules and eligibility for your CA to answer; the record-keeping job is to capture it cleanly.
Why keep the tax apart from the cost?
If you write only the final total, the tax is buried inside it and cannot be pulled out later without digging through bills. A column for tax on each purchase lets you add it up for any month in seconds. It also keeps your real cost of the item visible, since the base amount is what the goods or service actually cost the business.
One purchase bill, split into columns
Say a shop buys goods from a supplier. The bill shows a base value of ₹25,000 and tax of ₹4,500, so the total payable is ₹29,500. The figures are made up.
| Bill | Base cost (₹) | Tax on the bill (₹) | Total paid (₹) |
|---|---|---|---|
| Supplier A, bill 214 | 25,000 | 4,500 | 29,500 |
| Supplier B, bill 88 | 8,000 | 1,440 | 9,440 |
| Supplier C, bill 52 | 3,200 | 160 | 3,360 |
| Month total | 36,200 | 6,100 | 42,300 |
Check: 25,000 plus 8,000 plus 3,200 is 36,200; 4,500 plus 1,440 plus 160 is 6,100; and 36,200 plus 6,100 is 42,300. The totals column also adds up to 42,300, so the three columns agree.
How do you build the ITC column in a sheet?
- Column A: bill date. Column B: supplier. Column C: bill number.
- Column D: base cost. Column E: tax on the bill. Column F: total, =D2+E2.
- Column G: a flag such as Yes, No or Check, for whether the tax can be used. You fill it only after checking with your CA.
- Month total of tax: =SUM($E$2:$E$200).
- Tax marked Yes: =SUMIFS($E$2:$E$200,$G$2:$G$200,"Yes").
Does every bill's tax go in the column?
Record the tax on every bill that shows it, then use the flag to separate what is usable from what is not. Some purchases may not qualify, and the rules differ by item and situation, which is why the flag starts as Check. Do not decide alone; list the Check items and ask your CA at the end of the month.
What happens when a bill is returned or corrected?
If the supplier later issues a credit note for part of Bill 214, say for ₹1,000 base and ₹180 tax, reduce both columns for that bill: base falls to 24,000 and tax to 4,320. Keep the original row and add a second row for the credit note with negative amounts, so the history stays visible and the month total corrects itself. Never overwrite the original figures, because you may need to show how the change came about.
What proof should you keep?
Keep the supplier's bill with their GSTIN, the bill number and date, and the tax lines visible. A photo of a faded thermal print is risky, so scan or photograph it clearly on the day. Matching the bill to the payment in your bank statement closes the loop.
In SpendixAI, each custom category can carry GST rate, ITC-eligible and tax-deductible settings, and reports estimate the GST inside your spending. These are estimates, so check them against your bills before relying on them.
Monthly routine
- Enter every purchase bill with base cost, tax and total.
- Flag each as Yes, No or Check.
- Add the tax column and compare with the tax figures on your bills.
- Send the Check list to your CA.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

