Health and family

Badminton courts, swimming and coaching: a sports fees tracker

A sports activity expense tracker for court bookings, pool entry, coaching and equipment, for an adult player or a child's weekly activity.

Editorial illustration for Badminton courts, swimming and coaching: a sports fees tracker

A sports fees tracker needs four kinds of rows: court or pool charges, coaching fees, equipment and travel. Log each one by date and activity, mark who it was for, and total them by month and by sport. After three months, you will know what badminton, swimming or coaching actually costs per week, and whether the habit suits your budget.

What does the tracker sheet contain?

  • Date
  • Activity: badminton, swimming, cricket coaching and so on
  • Type: court booking, pool entry, coaching, equipment, travel
  • Who it was for, useful if a child and an adult both play
  • Amount you paid in rupees
  • Payment mode and receipt status
  • Note: for example the number of players sharing a court

Keep one sheet for the whole family and filter by person or by activity, rather than creating separate files that nobody updates.

How do I handle shared court bookings?

Record only your own share. If four of you book a court for ₹400 an hour and split it, your row is ₹100, even if you paid the whole amount at the counter and collected the rest by UPI later. Write the full figure and the split in the note column, so that you can check that the collection matched. SpendixAI is not a bill-splitting tool, so settle the split among yourselves and then record your share.

What does a month look like?

Say an adult plays badminton twice a week and a child has swimming coaching. The numbers are invented for the illustration.

ItemWorkingAmount
Badminton court, your share8 bookings x ₹100₹800
Pool entry for the adult4 visits x ₹150₹600
Child's swimming coachingmonthly fee₹1,800
Shuttlecocksone tube₹500
Month total800 + 600 + 1,800 + 500₹3,700

To total by activity with the activity in column B and the amount in column E, use =SUMIFS($E$2:$E$300,$B$2:$B$300,"Badminton"). Change the text for each sport.

What about equipment, which is lumpy?

Rackets, goggles, shoes and kit are bought rarely and cost a lot at once. Log them on the purchase date, with a note on the expected life, for example a racket restrung each season. If you want a smoother view, divide the cost by the months you expect to use it, and keep the real transaction date in your records.

How do I plan for the festival and holiday months?

Courts and pools often get busier, closed or more expensive around school holidays and festival weeks, and academies may run summer camps with separate fees. Add a row for each camp or special batch and label it clearly, so that one-off costs do not distort your normal weekly figure. When you review a year, you will see which months were heavier and can set aside money for them next time.

Is the sport worth the cost for a child?

Only you can decide that, but numbers help the conversation. Add up the fees, kit and travel for a term and divide by the number of sessions attended, the same way you would for a gym. Be aware that fees are often paid for a block, so an absent child still costs the same. Look at attendance and enjoyment together with the figure.

Can I get the tracker out of a statement?

Partly. UPI payments to a court or academy will appear in an uploaded bank or card statement, and you can categorise them as sports or fitness. Cash payments at a pool counter go in by hand. In SpendixAI, a report grouped by category shows the monthly total, and sub-categories for each sport give you the split by activity.

End-of-term checklist

  1. Total each activity for the term
  2. Check coaching receipts against the months paid
  3. Note any equipment likely to be replaced soon
  4. Decide which activities continue and which pause
SPENDIXAI JOURNAL

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

Explore your reports