How to Consolidate Accounting for 3 Restaurants Without Drowning
Moving from one location to three is a qualitative leap in management. It's not "three times the work"; it's different work. What you once did in your head ("this month the restaurant is doing well") now requires tools, judgment, and a bit of organization. Especially if you want to understand the group as a whole, not just each location separately.
Accounting consolidation for a hospitality group is an issue many operators face late and poorly: when they already have three locations open and discover they don't know where the monthly numbers are coming from. Let's avoid that moment.
What Exactly Does 'Consolidate' Mean?
There are three levels of consolidation, ordered from least to most complex:
**Visual Consolidation.**Each location maintains its own accounting independently. Once a month (or quarter), someone sums the key figures from all three into an Excel sheet to get a group overview. It's the simplest approach. It helps you get a general idea but isn't for making operational decisions.
**Managerial Consolidation.**Each location still has its own accounting, but there's a consolidated group dashboard with aligned KPIs (same period, same cost categories, same ratios). This allows you to compare locations with each other and see the group's performance.
**Formal Accounting Consolidation.**If the three locations are distinct legal entities but the group presents consolidated accounts due to a tax obligation or management decision, there's a formal accounting process involving the elimination of intercompany transactions, consolidation adjustments, etc. This is the work of an auditor or specialized accounting advisor.
For most small and medium-sized hospitality groups, managerial consolidation is the useful and realistic approach. Formal consolidation comes later, when there's an obligation or sufficient size.
The Minimum You Need to Start
For useful managerial consolidation, your three locations should have:
**1. Same Chart of Accounts.**If location A classifies oil as "Raw Materials" and location B as "Procurements > Oils," comparison is impossible. Define a single chart of accounts for the entire group and apply it to all three.
**2. Same Closing Dates.**If location A closes the month on the 30th and B on the 28th, monthly comparisons will be misleading. Agree on a uniform closing date.
3. Same KPI Definitions.Food cost: Is it calculated on sales including IVA or not? Does it include beverages or only food? Are spoilage/shrinkage deducted or not? Define it once for all three and apply it consistently.
**4. Centralizable Data.**Data from each location must be able to reach a single consolidation point. If A uses one software, B uses Excel, and C uses a kitchen program, consolidation will be manual and costly. The more uniform your tools, the easier it will be.
KPIs Worth Consolidating
Not everything is worth consolidating. These are the KPIs that provide useful information when viewed at the group level:
**Sales and Average Ticket.**Total group sales, sales per location, average ticket. Comparing locations (average ticket of location A vs. B) reveals differences in customer mix or concept.
**Food Cost per Location and Consolidated.**The key metric. If all three locations share the same concept, their food cost should be in similar ranges. Differences greater than 2-3% indicate something distinct: different suppliers, poorly applied recipes, uncontrolled spoilage.
**Labor Cost as a Percentage of Sales.**Another powerful indicator. A location with 35% labor cost and another at 30% for the same concept: there's a difference in productivity.
**Absolute Gross Margin.**For every euro sold, how much remains after product and labor costs. This is what covers fixed expenses and leaves profit.
**Table Turnover Rate.**In full-service restaurants, this indicates operational efficiency. Comparing between group locations during the same time slot reveals bottlenecks.
**Customer Loyalty Ratio (if applicable).**If you have a loyalty program or reservation system, what percentage of customers are recurring vs. new per location.
What NOT to Consolidate at First
Resist the temptation to consolidate everything from day one. Some data is only useful at the local level:
- Specific spoilage by kitchen section.- Individual employee productivity.- Order details.- Non-aggregable daily variations.
This data is better kept at each location. Bringing it into consolidation adds little value and multiplies the work.
The Typical Mistake: Starting with an Ambitious Dashboard
Many operators entering consolidation want to start with a comprehensive dashboard: 25 KPIs, evolution charts, double-entry comparisons. The project often fails in the first or second iteration because it's too costly to maintain.
The pragmatic approach:
**Month 1-3: 5 KPIs.**Just five. Total sales, food cost, labor cost, gross margin, average ticket. Each location calculates them. A consolidated sheet sums them up. That's enough.
**Month 4-6: Add 3-5 More.**Only after the first five are well-established, add the next ones. For example: table turnover rate, % of beverages over sales, top 5 products.
**Month 7+: Depth.**When the foundation is solid and maintained effortlessly, then yes: charts, comparisons, alerts. Not before.
This progression avoids the 'dashboard nobody looks at' syndrome because it becomes too cumbersome.
How It's Done Practically
The operational flow that works for small-to-medium groups:
First day of the month:- Each location closes and exports its data to the central system (manual or automatic).- Quick review at each location to ensure 'everything balances out'.
Day 3-5:- Consolidation: summing figures and calculating KPIs.- Comparison between locations: Is any location showing a significant deviation?- Comparison with the previous month and the same month of the previous year.
Day 5-7:- Management meeting (15-30 min) with the managers of the three locations.- Discussion of deviations and actions.- It's not for 'praising' or 'scolding'; it's for understanding what's happening.
Day 7-15:- Actions defined in the meeting are executed.- If there are issues requiring more in-depth analysis, specific reviews are scheduled.
This monthly cadence is realistic and useful. More frequent is too burdensome; less frequent is too late.
The Technology Piece
Without technology, consolidating three locations monthly is feasible but costly (4-6 hours monthly just for consolidation). With technology:
- Each location digitizes invoices and records sales in the same multi-organization system.- The system automatically aggregates data at the group level.- KPIs are calculated with uniform definitions without risk of error.- Comparing between locations is a single click.
A multi-tenant system, when you have multiple locations, ceases to be a convenience and becomes a necessity. The difference between 'three Excels' and 'a single consolidated view' is the difference between operating blindly and making data-driven decisions.
Conclusion
Consolidating the accounting for three locations isn't complicated if done correctly from the start: same chart of accounts, same dates, uniformly defined KPIs, common tool. Starting with 5 KPIs and gradually adding more avoids the useless dashboard syndrome.
The expensive part is always the initial setup: getting things in order. Once that's done, monthly maintenance drops to 1-2 hours if the system is appropriate.
If you have multiple locations and want operational consolidation with multi-organization OCR, Sincrio provides it natively.