You can find every payment to a shop by asking a connected AI assistant in plain language, for example 'How much did I pay the milkman last month?' It reads your records, lists the matching rows and adds them up. Then you check the total against your own report. No technical skill is needed, only a connection and one careful question.
What do I need before I start?
An expense app connected to the assistant, with read-only access so the assistant can look but not touch. SpendixAI supports connecting Claude or ChatGPT over MCP, and you choose the scope and can disconnect whenever you like. Merchant search is one of the things a connected assistant can use. If you have not connected yet, do that first and pick read-only.
What should I type?
Say three things: the name, the period and what you want back. A good question is: 'Find payments to the milkman in October and tell me how many there were and the total.' A weak one is: 'milk'. The first tells the assistant what to search for, when, and what a useful answer looks like.
- Type the shop's name as you know it.
- Add the month or date range.
- Ask for the count and the total, not only a list.
- Read the rows it shows you.
- Ask a follow-up, such as 'Are there any with a different spelling?'
How do I know the answer is right?
Do a small sum yourself. Suppose the assistant shows four payments of ₹1,860 for the milkman. Four times 1,860 is ₹7,440. If the assistant says ₹7,440 and your own report shows the same figure, you can trust the answer for this question. If it does not match, do not argue with it; open the rows and look.
| You asked | The assistant said | Your check |
|---|---|---|
| Milkman payments in October | 4 payments, ₹7,440 | 4 x ₹1,860 = ₹7,440, matches |
| Chemist in October | 3 payments, ₹2,150 | Add the three rows in the report |
| Electricity bill in October | 1 payment, ₹2,340 | Compare with the bill itself |
Why might the search miss something?
The name on your statement may not be the name you use. A shop might appear under the name of a payment company, or a short code. If the answer looks too small, tell the assistant: 'Also look for rows with similar names.' You can also add an alias in the app, so that different spellings are treated as one merchant from now on.
Payments made in cash will not appear unless you added them yourself.
What if I want to change something I find?
Make the change in the app yourself. Reading is the safe job for the assistant. If you find a row under the wrong category, open it in the app and fix it there, and the correction becomes part of your history.
What are some good first questions?
- How many times did I pay the chemist this month, and what was the total?
- What was my largest payment to the electricity company this year?
- Which month did I pay the broadband provider twice?
- What did I pay the domestic help in the last three months?
Each of these is one shop, one period and one measurable answer, which makes them easy to check.
A quick practice run
- Pick one shop you pay often.
- Ask the assistant for the count and total last month.
- Open your own report and filter to the same shop.
- Compare the two numbers.
- If they match, you have learned that the search works for names like that one.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


