Expense categories

IRCTC spend report: how to total your train travel from statements

Build an IRCTC spend report from bank or card statements: find the lines, net off refunds, group by trip and total it, with a worked example and a sheet method.

Editorial illustration for IRCTC spend report: how to total your train travel from statements

To build a report of what you spend on train tickets, find the lines on your bank and card statements that belong to railway bookings, put them in one sheet, subtract any refunds that came back, group by trip and total them. Your statement is the evidence; the railway's own booking history only helps you name the trips.

Where do the charges appear?

The description on a statement depends on how you paid, so check your own. A card payment may carry the booking site's name; a UPI or net-banking payment may show a payment gateway's name or a reference. Read three or four lines from a month you know you booked, and write down exactly how each one reads. That wording is your search term.

How do I build the report?

  1. Download statements for the period, for example the full April to March year.
  2. Search each for the wording you noted.
  3. Copy each match into a sheet with date, description and amount.
  4. Add refunds as separate negative lines with their dates.
  5. Tag each line with a trip name, such as Diwali visit.
  6. Total by trip, then in all.

A worked example with invented numbers

DateLineTripAmount (₹)
12 OctTicket, outboundDiwali visit1,420
12 OctTicket, returnDiwali visit1,420
20 OctTicket, extra legDiwali visit960
25 OctRefund, extra legDiwali visit-880

The net cost is 1,420 + 1,420 + 960 - 880 = ₹2,920. The refund was smaller than the charge, so ₹80 stayed with the seller. Why, and whether that is normal, comes from the seller's own terms, not from this article. Your report only needs to show that the gap exists.

Why do refunds change the picture?

If you count only the charges, the trip looks like ₹3,800. Counting the refund gives ₹2,920. Without netting, a cancelled journey inflates the travel category, and your yearly total will not match what you really spent.

Can a tracker build this report for me?

In SpendixAI, you can import statements, add a merchant alias so differently worded railway lines map to one name, put them in a Travel category, and then use the Report builder to filter and group by month or by that merchant. You can download the result as CSV and check it against your own sheet.

How do I separate personal and work trips?

Add a Purpose column with values such as Personal and Work. If a work trip will be repaid by your employer, keep the ticket and the reimbursement claim together, and mark the line as repaid when the money arrives. Your personal total then shows only what you bore yourself. For group bookings, note who the tickets were for, so the amount you paid for others is clear when you ask them to settle.

How do I deal with bookings paid by someone else?

If a relative paid for your ticket, or you paid for theirs, it will not appear on the right statement. Add those rows by hand with a note, such as paid by cousin, repaid in cash. Your report is meant to describe your own spending, so include only what you finally bore.

What should I keep with the report?

  • The booking confirmation or ticket for each trip
  • Any refund message, with its date
  • The statement pages that show each line
  • A note of who the trip was for, if you paid for others

If anything is for work travel that your employer will repay, mark it separately now. That makes the later reimbursement request a matter of filtering, not remembering.

SPENDIXAI JOURNAL

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

Explore your reports