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.
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.
10 tasks
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.
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.
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.
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.
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.
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.
Pull a list of all active jobs that will have billings during the forecast period. Include job number, job name, client, and project manager.
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.
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.
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.
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.
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.
Run reports showing open subcontracts, purchase orders, and unpaid vendor invoices for each project. Note amounts, vendors, and due dates.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Explain major assumptions behind inflows and outflows and review the proposed corrective actions for tight periods. Invite comments and alternative ideas from participants.
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.
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.
When you refresh the forecast (weekly or bi-weekly), note actual bank balances for the prior periods and compare them to forecasted ending balances.
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.
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.
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.
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.
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.
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.
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.
Save forecast models, summaries, and change logs in a shared folder with appropriate access controls. Ensure only authorized people can edit the master files.
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.
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.
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.
You Found the SOP
Start with this Cash Flow Forecast SOP, assign it to your team, and track every step from one place. Customize it as your process evolves without rebuilding it from scratch.
Start for Free