GST and input tax credit are Indian concepts, so if you are in the United States, the label you need is different: sales tax paid, and whether a purchase is for business or personal use. The method still carries across. Give each category a tax column and a business-use flag, then confirm treatment with a local accountant.
Why does the query mention GST in the US?
Many people searching this have a business or client in India, or a template built around Indian categories. GST is charged on goods and services in India, and registered businesses can in some cases offset tax paid on purchases against tax collected. That mechanism is specific to India, and we will not describe rules for the United States. What I can show is how to structure your records so any accountant can work from them.
What columns should a category list have?
| Column | What it holds | Why |
|---|---|---|
| Category | Software, Travel, Office supplies | The basic grouping |
| Business or personal | B or P | Separates what an accountant may review |
| Tax paid (amount) | Sales tax or similar shown on the receipt | Records what was charged, whatever its treatment |
| Tax rate (if known) | The percentage printed on the receipt | Lets you check the arithmetic |
| Recoverable? (to confirm) | Yes, no or unsure | A flag for your accountant, not a ruling |
| Account code | Your accountant's code | Lets the totals flow into their books |
The key is to record what the receipt says and leave the conclusion to a professional. A flag set to unsure is better than a guess.
A worked example with made-up numbers
Say you buy a $400 monitor for your home office and the receipt shows $32 tax, bringing the total to $432. The rate printed is 32 divided by 400, which is 8 per cent. Your row would read: category Office equipment, business, tax paid $32, rate 8%, recoverable unsure. If the invoice instead showed the tax inside a single total of $432, you can back it out only if you know the rate: 432 divided by 1.08 is $400, and the tax is $32. Always prefer the figure printed on the receipt.
How do I keep this tidy in a spreadsheet?
- Make one row per purchase, with date, merchant, category, total paid and tax paid.
- Add a helper column for the pre-tax amount: =D2-E2.
- Add a check for the rate: =IF(F2=0,0,E2/F2) formatted as a percentage.
- Filter on the recoverable flag when you meet your accountant.
- Keep a receipt image for every row where tax paid is above zero.
Where does SpendixAI come in?
SpendixAI has custom categories with a GST rate, an ITC-eligible setting, a tax-deductible setting and an accounting code, and its reports estimate the GST inside spending. That is built for India and INR, so it suits Indian GST and we do not claim it is available or priced elsewhere. If you have Indian transactions alongside US ones, the same column structure above is a useful pattern.
What if I use more than one currency?
Record each expense in the currency you paid, along with the exchange rate that applied that day, and convert to one base currency for totals. Taxes shown on a foreign receipt belong to that country's rules, so keep the receipt and ask an accountant how to treat it. Never apply the tax rate of one country to a receipt from another.
Checklist
- Category, business flag, tax paid and rate recorded for every row.
- Receipts kept for taxed purchases.
- Unsure flags reviewed with an accountant.
- No Indian rates copied into US records.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


