Exporting cost data to CSV
The Fleet Cost Cockpit can export the current cost summary as a CSV file so you can analyse it in a spreadsheet, share it with finance, or archive it. This article explains exactly what the export contains and how to use it.
What the export produces
The export renders the cost summary for the dimension and period you have selected into a single CSV file. It contains one row for every bucket-and-category combination, followed by a total row. The columns are:
| Column | Contents |
|---|---|
| Dimension | The dimension the summary was grouped by (fleet, vehicle, pool, costcenter or driver). |
| BucketKey | The stable key of the bucket — e.g. a vehicle id, a cost-center code, or unassigned. |
| BucketLabel | The human-readable label — e.g. a licence plate, cost-center name or driver name. |
| Category | The cost category: fuel, maintenance, damage, fines, insurance, leasing, or belege:<type>. |
| Amount | The amount for that bucket and category. |
The final line is a grand-total row in the form TOTAL,,,,<amount>, giving the sum across every bucket and category so the file reconciles to the cockpit's headline figure.
The file name
The download is named for the dimension and the export date, for example fleet-cost-costcenter-20260706.csv. Because the date stamp is part of the name, repeated exports don't overwrite each other and stay easy to sort chronologically.
Note: The export mirrors the summary, so it always reflects the same dimension and period filters that are active on screen. Set your dimension and date range first, then export.
How to export
- Open the Fleet Cost Cockpit and choose the dimension you want (for example Cost center or Vehicle).
- Set the period. If you leave the dates unset, the export covers the current year to date, matching the default cockpit view.
- Trigger the export. The file downloads as a CSV.
Working with the file
- Because each row is one bucket-and-category pair, a pivot table over BucketLabel and Category rebuilds the on-screen breakdown instantly.
- The TOTAL row is a footer, not a data row — exclude it before pivoting or summing to avoid double-counting.
- Amounts use the platform's standard export number formatting; check your spreadsheet's locale on import if figures look off.
Tip: To build a cost-per-kilometre report, export the Vehicle dimension and add a distance column from your odometer readings in the spreadsheet. The BucketLabel (licence plate) lets you match rows to vehicles.
Who can export
Exporting requires the dedicated fleetcost:export permission ("Export fleet cost reports"), which is separate from the fleetcost:view permission used to see the cockpit. A user can therefore be allowed to view costs on screen but not to download them. Both are typically granted to the FleetManager role and are enforced through [RequirePermission].
Warning: Exported cost files contain detailed financial data across cost centers, vehicles and drivers. Grant the export permission deliberately and handle downloaded files in line with your data-protection policy.
Related
- What the Fleet Cost Cockpit shows
- Analyzing costs by cost center
- Comparing vehicles by cost
- Interpreting the cost KPIs
