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.

🔌

Tier 1 — Automatic (Integration): Truck data flows automatically once your BP Fleet Card and eRoad integrations are connected. Connect in Integrations →

BP Fleet Card integration

Fuel purchases sync automatically when connected.

Checking...

eRoad integration

Mileage readings sync automatically when connected.

Checking...

📧

Tier 2 — Automatic (Email CSV)

No integration yet? Send your CSV reports to your upload email address instead.

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