A working owner dashboard for a Singapore restaurant isn't a tool decision. It's a sequence: decide what the owner needs to see, decide where the data lives, decide how each piece flows in, decide how it's presented. The tool — Xero's built-in dashboard, Fathom, Spotlight, a custom build — is the last decision, not the first.
Here's the build sequence we use for F&B clients.
Step 1: name the questions
The dashboard exists to answer specific questions an owner asks regularly. Write them down before picking metrics. Common ones for restaurant operators:
- What's in the bank right now and what's coming in/going out in the next 14 days?
- How is each outlet performing this week vs last week and same week last year?
- Is my labour ratio drifting in any outlet?
- Are my delivery platform payouts arriving as expected?
- What did food and beverage cost as a percentage of revenue this month?
- What anomalies or exceptions need attention this week?
- What's on the compliance calendar this month?
A dashboard built to answer the owner's actual questions ends up tight. A dashboard built “in general” ends up cluttered and ignored.
Step 2: map data sources
For each question, the data comes from one or more systems. For a typical Singapore restaurant:
- Xero for revenue, costs, GL data, cash position from bank feeds
- POS for sales by outlet and channel (already flowing into Xero via integration)
- Delivery platforms for payout timing and commission splits (manual import or POS aggregation)
- Payroll system for labour cost (flowing into Xero)
- Inventory system for stock and COGS (flowing into Xero monthly)
- Bank feeds for live cash position
If everything flows into Xero, Xero is the dashboard data source. If some data lives outside (e.g. platform statement details), the dashboard tool needs to ingest from those too — usually via scheduled import or API.
Step 3: design the layout
The dashboard should fit on a single screen with no scrolling for the most-used view. Hierarchy matters:
- Hero row: cash position, MTD revenue, net operating
- By-outlet table: revenue, gross margin, labour ratio per outlet
- By-channel breakdown: dine-in vs takeaway vs delivery, by amount and percentage
- Cost lines: COGS food, COGS beverage, labour, rent, others — each as % of revenue
- Exception feed: what got flagged this week (separate panel, scrollable)
- Compliance status: upcoming deadlines, current GST exposure
See our F&B owner dashboard demo for an implemented version of this layout.
Step 4: pick the tool
Options for Singapore restaurants:
Xero Business Performance dashboard
Built into Xero. Free with subscription. Limited customisation but adequate for single-outlet operators with simple needs.
Fathom or Spotlight Reporting
Established Xero add-ons. Subscription cost. Good customisation, KPI tracking, multi-period comparison. Most common for multi-outlet operators.
Custom dashboard
Built specifically for the operation. Higher cost up-front, lower marginal cost over time. Best when the standard tools don't cut the metrics the way the operator thinks about them.
For most F&B operators, Fathom or Spotlight is the right starting point. Custom dashboards become worth it once the operation is large enough that the cost of a small dev investment is dwarfed by the value of getting the views exactly right.
Step 5: configure refresh cadence
Different metrics on different cadences:
- Live / near-live (refreshed from source feeds with no human intervention): cash position, current-day revenue, exception feed
- Weekly (compiled automatically each Sunday night): labour cost ratio, delivery platform reconciliation, AR aging, AP aging
- Monthly(available within 4-6 days of close): gross margin, COGS, outlet P&L, prime cost
The dashboard should make the cadence visible — date last updated on each section — so the owner knows whether a number is live or 4 days old.
Step 6: set permissions
Not everyone sees everything:
- Owner: all metrics, all outlets
- Operations lead: operational metrics, exception feed, compliance status
- Outlet manager: their outlet's metrics only
- Bookkeeper / accountant: full financial detail, including unreconciled transactions
Most modern dashboard tools handle role-based access. Set it deliberately at setup.
Step 7: review and iterate after a month
The first version of any dashboard is wrong. Run for one full month, then sit with the owner and ask:
- Which metrics did you actually look at?
- Which did you not look at — and should be removed?
- What did you want to know but couldn't find?
- What surprised you (positively or negatively)?
Refine. Repeat after another month. By month 3 the dashboard is stable.
The discipline that keeps the dashboard useful
- Underlying data must be clean. Bank feeds working, reconciliation rules applied, inventory feeding monthly. A dashboard on bad data is worse than no dashboard.
- Cadence must be honoured.If the weekly summary doesn't arrive Monday morning, the owner stops trusting it.
- Exception feed must be active. Stale exceptions or no exceptions usually mean the agent isn't monitoring properly, not that nothing's happening.
- Metrics must trigger decisions.A number nobody acts on doesn't belong on the dashboard.
Common questions about building a restaurant dashboard
How much does building a restaurant dashboard cost?
Tool cost depends on choice (Xero Business Performance is free; Fathom / Spotlight S$50-200/mo; custom higher). The bigger cost is the configuration time — typically 2-4 weeks for a properly-designed dashboard for a multi-outlet operation. For Acuitas clients, this is included in the Operator stack engagement.
Can I build a dashboard if my accounting isn't fully on Xero?
Possible but limited. The dashboard's usefulness mirrors the cleanliness of the underlying data. Migrating to Xero first usually unlocks more value than trying to build a dashboard on top of a spreadsheet-based system.
Should outlet managers see each other's outlet numbers?
Mixed practice. Some operators show all outlets to all managers to create constructive competition; others restrict to own-outlet only. Depends on culture. The dashboard tool should support both approaches.
How do I handle multi-brand operations on one dashboard?
Tracking categories for brand (in addition to outlet) at the chart-of-accounts level. The dashboard then filters by brand to give per-brand P&L while still rolling up to a group view.
What if my owner ignores the dashboard?
Usually means the dashboard isn't answering their questions — or it's answering them with data they don't trust. Sit down with them, redesign around what they actually want to see, and confirm the underlying data is clean. A dashboard an owner ignores is failing at its job; the fix is structural, not motivational.
Building a dashboard isn't the work. Keeping it usable is the work. Get the underlying data discipline right, design for the owner's actual questions, honour the cadence, and the dashboard becomes the operating layer the rest of the back office runs from.
— The Acuitas team