Airline Settlement Report

Product version 1.3
Last edited January 2023

Report Overview

In addition to the positive commercial impact that Nium Airline Payment Solution provides to Airlines, speed of payments is another significant benefit. With Nium Airline Payment Solution, any amounts due via indirect distribution channels (e.g., online travel agencies (OTAs) and Travel Management Companies (TMCs)) is received much quicker than other payment methods such as BSP Cash. Using the Nium Card, which is powered by UATP, Airlines will no longer need to raise Agent Debit Memos (ADMs), as Nium will affect a daily bank transfer to your accounts. To help your back-office teams understand what this daily amount is made of, we have built the Airline Settlement Report. This report is generated daily and comprises a list of transactions (purchases and refunds) we processed during the previous business day.

We want to ensure that payments done using the Nium Card powered by UATP are as transparent as possible. The Airline Settlement Report breaks down each transaction into multiple columns. The columns provide critical details such as the card number, the exact amount you receive, together with the OTA incentive, and settlement fee. In addition, we also include the Passenger Name Record (PNR) and Ticket Number, to help optimize your reconciliation processes. These will allow your back-office teams to easily reconcile each airline ticket with a transaction.

To download the report, please use the SFTP connection our Customer Delivery team provided during your onboarding. In case of any issues, feel free to contact us at [email protected].

What follows is a reference guide of all the details you will find in the Airline Settlement Report.

Transaction Details

COLUMN HEADINGDESCRIPTION
Transaction DateDate and time (in GMT) when Nium successfully processed the transaction.
ClientThe account name of the travel buyer (e.g. OTA, TMC, etc.)
Ticket NumberThe unique number is generated by the airline for every purchase. Any subsequent refunds for sale will have the same ticket number. 13 digits made up of a 3-digit airline code followed by a 10-digit ticket number.
PNRPassenger Name Record provided by the airline.
Transaction TypePURCHASE or MERCHANT REFUND
Card NumberMasked card number with the first six digits representing the card’s issuer identification number. e.g., 194600*****3293
Transaction CurrencyThe currency that the airline uses to request funds. Currency is agreed with OTA.
Transaction AmountAmount requested by the airline.
Forex RateThe rate used to convert the transaction amount to the settlement amount. It will be 1 when the Transaction Currency and the Card Currency (not provided in the report) are the same.
ECB RateThe latest European Central Bank (ECB) rate applicable for the day. Will be available for any forex transactions where both the card and transaction currencies are EEA Currencies, otherwise the ECB Rate will be empty.
Settlement CurrencyCurrency used by Nium to pay the airline.
Settlement AmountThe net amount settled by Nium to the airline. The settlement fee and OTA incentive are already deducted from this amount.

When the transaction type is MERCHANT REFUND, the amount will be equal to the Transaction Amount less the Nium Airline Payments Fee less the client incentive. The amount will be negative.
Settlement FeeTotal fees for the Settlement Transaction, as agreed with Nium in the Airline Settlement Agreement. This is made up of the Nium Airline Payment Fee, a % of the transaction amount, and the UATP fee. The latter is a fixed cost per transaction. The UATP fee is applicable for both PURCHASE and MERCHANT REFUND transaction types.

When the transaction type is MERCHANT REFUND, the Nium Airline Payment Fee will be refunded. The pass-through UATP fee is not refunded. The amount will be negative.
Client Incentive AmountIncentive agreed with OTA.
When the transaction type is MERCHANT REFUND, the amount will be negative, indicating that the incentive will be paid back to the Airline.
Transaction IDA unique transaction reference was generated by Nium. Used by the airline to request further transaction information from Nium.