Cash-flow forecasting
13-Week Restaurant Cash-Flow Forecast
See when cash is expected to enter and leave the bank account, identify a future shortage, and give yourself time to change the plan.
A restaurant can report a profit and still run short of cash. Card deposits arrive after the sale. Delivery platforms follow their own payout schedules. Payroll clears on fixed dates. Rent, sales tax, debt, and a failed compressor do not wait for the P&L to catch up. A 13-week cash-flow forecast puts those events on one weekly timeline.
Accounting Forward is a CPA-led accounting and fractional CFO firm working exclusively with restaurants. We provide restaurant bookkeeping, financial reporting, cash-flow forecasting, and CFO advisory to single-location and multi-location restaurant operators nationwide. This template reflects the way restaurant cash actually moves: by deposit and payment date, not only by accounting period.
What a 13-week cash-flow forecast is
A 13-week forecast is a rolling, week-by-week estimate of cash receipts, cash payments, and ending cash for the next quarter. It begins with available cash, adds deposits expected to clear, subtracts payments expected to clear, and compares the resulting balance with management's minimum cash target.
Shortfall or surplus = Ending cash − Minimum cash target
The model is direct-method cash forecasting. It does not start with accounting profit and adjust noncash items. It lists real bank activity: sales receipts, delivery deposits, catering deposits, vendor payments, payroll, taxes, rent, card fees, utilities, insurance, debt, repairs, distributions, and other operating payments.
Why update it every week
The usefulness of a forecast comes from its rhythm. Each week, replace the completed week's estimates with actual cash activity, revise the next several weeks using current sales and payment information, and add a new Week 13. The first two to four weeks should be relatively detailed because invoices, payroll, tax dates, and planned transfers are known. Later weeks can rely more on operating assumptions.
A monthly update leaves too much time for conditions to change. A weekly update catches a delayed catering payment, a higher food order, an unexpected repair, or a tax payment before those items combine into a problem. The goal is not perfect prediction. It is earlier notice and better decisions.
How this differs from a budget and P&L
A budget describes the operating plan, usually by month, and often uses accrual accounting. A P&L reports revenue earned and expenses incurred during a past period. Neither tells you exactly when money will clear the bank. The cash-flow forecast answers that timing question.
For example, a September catering event may appear as September revenue, while its deposit arrived in August and the balance is collected in October. A food invoice may be included in September COGS but paid in October under vendor terms. The forecast places both amounts in the weeks the cash is expected to move. Use all three tools together: budget for plan, P&L for performance, and 13-week forecast for liquidity.
How to use the restaurant template
- Set the week dates. Start with the coming Monday or the start of your operating week.
- Confirm beginning cash. Use reconciled, available operating cash. Exclude restricted balances or funds you cannot spend.
- Enter receipts by clearing date. Forecast card settlements and cash deposits under weekly sales receipts. Enter delivery-platform payouts and catering deposits separately because their timing differs.
- Enter payments by clearing date. Use AP aging, vendor terms, payroll calendars, rent documents, tax deadlines, debt schedules, insurance dates, and approved capital or repair plans.
- Set the minimum cash target. This is an internal guardrail, not a universal benchmark. Base it on payroll, fixed obligations, revenue volatility, seasonality, vendor terms, and access to capital.
- Review the first negative gap. When projected ending cash falls below the target, the shortfall/surplus line becomes negative. That week is the decision deadline, not the week to begin thinking.
Illustrative restaurant example
The following numbers are illustrative. Assume one restaurant begins Week 1 with $80,000. It expects $52,000 of sales receipts, $7,500 of delivery deposits, and no catering deposit. Known payments total $61,100, including a rent week.
| Illustrative Week 1 item | Amount |
|---|---|
| Beginning cash | $80,000 |
| Total expected receipts | $59,500 |
| Food and beverage vendors | ($18,500) |
| Payroll, taxes, and benefits | ($22,100) |
| Rent and occupancy | ($12,000) |
| Other scheduled payments | ($8,500) |
| Net weekly cash movement | ($1,600) |
| Ending cash | $78,400 |
| Minimum cash target | $45,000 |
| Projected surplus | $33,400 |
If Week 4 then includes a sales-tax payment, owner distribution, and equipment repair that push ending cash to $39,000, the model shows a $6,000 shortfall against the $45,000 target. Management can test specific responses: move a discretionary distribution, accelerate a catering collection, negotiate an invoice date, reduce an upcoming order using inventory on hand, or arrange financing. The forecast should make timing visible, not justify delaying required tax, payroll, or vendor obligations.
Single-location and multi-location use
A single restaurant can operate one forecast using its main operating accounts. A restaurant group should usually prepare a location-level view plus a consolidated view. Location forecasts reveal where cash is generated and consumed. The consolidated view includes shared payroll, corporate overhead, debt, intercompany transfers, and the actual cash available to the group.
Do not double-count transfers. A transfer from Location A to a central account is an outflow in one view and an inflow in another, but it must eliminate from the consolidated forecast. Maintain one owner for assumptions and document which deposits and payments belong to each entity and account.
Common forecasting mistakes
- Forecasting sales instead of bank deposits and ignoring processor or platform timing.
- Spreading rent, taxes, insurance, and debt evenly instead of using actual due dates.
- Using purchases as food cost in the P&L or using food cost as vendor cash payments in the forecast. They answer different questions.
- Leaving owner distributions, equipment purchases, or intercompany transfers outside the model.
- Assuming every week resembles an average week despite seasonality, holidays, closures, and events.
- Setting an arbitrary minimum balance without considering payroll and other obligations.
- Failing to compare prior forecasts with actual results, which prevents assumptions from improving.
FAQ
Should credit-card processing fees be netted against sales receipts?
Either method can work if applied consistently. Showing gross settlements and fees separately gives better visibility. If the processor deposits net amounts, reconcile the two lines to the actual settlement report.
Should the forecast include an unused line of credit?
Keep operating cash separate from borrowing capacity. Add a financing section if management has a committed facility and wants to model draws and repayments. Do not treat unapproved borrowing as available cash.
How accurate should Week 13 be?
Less accurate than Week 1. The model should become more detailed as each week approaches. Record assumptions so management can update them quickly.
Can the workbook be opened in Google Sheets?
Yes. Upload the Excel file to Google Drive and open it with Google Sheets. Review formatting after import and preserve the formulas when rolling the model.
For related operating guidance, read Restaurant Cash-Flow Planning, Why a Profitable Restaurant Can Run Out of Cash, or see our fractional CFO services for restaurants.
This resource provides general educational information and does not replace accounting, tax, legal, lending, or financial advice based on your restaurant's individual financial situation.