Skip to content
Finance

Restaurant Cash Flow Forecast Calculator

Forecast restaurant cash flow from opening balance, sales, inflows, and expenses. See net cash flow, closing balance, burn, runway, and benchmark status.

Restaurant cash flow forecast formulas

Formula
Monthly mode:
  Total Inflows = Projected Sales + Cash Inflows
  Total Outflows = Food + Labor + Operating + Loan + Taxes + Other
  Net Cash Flow = Total Inflows - Total Outflows
  Closing Balance = Opening Balance + Net Cash Flow
  Cash Burn = max(0, -Net Cash Flow)
  Cash Runway = Opening Balance / Cash Burn when burn > 0

Multi-month mode:
  Per month: Net = Income - Expenses
  Closing = Prior Closing + Net
  Average Monthly Cash Flow = sum(Net) / months
  Lowest/Highest cash point from running balances

Benchmark:
  Excellent: positive cash flow every month
  Good: positive overall closing balance
  Average: small negative periods with cash remaining
  High Risk: negative trend with cash still on hand
  Critical: cash exhausted (closing <= 0)

What it means

Cash flow forecasting tracks money moving through the bank account. Monthly mode sums line-item inflows and outflows for one period. Multi-month mode rolls income and expense rows forward to show running balances. This page is not Sales Forecast (revenue projection), Labor Budget (wage target), or Break-even (volume floor).

Good to know

  • Figures reflect cash timing, not accrual profit.
  • Optional expense lines default to zero when left blank.
  • Runway uses opening balance divided by monthly burn when burn is positive.

Ideal range

  • Not Sales Forecast. Use Sales Forecast for revenue projections.
  • Not Labor Budget. Use Labor Budget for wage targets from projected sales.
  • Not Break-even. Use Break-even for fixed-cost volume floors.

Variables

Opening BalanceStarting cash
Cash on hand at the start of the forecast window.
InflowsCash received
Projected sales deposits plus other cash received.
OutflowsCash paid
Food, labor, rent, loans, taxes, and other cash payments.
Cash BurnMonthly deficit
The absolute value of negative net cash flow.

Assumptions

  • Benchmark bands reflect independent restaurant liquidity planning.

Limitations

  • No credit card float modeling, owner draw schedules, or tax accrual timing.

Worked examples

Real numbers through the same formula this tool uses.

  1. 1
    Restaurant scenarioExample 1

    50k opening with 125k inflows and 110k outflows

    Positive net cash flow produces 65k closing balance with excellent status.

  2. 2
    Restaurant scenarioExample 2

    40k opening over three mixed months

    Running balances show lowest and highest cash points with good overall status.

How to use the restaurant cash flow forecast calculator

Pick monthly or multi-month mode, enter cash on hand and your inflows and outflows, then read net cash flow and runway benchmarks.

  1. Choose monthly forecast or multi-month forecast

    Use monthly mode for one detailed month with separate expense lines. Use multi-month mode when each month has different income and expense totals.

  2. Enter opening cash balance

    Use the bank balance at the start of the period you are modeling.

  3. Enter projected sales, inflows, and expense lines

    Include food, labor, rent, loans, and taxes that leave the account in the same month.

  4. Add monthly income and expense rows

    One row per future month. Income is total cash in. Expenses is total cash out.

  5. Read net cash flow, closing balance, and runway

    Negative net cash flow shows burn. Runway shows how long opening cash lasts at that burn rate.

  6. Pair results with Sales Forecast and Labor Budget

    Project sales first, then check whether labor and purchasing fit the cash window.

How to read your cash flow forecast

Cash flow forecasting tracks money in and out of the bank, not profit on paper or sales projections alone.

  • Start with net cash flow

    That is total inflows minus total outflows for the month or row you entered.

  • Excellent (positive cash flow)

    More cash came in than went out. Reserves can grow if costs stay controlled.

  • Good (positive overall balance)

    Closing cash stays above zero even when one line item runs tight.

  • Average or High Risk

    Some months burn cash. Watch payroll dates, vendor terms, and loan payments.

  • Critical (cash exhausted)

    The forecast hits zero or below. Act before checks bounce or vendors stop delivery.

Best practices for restaurant cash flow forecasting

Cash forecasts work when they use the same timing your bank account sees.

  • Forecast cash, not accrual profit

    Sales on the P&L may not hit the bank for days. Use deposits and payment dates.

  • Include loans, taxes, and owner draws

    Missing one loan payment makes the forecast look healthier than the account.

  • Update the forecast when sales shift

    A slow week changes runway fast. Refresh after each payroll cycle.

  • Pair with Sales Forecast and Labor Budget

    Project sales first, then map labor and purchasing to the same window.

Common cash flow forecast mistakes

These errors make cash look stronger than the operating account.

  • Confusing profit with cash flow

    A profitable month can still run out of cash when vendors are paid before deposits clear.

  • Confusing cash flow with sales forecast

    Sales forecast projects revenue. Cash flow tracks what hits the bank after expenses.

  • Ignoring payroll and rent timing

    Two big outflows in the same week can zero out the account even with healthy sales.

  • Skipping a cash reserve line

    Use other expenses or a lower opening balance to reflect the reserve you will not spend.

People also ask

Short answers owners ask when they forecast restaurant cash flow.

  • What is a restaurant cash flow forecast?

    A cash flow forecast projects how much money enters and leaves the restaurant bank account over a future period.

  • How do you calculate restaurant cash flow?

    Subtract total cash outflows from total inflows for the period. Add the result to opening cash for closing balance.

  • What is cash runway?

    Cash runway is how many months the opening balance can cover at the current monthly burn rate.

  • How is cash flow different from sales forecast?

    Sales forecast projects revenue. Cash flow includes expenses, loans, and taxes that move the bank balance.

  • How is cash flow different from labor budget?

    Labor budget sets a wage target from sales. Cash flow shows whether all outflows leave enough cash on hand.

  • How is cash flow different from break-even?

    Break-even finds the sales volume to cover fixed costs. Cash flow tracks timing of money in and out.

  • What is a good cash runway for a restaurant?

    Many operators want at least one to three months of operating cash after payroll and rent.

  • What if one month is negative?

    One negative month is common in seasonal businesses. Watch the closing balance and the trend across months.

  • When should I use multi-month mode?

    Use it when you have different income and expense expectations for each upcoming month.

  • When should I use monthly forecast mode?

    Use it when you want one detailed month with separate lines for food, labor, rent, loans, and taxes.

Related tools and next steps

Use these when cash flow results meet revenue planning and labor targets.

  • Restaurant Sales Forecast Calculator

    Project monthly revenue before you map inflows in the cash flow forecast.

  • Restaurant Labor Budget Calculator

    Turn projected sales into a labor spending target for the same window.

  • Restaurant Break-even Calculator

    Find the sales volume needed to cover fixed costs when cash runs tight.

  • Restaurant Profit Margin Calculator

    Compare cash timing to profit margin when planning owner draws.

Frequently asked questions

You may also need

Complementary calculators that often pair with this workflow.

Continue exploring

More tools to browse after you finish this calculation.

Guides from the Learning Center that explain this topic.

Browse all guides in the Learning Center.