Earnings Report CSV
The Earnings Report CSV provides monthly aggregated earnings data with payment status.Download a sample file: earnings-report-sample.csv
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
- Deduplication uses a composite key of
(user_id, date, vehicle_id, amount, row_index) - Currency values are plain numbers without
$signs - 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