Use this template to see cash gaps before they become payroll, vendor, contractor, or operating surprises.
A cash flow forecast template gives finance and operations teams a practical way to estimate how money will move through the business before decisions are made. It is different from a historical cash flow statement. A statement records what already happened; a forecast shows what is likely to happen next, based on expected receipts, planned payments, known obligations, and timing assumptions.
Quick answer
A cash flow forecast template should include opening cash, expected cash inflows, expected cash outflows, net cash movement, closing cash balance, assumptions, variance tracking, owners, and review cadence. The most useful version shows when cash is expected to arrive or leave, not just when revenue is earned or expenses are booked.
What’s included
This resource gives you a copy-ready template structure for monthly forecasting. It is designed for business teams that need to plan payroll, vendor bills, contractor payments, taxes, debt payments, inventory, marketing spend without relying on scattered spreadsheets or memory.
- A field-by-field cash flow forecast template.
- A simple formula structure for opening balance, inflows, outflows, net cash flow, and closing balance.
- A 13-week and 12-month use case guide.
- A variance review table for comparing forecast to actual results.
- Common mistakes that make forecasts unreliable.
How to use this cash flow forecast template
Start with the period you need to manage. A 13-week forecast is useful when timing is tight and finance needs week-by-week control. A 12-month forecast is better for planning hiring, vendor commitments, seasonal swings, debt payments, tax deadlines, and growth investments. The FDIC’s small business cash flow training describes projections as forward-looking estimates of cash inflows and outflows used to estimate future cash position, which is the right way to think about this template.
Use cash timing, not accounting timing. If a customer invoice is issued on September 15 but usually pays 30 days later, record the inflow in October. If payroll is approved this week but paid next Friday, record the outflow when the money leaves the account. SCORE’s financial projection guidance makes the same operating distinction: cash flow projections show receipts and payments by month, including beginning and ending cash balances.
Cash flow forecast template
| Section | What to enter | Owner |
|---|---|---|
| Forecast period | Week, month, quarter, or rolling 13-week / 12-month period. | Finance |
| Opening cash balance | Cash available at the start of the period across approved business accounts. | Finance |
| Expected customer receipts | Cash expected from invoices, subscriptions, retainers, deposits, or sales. | AR / Revenue owner |
| Other cash inflows | Loans, investment proceeds, grants, refunds, reimbursements, or asset sales. | Finance |
| Payroll and contractor payments | Employee payroll, contractor invoices, bonuses, taxes, benefits, and payouts. | Finance / People |
| Vendor and operating payments | Rent, software, inventory, utilities, insurance, agencies, suppliers, and services. | AP / Operations |
| Tax, debt, and finance obligations | Loan payments, credit lines, tax deposits, merchant fees, interest, and penalties. | Finance |
| Net cash flow | Total inflows minus total outflows for the period. | Finance |
| Closing cash balance | Opening cash plus net cash flow. | Finance |
| Assumptions and confidence | Payment timing assumptions, collection confidence, disputed invoices, and risks. | Finance / Operations |
Copy-ready forecast format
Use this structure in a spreadsheet, finance system, or operating workflow:
- Opening cash balance: [amount]
- Cash inflows: customer receipts, deposits, financing, refunds, other receipts
- Total cash inflows: [sum]
- Cash outflows: payroll, contractor payments, vendor bills, taxes, rent, software, inventory, debt, other payments
- Total cash outflows: [sum]
- Net cash flow: total inflows minus total outflows
- Closing cash balance: opening cash balance plus net cash flow
- Minimum cash threshold: [amount the business does not want to fall below]
- Forecast notes: assumptions, late-payment risk, blocked payments, approval dependencies, and owner follow-up
The U.S. Small Business Administration notes that balance sheets and cash flow projections help business owners understand current capital and future cash needs. The forecast becomes more useful when the assumptions are explicit enough for someone else to challenge them.
Example application
A services company starts the month with $85,000 in cash. It expects $120,000 from customer invoices, but $30,000 is tied to one client with a history of late payment. The team expects $72,000 in payroll and contractor payouts, $18,000 in software and rent, $12,000 in vendor invoices, and $9,000 in taxes. The base forecast shows a healthy closing balance, but the risk-adjusted version removes the late customer payment and shows cash falling close to the company’s minimum threshold.
That insight changes the operating plan. Finance delays one discretionary vendor purchase, collections escalates the late invoice, and operations confirms which contractor invoices are tied to accepted milestones. The forecast does not just predict cash. It assigns work before cash gets tight.
Variance review table
| Line item | Forecast | Actual | Variance question |
|---|---|---|---|
| Customer receipts | [amount] | [amount] | Which payments arrived late, short, early, or disputed? |
| Payroll and contractors | [amount] | [amount] | Were new workers, bonuses, corrections, or timing shifts missed? |
| Vendor payments | [amount] | [amount] | Which bills were unplanned, accelerated, blocked, or deferred? |
| Taxes and debt | [amount] | [amount] | Were required payment dates and amounts confirmed? |
| Closing cash | [amount] | [amount] | Did the business remain above its minimum cash threshold? |
Common mistakes
- Forecasting revenue instead of cash. Revenue timing and cash timing are not always the same, especially when customers pay by invoice.
- Forgetting approval status. A vendor bill may be expected, approved, disputed, blocked, or scheduled. Those statuses affect timing.
- Ignoring contractor and vendor payout cycles. External workforce payments can create sharp cash outflows if invoice cutoffs and milestone approvals are not tracked.
- Using one optimistic scenario. Keep at least a base case and a tighter cash case when receivables, seasonality, or large obligations are uncertain.
- Skipping variance review. A forecast improves only when finance compares expected cash to actual cash and updates the assumptions.
Where Workhint fits
A template helps the team see the forecast, but cash flow work often depends on operational status: which invoices are approved, which contractor milestones are accepted, which vendor payments are blocked, which departments created new commitments, and which customer payments need follow-up. Workhint helps teams turn that surrounding process into a live workflow. Finance can collect payment requests, route approvals, assign follow-ups, track contractor and vendor payment status, connect documents to owners, and keep a visible record behind the forecast. For teams managing many external contributors or payouts, Workhint can support the operating layer around a contractor payment platform by connecting approvals, evidence, schedules, and payment readiness.
FAQ
What is a cash flow forecast template?
It is a reusable worksheet or workflow for estimating cash inflows, cash outflows, net cash movement, and closing cash balance over a future period.
What is the basic cash flow forecast formula?
The basic formula is net cash flow equals total cash inflows minus total cash outflows. Closing cash balance equals opening cash balance plus net cash flow.
Should a business use a weekly or monthly forecast?
Use weekly forecasting when cash is tight, payment timing is uncertain, or the business has frequent payroll, contractor, vendor, or inventory payments. Use monthly forecasting for broader planning.
Who should own the cash flow forecast?
Finance should own the forecast, but AR, AP, payroll, operations, sales, and department owners should own the inputs they control.
Is this template a substitute for accounting advice?
No. Use it as an operating resource. Work with a qualified accountant or finance advisor for accounting treatment, tax planning, lending requirements, or financial statement preparation.
Conclusion
A strong cash flow forecast template helps business teams make better decisions before cash becomes urgent. Start with opening cash, forecast the real timing of inflows and outflows, compare actuals to assumptions, and assign owners to anything that could shift the forecast. The best version is not the most complicated spreadsheet. It is the one finance and operations actually use every week to see what is coming, what is blocked, and what needs action.
Leave a Reply