Daily Financial Dashboard Template for Managers

Purpose and use

This dashboard gives managers one clear screen each morning (and a quick check during service) to see whether the day is running profitably and where to take immediate action. It highlights the few numbers that matter for daily control, explains how each figure is calculated, recommends visual treatments and thresholds, and includes a short daily-huddle script that turns insight into action.

Recommended Layout (single-screen priority)

1. Top row — Scorecards (high-importance KPIs): Net Sales, Forecast vs Actual, Labor %, Prime Cost, Food Cost %, Comps/Discounts.
2. Middle row — Trend visuals: 14-day sparklines for Sales, Labor %, Food Cost % and Prime Cost with yesterday vs forecast arrows.
3. Bottom row — Operational detail and alerts: Top variance drivers (by menu item/category), covers vs forecast, current open ticket count, inventory exceptions, and short action log from the last huddle.

Top KPIs & Template Fields

• Date / Location — reporting day and unit.
• Gross Sales — POS total sales before discounts and comps.
• Net Sales — Gross Sales minus discounts, comps, and refunds. Use Net Sales for margin calculations.
• Covers — Number of guests or checks.
• Average Check = Net Sales / Covers.
• Labor Cost — Total labor dollars for the period (payroll expense + paid breaks + paid training for shift hours).
• Labor % = (Labor Cost / Net Sales) × 100.
• Food Cost — Cost of goods sold for food for the day (inventory-based COGS preferred).
• Beverage Cost — Separate if valuable.
• Prime Cost = Labor Cost + Food Cost + Beverage Cost.
• Prime Cost % = (Prime Cost / Net Sales) × 100.
• Comp/Discount $ & % of Sales.
• Refunds / Voids — count and dollar value.
• POS Ticket Count / Avg Ticket Time — throughput signal.
• Inventory Exceptions — flagged items beyond expected usage.
• Cash / Card Reconciliation — quick yes/no or variance amount.

Exact Calculation Rules

1. Net Sales = Gross Sales − Discounts − Comps − Refunds
2. Average Check = IF(Covers > 0, Net Sales / Covers, 0)
3. Labor % = (Total Labor Cost / Net Sales) × 100 where Total Labor Cost includes hourly wages, salaried labor allocated for shift time, payroll taxes, and scheduled paid breaks for the day.
4. Food Cost % = (Food Cost / Net Sales) × 100
5. Prime Cost % = ((Labor Cost + Food Cost + Beverage Cost) / Net Sales) × 100
6. Variance vs Forecast $ = Actual − Forecast; Variance % = (Actual − Forecast) / Forecast × 100
7. Daily COGS (inventory method) = Opening Inventory + Purchases − Closing Inventory

Suggested Visualizations

• Card KPI tiles for the top row with big numbers, small 14-day sparkline, and colored trend arrow (green up, amber flat, red down).
• Sparklines (14-day) for Sales, Labor %, Food Cost % and Prime Cost %.
• Stacked bar for Sales mix by category and contribution to GP.
• Table of top variance drivers (menu items) with Item, Sales $ Change, Cost $ Change, Action Suggested.
• Small gauge or colored band for Labor % and Prime Cost % with thresholds.
• Alert banner that lists active alerts and recommended immediate actions.

Thresholds & Alert Rules (starter values)

• Labor % > Scheduled Labor % + 3 points → Alert: 'Labor above plan'
• Prime Cost % > Target Prime Cost % + 2 points → Alert: 'Prime cost pressure'
• Food Cost % daily change > +2 percentage points vs rolling 7-day average → Alert: 'Spike in food cost'
• Net Sales < Forecast by > 10% → Alert: 'Sales shortfall'
• Comps/Discounts > 3% of Net Sales → Alert: 'Unusual comps'
• Refunds or Voids > X transactions (set locally) → Alert: 'High voids/refunds'

Surface high-impact alerts on the huddle agenda and use color-coded cards (red/amber/green).

Data Sources & Mapping

• Sales, Covers, Ticket Count: POS (primary). Fallback: manager daily sales file.
• Labor Cost, Hours: Timeclock/payroll export (primary). Fallback: scheduled labor cost + manager adjustments.
• Food/Beverage Cost: Inventory consumption, production sheets, or integrated recipe-level COGS.
• Forecasts: Forecasting module or simple model (e.g., same day last week adjusted).
• Inventory Exceptions: Inventory system or daily count spreadsheet.

Capture field-level mappings such as POS.TenderGross, POS.Discounts, POS.VoidAmount, Payroll.TotalPay, TimeClock.Hours, Inventory.OpeningValue, Purchases.Total, Inventory.ClosingValue.

Data Refresh Cadence & Ownership

• Automated refresh where possible: hourly during service if POS supports it; otherwise daily after close.
• Daily owner: Floor Manager or Duty Manager — responsible for reviewing the dashboard at shift start and during checkpoints.
• Escalation owner: General Manager or Area Manager — receives alerts that persist (>1 day) or large variances.

Daily Huddle Script (5–8 minutes)

1. Open — 'Quick numbers: Sales vs Forecast, Labor %, Prime Cost %. Any major alerts?' (Manager reads top-row KPIs aloud.)
2. Check for red alerts — If Labor or Prime Cost is over threshold, ask: 'Which station/shift is driving this? Can we reassign coverage or hold appetizers?'
3. Sales variance — If sales are below forecast: 'Are covers low or avg-check down? What promotions or upsells can we run this service?'
4. Food cost spike — If food cost rose: 'Any large comps, waste events, or substitution? Any delivery/portioning mistakes?'
5. Operational check — 'Ticket times, open tickets, and POS errors?' (Assign owner for immediate fixes.)
6. Decide action — Assign one short corrective step and who owns it with a time window.
7. Log decision — Record action and owner in the dashboard's action log so follow-up is visible the next day.

Common Situations and Suggested Immediate Actions

• High Labor % with normal sales: review scheduled vs actual hours, close an unnecessary prep station, reassign support staff to FOH if appropriate.
• Food Cost spike tied to single menu item: check portioning, waste log, and plate photos; coach cooks and tighten portions.
• Sales shortfall: boost average check (upsells), run a short special, or reallocate staff to improve throughput.
• High comps/voids: review server behavior, coach staff, and require manager approval for comps until behavior improves.

Implementation Tips

• Start with daily Net Sales, Labor Cost and Food Cost feeding into Labor % and Prime Cost %.
• Set conservative alert thresholds initially, then tighten them as you learn variance patterns.
• Keep the dashboard uncluttered — default to one or two visualizations per KPI and offer drilldowns.
• Show a simple green/red 'data complete' indicator (payroll imported, POS file present, inventory closed). Mark calculations provisional if incomplete.
• Build a short training card so every shift lead interprets the dashboard the same way and runs the huddle script consistently.

Small Checklist to Run the Dashboard (under 2 minutes)

1. Open dashboard and verify data-complete indicator.
2. Scan top-row KPIs and note any red/amber alerts.
3. If alert exists, run the specific probe question from the huddle script and assign one corrective action.
4. Note the action in the dashboard action log and assign follow-up owner/time.

Quick Notes on Accuracy & Limitations

Daily financial numbers are operational controls, not audited accounting. Timing differences (AP invoices, payroll cutoffs, inventory timing) will cause noise — use rolling averages for non-immediate decisions. Avoid treating single-day anomalies as permanent trends without follow-up.

Where interactivity helps (implemented below)

This page includes two interactive manager tools: a daily data-complete flag and a short action-log form so managers can record decisions, assign owners, and create an auditable trail. Submissions are saved for follow-up, escalation, and cross-day analysis.