Cash Flow Forecast for General Contracting
Cash Flow Forecast is the process of predicting future cash inflows and outflows so the company can meet obligations without running out of cash. It combines project-level billing and payment schedules with overhead, debt service, and other non-project cash items. The process translates job cost and billing data into a time-based forecast, then tests different scenarios and plans actions to manage gaps. When done properly, cash flow forecasting gives advance warning of tight periods and supports better decisions about hiring, equipment, and project selection.
Define cash flow forecasting objectives and time horizons
Step 1: Clarify the primary purpose of the forecast
Decide whether the main goal is to avoid short-term cash crunches, plan for growth, support bank reporting, or a combination. Write this down so everyone involved knows why the forecast matters.
Step 2: Set the overall forecast period
Choose how far into the future the forecast will look (for example, 13 weeks for short-term, 6–12 months for medium-term). Make sure this aligns with management’s planning needs and lender reporting requirements.
Step 3: Decide on forecast time buckets
Determine the time intervals you will use, such as weekly for the next 13 weeks and monthly beyond that. Finer buckets give more precision but require more effort to maintain.
Step 4: Define the level of project detail
Decide whether each project will be forecast individually or grouped by client, division, or region. For most general contractors, larger projects should be shown individually and smaller jobs grouped.
Step 5: Document which cash flows are in scope
List the types of cash inflows (client billings, change order payments, retainage releases) and outflows (vendor payments, payroll, taxes, debt service, overhead) that will be included. This avoids surprises later when numbers don’t match expectations.
Step 6: Set update frequency and owner
Agree on how often the forecast will be refreshed (for example, weekly or bi-weekly) and assign a specific person in Finance as the process owner. Record this in a brief written procedure.
Gather project-level billing (cash inflow) projections
Step 1: List active projects to be included
Pull a list of all active jobs that will have billings during the forecast period. Include job number, job name, client, and project manager.
Step 2: Obtain current billing plans from project managers
Ask each project manager for their expected billing amounts and dates over the forecast horizon, based on progress, milestones, and planned pay applications. Request these in a simple template that matches your forecast time buckets.
Step 3: Review contract terms and typical client payment timing
For each project, review payment terms and typical payment lag (for example, 30 days after approval, often with real-world delays). Adjust projected cash receipt dates to reflect realistic timing, not just contract language.
Step 4: Incorporate retainage and final payments
Identify how much retainage is outstanding and when it is expected to be released. Similarly, estimate final payment timing based on expected substantial completion and closeout timelines.
Step 5: Record project inflows into the forecast model
Enter expected cash receipt amounts into the forecast model by project and time bucket. Label each line with the job number so you can trace back to the source if questions arise.
Step 6: Validate inflow totals against revenue/WIP plans
Compare the sum of forecasted cash inflows to planned billings and revenue recognition to make sure they are reasonably aligned. Investigate any large mismatches with project managers.
Gather project-level payment (cash outflow) projections
Step 1: Pull open commitments and unpaid invoices per job
Run reports showing open subcontracts, purchase orders, and unpaid vendor invoices for each project. Note amounts, vendors, and due dates.
Step 2: Discuss upcoming work and major buys with project managers
Meet with project managers to understand their plans for upcoming phases, major material purchases, and anticipated subcontractor billings. Ask them to identify big spends and approximate timing.
Step 3: Estimate timing of subcontractor and supplier payments
Based on payment terms, expected invoicing dates, and your payment practices, forecast when cash will actually be paid out to each major subcontractor and supplier. Include retainage releases if they will occur in the forecast horizon.
Step 4: Estimate project payroll and field costs
Using staffing plans and current labor run rates, estimate weekly or monthly project payroll costs for the forecast period. Include expected overtime or staffing changes if known.
Step 5: Record project outflows into the forecast model
Enter expected cash outflows by project and time bucket into the model, separating major categories such as subcontractors, materials, equipment, and payroll if the model supports that level of detail.
Step 6: Review outflow projections with project managers
Share the projected payment schedule with each project manager and ask them to confirm or adjust dates and amounts. Update the model based on their feedback.
Incorporate overhead, debt service, and non-project cash flows
Step 1: List recurring overhead cash outflows
Identify regular monthly or weekly cash payments such as office rent, utilities, office payroll, benefits, insurance premiums, software subscriptions, and professional services. Use prior months as a guide.
Step 2: Identify periodic or annual payments
List less frequent outflows such as quarterly tax payments, annual insurance renewals, license renewals, and equipment registrations. Note expected dates and amounts based on prior years and current plans.
Step 3: Add debt service and lease payments
Include scheduled loan principal and interest payments, equipment leases, and any lines of credit that require interest-only or principal payments. Confirm payment dates with loan documents or your bank portal.
Step 4: Include planned capital expenditures
Ask leadership about planned purchases of vehicles, equipment, or major technology upgrades that will require significant cash outlays during the forecast period. Estimate amounts and timing.
Step 5: Estimate non-project inflows if applicable
If the company expects non-project cash inflows such as tax refunds, asset sales, or owner capital contributions, include these in the forecast with realistic dates and amounts.
Step 6: Enter overhead and non-project items into the model
Add these inflows and outflows into the forecast model in the appropriate time buckets, clearly labeled as overhead, debt service, or other. Check that totals match your expectations from budgets and prior periods.
Build and maintain consolidated cash flow forecast model
Step 1: Choose or create a standard forecast template
Select an existing company template or build a simple model with rows for different cash sources and uses and columns for time periods. Include lines for beginning cash, total inflows, total outflows, net change, and ending cash.
Step 2: Input beginning cash balances
Enter current bank balances for all relevant accounts as the starting point for the forecast. If multiple accounts are used, decide whether to forecast individually or in total, but be consistent.
Step 3: Link or paste project inflow and outflow data
Bring in the project-level inflow and outflow estimates you gathered, either by linking cells or copying them into the appropriate sections of the model. Keep clear labeling so you can trace amounts back to specific jobs.
Step 4: Add overhead and non-project cash flows
Enter the overhead, debt service, and other non-project items into their designated rows for each time bucket. Double-check that regular monthly items show up in every applicable period.
Step 5: Calculate net cash change and ending balances
Set formulas to sum inflows and outflows by period, calculate net cash change, and then compute ending cash by adding net change to beginning balances. Verify formulas by testing them on a small sample period.
Step 6: Check the model for errors and save version
Scan the model for obvious formula mistakes, missing periods, or mislabeled lines. Save the forecast with a version number and date so you can track changes over time.
Run scenario and sensitivity analyses on the forecast
Step 1: Identify key assumptions and risk drivers
List the assumptions that have the biggest impact on cash, such as client payment lag, timing of large billings, start dates for new projects, and size of major purchases.
Step 2: Define at least three scenarios
Create a baseline scenario (most likely), a conservative scenario (slower collections or delayed projects), and an optimistic scenario (faster collections or new profitable work starting). Clearly name each scenario.
Step 3: Adjust assumptions in the model for each scenario
In the forecast model, change the relevant inputs for each scenario, such as shifting inflows by a couple of weeks, reducing certain billings, or increasing specific cost lines. Keep track of which cells you change.
Step 4: Recalculate ending cash balances
For each scenario, let the model recalculate net cash and ending balances across the forecast horizon. Focus on periods where ending cash gets close to or below your minimum comfortable level.
Step 5: Compare scenarios and note critical periods
Lay out the scenarios side by side and highlight weeks or months where the conservative or baseline scenarios show tight cash. These are periods that may require special attention or actions.
Step 6: Summarize scenario findings for leadership
Prepare a short summary describing how robust the cash position is under each scenario and which periods are most sensitive. This summary will support discussions on contingency plans.
Identify cash shortfalls and plan corrective actions
Step 1: Set a minimum target cash balance
Agree with leadership on a minimum cash threshold that should not be breached, such as a certain number of weeks of payroll and overhead. Note this threshold clearly in the model and reports.
Step 2: Highlight periods below the threshold
Scan the forecast for periods where ending cash falls below the target. Mark these periods clearly with color or flags in the model so they are easy to see.
Step 3: List potential corrective levers
For each tight period, list options such as speeding up client billings, tightening payment terms with vendors, delaying non-critical capital expenses, drawing on a line of credit, or slowing hiring.
Step 4: Estimate impact of each action
Roughly quantify how much cash each action would free up and when. For example, delaying a truck purchase by two months or negotiating extended terms with a key supplier.
Step 5: Build a preferred action plan
Choose a combination of actions that restores ending cash above the threshold in each tight period while minimizing negative impact on projects and relationships. Sequence actions from least painful to most intrusive.
Step 6: Document action plan and assign responsibilities
Write a short plan describing which actions will be taken, by whom, and by when, for each identified cash shortfall period. Share this with leadership and keep it with the forecast.
Review and validate forecast with leadership and project team
Step 1: Prepare a concise forecast summary
Create a summary that shows beginning cash, key inflows and outflows, and ending cash for each period, plus a list of tight periods and proposed actions. Keep it to a few pages or slides for easier discussion.
Step 2: Schedule a forecast review meeting
Set up a meeting with the finance lead, owner or executive, and representatives from operations or project management. Share the summary and detailed forecast at least one day before the meeting.
Step 3: Walk through overall trends and key periods
In the meeting, start with the big picture: how cash is expected to move over time and where the highest risks lie. Then focus on the weeks or months where cash is tight.
Step 4: Discuss assumptions and proposed actions
Explain major assumptions behind inflows and outflows and review the proposed corrective actions for tight periods. Invite comments and alternative ideas from participants.
Step 5: Agree on approved actions and thresholds
Confirm which actions will be implemented, which are backup options, and whether the minimum cash threshold should be adjusted. Note any special instructions or constraints.
Step 6: Update forecast and documentation based on feedback
After the meeting, revise the forecast model and summary to reflect agreed changes. Save the updated version as the current approved forecast and record the date of approval.
Monitor actual cash performance against forecast
Step 1: At each update, record actual cash balances
When you refresh the forecast (weekly or bi-weekly), note actual bank balances for the prior periods and compare them to forecasted ending balances.
Step 2: Compare actual inflows and outflows to forecast
For each recent period, sum actual inflows and outflows and compare them to the forecasted numbers. Note which side (inflows or outflows) diverged more and by how much.
Step 3: Identify major variances and causes
For significant differences, dig into the details to see what drove them: delayed client payments, early vendor payments, unexpected costs, or new work not previously planned.
Step 4: Update model with latest actuals
Replace forecast values for past periods with actual numbers in the model, and roll forward beginning balances for future periods based on real closing balances.
Step 5: Adjust near-term assumptions if patterns emerge
If you see consistent patterns (such as clients always paying two weeks later than expected), adjust short-term assumptions in the forecast to better reflect reality.
Step 6: Document lessons learned for next cycles
Keep a simple log of what you learned from each comparison (for example, “Client X pays 15 days late on average,” “Equipment repairs higher than budget”). Use this to refine future forecasting inputs.
Maintain version control, documentation, and communication
Step 1: Establish a naming and versioning convention
Decide on a clear way to name forecast files, such as “CashFlowForecast_YYYYMMDD_v1.” Use this consistently so you can easily identify the latest approved version.
Step 2: Keep a simple forecast change log
Maintain a brief log noting each time the forecast is updated, what changed (for example, major new job, revised billing plan), and who approved the new version.
Step 3: Store forecasts in a shared, secure location
Save forecast models, summaries, and change logs in a shared folder with appropriate access controls. Ensure only authorized people can edit the master files.
Step 4: Define who receives forecast updates
Create a distribution list of people who should receive updated forecasts and summaries (for example, owners, finance leaders, operations leaders). Confirm how often they expect updates.
Step 5: Send concise update communications
When you issue a new forecast, send a short email or memo summarizing key changes, new risks, or improvements compared to the prior version. Attach the summary and indicate where the full model is stored.
Step 6: Periodically review the forecasting process
Every few months, reflect on what is working well and what is not in your forecasting process. Gather feedback from leadership and project managers and adjust templates, timing, or assumptions to improve usefulness and ease of use.
👈 Use this SOP template inside Subtrak
Edit with AI. Customize in seconds. Store and share all your SOPs and checklists in one place.