Reconciling Airline Tickets

Pages Used to Reconcile Airline Tickets

Page Name	Definition Name	Usage
Airline Tickets Page	EX_AIRLINE_TICKETS	Query and update airline ticket data that was loaded from an external source.
Expenses with Airfare Page	EX_SHEET_TKT_LINES	Reconcile airline tickets to expense report IDs.

Understanding Airline Ticket Reconciliation

PeopleSoft Expenses enables you to track unused airline tickets and control travel expenses by reconciling completed airline flight segments with purchased tickets.

Common Elements Used to Reconcile Airline Tickets

Field or Control	Description
Status	Values are: Cancelled: The ticket was voided. Not Reconciled: The ticket is waiting to be reconciled with an expense report. Reconciled: The ticket was reconciled with an associated expense report.
Sort By	Select a criterion to sort by: Employee ID (default), Employee Name, Merchant, Reconciliation Status, Ticket Amount, Ticket Number, or Transaction Date.
Sort Order	Select to sort the airline tickets in ascending or descending order.

Airline Tickets Page

Use the Airline Tickets page (EX_AIRLINE_TICKETS) to query and update airline ticket data that was loaded from an external source.

Navigation:

Travel and Expenses, and then Manage Accounting, and then Reconcile Airline Tickets

Expenses with Airfare Page

Use the Expenses with Airfare page (EX_SHEET_TKT_LINES) to reconcile airline tickets to expense report IDs.

Navigation:

Select the Expenses with Airfare tab on the Airline Tickets page.

Note:

The Expenses with Airfare page lists airline tickets that are applied to an expense report but are not in the EX_AIRLINE_TKT table that stores airline data from a direct feed. Most likely, these tickets were entered manually into the expense system.

Field or Control	Description
Report ID	Click to access the Create Expense Report page and view the line items of the expense report that is associated with the airline ticket.