Xero tracking categories let you give each venue its own P&L when the venues belong to the same entity. Set up a category called Venue, then tag each location’s sales and costs.
That shows you which cafe or restaurant is earning its keep, which one combined P&L can’t. But the setup needs to follow your business structure and your roster, especially when staff move between venues.
Our view: if one company owns all the venues, one Xero file with a Venue category is the simplest way to get a P&L for each, as long as you plan payroll before you switch anything on. Most of the work is getting every sale, bill line and wage into the right column.
Can You Use One Xero File for Multiple Venues?
Yes, one Xero file can work when the venues all belong to the same entity, with tracking categories separating their results.
Think of the file as the books for the company that owns the venues. The Venue category tells you which venue each sale, bill and wage belongs to.
If each venue sits in a separate company or trust, use separate Xero files for those entities. Don’t use tracking categories as a substitute for separate books just because you own all the venues.
The ATO treats a company as a separate legal entity with its own tax and super obligations. Giving that company’s transactions a location label inside another company’s file doesn’t change those obligations.
GST grouping is a separate arrangement. A GST group consists of associated entities treated as a single business for GST purposes, with a representative member completing activity statements and accounting for the group’s GST.
Eligible associated entities can form a GST group by notifying the ATO.
Before touching the software, write down which entity owns each venue.
How Do You Set Up Xero Tracking Categories?
Create one tracking category called Venue, add each cafe or restaurant as an option, and decide how payroll will use tracking before you add a second category.
Xero allows four tracking categories in total, but only two can be active at any time. A category needs at least one option before you can assign tracking to a transaction.
Follow Xero’s tracking category setup instructions:
- Open the Accounting menu and select Accounting settings.
- Select Tracking categories, then Add Tracking Category.
- Name the category Venue.
- Enter each venue as a separate option.
- Save the category.
Use names your team will recognise on invoices and timesheets. Don’t create a category for each venue; the venues are options within the category.
Keep the second active category free until you’ve planned payroll. If you want department reporting, a Department category with Kitchen and Front of House as options can go there.
A group of three cafes that wants both could set them up like this:
| Tracking category | Options | What gets tagged |
|---|---|---|
| Venue | Venue A, Venue B, Venue C, Shared | Sales, supplier bill lines, timesheet hours |
| Department | Kitchen, Front of House | Wages, through employee groups |
That uses both active categories, and it matches the payroll setup for floating staff further down.
Before setup, have this checklist ready for your hospitality bookkeepers:
- The entity that owns each venue.
- A consistent name for each venue.
- The POS settlements belonging to each location.
- Suppliers whose invoices cover multiple venues.
- Staff who stay at one venue and staff who move between them.
- Costs that belong to the group rather than a particular venue.
- Any tracking categories already in use.
How Do You Tag Sales and Supplier Bills?
Assign sales to the venue that earned them and supplier costs to the venue that incurred them, working at bill-line level where needed.
For sales, match the POS activity and deposits to the correct venue. If several venues’ settlements land in the same bank account, the bank account alone won’t tell you where the sales belong.
Use the venue’s POS settlement information to identify the location before accepting a reconciliation match. Don’t assume an automatic match has also put the sale in the right venue column.
We’ve seen Square clearing accounts blow out because Xero’s auto-reconcile matched the wrong lines. If deposits and sales don’t agree, fix the Square and Xero clearing account reconciliation before relying on the location split.
For supplier bills, check each line rather than assigning the entire bill to whichever venue usually orders from that supplier.
- A delivery entirely for one cafe belongs to that cafe.
- A bill covering several venues needs its lines assigned to the relevant locations.
- A shared purchase belongs with shared costs until there’s a supported way to allocate it.
Ask whoever orders or receives the goods to identify the venue while the delivery is still fresh. A bookkeeper shouldn’t have to guess from a supplier name later.
Keep the same habit for corrections. A transaction with the right expense account but the wrong Venue option can leave the combined P&L looking right while both venue reports are wrong.
How Do You Split Payroll Between Venues?
Xero Payroll splits wages by venue in two ways: employee groups for staff who always work at one venue, and timesheet categories for staff who move between venues.
You must be a payroll admin to apply tracking in Xero Payroll Australia. The settings sit under Payroll settings, then the Organisation tab, under Payroll Tracking.
Staff Who Stay at One Venue
Employee groups allocate an employee’s total salary and wage expense to a tracking option across their pay runs. You select the employee’s option on their Employment tab, under Employee group.
That suits staff who only ever work at one venue. If you use Venue as the employee-group category, each employee’s wage expense is allocated to their selected venue.
But a home-venue label isn’t enough when someone starts covering shifts elsewhere. It tells you their usual location, not necessarily where they worked that week.
Staff Who Move Between Venues
Timesheet categories allocate payroll hours and expenses using the timesheet details. Time can be assigned to different tracking options for each earnings rate, including hours worked by location.
Employee groups and timesheet tracking must use different tracking categories, even when you use both. You can’t select Venue for both settings.
Don’t create separate location categories for fixed staff and floating staff. Choose the reporting category first, then work through how each employee’s wages will reach it.
For a group with floating staff, we’d put Venue on timesheet categories for the whole team, so every hour lands in a venue column. Employee groups can then use Department, with Kitchen and Front of House as its options, if you need department reporting.
A salaried manager’s wage doesn’t come from a timesheet, so check after every pay run which venue column it lands in.
Use Xero’s Australian payroll tracking instructions to configure the settings, then check the resulting wage allocation against the roster and payroll totals.
Where Should Shared Costs Go?
Keep shared costs separate, either untagged as group-level costs or assigned to a Shared option within your Venue category.
The owner’s wage, accounting fee, group insurance and head-office costs don’t automatically belong to whichever venue has the most sales. A central kitchen’s costs may also need separate treatment where they support several venues.
We’d rather see an honest Shared column than a tidy-looking split based on guesswork. An arbitrary allocation can make a sound venue look weak or hide the cost of running the group.
If you leave shared costs untagged, review anything without a Venue option before treating it as a group-level cost. Otherwise, a missed supplier bill tag and an intentional shared expense look the same.
A Shared option makes that intention clearer: someone has reviewed the cost and decided it belongs to the group.
Read each venue’s result alongside the shared costs. A venue result that excludes shared overhead isn’t the whole business’s profit, and those overheads still need to be covered by what the venues earn.
How Do You Get a Separate P&L for Each Venue?
Open Xero’s Profit and Loss report and use Compare tracking categories to put the Venue options side by side in columns.
Set the dates for the week you’re reviewing. Check that the venue columns and any Shared option add up to the overall P&L for the week. Any gap is income or costs without a Venue option.
You can’t compare tracking categories and comparison periods on the same report. Run the weekly venue comparison first, then compare weeks separately. You can also filter by category and option, and save a useful layout as a custom report.
What the Wage Split Reveals
Take a group of three cafes in one company, with its weekly wage expense allocated by venue using timesheet tracking.
| Venue | Weekly Sales | Weekly Wages (% of Sales) |
|---|---|---|
| Venue A | $18,000 | $5,900 (32.8%) |
| Venue B | $12,000 | $4,100 (34.2%) |
| Venue C | $9,000 | $3,650 (40.6%) |
| All three | $39,000 | $13,650 (35.0%) |
Venue C spends $3,650 of its $9,000 weekly sales on wages, making it the first cafe whose roster and sales we’d review. At Venue B’s 34.2%, Venue C’s wages would be about $3,080, roughly $570 a week less.
The combined 35.0% might look fine at a glance, but it hides Venue C’s 40.6%. It doesn’t prove Venue C’s roster is wrong. It tells you to start there before you cut hours at all three cafes.
Our explanation of cafe wage cost percentage helps with that next check. Then use the rest of your weekly P&L to look beyond wages: a venue’s wage percentage isn’t its profit.
Key Takeaways
- Use one Xero file with Venue tracking for venues owned by the same entity, not as a substitute for separate entities’ books.
- Plan payroll before using both active tracking categories, because employee groups and timesheets must use different categories.
- Assign POS sales, supplier bill lines and payroll expenses to the venue they belong to, then check the allocations.
- Keep shared costs visible rather than splitting them by guesswork.
- Run the weekly P&L by venue, review untagged transactions and compare weeks separately.
If you’d like help with a separate weekly P&L for each of your venues, you can reach us at (02) 9768 5922 or enquiries@getroger.com.au for a free, no-obligations chat.