Managing 2–10 outlets on Excel and WhatsApp: where the money leaks
In a multi-outlet F&B group, money rarely leaks inside one system. It leaks in the gaps between them. The three most common gaps:
- staffing that doesn’t follow each outlet’s real sales peak
- ordering that’s even across the day while selling isn’t
- sales dips that nobody explains
Each is visible in data you already have. It’s just spread across a POS, a roster spreadsheet, a stock sheet and a WhatsApp group, so nobody puts it together in time.
Why the gaps matter more now
Margins have less room for slippage. rising manpower cost is Singapore employers’ top manpower challenge, flagged by 83% of them (SNEF, 2026),¹ and the Restaurant Association of Singapore’s July 2026 index found F&B sales 1.9% lower year-on-year, with manpower costs still rising under the Progressive Wage Model.² When costs climb and sales don’t, the small leaks add up.
Leak 1: Staffing that ignores the sales peak
What happens: rosters get written from habit or last month’s template. Outlet A gets the same headcount at 3pm as at 12:30pm. One outlet is short at peak while another carries a full floor through a quiet afternoon.
Why spreadsheets miss it: the roster lives in one file and sales by hour live in the POS. A weekly labour % can look fine while the hours inside it are wrong.
Check it this week:
- Export sales by hour for each outlet for the last four weeks.
- Put rostered headcount by hour next to it.
- Look for hours where sales per staff member are far below the outlet’s average, and hours where they’re far above.
- Compare rostered hours with paid hours from payroll. The difference is a leak of its own.
Leak 2: Even ordering, uneven selling
What happens: outlets order and prep in even morning and afternoon batches. But demand for many items is lopsided: most of it lands in the morning, or most of it in the evening. Too much made early goes stale. Too little made late means sold-out signs and lost sales.
Why spreadsheets miss it: stock counts are on a clipboard or a shared sheet. Nobody lines them up against hourly sales.
Check it this week:
- Pick your ten highest-volume items.
- For each, split the last four weeks of sales into AM and PM.
- Compare that split with how you order or prep it. Anywhere the split is far from 50/50 but ordering is even, the timing is costing you.
Leak 3: The dip nobody explains
What happens: one outlet has a bad Tuesday. Someone says “must be the rain” in the group chat, and everyone moves on. Sometimes it was the rain. Sometimes it was a staffing gap, a stock-out or a competitor’s promotion. If you don’t check, you can’t tell which, and the real ones repeat.
Why spreadsheets miss it: comparing revenue with the outlet’s own normal, plus weather and calendar, takes three sources and a free afternoon.
Check it this week:
- For each outlet, calculate its average revenue for each day of the week over the last eight weeks.
- Flag any day more than ~15% below that average.
- For each flagged day, note whether there was heavy rain or a public holiday or school-holiday shift. Anything you can’t explain is worth investigating.
Two more worth a look
- Delivery items that lose money after commission and ingredient cost. See How to calculate your real margin on GrabFood and foodpanda orders.
- Outlet profit after rent, especially on gross-turnover leases, where a good sales month also raises your rent.
The pattern
None of these leaks needs new data. It needs the data you already have, put side by side, per outlet, often enough to act on. That’s the job a good ops manager does when they have the time, and the job that slips first when you open outlet three.
Where Backline fits
Backline reads your POS, roster, stock and delivery data across every outlet and puts these comparisons side by side every day. It ranks what it finds by dollar impact, flags unexplained dips as “worth investigating”, and drafts the roster note or supplier RFQ for you to approve. See what Backline flags across your outlets, or how it handles rosters and stock ordering.