Weekly P&L & Cash Snapshot (template)

Weekly P&L & Cash Snapshot — Compact Template

Purpose: Keep the small set of numbers visible so managers can spot margin erosion, cash signals, and staffing or sales anomalies before they become month‑end surprises. This template is purposefully compact — a single page for quick review, plus a short commentary for issues and actions.

At a glance (layout)

Top row: headline sales and cash signals. Middle row: margin KPIs and prime cost comparisons. Bottom row: quick operational signals (inventory, variance, labor efficiency). Beside each KPI include a 4‑week sparkline and week‑over‑week variance.

Required data sources

• POS (net sales, voids, comps, covers, average check)
• Payroll / scheduling system (scheduled hours, paid hours, labor cost, overtime)
• Inventory / receiving (opening/closing inventory, receipts)
• Purchasing / AP or invoices (food & beverage purchases by period)
• Bank / cash records (bank balance, deposits, petty cash, outstanding receivables)
• Accounting (weekly GL adjustments, taxes, fees) — used for reconciliation

Key metrics, definitions, and where to get them

1. Net Sales (week): Total POS net of refunds and comps. Source: POS. Visual: big number + sparkline. Action threshold: >5% drop vs LY or rolling 4‑week average → investigate promotions, covers, comps.
2. Cash on Hand (end of week): Bank balance + petty cash + undeposited receipts. Source: Bank/petty cash. Visual: number + trend. Threshold: below target buffer (e.g., 7 days of operating cash) → prepare cash plan.
3. Food Cost % (week): (Cost of goods sold for food for the week) / Net Sales. Sources: inventory + purchases + adjustments; or accounting COGS if available. Visual: gauge + sparkline. Thresholds: Green ≤ target% (e.g., 29%); Amber within 2 pts; Red >2 pts above target → check portioning, waste, deliveries.
4. Beverage Cost % (week): Beverage COGS / Beverage Sales. Source: purchases, inventory. Action: high variances may indicate theft or pouring waste.
5. Labor % (week): Labor cost (wages + payroll burden) / Net Sales. Source: payroll system. Visual: bullet chart vs budget. Threshold: Red if > target by 2–3 pts; action: review scheduling, covers per labor hour.
6. Prime Cost %: Food + Beverage + Labor costs / Net Sales. Quick health indicator. Thresholds: exceed combined target → immediate shift schedule and menu review.
7. Sales per Labor Hour (SPLH): Net Sales / Paid Labor Hours. Source: POS + payroll. Visual: ranking vs target. Low SPLH in peak hours → staffing mismatch.
8. Inventory Variance (week): Expected COGS from sales vs recorded COGS from inventory and purchases. Source: inventory counts + purchases. High unexplained variance → theft, miscounts, or receiving errors.
9. Overtime $ and Hours (week): Payroll overtime. Visual: small bar chart. Threshold: any unexpected OT spike → investigate call‑offs or scheduling issues.
10. Net Cash Flow (week): Receipts minus cash outflows (payroll, supplier payments, known large expenses). Source: bank + AP schedule. Visual: bar. Action: negative flow two weeks in a row → escalate.
11. Top 3 Variances (week): Highlight the three largest dollar variances vs the rolling forecast (eg. food vs target, labor vs budget, bank deposits vs expected). Source: comparison calculations in dashboard.

Visualizations — simple, actionable designs

• Headline numbers with color band (green/amber/red) and 4‑week sparkline.
• Bullet charts for % metrics showing target, last week, and best practice band.
• Bar chart for category spend (food, beverage, labor, other) with week vs budget comparison.
• Heatmap for hourly sales vs labor hours (spot understaffed or overstaffed shifts).
• Small table for Bank & Cash reconciliation items (expected deposit, actual deposit, variance).

Thresholds & immediate actions (example)

• Food Cost % > target +2 pts: Pull daily recipe/portion checks for the last 7 days; review recent deliveries and variance report; schedule a short training/refresh on portion control.
• Labor % > target +3 pts or OT spike: Review scheduling, check reasons for call‑offs, consider reassigning shifts or reducing premium labor where possible.
• Net Sales drop >5% vs rolling average or LY: Check covers by daypart, voids and comps, recent service issues or menu changes, and local events; consider short promotional plan if persistent.
• Inventory variance >2% of weekly COGS: Conduct immediate receiving/stocktake audit for high‑risk SKUs and review security/cash handling procedures.
• Cash on hand below buffer: Delay non‑urgent payables, contact bank if needed, notify operator for contingency plan.

Sample commentary prompts for weekly management review

• "Headline: Sales were up/down X% vs last week and Y% vs rolling 4‑week average. Main drivers were..."
• "Top risk: Food cost variance widened by Z points due to... Proposed immediate action:..."
• "Labor: OT increased by $X because of... Action taken or suggested:..."
• "Cash note: Deposits were $X below expected due to... Next steps:..."
• "Quick wins: Two small operational changes we will implement this week to protect margin:..."

Weekly rhythm and owners

• Daily: Shift leaders confirm end‑of‑day cash and sales reconciliation.
• Weekly (once): General Manager or Operator reviews this snapshot, completes the short commentary, and assigns any actions. Recommended meeting: 20 minutes weekly huddle with GM + kitchen lead + FOH lead.
• Monthly: Finance reconciles the weekly snapshots to the monthly P&L and flags recurring issues.

Implementation checklist

1. Map each KPI to its source field (POS sales, payroll hours, purchase invoice amount, inventory on hand).
2. Confirm data refresh frequency for each source (daily/real‑time/batch) and set update schedule for the weekly snapshot.
3. Set targets and color bands for each KPI (site‑specific). Document how targets were chosen.
4. Create a template commentary form with the prompts above and attach to the dashboard for the reviewer to submit weekly notes.
5. Validate numbers for two weeks in parallel with existing reporting to confirm accuracy before switching to the dashboard as the primary signal.

Tailoring notes

Independent restaurants may focus on cash buffer, food/labor %, and inventory variance. Multi‑unit operators should add location ranking, per‑store SPLH, and a consolidated cash position. Adjust thresholds for different service styles (fast casual vs full service) and local labor cost structures.

Quick exportable checklist (for the weekly reviewer)

1. Confirm POS sales vs bank receipts.
2. Scan top 3 variances and state cause in commentary.
3. Confirm cash buffer and note any shortfalls.
4. List at least one corrective action (owner + due date) when a threshold is in amber/red.

Final note

This template is intentionally operational: make it the one‑page weekly habit. Keep visuals simple, keep commentary short, and convert repeated commentary into a recurring improvement item. When the dashboard reliably reflects the business, managers can use it to prevent surprise losses and to prioritize high‑ROI actions.