PromptPilot logoPromptPilot

Small business playbook / cash flow

Small business cash flow forecast: a practical guide

A simple forecast maps when money is expected to arrive and when it needs to leave. The goal is a clearer view of cash timing, one period at a time.

The basic calculation

Starting cashCash inCash outEnding cash

01 / The moving parts

What a simple forecast tracks

A cash flow forecast estimates your cash balance across future weeks or months. For each period, record the cash you expect to have at the start, the money you expect to collect, and the payments you expect to make. The result is the estimated cash left at the end of that period.

Track cash by its expected arrival or payment date. That makes a forecast different from a profit report: a sale can be recorded before a customer pays, and a bill can be due after you receive it. The timing still affects the cash available in between.

02 / Set up the view

Build a forecast one period at a time

  1. Choose a useful time range

    Start with weeks if near-term payment dates matter most, or months if you want a broader view. Keep each period consistent so the ending balance for one period becomes the starting balance for the next.

  2. Write down cash in and cash out

    For inflows, include customer payments on the dates you reasonably expect to receive them. For outflows, include bills, payroll, rent, supplier payments, subscriptions, debt payments, taxes, and one-time purchases when they are due. Add a short note for estimates you may need to revisit.

  3. Calculate the ending balance

    Add expected inflows to starting cash, then subtract expected outflows. Carry that ending cash into the next period as its starting cash.

Illustrative example — not a business outcome

If a period starts with $4,000, has $6,500 in expected cash receipts, and $5,200 in expected payments:

$4,000 + $6,500 − $5,200 = $5,300 estimated ending cash

Replace these sample figures with your own dates and estimates. The result is only as current as the assumptions you enter.

03 / Keep it current

Review it weekly and monthly

Each week, compare expected receipts and payments with what actually cleared. Update the starting cash to match your current records, move delayed receipts or bills to their new expected dates, and refresh estimates that have changed.

At month end, compare the forecast with actual totals. Look for repeated differences, such as customers regularly paying later than expected or a recurring bill missing from the plan. Use what you learn to adjust future periods and check that the rolling cash balance carries forward correctly.

04 / Check the details

Common setup mistakes to avoid

  • Using invoice dates instead of collection dates. Forecast when you expect cash to arrive, and update that date if payment is delayed.
  • Forgetting irregular or one-time payments. Include annual renewals, equipment, deposits, and other non-monthly costs in the period when you expect to pay them.
  • Counting a recurring item twice—or not at all. Check recurring rows against recent statements and make sure the schedule covers the full forecast.
  • Starting from an old or unclear balance. Record the cash position as of the forecast’s start date, and keep the date visible.
  • Mixing transfers with income or expenses. Moving cash between your own accounts is different from a new receipt or payment. Track it consistently so the same money is not counted twice.

A workbook to start with

Put the moving parts in one place

The Small Business Cash Flow Dashboard workbook has Instructions, Income, Expenses, and Dashboard sheets, with monthly SUMIFS totals, net cash flow, a rolling cash position, starter entries, and a native chart.

View workbook details

This guide is general educational information, not professional financial or tax advice. Consider a qualified professional for decisions specific to your business.