Gorilla Dash

Franchise financial reporting

Franchise financial reporting: every location, one set of numbers

Your locations run different POS, accounting and quoting systems. Gorilla Dash unifies their sales into one report, gives executives, field managers and franchisees the view each of them needs, and benchmarks every location so the numbers turn into action.

What is franchise financial reporting?

Franchise financial reporting is the collection of sales, cost and margin data from every location in a network into one set of numbers that head office, field managers and franchisees can all act on. A single business reports on itself from one till and one accounting file. A franchise reports on fifty or five hundred businesses at once, each with its own systems, its own owner and its own idea of what a sale is.

That is why so much franchise reporting is still a monthly spreadsheet. Locations email exports, someone at head office pastes them together, and the network report is ready three weeks after month-end with a third of locations missing and the figures already stale. It answers how the network did last quarter. It cannot answer which location needs a visit this week, or why.

Reporting built for a franchise solves three problems in order: it connects to the systems the locations already run and standardises what they produce; it shows each level of the business the slice it is responsible for, from the same data; and it benchmarks every location against the ones most like it, so a number becomes a comparison and a comparison becomes an action. The rest of this page walks through each of them.

The problem starts with the systems

A network rarely chose its systems all at once. Locations joined with the POS they already had, acquisitions brought their own, and every franchisee keeps their own accountant. The sales data head office needs is spread across all of them, in formats that do not add up.

Point of sale

Toast, NCR Aloha, and the POS a location chose before it joined

Every POS exports sales differently — gross here, net there, refunds as negative lines or as separate records, tax in or out. Two locations on two systems cannot be added together until someone decides what a sale means.

Accounting

Xero, QuickBooks, MYOB

Costs, labour, cost of goods and margins live in each franchisee’s own accounting file, categorised by whoever set it up. The chart of accounts differs from one location to the next, so a margin comparison starts with a mapping exercise.

Business management and quoting

Job management and estimating platforms used in signage, print and trades

In estimate-driven industries the sale is not a till receipt but a quote that becomes a job, then work in progress, then a completed invoice. The POS sees none of it, and the value of the pipeline is invisible to head office.

Online ordering and marketplaces

Online stores, ezCater and delivery platforms

Online and catering revenue arrives through a different system from walk-in sales, is often settled net of commission, and is easy to double-count when it also lands in the POS.

Memberships and branded stores

Recurring billing and store orders processed inside Gorilla Dash

Some revenue never touches the POS at all — membership renewals, subscription packages and orders from a branded online store. It is already in Gorilla Dash, but it still has to be counted once, against the right location, alongside everything else.

Spreadsheets and emailed exports

The monthly figures a franchisee keys in by hand

The fallback for everything that is not connected. Late, incomplete and unverifiable — the network report is only as complete as the last franchisee who replied.

How Gorilla Dash turns them into one set of numbers

The standardisation happens once, inside the platform, so it never has to happen again in a spreadsheet.

  1. 1

    Connect

    Each location connects the systems it actually runs — a POS, an accounting file, a job-management platform, an online store — through built-in integrations, Zapier or the open API. A network can have three POS platforms across its locations and still report as one.

  2. 2

    Standardise

    Every sale is brought into one data model: gross and net, refunds, tax, the products sold, the customer who bought and the location it belongs to, stored in the location’s own timezone and currency. From then on revenue means the same thing at every location, whatever system produced it.

  3. 3

    Attribute

    Sales are matched to the people, enquiries, tracked calls and campaigns that produced them, so the number on the report carries its cause. A campaign is reported by the revenue it made at each location, not by its clicks.

  4. 4

    Monitor

    Every connection’s health is watched. A feed that stops syncing is flagged on the connection status report before the month-end report is wrong, and the location knows exactly which system to look at.

The views each level of the network needs

The same sales data answers a different question at each level. The mistake most reporting makes is giving everyone the executive view, or giving everyone a spreadsheet.

Top executives

CEO, CFO, franchise leadership, the board

“Is the network growing, and where is it not?”

  • Network revenue, growth and margin against target, by region and format
  • The ranked list of locations, top and bottom, with the movement since last period
  • Marketing fund revenue and cost per acquisition by campaign and channel
  • A scheduled weekly and monthly report delivered by email, from the same data

What changes

The board pack becomes a filter on a dashboard rather than a three-week project, and the question in the meeting is what to do about a region, not whose spreadsheet is right.

Field managers

Territory, regional and area managers

“Which of my locations needs help this week, and why?”

  • Every location in the territory ranked against the region and the network
  • Side-by-side comparison of two or more locations, like for like
  • The funnel behind the number: enquiries, calls, conversion, average sale, reviews
  • A territory report delivered before the week’s store visits

What changes

A store visit opens with the location’s own numbers already on the screen, and the coaching conversation starts from the cause of a gap rather than from an opinion about it.

Locations

Franchisees, store managers, their teams

“How am I doing, and where do I stand against the network?”

  • Sales, targets, work in progress and products sold for their own location
  • Their position against the network and peer-group benchmark
  • Revenue by lead source, so they know which channel to feed
  • The same figures head office and the field manager see

What changes

The benchmark stops being a judgement handed down at the quarterly review and becomes a daily tool the owner uses, because it is built from data they can see and trust.

One metric, three views

Every row is the same underlying number, scoped to the person reading it. Permissions decide the scope; nobody is looking at a different version of the figures.

MetricTop executivesField managersLocations
RevenueNetwork, region and format totals against targetEach location in the territory, rankedOwn location against its target and the benchmark
GrowthPeriod on period, same-store and new locations separatedWhich locations are moving up or down, and since whenOwn trend, week by week and month by month
Margin and costsNetwork margin, and the regions carrying itCost and labour outliers to visit firstOwn costs against the peer-group benchmark
PipelineEstimate value and conversion across the networkWho quotes fast, who lets quotes dieOpen estimates, work in progress, completed jobs
Marketing returnFund revenue and cost per acquisition by campaignWhat the national campaigns produced at each locationRevenue by source, campaign and referrer
Data healthHow many locations are connected and currentWhich locations have a stale feedWhether their own systems synced today

One sales report, followed through the network

What a week looks like when every level is reading the same numbers. The locations, the region and the gap are illustrative; the sequence is how the reporting is designed to be used.

  1. Monday, 7:00 am

    Head office

    The weekly report arrives before anyone asks for it

    The network sales report lands in the inboxes of the leadership team and every territory manager, built overnight from the POS, accounting and job-management feeds of every connected location. Nobody emailed an export. One region is four percent behind the same week last year; the other three are ahead.

  2. Monday, 7:20 am

    The CEO

    One click from the region to the locations

    The region is a group of locations defined once and reused across every report, so the CEO opens it and sees the ranked list. Two locations account for the whole gap. The rest of the region is fine. The question for the territory manager is already specific.

  3. Monday, 9:00 am

    The territory manager

    The cause, not just the number

    Comparing the two locations side by side against their peers shows that enquiries and calls are up at both — the marketing is working. Conversion from estimate to sale is down at one, and average sale value is down at the other. Two different problems that a revenue total made look the same.

  4. Tuesday

    The franchisee

    The same numbers on both sides of the table

    The store visit starts from the location’s own dashboard: the owner has already seen the conversion drop and knows which quotes went cold. The conversation is about follow-up, not about whether head office’s figures are right. The agreed actions are logged against the location.

  5. The following month

    Everyone

    The benchmark shows whether it worked

    Conversion at the first location is back with its peers; the second is still behind and moves up the visit list. The monthly report says so without anyone assembling it, and the region is reported ahead. The numbers were a shared fact from the first morning, which is why the fix took a month instead of a quarter.

Benchmarking that locations trust

A revenue total tells you a location is behind. A benchmark tells you by how much, against whom, and where in the funnel the gap opened — and only works when the franchisee believes it.

Like for like, not one league table

Locations are grouped once — by region, format, size, opening cohort or any grouping the brand uses — and the groups are reused in every dashboard, report and scheduled email. A kiosk is compared with kiosks, a new opening with other new openings, and the network view is one filter away.

Sales and the operating metrics behind them

Revenue, growth, margin and costs are benchmarked next to the numbers that usually explain them: enquiries, call answer rates, conversion, average sale, review scores and response times. A location that is behind on revenue shows where in the funnel the gap opened.

Scoped by role, from one benchmark

Each franchisee sees their own location against the network and their peer group. Head office and field managers see every location by name, scoped to the territory they are responsible for. The same benchmark, with permissions deciding how far each person can see.

Built from data both sides trust

The benchmark is only useful if the franchisee believes it. Because it is computed from the location’s own connected systems, on the same data model as everyone else, there is no version of the numbers to argue with — only the question of what to do about them.

Two sales numbers, on purpose

Gross sales are everything a location sold, straight from its connected systems. Attributed sales are the subset Gorilla Dash can trace back to a person, a web enquiry, a tracked call or a campaign. The two are reported separately because they answer different questions: gross tells you how the location is doing, attributed tells you what the marketing produced.

The marketing fund stops being argued about in impressions and clicks when every campaign is reported by the revenue it made at each location.

Because the leads, calls and campaigns live in the same platform as the sales, the attribution is a report rather than a data-engineering project. Every lead carries its source through the CRM to the sale; the sale is joined to the POS or job-management record; and lead sources and campaigns are reported by revenue and cost per acquisition, per location, per month.

The sales reports you get

Each one is documented step by step in the Help Centre, so your team can read how a report is built before they trust it.

The sales dashboard

Headline revenue, targets and trend for the network, a group, or one location, with the drill-down underneath

Read the guide

Comparing your locations

Every location ranked and compared like for like, the report field managers open before a visit

Read the guide

What you actually sold

Revenue by product and category per location, so a menu, range or service change is measured rather than guessed

Read the guide

Work in progress

Open estimates, jobs in progress and completed work for estimate-driven industries, with conversion and time to close

Read the guide

The transactions list

Every sale behind a total, searchable, with the customer, source and system it came from

Read the guide

Attributed and gross sales

Two deliberate numbers: the revenue your marketing can claim, and the revenue the location made

Read the guide

Custom dashboards

Dashboards built from the same data for the questions specific to your brand, scoped to a group of locations and shared by role

Read the guide

Connection status

Which locations are connected, which systems synced today, and which feeds need attention before the report is wrong

Read the guide

What Gorilla Dash brings to franchise financial reporting

Financial reporting is one module of the platform that runs the rest of the network, which is why the sales data can be joined to the leads, calls, campaigns, reviews and support that explain it.

One set of numbers, however many systems

Three POS platforms, two accounting packages and a quoting tool still produce one network report, because the standardisation happens once, in the platform, rather than every month in a spreadsheet.

The report is ready the morning after

Connected systems sync automatically, typically daily or better, so the network view is current when the week starts — not three weeks after month-end with a third of locations missing.

Every level sees its own slice of the same data

Executives, field managers and franchisees are looking at one source, scoped by role. There is no reconciling meeting, because there is nothing to reconcile.

Marketing is judged by revenue

Leads, calls and campaigns live in the same platform as the sales, so the marketing fund is reported by what it produced at each location. The fairness argument ends at the report.

Problems surface in days, not quarters

A location that slips shows in the weekly benchmark, with the funnel metric that caused it. The field manager visits the right store, for the right reason, this week.

A new location is data, not a project

When a location connects its systems it appears in every report, group and benchmark from that day. Nothing is rebuilt when the network grows or a franchisee changes hands.

Franchise financial reporting — frequently asked questions

What is franchise financial reporting?

Franchise financial reporting is the collection of sales, cost and margin data from every location in a network — each with its own POS, accounting file and owner — into one set of numbers that head office, field managers and franchisees can all act on. What makes it different from ordinary financial reporting is the comparison: not just how a location is doing, but how it is doing against the network and the locations most like it.

Our locations use different POS systems — can they be reported together?

Yes. Each location connects the system it actually runs, and Gorilla Dash brings every sale into one data model — gross, net, refunds, tax, products and customer — so a location on one POS and a location on another are compared like for like. Networks that inherited several POS platforms through acquisitions or franchisee choice report as one network from the day the connections are made.

Which systems does it connect to?

Restaurant POS and ordering platforms including Toast, NCR Aloha and ezCater, accounting platforms, and the business-management and quoting platforms used in estimate-driven industries such as signage and print, plus Salesforce, Zoho, Zapier and an open API. Several production integrations began as one network asking whether we could connect to theirs — ask us about the systems your locations run.

What do executives, field managers and franchisees each see?

The same data, scoped by role. Executives see the network by region and format against target, with the ranked list of locations and the marketing fund reported by revenue. Field managers see every location in their territory ranked and compared, with the funnel metrics behind each number. Franchisees see their own location against target and the benchmark. Permissions decide the scope; nobody is looking at a different version of the figures.

How does benchmarking work?

Locations are grouped once — region, format, size, cohort — and every report and dashboard reuses the groups, so a location is compared with the locations most like it as well as with the network. Revenue, growth, margin and costs are benchmarked next to enquiries, conversion, average sale and reviews, so the cause of a gap is visible. Permissions decide the scope: a franchisee sees their own location against the benchmark, and head office and field managers see every location by name.

What is the difference between attributed and gross sales?

Gross sales are everything the location sold, from its connected systems. Attributed sales are the subset that can be traced to a person, enquiry, tracked call or campaign in Gorilla Dash — the revenue your marketing can claim. They are reported separately on purpose: gross tells you how the location is doing, attributed tells you what the marketing produced, and the two should never be added together or confused.

How fresh are the numbers?

Connected systems sync automatically, typically daily or better depending on the source, so the report is current the morning after. Each connection’s health is monitored and a stale feed is flagged on the connection status report, so a location whose POS stopped syncing is noticed before its numbers are read as a downturn.

Can franchisees see other locations’ figures?

Only what their permissions allow. A franchisee sees their own location and their position against the network and peer-group benchmark. Head office and field managers see locations by name, scoped to the territory they are responsible for. Visibility upward never means every owner seeing every other owner’s books.

Do we still need a BI tool or a finance analyst?

The hard part of franchise reporting is not the chart but connecting, standardising and permissioning a hundred businesses’ data every day, and that is what the platform does. Custom dashboards cover the questions specific to your brand, and scheduled reports deliver them. If you have an analyst, they spend their time on the questions rather than on the collection; if you do not, you do not need to hire one to get a network report.

What does franchise financial reporting cost?

Financial reporting, benchmarking, custom dashboards and scheduled reports are part of the Gorilla Dash base platform at USD $52 per location per month, with unlimited team members — so executives, field managers and every franchisee can see their numbers without a per-seat licence.

See your network on one set of numbers

Bring the systems your locations run and we will show you what the network report, the territory view and the franchisee dashboard look like on Gorilla Dash — book a demo with our team.

Book a Demo