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