Case Studies Management Reporting | Financial Controls

Establishing Cash Visibility and Profitability Insight for a Services Business Operating Without Financial Controls

Engagement Overview
  • Sector: Professional services — communications
  • Revenue model: Project fees and retainer arrangements
  • Primary cost driver: Employee salaries and on-costs
  • Engagement type: Financial controls design and management reporting — ongoing

Executive Summary

A growing professional services business engaged Sapphire Digital Accounting Australia after its leadership team identified a fundamental gap: they had no reliable mechanism to determine whether the business was generating a profit. The absence of cash flow forecasting, structured management reporting, and per-project profitability analysis meant that financial decisions were being made without adequate information.

Sapphire's engagement team introduced three interconnected financial controls: a 13-week rolling cash flow forecast, a structured month-end reporting framework, and a bespoke employee cost and project profitability model. Together, these gave management the visibility needed to make informed decisions on pricing, resourcing, and cost control — transforming the finance function from a reactive record-keeping operation into an active management tool.

Client Overview

The client is a professional services business operating in the communications sector. The business generates revenue through project-based client engagements and retainer arrangements, with cost structures dominated by employee expenses and associated overheads. At the time of engagement, the business had been operating for several years but had not established a formal financial management framework.

Engagement Scope

The engagement was structured around three workstreams, each addressing a distinct gap in the client's financial management capability:

  • Short-term liquidity management — design and maintenance of a 13-week rolling cash flow forecast
  • Monthly financial reporting — structured income statement analysis and management commentary
  • Profitability modelling — development of an employee cost calculator and project-level margin analysis

Key Challenges

4.1 No Cash Flow Visibility

The business had no forward-looking cash position. Management was unable to anticipate upcoming cash obligations or identify periods of potential liquidity stress with sufficient lead time to take corrective action. Decisions on investment, staffing, and client acquisition were being made without reference to the underlying cash position.

4.2 Absence of a Structured Reporting Cycle

Monthly financial results were not being reviewed in a structured or timely way. Without a defined reporting framework, management lacked clarity on revenue trends, cost movements, and period-on-period performance. There was no mechanism for identifying deteriorating margins or cost overruns before they became material.

4.3 Inability to Determine True Profitability

The business could not accurately determine whether individual projects or employees were generating a positive return. Billing rates had been set without reference to the full cost base — including employer superannuation contributions, leave entitlements, overhead allocations, and other on-costs — meaning that projects could be loss-making without management being aware of it.

4.4 Uncontrolled and Opaque Cost Base

Costs were not being tracked against budget or reviewed for optimisation. The absence of expense analysis meant that cost inefficiencies were not visible, and there was no framework for identifying savings or renegotiating supplier arrangements.

Approach and Solution

5.1 13-Week Rolling Cash Flow Forecast

A 13-week rolling cash flow model was designed to provide management with a forward view of the business's liquidity position at any point in time. The model was structured to capture all known and anticipated cash inflows — including client receipts by project and retainer — and all outflows, including payroll, supplier payments, tax obligations, and discretionary expenditure.

The 13-week horizon was chosen deliberately: it is long enough to identify structural liquidity pressure before it becomes a crisis, but short enough to maintain forecast accuracy. The model was updated on a rolling weekly basis, with variances between forecast and actual tracked and explained to maintain model integrity over time.

This gave management the ability to anticipate cash shortfalls with sufficient lead time to act — whether through accelerating client collections, deferring discretionary spending, or arranging short-term financing — rather than responding reactively.

5.2 Month-End Financial Reporting Framework

A structured month-end reporting cycle was introduced, anchored to a defined close timeline and a standardised management report. The report was designed to be read by non-finance stakeholders, presenting results in plain language with commentary that explained variances rather than simply restating numbers.

The framework covered revenue by client and project type, gross margin analysis, operating cost review, and a comparison of actual results against the prior period. The rationale was to give management a consistent reference point each month — so that trends could be identified early and decisions could be made on the basis of current, accurate information rather than intuition.

5.3 Employee Cost and Project Profitability Model

A bespoke employee cost calculator was developed to determine the true all-in cost of each employee to the business. The model incorporated base salary, employer superannuation contributions, payroll tax, leave provisions, and an allocated share of fixed overhead costs. This produced a fully loaded cost rate per employee — the minimum billing rate required to recover costs and generate a margin.

The model was then applied at the project level, mapping employee time allocations against client billing rates to produce a margin calculation for each engagement. This made it immediately apparent which projects were profitable, which were marginal, and which were being delivered at a loss — information that had not previously been available to management.

The decision to build this as a standalone model — rather than embedding it in the accounting system — reflected the practical reality of the client's systems environment and the need for a tool that management could interrogate directly without finance intermediation.

Tools and Systems

The engagement was delivered using the following tools:

  • Excel-based 13-week cash flow model — structured with a weekly rolling mechanism and actual-versus-forecast variance tracking
  • Excel-based employee cost calculator — covering all on-costs, overhead allocations, and project-level margin analysis
  • Accounting system (client's existing platform) — used as the data source for actuals, with no system changes required
  • Structured reporting template — designed for monthly distribution to management and key stakeholders

Results and Impact

The following outcomes were observed over the course of the engagement. Improvements are assessed against the pre-engagement baseline established during the initial diagnostic.

Area Baseline State Post-Engagement State
Cash flow visibility No forward view; decisions made without liquidity reference 13-week rolling forecast updated weekly; cash shortfalls identified with adequate lead time
Management reporting No structured monthly review; results reviewed sporadically Defined close cycle; monthly P&L report with variance commentary issued within agreed timeframe
Employee profitability Billing rates set without reference to full cost base All-in cost rate calculated per employee; loss-making resources and projects identified
Project margin visibility No project-level profitability data available Per-project margin calculated; management able to make informed pricing and resourcing decisions
Cost control No expense review process; inefficiencies unidentified Monthly cost review introduced; specific areas of inefficiency identified and actioned

Key outcome: Management was able, for the first time, to answer the question of whether the business was profitable — at the entity level, at the project level, and at the individual employee level. Pricing decisions and resourcing changes were made on the basis of this analysis.

Conclusion

This engagement illustrates a challenge that is common in professional services businesses that have grown beyond their early-stage financial infrastructure: the accounting function is producing records, but it is not producing management information.

The three tools introduced in this engagement — cash flow forecasting, structured monthly reporting, and employee cost modelling — are not complex in isolation. Their value lies in the combination: together, they give management a complete picture of liquidity, profitability, and cost — the three dimensions that determine whether a services business is sustainable.

For businesses in a similar position, the most important first step is not a system change or a technology investment. It is the discipline of structured financial reporting — regular, reliable, and designed for the people who need to act on it.

Key Results

13-Week
Rolling Cash Flow Forecast Delivered
Per-Head
True Employee Cost Visibility Established
Monthly
Structured P&L Review Introduced
100%
Project Margin Visibility Achieved