Table of Contents

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

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:

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

Multicurrency

It is allowed to import BSP files in currencies which differ from the host company default currency and to compare incoming foreign currency values with local currency values on related invoices.


The column 'Currency' contains ISO currency code taken from the BSP file lines (can be located manually between 'File name' and 'Locked' columns, by default it is placed in the end of the grid) .

When report data is processed there could be three main scenarios:

  1. File's currency is matching HC currency. Report is run the same way as it used to be.
  2. File's currency is not matching HC currency. Report is run comparing tickets fares with local sell values on related invoices where file currency is matching local sell currency. In case there is related invoice line, but the local currency value is missing then TWNet=0 is set.
  3. File contains values in different currencies. Report is run comparing tickets fares with local sell values on related invoices where file currency is matching local sell currency. In case there is related invoice line, but the local currency or issues in another currency are missing then TWNet=0 is set.

RULES