Check your Turo earnings file before you trust it

Before you build a report, a spreadsheet or an import on top of your Turo trip earnings file, it is worth five minutes to check that it says what you think it says. Most problems show up in the first few checks.
This is general information, not tax or accounting advice. The checks below only add up and compare what the file says. They do not classify anything.
1. Count the trips
Open the file and count the rows, or look at the row count in your spreadsheet. Compare it with the trips you remember for that period. A file that is far off can mean the wrong date range, or that you downloaded a different export.
2. Look for repeated reservations
Each trip has a reservation ID. If the same ID appears on two rows, you may be counting one trip twice. This happens when you download overlapping date ranges and paste them together. Decide which row to keep, and keep only one.
3. Check the total
Add up the column with the total earnings and compare it with what you remember being paid. If you add it up by hand, remember that the total is the sum of that column as written, including cancelled or incomplete trips that may show zero.
4. Look at earnings per car
Group the rows by vehicle. A car with many trips and little income, or a car you thought you had stopped renting, is worth a second look before you move on.
5. Read the status column as it is written
The status column says what Turo wrote for each trip. Do not guess what a status means for your books. List the values you see, count how many rows each one has, and ask your accountant how to treat each one in your situation.
Two habits that avoid trouble
- Do not re-save the file from a spreadsheet before you use it. Opening and saving a CSV can change date formats and numbers, and you will not notice until a total is off. Work on a copy.
- Keep the original download. If a number looks wrong later, you can always go back to what Turo gave you.
Do the checks in seconds
We built a free tool that does checks 1 to 5 for you: the Turo CSV checker. You pick your trip earnings file and it shows the trip count, the repeated reservations, the sum of the earnings column, a table by car and the status values as written. It reads English or Spanish files. The file is read in your browser and is never uploaded.
If you want to know how each column of the export is read, see how to read your Turo earnings export.
When you want to keep the data
The checker adds up a file and then forgets it. FleetWise reads your Turo files, records each trip once, and shows profit per car with your expenses. It does not ask for your Turo password and does not use a browser extension: you forward your Turo emails or upload your CSV files. The Free plan covers up to 3 cars.
FleetWise brings your Turo earnings, expenses, tolls and direct bookings into one real set of books.
Start your free trial
Comments
Leave a comment
Your name and comment become public after review. Your email is used only to review the comment and is never shown. Please do not include guest names, phone numbers or other private details. By sending, you accept our Terms and Privacy policy.