12-Month Rolling Cash Flow Forecast — Excel & Google Sheets

Description

Running a small business means juggling invoices, expenses, tax deadlines and payroll — often with no clear picture of what your bank balance will look like three months from now. This Cash Flow Forecast template gives you that picture, automatically, for a full 12 months ahead.

Built for freelancers, consultants, and small business owners, this workbook rolls forward month by month from whatever start date you choose. Enter your expected income and expenses once, and every total, subtotal, and closing balance updates instantly.

What’s inside:

• Start Here guide — plain-language instructions and a colour key so you know exactly what to edit
• Settings tab — set your business name, currency, forecast start month, and opening cash balance in one place
• 12-Month Forecast — a full month-by-month breakdown covering cash inflows (sales, other income, capital), operating expenses (rent, salaries, software, marketing, fees, and more), and tax, financing and other outflows (VAT, provisional tax, loan repayments, owner drawings, capex)
• Automatic closing balance carry-forward — each month’s closing balance becomes next month’s opening balance, with built-in red highlighting the moment your cash position goes negative
• Dashboard — KPI cards (opening and closing balance, total and average net cash flow, lowest monthly balance, cash runway), plus a cash position trend chart and an inflows-vs-outflows bar chart
• Assumptions tab — growth-rate drivers, VAT and provisional tax rate fields, minimum cash buffer target, and South African tax/compliance reminders (VAT, provisional tax, PAYE deadlines)

Why it works:

Every number flows from formulas, not hardcoded values — change one input and your entire 12-month picture recalculates. Built using industry-standard colour coding (blue = your inputs, black = automatic calculations) so you always know what’s safe to edit.

Formats included: Excel (.xlsx) and Google Sheets (import-ready, identical layout)

Best for: freelancers, consultants, agencies, contractors, and any small business that wants to see cash shortfalls coming — not find out the hard way.

This template is a planning tool, not tax or financial advice. Confirm deadlines and rates with SARS or your accountant.