This is an old revision of the document!


BSP Report

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

Purpose

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.

Workflow

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.

STEP 1

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:

STEP 2

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).

Report Notes

  • 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.