BSP Report (New)

BSP (Billing and Settlement Plan) - is a mechanism for airlines to charge the money for air tickets from selling agents.
For more info please visit IATA page: http://www.iata.org/ps/financial_services/bsp/Pages/index.aspx

BSP Report in Travelwise.net is designed to import data file from BSP containing all tickets bought by the Agent, compare this data with Application database and generate a report showing the difference. It is a tool to trace expenses for air tickets and ensure that BSP charges correct amounts.

BSP report in Application consists of 2 main steps:

1. Import of BSP file and calculation the difference (Reports → BSP → Import BSP data from file);
2. BSP report itself showing results of calculation (Reports → BSP → BSP Report (New)).

New functionality since version 1.85.11

One or several files can be used for comparison with new options:

• invoice date period from/to; max difference in local currency;
• expence only from invoice lines or exp+VAT;
• no need to have IATA no selection since by choosing the files to compare (IATA is defined);
• both AGT and HOT files are supplied.

Navigation: Reports → BSP → Import BSP data from file

All is needed is to browse for a file and push 'Export' button. Available data becomes exported by itself without any additional actions from user's side. The file title is going to be generated according to the green area, but it is allowed to type it manually in the 'File name' field:

Navigation: Reports → BSP → BSP Report (New)

To generate the report:

1. Select the files for reporting.
2. Complete Report parameters: Date from - Date to and set Max. Diff (if maximum difference = 0, then even the slightest difference is going to be shown).
3. Push Export.

To return the locked files back, please do the importing one more time (or contact helpdesk in case of difficulty).

• Tickets are merged in case its number is the same, but different 'TWDocType'.
• Totals of PNR tickets and manual tickets with the same number is summarized. For such records 'Mixed' type ('TWDocType') is set, issue date and PNR are taken from PNR ticket, Order No, values are separated with comma.
• It is possible that a ticket exists in Application (TW) database, but not invoiced. To see to which PNR or to which Order such tickets are related to: in 'Exist in BSP only' sheet check 'TW PNRs' column where all PNR numbers (comma separated) related to the tickets are shown (only for non-locked PNRs). In 'Orders' column there are all Orders' numbers (comma separated) related to the ticket. Relation may be either via Order→PNR→Ticket or via Order→Offer/Invoice→InvoiceLine→Ticket. In case there are no relations, the PNRs/Orders fields are blank.