QuickBooks reports what your cash has done, not what it will do. A real forecast needs three things the software cannot supply on its own: receivables phased by each customer's actual payment behavior rather than their stated terms, payments placed on the dates they will genuinely leave, and a weekly rather than monthly view, because a month can finish healthy while containing a week where payroll does not clear. Build it from the AR aging, the AP aging and your payroll calendar, chain each week's closing balance into the next, and mark every week that falls below your cash floor.
What this actually feels like
You look at the bank balance and it seems fine. Three weeks later it is not, and nothing unusual happened in between — a couple of customers paid late, a material order was larger than expected, and payroll landed on the wrong side of both.
The balance told you about today. The thing you needed was a view of the six weeks after it.
What it costs to do by hand
Built by hand, a first forecast is two to four hours. Maintained honestly it is about thirty minutes every week — roughly a full working week per year, spent on a task with no deadline forcing it.
Which is why most are abandoned by month three, usually during a busy period, which is precisely when the forecast was about to earn its keep.
Building a 13-week cash flow forecast
Row by row, including how to phase receipts on payment history rather than terms — the judgment that makes a forecast useful or useless.
Read the guide →Input, skill, output
- QuickBooks — Books, invoices and bills — the core ledger.
- PayPal — Payments and payouts as a live cash signal.
- Square — POS takings folded in as a secondary feed.
- Project forward — Models cash 30, 60 and 90 days out.
- Flag the risks — Names the weeks where cash runs tight.
- Show the range — Confidence bands around each figure.
- Forecast chart — The cash curve with confidence bands.
- Risk flags — The exact weeks to watch, called out.
- XLSX export — The full model to share or adjust.
Who this is for
- Your revenue is uneven, or your customers pay on terms you did not really choose.
- You have employees, so the largest outflow is on a fixed date that cannot move.
- You have been surprised by a tight week in the last twelve months.
If none of those describe you, this is probably not your first priority — and the rest of the library may point somewhere more useful.
Common questions
Does QuickBooks have a cash flow forecast?
It has a cash flow statement, which is historical, and a short projection built on due dates. Neither phases receipts on how customers actually pay, which is where the accuracy comes from.
Why weekly rather than monthly?
Because cash crises happen on days. A month can end comfortably positive and still contain a Thursday where the payroll debit did not clear.
How far ahead is useful?
About thirteen weeks. Nearer than that and everything is already committed; much beyond it and you are extrapolating rather than forecasting.
What if my revenue is unpredictable?
Then the forecast matters more, not less. Keep new sales on their own line so you can see how wrong that assumption was, and run a downside case alongside the base.
Do I need to reconcile first?
Yes. A forecast built on an unreconciled balance is wrong in every week by the same amount, and you will not know which amount.
See it on your own books, once
The First Close is one real month of your books, closed properly and configured to your chart of accounts, delivered inside two weeks. Full reconciliation against every processor, every exception flagged with the transaction behind it, and the narrative written. $497, refundable if the packet is not delivered, and it credits in full toward the first month if you continue.
Get Your First Close — $497 See a sample packet