How to set up a franchise royalty and fee schedule in software

Pull every active franchise agreement and its amendments, then read the fee clauses themselves instead of the summary table, because side letters change the rate for one outlet. The table rarely mentions them.

For each agreement, copy out the royalty basis, rate, minimum, marketing fund rate, renewal fee, transfer fee and payment terms, and note the clause number beside each one. Clause references pay off later.

When a franchisee questions a charge, the invoice can point to the exact paragraph, and a short list for the franchise lawyer covers any unclear wording. Ask whether the marketing fund is charged before refunds or after, and have the lawyer confirm it by email before you enter a rule. Software must not decide an ambiguous clause.

A rule has a name, a basis, a rate, a start date and an end date, and it lives apart from the invoice. When the rate steps down at month six, you add a new dated rule instead of editing the old one, which keeps every past statement reproducible.

Handle ramp-up periods the same way. An outlet may pay a reduced royalty until its twelfth month and the standard rate after that, so two dated rules sit on its record from day one.

Mark which fees run on sales and which are flat, because sales fees need a feed while flat fees need only a date, like an annual renewal. A dated rule leaves a clean trail when a franchisee asks what applied in March, a question that arrives sooner than you expect.

Royalties on sales need figures from the point of sale, so choose a daily upload, a weekly file or a direct connection to Toast, Lightspeed or Square. Decide which total counts. Gross, net of refunds and net of tax give three different royalty bills, so write the choice into the rule.

Set the billing day per agreement. Some franchisees pay weekly and some monthly, while others settle by direct debit on a fixed date, so store the mandate reference with the outlet. Wrong dates cause most early disputes.

Add a cut-off rule so that sales posted after it roll into the next period, and print the rule on each statement. Reconcile the feed against the till Z-report every week because a missing store, a duplicated upload or a shifted cut-off shows up there before it reaches an invoice.

Choose one closed month for three or four outlets, including one with an odd clause, and run the new schedule on that month’s sales. Compare each generated line with the invoice you sent then, and mark every gap by outlet and fee name on the comparison sheet.

Differences fall into three groups, namely a wrong rule, a wrong sales feed or an old manual error that nobody caught at the time. Fix the first two. Tell the franchisee about the third. Write down what you decided for each odd case, such as a refund processed in the month after the sale.

Keep the comparison sheet. It proves the two agree. If your ledger is Xero or QuickBooks, check that posted invoice totals match the generated schedule, and note any rounding rule you chose for fractions of a unit.

Start with a draft run in which finance reviews every invoice before release for the first two cycles, then release automatically and look only at flagged exceptions. Nothing else needs a human eye.

Set alerts for outlets with missing sales, negative totals or a royalty below the minimum, because these need a person rather than a rule. Require a second person to approve any rate edit, because a rate change is a contract change in practice, and keep the old version on file.

At the end of the first cycle, ask three franchisees whether the statement was clear, then adjust the layout where they stumbled. Add a remittance advice line that names the invoice, the period and the bank reference, so payments match without a phone call. Chasing stops.