Start a new topic

Single Database vs. Multi Database

Leveraging R365 for your Franchisees can provide full transparency into your Franchisor/Franchisee partnerships.


Having all your locations in a single R365 database provides many benefits:


1.  Consolidated Financial Reporting and Billing

2.  Control over Purchasing and Inventory Databases

3.  Control over Product Mix

4.  Healthy Competition amongst Franchisees with the P&L Comparison Report

5.  Central Repository for Franchise Documentation and Communication


Allowing each Franchisee to maintain their own R365 database removes this transparency, however the burden of maintaining the database now falls on the Franchisee and is no longer the responsibility of the Franchisor.  


That being said maintaining the R365 accounting/operations database is typically associated with a monthly technology fee that is passed onto the franchisee and provides additional revenue.


While we lose insights into the Franchisee's financial health and purchasing we are able to maintain polling of the POS to monitor sales and product mix.  However if each Franchisee has a unique POS database then the responsibility for mapping the sales and payment types for the Franchise module billing will fall on the Franchisor.  We now have the ability to pull only the Net Sales which negates the need for any mapping, but we lose check level detail and therefore product mix in this scenario.


Ideally we want an Enterprise POS solution in place and a single R365 database for a truly scalable Franchise model.


Thanks Marc-


What are the difficulties you have seen with having Franchise locations included in a single database?

The biggest challenge is allocating Franchisor resources to maintain and manage the database.  The Franchisor needs to assume the role of gatekeeper for the R365 database and not all Franchise groups have the bandwidth for this.  But adding the cost of an R365 admin to the Franchisee billing can help offset the labor costs associated with managing and supporting the Franchisees.

Login or Signup to post a comment