Restaurant Cash Flow Forecast: A 13-Week Worked Example

A restaurant cash flow forecast maps when money is expected to reach and leave the bank. A restaurant cash flow projection is the same forward-looking schedule here; a cash flow statement reports a completed period. It connects service sales to card settlements, supplier due dates, payroll funding and other commitments. Use actual payment dates: a profitable month can still contain a day when the bank balance is too low to fund payroll.

This guide builds one fictional US-dollar counter-service restaurant forecast over 13 weeks. The amounts, payment calendar and $8,000 minimum balance are invented planning assumptions, not restaurant benchmarks or a recommended reserve. The method can be adapted to another currency; US payment-provider examples are identified separately.

The restaurant cash flow forecast formula

Closing cash = opening cash + cash receipts − cash payments. Carry the closing balance into the following week. Then calculate headroom = closing cash − your chosen minimum cash balance. A negative headroom means the forecast falls below that planning floor, even when the bank balance is positive. A negative closing balance is an unfunded requirement, not permission to overdraw.

For a restaurant, forecast receipts from cash deposits, card settlements, delivery-platform payouts, catering collections and other confirmed inflows. Forecast payments from the supplier ledger, payroll funding calendar, lease, utilities, loan schedule and other commitments. Depreciation is not a cash payment. An inventory payment or loan-principal payment can use cash even though it is not the same period's operating expense.

Start with six records you can reconcile

1. Opening bank position: reconcile the included accounts, outstanding payments and any genuinely restricted cash. Record which accounts are included; transfers between them are not new income.
2. POS sales and tender split: separate physical cash, cards, delivery platforms and credit catering invoices. Keep food sales, sales tax, tips, refunds and discounts distinguishable.
3. Processor settlement reports: match gross transactions, deductions, refunds, disputes and the deposits expected in the bank. Check the current payout settings rather than assuming sales settle immediately.
4. Supplier payment schedule: list invoice amounts and agreed due dates, including opening unpaid bills. A food-cost percentage can estimate purchasing needs, but it does not establish when a supplier is paid.
5. Payroll funding calendar: include wages and employer costs on the dates cash is needed. If net wages, withheld amounts and remittances are listed separately, reconcile them to the gross payroll so they are counted once.
6. Nonweekly commitments: add rent, insurance renewals, equipment, loan principal and interest, tax remittances and owner withdrawals in the appropriate periods.

Choose a consistent gross or net cash convention. For example, if card deposits enter the forecast after processing fees, do not subtract those fees again. If receipts include collected sales tax and tips, include the associated payments once. If you exclude a ring-fenced balance from opening cash, do not treat the same amount as a new reserve deduction. These are reconciliation rules; actual payroll and tax obligations depend on the business.

Turn restaurant sales into bank receipts

The restaurant sales forecast estimates orders, average checks and service days. A cash projection asks a different question: which week's bank deposits will those sales generate? Build a settlement bridge by channel before adding receipts to the cash schedule.

Suppose $10,000 of card transactions is expected to generate $9,700 after hypothetical $300 deductions. If $7,700 arrives this week and $2,000 next week, enter those deposits in their respective weeks. Do not also enter the $10,000 as immediate cash. Reconcile the unsettled $2,000 and the deductions to the processor report. These invented figures are not a payment-provider fee quote.

Square's US transfer-options documentation, checked October 18, 2026, explains that transfer timing varies with the selected option, cutoff, weekends and holidays. Use the schedule shown in your own account and bank records. Another processor or delivery marketplace may use a different cycle; an assumed faster payout is not available cash.

Catering deposits and gift-card sales also require care. A receipt today can fund a future service obligation without representing earned revenue today. When an earlier deposit is applied to an event or a gift card is redeemed, do not enter the same cash again. Retain a separate liability and fulfillment record instead of treating every receipt as free-to-spend profit.

A complete 13-week restaurant cash flow example

Opening cash is $18,000. Payroll funding is $18,000 every second week, including the employer costs assumed for this example. Supplier payments vary by week. Other payments include $4,000 operating payments and $1,500 owner drawings each week, plus $6,000 rent in weeks 1, 5, 9 and 13. Week 4 also contains a $6,500 sales-tax remittance and an $8,500 equipment purchase. Owner drawings are separate from employee payroll.

The fictional receipt estimates are bank/cash deposits after processor deductions and include the collected sales tax relevant to the scheduled remittance. The example assumes no tips and no additional financing, tax, refunds or other flows beyond those stated. An actual forecast must add every applicable line, including opening liabilities and remittances beyond this horizon. Week numbers are relative planning periods; the invented four-week rent pattern is not a calendar-month schedule. Replace it with the dates in your lease. A zero row means none is assumed here, not that the cost is unnecessary.

Week 4 demonstrates the issue: $23,000 + $27,000 − $8,000 − $18,000 − $20,500 = $3,500. Its $20,500 other-payments total is $5,500 regular payments + $6,500 tax + $8,500 equipment. Against the chosen $8,000 floor, the shortfall is $4,500. The quarter ends at $46,500, but that later balance does not fund an earlier payment.

Weekly closing balances can hide a midweek funding failure. If Friday deposits are needed for Tuesday's payroll, add a daily schedule around that week. Thirteen weeks is the selected near-term planning window, not a universal rule. A longer lease, seasonal closure or later obligation may require a longer view.

Why a positive week can still miss payroll

Allocate the same base-case week 4 across five illustrative business days. Start Monday with $23,000. The weekly receipts remain $27,000 and weekly payments remain $46,500; only their order is now visible. Assume no further weekend cash movements in this extract. This is an invented allocation, separate from the later $6,000 payout-delay stress test.

The weekly closing balance is still $3,500, but Tuesday's payroll funding produces a $3,000 unfunded gap. Reaching the chosen $8,000 floor at that daily low point would instead require $11,000. These are alternative targets, not two amounts to add together. A negative cell is a warning that the plan is not funded; the table does not assume an authorized overdraft or say that payroll can be delayed.

A confirmed available funding source or an actually adjustable commitment must be evaluated before that date. When the bank posts several transactions on one day, check their order and cleared availability as well; an end-of-day forecast can still miss an intraday shortfall.

Test a payout delay before choosing a response

Delay $6,000 from week 4 to week 5. Change only those two receipt cells: week 4 becomes $21,000 and week 5 becomes $32,500. Week 4 closing cash falls from $3,500 to negative $2,500. Week 5 returns to the original $10,500 because the delayed amount is then received. The amount needed to reach the $8,000 planning floor at the low point is $10,500. Reaching zero instead would require $2,500. Do not add both as separate funding needs.

Separately, move an uncommitted equipment purchase. In the original base case, moving the $8,500 purchase from week 4 to week 7 raises week 4 closing cash to $12,000. The lowest weekly closing balance becomes $12,000; week 7 and later closing balances return to their original values after the purchase is paid. The total purchase cost has not disappeared. This is a separate scenario, not combined with the delayed-receipt scenario.

Only change a payment date if it can actually change. Confirm supplier terms, service continuity and any cancellation cost before moving a commitment. Do not model delayed wages or statutory payments as an automatic solution. A funding option is not cash until its availability, timing, cost and conditions are confirmed. If a shortfall cannot be resolved, escalate the decision before the affected service week.

Reproduce this restaurant cash flow forecast in Excel

Create eight columns matching the worked table: A Week, B Opening cash, C Receipts, D Suppliers, E Payroll, F Other payments, G Closing cash, H Headroom. Use row 1 for headings and rows 2–14 for the 13 weeks. Enter the chosen $8,000 minimum in K2. Enter $18,000 in B2 and the example's receipts and payment amounts as numeric values in C2:F14.

G2 = B2+C2-SUM(D2:F2)
H2 = G2-$K$2
B3 = G2

Fill G2:H2 down through row 14. Fill B3 down through B14 so each opening cash value references the prior closing balance. Keep negative cash values visible. These English-language formulas may need the separator convention used by your spreadsheet locale.

Do not add K4 and K5: they answer different questions. Label the summaries weekly, because they do not include the daily supplement's lower balance. Before changing a scenario, preserve the base case and change only the intended receipt or payment cells. Keep a source reference and due date in a supporting ledger for every grouped payment.

The existing cash flow forecast tool and downloadable template offers another way to enter dated cash movements. Its layout is separate from the A:H worksheet above; do not assume that its cells or categories use these exact addresses.

Keep cash, the monthly budget and break-even connected

A monthly restaurant budget compares planned sales and operating costs with actual results. A cash forecast schedules receipts and payments. The restaurant break-even calculator estimates the service volume needed to cover the entered contribution and monthly funding target; it does not produce this bank-date forecast.

Use all three views. Loan proceeds increase cash without becoming restaurant sales. Loan principal and equipment purchases reduce cash without automatically becoming current operating expenses. Depreciation affects an accounting profit measure without creating the same cash payment that week. Owner drawings use cash but are different from paying a wage for work. Define these boundaries before comparing results.

Improving menu contribution can help future cash generation, but it cannot bring a later settlement into an earlier week by itself. For service economics, continue with restaurant prime cost and delivery-app contribution per order. Keep channel fees consistent between the profit model and the bank receipt bridge.

Run a weekly forecast-to-actual review

1. Replace the completed week's estimates with reconciled deposits and payments.
2. Explain material differences as volume, price, cost, missing entry or timing. A late collection is different from a permanently lost sale.
3. Update unsettled card balances, unpaid supplier invoices and payroll funding dates.
4. Recalculate the lowest closing balance and the minimum headroom across every remaining week.
5. Assign an owner and decision date to each action. Keep a dated record of changed assumptions.
6. Add one week at the end so the forecast remains rolling; carry forward later obligations instead of letting them vanish.

For a worksheet, use the existing 13-week cash flow forecast tool and template. Opening that tool does not load the restaurant example. Enter your own receipts and payment categories, reconcile any grouped costs, and keep the detailed restaurant ledger as support. Use a daily supplement when weekly totals are too coarse.

Sources, method and limits

Sources reviewed October 18, 2026. OpenStax's short-term planning chapter explains a cash budget's opening balance, collections, disbursements and rolling periods. The SBA's forecasting explanation emphasizes monitoring business drivers and comparing forecasts with actual results. Square's transfer guidance above supplies a specific payout-timing example, not a promise for every restaurant.

The 13-week amounts, planning floor and stress tests are original hypothetical examples constructed for this guide; they are not sourced industry averages or customer results. This is a management planning explanation, not a financial statement, lending offer or tax filing instruction. Replace the assumptions with reconciled business records and review material accounting or funding decisions with the appropriate adviser.