Weekly cash collections forecast: turn open construction invoices into dated scenarios

An aging report tells you what is open, not when cash will arrive

A Fort Worth subcontractor has $46,000 in open invoices and a payroll run next Friday. The owner looks at the total receivables and feels comfortable. The office then discovers that one large request is still awaiting approval and another expected payment has moved to the following draw. The total was real; the timing assumption was weak.

The accounts-receivable aging guide helps identify open balances and overdue items. A weekly collections forecast adds an expected receipt week, the reason for that expectation and the cash outflows that must occur before the money arrives.

The SBA’s business-finance guidance distinguishes cash monitoring and receivables management from a financial snapshot. This article provides an original planning worksheet approach, not an accounting standard, financing recommendation or guarantee of payment.

Start with reconciled records and one dated assumption per receipt

Use the ledger balance after recorded receipts and authorized credits. Confirm which amount is actually collectible in the expected draw, and identify retainage or disputed portions separately. Do not place the full original invoice into next week if part has already been paid.

For each expected collection, record the invoice ID, remaining amount, proposed week, evidence date and assumption owner. Evidence might be a written remittance schedule or a confirmed review status. Record the quality of the information without calling a promise “cash received.”

Build the outflow list from dated payroll, supplier and other committed payments. Begin with reconciled available cash and account for already-issued or pending transactions so they are not counted twice. Ask the bookkeeper about taxes, restrictions or other adjustments that affect the opening balance.

Worked example: a delay creates a week-one cash gap

Original fictional example: opening available cash is $4,000. The base case expects $10,000 of receipts and $12,000 of outflows in week one, producing $2,000 of closing cash. Week two expects $12,000 of receipts and $11,000 of outflows, producing $3,000 of closing cash.

Now move an expected $8,000 collection from week one to week two. Week-one receipts become $2,000, so the modeled closing cash is negative $6,000. That negative number flags an uncovered timing gap; it is not an assumption that an overdraft or credit facility is available. Week two returns to $3,000 if the delayed receipt arrives with the originally expected $12,000.

The two-week total is unchanged, but the business still faces a week-one problem. A forecast should expose that problem while there is time for an authorized review of collections, payment commitments and available options. A positive later balance does not pay an earlier payroll run.

Separate confirmed information from optimistic assumptions

Use labels that explain the evidence: “scheduled per written remittance,” “expected after approval” and “timing unresolved.” Those labels are planning categories, not probabilities. Avoid adding a precise collection percentage unless the business has a defensible method and understands its limits.

A scheduled transfer is still not received cash. Move it into the actual-receipt column only when the finance record supports that status. If the amount or date changes, preserve the prior forecast version and a short reason for the change.

Use the follow-up log to assign collection actions. Use the invoice dispute log to document a challenged balance. The forecast should read those records, not quietly alter them to make the cash outlook look better.

Run a short weekly review with a named owner

At each review, reconcile actual receipts since the previous version, identify moved collections and update the next few weeks. Ask which assumption changed, which payment commitment is approaching and who owns the next action. Keep the forecast date visible so an old file is not mistaken for the current plan.

A useful variance note might read: “Invoice 221 remains unpaid. Customer now expects review on Wednesday; no remittance scheduled. Collection moved from the base case to the unresolved list pending confirmation.” This note explains the change without inventing a confirmed payment date.

Keep the monthly notice review separate from cash expectations. A forecast delay or payment promise should not automatically change a statutory review date. Preserve the actual work month even if the invoice moves between forecast weeks.

• Compare prior expected receipts with actual applied receipts.
• Reconcile open invoices before adding new collections.
• Keep retainage and unresolved disputes visible.
• Review one realistic delayed-receipt scenario.
• Assign the collection action and next review date.

Cash-forecast questions that prevent false confidence

Is the forecast the same as profit? No. It models receipt and payment timing under stated assumptions, rather than determining accounting income.

Should every overdue invoice be put into next week? Only if the evidence supports that expectation. Otherwise keep the timing unresolved and show the consequence in a scenario.

Does the forecast need thirteen weeks? Choose a useful horizon for the business and available data. This example uses two weeks to make the timing arithmetic visible; the same record can be extended without pretending that distant dates are certain.

Does Texas Notice Tracker guarantee the receipt week? No. Project records and reminders support the review, but customer payment behavior still has to be verified.