Download Transactional Data
¶ Introduction
By connecting to SFTP, you can access your organization’s Uber transaction data in bulk. Trip and fare data is exported into a CSV file and available through SFTP in the directory from_uber/trips.
¶ Summary
Allow one full day to pass before retrieving your trip data from from_uber/trips from the day you create your account. Files will be ready daily at 7AM PDT/PST.
These transactions will include trip fares as well as any adjustments that have been made.
Folder: from_uber/trips
Filename: daily_trips-YYYY_MM_DD.csv
Available: 7AM PDT/PST Daily
Start time bound: The start time of all the transactions fetched in the daily file is 00:00 of every day in PDT/PST
End time bound: The end time of all the transactions fetched in the daily file is 24:00 of every day in PDT/PST
There would also be a monthly statement pdf and monthly statement csv generated on the 1st 10pm PDT/PST every month.
Folder: from_uber/trips/monthly
Filename: monthly_statement-YYYY_MM.csv
Filename: monthly_statement-YYYY_MM.pdf
Available: 10PM PDT/PST 1st of month
Start time bound: The start time of all the transactions fetched in the monthly file is the 1st day 00:00 of every month in UTC
End time bound: The end time of all the transactions fetched in the monthly file is the last day 24:00 of every month in UTC
¶ Available Data
The columns of the csv will include:
- Trip/Eats ID
- Transaction Timestamp (UTC)
- Request Date (UTC)
- Request Time (UTC)
- Request Date (Local)
- Request Time (Local)
- Drop-off Date (UTC)
- Drop-off Time (UTC)
- Drop-off Date (Local)
- Drop-off Time (Local)
- Request Timezone Offset from UTC
- First Name
- Last Name
- Employee ID
- Service
- City
- Distance (mi)
- Duration (min)
- Pickup Address
- Drop-off Address
- Expense Code
- Expense Memo
- Invoices
- Program
- Group
- Payment Method
- Transaction Type
- Fare in Local Currency (excl. Taxes)
- Taxes in Local Currency
- Tip in Local Currency
- Transaction Amount in Local Currency (incl. Taxes)
- Local Currency Code
- Fare in Home Currency (excl. Taxes)
- Taxes in Home Currency
- Tip in Home Currency
- Transaction Amount in Home Currency (incl. Taxes)
- Estimated Service and Technology Fee (incl. Taxes, if any) in Home Currency