12-Month Cash Flow Forecast

A cash flow forecast template projects your cash position month-by-month for the next 12 months — the single most important financial document for any founder who wants to avoid running out of money. This free cash flow forecast template uses monthly columns for revenue (split by channel), cost of goods sold, operating expenses, financing in/out, and opening / closing cash balances — the same structure your bank, accountant, or angel investor will expect. PDF is print-ready; rebuild in Excel or Google Sheets by copying the column structure for live editing.

Structure of this 12-month cash flow forecast template

The cash flow forecast template uses 12 monthly columns (M1 through M12) plus a Total column. Rows are grouped into four sections. Cash In captures revenue by channel plus one-time income (loans, investment). Cash Out — COGS captures variable costs that scale with revenue (hosting, API costs, payment-processor fees). Cash Out — Operating Expenses captures fixed costs (salaries, rent, software, marketing baseline, legal). Cash Out — Financing captures loan repayments and founder draws. Opening + Cash In − Cash Out = Closing.

How to fill out the cash flow forecast template

Start with the opening cash balance (your current bank balance on Day 1). Project revenue by channel with realistic month-over-month growth — be more conservative than the deck. List every recurring operating expense; subscriptions are usually under-counted. Annualised payments (insurance, tax estimates) should be placed in the months they actually leave the account, not divided evenly. The cash flow forecast template's closing balance for each month becomes the next month's opening balance. Watch the trend line: if any month's closing balance is negative, you have a runway problem to solve before it becomes a crisis.

Why every founder needs a cash flow forecast template

Cash flow is the only metric that can kill a profitable business. A company can be profitable on paper (positive net income) and still go bankrupt because customers pay 60 days late while suppliers demand payment in 30. The cash flow forecast template forces you to face this timing reality month-by-month. Banks require a cash flow forecast for any loan. Investors expect a 12-month cash flow forecast in any data room. Accountants use it for tax planning. Founders who run a cash flow forecast template monthly raise their next round earlier (because they see the runway clock) and negotiate better terms.

Frequently asked questions

What's the difference between cash flow and profit?

Profit is revenue minus expenses recognised in the same accounting period; cash flow is actual cash moving in and out of the bank account in the same period. They diverge whenever there's a payment timing gap — customer pays 60 days after invoice, supplier requires payment in 30. A business can be profitable and run out of cash. The cash flow forecast template surfaces this risk month-by-month.

How accurate does a cash flow forecast need to be?

Month 1 should be within 5% — those numbers are mostly known. Months 2-3 should be within 15-20% — close enough to plan. Months 6-12 are scenarios, not predictions; recheck monthly. The point of a cash flow forecast template isn't precision-to-the-dollar; it's to surface runway risk early enough to react.

Should I include sales tax in the cash flow forecast template?

Yes — sales tax / VAT is real cash that hits and leaves your bank account. Even though it's not your revenue, you collect it on every sale and remit it monthly or quarterly to the tax authority. Forgetting to model sales tax remittance in the cash flow forecast template causes nasty surprises in the month it's due.

Can I use this cash flow forecast template in Excel?

Yes. The PDF is the design; recreate the column and row structure in Excel or Google Sheets for live editing. The Excel version will let you formulaically connect each month's closing balance to the next month's opening balance, automatically update totals, and add sensitivity scenarios (best case / base case / worst case revenue rows).

Related free resources: Burn Rate & Runway calculator · Business Plan template