Free · Works in FLYNT Sheets

Cash Flow Forecast Template

A cash flow forecast that starts from your current cash balance, lays out expected cash coming in and going out, and calculates net cash flow and your projected ending balance automatically — the difference between being profitable on paper and actually having cash on hand.

Use this template in FLYNT SheetsHow to build one from scratch
Starting Cash Balance$15,000.00
Cash In — Sales & Revenue$18,000.00
Cash Out — Operating Expenses$9,500.00
Cash Out — Payroll$6,000.00
Cash Out — Other$1,200.00
Total Cash Out$16,700.00
Net Cash Flow$1,300.00
Ending Cash Balance$16,300.00

Green rows calculate automatically from the values above them — change any number in FLYNT Sheets and they update.

Who it's for

Small business owners managing tight or seasonal cash flow, who need to see a few weeks or months ahead rather than just looking at last month's numbers after the fact.

Key features

  • Starting cash balance as the baseline for the forecast
  • Separate cash-in and cash-out categories (operating expenses, payroll, other)
  • Total cash out, net cash flow, and ending balance all calculated automatically
  • Every input is editable — rerun the forecast instantly with different numbers

How to use it

  1. Click "Use this template" to open it in FLYNT Sheets
  2. Enter your actual starting cash balance
  3. Update expected cash in from sales and revenue for the period
  4. Update the cash-out categories — operating expenses, payroll, and other costs
  5. Review the calculated net cash flow and projected ending balance
  6. Duplicate the sheet for the next period to keep forecasting forward

What's included

  • Starting cash balance line
  • Cash-in line for sales and revenue
  • Three cash-out categories (operating expenses, payroll, other)
  • Total cash out, net cash flow, and ending balance formulas already wired up

Common use cases

  • Checking whether cash will run low before the next big invoice gets paid
  • Planning for a seasonal slow period in advance
  • Deciding whether now is the right time for a big purchase or hire
  • Preparing a forecast to discuss with a lender or investor

Frequently asked questions

Is the cash flow forecast template free?
Yes — it's available on FLYNT's free plan, no credit card required.
How is this different from the budget template?
A budget looks at revenue vs. expenses for a period on paper. A cash flow forecast tracks actual cash moving in and out and your resulting balance — a business can be profitable on a budget and still run short on cash if payments are timed badly. Using both together gives a fuller picture.
Can I forecast further than one period ahead?
The template is one forecast period by default. Duplicate the sheet (using the prior period's ending balance as the next one's starting balance) to chain forecasts forward — it's a real spreadsheet, not a fixed single-use form.
What if my cash-out categories don't match the template?
Edit or add rows freely — the total cash-out formula will pick up any row you add in that section.
Use this template in FLYNT Sheets

Related