Building Financial Controls for a Multi-Site Construction Business: Cash Flow Forecasting, Project Profitability, and Labour Cost Reconciliation

A multi-site construction business managing concurrent projects across several locations engaged Sapphire Digital Accounting Australia to address three interconnected gaps in its financial management framework: an absence of short-term cash flow visibility, no reliable mechanism for tracking project-level profitability, and a labour costing process that could not accurately allocate hours or costs to individual jobs.

Sapphire designed and implemented four structured financial models — a rolling cash flow forecast, a near-term liquidity planning tool, a project costing and profitability model, and a timesheet reconciliation framework. Together, these gave management the financial information needed to plan liquidity, identify underperforming projects, and accurately determine the true cost of labour on each job — disciplines that the business had been operating without.

The client is an Australian construction business managing multiple concurrent projects across different sites. The business operates in a project-based revenue model, with cost structures dominated by labour, subcontractors, and materials — all of which vary significantly by job. At the time of engagement, the business lacked the financial reporting infrastructure to monitor performance at the project level or manage short-term liquidity proactively.

• Sector: Construction — multi-site project operations
• Revenue model: Project-based contracts across multiple concurrent sites
• Primary cost drivers: Labour, subcontractors, and materials — variable by project
• Engagement type: Financial controls design and management reporting — ongoing

The engagement covered four workstreams, each targeting a specific financial management gap:

• Short-term cash flow forecasting — design and maintenance of a rolling two-week cash flow model
• Liquidity planning — a complementary near-term liquidity tool covering daily and weekly cash obligations
• Project costing and profitability — development of a model to track and report project-level margins on a fortnightly basis
• Labour cost reconciliation — a timesheet reconciliation framework to allocate payroll costs accurately to individual jobs

4.1 No Short-Term Cash Flow Visibility

The business had no forward-looking view of its cash position. Management could not identify upcoming cash shortfalls with sufficient lead time to act — whether by accelerating collections, deferring payments, or arranging bridging facilities. Payroll and vendor payment decisions were being made reactively, without reference to the expected cash position over the following weeks. In a project-based business with uneven cash inflow timing, this represented a significant operational risk.

4.2 Absence of Project-Level Profitability Data

Revenue and costs were not being tracked at the project level in a structured or timely way. Management had no reliable mechanism to identify which projects were generating acceptable margins and which were running at or below breakeven. Without this information, pricing decisions for new projects and resource allocation decisions for current ones were being made without adequate financial reference.

4.3 Labour Costs Not Allocated to Jobs

Labour represented a significant proportion of total project cost, but hours worked were not being reconciled against project timesheets on a systematic basis. The result was that payroll costs could not be attributed to individual jobs with confidence. This created a compounding problem: project cost estimates were unreliable, and the business could not assess whether the labour component of any given project was within or above the budgeted allowance.

5.1 Two-Week Rolling Cash Flow Forecast

A rolling two-week cash flow model was designed to give management a forward view of the business's liquidity position, updated weekly as new information became available. The model captured all anticipated inflows — customer receipts mapped to project milestone schedules — and all outflows, including subcontractor and supplier payments, payroll runs, tax obligations, and overhead costs.

A two-week horizon was selected to reflect the operating rhythm of the business: it is long enough to identify an emerging shortfall before it becomes a crisis, but tight enough to maintain forecast accuracy given the variability of construction cash flows. Variance tracking between forecast and actual was built into the model from the outset, both to maintain model integrity and to improve the quality of forward estimates over time.

5.2 Near-Term Liquidity Planning Tool

A complementary liquidity model was developed to sit alongside the cash flow forecast, providing daily and weekly visibility over committed cash obligations and minimum reserve requirements. Where the cash flow forecast addressed the question of what cash was expected over the next two weeks, the liquidity model addressed the question of whether that position was adequate — flagging periods where obligations were likely to approach or breach minimum thresholds.

The rationale for maintaining these as two separate but linked tools was that they serve different management decisions: the cash flow forecast supports payment and collection planning; the liquidity model supports decisions about whether additional facilities or collections acceleration are required.

5.3 Project Costing and Profitability Model

A project costing model was designed to consolidate all direct costs — labour, subcontractors, and materials — against project revenue on a job-by-job basis. The model tracked actual costs against the original estimate, producing a variance analysis that enabled management to identify cost overruns at the project level before they were absorbed into an undifferentiated profit and loss account.

Fortnightly reporting was adopted as the review cycle — frequent enough to allow corrective action while being practically achievable given the volume of transactions involved. The decision to track both actual and estimated costs from project inception, rather than simply recording actuals, was deliberate: it is only by reference to the original estimate that a cost overrun can be identified and understood.

5.4 Timesheet Reconciliation Framework

A structured timesheet reconciliation process was introduced to bridge the gap between payroll records and project cost allocations. Total hours paid through payroll were reconciled against hours recorded on project timesheets each pay period, with any unmatched or unallocated hours identified and resolved before costs were allocated to jobs.

The framework produced a reconciled labour cost allocation by project — giving management a reliable figure for the labour component of each job's cost, and enabling meaningful comparison against the budgeted labour allowance. Discrepancies identified through the reconciliation process also served as a signal for operational issues — such as hours not being recorded against the correct job — that would otherwise remain invisible.

All four models were designed and delivered in Microsoft Excel, using the client's existing accounting system as the source of actuals. No new system investment was required. The choice of Excel was deliberate: it gave management direct access to the models for interrogation and scenario testing without requiring finance intermediation, and it allowed the models to be built and deployed quickly against an immediate business need.

The following outcomes were observed following implementation. Improvements reflect the change from the pre-engagement baseline established during the initial diagnostic.

Key outcome: Management was able, for the first time, to answer three fundamental questions with confidence: Is the business in a sound cash position for the next two weeks? Which projects are profitable, and which are not? Is labour being deployed and charged to jobs accurately? These are the operating questions that project-based businesses need to answer consistently to remain in control.

Construction businesses face a particular financial management challenge: revenue is project-based and uneven, costs are variable and site-specific, and the volume of transactions across concurrent jobs makes project-level visibility difficult to maintain without structured processes.

The tools introduced in this engagement are not complex in concept. Cash flow forecasting, project costing, and labour reconciliation are established disciplines. Their value here lay in the fact that they did not exist — and in a project-based business operating across multiple sites, their absence meant that management was making significant financial and operational decisions without adequate information.

For finance leaders and business owners in similar operating environments, the most important insight is that project-level financial visibility does not require sophisticated systems. It requires structured processes, consistently applied, and a reporting rhythm that gives management the information it needs at the frequency the business demands.