Expense categories

How to build a MakeMyTrip spend report from your own statements

Pull every MakeMyTrip charge off your bank and card statements into one trip-wise spend report, with a worked example and a proof checklist.

Editorial illustration for How to build a MakeMyTrip spend report from your own statements

A MakeMyTrip spend report is simply every charge from that booking platform, collected from your own bank and card statements, tagged by trip and totalled. You do not need anything from the company to start: your statements already hold the date, amount and account for each payment. The steps below turn those lines into a report you can read in five minutes.

What goes into a travel booking spend report?

Think of one row per payment, not one row per trip. Flights, hotels, cabs and add-ons are often paid separately, sometimes on different cards. Each row needs five things: the date on your statement, the amount, the account or card used, the trip it belongs to, and a note on what it paid for.

  • Date and amount exactly as printed on the statement
  • Account or card, because a trip can be split between a credit card and UPI
  • Trip name, such as Goa December or Mother's Delhi visit
  • Type: flight, stay, cab, insurance, convenience fee
  • Booking reference, copied from the confirmation email, so the row can be matched later

How do I find the charges on my statements?

  1. Download the last three to six months of statements for every account and card you use for travel, as PDF, CSV or Excel.
  2. Search each file for the seller's name as it appears on your statement. The wording can differ from the brand name, so also try the first few letters and any payment gateway name that sits beside it.
  3. Copy each match into one sheet with the five columns above.
  4. Open the confirmation emails for the same dates and write the booking reference next to each row.
  5. Anything you cannot match goes into a separate list called unmatched, to be checked later.

Check the seller's own account page or help page for how bookings are listed there, and compare it with what your statement shows. Their terms and menus are theirs to describe; your statement is the record that your money actually left.

A worked example with made-up numbers

Say you took a four-day trip in December and paid in three ways. The figures below are invented only to show the arithmetic.

DateWhat it paid forAccountAmount (₹)
03 NovFlights, two peopleCredit card14,200
03 NovHotel, three nightsCredit card9,600
09 DecAirport cabUPI1,150
10 DecTravel insuranceDebit card640

Total: 14,200 + 9,600 + 1,150 + 640 = ₹25,590. Per person that is 25,590 divided by 2, which is ₹12,795. Notice that the cab and insurance rows might never show the platform's name at all, which is why matching by confirmation email matters more than searching by name.

Why is the total on my report different from the booking total?

Four usual reasons: a part-payment through a wallet or voucher that never touched your card, a refund that arrived weeks later as a separate credit, a currency conversion on a foreign booking, or a charge that appears twice because of a retry. Record refunds as negative rows against the same trip so the net figure is honest.

Can SpendixAI build this for me?

If you would rather not copy rows by hand, SpendixAI lets you upload the statement as PDF, CSV or Excel, review the rows before saving, and keep each transaction with its account. You can set your own rule so that rows from the travel platform go to a Travel category, then use the Report builder to filter and group, and download the result as CSV. Reading the statement still depends on its layout, so review the rows rather than assuming every line parsed.

A short checklist for the next trip

  • Create the trip name before you book, and use it in every row
  • Pay for one trip from as few accounts as you can
  • Save the confirmation email the same day
  • Check your statement within a week for charges you did not expect
  • Note refunds as soon as you see them, with the original booking reference
SPENDIXAI JOURNAL

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

Explore your reports