Restaurant Cash Flow Forecast Template: 13-Week Model Walkthrough

Bottom line: The 13-week cash flow model is the single most useful spreadsheet a restaurant operator owns. It projects weekly inflows and outflows for the next quarter so you can see a cash gap before it becomes a payroll problem. Update it every Monday with last weeks actuals, no exceptions.

Bottom line: This is the step-by-step walkthrough of the same 13-week cash flow template. It shows exactly which cells to fill in first, what to pull from your POS versus your accounting file, and how to read the ending-cash row so you can act on it Monday morning.

Written by The Pragmatic CFO. 15+ years running restaurant P&Ls.

Last updated July 30, 2026.

A 13-week cash flow forecast projects weekly cash inflows and outflows across the next quarter. It is the single most important operating tool for any restaurant, because it tells you the exact week you will run out of money if nothing changes. Build it in Google Sheets in under 90 minutes using your last 12 weeks of bank data.

Download the working template we use with clients: The Restaurant Cash Flow Model.

Why 13 weeks, not 4 and not 52

Four weeks is not enough visibility. Sales tax, payroll runs, quarterly vendor rebates, and lease payments do not all hit inside 30 days. You will miss cash cliffs sitting 6 to 10 weeks out.

Fifty-two weeks is more forecasting than the data supports. Restaurant volume is too seasonal and too event-driven to make a full year of weekly precision. You end up with false confidence in numbers that will move 30 to 50%.

Thirteen weeks is where operators can actually make decisions. It captures a full quarter of payroll cycles, sales tax payments, and vendor cycles. It is short enough that inputs stay reasonably reliable. And it maps to how banks think when they look at your books.

The row structure

Weeks across the top. Rows down the side, in this order:

1. Opening cash balance (rolls from prior week ending)
2. Cash inflows: dine-in sales, delivery sales (net of commissions), catering, gift card redemptions, refunds/rebates, other
3. Total cash in
4. Cash outflows: food COGS payments, beverage COGS payments, hourly payroll (biweekly), salaried payroll (biweekly), payroll taxes and benefits, rent, utilities, insurance, credit card fees, delivery commissions if paid separately, software subscriptions, R&M, marketing, sales tax remittance, other vendors, loan payments, owner distributions, capex (capital spending: ovens, buildouts, big one-time purchases) (capital expenditures, one-time spending on equipment or build-out)
5. Total cash out
6. Net weekly change
7. Closing cash balance
8. Minimum cash covenant (from your bank agreement, or the number you never want to go below)
9. Cushion vs. minimum (early warning)

Each row should be sourced, not typed. If you cannot point to a report or bill that generated the number, do not include it.

The three timing traps that break the model

Most cash flow models fail on timing, not amounts. Three specific traps:

1. Card settlement lag

Card sales on Monday do not appear in your bank account until Tuesday or Wednesday. On weekends and holidays, the lag stretches to 3 to 5 days. Model card revenue with a 2-day average delay, or your Week 1 will look better than it actually is and Week 2 worse.

2. Payroll double-hit weeks

Two payroll dates land in the same week roughly every 12 weeks. Your model needs to capture that. Miss it and your cash trough shows up 40 to 60% too shallow.

3. Vendor terms that are not really 30 days

Sysco and US Foods bill weekly but net your terms across all invoices in the billing cycle. The actual cash out date is often 5 to 9 days later than the invoice date on the paper. Look at your bank data to confirm the real cash timing, not the paper terms.

Populating the sheet from bank data

Pull the last 12 weeks of your business checking. Categorize each transaction into the row categories above. Compute a per-week average for each row. That is your baseline. Then adjust for:

• Known one-time items in the forward 13 weeks (equipment purchase, tax deposit, deposit refund)
• Seasonality on the sales side using last year’s same 13-week window
• Any known price or cost changes (menu price increase, new vendor contract)

Do not build from scratch every week. Build once, then update actuals. See our related post on why profitable restaurants still run out of cash for the operational context.

Sample 13-week outline for a $2.4M full service unit

Row	Weekly avg	Range across quarter
Dine-in sales (bank hit)	$38,000	$28,000 to $52,000
Delivery net	$6,200	$4,800 to $8,400
Food payments	$12,600	$9,500 to $16,000
Beverage payments	$3,400	$2,400 to $4,500
Payroll (single week)	$0 or $22,500	every other Friday
Rent (once monthly)	$9,800	first Tuesday of month
Sales tax (monthly)	$3,900	20th of month
Loan payment (monthly)	$4,200	first of month
All other operating	$5,600	$4,200 to $8,000

Sum inflows and outflows week by week. The cash cliffs are always the weeks when rent + payroll + sales tax land inside a 7-day window. Every quarter has one or two of them.

What to do when the model shows a trough

The forecast will show you a cash trough 4 to 9 weeks out. Options, in order of impact:

1. Delay a vendor payment. Not stop paying. Delay by 7 days after a phone call. Preserves the relationship, buys $10K to $25K.
2. Pull forward AR. If you cater or invoice for events, offer a 2% discount for 7-day pay.
3. Draw a portion of your credit line. If you have one, use it. That is what it is for.
4. Delay owner distributions. Not glamorous, but the fastest lever most owners have.
5. Push a bill 30 days. Only after conversation with the vendor. Do not surprise anyone.

Never skip payroll or sales tax. Those two lines are non-negotiable. Sales tax underpayment triggers penalties and personal liability. Missed payroll cascades into losing your best staff inside 30 days.

Weekly maintenance in under 20 minutes

Every Monday morning, replace the current week’s forecast column with actuals from the bank feed. Recompute the next 12 weeks. Compare closing cash against last week’s forecast for the same date. Look for the drift.

If actuals are consistently better than forecast, you are being too conservative and possibly missing growth investments. If actuals are consistently worse, your operating assumptions are off and you need to rerun the baseline.

Pair this with a daily financial dashboard for the operating layer.

Common mistakes that turn the model into wallpaper

• Building it once, never updating. A 13-week forecast that is 3 weeks stale is worse than no forecast.
• Only forecasting revenue. Cash timing is 70% of the value.
• Ignoring sales tax collection versus remittance. The money is in your account but it is not yours.
• Forgetting the quarterly vendor rebate that lands in Week 11 and creates false comfort.
• Forecasting salaried payroll as an even weekly number rather than actual pay-cycle timing.

For an operator’s overview of the whole finance stack, see what the top 3% of restaurant CFOs do on Monday mornings.

FAQ

What software should I use to build this?

Google Sheets or Excel. Restaurant365 has a version of this built in, but the discipline is what matters, not the platform. If you are building manually the first time, use our free 13-week template.

How often should I update actuals?

Weekly at minimum. Monday morning is best because you have Friday and Saturday bank data settled.

Should I forecast delivery separately from dine-in?

Yes. Delivery has different working capital dynamics (commissions net at variable rates and cash lands on a different schedule). Separate rows make the model more useful when you want to change the mix.

Do I include gift card sales as revenue?

Only when redeemed for food. Gift card sale cash is liability, not revenue. Model it as an inflow with a matching liability line and recognize revenue when a card is used.

What is a healthy minimum cash balance?

Two weeks of average operating expenses is a floor. Four to six weeks is healthier. Above that, you are probably underinvesting in growth.

For the full 2026 benchmarks, see our State of Restaurant Finance report.