A cash-flow forecast estimates whether cash will cover expected payments, and when. Compare it with actual activity and revisit assumptions regularly.
Quick answer: Start with reconciled cash. Estimate receipts and payments by date, calculate each week’s closing balance, then compare the forecast with actual activity. A 13-week view makes near-term timing visible.
What a cash-flow forecast is—and is not
A forecast estimates future receipts and payments. A P&L reports income and expenses for a period; a balance sheet shows the position at a point in time.
The starting formula is simple:
Opening cash
+ expected receipts
- expected payments
= closing cashThe key is timing: a customer may pay after an invoice’s due date, payroll falls on specific dates, and bills can be due after their expense was recorded.
QuickBooks’ current cash-flow guidance emphasizes starting from accurate, reconciled data before using reports or planning tools. Its cash-flow reporting guide also distinguishes the P&L and other reports used to understand the inputs to a forecast.
Choose the right time horizon
There is no one universal forecast horizon. Pick the view that fits the decision:
| Horizon | Best for | Limitation |
|---|---|---|
| Weekly, 13 weeks | Near-term timing: payroll, collections, supplier payments, and a possible cash squeeze | Requires regular maintenance and detailed dates |
| Monthly, 6–12 months | Operating plan, seasonality, hiring, and broader spending decisions | Can hide a difficult week inside an otherwise positive month |
| Longer-term | Strategic scenarios and capital planning | Depends more heavily on uncertain assumptions |
For a weekly 13-week checklist and common errors, see the 13-week cash forecast skill.
Build a cash forecast from receivables and payments
1. Reconcile the opening cash balance
Start with cash that has been reconciled to the relevant bank accounts. If the opening balance is wrong, every later week is wrong by the same amount.
Document which accounts are included. If the business has operating accounts, savings, merchant reserve accounts, or restricted cash, say whether each one is available for the decision being reviewed. Do not silently combine balances with different restrictions or purposes.
2. Forecast accounts receivable by expected payment date
For each expected receipt, record:
- customer or receipt source;
- expected amount;
- expected receipt week or date;
- whether the amount is invoiced, contracted, recurring, or only assumed; and
- the reason for the timing assumption.
Open receivables are often a key input, but invoice terms alone are not enough. Use known payment behavior, disputes, credits, concentration risk, and any information about collection timing. An invoice is not cash until it is paid.
For an A/R review before adding receivables to the forecast, use the QuickBooks A/R aging and collections workflow.
3. Forecast cash payments by their actual due date
Include the known timing of outflows, not just a monthly expense average. Common items include:
- payroll, payroll taxes, and benefits;
- supplier bills and recurring subscriptions;
- rent, insurance, and utilities;
- debt principal and interest;
- tax payments;
- inventory, deposits, and capital spending; and
- owner distributions or other planned transfers, where relevant.
Avoid “smoothing” the calendar when an exact date is known. A monthly total can look healthy while one weekly payment creates a temporary cash gap.
4. State the assumptions separately from facts
This is one of the most useful controls in a forecast. Facts might include a current bank balance, an approved payroll date, or an invoice already issued. Assumptions might include a customer paying on a projected date, a planned sale closing, or a supplier accepting an expected payment schedule.
Give each material assumption an owner and a date to revisit it. If the assumption changes, update the forecast rather than explaining away the variance afterward.
5. Calculate the weekly cash roll-forward
For each week, calculate opening cash plus receipts less payments to arrive at closing cash. The next week begins with the prior week’s closing cash.
| Week | Opening cash | Receipts | Payments | Closing cash | Main assumption to verify |
|---|---|---|---|---|---|
| Week 1 | $— | $— | $— | $— | Example: expected collection date |
| Week 2 | Prior closing cash | $— | $— | $— | Example: payroll and tax date |
| Week 3 | Prior closing cash | $— | $— | $— | Example: supplier payment timing |
The table is deliberately simple. The forecast should be understandable enough that an operator can see the week, amount, and assumption that create the pressure point.
6. Compare forecast with actual and roll it forward
Each review cycle, compare the forecasted receipt and payment timing with what actually occurred. Note whether the difference came from a late collection, an early bill, a missing transaction, a wrong assumption, or a change in business conditions.
Remove the completed week, add a new one at the end, and revise assumptions as needed.
What to review when a low-cash week appears
A low projected balance is a signal to review, not an automatic instruction. Start by validating:
- the reconciled opening cash;
- the timing and likelihood of major receipts;
- the exact dates of payroll, tax, debt, and supplier payments;
- missing commitments, transfers, or one-time events; and
- whether the forecast includes the accounts relevant to the decision.
Then discuss the situation with the people who own the finance and operating decisions. The appropriate response depends on contracts, customer relationships, payment obligations, financing terms, accounting treatment, and the business’s own policies. A forecast should inform that review, not replace it.
Two cash-forecasting traps to watch for
Using the P&L as the forecast
The P&L is an important input, but it is not a cash calendar. It does not by itself show when invoices will be paid, when bills will clear, or when debt principal will reduce cash. See how to read a P&L for the difference between performance and liquidity.
Forgetting known one-off events
Insurance renewals, tax deposits, annual software fees, deposits, inventory purchases, and three-payroll months can matter more than a typical week. Keep a visible list rather than relying on monthly averages.
Where MosoFin fits today
MosoFin can help review authorized QuickBooks data in Claude, including cash-related records, receivables, bills, and expenses. It does not provide a released cash-forecasting, budgeting, or planning workflow.
Use the forecast to identify questions for source review; a finance professional decides what to do. See QuickBooks reporting in Claude and MosoFin’s read-only controls. The Claude Fable 5.1 forecast example is not a released MosoFin forecasting feature.
FAQ
What is a cash flow forecast?
A cash-flow forecast estimates dated receipts and payments from an opening cash balance. It shows a possible future balance based on assumptions, not a guarantee.
How far ahead should a small business forecast cash flow?
Match the horizon to the decision and your data. A 13-week view shows weekly timing; monthly and longer forecasts support broader planning.
How do I forecast accounts receivable for cash flow?
Start with invoice-level balances and estimate when each will be paid. Consider payment history, credits, disputes, and customer concentration; revisit expected dates during each review.
Is profit the same as cash flow?
No. Profit compares income and expenses for a period. Cash also depends on when invoices, bills, debt, inventory, and owner transactions are paid or received.
What should I do if the forecast shows a low-cash week?
Check the opening balance, receipt and payment dates, and assumptions. Review options with the people responsible for finance and operations; a forecast is not a payment instruction or professional advice.
