Winning more work.
Keeping less profit.
The sales report looks healthy. Your team is busier than ever. So why does the extra work leave so little behind?
Contract profitability reporting connects what you charge with what it actually takes to deliver. It gives finance, operations and sales a shared basis for deciding what to change.
5 October 2026 · For UK service businesses and operational leaders
The revenue is real. So is the effort.
Commercial review required · Illustrative example
Reconciled Finance revenue · Illustrative example
Approved Timesheets and supplier costs · Illustrative example
Review Extra visits and scope changes · Illustrative example
The meeting that a sales dashboard cannot finish
Imagine a facilities services company discussing a successful contract renewal. Sales sees a valuable customer. Operations sees repeated short-notice visits. Finance sees a contribution that has almost disappeared. Each team has evidence, but the evidence sits in different places.
The account is not necessarily a bad one. The price may no longer cover the service being delivered. Overtime may be masking a scheduling problem. Small requests may have become an unofficial extension of the contract.
“Should we win more of this work?” needs a better answer than “the customer spends a lot with us”.
This is where a useful reporting project begins: with a commercial decision. The objective is to make the cost of serving an account visible early enough to discuss scope, change delivery or negotiate a sustainable price.
Follow the work behind the invoice
In this illustrative example, the headline contract value hides the effort consumed by delivery. The costs below are separate categories, counted once.
| Component | Amount | What to investigate |
|---|---|---|
| Net revenue | £40,000 | Revenue recognised for this month, after relevant credits. |
| Scheduled delivery labour | −£25,000 | Approved hours at agreed loaded rates; excludes the extra hours below. |
| Extra visits and overtime labour | −£7,000 | Separate hours: who requested the work, and was it chargeable? |
| Materials, travel and subcontractors | −£5,000 | Supplier costs and agreed accruals attributed to this contract. |
| Dedicated coordination | −£2,000 | Contract-specific support effort, excluded from the labour categories above. |
| Contract contribution | £1,000 | £40,000 less £39,000: a 2.5% contribution margin before central overheads. |
Ask what can actually change. An allocated cost is not automatically avoidable. Ending a contract may leave salaries, leases and central costs in place. Use the report to investigate options with finance and operations, not to trigger automatic customer exits.
Three decisions worth building a report for
A useful dashboard leads to a named decision, an owner and a date.
Reprice the work
If the agreed service consistently costs more than the pricing model assumes, the commercial owner needs a renewal discussion supported by actual delivery evidence.
Decision evidence: comparable periods, service volumes, agreed rates and the cost assumptions used in the original quote.
Reset the scope
If extra requests explain the gap, the account owner needs a clear change process. Capture the request, approval and charging decision before additional work becomes routine.
Decision evidence: agreed scope, extra visits, customer approvals and unbilled variations.
Improve delivery
If avoidable repeat visits or poor scheduling consume the margin, the operations owner needs a service improvement plan that protects customer outcomes.
Decision evidence: causes of rework, travel patterns, capacity constraints and service quality alongside cost.
Start with one renewal decision
A focused pilot is easier to test than a dashboard covering every customer, cost and exception at once.
Agree what “profitable” means
Choose a service line and contracts with a forthcoming review. Finance should define net revenue, direct costs, loaded labour rates, accruals and any overhead allocation. Show contribution separately from profit after allocated overheads. Use total contribution divided by total revenue for the portfolio margin; do not average contract percentages.
Connect records at the right level
Use a stable contract reference across finance lines, timesheets and delivery records. Keep each source at its natural level of detail and aggregate to the same contract and period. Joining every invoice line directly to every timesheet line can multiply both revenue and cost.
In Power BI, separate transaction tables can share contract and date dimensions. Microsoft’s star schema guidance explains this separation between data used for grouping and data used for summarising.
Expose what is missing
Reconcile revenue and cost totals to the agreed finance extracts. Keep unmatched contract references in an exception queue. Display cost completeness, last refresh and whether the period is provisional. Missing timesheets or a late supplier invoice must not silently become zero cost.
Review it with the people doing the work
Ask an account manager and an operations manager to explain a sample of contracts using source records. Record disagreements and correct definitions before widening access. Give each agreed action an owner, due date and expected mechanism of improvement.
Choose technology to fit the gap
A controlled Excel model may be sufficient for a small monthly pilot. Power BI becomes useful when several teams need repeatable views by contract, customer and period. If extra work is not recorded, improve capture first; assess a Power Apps form and a Power Automate approval route where they fit the existing process. Confirm connectors, permissions and licensing for the proposed design.
Make it fair enough for people to use
Margin reporting loses credibility when teams feel judged by costs they cannot understand or influence.
Separate facts from allocation choices
Finance owns the definitions and period sign-off. Operations owns time and activity completeness. The commercial lead owns pricing and scope decisions. Keep allocation rules versioned, show their effect and document corrections to closed periods.
Protect sensitive cost information
Prefer approved aggregated labour costs where individual pay is unnecessary. Define audiences and test access with real user roles. Power BI row-level security applies to workspace Viewers, not Admins, Members or Contributors; it is also not a way to hide individual columns. See Microsoft’s RLS documentation and design guidance.
Bring the report into the existing account review. Train managers on one real decision and explain the limits of provisional figures. A report owner and deputy should maintain refreshes, mappings and support; the business owners should decide what happens next.
Measure the change in the business
Dashboard visits are useful adoption signals. They do not prove that profitability improved.
Track the value of approved extra work that reaches invoicing, repeat-visit hours, time to resolve unassigned costs and overdue commercial actions. Review contribution alongside service quality, complaints and retention so a cost reduction is not celebrated while delivery deteriorates.
Illustrative example: if a scheduling change genuinely avoids £2,000 of monthly delivery cost while revenue remains £40,000, contribution rises from £1,000 to £3,000, or from 2.5% to 7.5%. That is a five-percentage-point improvement before central overheads. It is not a forecast or a guaranteed saving.
Check whether the cost was actually removed or capacity was simply freed. Compare similar service volumes and account for seasonal demand, rate changes and one-off credits. Keep the evidence linking each action to its result.
Could you explain your lowest-margin contract?
Tick only statements you can support with current evidence. This is a discussion aid, not an audit or certification.
How Smart Statistics could help
Start with a recent quote, its agreed scope and the records used to deliver it. Smart Statistics could help map the reporting gaps, agree practical measures with your team and build a connected view of revenue, effort and cost.
The work can combine business analysis, Power BI reporting and process improvement: define the decision, trace the data, test the result and make the review part of normal operations. Where missing information is the problem, scope improvements to capture and approval before adding more charts.
A useful initial brief is specific: “Before our next renewal meeting, help us explain the contribution on this service line and agree which accounts need action.” The deliverable should include reconciled measures, visible exceptions, clear ownership and a handover your team can use.
Questions business leaders ask
Is contract contribution the same as net profit?
No. In this article, contribution is net revenue less the defined direct delivery costs. Central overheads, financing and tax are outside that measure. Finance should approve the definitions used in your business.
Do we need Power BI to start?
No. A controlled Excel model can support a focused pilot. Consider Power BI when you need repeatable reporting across several sources, teams or reporting periods.
What if our timesheets and cost records are incomplete?
Show the gaps and mark affected results as provisional. Agree who will resolve missing records before using the figures for major pricing or customer decisions.
Should we stop serving low-margin customers?
Not on the dashboard alone. Investigate scope, pricing, delivery options, strategic value and which costs would actually disappear. The report supports a commercial decision; it does not replace one.
Know which work is worth winning again
Bring the contract that makes your team busy but leaves you questioning the return. Talk to Smart Statistics about connecting the numbers, understanding the cost of delivery and turning the next review into a decision.