Sports Club Finances: Membership Fees, Arrears, Budgets & Fundraising Events

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn the club's fee table and member counts into fee income per category, each category's share of income, and the average fee per member and per paying member.
• Price junior memberships per household with a second-child and third-child discount, apply a family cap, total the discount the club gives away and count the households that hit the cap.
• Look up the annual fee for each new member, count the months left in the season including the joining month, charge a pro-rata fee rounded up to a multiple of 5 with a minimum fee, and total the income from new joiners.
• Calculate what each member still owes, how many days the invoice is overdue on the report date, sort every invoice into an ageing bucket with IFS and total the oldest debts.
• Phase the annual budget to the months elapsed, calculate variances that are positive when they are good news for both income and expense lines, express them in % and flag the lines the committee must review.
• Calculate the contribution per team and the profit of a fundraising tournament, the number of teams needed to break even, the entry fee that reaches a profit target, and the profit per volunteer hour.
• Price each team's weekly pitch and hall hours, scale them to the season, share the club's overheads by players, work out the cost per player and count the teams that cost more than the review threshold.
• Build the club's monthly cash plan, find the closing balance at the end of the season and the lowest point in the year, chart income against expenses to show the seasonal pattern and name the month the club's reserve has to carry.