A therapy session package tracker needs only five facts per package: what you paid, how many sessions it bought, how many you have used, the expiry date and the cost per session. Keep them in one row, add two small formulas, and you will always know how many sessions are left and how long you have to use them.
Prepaid bundles are easy to lose track of because the money leaves your account on day one while the value is spent slowly over weeks. A bundle that expires with two sessions unused is a real loss, and a sheet row costs nothing to keep.
What goes into a package row
- Package name: use a neutral label such as 'Package 1' if the sheet is shared with family.
- Date paid and amount paid in rupees, plus how you paid (UPI, card, cash).
- Sessions bought, and sessions used so far.
- Expiry date, exactly as written on the receipt or the booking message.
- Notes: whether a missed or rescheduled session counts as used, and who to ask if the date needs to move.
Ask the therapist or clinic about those last two points when you buy, and write the answers in the notes column. Rules about cancellations and extensions differ between practices, so do not assume; ask and record.
How do you work out the cost per session?
Divide the price by the sessions bought. Say a package costs ₹12,000 for 8 sessions: 12,000 divided by 8 is ₹1,500 per session. If a single session at the same clinic is ₹1,800, the package saves ₹300 a session, which is ₹2,400 across all eight.
That saving only exists if you use every session before expiry. Suppose you attend 6 of the 8. Your real cost per used session is 12,000 divided by 6, which is ₹2,000, higher than the single-session price of ₹1,800. This is worth seeing in black and white, because it tells you whether the next bundle should be smaller.
A sheet you can copy
| Column | Heading | Example or formula |
|---|---|---|
| A | Package | Package 1 |
| B | Price paid (₹) | 12000 |
| C | Sessions bought | 8 |
| D | Sessions used | 5 |
| E | Expiry date | 30-Jan-2027 |
| F | Cost per session | =B2/C2 |
| G | Sessions left | =C2-D2 |
| H | Value still unused (₹) | =G2*F2 |
| I | Days to expiry | =E2-TODAY() |
With 5 of 8 used, G2 shows 3 sessions left and H2 shows ₹4,500, because 3 times ₹1,500 is 4,500. Format column E as a date and column I as a plain number. Both Excel and Google Sheets accept these formulas as written.
How do you make sure the expiry does not slip past?
- Add a conditional format to column I that turns the cell amber when it is below 21 days and red when below 7. In both Excel and Google Sheets this is under the conditional formatting menu.
- Put the expiry date in your phone calendar the day you pay, with an alert three weeks before.
- When sessions left is more than the weeks left, book the remaining ones straight away instead of waiting for the next appointment to come up.
Where does the payment show up in your records?
A package is paid once but used over time, so your bank or card statement will show one large debit on the payment day. If you want a monthly view that looks fair, record the full payment on the day it left your account, and track the sessions in the package sheet separately. Do not spread the amount across months by hand unless you will keep that up.
If you import statements into SpendixAI, the package payment arrives as one transaction against the account you picked before importing, and you review the row before saving. You can give it a neutral category name of your own, and keep the sessions-used count in your package sheet.
A short checklist for every new package
- Add a row on the day you pay, with the receipt or message saved.
- Note the expiry date and set the calendar alert.
- Update sessions used after each visit, not at month end.
- Review the cost per session before you buy the next package and decide if a smaller one fits better.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


