Life events

Physiotherapy or dialysis sessions: track a recurring treatment

Track recurring treatment such as physiotherapy or dialysis: log each session, package versus per-session cost, travel, attendant and sessions remaining.

Editorial illustration for Physiotherapy or dialysis sessions: track a recurring treatment

To track a recurring treatment, keep a session log with one row for each visit: date, place, amount, how it was paid (package or per session), travel and attendant cost, and a running count of sessions left. Total it each month and you will know what the treatment costs without waiting for the bills to pile up.

What should each session row contain?

DateSession no.PlacePaid viaSession costTravelAttendantStatus
your date1Centre namePackage₹800₹250₹0Done
your date2Centre namePackage₹800₹250₹0Done
your date3Centre namePackage₹800₹400₹300Done
your date4Centre namePackage₹800₹250₹0Planned

The numbers are invented. Keep a column for status, because a planned session that does not happen should not be counted as spent.

Is a prepaid package or a per-session fee cheaper?

Work it out with the centre's own prices, and ask what happens to unused sessions if treatment stops early, and whether a package expires. Say a package of 12 sessions costs ₹9,600 and a single session costs ₹1,000. The package works out to ₹9,600 divided by 12, which is ₹800 a session, so ₹200 less per session, or ₹2,400 across the twelve. But the saving exists only if you actually use all twelve, and if the package is refundable or transferable. If treatment may stop after six sessions, six at ₹1,000 is ₹6,000, while the package would still have cost ₹9,600.

How do you know how many sessions are left?

Put the package size in cell B1, the package price in B2, and list sessions from row 6 onwards with the status in column H. These formulas work in Excel and Google Sheets:

  • Cost per session in the package: =B2/B1
  • Sessions done: =COUNTIF($H$6:$H$200,"Done")
  • Sessions remaining: =B1-COUNTIF($H$6:$H$200,"Done")
  • Value of unused sessions: =(B1-COUNTIF($H$6:$H$200,"Done"))*B2/B1

With 12 sessions at ₹9,600 and 5 done, 7 remain and the unused value is ₹5,600, since 7 times ₹800 is ₹5,600.

What does a month cost in all?

The session fee is only part of it. For a treatment with twelve visits a month, a per-session cost of ₹1,800, a round trip of ₹250 and an occasional attendant, the monthly view looks like this. Hypothetical figures: twelve sessions at ₹1,800 is ₹21,600, twelve trips at ₹250 is ₹3,000, and attendant cost of ₹1,500 on a few days makes a total of ₹26,100. Add medicines and tests on their own lines, so you can see which part moves from month to month.

Travel and attendant costs deserve their own columns, because they often match or exceed the session fee over time. A parent who needs someone to accompany them on every visit adds a real cost, and a longer commute multiplies it. If a centre closer to home charges a little more per session but saves travel, the totals in your sheet will show whether that is worthwhile.

What should you keep for claims?

Keep each bill or receipt, the doctor's advice for the course of treatment, and the dates of sessions. Whether a recurring treatment is covered, and how often claims can be made, depends on the policy or scheme, so ask the insurer or the employer's desk. Writing the answer in the sheet will save you asking again.

When a sheet stops being enough

For one treatment a sheet suffices. If payments go through UPI, a card and cash, SpendixAI can bring them together: import statements, add cash entries by hand, keep receipts with the transactions and use a category with sub-categories for fees, travel and medicines. Its monthly reports then show the total without manual adding.

A simple routine

  1. After each session, add the row that evening.
  2. Mark the status and the payment type.
  3. On the last day of the month, total the fees, travel and attendant lines.
  4. Update sessions remaining and note any package expiry date.
  5. File the receipts for the month in one place.
SPENDIXAI JOURNAL

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

Explore your reports