To build a 13-week cash flow forecast, list your starting bank balance, project the cash you expect to collect each week, subtract the cash you expect to pay out each week, and carry the ending balance forward into the next week. Repeat for 13 weeks (one quarter). The result shows the exact week your balance could dip too low, while you still have time to fix it.
A profit and loss statement tells you whether you made money. A cash flow forecast tells you whether you can make payroll on Friday. Those are different questions, and plenty of profitable restaurants have run out of cash because a big bill, a slow month, or a quarterly tax payment landed at the wrong time.
Why 13 weeks works
Thirteen weeks is long enough to see seasonal swings and quarterly obligations, but short enough that your estimates stay realistic. Restaurants live week to week: sales spike on holiday weekends, vendors bill on net-7 or net-14 terms, and payroll hits on a fixed schedule. A weekly view captures all of that. A monthly budget hides it.
Step 1: Start with real cash
Enter your actual bank balance today, not your book balance. Subtract any outstanding checks that have not cleared and add deposits in transit. If you also hold a cash drawer float or safe cash, track it separately so the forecast reflects spendable money.
Step 2: Forecast weekly cash in
Use last year's same weeks as a base, then adjust for trends. Your POS reports make this fast; How to Use Sales Data From Your POS shows which reports to pull. For deeper projection methods see How to Forecast Restaurant Revenue.
Remember timing. Card sales usually reach your bank one to three days later, third-party delivery payouts can lag a week, and catering deposits arrive before the event. Forecast when money lands, not when the meal is served.
Step 3: Forecast weekly cash out
| Cash out item | Typical timing | Forecasting tip |
|---|---|---|
| Payroll and payroll taxes | Weekly or biweekly | Use your actual schedule plus 10-12% for taxes |
| Food and beverage vendors | Net-7 to net-30 | Tie to expected sales, about 28-32% |
| Rent and CAM | 1st of month | Fixed, never skip it |
| Utilities | Monthly | Use last year, adjust for season |
| Sales tax remittance | Monthly or quarterly | Money you collected, not yours to spend |
| Loan payments | Monthly | Fixed |
| Insurance, licenses, repairs | Irregular | Spread an annual estimate or place in the week due |
Put sales tax and quarterly estimated taxes in the exact week they are due. These are the payments that surprise owners. Year-End Tax Planning for Restaurant Owners covers what to expect as the year closes.
Step 4: Set a minimum balance
Pick a floor, such as two weeks of payroll plus rent. Any week where the ending balance falls below that floor is a red flag. The goal is not to hit zero without bouncing a check; it is to stay above a cushion that lets you absorb a bad week.
Takeaway: Your forecast is useful only if you update it every week. Replace last week's estimate with actuals, push the horizon out one more week, and you always see 13 weeks ahead.
Step 5: Run what-if scenarios
Copy your forecast and test three situations: sales drop 10%, a major repair costs $4,000, or a vendor shortens payment terms. If any scenario pushes you below your floor, decide now what you would do. Options include delaying a purchase, negotiating terms, running a promotion, or tapping a line of credit. How to Improve Cash Reserves lists ways to build a buffer before you need it, and Cash Flow Management for Restaurants covers the day-to-day habits that support the forecast.
Holiday season: when forecasting pays off
Q4 is the classic cash trap. You buy extra inventory, hire seasonal staff, and pay bonuses, yet January and February often bring the slowest sales of the year. Map the post-holiday dip into weeks 10 to 13 so you are not caught short. See How to Prepare for a Busy Holiday Weekend for the operations side.
Keep it simple with the right tools
You do not need accounting software to start. A spreadsheet works, and the free worksheet above does the math for you. Cobblestone POS, a free all-in-one POS for independent restaurants, gives you the daily sales and payment reports you need to feed the "cash in" lines without monthly fees. Learn more at Cobblestone POS.
A weekly 15-minute routine
- Enter last week's actual sales deposits and payments.
- Compare to your forecast and note the gap.
- Adjust the next four weeks based on what you learned.
- Add any new bills or known events.
- Check the lowest projected balance and act if it is under your floor.
Do this every Monday and cash surprises become rare.
Download the free 13-week cash flow forecast (Excel)