Expense categories

How to build an Uber spend report from your statements, month by month

Build an uber spend report: pull ride charges from statements, group by month and purpose, and read the totals without guessing.

Editorial illustration for How to build an Uber spend report from your statements, month by month

An Uber spend report is a table of your ride charges grouped by month, with a count, a total and an average. You can build one from your statements in about fifteen minutes, and the same method works for any ride service or delivery merchant.

What the report should show

  • Month
  • Number of rides
  • Total spent
  • Average per ride
  • Purpose, if you need it: office, airport, personal

Keep it to these columns. More detail makes the report harder to keep up and harder to read.

Step by step: from statement to table

  1. Download the statements for the months you need, from each card or account you pay with.
  2. Filter or search for the ride merchant's name as it appears on your statement, and watch for odd spellings.
  3. Copy date and amount into a sheet, one ride per row, with a column for the month.
  4. Compare with the seller's own trip history in your account there. Use their page for details such as routes and receipts, and read their terms for refunds.
  5. Summarise by month.

A worked report, with invented figures

MonthRidesTotalAverage
August9₹3,150₹350
September14₹4,620₹330
October11₹4,070₹370
All three34₹11,840about ₹348

Check: 9 + 14 + 11 = 34 rides. 3,150 + 4,620 + 4,070 = ₹11,840. 11,840 ÷ 34 is about 348. September had the most rides but the lowest average, which might mean shorter trips. The report raises that question. It does not answer it.

Can a spreadsheet do the summing for me?

Yes. Suppose dates are in column A, merchants in B, amounts in C, rows 2 to 500, and the month start date is in E1 with the next month start in E2. In Excel or Google Sheets, this adds the ride totals for the month:

  • =SUMIFS($C$2:$C$500, $B$2:$B$500, "*ride*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&$E$2)
  • =COUNTIFS($B$2:$B$500, "*ride*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&$E$2) counts the rides

The asterisks are wildcards, so replace the word ride with the text you see in your merchant column. Dates must be real dates, not text. Divide the sum by the count for the average, and wrap it in IFERROR if a month may have no rides.

When a sheet stops being enough, for example with several cards and twelve months, SpendixAI can import the statements and the Report builder can filter by merchant and group by month, with a CSV download. You still check the rows before saving.

Reading the report

  1. Is the average steady, or does one month stand out?
  2. Do the rides match your calendar: travel weeks, late nights, rain?
  3. Is there any day with two similar charges? Check them against the trip list.
  4. Does the total fit what you thought you spent?

Two small additions make the report more useful. First, add a column for the day of the week, which shows whether most of your rides cluster on weekdays or weekends. Second, note any ride where someone else shared the cost, so you do not mistake a shared fare for a personal one. In a spreadsheet, the weekday can come from =TEXT(A2,"ddd"), which gives Mon, Tue and so on, and a pivot table can then count rides by weekday. Keep the notes short. The aim is a report you will still update in six months, not a perfect one you abandon after one.

Run the report quarterly. Three months is enough to see a pattern and short enough to act on it.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports