Free tool, no sign-up
QuickBooks cash flow forecast: a free 13-week tool
QuickBooks Online plans cash by the month; this tool shows it by the week. Add the Open Invoices and Unpaid Bills exports, payroll and fixed costs, and see the ending balance for each of the next 13 weeks, the lowest week and weeks of runway. It reads Xero exports too. Files stay in this browser: nothing is uploaded.
Your 13-week cash view appears here
Enter today's bank balance and add the open invoices and unpaid bills exports. Or see how it works first.
How to export the reports from QuickBooks Online
About two minutes. Report exports are limited on QuickBooks Online Free and Lite, per Intuit.
- 01
Open the invoices report
Cash inGo to Reports, search for Open Invoices and open it. A/R Aging Detail works too.
- 02
Export it
CSV or ExcelSelect the Export/Print dropdown, then Export to Excel or Export as CSV, and save the file.
- 03
Export unpaid bills
Cash outDo the same for Unpaid Bills (or A/P Aging Detail).
- 04
Add both files
In the toolDrop them into the tool, enter the bank balance, payroll per run and monthly costs not entered as bills.
- 05
Read the low point
Every weekCheck the lowest week first, then raise days late to see how a slower month changes it.
- From Xero
- Open Reports, then Aged Receivables Detail, select Export and choose Excel. Repeat with Aged Payables Detail. Xero dates are often day first; the tool detects that from the file.
- No export access
- Paste rows of due date and amount into the tool instead, one invoice or bill per line, copied from any report or spreadsheet.
- Source
- Export steps: Intuit, run reports in QuickBooks Online (checked November 2026).
What the numbers mean
Lowest week
The smallest ending balance in the 13 weeks and the week it happens. This is the number to manage, not the balance in week 13: a quarter can end well and still dip below payroll in week 6.
Weeks of runway
Today's cash divided by the average weekly burn across the 13 weeks. If the forecast goes below zero, the tool shows the week cash runs out instead. Growing means cash rises over the period.
Cash in and cash out
Cash in is open invoices in the week they are due (moved later by days late) plus new cash not yet invoiced. Cash out is unpaid bills by due date, payroll on paydays and monthly costs on the 1st.
Overdue items
Invoices and bills already past due are counted in week 1. If a customer is unlikely to pay soon, remove that invoice from the file or raise days late.
Minimum cash
The balance the company will not go below, such as a lender minimum or a board floor. Weeks under it are marked Below min; weeks under zero are marked Short.
The tool gives a first view. A full model adds named collections dates, a downside case and a Monday update: how to build a 13-week cash flow forecast.
What QuickBooks and Xero offer for cash forecasting
Checked against Intuit and Xero help and product pages in November 2026. Features vary by plan and region.
QuickBooks Online cash flow planner
Under Reports, then Financial planning. It projects by month: the 24-month view looks 14 months ahead and the shorter views 1 or 2 months (Intuit FAQ). Intuit lists it as unavailable with multicurrency on (Intuit).
Intuit Intelligence forecast
A 12-month projection of income, expenses and cash flow, which needs at least two years of history (Intuit).
A weekly 13-week view
Documented for Intuit Enterprise Suite, under Reports, Financial planning, Cash flow overview (Intuit), not for QuickBooks Online plans. The statement of cash flows looks back, not ahead (Intuit).
Xero
Short-term cash flow projects 7 or 30 days ahead from invoices and bills in Xero; Xero's US pages list 30, 60 and 180 day forecasts by plan (Xero). Payroll run outside Xero and costs not entered as bills still need adding.
This tool fills the gap between those: a weekly view of the next quarter from the reports every plan can export, with payroll and fixed costs added by hand.
This tool, the Excel template or a full model
This tool
A first weekly view in minutes from QuickBooks or Xero exports. Nothing to set up and nothing saved, so it is redone from fresh exports each time.
The Excel template
The 13-week cash flow forecast template keeps the forecast week to week: invoices by expected pay date, every disbursement line, a downside case, an actuals row and a monthly tie-out.
A model run by a finance lead
For a credit line, covenants or a raise: headcount-driven payroll, debt schedules and a variance review each Monday. Decipher builds and runs it as part of its fractional CFO services.
QuickBooks cash flow forecast: common questions
Does QuickBooks have a cash flow forecast?
Partly. QuickBooks Online has a cash flow planner (Reports, then Financial planning) that projects month by month, and an Intuit Intelligence forecast that looks 12 months ahead. A weekly 13-week cash flow forecast is documented only for Intuit Enterprise Suite. This tool builds the weekly view from two standard QuickBooks Online reports.
How do I prepare a cash flow forecast in QuickBooks?
Export the Open Invoices report (cash in) and the Unpaid Bills report (cash out) to CSV or Excel, then place each amount in the week it is due, add payroll and fixed costs that are not entered as bills, and start from the bank balance. The tool on this page does those steps in the browser.
Is the QuickBooks statement of cash flows a forecast?
No. The statement of cash flows in QuickBooks Online shows the cash that came in and went out during a past period. A forecast looks ahead: it uses open invoices, unpaid bills and known payments to show the cash balance in each coming week.
Does Xero have a cash flow forecast?
Yes, within limits. Xero's short-term cash flow projects the bank balance 7 or 30 days ahead from invoices and bills already in Xero, and Xero's US plan pages list longer forecasts on higher plans. Payroll run outside Xero and costs not entered as bills are not in it. This tool reads Xero aged receivables and payables exports.
Does QuickBooks Desktop have a cash flow forecast?
QuickBooks Desktop had a Cash Flow Projector, which Intuit says was discontinued from QuickBooks Desktop 2022. Desktop users can export the Open Invoices and Unpaid Bills reports to Excel and use this tool or the 13-week template instead.
More free tools
The browser tools need no sign-up, and nothing entered leaves the browser.
Startup runway calculator
Months of runway, the zero-cash date and a default alive check from cash, revenue and costs. Calculate startup runway
QuickBooks budget vs actual
Every variance from the Budget vs. Actuals export, the 5 biggest and which ones hurt profit. Compare QuickBooks budget vs actual
13-week cash flow forecast template
The Excel workbook to keep the weekly forecast going, with a sample company built in. See the 13-week template
Further reading
Decipher's fractional CFO services
Want the forecast built and kept current every week? Decipher runs a 13-week cash view as part of a fractional CFO engagement.
Get the 13-week cash flow forecast template
Keep the forecast going in Excel, with a downside case and a sample company built in. Or book a 30-minute call to have Decipher build and run it with you.
Or email contact@decipherhq.com