Statistic and Reporting System

Description

LEONARDO has a built in reports engine containing a large amount of predefined reports and reporting cubes for further analysis based on user requirements. All reports can be run “on-demand” on the LEONARDO Reporting platform and may be exported in various data formats, including CSV (Comma Delimited), XML, and PDF. (Microsoft Excel can open and import CSV and XML file formats.)

Detail reports that generate output based on a user-specified time frame can produce at least one full day of detail data.

Summary reports that generate output based on a user-specified time frame can produce up to one month of summary data.

Report files generated by LEONARDO Reports subscription functionality will be retained for up to 6 (six) months from the date they are generated.

Features and Functionality

The following is an alphabetical list by function, which contains a description of the standard reports available as a part of the LEONARDO Reporting Services. These reports may be added to, deleted, modified, changed, eliminated or substituted for at the discretion of the Airline at any time. The reports are viewed online via a browser interface.

Accounting General

·         Agent Activity -Displays information about activity within a travel agency during a specified period of time.

·         Agency List Summary -Displays a summary view of the agencies associated with your carrier.

·         Availability Information -Displays flight availability information, including lid, capacity, seats sold

·         Bank Reconciliation - Reconciles bank transactions.

·         Bookings By Agent Detail - Provides detailed information on bookings made by individual booking agents.

·         Cancellation After Travel Date -Displays passenger and fare information about cancelled booking segments.

·         Checked Baggage -Displays baggage information for flights.

·         Checked In Passengers By Fare Class -Displays the total number of passengers by fare class who were checked-in.

·         Commissions Incurred - Provides commissions information for each of the travel agency that generates bookings for your carrier.

·         Credit File Commissions -Displays commission information on travel agency bookings.

·         Customer ID By Flight -Displays the customer IDs associated with passengers booked on a selected flight.

·         Daily Agency Charges -Displays the number of charges and activity performed by each agency during a specified day.

·         Enplanement Deplanement -Displays either enplanements or deplanements by airport.

·         Fare Overrides -Displays fare override information by agent.

·         Fees And Discounts -Displays passenger-level service fees, SSR fees, seat fees, and penalty fees.

·         Fees And Discounts By Date -Displays fees that were manually added to the booking.

·         Fees And Discounts By Location And Agent -Displays fees that were manually added to the booking by location and by agent.

·         Fees And Discounts By Location And Fee Type -Displays fees that were manually added to the booking by location and by fee type.

·         Gender Count By Fare Class - Lists and breaks down passenger information by fare class.

·         Generic Tax History -Displays information about the selected tax.

·         Net Sales - Summarizes net sales figures.

·         No Shows -Displays the names, PNRs, flight dates, and flight numbers for no-show passengers.

·         Payment Detail -Displays information about payments made.

·         Payment Detail Consolidation -Displays information about payments made and is further organized by booking source.

·         Payment Receipts -Displays information about all payments made on the payment approval date.

·         Payment Receipts Restricted -Displays information about all payments made on a specified date.

·         Refunds -Displays refunds made by specific departments.

·         Sales Exceptions -Displays the information on PNRs when the balance of the PNR and the payments made differ.

·         Seat Assignments By Agent - Provide the total number of seat assignments made by specific agents.

·         Segment Activity By City Pair -Displays information on confirmed and/or unconfirmed booking amounts and passenger totals by city pairs.

·         Segment Activity By Flight Date -Displays information on segment activity by flight date.

·         Segment Activity Detail -Displays information on segment activity for a specific date or date range.

·         Segments By Agent - Shows the number of segments that were created or cancelled during the period and the charges associated with those segments made by individual agents.

·         Unapproved Payments -Displays all payments, by payment type that have not been approved.

Add-on Services

·         Ancillary Services Detail - Generates detailed information on car rentals, insurance, and hotels.

·         Ancillary Services Summary - Generates summary information on car rentals, insurance, and hotels.

·         Insurance - Tracks the amount of revenue generated by passengers purchasing insurance.

Booking

·         Bookings By Agent -Displays total bookings created by an agent.

·         Bookings By Agent Detail - Provides detailed information on bookings made by individual booking agents.

·         Bookings By Agent Detail Restricted - Provides detailed information on bookings made by individual booking agents restricted by the agent’s location and domain.

·         Bookings By Agent Restricted - Provides detailed information on bookings made by individual booking agents restricted by the agent’s location.

·         Bookings By Fare Class with Equipment -Displays passenger/segment booking and fare totals by fare class.

·         Bookings By Market -Displays passenger totals, booking amounts, and average fares for individual markets.

·         Bookings By Origin -Displays segment booking information (total segments and fare amounts by currency) for each originating city.

·         Bookings By Schedule - Monitors bookings for a specified origin/destination (city pair) on a specific date.

·         Bookings By Source - Provides a count of active (not cancelled) booking Segments and Journeys by booking source or channel.

·         Booking Statistics - Determine flown and unflown revenue by booking source.

·         Bookings By Time -Displays booking information in hourly increments.

·         Days Out Bookings -Displays information about segment bookings made on a specific date, the number of segments sold in future dates following the selected booking date, and the actual travel date when these bookings were made.

·         Duplicate Bookings - Lists different PNRs for the same flight and date that contain identical passenger names.

·         E-Ticket On Demand -Displays information on the dates E-Tickets were issued for billing purposes.

·         Group Bookings Out of Balance - displays information on group reservations that have a credit and/or balance due.

·         Net Booking Transactions - determines revenue from confirmed bookings by booking source using the date created.

Codeshare

·         IATCI Reporting - Provides Inter Airline Through Check-in (IATCI) data to carriers expanding their existing code share partnerships with other airlines.

Inventory

·         Cancelled Inventory With Passengers - Provides the number of passengers who may need to be re-accommodated to another flight due to a cancellation

·         Flight Capacity Lid -Displays information on seat capacity (or lid) and availability.

·         Flight Schedule -Displays scheduled departure cities and times for flights

·         Inventory Capacity - Lists capacity, lid, net seats sold, and seats sold today for flights.

·         Load Factor Search -Displays load factor information.

·         Seat Property Match -Displays counts of how many passengers requested seat assignments and how many got the seats they actually requested.

·         Seating Exceptions - Designed to identify PNRs with particularly low match rates on desired properties.

·         Seats Sold By Cabin -Displays the number of seats sold, and fare amounts, by cabin.

·         Seats Sold By Fare Class -Displays the number of seats sold in each fare class.

Management Performance

·         City Pair Load Factor - Provides information about the productivity of flights servicing different city pairs.

·         Flight Specific Load Factor -Displays flight specific load factor information.

·         Revenue By Flight -Displays revenue by average seat mile/kilometer for each date and for individual flights.

Marketing

·         Promo Codes By Booking Date -Displays information on PNRs with promotion codes by booking date.

·         Promo Codes By City Pair -Displays information on promotion codes by city pairs.

Operations

·         Availability Information -Displays flight availability information, including lid, capacity, seats sold and GDS triggers for selected flights on selected dates.

·         Checked Baggage -Displays baggage information for flights.

·         Checked In Passengers By Fare Class -Displays the total number of passengers by fare class who were checked-in.

·         Flight Line -Displays passenger counts for a specific flight on a specified date.

·         Flight Load -Displays passenger totals for flights.

·         Flight Manifest -Displays passenger information for selected flights.

·         Flight Schedule -Displays scheduled departure cities and times for flights.

·         Flight Specific Load Factor -Displays load factor information.

·         Gender Count By Fare Class -Breaks down passenger information by fare class.

·         IROP And Moved Passengers - Lists all PNR's that have been moved by IROP.

·         Lock List - Allows you to print all data associated with a name on the watch list.

·         Lock List History - Allows you to print all data associated with activity on the lock list including those who have been moved on as well as cleared from the list.

·         Manifest With Connection Information - Lists connection information for booked passengers.

·         Selectee Report - Lists the number of passengers that have been identified for additional security screening.

·         SSR Flight Information - Provides a list of passengers with SSRs on a flight by flight basis and the SSR counts by flight.

·         SSRs By Agent - Lists and subtotals SSR code assignments by the Agent ID that assigned them.

·         SSRs By Flight - Allows you to generate SSR statistics for inbound, outbound, thru, connection or all flight types.

Payment

·         Payment Detail -Displays information about payments made.

·         Payment Detail Consolidation - displays information about payments made. Information may be further organized by booking source, transaction type, department, and agent.

·         Payment Receipts -Displays information about all payments made on the payment approval date.

·         Payment Receipts Restricted -Displays information about all payments made by payment type, agent, location, and department.

·         Payment Summary -Displays information on what location and department received the payment, the payment method, and how much of the payment was collected.

·         Unapproved Payments -Displays all payments, by payment type that have not been approved.

PNR Diagnostics

·         Bookings By Agent Detail - Provides detailed information on bookings made by individual booking agents.

·         Duplicate Bookings - Lists different PNRs for the same flight and date that contain identical passenger names.

·         PNR Activity -Displays transaction activity performed on individual PNRs.

·         PNRs On Queue -Displays information about all PNRs that are currently awaiting processing in one or more queues including subqueues.

 Revenue

·         City Pair Load Factor - Provides an extensive array of information about the productivity of flights servicing different city pairs.

·         Earned Unearned Revenue - Allows you to view information on earned (flown) revenue, unearned (no-show, unflown) revenue, or both earned and unearned revenue.

·         Earned Unearned Revenue Detail - Provides details in addition to those generated in the Earned Unearned Revenue Report

·         Enplanement Deplanement -Displays either enplanements or deplanements by airport.

·         Revenue By Fare Class -Displays earned revenue by fare class.

·         Revenue By Flight -Displays revenue by average seat mile/kilometer for each date and for individual flights.

·         Revenue By Market -Displays base and gross revenue information by market