Health and family

Personal trainer payments: a session package record

A personal trainer fee tracking record for session packages: sessions bought, completed, cancelled and rescheduled, so payments and sessions reconcile.

Editorial illustration for Personal trainer payments: a session package record

Sessions bought should equal done plus cancelled plus rescheduled plus remaining, at any moment. If they do not, the payment and the training have drifted apart. Keep one record per package with the package price, the number of sessions bought, and a dated row for every session: done, cancelled by you, cancelled by the trainer, or rescheduled.

What does the package record look like?

  • Package number, purchase date and amount paid
  • Sessions bought and the validity period, as written on the receipt or message
  • One row per planned slot: date, time, status
  • Status options: Done, Cancelled by me, Cancelled by trainer, Rescheduled
  • New date for any rescheduled slot
  • Cancellation terms, copied from what the trainer told you

Trainers often confirm bookings by message. Take a screenshot of the package confirmation, and save it with the sheet, since this is your evidence of what was agreed.

How do I reconcile payments with sessions?

Say you paid ₹24,000 for 20 sessions. That is 24,000 / 20 = ₹1,200 per session. After a few months your log shows the following. The figures are hypothetical.

StatusSessionsValue at ₹1,200
Done14₹16,800
Cancelled by me, not made up2₹2,400
Cancelled by trainer, to be rescheduled1₹1,200
Remaining and unbooked3₹3,600
Total20₹24,000

Check: 14 + 2 + 1 + 3 = 20 sessions, and 16,800 + 2,400 + 1,200 + 3,600 = ₹24,000. The one session cancelled by the trainer is still owed to you, so it should not be counted as lost. The two you cancelled may or may not be forfeited, depending on the terms you were given.

What if the trainer cancels or reschedules often?

Keep the status exact. A pattern of trainer cancellations is easy to forget but easy to see in a log. If three or four slots in a month move, you have a record to raise the matter politely, and to decide whether the package is working for you. Do not count a rescheduled slot as done until it has actually happened.

How do I count with a formula?

With the status in column C, =COUNTIF($C$2:$C$40,"Done") gives completed sessions. Remaining sessions are =B1-COUNTIF($C$2:$C$40,"Done")-COUNTIF($C$2:$C$40,"Cancelled by me"), where B1 is the package size, if your terms treat your own cancellations as used. If they do not, leave that part out.

What if I change trainers or gyms mid-package?

Ask in writing whether the remaining sessions can be transferred, refunded or used with another trainer at the same studio. Until you have an answer, mark the unused sessions as Pending in your sheet and write the date you asked. If the answer is no, record the value of the sessions lost, using the per-session price above, so that the cost of the change is visible when you choose a new trainer.

It also helps to note whether the package was bought for a goal with an end date, such as a wedding or a trek. If the date passes with sessions left, you will know straight away rather than months later.

How should the payment show in my monthly spending?

A package is usually paid in one go, so it looks like a large fitness expense in the month you paid. If you prefer, spread it across the months you expect to use it. When you pay by UPI or card, an uploaded statement in SpendixAI will bring the payment in, and you can tag it as fitness and attach the trainer's confirmation. Sessions themselves stay in your sheet.

Before buying the next package

  1. Count how many sessions of the last package were used
  2. Note how many were lost to cancellations on either side
  3. Compare the per-session price against what you actually got
  4. Ask for the terms in writing before paying
SPENDIXAI JOURNAL

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

Explore your reports