How to organise a franchise cost schedule

For franchise opportunities, a cost schedule is useful when a reader can trace each amount to a document, a quote or a dated official rate, and can see when payment leaves the business. A headline total cannot do that alone. This is a method for organising evidence and timing, not a priced estimate for a particular franchise. Keep unresolved items visible, so a provisional allowance is not mistaken for an agreed liability.

Recording an advertised entry amount

Weak version. An advertised entry amount can be mistaken for the cash needed to trade even when local property, fit-out and staffing costs remain unpriced. If the estimate omits its source, date and owner, a provisional allowance may look as certain as an agreed payment or written supplier price.

Better version. Replace the headline with a line-by-line record. For every amount, note its source, when that source was checked, the payment date, whether it recurs and who will resolve any gap. Keep unanswered costs visibly provisional. The budget model can sit beside, not substitute for, this record.

Assigning costs to payment periods

Weak version. Grouping everything as start-up or ongoing gives too little timing detail. It can place legal work, reservation money, purchases before trading, monthly bills and later transfer or renewal payments in broad buckets, making the cash required at a particular point difficult to see.

Better version. Use contract wording, property papers and supplier terms to assign each amount to the period when it is payable. Keep one-off purchases apart from recurring bills and later transfer or renewal charges. The following layout groups costs by payment period; add a source and due date to every line.

This grouping is a filing aid, not a price estimate. Keep each cost attached to its own evidence and payment point, so a delayed opening does not shift a recurring bill by assumption. If terms are unclear, leave the date unresolved and name the person who will confirm it.

Tax and pay without shortcuts

Weak version. Applying one VAT percentage to every line, then treating all tax as reclaimable, confuses supplies that may have different treatment.

A rounded staff headcount is equally weak: it hides paid hours for cover, training and holidays, and fails to show whether gross cash and employment costs have been supported.

Better version. Apply the relevant VAT treatment to each supply: the standard rate is 20%, the reduced rate is 5%, and the zero rate is 0%, while some financial and property transactions are exempt. Leave gross amounts in the cash forecast until an accountant confirms whether VAT is recoverable for each line, including fees, vehicles, property costs or mixed activity.

Registration or a displayed VAT amount does not by itself confirm that the buyer can reclaim it. A VAT-registered supplier must show VAT separately on a VAT invoice and include its VAT number. Keep that invoice and the supporting VAT records with the corresponding schedule entry, so the amount and treatment can be checked together.

Build payroll from opening hours, minimum cover, holidays, training and management time. Multiply paid hours by the applicable wage rate, then add employer costs. The published minimum wage rates change on 1 April each year; check the rate for the relevant pay period and record the date checked.

A quote with a shelf life

Weak version. Treating a spoken indication and a written price as equivalent can leave an allowance in the forecast after its source has lapsed. Without a named supplier, defined work, payment timing, VAT basis and expiry date, the schedule cannot show whether a number is documented or still usable.

Better version. Request written prices from a qualified building surveyor, commercial letting agent, shopfitter and equipment supplier. Keep verbal indications outside the quoted total in a visible gap column. For each written price, record the payee, scope, payment point, VAT basis, gross cash, expiry, recurrence and the person responsible for checking it.

Contract payments in separate boxes

Weak version. Combining the initial fee, royalty, marketing contribution and other payments into one franchise-cost line hides separate due dates. It may also conceal whether one payment includes a distinct item, such as staff training, that could need separate tax consideration.

Better version. Turn each payment in the agreement clauses into its own entry, with amount, payee, scope, territory, due date and instalment terms. Keep the initial payment, royalties, continuing charges and marketing contributions separate. Compare fee models by how charges are calculated, and use vendor due diligence for related commitments.

An initial franchisee payment is usually capital, as are related legal fees. The HMRC franchising manual says capital payments cannot be deducted when calculating taxable trade profits. If the contract assigns part of a payment to a potentially allowable expense, such as staff training, ask an accountant whether apportionment applies and keep any agreed split separately.

Premises bills without one catch-all

Weak version. Combining the property deposit, rent and maintenance into a single premises allowance can conceal who carries a repair duty and when local bills fall due. It also leaves no separate schedule lines for the costs attached to the business property.

Better version. Record the deposit separately from rent, service charge, utilities, repairs, insurance and business rates. Responsibility for repair and maintenance can depend on lease wording, so ask a surveyor and solicitor to compare the cost plan with the lease terms. Give every premises item its own amount, source and payment date.

Business rates apply to most non-domestic properties, including shops and offices. Councils send the bill in February or March for the following tax year, so show it as a recurring entry with its own payment date. Do not enter business rate relief as a saving until supporting evidence has been obtained.

A delayed opening on the calendar

Weak version. Placing every amount in one opening total and relying on a central forecast can hide the lowest cash balance. Rent, wages and loan payments may fall due before the delayed opening or expected sales ramp, while a credit facility may not remain available for the period assumed.

Better version. Put dated entries into monthly cash columns and compare cumulative balances in a central forecast with a downside case. Delay the opening and sales ramp in that case, but leave rent, wages and loan payments in their original periods unless documents allow a change. Show contingency separately rather than using it to disguise scheduled commitments.

The lowest cumulative balance is the funding requirement. Check expiry dates for property terms, equipment prices and lender offers; replace expired amounts in both forecasts instead of presenting them as current. Show an unused credit facility only for the period stated in its terms, and note the effect of unresolved prices beside the person assigned to obtain them.

Use downside scenarios to label allowances and run an omission check before committing. Do not calculate return on investment from incomplete costs. Revisit the calculation when quotes or contract terms change, so the result reflects the current schedule rather than an earlier set of assumptions.