Data Import

Upload Fleet Data

Import your fuel supplier records and telematics data. Download the template for each, fill in your data, and upload to get started.

💡

Before uploading: Make sure your assets are added in the Assets page first. Download the template to get one row per asset with asset_id and asset_name pre-filled — duplicate rows for each date. Dates should be in YYYY-MM-DD format (e.g. 2026-06-01).

⛽ Fuel Data

Fuel Supplier Records

Import fuel delivery data from your fuel card or supplier invoices. One row per fuel delivery event.

📧

Data is imported automatically via your upload email address. Go to Integrations to view your address and setup instructions.

📡 Telematics Data

Telematics Records

Import engine hours and operating data from your telematics provider. One row per asset per day.

📧

Data is imported automatically via your upload email address. Go to Integrations to view your address and setup instructions.

🚛 Truck Fleet

Truck Fuel Purchases & Mileage

Import BP fuel purchase and eROAD mileage data for on-road vehicles. Excel file with Fuel Purchases and Eroad Mileage sheets.

🔌

Automatic: Truck data flows in once your BP Fleet Card and eRoad reports have been received. Find your upload address in Integrations →

BP Fleet Card reports

Fuel purchases are imported once your BP Fleet Card report has been received.

Checking...

eRoad reports

Mileage readings are imported once your eRoad report has been received.

Checking...

📧

Tier 2 — Automatic (Email CSV)

Send your CSV reports to your upload email address.

BP Fleet Card transaction CSV → automatically imported to fuel_purchases

eRoad mileage CSV → automatically imported to eroad_mileage

Upload email address

Or upload manually →

Column reference

⛽

Fuel Template Columns

asset_id · asset_name · record_date · litres · cost_per_litre · total_cost · supplier

📡

Telematics Template Columns

asset_id · asset_name · record_date · total_engine_hours · operating_hours · idle_hours · odometer_km

📅

Date Format

All dates must use the format YYYY-MM-DD. Example: 2026-06-15. Duplicate a row for each date — do not change asset_name or vehicle_name.

🚛

Truck Template Sheets

Fuel Purchases: vehicle_name · purchase_date · litres · cost_nzd · source
Eroad Mileage: vehicle_name · reading_date · odometer_km · source