Franchise royalty management
without the monthly spreadsheet.
Franchisees submit their figures once. The royalty calculates itself against that location's rate and the invoice generates, corporate reviews, and locking the period freezes it for good. Every number traceable back to who submitted it and when.
LynkPilot calculates franchise royalties from the monthly operating reports franchisees submit, using either gross revenue or gross margin as the basis for the brand, applying the rate set for that location, and generating the invoice automatically. Corporate reviews the period and then locks it, which freezes the figures for good.
It is built for wellness networks where royalty terms are not uniform: legacy rates for early franchisees, negotiated territory terms, and margin based bases that a generic franchise tool cannot model.
Key takeaways
- Structured submission, not email. Franchisees enter figures into a validated form in their own portal, which timestamps exactly what was reported.
- Gross revenue or gross margin. The royalty basis is set per brand, so margin based networks are a first class case rather than a workaround.
- Rates per location. Legacy rates, territory terms, and volume schedules all coexist without a separate spreadsheet each.
- Period lock. Approved figures freeze, so nothing moves retroactively and disputes have a single answer.
- One audit trail. Submission, review, calculation, and invoice all sit on the same record.
Why spreadsheet royalties stop working around five locations
Spreadsheets are genuinely fine for two or three units and one person doing the math. The failure is not carelessness, it is that the model stops fitting the business.
The break happens when the network stops being uniform. Different franchisees hold different rates depending on when they signed. A margin based basis means the calculation now depends on cost of goods, not just revenue. Regional managers need to see their own locations without seeing everyone else's. And somebody has to be able to prove, months later, what a franchisee actually reported in March.
A spreadsheet can be made to do any one of those. It cannot do all of them at once and stay trustworthy. What follows is familiar to anyone who has run it: formulas that silently stop covering a new row, figures that change after the fact with no record of who changed them, and a monthly cycle where the finance team spends more time chasing submissions than reviewing them.
What the royalty engine actually does
1. The franchisee submits
Operators enter their period figures in their own portal against a form that validates as they go. No spreadsheet attachment, no retyping on the corporate side, and a locked record of what was submitted and when.
2. The royalty calculates
On submission the engine applies that franchisee's configured rate to the configured basis. No formula maintenance, and no possibility of two locations being calculated with two different versions of the same rule.
3. Corporate reviews
Submitted figures are visible before anything is final. If a number looks wrong, flag it and send it back rather than discovering it in a dispute two quarters later.
4. The period locks
Approval freezes the figures and the royalty derived from them. This is the step spreadsheets cannot really replicate, and it is the one that makes the number defensible.
5. The invoice generates
Invoices are produced from the locked figures and are visible to the franchisee in their portal alongside their own calculation breakdown and payment history.
Gross margin as a royalty basis, not an afterthought
This is the part most franchise software gets wrong for wellness, because it was built for categories where revenue and margin track each other closely.
Traditional franchising calculates royalties as a percentage of gross revenue, and for a category with thin product cost that is a reasonable proxy for the value the franchisee is getting. Clinical wellness does not behave that way. A med spa doing $200,000 in a month against $160,000 of product and clinical labor is a very different business from a cryotherapy studio doing $200,000 against $40,000 of cost, and a revenue based royalty charges both the same.
That is why a growing share of wellness franchisors now set royalties against gross margin. It is fairer to the franchisee, and it survives the introduction of a high cost service line without renegotiating every agreement. It also makes the calculation harder, because the system now has to understand revenue, cost of goods, and the margin between them, and has to show all three to both sides.
LynkPilot treats the basis as brand level configuration. A network runs on gross margin or on gross revenue, the full breakdown stays visible to corporate and to the operator, and the choice does not change how any other part of the workflow behaves. For the wider picture on where rates land across the category, see the franchise royalty rate guide.
Spreadsheets, generic franchise software, and a wellness specific engine
An honest comparison. Generic franchise platforms do real work here; they were simply designed around a different kind of network.
| Spreadsheets | Generic franchise software | LynkPilot | |
|---|---|---|---|
| Royalty basis | Whatever the formula says | Usually gross revenue only | Gross revenue or gross margin, set per brand |
| Rates per location | A tab per operator, maintained by hand | Often supported | Brand default with a per location override, applied every period |
| Franchisee submission | Emailed file, retyped on receipt | Portal, varies by product | Validated form in the operator portal |
| Period locking | Not really possible | Varies | Approval freezes figures and calculation |
| Audit trail | File history at best | Varies | Submission through invoice on one record |
| Built for | Two or three locations | Food, retail, and services at scale | Multi-unit wellness and recovery brands |
What the franchisee sees
The operator side is the part that decides whether any of this actually reduces work, and it is the part that tends to get built last.
When a franchisee can submit their own numbers, see their royalty broken out clearly, track what is outstanding, and check their compliance status without calling anyone, two things happen. Submissions arrive faster, because the path of least resistance is now the correct one. And disputes drop, because the operator has already seen the arithmetic before the invoice lands.
That is the real return on a royalty engine, and it is easy to miss when evaluating on feature lists. The hours saved on the corporate side are straightforward to count. The calls that never happen are larger and harder to see.
Royalty questions
What is franchise royalty management software?
Franchise royalty management software calculates the ongoing fee each franchisee owes the franchisor, based on revenue or margin figures the location reports for a given period. It replaces spreadsheet formulas and email chains with a structured submission form, an automatic calculation against the agreed rate for that location, a corporate review step, and generated invoices with a full audit trail.
Can royalties be calculated on gross margin instead of gross revenue?
Yes. The royalty basis is configured per brand, so a network can run on gross revenue or on gross margin. Margin based royalties are increasingly common in med spa, IV therapy, and aesthetics franchising, because a location doing high revenue on high product cost is hit much harder by a revenue based royalty than a margin based one. Both bases keep the full revenue and cost breakdown visible to corporate and to the franchisee.
Does it handle different royalty rates for different franchisees?
Yes. Each brand sets a default royalty rate, and any individual location can carry its own negotiated rate as an override. That is what growing networks actually need: legacy rates for early franchisees, negotiated territory terms, joint venture units, and locations on a temporary concession. The override is configured once and then applied automatically every period.
How does period locking work?
Once a franchisee submits their figures for a period, corporate can review them before anything is final. If a number looks wrong it can be flagged and sent back for correction. Locking the period is a separate, deliberate step after review, and it freezes the submitted figures and the royalty calculated from them. A locked period cannot be reopened, which is what makes the numbers defensible in a dispute.
Do franchisees have to email a spreadsheet every month?
No. Franchisees log into their own portal and enter figures into a structured form with validation, which removes transcription errors and timestamps exactly what was submitted and when. They can also see their own royalty calculation broken out, their invoice history, and what is outstanding, which is what cuts down on calls to the corporate finance team.
Does the royalty engine connect to accounting?
LynkPilot connects to QuickBooks, and financials can be imported rather than retyped. It is deliberately POS agnostic, so locations keep whatever booking or point of sale system they already run. The royalty engine works from the reported period figures, not from a specific POS integration, which is what lets a network with mixed systems run one consistent royalty process.
How long does it take to move off spreadsheets?
Setup is configuration rather than development: import your locations, set the royalty basis and each brand default rate plus any per location overrides, and open the portal to operators. Most networks start with a pilot region for a period or two before extending to the full network, so the first royalty run happens against a small group while everyone learns the workflow.
The rest of the platform
Run one royalty period with us.
Book a walkthrough and we will configure your actual basis and a couple of your real franchisee rates, then run a period against them so you can see the arithmetic on your own network.
Request a Demo →