The question: can I ask an AI assistant to search my expense app for a merchant by name and tell me what I paid them? Yes, if your app is connected to the assistant. Ask for the payments to that merchant over a date range, then check the count and total against your own report, because name matching is only as good as the name on the row.
What do I need first?
A connection between the assistant and your expense data, and a clear question. SpendixAI lets you connect Claude or ChatGPT over MCP, choose a scope, begin read-only, and disconnect at any time, and merchant search is among the things a connected assistant can use. Read-only is enough for this job, since searching changes nothing.
How do I run the search, step by step?
- Connect the assistant with read-only access.
- Ask in plain words: 'Find my payments to Zomato in the last three months and give me the count and total.'
- Look at the rows it lists. Check the dates and amounts look like things you remember.
- Ask a follow-up for variations: 'Also check spellings like Zomato Ltd or ZOMATO ORDER.'
- Compare the total with the same filter in your app's own report.
What does a good result look like?
Say the assistant finds six payments: ₹349, ₹512, ₹275, ₹640, ₹418 and ₹396. You add them: 349 + 512 = 861, plus 275 is 1,136, plus 640 is 1,776, plus 418 is 2,194, plus 396 is ₹2,590. If the assistant says ₹2,590 over six orders, the answer matches. If it says five orders or a different total, one row was missed or double counted, and you have found a reason to look closer.
| What the assistant returns | What to check | Likely cause if it differs |
|---|---|---|
| Six payments, total ₹2,590 | Same count and total in your report | None, it matches |
| Five payments | Look for a differently spelled row | Name on the statement varies |
| Seven payments | Look for a refund or a duplicate | A reversed or repeated charge |
| Total much higher | Look for a similar merchant name | A different shop matched by mistake |
Why do some payments not show up?
Because the name on a statement is often not the name on the shop's board. It can be a payment gateway, a shortened code, or a different trading name. A search for the friendly name will miss those rows. SpendixAI normalises merchant names and lets you add merchant aliases, so tying two spellings to one merchant is worth doing once instead of searching twice each time.
Cash is the other gap. A merchant you paid in cash has no statement row unless you added it by hand.
What should I avoid asking?
- Anything that needs the assistant to edit rows, unless you have chosen that on purpose.
- Very broad searches, such as every payment this year, when a month will do.
- Searches for sensitive merchants, if you would not want that line in a chat.
- Questions where you do not plan to check the total.
Can I ask for more than a total?
Yes, but ask in layers. Start with count and total, then ask for the largest and smallest payment, then the gaps between dates. If a shop you pay weekly shows a three-week gap, either you used someone else or a payment was not recorded. Each layer is a quick check on your records, and the assistant does the sorting you would otherwise do by hand.
My short version
Connect read-only, search by name for a bounded period, verify the count and total, add an alias for any spelling that slipped through, and disconnect when you are done.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

