Table of Content
What is cash flow forecasting?
Cash flow forecasting is predicting the cash that will come into and go out of your business over a set period, usually 13 weeks or 12 months. It starts from your current bank balance, adds expected receipts, subtracts expected payments and shows the lowest point ahead, so you can act before cash runs short.
The short version
- Forecast cash, not profit. A profitable business can still run out of cash when customers pay late.
- Start with a 13-week view. It is short enough to be accurate and long enough to act on.
- Receivables drive the forecast. Use your invoice aging and real payment habits, not due dates alone.
- Automate the data, keep the judgment. Tools pull balances and invoices, and a person confirms the assumptions.
- Run three scenarios. A base, a best and a worst case show how much room you have.
- Prices checked on October 15, 2026. Confirm with each vendor before you buy.
What cash flow forecasting is, and what it is not
A cash flow forecast looks ahead. It answers one question: will we have enough cash on each date to pay what we owe? It is different from a cash flow statement, which looks back. The statement reports cash movements in three groups: operating, investing and financing activities. A forecast projects those movements forward, usually week by week for the near term.
Two methods exist. The direct method forecasts actual receipts and payments, such as customer payments and supplier bills, and suits short horizons. The indirect method starts from forecast profit and adjusts for non-cash items and changes in working capital, and suits longer plans. Most small businesses use the direct method for the next 13 weeks and the indirect method for the year.
9 cash flow forecasting steps to automate
If you are wondering how to create a cash flow forecast, these nine steps are the process. Forecasting cash flow well is mostly about good inputs and a weekly habit, and each step below can be automated in part.
1. Connect your bank and accounting data
The forecast starts with real numbers. Forecasting tools pull balances, invoices and bills from your accounting system, so nobody retypes them. Float connects to Xero and QuickBooks Online, and Fathom connects to Xero, QuickBooks, MYOB and FreeAgent among others.
Choose it if your data lives in an accounting system. Watch for stale feeds. Check the last sync date before you trust a forecast.
2. Set up a 13-week structure
A 13-week forecast lists each week in a column and cash lines in rows: opening balance, receipts, payments, closing balance. Float includes a 13-week cash flow view on all of its plans. A template table is shown below.
Choose it if you manage near-term liquidity. Watch for false precision. Round to useful amounts.
3. Forecast receipts from your receivables
Start from the invoices you have sent and when customers actually pay. If a customer averages 45 days on 30-day terms, forecast 45. An agent can calculate average days to pay per customer from your history and update the forecast every day.
Choose it if late payers drive your cash gaps. Watch for one-off large customers. Review the top five invoices by hand.
4. Forecast payments from bills and commitments
List bills due, payroll, tax, rent, loan payments and subscriptions on their real dates. Pull recurring items from your accounting system and add one-off commitments by hand.
Choose it if you have predictable fixed costs. Watch for forgotten items such as annual fees and tax dates.
5. Add recurring and seasonal patterns
Many businesses sell more in some months. Use last year’s monthly pattern to shape revenue and costs, and mark known events such as a sale or a hiring plan. This step is a good use of AI because it can spot seasonality in your history.
Choose it if sales or costs vary through the year. Watch for one unusual year. Check the pattern against two years if you have them.
6. Run scenarios
Build a base, a best and a worst case. In the worst case, delay customer payments by two weeks or lose your biggest customer, and see the lowest cash point. Float includes eight scenarios on every plan.
Choose it if you need to know how much buffer you have. Watch for extreme cases that nobody believes. Make the worst case plausible.
7. Compare forecast with actuals
Each week, compare what you forecast with what happened and note why it differed. This is how a forecast gets better. An agent can produce the variance table automatically and flag the biggest gaps.
Choose it if you forecast every week. Watch for blame. Use variances to fix assumptions, not to assign fault.
8. Set low-cash alerts
Choose a minimum balance, such as two payroll cycles, and have the system alert you when the forecast drops below it in the next 8 weeks. Early warning gives you time to chase invoices or arrange financing.
Choose it if a shortfall would hurt quickly. Watch for alert fatigue. Alert on the forecast, not on every daily balance.
9. Report to the people who decide
Send a one-page summary to the owner, board or lender each week: lowest cash point, biggest risks and actions. Business Central, Microsoft’s ERP for small and midsize companies, lists AI-driven cash-flow forecasting and automated bank reconciliation as part of its finance features.
Choose it if others rely on your cash position. Watch for long reports. One page, one lowest point, three actions.
A cash flow forecasting example: the 13-week template
Use this layout in a spreadsheet, or as the structure for a tool. The figures are illustrative.
| Line | Week 1 | Week 2 | Week 3 | … | Week 13 |
|---|---|---|---|---|---|
| Opening cash | $40,000 | $34,000 | $37,500 | … | |
| Customer receipts | $12,000 | $18,000 | $9,000 | … | |
| Supplier payments | -$9,000 | -$7,500 | -$8,000 | … | |
| Payroll and tax | -$9,000 | -$7,000 | -$6,500 | … | |
| Other (rent, loans) | $0 | $0 | $0 | … | |
| Closing cash | $34,000 | $37,500 | $32,000 | … |
Closing cash for each week becomes opening cash for the next. The number to watch is the lowest closing balance in the whole row.
Cash flow forecasting software compared
| Tool | Cost to start | Good for | Notes |
|---|---|---|---|
| Spreadsheet template | Free | First forecast, simple businesses | Manual updates; build the 13-week layout above |
| Float | Essentials $130 monthly or $105 billed annually; 14-day free trial | Small businesses on Xero or QuickBooks Online | 13-week view and 8 scenarios on all plans; 12-month forecasts on Essentials, 36-month on higher plans |
| Fathom | Pro $450 per month for 25 companies | Accounting firms and advisors | Three-way cash flow forecasting is on Pro only; built for client portfolios |
| Business Central | Per-user plans; $80 Essentials, billed yearly | Companies already running it as their ERP | Lists AI-driven cash-flow forecasting among its finance features |
Float lists prices in several currencies and the figures above are its dollar rates. Fathom is priced for firms that manage many clients, so a single company should compare it with Float or a spreadsheet first.
The limits of forecasting
- It is only as good as the inputs. Late invoices and missed bills break any forecast.
- Far-out weeks are guesses. Trust week 1 to 4 most, and treat weeks 9 to 13 as ranges.
- Surprises happen. A lost customer or a supplier price rise will not appear until it does.
- It needs a habit. A forecast nobody updates goes stale within a month.
A common health check is the operating cash flow ratio, operating cash flow divided by current liabilities. A result above 1 generally means you cover short-term obligations from operations, but norms vary by industry.
When to build beyond off-the-shelf tools
Standard tools work well when your data sits in one accounting system. If cash movements come from several banks, processors, currencies or entities, or if you want an agent to explain variances in plain language, a custom build can help. Our AI automation services team builds finance agents, including a cash flow monitor, and our predictive analytics services add demand and payment forecasts. Our bookkeeping and accounting services team can keep the underlying books clean. If your cash depends on matching payments to invoices, read our guide to AI agents in ERP. Our guides to e-commerce ERP integration, AI agents for Odoo and NetSuite consulting show how finance data moves between systems, and our guide to the best AI agents for business covers monitoring agents.
Frequently Asked Questions
What is cash flow forecasting?
Cash flow forecasting is predicting the cash coming into and going out of your business over a set period, so you can see your lowest cash point and act before you run short.
How do I create a cash flow forecast?
Start with your current bank balance, list expected customer receipts and expected payments week by week for 13 weeks, calculate the closing balance for each week, and check the lowest point. Update it every week.
What is a 13-week cash flow forecast?
It is a week-by-week projection of cash receipts, payments and balances for the next 13 weeks. It is detailed enough to be accurate and long enough to give you time to act.
What are the three types of cash flow statements?
A cash flow statement groups cash movements into operating activities, investing activities and financing activities. A forecast projects those movements forward.
What is the difference between direct and indirect forecasting?
The direct method forecasts actual receipts and payments and suits short horizons. The indirect method starts from forecast profit and adjusts for non-cash items and working capital, and suits longer plans.
What is the best cash flow forecasting software?
It depends on your size and systems. Float suits small businesses on Xero or QuickBooks Online, Fathom suits accounting firms, and an ERP such as Business Central suits companies that already run it. Start with a spreadsheet if you are unsure.
How accurate is a cash flow forecast?
Near-term weeks are far more accurate than distant ones because they rest on known invoices and bills. Compare forecast with actuals every week and adjust your assumptions.
What are common cash flow problems?
Customers paying late, seasonal swings, heavy inventory purchases, fast growth that outruns cash, and large tax or loan payments. A forecast shows each one before it bites.
Can AI forecast cash flow?
AI can calculate how long each customer takes to pay, spot seasonality, run scenarios and explain variances. A person should confirm the assumptions and decide what action to take.
Bottom Line
Cash flow forecasting works when it is short, weekly and tied to action. Build a 13-week forecast from your receivables and bills, run a worst case, set a low-cash alert and compare it with actuals every week.
When your cash data lives in several systems, our AI automation services team can build a cash flow agent that pulls it together and sends you the weekly summary.
