Fleet costs.
Seven years of fuel, repair, insurance and tax invoices, exported from the invoicing system, became a dashboard that says what each boat and each vehicle costs and how much of each site’s revenue that takes.
- 16exports from the invoicing system read automatically
- 1,853cost lines, across 86 sheets, none copied by hand
- 7years compared, 2020 to 2026, per unit and category
- 15units: 5 boats and 10 vehicles, assigned to each site
- 58gaps identified, with severity and status
- 14conclusions generated automatically from the filters
Starting point
Fleet costs lived in dozens of exports from the invoicing system, one per unit and per year, each with its own sheets. Nobody knew for sure what a boat cost per year, or what share of each site’s revenue went to fuel and repairs. Every question from the partners was an afternoon in a spreadsheet, and the answer was stale the following month.
What we built
A dashboard that reads the exports as they come out of the system, with no rework, and crosses costs with revenue per site: filters by type, unit, company, years, category and supplier; evolution by year and category; a pivot table in totals or monthly average; the weight of costs in each site’s revenue, with the boats and vehicles assigned to each.
Because the data is never complete, the dashboard says so: a unit × year coverage map shows which exports are missing, and a list of gaps with severity and status tracks what is still to confirm with the accountants. Key conclusions are generated from the active filters, flagged as alert or attention, ready to copy. For the partners’ meeting, it also produced a 12-slide executive summary and a 64-second video.
What changed
The partners’ meeting now has numbers instead of impressions: fuel and repairs are nine out of every ten euros of cost, and the weight on revenue is rising at one of the sites. Gaps went from unknown to a list, to be resolved with the accountant. The dashboard lives inside the company’s analytics tool, owner-only, and updates with every new export.