Free Cash Flow Forecast Template
Predict future cash needs, manage business liquidity, and avoid cash flow crises with a six-month cash flow forecasting template for small businesses.
What Is This Template?
Cash flow is the lifeblood of any small business. You can be profitable on paper and still run out of money if clients pay late, expenses spike unexpectedly, or a slow month hits harder than anticipated. Cash flow forecasting solves this problem by showing you exactly when money is expected to arrive and when bills are due — weeks and months in advance.
Our free cash flow forecast template gives you a six-month starting view of your business cash position, broken down by month. You enter your expected income and expenses, and the template calculates your opening and closing cash balance for each month, showing you whether you are moving toward a healthy surplus or heading for a shortfall you need to plan for now.
The template is used by small business owners to manage daily operations, by startups to demonstrate viability to lenders and investors, and by freelancers to plan for months when client work is slower or payments are delayed.
Unlike a profit and loss statement (which records profit on an accounting basis), the cash flow forecast tracks actual money movement — so you can see precisely what your bank balance will look like in three, six, or twelve months if your assumptions hold true.
Who Should Use This Template
- Product-based businesses managing inventory purchases, supplier payments, and payment terms with customers
- Service businesses with long invoice payment cycles or retainer-based income
- Freelancers with irregular income who need to know if next month's expenses are covered
- Startups preparing an initial cash forecast, then adapting its horizon and detail to lender or investor requirements
- Seasonal businesses (landscaping, tourism, retail) that need to plan for predictable revenue peaks and troughs
- Any small business owner who has ever been surprised by a negative bank balance despite having profitable months
How To Use This Template
- Step 1 — Enter your opening cash balance. Start with your current business bank account balance. This becomes Month 1's opening balance.
- Step 2 — Enter expected cash inflows. List all income sources and the month you expect to receive payment. Include client invoices, product sales, loan draws, and any other cash receipts. Use the date you expect money in your account — not when you invoice.
- Step 3 — Enter expected cash outflows. List every payment you expect to make: rent, supplier payments, loan repayments, salaries, tax payments, and overheads. Use the date each payment leaves your account.
- Step 4 — Review monthly closing balances. The template calculates closing balance = opening balance + inflows − outflows. Months with negative or dangerously low closing balances need attention.
- Step 5 — Plan for cash gaps. If the forecast shows a negative balance in any month, you have time to act: chase outstanding invoices, delay non-essential spending, arrange an overdraft, or adjust your billing timing.
- Step 6 — Update monthly. Save a dated copy of your forecast before entering actuals so you can compare them manually; there is no built-in variance tracking. To extend beyond six months, copy Month 6 to the right, rename the headings and extend the Lowest balance formula to include the new closing balances.
Formula and calculation model
- Month Closing Balance = Opening Balance + Total Inflows − Total Outflows
- Opening Balance (next month) = Closing Balance (current month)
- Lowest Balance in Period = the smallest of the six month-end closing balances. Compare it with the cash buffer you want to keep.
Assumptions in this version
- The forecast assumes all planned inflows/outflows materialize in the month you enter.
- It is a monthly model with a fixed six-month starter horizon.
- Opening balances from Month 2 onward link to the previous closing balance. Change receipts or payments to test a delay; leave those links intact.
What this template does not include
- It does not forecast variance against actuals automatically; this is a manual planning comparison.
- It cannot show a cash shortage between month ends. A positive closing balance can hide a bill due before a customer pays; check those dates separately.
- Late payments and credit risk need conservative assumptions entered by the user.
Example Scenario
Lisa's Photography Business — Cash Flow Gap Example
Lisa runs a wedding photography business. She uses the cash flow template and discovers a problem before it happens:
- November opening balance: $4,200
- Expected inflows: $1,500 (one booking deposit, no events in November)
- Expected outflows: $3,800 (rent $1,200, equipment loan $600, insurance renewal $800, software $200, marketing $500, owner draw $500)
- November closing balance: $1,900
- December inflows: $800 (another deposit). Outflows: $3,800. December closing balance: -$1,100
The forecast reveals a December cash shortfall 6 weeks in advance. Lisa responds by offering a December mini-session promotion (raising inflows by $1,500), deferring a marketing campaign until January, and contacting two outstanding clients for early payment. The crisis is avoided before it begins.
Common Mistakes to Avoid
- Confusing invoicing dates with payment dates. Enter when you expect to receive cash — not when you send the invoice. If your clients pay on 30-day terms, that money arrives a month later than the invoice date.
- Forgetting annual and quarterly payments. Tax instalments, annual software licences, insurance renewals, and professional memberships are predictable but often missing from cash flow forecasts until they hit the bank account.
- Being too optimistic with inflows. Forecast conservatively. If 20% of your invoices are paid late, build that delay into your model rather than assuming every client pays on time.
- Ignoring the difference between cash flow and profit. A profitable month can still damage cash flow if you pay expenses before clients pay you. Understand payment timing, not just totals.
- Only building one scenario. Create a base case plus optimistic and pessimistic cases using variance percentages you choose for your own business. The pessimistic scenario is often the most informative about risk.
Methodology & Accuracy
How this template produces its results, and the limits you should keep in mind when using them.
- Formula source
- The result is produced by the exact mathematical formula shown on this page. The formula is derived from the definition of the relationship between the inputs and the output (for example, profit margin is profit divided by revenue by definition). Where a formula relies on an external rule, rate, or convention, the authoritative source supporting that claim is linked in the Sources section below. The calculation has not been certified or approved by any professional body.
- Assumptions
- Calculations assume the figures you enter are accurate and apply to your situation. These are simplified models that may not capture every business scenario, and the estimates depend entirely on the values you select.
- Uncertainty and limitations
- Results are estimates based on the information entered. Actual financial outcomes may differ depending on business circumstances, market conditions, taxes, location, and other factors.
- Jurisdiction limitations
- Financial rules, taxes, lending practices, and business requirements may vary by location. Consider local requirements when making financial decisions based on these results.
- Tested with sample inputs
- The formulas in this template have been checked using the sample figures shown in the workbook to confirm the calculation logic produces expected results.
- Ownership and testing
- This template is maintained by Small Business Finance Toolkit. Its calculation can be checked using the sample figures shown on this page. It has not been certified or reviewed by a licensed financial professional. Found an error or outdated information? Contact us.
- Review status
- Sample checks are listed above where available. This page is documented as an educational tool and is updated before major edits using a documented review process.
Download Free Template
A six-month forecast with opening balances, receipts, total payments and closing balances, plus an Instructions sheet. Extend manually if needed. No built-in forecast-versus-actual variance tracking.
No sign-up required. Download, customize, and use the template for your own business needs.
- Free to use
- Editable formulas
- Example data included
- Instructions tab
- Google Sheets compatible
- No sign-up needed
Published and maintained by Small Business Finance Toolkit
Content updated: September 2026
This template was created using common small business cash flow planning principles. It helps entrepreneurs understand the timing differences between incoming revenue and outgoing expenses and organize financial planning assumptions. The template is an educational resource and does not replace professional accounting, tax, or financial advice.