Ola spending comes straight from your bank and card statements: find every line carrying the ride company's name and add them up month by month. A spreadsheet filter does it in minutes, and an expense tracker can do it for you after one upload. The exact merchant text on your statement is the key, so look at your own lines first.
This article does not describe the company's prices, offers or in-app history screens. It works from your statement, which is the record of what actually left your account, and tells you to check the company's own help page for anything about its receipts.
Step 1: find the ride lines on your statement
- Download three months of statements for every bank account and card you use for rides, as CSV or Excel if possible.
- Search the description column for the merchant name. It may be spelled differently from the brand, or carry extra letters or a payment gateway name, so read the first few lines closely.
- Add a column for category and mark each line as ride.
- Check wallets too. If you top up a wallet and ride from it, the top-up is the line on your statement and the ride itself is not.
Step 2: total them with a formula
Suppose dates are in column A, descriptions in column B and amounts in column C, from row 2 to row 500. Then this formula adds every amount whose description contains the text OLA:
- =SUMIF($B$2:$B$500, "*OLA*", $C$2:$C$500)
- For one month only, with the first of the month in E1 and the first of next month in E2: =SUMIFS($C$2:$C$500, $B$2:$B$500, "*OLA*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&$E$2)
- To count the rides: =COUNTIFS($B$2:$B$500, "*OLA*", $A$2:$A$500, ">="&$E$1, $A$2:$A$500, "<"&$E$2)
These work in Excel and Google Sheets. The asterisks are wildcards. If your statement spells the merchant differently, change the text in quotes to match, and make sure dates are real dates, not text.
What does a monthly report look like?
Say your lines come to ₹3,420 in March, ₹2,980 in April and ₹4,150 in May. The three months total ₹10,550, which is about ₹3,517 a month. Say you took 18 rides in May. Then ₹4,150 divided by 18 is about ₹231 a ride. Those are made-up figures, but the two ratios, per month and per ride, are the ones worth tracking.
| Month | Ride total | Rides | Average per ride |
|---|---|---|---|
| March | ₹3,420 | 15 | ₹228 |
| April | ₹2,980 | 13 | ₹229 |
| May | ₹4,150 | 18 | ₹231 |
Can the same report show other transport?
Yes, and it is more useful that way. Put auto, metro, fuel and FASTag lines into a transport category and compare. If rides climb in months with late office days or heavy rain, you learn something about your routine, not only your wallet.
When a sheet stops being enough
A formula is fine for one merchant. If you want it for every merchant and every month without rebuilding it, SpendixAI lets you upload statements as PDF, CSV or Excel for the account you choose, categorises them with your own rules first, and lets you add a merchant alias so differently spelled lines group together. The Report builder filters and groups by category or merchant and the result can be downloaded as CSV.
A report is only useful if you act on it. Decide what question it should answer: is the monthly figure higher than you expected, are you riding for distances a bus or train would cover, or are a few late-night rides pushing the total up? Pick one, look at the dates and amounts that explain it, and set a rupee figure for next month that you can compare against.
Next steps
- Pull three months of statements today.
- Mark the ride lines and total them.
- Decide a monthly figure you are comfortable with.
- Check your own statement line by line if a total looks high.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


