![](media/image1.wmf){width="2.8854166666666665in"
height="0.4465277777777778in"}![](media/image2.wmf){width="1.7909722222222222in"
height="2.0729166666666665in"}

![](media/image3.wmf){width="3.623611111111111in"
height="2.696527777777778in"}

![](media/image4.wmf){width="1.823611111111111in"
height="2.0819444444444444in"}

FedTraveler.com

Executive Training Series

Online Reports

**Table of Contents**

[Part I Introduction 5](#part-i-introduction)

[Introduction 6](#introduction)

[Gaining Access to Reports 6](#gaining-access-to-reports)

[Part II FedTraveler Reports 7](#part-ii-fedtraveler-reports)

[Accessing FedTraveler Reports 8](#accessing-fedtraveler-reports)

[Administration Log Report 12](#administration-log-report)

[Amount of Travel by Purpose Report
12](#amount-of-travel-by-purpose-report)

[Approval Chain Summary 12](#approval-chain-summary)

[Approved Travel Plan Summary 13](#approved-travel-plan-summary)

[Approved Travel Plans by Approval Date
14](#approved-travel-plans-by-approval-date)

[Average Cost and Duration of Travel Report
14](#average-cost-and-duration-of-travel-report)

[Cancelled Travel Plans 15](#cancelled-travel-plans)

[Completed Expense Report Summary 15](#completed-expense-report-summary)

[Completed Expense Reports by Approval Date
16](#completed-expense-reports-by-approval-date)

[Completed Local Expenses by Approval Date
17](#completed-local-expenses-by-approval-date)

[Cost Center Funds Availability 18](#cost-center-funds-availability)

[Cost Center Spent/Obligated Report
19](#cost-center-spentobligated-report)

[Debt Summary 20](#debt-summary)

[Extended Travel Summary 20](#extended-travel-summary)

[Est. Total Payments By Travel and Transportation Report
21](#est.-total-payments-by-travel-and-transportation-report)

[Job Title Summary 21](#job-title-summary)

[Overdue Travel Advances 21](#overdue-travel-advances)

[Returned Documents Summary 22](#returned-documents-summary)

[Sponsored Travel Report 22](#sponsored-travel-report)

[Travel Documents Not Complete 23](#travel-documents-not-complete)

[Used Document Numbers Report 23](#used-document-numbers-report)

[User Identification Report 24](#user-identification-report)

[Part III Quality Agent Reports 25](#part-iii-quality-agent-reports)

[Accessing Quality Agent Reports 26](#accessing-quality-agent-reports)

[Activity Statement 29](#activity-statement)

[Advanced Destination and Airline Volume Report
30](#advanced-destination-and-airline-volume-report)

[Air-Car-Hotel Detail Summary 31](#air-car-hotel-detail-summary)

[Airline Segment Share Summary 32](#airline-segment-share-summary)

[Car Report 33](#car-report)

[Car Report By City 34](#car-report-by-city)

[Carrier Analysis 35](#carrier-analysis)

[City Pair Analysis 36](#city-pair-analysis)

[Class of Service Summary 38](#class-of-service-summary)

[Cost Center Summary 39](#cost-center-summary)

[Credit Card List 40](#credit-card-list)

[Destination Airport(s) Summary 41](#destination-airports-summary)

[Destination and Airline Volume Report
42](#destination-and-airline-volume-report)

[Detail Reports 43](#detail-reports)

[Domestic / International Summary 44](#domestic-international-summary)

[Duplicate Invoice 45](#duplicate-invoice)

[Exceptions Analysis 46](#exceptions-analysis)

[Exceptions Reports 46](#exceptions-reports)

[Exchanged Tickets 47](#exchanged-tickets)

[Executive Travel Summary 48](#executive-travel-summary)

[Hotel Report 50](#hotel-report)

[International Routing Report 51](#international-routing-report)

[International Routing Report by SI group
52](#international-routing-report-by-si-group)

[Invoice List 53](#invoice-list)

[Negotiated Fares Report 54](#negotiated-fares-report)

[Passenger Location Report 55](#passenger-location-report)

[Passenger Manifest 56](#passenger-manifest)

[Preliminary Exceptions Report 57](#preliminary-exceptions-report)

[Preliminary Hotel Report 58](#preliminary-hotel-report)

[Preliminary International Routing Report
59](#preliminary-international-routing-report)

[Preliminary Transaction Detail Summary
60](#preliminary-transaction-detail-summary)

[Premium Travel Summary 61](#premium-travel-summary)

[QA Profile Report 62](#qa-profile-report)

[QA Request Statistics 63](#qa-request-statistics)

[Sales List 64](#sales-list)

[Savings Summary 65](#savings-summary)

[Service Fees 66](#service-fees)

[Top Hotels By City 67](#top-hotels-by-city)

[Top Travelers Summary 68](#top-travelers-summary)

[Transaction Report 69](#transaction-report)

[Transaction Summary 70](#transaction-summary)

[Travel Policy Exceptions 71](#travel-policy-exceptions)

[Unticketed PNR Report 72](#unticketed-pnr-report)

[Unused Ticket Log 73](#unused-ticket-log)

[Validating Airline Summary 74](#validating-airline-summary)

# Part I Introduction 

### Introduction

This document provides a sample of each of the reports available to
system administrators. The document contains three parts: the
introduction, reports pertaining to travel documents (FedTraveler
Reports), and reports pertaining to the online booking tool (Quality
Agent Reports).

The FedTraveler reports may be accessed from the **Organizer** page by
selecting **Reports** from the menu.

The Quality Agent reports may be accessed from the **Organizer** page by
selecting **Schedules** from the menu, then selecting **Reports** from
the Quality Agent menu.

### 

### Gaining Access to Reports

To access to the online reports you must first sign on to the system.
This will bring you to the Organizer page. You may access both the
FedTraveler reports and the Quality Agent Reports from this page. For
the steps to access FedTraveler reports, see Part II of this document.
For steps to access Quality Agent reports, see Part III of this
document.

![](media/image5.wmf){width="6.0in" height="2.7847222222222223in"}

# Part II FedTraveler Reports 

### Accessing FedTraveler Reports

From the Organizer page select **Reporting** from the menu.

![](media/image6.wmf){width="5.997222222222222in"
height="2.7416666666666667in"}

The Reports screen displays. Select the report that you would like to
run then click on the **Next** menu option on the left of the page.

-   After selecting a report to run, you may opt to have the report
    displayed in an MS Excel viewer. The report may then be saved as an
    Excel Spreadsheet on your local computer. To enable this feature,
    simply click the "**Save as MS Excel Spreadsheet**" checkbox found
    below the reports list.

![](media/image7.wmf){width="4.489583333333333in"
height="2.667361111111111in"}

Reports providing a summary of data will present the following search
criteria options. A brief description of each option appears below. Once
you have specified your preferences, click the **Next** menu option on
the left of the page.

![](media/image8.wmf){width="5.750694444444444in"
height="2.9368055555555554in"}

-   **Search for every XX records** -- This option provides a random
    sampling of data. The system will search for and return records at a
    specified interval represented by XX; for example, "**Search for
    every [5]{.underline} record(s).**"

-   **Search for records with Total Cost** -- Records with a total trip
    cost meeting the criteria you specify here will appear in the
    report. Click on the arrow next to the comparison field, select your
    search parameter (Equal, Greater than, Less than, etc) then enter
    the dollar amount.

-   **Search for records with End Date** -- Records with a trip return
    date meeting the criteria you specify here will appear in the
    report. Click on the arrow next to the comparison field, select your
    search parameter (Equal, Greater than, Less than, etc) then enter
    the date.

-   **Search for records with End Dates between** -- Records with a trip
    return date between the dates you specify will appear in the report.
    Click on the arrows next to each Begin Date parameter (Month, Day,
    and Year) and select the desired option. Repeat for the End Date
    parameter.

The reports listed below all use this type of search feature:

-   Approved Travel Plan Summary

-   Cancelled Travel Plans

-   Completed Expense Report Summary

-   Extended Travel Summary

-   Returned Documents Summary

-   Travel Documents Not Complete

The next screen will allow you to select the fields you would like to
appear in your report. To make a selection click once on the item you
want included in your report. To choose multiple items hold the CTRL key
down as you click on each item.

-   You may sort the report data based on a Sort criteria selection. The
    default sort order is based on Document Number, however, you may
    choose from Begin Travel Date, End Travel Date, Document Status,
    Final Approval Date and Traveler Name among others.

To continue, select the **Next** menu option.

![](media/image9.wmf){width="5.996527777777778in" height="2.88125in"}

Reports based on the document approval date will present a similar
criteria page but will only prompt you for the begin date and end dates
of the report. All records with approval dates falling between the dates
you specify will appear in the report.

To continue, select the **Next** menu option.

![](media/image10.wmf){width="4.079861111111111in"
height="1.6604166666666667in"}

The reports listed below all use this type of search feature:

-   Administration Log Report

-   Amount of Travel by Purpose Report

-   Approved Travel Plans by Approval Date

-   Completed Expense Reports by Approval Date

-   Completed Local Expenses by Approval Date

The reports listed below use slightly different search criteria and are
detailed in the corresponding section later in this chapter:

-   Cost Center Funds Availability

-   Cost Center Spent/Obligated

-   User Identification

All other reports appearing in this document will display directly upon
selecting it from the reports list. A listing of each FedTraveler report
and a sample of that report appear on the following pages.

### Administration Log Report

The Administration Log Report provides information pertaining to any
system administrator initiated changes performed in the system. The
administrator's name, the action performed, the date and time the
administrator made modifications to the system, and a description of the
object affected displays in this report.

![](media/image11.wmf){width="5.993055555555555in"
height="0.9055555555555556in"}

### Amount of Travel by Purpose Report

The Amount of Travel by Purpose Report provides information for each
organization grouped by the Purpose of Trip selected in each Travel
Plan. Data displayed in this report includes the Organization Name, the
Purpose Description, the Total Trips having this purpose and the Total
Cost of the trip.

![](media/image12.wmf){width="6.0in" height="0.6347222222222222in"}

### Approval Chain Summary 

This report displays the hierarchical structure of each approval chain
in an organization. Each document path (Travel Plan and Expense Report)
is displayed individually. Data displayed in this report includes the
Organization Name, the Approval Chain name, the Path Type (Travel Plan
or Expense Report), the Job Titles in each path and the position of the
Job Title in the path.

![](media/image13.wmf){width="5.992361111111111in"
height="2.2472222222222222in"}

### Approved Travel Plan Summary 

This report displays information pertaining to travel authorizations
that have already gone through the final level of approval. Data
displayed in this report is selected by the user and varies according to
the selections made. The sample below displays all available fields.

![](media/image14.wmf){width="5.995833333333334in"
height="3.5416666666666665in"}

### Approved Travel Plans by Approval Date 

This report displays information pertaining to travel authorizations
that have already gone through the final level of approval. Data
contained in this report is grouped by final approval date and contains
the Traveler Name, Vendor Code, Organization, Document Status, Document
Number, Travel Type (Travel Plan, Expense Report, etc), Begin/End Dates
of travel, amount Centrally Billed, Segment Types used (Per Diem Code),
Cost Center, Object Class, Project Code (if applicable), and Allocation
amount.

![](media/image15.wmf){width="5.995833333333334in"
height="3.316666666666667in"}

### Average Cost and Duration of Travel Report

Average Cost and Duration of Travel Report provides information
pertaining to the average cost and duration of all trips for a
particular organization. Data displayed in this report includes the
Organization Name, Total Documents, Total Cost, Average Cost and Average
Duration.

![](media/image16.wmf){width="6.0in" height="0.6347222222222222in"}

### Cancelled Travel Plans 

This report displays a list of all of the Canceled Travel Plans for each
organization contained in the system. Data displayed in this report is
selected by the user and varies according to the selections made. The
sample below displays all available fields.

![](media/image17.wmf){width="5.989583333333333in"
height="3.5416666666666665in"}

### Completed Expense Report Summary 

This report displays information pertaining to expense vouchers that
have already gone through the final level of approval. This is
considered the final stage in the life cycle of the travel document and
identifies any reimbursable amounts due to the traveler. Data displayed
in this report is selected by the user and varies according to the
selections made. The sample below displays all available fields.

![](media/image18.wmf){width="5.992361111111111in"
height="2.8916666666666666in"}

### Completed Expense Reports by Approval Date 

This report displays information pertaining to expense vouchers that
have already gone through the final level of approval. Data contained in
this report is grouped by final approval date.

Data contained in this report is grouped by final approval date and
contains the Traveler Name, Vendor Code, Organization, Document Number,
Travel Type (Travel Plan, Expense Report, etc), Begin/End Dates of
travel, Cost Center, Object Class, Allocation amount, Original Estimated
Amount and the amount Owed Employee.

![](media/image19.wmf){width="5.9944444444444445in"
height="3.6055555555555556in"}

### Completed Local Expenses by Approval Date 

This report displays information pertaining to local vouchers that have
already gone through the final level of approval. Data contained in this
report is grouped by final approval date and contains the Traveler Name,
Vendor Code, Organization, Document Number, Travel Type (Travel Plan,
Expense Report, etc), Approval Date, Cost Center, Object Class and
Allocation amount.

![](media/image20.wmf){width="5.995138888888889in"
height="4.077083333333333in"}

### Cost Center Funds Availability 

This report lists all cost centers in an organization along with the
dollar amounts associated with them. Data elements displayed include the
Organization name, Cost Center, Cost Center Description, the Fund
Certifier job title (if applicable), Appropriation number, Budget Point,
Allowance Code, Initial Allocation, Current Available Funds, Revised
Allocation (if any), the Fiscal Year Range, List Status (Show or Hide)
and the amount Spent/Obligated.

![](media/image21.wmf){width="6.493055555555555in"
height="3.297222222222222in"}

This report uses search criteria slightly different from those
previously mentioned. Once you have selected this report, you are
immediately presented with the field selection list. This differs in
that all the available fields pertain only to cost center data. A
partial list appears in the image below. The sorting options also differ
slightly. They, too, pertain only to cost center data and include such
fields as Cost Center Description, Appropriation Number and Fiscal Year
among others. Lastly, you may limit which Cost Centers will appear in
the report by specifying the Fiscal Year.

![](media/image22.wmf){width="2.8118055555555554in"
height="3.104861111111111in"}

### Cost Center Spent/Obligated Report

This report lists the dollar amounts obligated for approved travel
authorizations or deducted from the cost center for completed travel
vouchers. The report displays information only for the individual cost
center indicated by the user. Data elements displayed include the
Organization name, Document Number, Traveler Name, Job Title (if
applicable), Project Code and Title (if applicable), Begin/End Dates of
travel, Approval Dates for the travel plan and expense report, Document
Status and the amount Spent/Obligated.

![](media/image23.wmf){width="6.5in" height="0.5729166666666666in"}

This report uses search criteria slightly different from those
previously mentioned. In order to run this report, you must select one
specific Organization from the Org. list (may not be "All
Organizations"). If not, you will receive the following error message:

![](media/image24.wmf){width="5.042361111111111in"
height="0.5965277777777778in"}

Once you have selected this report, you are immediately presented with
the Cost Center selection list. Choose the specific Cost Center for
which you will run the report by clicking on the description as
indicated in the image below.

![](media/image25.wmf){width="3.077777777777778in"
height="1.5013888888888889in"}

After selecting the Cost Center, the report will immediately generate
showing the above listed fields for the specific Cost Center chosen.

### Debt Summary 

This report lists the travelers in an organization with outstanding
debts and the amounts due back to the government. Data displayed in this
report contains the Organization name, Document Number, Traveler name,
End Travel Date, Estimated Cost of trip, Actual Cost of trip, any
Advance received by the traveler and the Amount Owed by the traveler
back to the government.

![](media/image26.wmf){width="5.991666666666666in"
height="0.5111111111111111in"}

### Extended Travel Summary 

This report provides details for travel documents where the traveler is
on TDY for 30 or more days. Data displayed in this report is selected by
the user and varies according to the selections made. The sample below
displays all available fields.

![](media/image27.wmf){width="5.9944444444444445in"
height="3.265972222222222in"}

### Est. Total Payments By Travel and Transportation Report

The Est. Total Payments By Travel and Transportation Report provide
information pertaining the total expected Travel and Transportation
costs for a particular organization. Data displayed in this report
includes the Organization Name, Total Travel Cost, and Total
Transportation Cost.

![](media/image28.wmf){width="6.0in" height="0.8534722222222222in"}

### Job Title Summary 

This report lists the approving officials contained within each Job
Title. These Job Titles appear in the Approval Chain Summary report
detailed earlier in this chapter. Data displayed in this report includes
the Organization name, the Job Titles in that organization, and the
Approver Name for each approving official in that job title.

![](media/image29.wmf){width="3.9381944444444446in" height="0.88125in"}

### Overdue Travel Advances 

This report details information pertaining to overdue travel advances
including the status of the document and how long the advance is
outstanding. Data elements in this report include the Organization name,
Document Number, Traveler name, End Travel Date, amount of Advance, the
number of days Past Due and the Status of the travel document.

![](media/image30.wmf){width="5.992361111111111in"
height="0.4548611111111111in"}

### Returned Documents Summary 

This report lists all returned documents in an organization and the data
associated with them. Data displayed in this report is selected by the
user and varies according to the selections made. The sample below
displays all available fields.

![](media/image31.wmf){width="5.993055555555555in"
height="3.651388888888889in"}

### Sponsored Travel Report

The Sponsored Travel Report provides information pertaining to Sponsored
Travel for each traveler. The information included in this report
consists of the traveler's Organization Name, the Travelers Name, the
Total Amount of the trip, the Sponsored Amount, Comments and the Project
Code (if applicable).

![](media/image32.wmf){width="5.997222222222222in"
height="1.9083333333333334in"}

### Travel Documents Not Complete 

This report provides detailed information pertaining to travel documents
that do not have a status of Complete. Data displayed in this report is
selected by the user and varies according to the selections made. The
sample below displays all available fields.

![](media/image33.wmf){width="5.989583333333333in" height="3.6375in"}

### Used Document Numbers Report

The Used Document Numbers Report displays a list of all the document
numbers currently in use by a particular organization. Data displayed in
this report includes the Organization Name, the Creation Date of the
document, the Document Number, the Document Status and the Traveler
name.

![](media/image34.wmf){width="5.9944444444444445in"
height="0.6201388888888889in"}

### User Identification Report 

This report will provide detailed information about users. Data
displayed in this report is selected by the user and varies according to
the selections made. The sample below displays all available fields.

![](media/image35.wmf){width="5.9944444444444445in"
height="2.696527777777778in"}

This report uses search criteria slightly different from those
previously mentioned. Once you have selected this report, you are
immediately presented with the field selection list. This differs in
that all the available fields pertain mainly to user data. A partial
list appears in the image below. The sorting options also differ
slightly. They, too, pertain mainly to user data and include such fields
as Organization, Traveler First Name, Traveler Last Name, Vendor Code
and Security Clearance among others.

![](media/image36.wmf){width="2.9409722222222223in"
height="2.4944444444444445in"}

# Part III Quality Agent Reports 

### Accessing Quality Agent Reports

From the Organizer page select **Schedules** from the menu.

![](media/image37.wmf){width="5.501388888888889in"
height="2.6368055555555556in"}

On the Schedules page select **REPORTS** from the top menu.

![](media/image38.wmf){width="5.502083333333333in"
height="4.441666666666666in"}

On the REPORTS page select **Create New Report**.

![](media/image39.wmf){width="5.496527777777778in"
height="3.482638888888889in"}

Next, select **Request New** from the menu. Select the report that you
would like to run (a brief explanation of the report appears in the
Report Description box). Continue by clicking on **Select**.

![](media/image40.wmf){width="5.490972222222222in" height="3.35625in"}

The next screen will ask you for the **Report Criteria**. The fields
shown below are the standard criteria; however, some reports may vary in
their criteria options. To enter your specifications simply click on the
arrow at the end of each field and make your selection. Those fields
marked by an asterisk are required fields for report generation.

![](media/image41.wmf){width="3.4569444444444444in"
height="4.043055555555555in"}

Once you have made all your selections, click the **Continue** button.

The **Reports Available** page appears displaying a list of the most
recent reports requested. The latest request appears at the top of the
list. Select the report you requested and the method of display you
would like (Adobe Acrobat or MS Excel), then click the **View** button.

![](media/image42.wmf){width="6.497916666666667in"
height="2.4034722222222222in"}

A listing of each Quality Agent report and a sample of that report
appears on the following pages.

### Activity Statement

Shows all accounting activity for a specified date range.

![](media/image43.wmf){width="5.490277777777778in"
height="3.0861111111111112in"}

![](media/image44.wmf){width="5.986111111111111in"
height="2.076388888888889in"}

### Advanced Destination and Airline Volume Report

A summary report of air transactions summarized by carrier and city
pair. Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image45.wmf){width="5.473611111111111in" height="2.41875in"}

![](media/image46.wmf){width="5.323611111111111in"
height="2.6868055555555554in"}

### Air-Car-Hotel Detail Summary

Provides a detailed report on all air, car and hotel activity for an
account or a single passenger for a specified date range (max Date range
: 31 days ). Data is pulled from our live post-ticket data base.

![](media/image47.wmf){width="5.502083333333333in"
height="1.9034722222222222in"}

![](media/image48.wmf){width="6.002083333333333in"
height="3.1444444444444444in"}

### Airline Segment Share Summary

Shows market share for a particular airline by city pair.

![](media/image49.wmf){width="5.561111111111111in"
height="2.061111111111111in"}

![](media/image50.wmf){width="5.644444444444445in"
height="2.097916666666667in"}

### Car Report

A detailed list of each car transaction for a specified month range.
Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image51.wmf){width="5.997916666666667in"
height="1.5493055555555555in"}

![](media/image52.wmf){width="5.998611111111111in"
height="2.845138888888889in"}

### Car Report By City

Detail information on car transactions grouped by city and car chain.
Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image53.wmf){width="5.958333333333333in"
height="1.8402777777777777in"}

![](media/image54.wmf){width="5.9944444444444445in"
height="2.879166666666667in"}

### Carrier Analysis

Summary of air transactions showing number of trips by carrier and city
code. Grouped by Carrier. Data is pulled from our Reporting Database.
Data is cleaned and processed at the beginning of each month.

![](media/image55.wmf){width="5.441666666666666in"
height="1.7770833333333333in"}

![](media/image56.wmf){width="6.003472222222222in"
height="2.1041666666666665in"}

![](media/image57.wmf){width="5.503472222222222in"
height="3.970138888888889in"}

### City Pair Analysis

Summary information for air transactions showing the top 20 to 25 city
pairs. Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image58.wmf){width="5.441666666666666in"
height="2.097916666666667in"}

![](media/image59.wmf){width="5.847916666666666in"
height="3.1680555555555556in"}

![](media/image60.wmf){width="5.611805555555556in"
height="6.627777777777778in"}

### Class of Service Summary

Shows a breakdown of air activity by Logical Class of service.

![](media/image61.wmf){width="5.441666666666666in" height="1.8625in"}

![](media/image62.wmf){width="6.499305555555556in"
height="6.564583333333333in"}

### Cost Center Summary

Summary information of an Account, grouped by cost center.

![](media/image63.wmf){width="5.4527777777777775in"
height="1.9909722222222221in"}

![](media/image64.wmf){width="6.495833333333334in"
height="0.8868055555555555in"}

### Credit Card List

A detail list of air transactions on a specified credit card. Data is
pulled from our Reporting Database. Data is cleaned and processed at the
beginning of each month.

![](media/image65.wmf){width="6.000694444444444in"
height="1.8111111111111111in"}

![](media/image66.wmf){width="5.992361111111111in"
height="3.339583333333333in"}

### Destination Airport(s) Summary

The number of incoming flights booked by the whole of WWTS, a specified
branch, or for a specified Custid, for a given date range and airport
code(s). Data is cleaned and processed at the beginning of each month.

![](media/image67.wmf){width="5.998611111111111in" height="2.19375in"}

![](media/image68.wmf){width="5.291666666666667in"
height="5.222916666666666in"}

### Destination and Airline Volume Report

A summary report of air transactions summarized by carrier and city
pair.Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image69.wmf){width="6.000694444444444in"
height="1.9055555555555554in"}

![](media/image70.wmf){width="5.9944444444444445in"
height="2.4590277777777776in"}

### Detail Reports

A pair of reports that shows each air transaction for issued tickets and
refunds.Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image71.wmf){width="5.500694444444444in"
height="1.9993055555555554in"}

![](media/image72.wmf){width="6.003472222222222in"
height="2.4402777777777778in"}

### Domestic / International Summary

A one page report giving summary data for Domestic and International
travel for a specified period and year-to-date. Data is pulled from our
Reporting Database. Data is cleaned and processed at the beginning of
each month.

![](media/image73.wmf){width="5.441666666666666in"
height="1.9694444444444446in"}

![](media/image74.wmf){width="6.499305555555556in"
height="4.802777777777778in"}

### Duplicate Invoice

Provides duplicate invoices. Either for a specific invoice or for a
specific date range. Data pulled from our live, post-ticket database.

![](media/image75.wmf){width="5.986805555555556in"
height="2.1618055555555555in"}

![](media/image76.wmf){width="5.430555555555555in" height="3.8in"}

### Exceptions Analysis

A summary of air transactions where a missed savings situation exists
(defined as lfo-gross \< 0). Summarized by reason code. Data is pulled
from our Reporting Database. Data is cleaned and processed at the
beginning of each month.

![](media/image77.wmf){width="5.426388888888889in"
height="1.9569444444444444in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Exceptions Reports

A detail report that shows every transaction resulting in a missed
savings situation. Data is pulled from our Reporting Database. Data is
cleaned and processed at the beginning of each month.

![](media/image78.wmf){width="5.997916666666667in"
height="2.123611111111111in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Exchanged Tickets

List Tickets that have been exchanged and the Tickets to which the
exchanged value is applied.

![](media/image79.wmf){width="6.003472222222222in"
height="1.2895833333333333in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Executive Travel Summary

A one page summary showing month and year-to-date figures for the
current and previous year for a selected month. Figures include Taxes.
Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image80.wmf){width="5.490277777777778in"
height="2.4277777777777776in"}

![](media/image81.wmf){width="6.499305555555556in"
height="5.123611111111111in"}

![](media/image82.wmf){width="5.997222222222222in"
height="3.3993055555555554in"}

### Hotel Report

A detailed list of each hotel transaction for a specified month range.
Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image83.wmf){width="5.998611111111111in" height="3.19375in"}

![](media/image84.wmf){width="5.996527777777778in"
height="2.3340277777777776in"}

### International Routing Report

A detailed list of air transactions involving international travel. Data
is pulled from our Reporting Database. Data is cleaned and processed at
the beginning of each month.

![](media/image85.wmf){width="6.499305555555556in"
height="2.2215277777777778in"}

![](media/image86.wmf){width="6.497916666666667in"
height="3.0868055555555554in"}

### International Routing Report by SI group

A detailed list of air transactions involving international travel. Data
is pulled from our Reporting Database. Data is cleaned and processed at
the beginning of each month.

![](media/image87.wmf){width="5.502777777777778in"
height="1.8944444444444444in"}

![](media/image88.wmf){width="6.493055555555555in" height="3.6625in"}

### Invoice List

Provides a list of invoices for a specified date range in alphabetical
order by passenger name. Data is pulled from our Reporting Database.
Data is cleaned and processed at the beginning of each month.

![](media/image89.wmf){width="5.986805555555556in"
height="2.067361111111111in"}

![](media/image90.wmf){width="5.997916666666667in"
height="1.336111111111111in"}

### Negotiated Fares Report

A detailed list of air transactions using a negotiated fare (determined
by savings code). Sorted and summarized by airline. Data is pulled from
our Reporting Database. Data is cleaned and processed at the beginning
of each month.

![](media/image91.wmf){width="5.997916666666667in"
height="1.9458333333333333in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Passenger Location Report

Shows itinerary, and all available contact information for all travelers
in route as of a specified date.

![](media/image92.wmf){width="5.996527777777778in"
height="2.0180555555555557in"}

![](media/image93.wmf){width="5.99375in" height="3.83125in"}

### Passenger Manifest

Provides a passenger list for a specified flight. Ordered by passenger
name alphabetically. Data is pulled from our Reporting Database. Data is
cleaned and processed at the beginning of each month.

![](media/image94.wmf){width="5.989583333333333in"
height="2.220833333333333in"}

![](media/image95.wmf){width="6.4944444444444445in"
height="2.4784722222222224in"}

![](media/image96.wmf){width="6.497222222222222in" height="1.3875in"}

### Preliminary Exceptions Report

This report checks for PNRs that have a missed savings exception, an
Advanced Purchase exception, or both. Returns PNR info and Itinerary
info is desired. Helps realize budgeting exceptions before the
reservation is actually ticketed.

![](media/image97.wmf){width="5.496527777777778in"
height="1.9895833333333333in"}

![](media/image98.wmf){width="6.497222222222222in"
height="1.8881944444444445in"}

![](media/image99.wmf){width="6.4944444444444445in"
height="1.695138888888889in"}

![](media/image100.wmf){width="6.4944444444444445in"
height="2.036111111111111in"}

### Preliminary Hotel Report

Displays a preliminary list of Hotel arrangements.

![](media/image101.wmf){width="6.495833333333334in"
height="1.9930555555555556in"}

![](media/image102.wmf){width="6.496527777777778in"
height="2.3243055555555556in"}

### Preliminary International Routing Report

A detailed list of air transactions involving international travel. Data
is pulled from our pre-ticket database.

![](media/image103.wmf){width="5.4527777777777775in"
height="1.6590277777777778in"}

![](media/image104.wmf){width="5.989583333333333in"
height="3.151388888888889in"}

![](media/image105.wmf){width="5.999305555555556in"
height="3.6152777777777776in"}

### Preliminary Transaction Detail Summary

Provides Detail information on air transactions for a whole account ID
or a specified passenger. Data is pulled from our live, PRE-ticket
database.

![](media/image106.wmf){width="6.002083333333333in"
height="2.1791666666666667in"}

![](media/image107.wmf){width="6.4944444444444445in"
height="3.439583333333333in"}

### Premium Travel Summary

Premium travel summary

![](media/image108.wmf){width="5.996527777777778in"
height="2.1958333333333333in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### QA Profile Report

Displays Traveler profile information.

![](media/image109.wmf){width="6.496527777777778in"
height="1.4645833333333333in"}

![](media/image110.wmf){width="5.988194444444445in"
height="4.535416666666666in"}

### QA Request Statistics

A report showing total Quality Agent requests for a given time period,
PCC code, Customer ID, QA User, or a combination thereof.

![](media/image111.wmf){width="5.527083333333334in"
height="1.9055555555555554in"}

![](media/image112.wmf){width="5.142361111111111in"
height="3.029166666666667in"}

![](media/image113.wmf){width="5.86875in" height="2.472916666666667in"}

### Sales List

List of all sales at a branch for a given date range . Ordered by
branch, AccountID and Invoice #.Data is pulled from our live, Post
ticketing Database.

![](media/image114.wmf){width="5.4631944444444445in"
height="1.7659722222222223in"}

![](media/image115.wmf){width="5.847916666666666in"
height="4.420833333333333in"}

### Savings Summary

Provides a Summary of air transactions grouped by savings code. Data is
pulled from our Reporting Database. Data is cleaned and processed at the
beginning of each month.

![](media/image116.wmf){width="6.001388888888889in"
height="2.0868055555555554in"}

![](media/image117.wmf){width="6.497222222222222in" height="2.9875in"}

### Service Fees

Shows service fees for a selected date range and Account ID. Optional
parameters include Credit Card number. You can also filter for accounts
payable, credit card charges, or auto payments.

![](media/image118.wmf){width="5.997916666666667in" height="2.6875in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Top Hotels By City

Provides property information for the most utilized hotels in a given
city. Data is pulled from our Reporting Database. Data is cleaned and
processed at the beginning of each month.

![](media/image119.wmf){width="5.993055555555555in" height="1.8625in"}

![](media/image120.wmf){width="5.997222222222222in"
height="1.5631944444444446in"}

![](media/image121.wmf){width="5.996527777777778in"
height="1.5416666666666667in"}

### Top Travelers Summary

Provides summary information of the top 100 travelers for an account.
Includes TICKET count, % of account TICKET count, gross \$ amount and %
of account gross \$ amount.

![](media/image122.wmf){width="5.997222222222222in"
height="1.9916666666666667in"}

![](media/image123.wmf){width="5.9944444444444445in"
height="3.5722222222222224in"}

### Transaction Report

Provides Detail information on air transactions for a whole accountID or
a specified passenger. Data is pulled from our Reporting Database. Data
is cleaned and processed at the beginning of each month.

![](media/image124.wmf){width="5.992361111111111in"
height="2.3006944444444444in"}

![](media/image125.wmf){width="6.4944444444444445in"
height="3.8243055555555556in"}

### Transaction Summary

Shows summary information per transaction for a given date range. Data
comes from our reporting database. Data is cleaned and audited at the
beginning of each month.

![](media/image126.wmf){width="6.002777777777778in"
height="2.0868055555555554in"}

![](media/image127.wmf){width="6.4944444444444445in"
height="1.0229166666666667in"}![](media/image128.wmf){width="6.499305555555556in"
height="1.4548611111111112in"}

### Travel Policy Exceptions 

This report checks for PNRs that have a missed savings exception, an
Advanced Purchase exception, or both. Returns PNR info and Itinerary
info is desired. Helps realize budgeting exceptions before the
reservation is actually ticketed.

![](media/image129.wmf){width="5.430555555555555in"
height="2.7506944444444446in"}

![](media/image130.wmf){width="6.16875in"
height="2.151388888888889in"}![](media/image131.wmf){width="6.147222222222222in"
height="1.0909722222222222in"}

![](media/image132.wmf){width="6.179166666666666in"
height="2.9006944444444445in"}

### Unticketed PNR Report

Shows PNRs unticketed by a Ticket-by date.

![](media/image133.wmf){width="5.996527777777778in"
height="1.820138888888889in"}

**NOTE:** At this time, there is no data that conforms to the criteria
for inclusion in this report.

### Unused Ticket Log

Returns a list of Tickets available for exchange.

![](media/image134.wmf){width="5.4631944444444445in"
height="1.445138888888889in"}

![](media/image135.wmf){width="6.493055555555555in"
height="1.801388888888889in"}

### Validating Airline Summary

Shows volume of transactions per validating airline carrier. Shows
carrier totals and share of overall total.

![](media/image136.wmf){width="6.001388888888889in"
height="2.0388888888888888in"}

![](media/image137.wmf){width="5.996527777777778in" height="1.69375in"}

![](media/image138.wmf){width="5.995138888888889in"
height="2.026388888888889in"}