Health and family

Finding hospital, clinic and lab payments in a bank statement

How to find medical transactions in a bank statement: search terms, a simple formula to flag them, and how to fix entries with unhelpful merchant names.

Editorial illustration for Finding hospital, clinic and lab payments in a bank statement

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 seeLikely reasonWhat to do
A person's name via UPIA doctor, a chemist or a lab technician paid directlyMatch with a receipt or message, then label it
A payment gateway nameThe clinic uses an online payment serviceLook at the date and amount in your email receipts
A short codeThe terminal's merchant IDSearch the code in other months to find a pattern
Cash withdrawalPaid in cashAdd 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?

  1. Keep a list of the payees you have confirmed as medical, and add each new one.
  2. Search for those names first each month.
  3. Note the amounts for regular payments, such as a monthly pharmacy bill, so changes stand out.
  4. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports