Franchisee Monthly Statement Of Account And Settlement

Appropriate adjustments re commission, marketing, product purchase (from franchisee) and resale (to customer) and so on as discussed. Following percentages based on monthly nett franchisee turnover
Management fee 15% subject to minimum amounts:
£100 year 1
£500 year 2
£1,000 year 3
£2,000 year 4
£2,500 year 5
Software fee lower of 1% and £200 per user account
Marketing 1%
Commission 15% if sale from lead generated by YSP (triggered by YSP_LEAD order field)
Credit/debit card fee 2.49% of gross payment amount (triggered by PMT_METHOD order field)
Fees are based on gross turnover – i.e. all franchisee invoices issued to franchisor

Prelude Desktop configuration:
Service items will be created in PD franchisor and franchisee companies for each of these fee types
A bespoke month-end processing form will be designed to analyse:
Franchisor invoices issued to franchisee
Franchisee invoices issued to franchisor
Service fees calculated as defined above
From the form, a statement of account will be produced and net settlement will be processed
The form will step through and process each franchisee company.