ARC Revenue Analysis Reports assemble ticketed transaction data for your carrier into logical groups for revenue management and loss prevention analysis. The reports allow you to quickly identify trends and anomalies in ticketing activity and transaction details.

The product suite includes the reports listed below. You can purchase one, several, or all of the reports. (Click on any title for information on that particular report.) For pricing and ordering information, please request more information.

• System Integrity
  • Velocity Report
    Identifies agencies with any sudden, significant increase in tickets sold on your carrier. The report ranks agencies ascending order based on how far their most recently submitted transaction count deviates from their average transaction count over the period of the previous 72 days. Allows you to quickly identify agencies that have an unusual spike in sales. The ranking provides information needed to determine the severity of the spike and determine if further action is necessary.
  • Out-of-Period Report
    Identifies agencies that report tickets and/or sales reports late. The report groups records by travel agency location and summarizes the late transactions by manual or IAR processing and cash or credit sales. The report also totals the number of late transactions during the report period and summarizes the total value of the transactions by fare and commission amounts.
  • Manually Priced Tickets Report
    Agency and ticket information for automated tickets where the price was manually changed. Included transactions might be priced incorrectly if the agents did not have permission or instructions to manually price an automated ticket.
  • Non-Lifting Carrier Report
    Identifies agencies that validate tickets on a carrier that does not have any segments within the itinerary. These types of transactions might be problematic for interlining carriers if a discrepancy exists with the value of the ticket or segment.
  • Class of Service Report
    Transaction information by class of service and average ticket value. This report will help carriers determine if the ticket price is in line with the class of service. Carriers can specify the cabin class codes to be used in the report.
  • Credit Card Missing Approval Code Report
    Agency and transaction information for tickets where no credit card approval code was obtained. This information can help reduce exposure to charge backs.
• Void Reports
  • Void Detail Report
    Transactions voided either manually or through a GDS. (Reports can be ordered separately by manual or GDS transactions.)
  • Void Detail Report – Other Airlines
    Transactions voided, but subsequently settled on other airlines. This report can help expedite the payment process with other interlining carriers by tracking transactions that were voided on the subscribing carrier, but were later reported using another carrier’s validation.
  • Void Summary Report
    Summary information of voided transactions by agency location, subscribing carrier, and all carriers (aggregated). (Reports can be ordered separately by manual or GDS transactions.)
• Commission Reports
  • Commissions Report – Settled Transactions
    Settled transaction information for tickets that include commissions.
  • Commissions Report – Initial Transactions
    Initial transaction information for tickets that include commissions.
  • Average Commission Report
    Average commission amounts by agency for settled transactions.

• Aggregate Reports
  • Aggregate Sales Report
    Sales totals from all cycles aggregated into one report. (Offered monthly and weekly for settled transactions and daily for initial transactions.) The ACN’s full address and the fare field separated by cash and credit transactions can be added for an additional fee.
  • Form of Payment Reports
    • Form of Payment Summary Report
      Count of transactions validated on the subscribing carrier summarized by: ACN; number of cash transactions; number of credit card transactions by credit card company.
    • Form of Payment by Credit Card Number Report
      Count of transactions validated on the subscribing carrier by credit card account number.
  • Passenger Facility Charge (PFC) Report
    Passenger Facility Charges (PFC) by three-letter airport code, counts, and amounts that appear on a ticket.
  • Tax Report
    All two-letter tax codes, counts, and amounts that appear on a ticket.
• Detail Reports
  • Detailed Sales Report
    All data elements on the face of a ticket for every ticket transaction.
  • Refunds and Exchanges Report
    All ticket refunds and exchanges in an electronic format, including the original ticket information.
  • Adjustment Transactions Report
    Details of “adjustment” transactions, such as debit memos, credit memos, recall commission statements, and agent-automated deductions.
  • Cash/Credit Report
    All transactions by cash or credit.

All reports are delivered in Microsoft® Excel® format. (Other formats may be available for an additional fee.) Reports are provided on a daily, weekly, or monthly basis depending on the report.

Request Additional Information
For more information and pricing on any of these reports, please complete an information request form. You may also contact an ARC Sales Representative at +1 703.816.8007.