F&B Group Consolidation in Xero: 7 Edge Cases We've Built For

It's the fourth working day of the month at a restaurant group. The finance manager has nine Xero files open, one per company, for twelve venues. Three venues share one company and are split by a tracking category. One has an operating partner who takes 40% of its profit. A guest paid for dinner at the bistro with a gift card bought at the rooftop bar, and the delivery platforms paid out net of commission.

Adding up nine P&Ls takes ten minutes. Everything else takes the week.

That's F&B group consolidation in Xero: the sum is easy, and the work is in the edge cases. Below are seven of them, from consolidations we've built for F&B groups: a high-end hospitality group, a quick-service salad franchise and a nine-company restaurant group. We've left out names and anything from their books, and every number is invented. Each edge case is one those builds handle today.

For the wider F&B reporting picture (food cost, labour, prime cost), see what good Xero reporting looks like for F&B operators. This post sticks to the group view.

Why an F&B group consolidation isn't just adding up companies

A textbook consolidation maps each company to one chart of accounts, adds them up and removes what the companies charge each other. Our multi-entity consolidation guide walks through that part. F&B groups break the textbook in four places:

• The unit people manage is the outlet, not the company. Outlets and companies rarely line up one to one.
• Money crosses venues. A central kitchen supplies the outlets, head office charges a management fee, and a gift card sold in one venue is spent in another. Each is income in one place and a cost in another, and has to cancel out in the group (how eliminations work).
• Sales arrive through other people's systems. Delivery platforms and payment terminals pay out net of their fees.
• Ownership differs by venue. One outlet is wholly owned and the next has a partner.

Here's what each of those looks like in a real build.

Seven edge cases from real F&B builds

1. A venue isn't a company

At the hospitality group, the venue list and the company list don't match. Some venues are a company of their own. Some are two companies added together. Several share one company and are told apart by a tracking category. And the untagged remainder of a company has to land on a row of the report too.

So the consolidation starts from a venue map kept in a config sheet, not in code. Each row is one venue: the companies that feed it, plus the tracking options to include, or to exclude so that everything else counts. Adding a venue, or moving one to a new company, is a row change.

The untagged transactions needed a trick of their own. Xero's report API filters by a tracking option's ID, and "Unassigned" isn't an option, so it has no ID. The report pulls the full breakdown instead, one column per option, and takes the Unassigned column from it.

Tracking carries a lot of weight here, and Xero allows only two active tracking categories. If outlet takes one, choose the other carefully (the two-category limit).

2. Not every venue is the same kind of business

The same group runs more than one kind of venue, and they don't share a P&L layout. Each category of venue has its own template, with the lines that matter for that kind of business, and its own consolidated tab. Venues under the same brand sit together as a sub-family with a subtotal.

On top sits a monthly summary with one row per venue: revenue, staff costs, staff costs as a share of revenue, EBITDA and net profit. Each is shown against budget and last year, which the group keeps per venue in the same config workbook.

3. Some venues have partners

Not every venue is wholly owned. Each row of the venue map carries the group's shareholding, and the summary works out the group's share and the partners' share of each venue's EBITDA and net profit, for actuals and budget.

A year-to-date profit share tab runs the same split month by month and quarter by quarter. A "sum to zero" row checks that the venues add back to the group total, after a line for dividends from companies outside the consolidation.

That's a management view of who earns what. Statutory accounts present the outside owners' share differently, as a non-controlling interest, and our NCI guide covers that side.

4. Gift cards sold in one venue, spent in another

The group sells gift cards and gift experiences that guests can use at any of its venues. The venue that sold the card holds the cash, and the venue that served the meal did the work. Until a card is redeemed, the cash is a liability, not revenue.

None of this lives in Xero. It sits in the gift card platform, so we built two reports on that data:

• A recharge reconciliation. Every card and experience issued in the period, by the venue that sold it, and every redemption, by the venue that honoured it, with the date and venue of the original sale. That's what the venues settle against each other. Cards issued by hand often carry no venue, so the report reads one from the remarks and falls back to head office. If a remark names two venues, the report stops rather than guess.
• A revenue recognition report. Every card that has expired by the period end, whatever its balance, and every expired experience, redeemed or not. Each card's use is laid out month by month, with the balance left.

The second report is where breakage comes from: value that's never redeemed. It becomes revenue too, either in step with redemptions or once redemption becomes unlikely, for example at expiry. And when the selling and redeeming venues sit in different companies, the recharge between them cancels out in the group accounts.

Running a multi-venue group on Xero? Cheetah builds Xero consolidation around how your group actually runs: venues, partners and intercompany flows included.

See how it works →

5. Delivery platforms sit inside sales

The salad franchise sells over the counter and through delivery platforms, and both channels carry a fee: the platform's commission on delivery orders and a POS fee on walk-in sales. Its consolidated P&L shows walk-in and delivery sales, each fee on its own line, and net sales after both. Beneath sit net delivery sales and the platform fee as a percentage of delivery sales.

In Xero, the commission accounts sat against sales. The report shows every account in the sign of the group it's mapped to, so each commission reads as a positive fee that net sales subtracts, whichever side of the ledger it was posted on.

The restaurant group does the same with more channels: restaurant sales, corporate orders, events and delivery. Its gross profit counts the platform cost alongside food cost. It also tracks the platforms' promotion fees as a share of delivery sales, separately from the commission. Why delivery should be booked gross in the first place is covered in our F&B reporting guide.

6. The ratios have to be the group's, not an average

The restaurant group's report ends with the ratios its operators manage by:

• rent, manpower, systems, repairs and utilities as a share of net sales
• card transaction (MDR) fees
• promotion and marketing fees, measured against the channel they're spent on
• the costs an operator can't trim this month, and what's left to manage

Then comes a breakeven block: the contribution margin ratio, fixed costs, and the sales needed to cover them. With fixed costs of $180,000 a month and a contribution margin of 40%, breakeven is $450,000 of sales.

Every ratio is calculated on the group's totals, because averaging outlet ratios gives the wrong answer. Say one outlet pays 10% of $300,000 in rent and another pays 20% of $100,000. The average of those ratios is 15%, but the group pays $50,000 on $400,000, which is 12.5%. Each ratio's numerator and denominator are defined in the config sheet, so the definitions are the operators' own.

7. Charts of accounts that drift

Every company in a group has its own chart of accounts, and new outlets add accounts mid-year. The franchise's mapping lives in a Google Sheet its own team edits. It assigns each account to a group and a sub-group, and lists the report's rows as plain formulas like {Sales Income} - {Walk-in POS Fee}. The report checks those formulas before it reads anything from Xero, and stops on an unknown name, a duplicate row or a loop.

Nothing gets dropped quietly. An account that carries a value but has no mapping lands in an UNMAPPED block at the foot of every tab, signed by its effect on profit. Net profit plus the unmapped total always equals Xero's net profit, and a new account appears there the first month it's used.

The restaurant group's nine files had a subtler problem: the same account name typed with a stray double space or line break. The report standardises spacing, and warns when doing so would merge two genuinely different accounts.

What a reliable F&B consolidation looks like

Across those builds, the same properties keep the group report trustworthy:

1. The venue is the unit. A venue map, held as data, says which companies and tracking options make up each venue, including the untagged remainder.
2. A layout per kind of venue. Restaurants, bars and other formats each get the lines that matter to them, then roll into one group view.
3. Ownership per venue. Every venue carries the group's share, and the partners' share is calculated rather than typed in.
4. Cross-venue flows reconciled by venue. Gift cards, recharges and management fees are traced from the venue that earned them to the venue that paid, then eliminated in the group.
5. Gross sales, separate fees. Platform and POS fees sit on their own lines, and net sales is a calculated line.
6. Group ratios from group totals. No averaged percentages.
7. A mapping the finance team owns, with nothing silently dropped. Anything unmapped is visible, and the report still ties to Xero's net profit.
8. Traceable numbers. A tab per company, a consolidated tab built from formulas, and a check wherever a split has to add back.

Where Cheetah fits

We wrote this list down because every item on it runs in a build today. Cheetah builds consolidated reports on top of Xero, shaped around each group. For the hospitality group, that's a monthly review with its venue map and profit share. For the franchise, it's an investor summary driven by a sheet its own team maintains. For the restaurant group, it's a P&L with operating ratios and a breakeven block.

Each report runs in one click and arrives in Google Sheets, with formulas you can trace back to a company tab and an Excel download. The structure lives in config rather than code, so a new outlet, a new partner or a renamed account means a change to a sheet, not a rebuild.

If your month-end still starts with a stack of Xero exports and a spreadsheet only one person understands, it might be worth a conversation.

The short version

An F&B group's consolidation is easy to add up and hard to get right. The outlet is the unit people manage, but Xero's unit is the company. Partners own slices of some venues. Gift cards, recharges and fees move money between venues. Delivery platforms sit inside sales. Build the venue map, the ownership and the cross-venue flows into the report, calculate the ratios on group totals, and make sure nothing falls out of the mapping unseen.

If you're still choosing how to build it, our guide to consolidation software for small groups compares the options, and Xero Custom Reports: 4 Ways to Build Them in 2026 lays out the routes.