Free 12-Month Cash Flow Forecast Template (Excel and Google Sheets)

Many profitable small businesses still run into trouble because cash runs out at the wrong moment: rent is due, but customers haven’t paid yet. A simple cash flow forecast shows you months ahead when money will be tight, so you can act early.

Download the free cash flow forecast template (.xlsx)

12-Month Cash Flow Forecast template preview with sample data
Preview of the 12-Month Cash Flow Forecast template with sample data. Download it above and replace the examples with your own.

What is inside

Section What it does
Cash in Cash sales, customer payments, loans or investment, other income
Cash out Rent, salaries, stock, utilities, marketing, loan repayments, taxes/VAT, equipment
Monthly summary Opening balance, net cash flow and closing balance for 12 months
Warnings Months below your minimum balance turn red, and the lowest balance is shown at the top
Automatic months Enter the first month once, and all 12 headers update

The sample data shows a typical pattern: two quieter months (months 8 and 9) push the balance below the warning level. That’s exactly what a forecast is for.

How to use it

  1. Set up: enter the first month, your current bank balance and the minimum cash you want to keep.
  2. Forecast cash in: when do you expect customers to actually pay? Use your sales history as a guide.
  3. Forecast cash out: fixed costs (rent, salaries) first, then variable costs (stock, marketing), then one-off payments (VAT, equipment).
  4. Check the warnings: look for red months and the lowest balance.
  5. Update monthly: replace forecasts with actual figures and add a new month at the end.

How a 12-month cash flow forecast works

Every month follows the same simple sum:

Opening balance + cash in − cash out = closing balance
and this month’s closing balance becomes next month’s opening balance.

Example for a small café:

Month Opening Cash in Cash out Closing
Month 1 5,000 12,000 11,000 6,000
Month 2 6,000 10,500 11,200 5,300
Month 3 (quiet) 5,300 7,000 10,800 1,500

If the café set a minimum balance of 2,000, month 3 would turn red in the template, two months ahead, giving the owner time to cut costs, chase customer payments or arrange finance.

Cash flow forecast vs cash flow projection

The two terms are used for the same thing: an estimate of the money coming in and going out over the next months. Some people use “projection” for longer, what-if plans and “forecast” for the realistic short-term view. This template works for both: start with your realistic numbers, then copy the sheet to try a “bad month” scenario.

What to do if cash looks tight

  • Get paid faster: send invoices immediately, ask for deposits, and offer easy payment links.
  • Chase overdue invoices every week.
  • Time big purchases for stronger months.
  • Negotiate longer payment terms with suppliers.
  • Talk to your bank early about a credit line, before you need it.

Profit vs cash flow

Profit is sales minus costs over a period. Cash flow is when money actually enters and leaves your bank. A business can be profitable on paper and still run out of cash if customers pay late. That’s why you need both. Learn the basics in bookkeeping basics for small businesses.

FAQ

How accurate does it need to be?
A realistic estimate is enough. Being a little cautious (lower income, higher costs) is safer than being optimistic.

Does it work in Google Sheets?
Yes. Import it with File → Import → Upload.

How do I make a 12-month cash flow forecast?
List your expected cash in and cash out for each month, start from today’s bank balance, and let the template carry each closing balance into the next month. Update it monthly with actual figures.

What is a good minimum cash balance?
Many small businesses aim to keep at least one to three months of fixed costs (rent, salaries, loan payments) in the bank. Set that number as your warning level.

Related templates

Leave a Comment