A medical test expense log needs six columns: the test or scan name, the lab, the date, the amount, where the report is saved, and a tag for the patient and the illness. With those six, you can answer a claim query, hand a second doctor the full history, and see exactly what a diagnosis cost.
What does the log look like?
| Date | Test or scan | Lab or centre | Amount | Report saved at | Patient and illness |
|---|---|---|---|---|---|
| your date | Blood panel | Lab name | ₹1,200 | Folder A, file 1 | Father, thyroid |
| your date | Ultrasound | Centre name | ₹1,600 | Folder A, file 2 | Father, thyroid |
| your date | MRI | Centre name | ₹7,500 | Folder B, file 1 | Mother, knee |
| your date | Follow-up blood test | Lab name | ₹900 | Folder A, file 3 | Father, thyroid |
The amounts are hypothetical. Fill the table with your own bills, and keep the report location as exact as a folder and file name, because searching a phone gallery for a scan from March is slow and stressful.
Why tag by patient and by illness?
Most families have more than one person under treatment at some point, and one person can have more than one issue. A patient tag tells you who the money was spent on; an illness tag tells you what for. Together they answer questions that arrive unexpectedly, such as how much the knee problem cost in the last year, or whether the thyroid check-ups are becoming a monthly drain.
With the four sample rows, the father's thyroid costs are ₹1,200 plus ₹1,600 plus ₹900, which is ₹3,700, and the mother's knee MRI is ₹7,500. Total spend on tests is ₹11,200.
How do you total tests by person or illness?
With amounts in column D and the patient and illness tag in column F, rows 2 to 500, these formulas work in Excel and Google Sheets.
- All tests for one tag: =SUMIFS($D$2:$D$500,$F$2:$F$500,"Father, thyroid")
- Anything mentioning a patient: =SUMIFS($D$2:$D$500,$F$2:$F$500,"Father*")
- Everything for one illness: =SUMIFS($D$2:$D$500,$F$2:$F$500,"*knee")
- Number of tests for a tag: =COUNTIFS($F$2:$F$500,"Father*")
The asterisk matches any text, so the second formula picks up every row that begins with Father. Keep tag spelling identical, or the formulas will miss rows.
Cost is only part of the reason for the log. A second doctor can save you a repeat scan if you can show what was done, when and where, so the date and lab columns often matter more than the amount. Before an appointment, filter the log to that illness, export it or print it, and bring it along with the original reports and images.
How should reports be filed for a second opinion?
A second doctor will ask for reports in date order, and for images, not only the written summary. Name each file with the date first, then the test, then the person, for example 2026-03-14 MRI knee Mother. Folders by patient work better than folders by lab. Where the lab gives you a link instead of a file, save the PDF and also note that a link exists, since links can expire.
Where does an expense tracker fit?
A sheet is perfect for the log. SpendixAI can keep the money side in order: import a bank or card statement, review the rows, and attach a receipt to each lab payment so the bill rests next to the debit. You can set up your own category for diagnostics. It does not store medical reports for sharing with doctors, so keep those in your folder.
What to do after each test
- Enter the row the same day, before the receipt is lost.
- Save the report with the date-first file name.
- Add the tag exactly as spelled earlier.
- Note if the doctor asked for a repeat test and when.
- Back up the folder once a month.
- Ask the lab whether reports stay available online and for how long, and download a copy rather than relying on it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


