To find medical transactions in a bank statement, download it as CSV or Excel, filter the description column for words such as hospital, clinic, diagnostic, lab, pharmacy and medical, then read what is left for payees you recognise. Entries with personal names or unclear merchant codes need checking against receipts, since a doctor paid by UPI may show only a person's name.
Bank descriptions are written for the bank's systems, not for you. A pharmacy may appear under its trade name, a hospital under a payment gateway, and a small clinic as a person's name. A systematic search, followed by a short review, finds most of them.
Which words should you search for?
- Places: hospital, clinic, nursing, diagnostic, diagnostics, labs, scan, imaging, dental, eye, ortho.
- Pharmacy: pharmacy, pharma, chemist, medical, medicos, drugs.
- Wellness: physio, therapy, health, care.
- Payment wrappers: a gateway name sometimes appears instead of the merchant, so look at the reference too.
Words like 'care' and 'health' also match shops and insurers, so treat results as candidates. Use your own statement to see what your bank actually prints, since formats differ.
How do you flag them with a formula?
Put the description in column B and your search words in H2:H12, one per cell. In C2, flag a medical candidate with this formula:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($H$2:$H$12, B2)))>0, "Medical?", "")
SEARCH ignores case, ISNUMBER turns each hit into TRUE, and SUMPRODUCT counts the hits, so any description containing at least one word gets flagged. Copy it down, then filter column C. It works in Excel and Google Sheets. To total the flagged rows, use =SUMIFS($D$2:$D$500, $C$2:$C$500, "Medical?") where D is the debit amount.
What do you do about unhelpful names?
| What you see | Likely reason | What to do |
|---|---|---|
| A person's name via UPI | A doctor, a chemist or a lab technician paid directly | Match with a receipt or message, then label it |
| A payment gateway name | The clinic uses an online payment service | Look at the date and amount in your email receipts |
| A short code | The terminal's merchant ID | Search the code in other months to find a pattern |
| Cash withdrawal | Paid in cash | Add the medical payments by hand if you have bills |
If you cannot identify a payment, leave it as uncategorised and ask whoever might have made it. Do not label it medical on a guess.
How do you stop repeating the work next month?
- Keep a list of the payees you have confirmed as medical, and add each new one.
- Search for those names first each month.
- Note the amounts for regular payments, such as a monthly pharmacy bill, so changes stand out.
- Keep receipts for the ambiguous ones in a folder, named by month.
Can SpendixAI do the matching?
You can upload a statement as PDF, CSV or Excel, after choosing the account, and review each row before saving. Set your own rules, such as 'description contains diagnostic goes to Medical', and add merchant aliases for confusing names. When you correct an entry, the correction becomes history, so similar merchants are categorised the same way next time. AI categorisation can be switched off if you prefer, and unmatched rows are then held for review. Not every statement layout will parse perfectly, so check the rows.
A checklist for each statement
- Download the statement for the month.
- Filter by your search words and check each hit.
- Identify personal-name payments from receipts or messages.
- Save the confirmed payees so next month is quicker.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


