The Travel Spend Report in Routespring gives you a detailed breakdown of all travel expenses across flights, hotels, and car rentals. This report helps finance teams, travel managers, and administrators understand spend patterns, policy compliance, savings, traveler behavior, and credit utilization.
This article explains every column in the report so you can interpret the data with confidence.
Each row in the report represents a single booking (flight, hotel, or car). The columns provide financial, operational, and traveler-level details.
Below is the full list of columns and what they mean.
| Column Name | Explanation |
| Advance Booking Days | The number days between booking date and travel start date |
| Airline Credit Amount Issued | Amount of airline credit issued on flight cancellation |
| Airline Credit Amount Used | Amount of airline credit used for this booking |
| Airline Credit Number Issued | MCO or Ticket Number of the credit issued under this booking event |
| Airline Credit Number Used | MCO or Ticket Number of the credit used under this booking event |
| Airline Credit Type Issued | Unused Ticket or MCO |
| Airline Credit Type Used | Unused Ticket or MCO |
| Approved By | Email address of the user who approved the travel request |
| Booked By | Name of the user who booked the travel |
| Booking Confirmation Number | Confirmation number of the travel booking |
| Booking Date | Date of "posting" the "booking transaction" |
| Booking fee | Routespring fee associated for the travel booking |
| Booking Session ID | Routespring session ID associated with the travel booking |
| Booking Status | 1. Cancelled = if booking is cancelled 2. Voided if booking option is voided 3. Booked = if the booking event has only "booking transaction" 4. Modified = if any transaction is "posted" in addition to "booking transaction" |
| Booking Type | The type of travel booking made: car rental, flight, hotel, or train. |
| Carry-on Baggage | Sum of all amounts with "Carry-on Baggage" line item under that booking "event" |
| Checked Baggage | Sum of all amounts with "Checked Baggage" line item under that booking "event" |
| Class Of Service | Class of service of the travel booked |
| Commissionable Rate | Explains if the booked fare is commissionable or not |
| Company Payment Method | Payment method if company paid for any portion of the travel fare |
| Custom Field: <name 1> | Value of the custom field selected at the time of booking |
| Custom Field: <name 2> | Value of the custom field selected at the time of booking |
| Custom Field: <name 3> | Value of the custom field selected at the time of booking |
| Department | The department of the traveler |
| Destination | Travel destination |
| Employee Id | Employee ID of the traveler |
| End Date | Travel end date |
| Entity Name | Name of the entity of the traveler |
| Event Name | The name of the Event, if the booking is related to any Event configured in the system |
| Incidentals | Sum of all amounts with "Incidentals" line item under that booking "event" |
| Last Modification Date | Latest date of "posting" any transaction under that booking's "event" |
| Merchant Group | - no change - |
| Merchant Name | The name of the merchant for the travel booked |
| Merchant Receipt | Receipt received from the merchant will be attached when applicable |
| Miscellaneous | Sum of all amounts with "Miscellaneous" line item under that booking "event" |
| Modification Note | Any notes to explain the booking modification |
| Modification Type | The type of modification made to the booking |
| Modified Base Price | Base Price under the latest "Booking Modification" transaction |
| Modified By | Name of the user who modified the booking |
| Modified End Date | End Date under the latest "Booking Modification" transaction |
| Modified Merchant Taxes & Fees | Merchant Taxes & Fees under the latest "Booking Modification" transaction |
| Modified Start Date | Start Date under the latest "Booking Modification" transaction |
| Modified Total Amount | Sum of Modified Base Price + Modified Merchant Taxes & Fees |
| Number Of Travelers | The number of travelers booked in that itinerary |
| Original Base Price | Base Price under the "booking transaction". Note: in case of flight, this is flight ticket base price (without considering any airline credit applied) |
| Original Merchant Taxes & Fees | Merchant Taxes & Fees under the "booking transaction". Note: in case of flight, this is flight ticket taxes & fees (without considering any airline credit applied) |
| Original Total Amount | Sum of Original Base Price + Original Merchant Taxes & Fees |
| Total Amount | Sum of all individual transaction amounts for that booking |
| Outgoing Arrival Airport | Outgoing Arrival Airport for flight booking |
| Outgoing Arrival Date | Outgoing Arrival Date for flight booking |
| Outgoing Arrival Flight Number | Outgoing Arrival Flight Number for flight booking |
| Paid by Company | Sum of all amounts paid by the company |
| Paid by User | Sum of all amounts paid by the user |
| Payment Processing Fee | Routespring's payment processing fee when applicable |
| Policy Status | Whether the travel policy was violated or not (Yes/No) |
| Policy Violation Details | Explanation of policy violation |
| Rate Type | Whether the booked rate was regular rate or a corporate rate |
| Refund Amount | Sum of all amounts with "Refund" line item under that booking "event" |
| Returning Departure Airport | Returning Departure Airport for flight booking |
| Returning Departure Date | Returning Departure Date for flight booking |
| Returning Departure Flight Number | Returning Departure Flight Number for flight booking |
| Routespring ID | This is an unque Routespring ID associated with the booking |
| Seat Purchase | Sum of all amounts with "Seat Purchase" line item under that booking "event" |
| Start Date | Travel start date |
| Supplier | Routespring's supplier used for that travel booking |
| Ticket Number | Ticket number for flight booking |
| Travel Duration (Days) | Number of days between travel start and end date |
| Travel Purpose | Travel purpose note added by the user at the time of booking |
| Traveler Name | Name of the traveler |
| User Payment Method | Payment method if user paid for any portion of the travel booking |