Cash Flow Forecast Template: Structure and How to Build One
A cash flow forecast template gives you a reusable structure for projecting cash inflows and outflows. Here is what a cash flow forecast template includes, the line items, a worked structure, and how AI agents replace the spreadsheet.
Most cash flow forecasts start life as a spreadsheet, and a good cash flow forecast template is what makes that spreadsheet useful: a clear, reusable structure for projecting the cash coming in and going out, period by period, so you can see your future cash balance. This guide lays out what a cash flow forecast template should include, the standard line items, a structure you can copy, and why AI agents are increasingly replacing the template altogether.
What is a cash flow forecast template?
A cash flow forecast template is a reusable layout, usually a spreadsheet, that structures a projection of cash inflows and outflows over a set of future periods (weeks, months, or quarters). It starts from the current cash balance, adds expected inflows, subtracts expected outflows, and carries the ending balance forward period to period, so you can see when cash will be tight or strong. The template is the frame; you fill it with your numbers each cycle.
A cash flow forecast template answers one question on repeat: given what we expect to collect and pay, how much cash will we have at the end of each period? The structure is simple; keeping it filled with current numbers is the work.
What a cash flow forecast template includes
A complete template has four sections, period by period across the columns:
- Opening cash balance. The cash you start each period with (last period's closing balance).
- Cash inflows. Customer receipts, financing, interest, and other cash in.
- Cash outflows. Payroll, suppliers, rent, debt service, taxes, capital spending, and other cash out.
- Net cash flow and closing balance. Inflows minus outflows, added to the opening balance to get the closing balance, which carries to the next period.
A cash flow forecast template structure
The core layout, with periods across the top:
| Line item | Period 1 | Period 2 | Period 3 |
|---|---|---|---|
| Opening cash balance | $100,000 | $110,000 | $95,000 |
| + Customer receipts | $60,000 | $45,000 | $70,000 |
| + Other inflows | $0 | $0 | $10,000 |
| − Payroll | ($30,000) | ($30,000) | ($30,000) |
| − Suppliers & expenses | ($15,000) | ($25,000) | ($18,000) |
| − Other outflows | ($5,000) | ($5,000) | ($5,000) |
| Net cash flow | $10,000 | ($15,000) | $27,000 |
| Closing cash balance | $110,000 | $95,000 | $122,000 |
The closing balance of each period becomes the opening balance of the next. Add as many periods as your horizon needs, weekly for a 13-week cash flow forecast, monthly for a longer view. Choose the direct method (actual expected receipts and payments, as above) for short-term liquidity.
Tips for a useful template
- Base inflows on real data. Drive customer receipts from the AR aging and payment patterns, not a guess.
- Time outflows precisely. Map payroll, large supplier payments, and debt service to the exact period they hit.
- Compare forecast to actuals. Add an actuals column each period to see where the forecast drifts and improve it.
- Keep it rolling. Refresh every period, dropping the oldest and adding a new one at the end.
The problem with templates, and what replaces them
A template is only as good as how current it is, and that is the catch. Every cycle, someone has to pull bank balances, update receipts from the AR aging, re-time payments from the AP schedule, and reconcile against actuals, by hand. The spreadsheet goes stale immediately, and a stale forecast is a guess.
This is why AI agents are increasingly replacing the template. Instead of filling a spreadsheet each cycle, an agent connects to your banking, ERP, and billing data, builds the forecast, and keeps it current automatically, with every number traceable to source. You get the structure of the template without the manual upkeep. That is how Concourse approaches forecasting. See AI cash flow forecasting and the best cash forecasting tools.
Frequently asked questions
What is a cash flow forecast template?
A cash flow forecast template is a reusable layout, usually a spreadsheet, that structures a projection of cash inflows and outflows across future periods. It starts from the opening cash balance, adds inflows, subtracts outflows, and carries the closing balance forward so you can see future cash positions.
What should a cash flow forecast template include?
Four sections across each period: opening cash balance, cash inflows (receipts, financing), cash outflows (payroll, suppliers, rent, debt, taxes), and net cash flow plus closing balance. The closing balance of one period becomes the opening balance of the next.
How do you build a cash flow forecast in Excel?
Lay out periods across the columns and the line items down the rows: opening balance, inflows, outflows, net cash flow, and closing balance. Drive inflows from the AR aging and outflows from the AP schedule, then refresh each period. The limitation is keeping it current by hand.
Is there a better option than a spreadsheet template?
Yes. AI agents can build and continuously maintain a cash flow forecast from live banking, ERP, and billing data, giving you the template's structure without the manual upkeep, and keeping every number traceable to source so the forecast stays current instead of going stale.
The bottom line
A cash flow forecast template gives you a clean, reusable structure, opening balance, inflows, outflows, closing balance, period by period, to project your future cash. Use the structure above as a starting point. But remember the template's weakness is staleness, and the modern alternative is an AI agent that keeps the forecast live from real data instead of a spreadsheet you rebuild each cycle.
If you want AI agents building and maintaining your cash flow forecast from live data, no template upkeep, every number traceable, book a demo of Concourse.
