Construction cash flow forecast by receipt and payment date

Your payroll clears before the owner’s payment arrives. A construction cash flow forecast places those movements on expected cash dates: closing cash = opening cash + cash receipts - cash payments. Carry each closing balance into the next period, then inspect the dated transactions inside any week that approaches your approved cash minimum.

Build the schedule from billing, collection, payroll, and payable evidence with an owner for every assumption. Procore’s US cash-flow projection article discusses timing project expenditure and comparing projections with actual results. The schedule below focuses on near-term receipts and payments, not a decision about how to recognize construction revenue.

The controller defines opening cash and forecast scope

State the company, accounts, currency, preparation date, and planning horizon. Reconcile opening available cash to the permitted bank and cash records, with outstanding transactions treated once under the chosen basis. Identify restricted balances and unavailable facilities separately; a bank balance alone does not establish what the business can use for the scheduled payments.

For a job-level view, distinguish the job’s net receipts and payments from cash held in a shared company account. Do not give several jobs the same opening cash. Treasury must approve any allocation, then combine project flows with overhead, tax, financing, and other company obligations before assessing company liquidity.

Keep your construction WIP report available for the earned-revenue and billing position. An underbilling can identify work that still needs billing attention, but it is not a dated cash receipt. ACCA’s cash-budget explanation shows why credit terms can separate reported sales from cash collection.

Billing and collection owners date the expected receipts

Give each receipt a project reference, payment-application or invoice ID, expected net amount, expected cash date, source, and named owner. Track submission, certification or approval, contractual due date, and expected bank availability separately. Certification requirements depend on the contract; an application waiting for approval should not inherit a receipt date merely because the work was completed.

Procore’s progress-payment article ties payment applications and submission timing to contract requirements and discusses retainage. Use the applicable agreement to establish what is withheld and when release can be requested. Keep retained amounts outside ordinary progress receipts until their release assumptions support a separate dated line; do not apply a universal retainage rate.

Record whether a collection date rests on confirmed payment advice, the approved terms, or a collection-owner estimate. Preserve the contractual date even when the expected date changes. Pending change orders and disputed amounts need explicit assumptions or separate scenarios so an uncertain claim cannot become an unexplained base-case receipt.

Accounts payable and payroll owners date the payments

Start with scheduled payroll, approved payables, subcontract payment applications, and supplier commitments. The construction job cost report helps distinguish posted cost, open commitments, and remaining work. Translate that evidence into expected cash dates: a cost posting or purchase-order date is not necessarily its payment date.

Link the payable back to its commitment before adding both amounts to the schedule. When an invoice replaces a planned commitment payment, retain the reference and replace the relevant forecast amount instead of adding the invoice on top. Preserve unsettled commitments for later periods so a low accounts-payable balance does not imply that future cash demands disappeared.

Give tax payments, loan draws, principal repayments, interest, and bank charges separate lines with finance-approved dates and owners. Document whether other amounts include tax so the tax cash movement is counted once. Exclude noncash charges such as depreciation from payment totals; ACCA’s cash-budget example makes that distinction. The responsible finance and tax owners select the treatment.

The controller builds the dated cash schedule

Assume treasury assigns $20,000 of available cash to this simplified, hypothetical one-job schedule. All values are US dollars. There are no other cash movements, restricted balances, tax settlements, financing flows, or retainage releases in these two weeks. The negative results show an unfunded position before corrective action, not bank payments that have already occurred.

In the base case, receipt A-101 provides $10,000 on November 13. Payroll PAY-01 is $15,000 on November 10, and supplier AP-17 is $10,000 on November 12. In the following week, A-102 provides $15,000 on November 20; PAY-02 is $16,000 on November 18 and AP-18 is $12,000 on November 19. The collection owner confirms receipt assumptions, while payroll and accounts payable own the payment dates.

Base week one closes at $20,000 + $10,000 - $25,000 = $5,000. Week two closes at $5,000 + $15,000 - $28,000 = -$8,000. Delaying A-101 into week two changes the earlier closing balance to -$5,000 but leaves the final two-week position at -$8,000. The scenario changes timing, with no loss of the receipt and no assumed change to payments.

Treasury tests daily timing before choosing a funding response

The base case’s positive first-week close hides an earlier shortfall. After the November 10 payroll, cash is $5,000; after the November 12 supplier payment it is -$5,000, before A-101 arrives. In week two, cash reaches -$23,000 after the scheduled payments and before the November 20 receipt. The -$8,000 weekly close therefore understates the largest dated gap in this example.

Inspect the payment calendar, bank availability, and transaction order on tight dates, including holidays and cutoff times. Treasury decides how the approved minimum balance and any funding facility affect the response. A proposed draw needs verified availability, approvals, covenants, fees, and timing; an undrawn facility is not automatically cash. Keep agreed collection or payment changes separate from assumptions that nobody has accepted.

Finance bridges actual cash to the frozen forecast

In a separate hypothetical actual-results case, the first week collects $8,000 and pays $26,000 from the same $20,000 opening balance. Actual closing cash is $2,000. The bridge from the original $5,000 forecast close is $5,000 - $2,000 of delayed receipts - $1,000 of additional payments = $2,000 actual close. This is not the full-receipt-delay scenario in the table.

Assume the collection owner now expects the unpaid $2,000 of A-101 on November 17. Carry that portion forward without recreating the full invoice. Assign the additional payment to its source and distinguish a new cost from an earlier settlement of an existing obligation. Preserve the original forecast, actual cash record, reason, and revised date so the next forecast can explain each movement.

Use the construction cost-code crosswalk when source categories differ across project management and accounting. Keep unmapped amounts visible instead of losing them from the cash total. Refresh future dates after the variance review (while retaining the frozen comparison) so later readers can reproduce both versions.

Where Permute fits in a cash review

Permute sells connected business data, custom applications, and governed context for AI tools. We can scope a review around permitted Sage or QuickBooks transactions, Excel assumptions, and supporting documents in Google Drive. Project references, invoice identities, and payment evidence need agreed mappings that retain the original records.

We use declared definitions to separate billed, approved, expected, and settled amounts. A controller can inspect the evidence behind a moved receipt through a scoped application or an AI tool such as Claude or ChatGPT. Access, source refresh, and unresolved mappings need verification before that view supports the cash-review meeting.

Keep forecasting assumptions and financial decisions with their owners

We are not a forecasting engine, and we do not select accounting treatments, tax policy, or borrowing terms. This review does not authorize bank transfers or promise collections. Any execution requires a separately verified supported workflow, explicit approval, and current permissions.

Build the cash forecast from expected receipt and payment dates on an explicit opening-cash basis. Keep billing status, retainage release, and commitments attached to their evidence and owners. Test the dated cash path because weekly endpoints can hide an earlier funding need. Compare actual movements with the frozen schedule, then carry revised assumptions into the next review.

Questions about construction cash forecasts