Skip to content

Free template. Excel and Google Sheets.

Cash flow forecast template.

Plan the next 12 months of cash in and cash out, see your lowest month before it arrives, and download the sheet with its formulas. US and Canadian versions.

Your forecast

Cash in, 12 months
$661,500
Cash out, 12 months
$693,400
Net for the year
−$31,900

US version: sales tax and IRS estimated tax rows, in US dollars. The numbers are an example: type over any cell below and the forecast updates.

Lowest balanceUnder a month of costs
$16,450in July
NovDecJanFebMarAprMayJunJulAugSepOct
Cash in October$28,100
Months cash falls9 of 12
Sample 12-month cash flow forecast, US version, in US dollars
2026–27NovDecJanFebMarAprMayJunJulAugSepOctYear
Opening balance$60,000$55,850$53,700$42,150$37,000$30,350$17,800$18,650$17,000$16,450$23,300$22,650
Cash coming in
Customer payments $660,000
Other income $1,500
Loans and investment $0
Total cash in$44,000$46,000$48,000$50,000$52,000$54,000$56,000$59,500$60,000$62,000$64,000$66,000$661,500
Cash going out
Payroll $435,000
Rent and utilities $54,000
Software $22,800
Suppliers and inventory $72,000
Marketing $49,000
Sales tax paidUS $21,600
Estimated taxUS $24,000
Loan repayments $15,000
Total cash out$48,150$48,150$59,550$55,150$58,650$66,550$55,150$61,150$60,550$55,150$64,650$60,550$693,400
Net cash flow−$4,150−$2,150−$11,550−$5,150−$6,650−$12,550$850−$1,650−$550$6,850−$650$5,450−$31,900
Closing balance$55,850$53,700$42,150$37,000$30,350$17,800$18,650$17,000$16,450$23,300$22,650$28,100
Download it with your numbers and the formulas in place.

The method

How to build a cash flow forecast.

Start from the bank

Add up the cash in every business account today. That is the opening balance of your first month.

Opening balance = cash today

Place cash when it moves

Put each payment in the month it reaches or leaves the bank, not the month you send or get the invoice. Include tax payments.

Net = cash in − cash out

Carry it forward

Each month closes with the opening balance plus the net. That closing balance opens the next month.

Closing = opening + net

Two versions

The tax rows are where the US and Canada differ.

Tax payments are the cash that catches founders out, because they come in lumps. Each version of the template has the rows and the usual timing for its country.

US version

Sales tax and IRS estimated tax

  • Sales tax paid: what you collected, paid to each state monthly, quarterly or yearly, depending on the state.
  • Estimated tax: quarterly payments to the IRS, usually due in April, June, September and January.
  • Payroll: wages plus the payroll taxes you pay as the employer.
Canadian version

GST/HST and CRA instalments

  • GST/HST remitted: what you collected minus input tax credits, paid monthly, quarterly or yearly, depending on your filing period.
  • Tax instalments: payments to the CRA ahead of your tax bill, often quarterly in March, June, September and December.
  • Payroll: wages plus the source deductions you remit, usually by the 15th of the next month.

Due dates and frequencies depend on your business, your state or province and your filing history. Your accountant can confirm the ones that apply to you. This template is not tax advice.

Template or Nuvio

A spreadsheet is out of date the day after.

The template is the right start when you are planning. Once invoices and bills are moving, Nuvio keeps the forecast current for you.

The template

You type in every number

  • Update it by hand when a customer pays late or a bill changes.
  • One version of the future at a time.
  • Good for planning a year, a hire or a raise.
Nuvio

Built from your bank, invoices and bills

  • Starts from your bank balances and places every open invoice and unpaid bill on its due date.
  • Moves every time an invoice, a bill or a payment changes.
  • Three views: everything on time, you hold back payments, or no customer pays.
See cash flow forecasting in Nuvio

FAQ

Cash flow forecast questions, answered.

What is a cash flow forecast template?

A cash flow forecast template is a ready-made sheet for estimating your business’s cash month by month. You enter the cash you have today, the money you expect to receive and the payments you expect to make, and it works out the balance at the end of each month.

How do I make a cash flow forecast?

Start with the cash in your business accounts today. For each month, add the payments you expect to receive and subtract the payments you expect to make, in the month the money actually moves. The result is that month’s closing balance, which opens the next month.

Is the template free, and does it work in Excel and Google Sheets?

Yes. It is free with no sign-up. Download it as an Excel file that also opens in Google Sheets, or export a CSV. The totals and balances are formulas, so they update when you change a number.

What is the difference between the US and Canadian versions?

The tax rows. The US version has sales tax and IRS estimated tax payments. The Canadian version has GST/HST remittances and CRA tax instalments, and its amounts are in Canadian dollars.

Should I forecast 12 months or 13 weeks?

Twelve months suits planning: a hire, a price change or a fundraise. Thirteen weeks suits a tight quarter, when you need to know which week money runs low. Many businesses keep both. Nuvio shows either, from two weeks to a year ahead.

How is a cash flow forecast different from a budget or a profit forecast?

A budget sets what you plan to spend. A profit forecast counts sales when you invoice them. A cash flow forecast counts money only when it reaches or leaves the bank, so it shows whether you can pay the bills in a given month.

Let the forecast build itself.

Connect your bank and Nuvio places every invoice and bill on its due date, then keeps the forecast current.