You’ll learn why weekly totals in «Uber» & MyTaxiCRM are often different, and how to make them match when needed. In short:
⚠️ Due to these two choices of design and periodic adjustments at the fleet level, the total amounts will differ unless you align the time window and decide whether to include tips.
Do not compare the calendar week in MyTaxiCRM with Uber's default weekly summary. Uber's week includes 3~4 hours of the morning shifts preceding it.
Decide what you want to compare:
If a tiny difference remains (for example, as little as 0.15 in local currency), check for fleet-level adjustments in Uber without a Trip ID; as those do not belong to any driver and therefore do not appear in MyTaxiCRM driver totals.
Uber’s weekly total usually includes tips.
Sometimes Uber adds an adjustment that does not belong to any specific trip (and is not driver-level). In exports these lines:
Trip ID,Such adjustments do not affect any drivers' totals in MyTaxiCRM, so they can cause very small residual differences if you include them on the Uber side when comparing to driver-based MyTaxiCRM totals.
1st Goal – to match Uber’s weekly total (as shown in Uber's «Payments»).
2nd Goal — to match MyTaxiCRM’s weekly total (in a calendar week, tips excluded).
.csv-file..CSV-fileIn the .csv-file, filter transactions to time ≥ Monday at the cut-off (~03:00/04:00 local time) and time < next Monday at the same cut-off point.
Sum the Earnings / Your Earnings column for the filtered rows.
Using the same .csv-file, filter transactions to the end of a calendar week: Monday 00:00 → Sunday 23:59:59 (local time).
Sum up the Earnings / Your Earnings for these rows → this is calendar-week earnings including tips.
Sum Tips for the very same calendar-week filter.
Calculate according to the formula below 👇
Calendar Earnings Excluding Tips = (Calendar Earnings Including Tips) - (Tips)
👉 This figure should match your MyTaxiCRM Weekly Total for Uber (same week, same timezone).
.csv-file, look for rows without Trip ID whose description indicates a fleet-level adjustments (such as «adjustment for invoices tax», «support adjustment» etc.).In the same Payments Transactions .csv-file → filter by Driver (Name and/or ID).
Pay-week view in Uber:
Timezones: use the same local timezone in both systems. Uber’s cut-off message at the top of «Payments» («Week runs from 3 AM/4 AM») is local to the organization.
Column names: Uber's exports can label the payout column «Earnings», «Your earnings», or similar. Use the column that represents net payout component for that line item. Use «Tips» for gratuities.
Cancellations & zero-fare lines: treat them consistently on both sides. If Uber’s .csv-report includes a zero-fare cancellation with a fee – you need to include it into both filters; if you exclude such rows in one place – exclude them everywhere else.
Rounding: expect 0.01~0.05 rounding noise (differences) if you compare on-screen rounded figures to totals in .csv-report. Always reconcile from the .csv-file.
Tips in MyTaxiCRM: tips are shown in «Statements» per service. If your current report widget does not include tips as a column, add back the weekly tips from «Statements» when you want an «Uber-style» figure that includes them.
Exports:
.csv-file for (week -1 day) → (week +1 day).Build two views from the same Uber's .csv-file:
SUM(Earnings).SUM(Earnings) − SUM(Tips).Compare:
If a total still off by a small margin (few cents or other currency):
Trip ID that are clearly fleet-level adjustments ( like «adjustment for invoices tax», «support adjustment», «payout …» etc.).Document:
Can I ask Uber to show a pure calendar week?
.csv-file to create a calendar-week view if needed.Why do MyTaxiCRM totals exclude tips by default?
Should I ever include fleet-level adjustments when comparing to MyTaxiCRM?
Trip ID is not present).