Weekly cash flow & working capital template

Purpose

This worksheet helps small food service and hospitality businesses see short-term cash timing, identify weekly cash gaps before they become crises, and plan practical actions — defer, accelerate, borrow, or buy inventory — so operations keep running and vendors and payroll are met on time.

Who should use this

Owners, general managers, finance leads, or operators who need a simple repeatable process to forecast cash one quarter ahead on a weekly cadence and to make clear trade-offs when cash timing becomes tight.

What the template includes

• Rolling 13‑week cash forecast — three sales scenarios (base, low, high) with weekly opening cash, receipts, expected outflows, and closing cash. Designed to roll forward each week so the 13‑week window stays current.
• Payables & vendor terms — a tab to list major vendors, invoice timing, typical payment terms, and payment windows so you can model when cash will actually leave the business.
• Payroll & payroll taxes — scheduled payroll dates, gross payroll, taxes and benefits, and timing assumptions (when payroll is funded vs. paid) so large weekly payroll items are visible.
• Action items — an operational checklist and decision log: options to defer or accelerate payments, request extended vendor terms, draw on temporary lines, pace inventory buys, or run short‑term promotions. Includes space to record owner/manager decisions and outcomes.
• Instructions & tips — practical guidance on estimating cash receipts from POS data, smoothing cash peaks, and using the template to negotiate working capital.

How to use the template (step‑by‑step)

1. Set the opening cash — enter your current bank balance at the top of week 1. This is the forecast starting point.
2. Populate sales scenarios — for each week enter projected sales for base, low, and high. Use recent POS history and seasonality — see the estimating tips below.
3. Convert sales to expected cash receipts — not all sales equal same‑day cash. Apply your receipts timing assumptions (cash, card, third‑party delivery holdbacks, merchant deposit delays). See the guidance section for an approach to estimate weekly cash receipts from POS.
4. Add scheduled outflows — enter payroll, payroll taxes, rent, major vendor payments, loan repayments, utilities, and any planned capital or inventory purchases. Use the Payables tab to assign expected week of payment based on vendor terms.
5. Review closing cash per week — each week shows closing cash (opening + receipts − outflows). Watch for weeks where closing cash drops below your minimum cushion threshold.
6. Record action items — when a shortfall appears, use the Action Items tab to list options (defer payment, ask vendor for terms, delay inventory purchase, temporarily draw a credit line, schedule slower payment run), assign owner and target date, and log results.
7. Roll forward weekly — when you finish a week, set actuals for sales and payments, move the 13‑week window forward one week, and re‑forecast. This keeps the forecast current and teaches the team how forecast errors behave.

Estimating daily/weekly cash receipts from POS (practical method)

POS shows gross sales by day but cash in the bank arrives on different schedules. Use this simple method to estimate expected cash receipts:

1. Start with gross sales by payment type (cash, card, delivery platform, gift cards, comps).
2. For cash sales, assume same‑day deposit unless you have a known delay. For card sales, subtract merchant fees and apply your typical merchant deposit lag (for example, 48–72 hours or specific deposit schedule).
3. For third‑party platforms, apply their payout schedule and fees (e.g., weekly payout on X day). For gift card redemptions, estimate based on historical redemption patterns.
4. Sum expected receipts by week to produce the cash receipts line for each scenario.
5. Document assumptions clearly (e.g., “merchant deposits T+2 business days; DoorDash pays weekly on Wednesdays”). Assumptions should be editable so the forecast stays accurate when terms change.

Key columns and suggested fields for the rolling forecast

Each weekly column should include, at minimum:

• Week starting date
• Opening cash
• Projected receipts (Base / Low / High)
• Expected payables & scheduled outflows (broken into payroll, vendor payments, rent/lease, taxes, loan payments)
• Net cash flow
• Closing cash
• Cumulative shortfall (shows if and when you fall below your minimum cushion)
• Notes / triggers (e.g., “pay vendor X this week if balance > $Y”)

Action thresholds & suggested responses

• If projected closing cash < minimum cushion for 2 consecutive weeks: prioritize payroll funding and essential vendor payments; contact primary lender/creditor; open action item to request vendor extension.
• If single‑week shortfall that recovers in the next week: consider short‑term overdraft or shifting noncritical payables within vendor terms.
• If worst‑case scenario (low) shows multi‑week shortfall: evaluate temporary credit, emergency cost reductions (hours, menu trimming), urgent negotiations with landlords or lenders, and fast revenue levers (promotions, gift card offers).

Tips to smooth cash peaks and troughs

• Negotiate staggered vendor payments or extended terms on large invoices.
• Shift small recurring supplier payments to monthly or align due dates with deposit days.
• Time inventory purchases for slow days or when receipts are strongest.
• Offer short‑term prepay or gift card promotions to accelerate inbound cash on critical weeks.
• Consider a small, committed line of credit sized to cover predictable shortfalls rather than relying on emergency credit.

Common pitfalls to avoid

• Using gross sales as cash receipts without modeling deposit lags and fees.
• Forgetting payroll tax schedules — payroll taxes are often due separately from payroll and can create unexpected cash demand.
• Failing to track recurring weekly vendor invoices that shift dates (seasonal suppliers, holiday schedules).
• Not updating assumptions after a change in merchant deposit policy or a new delivery partner.

How to customize this template

Adapt the payables tab to include vendor contact names and the typical invoice amount so you can prioritize who to call when negotiating terms. Add columns for actual vs. forecast to measure forecasting accuracy over time. If you run multiple shifts or outlets, add location subtotals and a consolidated view.

Next steps and how teams should operate with the forecast

1. Assign an owner (operations manager or GM) to update the forecast weekly and lead the cash huddle.
2. Use the Action Items tab as the agenda for a weekly 15‑minute cash huddle: review variances, confirm actions, and close prior tickets.
3. Record what worked when an action either avoided or failed to avoid a shortfall so the team learns and improves forecasts and responses.

Download and integration notes

This template is delivered as a spreadsheet you can download and adapt. For teams with stable POS and accounting connections, consider automating weekly population of sales and receipts by exporting POS reports or integrating via API to reduce manual entry and improve timeliness.

Where this tool fits in the Food Service & Hospitality domain

This template directly supports the domain hunger: Keep ahead of cash timing to avoid disruption and negotiate working capital proactively. Use it alongside inventory planning, payroll scheduling, and vendor management resources in the Tools, Templates & Calculators collection.