Report Types

1) Master Report

When generating the report, the department travel manager may choose how to sort the data.  The options for sorting are by passenger name, by credit card number, or by the Southwest Airlines ticket number.

Master Air Report

The Master Air Report contains the following information for each reservation made using the appropriate Company Identification (CID):

  • Transaction Date (Date the reservation was made)
  • Internal Reference Number (Number assigned internally by the department travel manager to record department expenditures)
  • Passenger Name (Name of the company/department employee who is the passenger)
  • Credit Card Number (The last five digits will be masked for security reasons)
  • Record locator number (PNR number)
  • Ticket Number (Number assigned by Southwest Airlines identifying the "ticket")
  • Base Fare (Base amount of the ticket)
  • Taxes (Amount includes US tax and segment fees combined)
  • PFC Amount (Passenger Facility Charges)
  • Total Ticket Amount (Base fare plus taxes plus PFCs)
  • Exchange Amount (Amount of ticketless funds used)
  • CC Amount (Amount charged to the credit card)
  • Ticket Type (Initial booking, refund, change, exchange, upgrade, initial with exchanged funds, and Cancelled)
  • Company ID (Number assigned to Company to access SWABIZ)

2) Monthly Travel Spend Report

The Monthly Travel Spend Report contains monthly travel data for all reservations made using a CID for any given company.  The Monthly Report provides the following information:

Air Report

  • Month (Identifies the month to which the data applies)
  • Segments (Total number of one-way segments booked for the month)
  • Gross Ticket Cost (Total of base fare, taxes, PFC's, security fee, transfers, and exchanges)
  • Net Ticket Cost (Total of gross ticket cost less refunds)
  • Total Amount Charged (Actual charges to credit cards for the given month)
  • Average Base Fare (Base fare, plus upgrades, minus refunds, divided by segments)
  • Average One Way Cost (Base fare, divided by segments)

3) Origination & Destination (O&D) Summary Report

The O&D Summary report shows the city pairs traveled to during a specified time period.  When generating the report, the department travel manager may choose how to sort the data by market pair, number of segments, total base fare or average base fare. It contains the following information:

  • Order (Rank of sorting options)
  • Market Pair (City pairs booked)
  • Segments (Total number of one-way segments booked, including exchanges)
  • Percentage of Total Segments (Percent of segments of specific city pair to all city pair segments)
  • Total Base Fare (Total of base fare only, including exchanges)
  • Percentage of Total Spent (Percent of total base fare spent)
  • Average Base Fare (Base fare only, divided by segments)