Your Consolidated P&L Is Hiding Your Worst Location — And You Don't Even Know It
You look at your consolidated income statement. Total revenue across all locations: $4.2M, gross margin: 62%, net income: $310K. Everything looks healthy. You exhale.
But behind that single number, one of your seven locations lost $47,000 last quarter. Another one — your "busiest" site by revenue — is running at a 4% net margin while your quietest location is delivering 19%. Your highest-paid location manager is running the least profitable unit, and you have no idea because every location's numbers are blended into a single consolidated P&L that averages winners and losers into comfortable mediocrity.
This is the multi-location reporting problem. And if you're running a franchise network, a chain of clinics, a restaurant group, a service business with regional offices, or any business that operates across multiple physical sites, this problem is costing you more than you realise. Every. Single. Month. According to QuickBooks, 61% of small businesses already struggle with cash flow. Running multiple locations without visibility into each one makes that struggle far worse.
A consolidated P&L for a multi-location business is like checking the average body temperature of every patient in a hospital. The average might be 98.6°F, but that doesn't help you find the patient running a 104°F fever. Location-level P&Ls are how you find the fever — before it kills the patient.
- Why a Consolidated P&L Hides Location Problems
- How to Build Location-Level P&Ls
- Allocating Shared Costs Fairly
- Benchmarking Locations Against Each Other
- When to Close an Underperforming Location
- Franchise-Specific Considerations
- The Reporting Cadence That Drives Accountability
- Frequently Asked Questions
A consolidated P&L hides which locations are profitable and which are bleeding cash — your top performers subsidize weak ones while the overall number looks fine. Location-level P&Ls with controllable contribution margins expose cross-subsidization, drive manager accountability, and give you the data to decide whether to fix, restructure, or close underperforming units.
Why a Consolidated P&L Hides Location-Level Problems
A consolidated profit and loss statement does exactly what it says: it consolidates. It adds up every location's revenue into a single line, blends every location's cost of goods into a single percentage, and presents a single net income figure. For external reporting (investors, lenders, the IRS), this is fine. For managing the business, it's dangerous. According to the AICPA, nearly 60% of SMBs say understanding financial data is a challenge, and a consolidated view only makes that worse.
Here's what a consolidated P&L conceals:
Cross-Subsidisation Between Locations
Your strongest locations are subsidising your weakest ones, and the consolidated P&L makes it invisible. Location A generates $180K in quarterly profit. Location B loses $47K. The consolidated P&L shows $133K in profit and everyone thinks things are fine. But Location B is consuming management time, tying up capital in its lease and equipment, and dragging down your overall return on invested capital.
No Manager Accountability
If a location manager can't see the P&L for their specific site, they have no financial target to hit. They manage by gut feel, anecdotal feedback, and whatever metrics happen to be visible (foot traffic, covers served, appointments booked). But foot traffic without margin is just expensive popularity. Accountability requires visibility. You can't hold a manager responsible for profitability if they never see a profit number attached to their location.
Invisible Margin Erosion
Labour costs at one location creep up 3% over six months. Supply costs at another spike because the local manager is using a different vendor. Occupancy costs at a third location just increased because the landlord renegotiated. None of these show up clearly in the consolidated P&L. They're absorbed into the aggregate. But at the location level, each one would trigger an immediate variance investigation.
Misallocated Growth Capital
Without location-level profitability data, expansion decisions are based on revenue or gut instinct rather than return on invested capital. You might open your next location in a market similar to your highest-revenue site — when your highest-margin site is actually in a completely different type of market. Location-level P&Ls give you the data to replicate your best-performing model, not just your biggest one.
How to Build Location-Level P&Ls
Building location-level P&Ls isn't just about splitting revenue by site. It requires a deliberate chart of accounts structure, disciplined cost coding at the point of transaction, and a clear philosophy about what belongs on a location's P&L versus what sits at the corporate level.
Step 1: Structure Your Chart of Accounts by Location
Every accounting system worth using (QuickBooks Online, Xero, Sage Intacct, NetSuite) supports location or class tracking. Each location needs to be a distinct tracking dimension so that every transaction can be tagged to a site. This is not optional. If your bookkeeper is coding everything to a single entity with no location tags, you're building your financial reporting on a foundation that cannot support location-level analysis.
For businesses with 5+ locations, consider moving to a system like Sage Intacct or NetSuite that supports multi-dimensional reporting natively. QuickBooks and Xero can handle location tracking with classes or tracking categories, but they start to strain beyond 8–10 locations. Your management accounts are only as good as the underlying data structure.
Step 2: Classify Every Cost Line
Every expense on the location P&L falls into one of three categories:
- Direct location costs: Rent, on-site labour, local utilities, supplies consumed at that site. These are coded directly to the location with no allocation needed.
- Shared costs that can be allocated: Regional manager salary, shared warehouse, centralised marketing campaigns, group insurance premiums. These need an allocation methodology (covered in the next section).
- Corporate overhead: CEO salary, head office rent, group accounting fees, legal, corporate IT infrastructure. These sit below the "controllable contribution" line, visible on the location P&L for full cost transparency but clearly separated from the costs the location manager can influence.
Step 3: Define Your Location P&L Template
Every location should report against the same template. Consistency is what makes benchmarking possible. Here's the structure we use:
| Line Item | What It Includes | Who Controls It |
|---|---|---|
| Gross Revenue | Total revenue generated at or attributed to this location | Location Manager |
| Less: Direct COGS | Materials, supplies, direct labour costs for service delivery | Location Manager |
| = Gross Profit | Revenue minus direct cost of goods sold | Location Manager |
| Less: Location Operating Expenses | Rent, utilities, local marketing, on-site staff, insurance | Location Manager |
| = Controllable Contribution | Profit from items the location manager can directly influence | Location Manager |
| Less: Allocated Shared Costs | Regional management, shared services, allocated marketing | Corporate / Regional |
| = Location Operating Profit | Profit after all operating costs, before corporate overhead | Shared |
| Less: Corporate Overhead Allocation | Head office rent, executive compensation, group admin | Corporate |
| = Location Net Profit | Fully-loaded profitability of this location | Reference only |
Allocating Shared Costs Fairly Across Locations
Cost allocation is where most multi-location reporting falls apart. Allocate too aggressively and managers revolt because they're being charged for things they can't control. Don't allocate at all and you never see the true cost of operating each site. The answer is a layered approach.
Allocation Drivers That Actually Work
| Shared Cost | Recommended Allocation Driver | Why This Driver |
|---|---|---|
| Regional Manager Salary | Equal split across locations managed | Each location receives roughly equal management time |
| Centralised Marketing | Revenue percentage | Larger locations benefit proportionally more from brand awareness |
| Shared Warehouse / Distribution | Units shipped or square footage used | Reflects actual consumption of the shared resource |
| Group Insurance Premium | Headcount | Insurance cost scales with number of employees |
| IT Systems / POS Licences | Per-location flat fee or transaction volume | Each location uses one licence or a measurable share of the system |
| HR / Payroll Processing | Headcount | Processing effort scales with number of employees |
The Two-Line Rule
Every allocated cost should appear as two lines on the location P&L: the allocation amount, and the driver used. For example:
- Centralised Marketing Allocation: $4,200 (based on 14% of group revenue)
- IT Systems Allocation: $850/month (flat per-location fee)
This transparency prevents the "black box" problem where managers see a mysterious overhead charge they can't explain or challenge. When they can see both the amount and the basis, they can have an informed conversation about whether the allocation is fair, and whether the shared service is delivering value proportional to its cost.
Benchmarking Locations Against Each Other
Once you have location-level P&Ls on a consistent template, the real power emerges: benchmarking. This is where you stop asking "is this location profitable?" and start asking "is this location performing as well as it should be?"
The Five Metrics That Matter
Controllable Contribution Margin %
Controllable contribution divided by revenue. This is the percentage of every dollar of revenue that drops to profit after the costs the location manager controls. If your best location runs at 28% and your worst runs at 9%, you don't have a market problem. You have a management problem. Or a cost structure problem. Either way, the gap is the starting point for investigation.
Revenue Per Square Foot (or Per Seat, Per Bay, Per Chair)
Normalise revenue by the physical capacity of the location. A restaurant doing $1.2M in a 2,000 sq ft space is outperforming one doing $1.8M in a 5,000 sq ft space, even though the raw revenue number says otherwise. This metric exposes whether you're extracting maximum value from your real estate investment.
Labour Cost as % of Revenue
The single biggest controllable cost in most multi-location businesses. If one location runs at 32% labour cost and another at 41%, the 9-point gap is worth investigating. Is the high-cost location overstaffed? Paying above-market wages? Using too many senior staff for tasks that could be handled by junior employees? Or is it a lower-revenue location where fixed minimum staffing creates a mathematically unavoidable higher percentage?
Occupancy Cost Ratio
Total occupancy cost (rent, rates, utilities, maintenance, insurance) as a percentage of revenue. This tells you whether a location's physical cost structure is sustainable. For most retail and service businesses, occupancy should sit between 8% and 15% of revenue. Above 20%, the location needs to either dramatically increase revenue or negotiate its lease, because the real estate is eating the margin.
Trend Direction (3-Month Rolling)
A location's absolute margin matters less than its direction. A site at 12% contribution margin and improving is a better story than a site at 22% and declining. Plotting 3-month rolling averages for each location on a single chart gives you the clearest picture of which locations are gaining momentum and which are sliding, often months before the absolute numbers turn negative.
When to Close an Underperforming Location
This is the decision every multi-location operator dreads. Closing a location feels like failure. It means laying off staff, breaking a lease, admitting the original opening decision was wrong. But keeping an unprofitable location open because you're emotionally attached to it is more expensive than the write-off. According to the SBA, there are 33.3 million small businesses in the United States, and the ones that survive are the ones that make hard calls based on data. The location-level P&L gives you the data to make this decision with your head, not your heart.
The Three-Question Framework
Is the Location Unprofitable at the Controllable Contribution Level?
If a location is losing money before any corporate overhead allocation, the problem is fundamental. Revenue doesn't cover the costs that the location itself generates. This is different from a location that's profitable at the controllable level but shows a loss after corporate allocation. That's an allocation problem, not a location problem.
Is There a Credible Turnaround Plan?
A turnaround plan isn't "we'll try harder." It's specific actions with measurable outcomes on a defined timeline. Replace the manager or renegotiate the lease. Cut hours by 15%. Launch a local marketing campaign. Each action should have a projected P&L impact, and the total should move the location to breakeven within 90 days. If no combination of realistic actions can get there, the location has a structural problem that effort alone won't fix.
What Is the Opportunity Cost of Keeping It Open?
Every dollar of capital, management time, and operational attention tied up in an underperforming location is a dollar not deployed in a location that's working. If Location C is losing $6K/month and you have a potential new market where you could open a location with a projected $12K/month contribution, the real cost of keeping Location C open isn't $6K — it's $18K ($6K loss plus $12K forgone profit).
Franchise-Specific P&L Considerations
Franchise businesses, whether you're the franchisor managing the network or a multi-unit franchisee operating several locations, have unique P&L line items that company-owned locations don't carry. According to the IFA, the franchise industry contributed $860.1 billion to the U.S. economy in 2023, making accurate unit-level reporting critical for this sector. Ignoring these costs in your location-level reporting leads to a fundamentally misleading picture of unit economics.
Franchise-Specific Cost Lines
| Cost Line | Typical Range | P&L Impact |
|---|---|---|
| Royalty Fee | 4–8% of gross revenue | Sits above net profit; reduces margin available for local operations |
| Brand / Advertising Fund | 1–3% of gross revenue | Mandatory contribution to national/regional brand marketing |
| Technology / POS Fees | $200–$1,500/month | Mandated systems: non-negotiable, fixed cost per location |
| Training & Compliance | $2,000–$10,000/year | Required franchisee training, mystery shopper programs, audits |
| Local Marketing Minimum | 1–2% of gross revenue | Franchise agreement often mandates minimum local marketing spend |
For a franchise unit doing $800K in annual revenue, the franchise-specific costs alone — royalty (6%), ad fund (2%), technology ($800/month), and training ($5K/year) — add up to roughly $79,000 per year. That's $79K that a company-owned location in the same market wouldn't pay. This is why franchise unit economics must be evaluated separately from company-owned benchmarks.
Local Marketing: The Franchise Trap
Most franchise agreements require both a contribution to the national brand fund and a minimum local marketing spend. This means the franchisee is effectively paying twice for marketing: once to the brand (which may or may not deliver measurable local results) and once for their own local efforts. The location-level P&L should show these as separate line items so the franchisee can evaluate the ROI of each.
If the brand fund contribution is 2% of revenue and local marketing is another 2%, that's 4% of revenue going to marketing before any other expenses. For a location running at a 15% net margin, marketing represents more than a quarter of the total profit. Tracking the effectiveness of that spend (new customer acquisition cost, repeat rate, revenue per marketing dollar) is essential.
Royalty Impact on Break-Even
A 6% royalty fee directly raises your break-even revenue. If your location needs $50K/month in revenue to break even as a company-owned unit, the same location as a franchise unit needs roughly $53,200/month just to cover the royalty and still break even. This is simple maths, but we regularly see franchise operators who haven't modelled the royalty impact on their break-even point. They're using company-owned benchmarks for a franchise cost structure.
The Reporting Cadence That Drives Accountability
Location-level P&Ls only work if they arrive fast enough to act on. A location P&L delivered 45 days after month-end is a history lesson, not a management tool. Here's the cadence that drives real accountability:
- Weekly: Flash revenue and labour cost by location. Two numbers, one page. Every Monday morning. This is an early warning system: if revenue drops or labour spikes, you know within 7 days, not 30.
- Monthly (by day 5): Full location-level P&Ls with variance analysis against budget and prior month. This is the core management report. Every location manager should receive their P&L and be prepared to discuss it in a monthly review meeting.
- Monthly (by day 10): Location benchmarking scorecard ranking all sites by controllable contribution margin %, with 3-month trend arrows. This goes to the CEO/owner and regional managers.
- Quarterly: Deep-dive analysis of bottom-quartile locations. Is the underperformance structural or temporary? What's the turnaround plan? What's the exit cost if the plan fails?
This is exactly what a proper management accounts package delivers. Not just a P&L, but a P&L with context, comparatives, and commentary that tells you what happened, why it happened, and what to do about it.
What a Location-Level Management Accounts Package Includes
| Report | What It Shows | Delivered By |
|---|---|---|
| Location P&L (each site) | Revenue, COGS, controllable contribution, allocated costs, net profit | Day 5 |
| Consolidated P&L | Group-level performance with elimination of inter-company transactions | Day 5 |
| Location Benchmarking Dashboard | All locations ranked by margin %, revenue per sq ft, labour %, trend | Day 10 |
| Variance Analysis | Budget vs. actual and prior month vs. actual for each location | Day 5 |
| Cash Flow by Location | Where cash is being generated and consumed across the group | Day 10 |
| Underperformer Watch List | Bottom-quartile locations with turnaround status and timeline | Quarterly |
Want to see what this looks like in practice? Our multi-location management accounts sample shows the exact format, layout, and level of detail we deliver for multi-site businesses every month.
Frequently Asked Questions
What is a location-level P&L and why do multi-location businesses need one?
A location-level P&L is a profit and loss statement produced for each individual site rather than a single consolidated statement. Multi-location businesses need them because the consolidated view averages strong and weak locations together, hiding underperformance and preventing accountability. Without location-level P&Ls, you can't benchmark sites, hold managers responsible for financial results, or make informed decisions about expansion, investment, or closure.
How should shared costs like head office and central marketing be allocated across locations?
Use a cost driver that reflects each location's actual consumption of the shared resource — revenue for marketing, headcount for HR, square footage for warehousing. The critical principle is separating the P&L into a "controllable contribution" section (costs the location manager can influence) and an "allocated costs" section below it. This ensures managers are held accountable only for costs they can control, while still showing the fully-loaded profitability of each site.
When should I close an underperforming location?
Consider closure when the location has been unprofitable at the controllable contribution level for 6+ consecutive months, there's no credible turnaround plan that would reach breakeven within 90 days, and the capital and management attention tied up in the site could generate a better return deployed elsewhere. Always quantify the exit cost (lease termination, redundancy, equipment write-off) against the monthly cash flow improvement from closure — in most cases, the breakeven on exit costs is 4–8 months.
How are franchise P&Ls different from company-owned location P&Ls?
Franchise P&Ls carry additional cost lines that company-owned locations don't: royalty fees (4–8% of gross revenue), brand/advertising fund contributions (1–3%), mandated technology fees, and required local marketing minimums. These franchise-specific costs can total $60K–$100K per year for a mid-size unit, directly raising the break-even revenue threshold. They should appear as explicit, separate line items — not buried in general expenses — so franchisees can see the true unit economics after franchise obligations.