How a Fractional CFO Builds a 13-Week Cash Flow Forecast for Construction and Home-Service Companies

By Velocity Business LLC editorial team | Fractional CFO | Published

A fractional CFO builds a 13-week cash flow forecast by reconciling available cash, scheduling customer collections and payments by week, and testing delays against an operating reserve. For construction and home-service companies, the forecast connects job milestones, retainage, payroll, and material purchases so owners can act before cash becomes tight.

Start with cash timing, not the profit estimate

A profitable job can still require cash before the customer pays. An installation may need equipment ordered before mobilization, while billing depends on completion or an approved milestone. The forecast answers a different question from the income statement: what money should actually enter and leave the bank during each coming week?

The FDIC's current Managing Cash Flow participant guide distinguishes cash flow projections from actual cash reporting and explains working capital as current assets minus current liabilities. That definition matters because receivables are not the same as spendable bank funds. An owner needs both a working-capital view and a dated cash schedule.

For this workflow, 13 weeks is a planning horizon, not a legal requirement or an accuracy guarantee. Weekly columns expose the timing of payroll, purchasing, billing, and collections. A longer-range budget still supports equipment plans and seasonal strategy. The short-term forecast shows whether those plans fit the cash expected to be available before the next major receipt.

Establish a reconciled opening cash position

Begin with balances for every included business bank account at a defined cutoff. Reconcile outstanding checks, pending withdrawals, transfers, and deposits so the opening figure matches the money represented in the model. An internal transfer is not a customer receipt and should not increase consolidated cash.

Show restricted or earmarked funds separately. Do not assume every customer deposit is available for unrelated projects. Document any contractual restrictions and identify internally reserved amounts without treating those two categories as identical. This article does not interpret restrictions or payment rights for a particular contract.

In a hypothetical contractor example, the bank shows $72,000 and there are $9,000 of outstanding payments not yet reflected in that balance. Available opening cash is $63,000, calculated as $72,000 minus $9,000. Those payments must not also appear as new future outflows if they have already been deducted from opening cash.

Request the receivables aging, unpaid vendor bills, payroll calendar, debt schedules, purchase orders, and active-job schedule. The SBA's Manage your business guidance identifies accounts receivable, accounts payable, available cash, bank reconciliation, and payroll as functions someone should manage. Reliable accounting support supplies that foundation; a forecast cannot repair missing transaction records simply by adding assumptions.

Convert contractor receivables into realistic collection weeks

Build the collection schedule from individual invoices and identifiable future billings. Each material receipt should have a customer or job reference, an amount, an expected bank-receipt week, a responsible person, and evidence supporting the date. Invoice due dates are a starting point, not proof that payment will arrive on time.

For construction work, distinguish submitted payment applications, approved applications, disputed amounts, and work that is not yet billable. Record what must happen before each amount can become cash. Missing inspection documentation, an unresolved change order, or incomplete closeout paperwork should create a visible dependency rather than disappear inside a total.

Retainage deserves its own schedule. Industry guidance from NASBP's Surety Bond Quarterly describes retainage as funds withheld from payment requisitions to secure performance or address defective work. It also emphasizes clear records of the amount. Use the actual contract and collection evidence; this article makes no claim about a universal percentage or release deadline.

For a separate hypothetical invoice of $50,000 with an assumed contractual holdback of 10%, retainage is $5,000 and the current payment portion is $45,000. Schedule that $45,000 only when collection is supported. Keep the $5,000 outside near-term receipts unless the release conditions and expected payment date support inclusion. These assumptions are illustrative, not standard terms.

Home-service forecasting requires different details. Separate service-call receipts, installation deposits, completion payments, and recurring maintenance collections. Confirm payment-processor settlement timing. A completed appointment is not automatically a deposit in the bank, and the same customer payment must not appear in both an invoice schedule and a processor settlement total.

Schedule payroll, job costs, and overhead when paid

The payment side starts with known obligations. Enter payroll withdrawals, subcontractor payments, supplier invoices, rent, insurance, vehicle costs, software subscriptions, loan payments, and owner distributions in their expected payment weeks. Use actual due dates and approved arrangements rather than spreading every monthly cost evenly across the forecast.

Job commitments need special attention. An open purchase order may require a deposit before a supplier ships equipment. A subcontractor milestone may precede the company's own customer collection. Ask operations to confirm purchasing and mobilization dates, then include commitments that have not yet become vendor invoices. Flag cancellable purchases separately from unavoidable obligations.

Payroll cash includes more than employee take-home pay. Identify employer taxes, withheld taxes, benefits, and processing charges, then map the actual payroll-provider withdrawals. The IRS employment-tax deposit guidance describes monthly and semiweekly deposit schedules and directs employers to determine the applicable schedule. Deposit timing is not interchangeable with return-filing timing. Use the company's applicable calendar, not a generic quarterly assumption.

Avoid double counting when the provider debits taxes alongside wages. Likewise, put a financed equipment purchase and its financing in the appropriate cash lines rather than assuming the full invoice leaves the bank immediately. Include loan principal as a cash payment even though principal repayment is not an operating expense. Keep owner draws visible so operating needs are not obscured.

Build the weekly model with traceable assumptions

Use a simple direct cash format: beginning available cash, operating collections, other cash inflows, operating payments, other cash outflows, and ending available cash. Calculate ending cash as beginning cash plus inflows minus outflows. Carry that result forward as the next week's beginning balance.

Keep operating cash distinct from financing and owner contributions. A borrowing inflow can make a week look healthy without resolving a collection problem. Show confirmed financing separately, and do not insert a hoped-for loan as available money. An undrawn credit facility is not bank cash; any modeled draw needs documented availability, terms, and authorization.

Add an assumptions register beside the schedule. Identify whether each item comes from a bank record, invoice, contract, operations estimate, or sales estimate. Assign confidence labels to uncertain receipts and give each assumption an update owner. Later weeks can use broader job or service categories, but material items still need understandable timing support.

Choose a minimum cash reserve with the owner based on upcoming obligations and uncertainty. It is a management threshold, not an industry benchmark. Show the lowest projected balance, its week, and any gap below the chosen reserve. Also check daily timing around large debits: a positive Friday balance does not prove Tuesday's payroll can clear.

Test a delayed-payment scenario before approving spending

Consider a hypothetical contractor forecast with $63,000 of opening available cash. In its first three weeks, assumed receipts are $42,000, $30,000, and $55,000. Assumed payments are $58,000, $49,000, and $47,000. These figures are hypothetical and illustrate the timing of receipts and payments.

The resulting ending balances are $47,000 in week one, $28,000 in week two, and $36,000 in week three. The remaining weeks would continue the same calculation using their own receipt and payment assumptions. This is a three-week excerpt illustrating the mechanism, not a complete company forecast.

Now assume a $25,000 customer payment expected in week two moves to week three. Weekly receipts become $42,000, $5,000, and $80,000, with payments unchanged. Ending balances become $47,000, $3,000, and $36,000. The final balance is unchanged, yet the interim cash position is sharply different.

If this hypothetical owner chooses a $25,000 minimum reserve, week two is $22,000 below it. That shortfall is relative to the chosen reserve, not a negative bank balance. The CFO should also examine the order of receipts and withdrawals within that week to identify any intraweek funding need.

The useful conversation is specific: can the customer confirm payment timing, can an uncommitted purchase move without disrupting work, or should the owner revise a discretionary distribution? A downside case should change identifiable assumptions. It should not merely reduce every revenue line by an arbitrary percentage or assume suppliers will tolerate late payments.

Translate the forecast into job and purchasing decisions

The forecast is useful when it changes a decision before money is committed. Before accepting a substantial installation or construction project, map its expected deposits, material payments, labor, billing milestones, and collection timing into the company schedule. Evaluate the job's cash demands alongside the existing workload, not in isolation.

A strong margin does not answer whether the company can fund several overlapping starts. The CFO can identify the period of greatest cash exposure; operations can assess whether mobilization or procurement can change; the owner decides whether the proposed commitment fits the business's available resources.

In a separate hypothetical purchasing example, a supplier offers a 2% discount on an $18,000 material order for an earlier payment. The discount is $360, and the early cash payment is $17,640. The CFO should compare the forecast with and without that early withdrawal. The discount alone does not justify reducing cash needed for payroll or other commitments.

An action list should name the decision, its owner, the deadline, and the assumption it changes. Negotiated payment dates belong in the model only after confirmation. A proposed customer deposit is not a receipt until its terms and likely collection timing support it.

Borrowing can be evaluated as one option, with fees, repayments, and restrictions modeled alongside proceeds. This forecast does not establish eligibility or guarantee approval. It also cannot resolve contractual disputes. The practical objective is to make cash consequences visible before the owner selects a course of action.

Separate CFO, bookkeeper, COO, and sales responsibilities

For this topic, the fractional CFO owns the forecasting method, tests assumptions, interprets liquidity risks, and presents decision options. The CFO connects cash timing to the owner's priorities and explains which facts would change the recommendation. Fractional CFO support is financial leadership, not simply a relabeled bank-balance report.

The bookkeeper maintains transaction records, reconciles accounts, applies customer receipts, and updates receivables and payables. That work establishes dependable actuals. If a receipt was applied to the wrong invoice, the records need correction before the collection schedule can be trusted. The CFO should not obscure bookkeeping gaps with optimistic projections.

The COO or operations lead owns the practical schedule: crew deployment, job progress, purchasing requirements, inspection readiness, and closeout documentation. Fractional COO support can help establish processes that deliver those inputs. Operations should confirm whether a proposed purchasing delay is feasible, not merely accept it because a spreadsheet suggests relief.

The sales leader supplies expected start dates, deposit terms, pipeline status, and customer commitments for potential work. Fractional sales director support can help distinguish signed work from prospects. Sales estimates inform scenarios, but unsold opportunities should not silently enter the base forecast as dependable cash.

The owner approves spending priorities and retains decision authority. Exact responsibilities, access permissions, fees, and deliverables are agreed in the engagement scope. Fractional CFO is not a claim of CPA licensure. This article provides general financial guidance, not individualized tax, legal, or accounting advice.

Refresh the forecast and investigate weekly variances

Set a recurring cash meeting with the people responsible for records, collections, operations, and decisions. Replace the completed week with actual bank activity, reconcile differences, and add a new week at the end. Preserve the previous forecast so the team can compare what was expected with what happened.

Explain variances by cause. A late customer payment is different from a cancelled job, and an accelerated supplier debit is different from an unplanned cost increase. Timing differences should move into the appropriate future week; permanent differences should change the underlying assumption. Neither should disappear merely because the model rolls forward.

For a hypothetical weekly comparison, forecast receipts are $42,000 and actual receipts are $34,000. The unfavorable variance is $8,000. If $6,000 represents a documented delayed receipt, the remaining unfavorable difference is $2,000. Breaking the difference into timing and collection issues makes the corrective action clearer.

Track missed receipt dates, repeated billing delays, and surprise commitments. When the same assumption fails repeatedly, change the collection estimate or operating process. Recheck the lowest cash week after each update and attach any required decision to a named owner. A forecast should become better informed through actual activity, not simply look more polished each week.

Owner checklist for a usable 13-week forecast

Before relying on the schedule, work through these checks with the team:

Confirm the opening balance cutoff, reconciliations, outstanding payments, and treatment of restricted funds.

Match material receipts to invoices or documented future billings, with expected collection weeks and responsible follow-up owners.

Separate retainage, disputed amounts, unapproved changes, and unsigned sales opportunities from dependable collections.

Include payroll withdrawals, applicable tax deposits, supplier commitments, debt payments, and owner distributions without duplication.

Identify the lowest cash week and compare it with the owner's chosen reserve, including daily timing where necessary.

Review a specific delayed-collection case and record feasible actions rather than assuming payment obligations can be ignored.

Assign operations and sales input deadlines, preserve forecast versions, and explain actual-versus-forecast differences.

If a check fails, identify the missing record or decision before treating the forecast as ready. A useful starting deliverable is a reconciled opening position, documented assumptions, and a rolling weekly schedule the owner can understand.

To discuss how Velocity Business LLC could support that workflow, contact the team about the records available, the decisions involved, and the proposed engagement scope. The forecast is a planning tool, not a promise of savings, financing, or particular business outcomes.

Sources

U.S. Small Business Administration: Manage your business, financial management guidance

FDIC: Money Smart for Small Business, Managing Cash Flow participant guide

Internal Revenue Service: Depositing and reporting employment taxes

NASBP Surety Bond Quarterly: Retainage, What Contractors Need to Know and Helpful Strategies

Frequently Asked Questions

Find answers to questions covered in this article.

Should retainage be included in a 13-week cash flow forecast?

Include retainage in the supporting receivables schedule, but place it in weekly cash receipts only when release conditions and collection evidence support the timing. Keep uncertain or later releases outside dependable near-term collections. The NASBP retainage article supports tracking withheld amounts clearly; it does not establish a single deadline applicable to every contract.

How should unsigned bids and home-service estimates enter the forecast?

Keep them separate from the base collection schedule unless there is sufficient evidence to justify inclusion as an explicitly labeled estimate. A sales scenario can show the cash effects of winning the work, including purchasing and labor before collection. Record expected approval, start, billing, and receipt timing so an attractive opportunity does not appear as immediately available cash.

Can a contractor use invoice due dates as expected collection dates?

Due dates provide a contractual reference, but the forecast needs an expected bank-receipt date. Check whether the invoice was accepted, documentation is complete, any amount is disputed, and the customer's payment behavior supports the estimate. Keep the due date in the records and document why the cash schedule uses a different week when collection evidence indicates a delay.

What if a payment delay creates a cash shortage before payroll?

Examine daily receipts and withdrawals around the payroll debit, then confirm customer timing and review feasible discretionary spending changes. Operations should evaluate any proposed purchasing or scheduling adjustment. Do not assume taxes, wages, or vendor obligations can simply be postponed. Model any confirmed funding separately and recognize that a forecast does not guarantee access to credit or solve contractual obligations.

Should payroll taxes be forecast quarterly because Form 941 is quarterly?

Do not equate the return-filing cycle with cash-deposit timing. The IRS deposit guidance describes monthly and semiweekly schedules and directs employers to determine the applicable schedule. Use the business's actual requirements and payroll-provider withdrawal calendar. Confirm whether the provider already debits taxes with payroll so the forecast does not include the same cash payment twice.

Does a 13-week cash forecast replace construction job costing?

No. Job costing helps assess the economics of individual projects, while a cash forecast schedules receipts and payments across the company. A job can have a favorable estimated margin but require funding before collections arrive. Use job-cost information to inform labor, material, and subcontractor assumptions, then evaluate their payment timing alongside other projects and overhead.

How much detail belongs in the later weeks of the forecast?

Use enough detail to explain material cash movements without pretending uncertain dates are confirmed. Near-term weeks should lean on documented obligations and collections; later weeks may use labeled job and service assumptions. The FDIC cash flow guide treats projections as estimates that can be revised. Update the assumptions as billing, scheduling, and payment information becomes available.