When you buy a prepaid physiotherapy pack, the payment is one lump but the benefit arrives one session at a time. To track it, record the pack price once, tick off each session as it happens, and divide the price by sessions attended to see your real cost per session. Whatever is left unused is money you have already spent but not yet received.
What columns does the pack tracker need?
- Pack name or number and the date you bought it
- Total price paid and how you paid
- Number of sessions in the pack
- One row per session: date, therapist, what was done, attended or missed
- Expiry date of the pack, if the clinic sets one
Keep the clinic's receipt with the sheet. If the pack was sold with a validity period, copy that into the sheet exactly as written, because an expired pack is the most common way people lose paid sessions.
How do I calculate sessions left and cost per session?
Say a pack of 10 sessions cost ₹6,000 and you have attended 4. These figures are only an example.
| Measure | Working | Result |
|---|---|---|
| Price per session if all used | 6,000 / 10 | ₹600 |
| Sessions left | 10 - 4 | 6 |
| Value still unused | 6 x 600 | ₹3,600 |
| Cost so far per attended session | 6,000 / 4 | ₹1,500 |
That last figure falls as you attend more sessions, and it reaches ₹600 only when all 10 are used. If sessions in column C are marked with the word Attended, then =COUNTIF($C$2:$C$30,"Attended") counts them, and =B1-COUNTIF($C$2:$C$30,"Attended") gives sessions left when B1 holds the pack size.
What happens to missed or rescheduled sessions?
Ask the clinic, before you buy, whether a missed session is lost, carried over or can be moved with notice, and write the answer on the receipt copy. In the sheet use a separate status for Missed and Rescheduled so the counts stay honest. A pack with many missed sessions is a sign that the schedule did not suit you, which is worth knowing before the next purchase.
Is a pack cheaper than paying per visit?
Only your own numbers can say. Find out the single-visit fee, then compare it with the pack's per-session price, but only after allowing for the sessions you realistically expect to use. If you buy 10 and use 7, your cost per session is the price divided by 7, and this may be higher than the single-visit fee.
How does this show up in my monthly spending?
A pack bought in January appears as one large health expense that month and nothing in the months after. If you prefer a smoother view, divide the price across the months the pack is meant to cover. In SpendixAI you could record the payment as a health expense with the receipt attached and note the pack size in the description, though the session count itself is best kept in your sheet.
What if you only attend part of the pack?
This is where a record pays off. Keep three simple numbers at the top of the sheet: sessions bought, sessions attended and days left before expiry. If the pack is about to lapse with sessions unused, you can ask the clinic for a date extension or an adjustment while you still have your own log to show.
- Sessions bought: 10
- Sessions attended: 4
- Days left on the pack: count from the expiry date written on the receipt
- Sessions at risk: sessions left that cannot realistically fit in those days
A tracker that shows sessions at risk turns a vague worry into a question you can ask the clinic with facts.
Before you buy the next pack
- Check how many sessions of the last pack were actually used
- Compare the cost per attended session with the single-visit fee
- Read the expiry and refund terms and note them down
- Ask your doctor or physiotherapist how many sessions are really needed, instead of buying the largest pack
Useful ideas start with a clearer picture of your own spending.
Explore your reports

