Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Produce the Monthly Figures Our Coaching Franchise Asks For Without a Weekend of Copying?
Problems We Solve

How Do We Produce the Monthly Figures Our Coaching Franchise Asks For Without a Weekend of Copying?

Kids' sports coaching franchisees rebuild monthly returns for head office by hand. We build returns drawn from your bookings and payments, checked by you.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Franchise returns take a weekend because head office wants participant numbers, sessions run and revenue in its own template, while your figures sit in the booking system, payment provider and accounts. We build a monthly return drawn from those sources in the franchisor's format, with the fee calculated by the rules in your agreement, for you to check before it is sent.

The template from head office

You run your territory as part of a children's sports coaching franchise. The brand, the programmes and the training come from head office. So does a monthly return: participants by programme, sessions delivered, schools and nurseries served, gross revenue, and the management fee or royalty that follows from it.

Your figures live elsewhere. Bookings and attendance are in the booking system the franchise uses, or one you chose. Income arrives through card payments, direct debits and school invoices in your accounts package. Some sessions are paid termly, some monthly. At the end of each month, you export, copy, total and paste into the head office spreadsheet. Some months head office queries a figure and you cannot remember how you arrived at it.

Why the return is so manual

  • The franchisor's template does not match how your booking system or accounts group things.
  • Revenue has to be counted the way your agreement defines it, which is not always the same as cash received.
  • Termly and monthly payments do not fall neatly into calendar months.
  • School and nursery contracts are invoiced separately from parent bookings.
  • Nobody keeps a record of how each month's figures were built, so queries are hard to answer.

What a manual return costs

A day or more each month of the franchisee's time, which is time not spent selling to schools or coaching. Errors that lead to paying the wrong fee, in either direction, and awkward corrections with head office. Queries that take hours to answer because the working has gone.

It also hides useful information. The same data that feeds the return could tell you which programmes and venues are growing in your territory, but it is only ever assembled for head office.

A return built from your own systems

  1. We connect to your booking system, payment provider such as Stripe or GoCardless, and accounts package such as Xero or QuickBooks, through their APIs or exports.
  2. The figures head office asks for are mapped to your data once: which programmes count as which category, and how revenue is defined in your agreement.
  3. Each month, the return is filled in automatically in the franchisor's template or portal format.
  4. The fee is calculated using the rules from your agreement as you and your accountant read them, and shown with its working.
  5. You review the draft, see how each figure was built, adjust anything unusual with a note, and approve it.
  6. Each approved return is stored with its working, so a query months later can be answered from the record.
Head office asks forComes fromChecked by
Participants by programmeBooking system and registersFranchisee
Sessions deliveredTimetable and registersFranchisee
Schools and nurseries servedContract recordsFranchisee
Revenue as defined in the agreementPayments and accountsFranchisee, with accountant if needed
Fee dueCalculated from the aboveFranchisee

We do not interpret your franchise agreement. The rules for categories and fees are confirmed by you, and your accountant where needed, before anything is automated.

Month end for a franchisee, afterwards

On the first working day of the month, the draft return is waiting. You look through it, notice a school invoice raised late last month that belongs in this one, add a note and approve. It is sent, or ready to paste into the head office portal, with the working kept.

When head office asks why nursery participants dropped in February, you open the stored return and see it straight away: two nurseries closed for a week of half term. The same data shows you which programmes grew in your territory this term.

Does your monthly return look like this?

  • You rebuild the head office return by hand each month.
  • Figures come from several systems that group things differently.
  • Termly payments make monthly revenue hard to work out.
  • Head office queries figures you cannot easily explain.
  • The return takes time you would rather spend selling or coaching.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does head office need to change anything?

No. We produce the return in the format they already ask for, or as a file ready for their portal.

Do you check our franchise agreement?

No. You and your accountant confirm how figures and fees are defined, and we apply those rules.

What if the franchise provides the booking system?

Many franchise booking systems can export data. We check what yours allows before starting.

Can it help with more than the return?

The same data can give you your own reports by programme, venue and school, if you want them.

Keep reading

More on Problems We Solve

Start here

Tell us which admin job eats your academy's evenings

Tell us about your academy: the sports, venues and age groups, how parents book and pay, and where the admin piles up. We will say what we would build and what we would leave alone, and if the booking system you already use can be set up to fix it, we will tell you.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →