Quoted £15k. Delivered in 65 hours over six weeks. Was it profitable? I don’t know - I feel the bank balance.

Sixty-five hours quoted on the website. Felt about right at the end. We invoiced, they paid, the bank balance is fine. Whether the next quote should be £17k or £14k? I’ve got nothing - every year-end I look at the P&L and the partner shrugs and we put 5% on for next year and hope.

The £15k website rebuild, the £40k rear extension, the £120 lock change, the £6,800 wedding-flower order, the £2k-a-month fractional-CMO retainer, the storm-damage insurance pipeline that gets paid eight weeks after the work, the commercial-fit-out where labour is on CIS reverse-charge and materials are on a Howdens account, the temp-desk margin on the weekly bill-and-pay cycle, the per-pupil per-month nursery EHCP that lands 90 days late. Every project-based UK SME has the same problem: project profitability is invisible until quarter-end. By the time the numbers land, the cost-overruns are baked in, the time-not-captured is unrecoverable, the underwater project is already done, and the next quote learns nothing from the last because the last one’s never been measured.

This is the operational-data-into-decision-dashboard layer that runs on top of the rest of the build. Time captured by the foreman / clinician / consultant; materials cost from the invoice line; contractor cost from the sub-payment; variation orders from the project record; retention release from the commercial diary; recurring DDs from the payment provider. The dashboard takes all of it and turns “was it profitable?” into a one-screen check that updates as the work runs, with the cashflow projection running eighteen months forward off the booked pipeline so the Q3 trough surfaces in April rather than September. The shape is sealed against pharmaceutical-analytics.com - the operational-data-in, decision-dashboard-out pattern built for an analytics consultancy - and ports cleanly across commercial trades on CIS, independent garages on parts-margin, consultants and boutique agencies on per-project profitability, wedding suppliers on the eighteen-month deposit-balance cashflow, recruitment temp desks on the bill-weekly-pay-weekly spread, and diversified agricultural estates on multi-entity rollup.

What gets lost between the project happens and the margin is known

Every project-based business loses the same thing in a slightly different costume. A few moments - pick the ones that sound like the projects you’ve quoted recently:

• Commercial-side tradesthe £40k commercial-fit-out, four-week programme, labour on CIS reverse-charge, materials on a Howdens account, two subcontractor invoices, three variation orders the customer agreed to verbally on site, retention held at 5% for twelve months; the “did we make money on that one” answer arriving at year-end with no granularity.
• The commercial / domestic splitsame firm, two cost-models, completely different margin shapes. The domestic side runs on hour-and-materials price points the customer accepts at quote; the commercial side runs on contractor labour absorbed against the build with the in-van variation log the QS hasn’t agreed to yet.
• Independent garagesthe £20k of parts margin quietly leaking through the wholesaler-statement-to-invoice reconciliation gap. ECP, GSF, Andrew Page, MPD all send monthly statements; the reconciliation against the invoiced parts is being done by eye, the parts-margin variance against the estimate is invisible until quarter-end, and the workshop-bay scheduling problem on top of it (the Booking & Review Loop shape) hides the under-utilisation hours.
• Consultants and boutique agenciesthe £15k website project. Quoted at sixty-five hours by the senior. Actual hours: somewhere between sixty and seventy-five, no-one’s quite sure because the time tracking was patchy in week 3. Materials cost: zero. Sub-contractor cost: £1,200 to the freelance copywriter. Margin? You guess.
• Wedding suppliers on the eighteen-month bookthe deposit-balance-lag shape. Booking taken eighteen months out at £6,800 with a £680 deposit; balance lands fourteen days before the day. Cashflow is paid before delivery on the deposit and paid after commitment on the balance, with a Q3 trough every year that you can never quite remember whether you survived last year or not.
• Tutors and nurseriesthe term-cycle cashflow. Predictable July-August gap, predictable September surge, but the SEND EHCP that the local authority pays 90 days after the term starts isn’t predictable until it lands; the on-the-payroll staffing has to be there from September regardless.
• Storm-damage roofers on insurance-pipelinethe work happens immediately because the roof is open. Payment lands six-to-twelve weeks later on the loss-adjuster clock. The cashflow window is paid eight-weeks-out against work delivered six-weeks-in, with the bank-overdraft cost absorbed quietly.
• Recruiters - temp desksthe temp-margin engine. Bill the client weekly, pay the temp weekly, the spread is the margin, and the bill-versus-pay cashflow has to run tight or the temp’s not back on Monday and the client’s not back next week. The per-temp / per-client / per-margin-band view is invisible until year-end.
• Recurring service businesses on retainerthe fractional-CMO at £2k a month, the bookkeeping-retainer at £900 a month, the recurring grounds-maintenance round at £1,200 a month. The retainer’s health (utilisation, scope-creep, profitability) gets reviewed at renewal, by which point you’ve been losing money on it for six months.
• Agriculture diversified estatesthe farm Ltd + venue Ltd + holiday-let sole-trader + grain-store LLP. P&L rollup across entities. Fertiliser, diesel, ag-chem buy-now-vs-buy-later running off live price feeds. The decision to buy fertiliser in October at autumn price vs March at spring price costing £4,000-£12,000 depending on the year and currently being made on gut.

These aren’t problems for a P&L at year-end. They’re the bit between the project happens and the next quote learns from it, which is where the next year’s margin actually lives.

What solved looks like

1. Every project / job / retainer is a structured profitability object, with the margin updating live

The “I’ll work it out at year-end” moment: the £40k extension finished in October. The quote, the invoices, the materials receipts, the contractor payments, the variation orders agreed on site, the snag-list rework - they exist, in eleven places. By the time you reconcile, you’re working out December’s margin on April’s project and the lessons have evaporated.

Solved looks like: every project, every job, every retainer is a first-class object with the quoted fee on one side and the live actual cost on the other. Time captured (by the foreman in the job-management app, by the consultant in the time-tracker, by the clinician in the practice-management system) writes to the project. Materials cost reconciles from the supplier-statement run via the Multi Channel VAT & CIS Invoicing ingest. Contractor cost flows from the sub-payment ledger. Variation orders attach as they’re agreed on site (signed off in your voice, attached to the project record, queued for the customer-facing approval). Retention release attaches with its 30-day-ahead-of-due reminder. The margin updates live; the “was it profitable” answer is on screen today, not in March.

2. Estimate-vs-actuals variance, tagged so the next quote learns

The “we always under-quote bathrooms” moment: the partner has a feeling that bathrooms come in at 110-120% of quote. The other partner has a feeling it’s 105%. Neither of you can tell whether it’s the prep stage that overruns, the materials cost that drifts up, the customer variations that get absorbed for free, or the rework on the silicone that you keep doing on the Friday. Without a tagged variance, you both go on under-quoting.

Solved looks like: the variance per project carries a tag - under-estimated prep, contractor cost overran, scope crept, rework on silicone, variation absorbed for free, snag-list extended the programme, deposit landed late and ate float. The tags are per-project-type so the bathroom projects roll up to one variance distribution, the kitchen projects to another, the commercial-fit-out projects to another. Next quote in the same shape, you see the actual variance distribution from the last twelve months and calibrate against it. The under-quote habit becomes a measurable thing rather than a feeling.

3. Operator dashboard surfaces underwater projects before they’re year-end write-offs

The “I think project X might be losing money” moment: the partner thinks. The other partner thinks not. You agree to look at it next month. Next month is January, project X closed in December, the write-off is already on the books.

Solved looks like: margin distribution across active projects, retainer clients, and recurring work. Underwater projects surface on the dashboard with the contributing factor flagged (time-tracking gap on the senior, materials-variance against estimate, contractor-cost overrun, scope creep without paid variation). Multi-vertical operators see the per-vertical mix on one screen - the commercial side is running at 18% margin, the domestic side at 32%, the storm-damage insurance-pipeline side at 26% with a six-week cashflow lag. The conversation at the partner meeting becomes which one to fix, not which one to look at.

4. Cashflow projection eighteen months forward, off the booked pipeline

The “Q3 trough” moment: every September, the wedding supplier hits a quiet month between the August balances clearing and the autumn deposits landing; every February the nursery hits a quiet term between the January start and the EHCP-arrears clearing; every July the agriculture estate hits the silage-cut spend before the harvest income. You know the troughs exist. You don’t know whether this year’s one is deeper than last year’s until you’re in it.

Solved looks like: the cashflow projection runs eighteen months forward off the booked pipeline. Quotes accepted but not yet billed; invoices raised but not yet paid (drawn from the Invoice & Dunning Ladder state); retention releases on the diary; recurring DDs projected forward; insurer-paced pipeline against the loss-adjuster clock for storm-damage work; deposit-and-balance timings for the wedding-supplier book; term-fee timings for the tutors / nurseries; SEND EHCP arrears at 90 days against actual receipt dates; supplier-cost projections for the materials-side. The Q3 trough surfaces in April, not in September.

5. Multi-entity consolidation and per-share allocation, where the business shape demands it

The “farm Ltd + venue Ltd + holiday-let sole-trader + grain-store LLP” moment: the diversified estate has four legal entities, each with their own books for HMRC, but the operator-level question is how are we doing across the family this year. The consolidation is a Sunday at the kitchen table with four sets of papers and a calculator.

Solved looks like: the per-entity records stay correct for tax and audit. The operator-level dashboard rolls up across the entities for the family-level decision view. Same shape for funeral-disbursement reconciliation, equine syndicate-share splits, hospitality multi-site rollups, recruitment temp-desk per-client / per-margin-band views. The decision data is the same data the books are made of; the rollup is the consolidation layer on top.

6. The Sunday-evening “how are we doing” check is nine minutes, not a forensic exercise

The “I should look at the numbers” moment: Sunday evening. You’d look at the numbers but the partner’s the only one who knows where the spreadsheet is, the bookkeeper does the live data on Tuesdays, and you don’t actually know which numbers to look at first. So you don’t look at the numbers. You look at them at year-end.

Solved looks like: the dashboard answers the four questions you actually want to know in the order you want to know them. Is the week’s margin where it should be? Is any project drifting underwater? Is the eighteen-month cashflow at risk? What did the partner / quarter / region do last week? Nine minutes on the dashboard, two follow-up items pencilled on the notepad, the partner-meeting agenda for Monday is set. You go and watch the football.

How the dashboard cadence runs, by default

The default project-based-service cadence runs:

• Project momentquote accepted, project object created. Estimated hours, estimated materials cost, estimated contractor cost, estimated margin, project-type tag.
• Live (as the work runs)time captured against the project (by the foreman, the consultant, the clinician). Materials cost reconciled from the supplier statement. Contractor cost from the sub-payment. Variation orders attached and customer-approved. Snag-list and rework attached. The margin updates live.
• Project closethe variance against estimate calibrates against the project-type tag. Underwater contributing factor (if any) flagged. The next quote in the same shape sees the calibration data.
• Weeklythe dashboard re-aggregates. Margin distribution across active projects; underwater-flag surfacing; the per-vertical mix update; the eighteen-month cashflow projection re-calculated against the live booked-pipeline + invoice state.
• Monthlythe per-vertical mix and per-project-type variance rolls into the partner-meeting view. The eighteen-month cashflow projection surfaces troughs ahead of the partner-meeting decision.
• Quarterly / year-endthe dashboard is the year-end. The accountant works from the same data you’ve been looking at all year; the partner-shrug-and-add-5% conversation is replaced with the actual variance distribution and the actual margin movement.

Per-vertical tuning lives on top - the storm-damage insurance-pipeline cashflow, the wedding-supplier eighteen-month deposit-balance shape, the temp-desk bill-and-pay weekly cycle, the tutors-nurseries term-cycle with SEND EHCP arrears, the agriculture buy-now-vs-buy-later input-cost projection, the diversified-estate multi-entity rollup.

Who this is for

The shape repeats across every UK SME that takes on projects, jobs, or retainers and ends up with a year-end question about margin.

Commercial-side trades on CIS - commercial sparks, commercial plumbers, commercial-fit-out builders, commercial-contract decorators, construction GCs. The job-cost margin dashboard with the in-van variation log, the contractor labour absorbed against the build, the retention release on the commercial diary, the commercial / domestic margin split visible. Pairs with Multi Channel VAT & CIS Invoicing for the CIS line-level reverse-charge and the supplier-statement reconciliation.

Independent garages - independent garages. Parts-margin reconciliation across ECP / GSF / Andrew Page / MPD wholesaler statements; the £20k of parts margin quietly leaking through the reconciliation gap; the workshop-bay utilisation hours visible alongside.

Consultants and boutique agencies - professional-services consultants, boutique agencies. The per-project profitability dashboard; utilisation × realisation × project margin × retainer health; the quoted £15k for a website, sixty-five hours estimated, actual sixty-five-ish but not sure becoming a one-screen check.

Wedding suppliers - wedding suppliers. The 18-month cashflow forecaster running off the booked-wedding pipeline with the Q3 trough surfaced three months ahead; supplier-cost projections layered alongside; the deposit-balance-lag shape captured per booking.

Tutors and nurseries - tutors and nurseries. The term-cycle cashflow forecaster with the predictable July-August gap surfaced eighteen months out; SEND EHCP 90-day-arrears reality captured against actual receipt dates; on-the-payroll staffing decisions made against the live cashflow projection.

Storm-damage roofers - storm-damage roofers. The insurance-paced cashflow forecasting where work happens immediately but payment lands six-to-twelve weeks later on the loss-adjuster clock; the per-claim margin visible against the eight-week-out cashflow window.

Recruiters - temp desks - recruiters. The temp-cashflow engine; margin built on bill-to-client vs pay-to-temp spread; the bill-weekly-pay-weekly cashflow cycle running tight with the per-temp / per-client / per-margin-band view live.

Clinical practices - dental practices. Per-dentist / per-treatment-type margin distribution; appointment-utilisation vs realisation against the booked diary; the practice-margin shape on top of the operational data the practice-management system already captures.

Agriculture diversified estates - agriculture. Multi-entity P&L consolidation across farm Ltd + venue Ltd + holiday-let sole-trader + grain-store LLP; input-cost cashflow projection (fertiliser, diesel, ag-chem) running off live price feeds with the buy-now-vs-buy-later decision data live on the dashboard.

Same engine; different project-shape; different cashflow rhythm; different variance tags.

The closest thing we’ve already built

pharmaceutical-analytics.com - this is the exact shape the page describes, built for an analytics consultancy. Operational data in, decision dashboard out. Per-client margin distribution, supplier-relationship timelines, partner-view rollup. The clearest single-build reference for any project-based service business that needs the answer rather than the spreadsheet. The same dashboard engine powers the KPI side of the trades-commercial reads and the wedding-supplier eighteen-month book.

HC Electrical - live job-cost margin dashboard on the commercial side. In-van variation log feeding margin live; estimate-vs-actuals variance tagged per project-type so the next quote calibrates; the commercial / domestic margin split visible on one screen. The clearest trade-side reference for any commercial-and-domestic firm that wants the margin shape made measurable. (Named pull-quote + final-£ outcome figures hold behind the permission checklist; see Hc Electrical for the build detail.)

MMI Services - proof we can take over and modernise older internal LOB systems where they exist (legacy claims, legacy ledgers, legacy programme tools). Useful where the dashboard has to layer on top of an existing system of record rather than start from scratch - the legacy data feeds in, the modern decision layer surfaces on top, the daily operator sees the answer in modern form while the back-office data stays in its current home.

The cost-side ingest pairs with Multi Channel VAT & CIS Invoicing for the supplier-statement reconciliation, the CIS line-level treatment, and the multi-entity rollup; the revenue-side ingest pairs with Invoice & Dunning Ladder and Stage Payment & Retention Ledger for the cashflow projection’s invoice-state and retention-release inputs; the recurring-side ingest pairs with Recurring Service Recall for the projected DD and renewal revenue.

Tell us what’s invisible

What project / job / retainer in the last year you’d most like to have known the margin on, in advance rather than at year-end. What variance you suspect but can’t prove. What cashflow trough you survive without quite knowing how. Tell us how you’d want to know - what one screen would change your week - and we’ll come back with a sketch of what we’d build. No demo, no calendar widget. Email reply, scoped sketch, you decide.

FAQ