Life events

Pharmacy bills during a long illness: grouping and keeping them

Track pharmacy bills in a long illness: group them under each prescription, keep the scan with the bill and log a monthly total for later claims.

Editorial illustration for Pharmacy bills during a long illness: grouping and keeping them

During a long illness, group every pharmacy bill under the prescription it came from, keep a scan of the bill and the prescription together, and write down one total per month. That small routine means that when you need the papers months later for a claim or a doctor's review, they are already in order.

Why group bills by prescription and not by date?

A chemist bill shows what you bought and when, but a claim or a doctor's review asks a different question: which treatment was this for? One prescription can lead to four or five purchases over weeks as you refill. If the bills are filed by date they mix with milk and vegetables; if they are filed under the prescription, the story of the treatment is visible at a glance.

Give each prescription a short reference such as P1, P2 and P3, with the doctor's name and the date written on the first line of your sheet. Every bill then carries that reference.

What should the sheet look like?

PrescriptionBill dateChemistPatientAmountScan saved
P1 (Dr, date)your datename of chemistMother₹2,340yes
P1 (Dr, date)your datename of chemistMother₹1,980yes
P2 (Dr, date)your datename of chemistMother₹3,150yes
P2 (Dr, date)your dateonline orderMother₹1,420yes

The amounts are made up to show the shape. Add a column for the invoice number as well, since two bills of the same amount on the same day are otherwise easy to confuse.

How do you get a monthly total?

If dates sit in column B and amounts in column E, rows 2 to 500, and you put the first day of the month you want in cell H1 (for example 1-Mar-2026 typed as a real date), this formula adds that month's pharmacy spend:

  • =SUMIFS($E$2:$E$500,$B$2:$B$500,">="&$H$1,$B$2:$B$500,"<"&EDATE($H$1,1))
  • For a single prescription across all months: =SUMIFS($E$2:$E$500,$A$2:$A$500,"P1*")
  • For one patient: =SUMIFS($E$2:$E$500,$D$2:$D$500,"Mother")

EDATE works in both Excel and Google Sheets and returns the same date one month later. The total of the four sample rows is ₹8,890, which is ₹4,320 for P1 and ₹4,570 for P2.

How should you keep the bills so they hold up later?

  • Ask the chemist for a printed bill with the shop name, the patient's name and the date, and avoid handwritten slips if you can.
  • Photograph the bill and the prescription in one frame, or in two photos named with the same reference.
  • For online orders, save the invoice PDF and note the order date.
  • Keep paper originals in a labelled envelope, one per month, in case the original is requested.
  • Note a medicine that was replaced or stopped, so the sheet explains why the pattern changes.

What if several people are ill in the same household?

Add a patient column and use one name per person. The same sheet then answers two questions: how much did medicines cost for each person, and which chemist bills belong to which prescription. If a bill covers two people, split it into two lines and note the invoice number on both.

When a sheet stops being enough

A sheet is enough for one illness. If medicine bills are also scattered across UPI payments and card statements, SpendixAI lets you upload a statement as PDF, CSV or Excel, review the rows before saving and attach the receipt to the transaction, so the debit and its bill sit together. Its custom categories and sub-categories can separate medicines from other health costs.

A monthly routine

  1. On the first of the month, total last month's bills with the formula above.
  2. Check that every bill has a scan and a prescription reference.
  3. Note the next refill date for each long-term medicine.
  4. File the month's paper bills in their envelope.
SPENDIXAI JOURNAL

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

Explore your reports