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.

No export to hand?

Open invoices (cash in)

Or paste rows instead

Unpaid bills (cash out)

Or paste rows instead
What the reports leave out

Files are read in this browser. Nothing is uploaded, sent or stored.

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.

  1. 01

    Open the invoices report

    Cash in

    Go to Reports, search for Open Invoices and open it. A/R Aging Detail works too.

  2. 02

    Export it

    CSV or Excel

    Select the Export/Print dropdown, then Export to Excel or Export as CSV, and save the file.

  3. 03

    Export unpaid bills

    Cash out

    Do the same for Unpaid Bills (or A/P Aging Detail).

  4. 04

    Add both files

    In the tool

    Drop them into the tool, enter the bank balance, payroll per run and monthly costs not entered as bills.

  5. 05

    Read the low point

    Every week

    Check 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.

See fractional CFO services

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 book a 30-minute call

Or email contact@decipherhq.com