> ## Documentation Index
> Fetch the complete documentation index at: https://dhanurgo.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

<Note>
  Download a sample file: [trip-earnings-sample.csv](/samples/trip-earnings-sample.csv)
</Note>

## 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

<Warning>
  **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.
</Warning>

<Warning>
  **Trip days field can be inaccurate.** Use `trip_start` and `trip_end` timestamps for actual duration calculations.
</Warning>