At month end, the goal is a short list of entries that are missing a receipt, a GST invoice detail, or a clear business reason, so you can fix them while the memory is fresh and take a clean file to your CA. An AI assistant can build that list from your rows quickly. It cannot tell you what is allowed, and this checklist does not try to.
Before you start: what is in scope
This is a records exercise. It does not say which costs qualify for any treatment, what rate applies, or what to file. Rules and limits change, so confirm the current position with your CA or the official source. Your aim is only to arrive with complete paperwork.
Step 1: gather the rows
- Export this month's expense rows with date, merchant, amount, category and any note.
- Add two columns of your own: Receipt on file (yes or no) and GST bill details noted (yes, no, not applicable).
- Strip bank account numbers and personal columns before giving the file to an assistant.
Step 2: run the prompts
- List every row where Receipt on file is no, sorted by amount, largest first. Show the count and the total in rupees.
- List every row in business categories where GST bill details noted is no. Do not guess which ones need it; show all of them.
- Find rows with the same merchant and amount within three days of each other. They may be duplicates.
- Find rows with round amounts above ₹5,000 and no note. I will explain each one myself.
- Find rows with no category or the category Other.
The ₹5,000 line in the fourth prompt is your own cut-off, not a rule. Pick a number that makes sense for your business and keep it the same each month.
Step 3: verify, do not trust
Count the rows yourself. If your sheet says 12 missing receipts totalling ₹21,300, the assistant should say the same. Say your two lists disagree: filter the Receipt column for "no", read the count at the bottom of the screen, and ask the assistant to list the rows it used.
| Check | How to do it manually |
|---|---|
| Missing receipts | Filter Receipt on file = no, note the count and sum |
| Missing GST details | Filter GST bill details noted = no, within business categories |
| Possible duplicates | Sort by merchant then amount, look for neighbours |
| Uncategorised | Filter Category blank or Other |
| Month total | Compare the sum of the rows with your bank statement's debit total |
What do you do about each gap?
- Receipt missing: ask the seller for a copy, or check the email or messaging app where it might have arrived, and attach it to the entry.
- GST details missing: check the bill; if it has none, note that, and let your CA decide what to do.
- Duplicate suspected: compare with the statement; if both are real, add a note.
- Uncategorised: choose a category now, or write "ask CA" in the note.
Where the tracker helps
SpendixAI keeps receipts with their transactions, flags possible duplicate imports, has a Possible duplicate charges report (same amount to the same merchant within two days), and lets you set GST rate, ITC-eligible and tax-deductible settings on categories. Its reports estimate the GST inside spending; those are estimates to confirm against invoices and with a CA. If you use it, the receipt and duplicate checks above become short filtered views.
Send your CA a tidy pack
- Month total that matches the bank statement.
- List of entries still missing receipts, with your note on each.
- List of entries with open questions for the CA.
- The category and tax-code file, if your CA uses one.
- Anything unusual: a large one-off purchase, a refund, an advance.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


