Trip Earnings CSV

Turo Trip Earnings CSV format — field definitions and parsing rules

Trip Earnings CSV

The Trip Earnings CSV is Turo’s primary data export. Each row represents one trip reservation with detailed earnings breakdown.

Download a sample file: trip-earnings-sample.csv

Field Reference

Identification Fields

CSV Column	DB Column	Type	Description
Reservation ID	reservation_id	text	Unique trip identifier (used for deduplication)
Guest	guest_name	text	Guest’s name
Vehicle	—	text	Used only for license plate extraction
Vehicle name	vehicle_name	text	e.g., “2024 Tesla Model 3”
Vehicle id	vehicle_id	text	Turo’s internal vehicle ID
VIN	vin	text	Vehicle Identification Number

Trip Details

CSV Column	DB Column	Type	Description
Trip start	trip_start	timestamptz	Trip start datetime
Trip end	trip_end	timestamptz	Trip end datetime
Pickup location	pickup_location	text	Pickup address
Return location	return_location	text	Return address
Trip status	trip_status	text	Completed, In Progress, Cancelled, etc.
Check-in odometer	check_in_odometer	integer	Miles at check-in
Check-out odometer	check_out_odometer	integer	Miles at check-out
Distance traveled	distance_traveled	integer	Miles driven
Trip days	trip_days	integer	Duration in days

Pricing & Discounts

CSV Column	DB Column	Type	Description
Trip price	trip_price	numeric	Base rental price
Boost price	boost_price	numeric	Turo boost earnings
3-day discount	three_day_discount	numeric	Negative value
1-week discount	one_week_discount	numeric	Negative value
2-week discount	two_week_discount	numeric	Negative value
3-week discount	three_week_discount	numeric	Negative value
1-month discount	one_month_discount	numeric	Negative value
2-month discount	two_month_discount	numeric	Negative value
3-month discount	three_month_discount	numeric	Negative value
Non-refundable discount	non_refundable_discount	numeric	Negative value
Early bird discount	early_bird_discount	numeric	Negative value
Host promotional credit	host_promotional_credit	numeric	Negative value

Fees & Additions

CSV Column	DB Column	Type	Description
Delivery	delivery	numeric	Delivery fee earned
Excess distance	excess_distance	numeric	Over-mileage charge
Extras	extras	numeric	Add-on items revenue
Cancellation fee	cancellation_fee	numeric	Cancellation charge
Additional usage	additional_usage	numeric	Extra usage charges
Late fee	late_fee	numeric	Late return fee
Improper return fee	improper_return_fee	numeric	Improper return charge
Airport operations fee	airport_operations_fee	numeric	Airport-specific fee
Airport parking credit	airport_parking_credit	numeric	Airport parking offset
Tolls & tickets	tolls_and_tickets	numeric	Toll reimbursement
On-trip EV charging	on_trip_ev_charging	numeric	EV charging during trip
Post-trip EV charging	post_trip_ev_charging	numeric	EV charging after trip
Smoking	smoking	numeric	Smoking violation fee
Cleaning	cleaning	numeric	Cleaning fee
Fines (paid to host)	fines_paid_to_host	numeric	Traffic fines reimbursed
Gas reimbursement	gas_reimbursement	numeric	Gas fill-up reimbursement
Gas fee	gas_fee	numeric	Gas service fee
Other fees	other_fees	numeric	Miscellaneous fees
Sales tax	sales_tax	numeric	Tax amount
Total earnings	total_earnings	numeric	Sum of all revenue items

Parsing Rules

1. Currency values have no $ sign in the CSV — they’re plain numbers like 285.00 or -45.00
2. Discounts are negative — e.g., 1-week discount appears as -45.00
3. Dates are in Turo’s local time format (host’s configured timezone) — stored as UTC timestamptz in the database
4. Deduplication uses (user_id, reservation_id) — re-importing the same CSV updates existing records
5. The Vehicle column contains the license plate in format “Vehicle Name (PLATE)” — this is parsed to extract the plate

Common Pitfalls

Don’t sum trip_price + all fees to verify total_earnings. Turo’s total_earnings is the canonical amount. Individual fields may not add up exactly due to rounding.

Trip days field can be inaccurate. Use trip_start and trip_end timestamps for actual duration calculations.