What does QuickBooks Online miss in a subcontractor’s cash forecast?
- GC pay habits. Intuit’s aging reports age by due date, and an invoice with no due date counts as due on receipt.
- Retainage timing. Left inside the invoice balance, it lands in the near weeks when it may be months away.
- Pay apps you haven’t sent. Next month’s billing isn’t in QuickBooks until you create the invoice.
Which QuickBooks reports do you need?
1. Open invoices. Go to Reports, then Standard reports. Under Who owes you, select Accounts receivable aging detail. Select Export/Print, then Export to Excel. If data looks missing in Excel, select Enable Editing.
2. Unpaid bills. Go to All apps, then Expenses & Bills, then Bills, and open the Unpaid tab. Uploaded bills wait in the For review tab, so review those first.
3. Bank balance. Take today’s balance at the bank and subtract checks that haven’t cleared.
4. Pay apps and retainage. From your pay application log or your GCs’ portals, take the next billing per job, the date you’ll submit it, and retainage held to date.
How do you build the 13 weeks in Excel?
- Set up the grid. 13 Monday dates across row 1; rows for opening cash, each cash in, each cash out, and closing cash.
- Give each GC a days-to-pay number. Use how long they took on recent paid invoices, not your terms. See how to find average days to pay in QuickBooks Online.
- Add an expected pay date to every open invoice. In the aging export, add a column: invoice date plus that GC’s days to pay.
- Split retainage out. Move retainage to its own row, dated at the closeout you expect. If the date is unknown, leave it out of the 13 weeks.
- Add future pay apps. One row per job: submission date plus the GC’s days to pay. Count change orders only once they’re signed.
- Sum each week with SUMIFS. With named ranges Amount and PayDate, week 1 in cell C5 is
=SUMIFS(Amount, PayDate, ">="&C$1, PayDate, "<"&C$1+7). Fill right. - Add cash out. Unpaid bills by due date, payroll and payroll taxes on each pay day, rent, equipment and truck loans, insurance, and owner draws.
- Add tax dates. The IRS puts the fourth estimated payment on January 15 of the following year, so January 15, 2027 falls inside a forecast started in November.
- Set a floor. Add a minimum-cash line and highlight any week where closing cash drops below it.
Example
| Week starting | Nov 16 | Nov 23 | Nov 30 | Dec 7 |
|---|---|---|---|---|
| Opening cash | 48,000 | 31,500 | 62,000 | 40,500 |
| GC payments on open invoices | 0 | 52,000 | 0 | 18,000 |
| Retainage released | 0 | 0 | 0 | 0 |
| Payroll and taxes | 14,000 | 14,000 | 14,000 | 14,000 |
| Supplier and sub-tier bills | 2,500 | 7,500 | 7,500 | 9,000 |
| Closing cash | 31,500 | 62,000 | 40,500 | 35,500 |
Every invoice here is due Net 30, but the largest GC pays in 52 days on average. By due date, that 52,000 would have shown up three weeks earlier.
What do GC payment terms change in the forecast?
Pay-when-paid terms tie your receipt to the owner paying the GC, so add the GC’s own wait to your days to pay on those jobs. If your sub-tier contracts are pay-when-paid too, move those payments to the week after the GC pays you.
On federal jobs, FAR 52.232-27 requires the prime’s subcontracts to include a clause to pay subcontractors “not later than 7 days from receipt of payment.” It also lets a subcontract allow the prime to “retain (without cause) a specified percentage of each progress payment.” State rules for private jobs vary, so ask your attorney which apply to yours.
How do you check the forecast each week?
- Compare last week to the bank. Give any GC more than a week off a new days-to-pay number.
- Roll forward. Drop the past week, add week 13, and refresh the aging export and Unpaid bills.
- Tie the totals. Open invoices plus retainage in your forecast should equal the A/R total on the aging report for the same date.
- Chase missing bills. Ask project managers for supplier and sub-tier bills not yet entered.
The over/under billing calculator shows underbilled jobs to bill now, and the AR aging chase list ranks which GCs to call first. Both rely on job costing in QuickBooks Online putting costs on the right job.
What are your options?
| Option | What you get | Watch for |
|---|---|---|
| QuickBooks Online Advanced forecasting | Intuit’s August 2026 notes say you can “forecast cash flow through the next quarter” | It sees retainage and pay apps only once they’re in the books |
| Do it yourself in Excel | The 13-week grid above, refreshed every Monday | An hour or two a week, and formulas one person understands |
| Hire a bookkeeper or controller | Weekly updates | Whether they know your GCs’ pay habits and retainage terms |
| Bring in an outside team (Reports & answers) | The forecast built from your books and pay apps, checked against your bank | Who owns the file, and a written source for each row |
FAQ
Does QuickBooks Online have a 13-week cash flow forecast? Advanced offers forecasting through the next quarter. For weeks built on each GC’s real days to pay, use Excel with the aging detail export and your Unpaid bills.
Should retainage go in a 13-week forecast? Only when you have a closeout date you trust. Otherwise keep it on a separate line below the 13 weeks.
Why use expected pay dates instead of due dates? QuickBooks ages invoices by due date. GCs pay on their own schedule, and that’s when cash reaches your bank.
How often should a subcontractor update the forecast? Every week, on the same day.
Sources
- Run an accounts receivable aging report in QuickBooks, Intuit QuickBooks Support,
- Aging reports: Current and 1-30, Intuit QuickBooks Support,
- Enter bills and record bill payments in QuickBooks Online, Intuit QuickBooks Support,
- What’s new in QuickBooks Online Advanced: August 2026, Intuit QuickBooks,
- Export reports to Excel in QuickBooks Online, Intuit QuickBooks Support,
- 52.232-27 Prompt Payment for Construction Contracts, Acquisition.gov (FAR),
- Estimated tax: individuals, IRS,
