Construction cash flow forecast from AR and AP
A rolling weekly cash forecast built from the invoices and bills already in your accounting system, with assumptions stated on the page.
The problem
Cash forecasting usually lives in a spreadsheet the controller rebuilds before every owners' meeting. It mixes committed money with guesses, it is out of date by the following week, and when a large receivable slips nobody sees the effect on the next payroll until it arrives.
What we build
We build a weekly cash forecast from what is actually committed: issued AR invoices and AP bills placed in the week they fall due, overdue items rolled into the current week, and unbilled backlog excluded by design. Additional assumptions, such as projected billings from the schedule of values, can be layered in as clearly labeled scenarios.
How it works
- 1
Pull open AR and AP
Invoices, bills, payments and credit memos come from your accounting system nightly through a read-only connection.
- 2
Place items by due date
Each open item lands in the week it falls due, from four weeks back to 26 weeks ahead; overdue items roll into the current week.
- 3
Compute the position
Expected collections minus expected payments gives net cash movement per week and a running cumulative cash position.
- 4
Show the items behind it
The open invoices and bills behind each week are listed beside the chart, alongside the AR aging and chase list.
- QuickBooks Online
- Sage 100 Contractor
- Procore
- Microsoft Fabric
- Power BI
The value it creates
Forecasting
The forward view is computed from committed items with its assumptions written on the page, not adjusted by hand.
Early warning
A week where payments exceed collections shows up as soon as the bills are entered, not when the account runs short.
Better decisions
Collections effort goes to the overdue balances that move the cash position most.
Time saved
No weekly spreadsheet rebuild; compare preparation time for the cash meeting before and after.
Proof
Related use cases
Frequently asked questions
Why exclude unbilled backlog from the forecast?
Unbilled work has no invoice date or amount yet, so including it mixes estimates with commitments. We keep the base forecast to committed cash and show projected billings, if you want them, as a separate labeled layer.
How far ahead does it forecast?
The built version covers four weeks back to 26 weeks ahead. The horizon is a setting we agree with you, but the further out it goes, the more of the figure depends on items not yet invoiced.
Does it handle retainage?
Retainage receivable and payable can be shown separately from current balances so it does not inflate near-term collections. We confirm how your accounting system records it during discovery.
Can it use Procore pay applications instead of accounting invoices?
Accounting is the better source for cash because it records what was actually invoiced and paid. Procore pay applications are useful for projected billings and for cross-checking.
Next step
Which report or workflow would you like to improve?
Tell us what your team does today, which systems are involved, and what you want to change. We'll discuss whether there is a practical fit.
Prefer email? charley@buildflows.ai