Real-Time Leadership Dashboard Replaced 3 Days of Manual Reporting With Live Project Visibility

The Challenge

The managing director of a mid-sized engineering consultancy was making resourcing, pricing, and investment decisions based largely on instinct — not because he didn’t want data, but because getting it was painfully slow.

• Reporting took 2–3 days to assemble. The finance manager manually pulled figures from Xero, cross-referenced project hours from the project management tool, and reconciled against a shared pipeline spreadsheet. By the time the numbers were ready, the decisions they were supposed to inform had already been made.
• The sales pipeline lived in a shared Google Sheet that project managers updated when they remembered to. There was no single source of truth on which opportunities were active, what stage they were at, or what the weighted pipeline value looked like at any given moment.
• Project margins were invisible until weeks after job completion. Actual hours and costs were only reconciled against quoted amounts during the monthly bookkeeping cycle — meaning margin blowouts were discovered long after any intervention was possible.
• Cash flow was tracked in a separate Excel workbook, updated fortnightly by the finance manager. The managing director had no real-time view of runway and was making cash allocation decisions on memory and instinct.
• Monthly “board-style” reporting consumed 6–8 hours of the finance manager’s time each month, pulling from three disconnected systems and manually formatting into a slide deck that was outdated by the time it was presented.
• Forecasting didn’t exist in any structured form. The managing director estimated upcoming revenue and costs mentally — often in the car between client sites — with no model to stress-test assumptions against.

Our Approach

Rather than jumping straight to a dashboard tool, we started with a process audit to understand what data existed, where it lived, who owned it, and what was actually missing.

• Mapped the full data landscape across Xero, the project management system, and the pipeline spreadsheet. Identified ownership gaps (no one owned pipeline accuracy), update frequency mismatches (finance was monthly, projects were ad-hoc), and three fields that were being manually duplicated across systems.
• Standardised the pipeline process — moved from a freeform Google Sheet to a structured pipeline view with defined stages, mandatory fields, and clear ownership. This wasn’t a new CRM purchase; it was cleaning up and formalising what already existed.
• Built automated data feeds from Xero (financials and invoicing), the project management tool (hours, milestones, resource allocation), and the restructured pipeline into a single data layer. Feeds run on a scheduled basis so the dashboard reflects data no older than the current business day.
• Designed three decision-making views based on what the managing director actually needed to act on: (1) pipeline health — weighted value, stage distribution, and conversion trends; (2) live project margin tracking — actual hours and costs vs. quoted, updated as timesheets are submitted; (3) cash flow with a 13-week rolling forecast based on committed pipeline, invoicing schedule, and known fixed costs.
• Added automated margin slippage alerts — when a project’s actual hours exceed the quoted amount by more than 15%, the managing director and project manager both receive a notification. This moved margin management from a post-mortem exercise to an early intervention opportunity.

The Results

Within the first month of go-live, the managing director went from spending the first half of every Monday chasing numbers to opening a single dashboard over coffee. The 6–8 hour monthly reporting exercise was eliminated entirely — the finance manager now spends that time on analysis rather than assembly.

More importantly, the margin slippage alerts caught six projects in the first quarter where actual hours were tracking ahead of quoted — three of which were adjusted mid-project by renegotiating scope, recovering an estimated $47K in margin that would have been silently lost.

The 13-week cash flow forecast gave the business its first structured view of runway, replacing the mental arithmetic that had previously guided hiring and equipment purchase decisions.