← All cases
Case 3
Finance dashboard for a client
A client saw its numbers through accounting reports that arrived two months late. I built the data pipeline, a dashboard and a forecast, then recalculated every figure against the raw files.
Example data. All names and figures in this demo are illustrative.
finance dashboard · demo · example data
Liquidity
How much of the bank balance is really available, and for how many months.
Receivables by age by due date
Open payables by due date gross, no time filter
Effectively available liquidity balance less what is already committed
Performance
Accrued against invoiced revenue, result, costs and billable share.
Revenue per month
Costs per month accounting stacked, expense tool as line
Costs by category example split, ten categories in the original
Service mix hours by type
Projects & segments
Utilisation per person billable ÷ logged hours
Revenue by segment invoiced, year to date
Planning & history
The forecast is built from capacity, not extrapolated. Move a slider and the plan line moves.
Capacity model
Total output: plan against actual 12 months
Result: plan against actual before taxes
Data pipeline
Four sources. Two arrive every night, two monthly or by hand.
Nightly syncApps Script triggers
What the pipeline handles three examples
Data checks
Every tile was recalculated against the raw files. Switch on a finding to see what the dashboard would have shown without the check.
Four findings to try