Daily Financial Snapshot: Sales, Cash, Labor & Food Cost

Purpose

This one-page Daily Financial Snapshot keeps the few numbers that most quickly predict profit risk visible to shift managers and supervisors so they can act before small problems become large losses. Use it during service (hourly or period refresh) and as a post-shift check.

Who Should Use It

Shift managers, assistant managers, kitchen leads, general managers on duty, and owners who review end-of-day reconciliations.

High-level Layout (single page)

1. Real-time Sales vs Forecast (by period & department) — sparkline + variance number
2. Cash-on-hand & Deposits — till totals, expected deposits, unexplained variance
3. Labor hours & Labor % vs Forecast — period and day-to-date (% of sales)
4. Daily food cost estimate & top 5 variance drivers — percent and $ variance
5. Action checklist & status — investigation steps, owner, time started

Key Metrics, Definitions & Formulas

• Sales vs Forecast: Sales (net of discounts & comps) for the period compared to forecasted sales for that period. Variance = (Actual - Forecast) / Forecast. Show period and day-to-date (DTD).
• Cash-on-hand: Physical cash in tills + petty cash. Compare to expected cash from POS close and previous deposit. Unexplained cash variance = Reported cash - Expected cash.
• Deposits: Expected deposit amount (based on POS-net) vs actual bank deposit logged. Flag when difference > threshold.
• Labor Hours: Clocked hours for the period. Labor % = Labor cost / Sales for same period (use payroll cost rate or hourly wage estimate). Compare to forecasted labor %.
• Daily Food Cost Estimate: Estimated food cost = Opening inventory + Purchases - Closing inventory - Transfers. When real inventory not available, use recipe-based theoretical cost for items sold. Food Cost % = Food Cost / Sales (DTD).
• Top 5 Variance Drivers: Quick list of likely causes (voids/comping, high-ticket discounts, over-portioning, spoilage/waste, unauthorized transfers or giveaways). Show estimated $ impact next to each driver.

Suggested Visuals

• Small sparklines for sales by period and DTD trend.
• Numeric tiles for current Sales, Forecast, Variance %, and DTD Sales.
• Gauge or % bar for Labor % vs target band (green/amber/red).
• Table for Top 5 Food Cost Variance Drivers with $ estimates and who to contact.
• Action checklist with status badges (Open / In progress / Resolved).

Suggested Thresholds & Alert Rules (examples — adapt locally)

• Sales variance: flag when period variance > ±8% (investigate when negative).
• Labor %: flag when actual labor % exceeds forecast by >2 percentage points or exceeds absolute threshold (e.g., >35% for full-service, >28% for limited service).
• Cash variance: flag unexplained variance >$100 for small shops, >$500 for larger venues.
• Food cost %: flag when daily food cost % > forecast by >1.5–2 percentage points or when Top 1 driver estimates >$75.
• Voids/comps: flag when voids & comps total >3% of period sales or a single ticket comp >$50.

Who Acts on Each Alert (role-specific)

• Sales shortfall (sustained): Manager — check shift pacing, promotions, POS channel issues, inventory availability.
• Labor spike: Manager & Scheduler — check recent clock-ins, overtime triggers, no-shows, double-clocked employees.
• Cash variance: Manager & General Manager — recount tills, review refund/comp logs, review opening float and deposit records.
• Food cost spike or variance drivers: Kitchen Manager & Purchasing — investigate recent deliveries, check prep logs/portioning, look for spoilage or recipe changes.
• Voids/comps anomaly: Manager & Ops — review transaction details, CCTV if available, interview server, confirm authorization.

Action Checklist (use during investigation)

1. Confirm the metric is correct (quick validation vs POS/timeclock/inventory counts).
2. Identify the time period and affected department or server.
3. Run quick supporting reports: voids & comps list, tickets by server, item sales report, clock punches for period.
4. Perform immediate corrective steps (e.g., close a mis-printed comp, reassign staff, tighten portioning, set temporary prep limits).
5. Record action taken, owner, and expected follow-up time in the dashboard action log.

How to Populate (data sources & mapping)

• POS: Sales by period, comps & voids, items sold.
• Timeclock / Labor system: Clocked hours by employee (map roles to labor cost rates).
• Inventory / Receiving: Purchases, deliveries, and fast inventory counts (opening/closing) to estimate food use.
• Cash records / Bank deposit logs: Till totals and deposit amounts.

Practical Populate Steps (quick, for busy managers)

1. Automated: schedule hourly pulls from POS and timeclock to populate Sales and Labor tiles where integration exists.
2. Manual quick-check (no integration): manager runs POS period sales report, timeclock summary, and records till cash. Enter values in the dashboard data entry fields or spreadsheet cells.
3. Food cost quick estimate: use sold items × recipe cost for the period if inventory counts are not practical mid-shift; reconcile with opening/closing inventory at day end.

Quick Calculations & Examples

Example: Period sales forecast $2,500, actual $2,100 → variance = (2,100 − 2,500) / 2,500 = −16% → Flag and investigate immediate causes (POS outages, menu stockouts, and comps).

Example: DTD Sales $12,000, DTD food cost $3,360 → Food cost % = 3,360 / 12,000 = 28%.

Common Root Causes & How to Quickly Check Them

• Voids/comps — run voids/comps report and identify server or ticket numbers; confirm authorization.
• Portioning drift — check recent prep batches, compare portion sizes to standard photo or measured portion.
• Theft / cash handling error — recount till, review refund logs, check CCTV around POS if available.
• Receiving/ordering mistakes — validate last delivery invoices and compare to usage and storage.

End-of-Shift & Morning Reconciliation

• End-of-shift: confirm actions taken, close action list, and assign any unresolved items for morning follow-up.
• Morning: reconcile cash deposits, finalize inventory-based food cost, update weekly trends and handover notes to the incoming manager.

Data Quality Tips

• Automate as much as possible (POS/timeclock integrations) to reduce manual errors.
• Set single-source-of-truth rules—declare which system is authoritative for each metric.
• Log adjustments — if you override a value, record why and who approved it.

Template & Reuse Notes

Make a copy of this dashboard for each location. Localize forecast bands, labor targets, and cash thresholds to reflect store size and model. Package the dashboard as a local toolkit with an attached Action Log form so managers can record incident details and corrective steps.

Further Enhancements (optional)

Consider adding an interactive Action Log so managers can submit actions and their status directly from the dashboard (use the platform's form submission capability). Over time, collect these submissions to build a searchable history of incidents and corrective actions.