Changelog

What changed in the dashboard and when.

8 June 2026 — Data refresh to July 2026

Refreshed the universe forward to July 2026 and re-cut every figure on the analytical pages against the new data.
Updated the Veld & Vine story: the account onboarded thin-but-positive in 2024 and crossed underwater around the middle of 2025 as its paid-social spend scaled past the flat service fee — now −R0.86M GP and −16.6% margin over the window, the #3 account by billings. Earlier framing that read it as loss-making in every month no longer holds; the honest picture is an account that grew its way into a loss.
Re-sized Priorities and Scenarios on the refreshed trailing-twelve-month baseline (Aug 2025 – Jul 2026): ~R0.83M/year gross-profit swing on the Veld & Vine decision.

8 June 2026 — Working capital and retainer pricing review

Added the cash-flow cycle: a real payroll/VAT/supplier outflow rhythm, debtor payment patterns (one slowing payer flagged early, one batch payer), and supplier payment segmentation.
Added the director's loan account movements to the working-capital view.
Added a retainer pricing review on Project Economics — the effective bill rate per client, sorted lowest-first, surfacing accounts drifting below the book rate (Highveld Property Group caught early, before the drift compounds).

4 June 2026 — Tier 3 refresh: ad-spend cost layer

Refreshed the universe forward to April 2026 and added the ad-spend (PAID1) cost layer, separating money Spark passes through to Meta and Google from money it earns.
Reworked the findings around the cost layer: What's Quietly Working (retention and the highest-margin work), The Ad-Spend Wedge (Veld & Vine, a top-three account by billings and the largest loss-maker once pass-through is stripped), and Why Your Record Month Wasn't Real (April's step up was largely money in transit).
Rebuilt Priorities and Scenarios around the Veld & Vine reprice/restructure/exit decision and the opportunity to sell more high-margin work.
Refreshed the data gaps and extensions to match (April hours spike, contract terms, pass-through early-warning).

Why it changed: the previous pages counted ad-spend pass-through as revenue, which made a structurally loss-making account look like a flagship. Deducting it as a direct cost of sales is what makes the real economics visible.

17 March 2026 — Initial dashboard build

Connected Xero accounting data: 35 months of financial history (March 2023 – January 2026)
Created 34 metric views covering P&L, revenue concentration, cash position, working capital, and expense analysis
Data sources integrated: Xero (financials), SimplePay (payroll), Toggl (time tracking — annual summary)
Built analytical pages: 4 findings (margin squeeze, client concentration, growth stall, cash and collections), 4 priorities, 3 scenarios
Identified 4 data gaps: monthly Toggl exports, CRM/pipeline, client contracts, bank balance

Limitations:

Toggl data is annual summary only — monthly utilisation trends not yet available
Bank balance not connected (cash snapshot shows null)
December seasonality creates predictable monthly losses that are not smoothed in the views

Back to Methodology