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

# Earnings Report CSV

> Turo Earnings Report CSV format — monthly earnings summaries

# Earnings Report CSV

The Earnings Report CSV provides monthly aggregated earnings data with payment status.

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

## Field Reference

| CSV Column     | DB Column        | Type    | Description                      |
| -------------- | ---------------- | ------- | -------------------------------- |
| Date           | `period_date`    | text    | Month/year of the earning period |
| Vehicle        | `vehicle_id`     | text    | Turo vehicle ID                  |
| Vehicle name   | `vehicle_name`   | text    | Vehicle display name             |
| Gross earnings | `gross_earnings` | numeric | Total gross for the period       |
| Turo fee       | `turo_fee`       | numeric | Turo's platform fee (negative)   |
| Net earnings   | `net_earnings`   | numeric | Gross minus Turo fee             |
| Payment status | `payment_status` | text    | "Paid" or "Pending"              |
| Payment date   | `payment_date`   | text    | Date payment was made (if paid)  |
| Payment method | `payment_method` | text    | e.g., "Direct deposit"           |

## Parsing Rules

1. **Deduplication** uses a composite key of `(user_id, date, vehicle_id, amount, row_index)`
2. **Currency values** are plain numbers without `$` signs
3. **Turo fee** is stored as a negative number

## Use Cases

* **Payment reconciliation** — Verify Turo payments match expected amounts
* **Tax reporting** — Monthly earnings summaries for accounting
* **Discrepancy detection** — Compare against trip-level earnings data