Orbis Web · Reconciliations
Version 2026.10

BSP Reconciliation: match your tickets against the IATA settlement

Import the BSP file, compare it with the air services in Orbis Web and instantly find any differences in amounts, taxes or tickets. For the agency's administration and accounting staff.

Basics

What BSP Reconciliation is

BSP Reconciliation saves you from checking the IATA settlement by hand: it cross-checks the tickets in the BSP file against the services recorded in Orbis Web and produces a report with the result, so you only need to deal with what does not match. Then, in Ticketing Control, you mark all the reconciled tickets as paid in one go.

You will find it under Reconciliations › BSP Conciliation. Everything is done from a single screen with two blocks: FILTERS (which tickets and services are included in the comparison) and CONFIGURATION (how they are compared). The actions are on the button bar and in the Actions menu.

BSP in one sentenceThe BSP (Billing and Settlement Plan) is the IATA system that settles with the airlines the tickets issued by the agency. Its settlement, which you download as a PDF from Amadeus and convert to TXT with BSP Convert, is the reference against which the Orbis Web services are compared.
ActionBar buttonWhat it does
ReconcileFirst buttonGenerates a list of the reconciled tickets according to the filters and configuration.
Import File BSPSecond buttonOpens the file browser so you can load a BSP file from your computer.
Manage Files BSPThird buttonOpens the Files BSP window with the imported files.
HelpFourth buttonOpens the Orbis Web help in a new tab.
ImportantFile first, reconciliation secondWithout an imported BSP file there is nothing to compare against. Import the file for the period before reconciling.
Video

BSP reconciliation on video

The reconciliation from start to finish, in 4:32. Click the image to watch it.
Common procedure

The 6 steps of a reconciliation

Open the screenIn the side menu, go to Reconciliations › BSP Conciliation.
Prepare and import the BSP fileDownload the settlement PDF from Amadeus, convert it to TXT with BSP Convert and import it with Import File BSP.
Set the filters and configurationChoose the file, the date range and the checks you want to apply.
Reconcile, balance and register ACMs and ADMsClick Reconcile, balance the incorrect tickets and generate the booking file for the ACMs and ADMs not found.
Change the payment dateFrom the report, assign a dummy payment date to the tickets found.
Complete in Ticketing ControlFilter by that payment date and complete the services: with the L button if you post accounting entries per booking file, or by generating the supplier invoices if you post them per invoice.
Task: identify the parts of the screen. Recreation of the screen with sample data.

Parts of the screen

  1. In the side menu, open Reconciliations and choose BSP Conciliation.
  2. From left to right, the button bar contains Reconcile, Import File BSP, Manage Files BSP and Help. Hover over each button to see its name.
  3. The Actions menu groups the same actions as a list.
  4. In FILTERS you choose which tickets and services are compared.
  5. In CONFIGURATION you decide how they are compared; Reset Filters restores the default values.
Find your task

What do you want to do?

No task matches that term. Try another word.

Before importing

Prepare the BSP file: from PDF to TXT

What it is for

Orbis Web imports the BSP settlement in text format (TXT). With BSP Convert you can quickly transform the PDF you download from Amadeus.

When to use it

Every time there is a new BSP settlement, before importing it into Orbis Web.

Download the PDFDownload the BSP settlement for the period in PDF format from the Amadeus website and save it on your computer.
Convert it to TXTOpen BSP Convert at www.pipeline.es/bsp.htm and send the PDF.
Save the TXTSave the converted file; this is the one you will import into Orbis Web.
Task: convert the BSP settlement from PDF to TXT. Recreation of the BSP Convert page.

Step by step

  1. At www.pipeline.es/bsp.htm, click Choose file and select the settlement PDF you downloaded from Amadeus.
  2. Select the BSP country: SPAIN (default option) or PORTUGAL.
  3. Click SEND and save the generated TXT file on your computer.
Common errorImporting the PDF directlyOrbis Web cannot read the settlement PDF. Always convert it first with BSP Convert and import the resulting TXT.
Module

Import BSP file

What it is for

Loads the BSP settlement for a period into Orbis Web so you can compare it with your services.

When to use it

Every time you have a new BSP settlement converted to TXT, before reconciling that period.

Task: open the file browser to import a BSP file. Recreation of the screen.

Step by step

  1. Click the Import File BSP button (the second one on the bar)…
  2. …or open Actions and choose Import File BSP.
  3. In your computer's file browser, select the TXT file generated with BSP Convert and confirm.
  4. Check in Manage Files BSP that it appears with its IATA number and period.
Common errorThe file does not appear in the File filterIf the import has not finished or the file is not a valid BSP settlement, it will not be available for reconciliation. Check the Files BSP window and import it again if it is not listed.
Module

Filters

What it is for

Defines which tickets from the BSP file and which Orbis Web services are included in the reconciliation.

When to use it

Always before reconciling: at the very least, choose the File and check the default dates.

Task: choose the BSP file and narrow down the services. Recreation of the screen with sample data.

Step by step

  1. Open File and tick the BSP file for the period. You can use the search box or Select all.
  2. If needed, limit the reconciliation by Branch, Suppliers or Ticketing Type.
  3. Adjust the date ranges and, if you wish, the ticket number range.
  4. In Include Services, choose Files, Groups or All.
  5. Tick or untick the check boxes depending on what you want to see in the report.
FilterWhat it doesDefault
FileThe imported BSP file or files used for the comparison. Each one is identified by its period and IATA number.Empty
BranchLimits the Orbis Web services to one or more branches.Empty
SuppliersLimits the reconciliation to the selected suppliers (multiple selection with search box).Empty
Ticketing TypeTicketing types included: (1) - SIN BILLETAJE, (2) - BSP, (3) - RENFE and (4) - LOW COST.Empty
Issue Date, Sale Date, Payment DateFrom / To ranges to narrow down the services by each date.Sale and Payment from 01/01/2026
Ticket NumberFrom / To range of ticket numbers.Empty
Include ServicesServices from booking files, from groups or from both.All
Include Services Without Payment DateAlso takes into account services that do not yet have a payment date.Ticked
Tax ControlAlso compares the ticket taxes, not just the amount.Ticked
Show correct tickets in the reportIncludes the tickets that match in the list, as well as those with differences.Unticked
Common errorTickets from the end of the previous year are missingFrom Date of Sale and From Payment Date are pre-filled with 01/01/2026. If you reconcile a file from a different period, change or clear those dates so the services are not left out.
Module

Configuration

What it is for

Defines the comparison rules: which documents are taken into account and what margin is accepted in the amounts.

When to use it

When the list shows differences you are not interested in (cents, voids, refunds) or when you want a stricter check.

Task: adjust the reconciliation rules. Recreation of the screen with the default values.

Step by step

  1. Tick Include ACMS Tasf or Include Voids if you want those documents to be included in the comparison.
  2. Tick Control Supplier IATA to also check the supplier of each ticket.
  3. In Maximum Deviation (Absolute Value), enter the amount difference you accept as correct.
  4. Tick Exclude Received Services or Exclude refunded tickets to leave them out.
  5. To start from scratch, click Reset Filters.
OptionWhat it doesDefault
Include ACMS TasfIncludes TASF-type ACMs (Agency Credit Memos from the airline) in the reconciliation.Unticked
Include VoidsIncludes the voided tickets in the BSP file.Unticked
Control Supplier IATAChecks that the supplier of the service in Orbis Web corresponds to the ticket's airline (see IATA suppliers).Unticked
Maximum Deviation (Absolute Value)Maximum amount difference, positive or negative, that is considered correct.0.02
Exclude Received ServicesLeaves out services that have already been received.Unticked
Exclude refunded ticketsLeaves out refunded tickets.Unticked
Reset FiltersRestores the filters and configuration to their default values.—
Enter the deviation with a decimal pointThe default value is shown as 0.02, with a decimal point. Use the same format if you change it, for example 0.50.
Module

Reconcile

What it is for

Runs the comparison and opens the Report BSP Conciliation window with the reconciled tickets according to the filters and configuration.

When to use it

After importing the BSP file and selecting it in the File filter.

Task: run the reconciliation. Recreation of the screen.

Step by step

  1. With the filters set, click the Reconcile button (the first one on the bar)…
  2. …or open Actions and choose Reconcile.
  3. The Report BSP Conciliation window opens with the list, the summary and the legend. Review the tickets that have a key and either correct the service in Orbis Web or raise a claim with the airline, as appropriate.
Common errorThe list is emptyUsually no file is ticked in File, or the dates leave out the services for the period. Check both filters and reconcile again.
Module

Balance the incorrect tickets

What it is for

Adjusts, in one go, the commission and tax of the tickets that do not match the BSP, so that they are the same as in the settlement.

When to use it

After reconciling and always before changing the payment date, when the report shows tickets with the key * (ticket does not match).

Task: balance the tickets that do not match. Recreation of the report (abridged) and the confirmation window with sample data.

Step by step

  1. In the report, review the tickets with the key * and the Non-matching tickets total in the SUMMARY. Check that the difference is in the commission or tax and not in any other data.
  2. Click Reconcile incorrect bills, below the report.
  3. In the Are you sure? window, click Accept to balance them, or Cancel if you want to review them first.
  4. Click Reconcile again and check that Non-matching tickets is now 0. Then register the ACMs and ADMs.
CautionIt applies to all the incorrect tickets in the reportBalancing changes the commission and tax of the services in Orbis Web. If a ticket does not match for another reason (amount, taxes or an issuing error), correct it manually or raise a claim before accepting.
Module

Register ACMs and ADMs as a booking file

What it is for

The airline's ACMs (credit memos) and ADMs (debit memos) arrive in the BSP with no service in Orbis Web, which is why they appear as not found. With one click, a booking file is created for all of them and they are included in the settlement.

When to use it

After balancing the incorrect tickets and before changing the payment date, when the report shows ACMs or ADMs with the key **.

Prerequisite: set up the customer and supplier (once only)

The booking file is created with the customer and supplier you specify in the branch configuration. Do this once per branch, before the first reconciliation.

Task: specify the customer and supplier for the ACM and ADM booking files. Recreation of the screen with sample data.

Step by step

  1. Go to Configuration and open Branches; choose the branch you are going to reconcile.
  2. In the branch menu, open Reconciliations and choose BSP.
  3. Choose the customer in Client automatic file registration (ACM, ADM) and the supplier in Automatic file registration provider (ACM, ADM).
  4. Save with the ✓ button.
A customer and supplier just for thisIt is common practice to create a dedicated customer (for example, “BSP ACM ADM”) and use the BSP supplier as the supplier. That way, the ACM and ADM booking files are quick to find and are not mixed up with sales.

Generate the booking files from the report

Task: create the booking file for the ACMs and ADMs not found. Recreation of the report (abridged) with sample data.

Step by step

  1. In the report, find the lines with DOC ACM or ADM and the key ** (not found).
  2. Click Generate ACMS and ADMS file not found and confirm if prompted.
  3. Click Reconcile again: the ACMs and ADMs should now appear as found. Then change the payment date.
Common errorThe booking file is not createdCheck that the branch has the automatic creation customer and supplier filled in under Configuration › Branches › Reconciliations › BSP.
Module

Change the payment date of the tickets found

What it is for

Assigns the same payment date to all the Orbis Web services that the reconciliation has found in the BSP file. You then use that date to find them all together in Ticketing Control.

When to use it

Once you have balanced the incorrect tickets and registered the ACMs and ADMs, the report is correct and you are ready to mark the period's tickets as paid to the BSP.

Task: set the payment date for the tickets found. Recreation of the report and the Payment Date window with sample data (the report is abridged).

Step by step

  1. Click Reconcile and, in the Report BSP Conciliation window, review the SUMMARY and the CODE column.
  2. Click Change payment date for services, below the report.
  3. In the Payment Date window, enter in New Date a dummy date that no other service has, usually 31 December of the following year (today's date is shown by default). Make a note of it: you will need it in Ticketing Control.
  4. Click Change Date.
Report codeMeaning
No codeCorrect ticket: it is in Orbis Web and matches the BSP.
*Bill does not match: it is in Orbis Web, but with different amounts.
**Bill not found: it is in the BSP but not in Orbis Web.
#Supplier does not match.
ImportantUse a dummy date, not the actual oneUse a date that no other service has, usually 31 December of the following year. With the actual date, tickets from airlines that are not settled through BSP could match and the summary would show amounts that do not belong there. The actual payment date is set later, when you complete the payment in Ticketing Control.
Follow-up step

Complete the payment in Ticketing Control

What it is for

Gathers all the tickets from the reconciliation by their payment date and marks them as received and paid in one go: invoice received, invoice date and amount, payment date and amount paid.

When to use it

Right after changing the payment date of the tickets found in the reconciliation.

Task: find the reconciliation tickets by their payment date and complete them. Recreation of the screen with sample data; only some columns and filters are shown, in four columns instead of six.

Step by step

  1. Go to Periodic Operations › Ticketing Control and open Filters.
  2. Clear From Date Services Start, which is pre-filled with 1 January, so that tickets for earlier services are not left out.
  3. In From Payment Date and Until Payment Date, enter the same date you set in New Date. Also untick Services Without Payment Date, which comes ticked: otherwise all the services without a payment date appear as well.
  4. Click Filter.
  5. Check that the table shows the reconciliation tickets, all with that Payment Date. If you wish, click R (Summary) to see the totals.
  6. If your agency posts accounting entries per booking file, click L (or Actions › Fill out Invoice Print, Invoice Received, Payment Date, Invoice Date and Invoice Paid). In the Dates window, enter the actual Payment Date, the Invoice Date and the Supplier Invoice Number, and accept.
  7. If it posts entries per invoice, do not use L: click Generate supplier invoices for the listed services (also under Actions) and confirm. Without those invoices you cannot receive the purchases or post the sale.
ButtonWhat it fills in on the listed services
RNothing: it shows the summary of amounts for the listed tickets.
FInvoice received, invoice date, invoice amount and payment date.
LThe same as F, plus the amount paid. With entries per booking file, this is the option for closing the payment to the BSP.
Generate supplier invoices for the listed servicesGenerates the supplier invoices for the listed services so you can receive the purchases and post the sale. This is the option with entries per invoice: in that case, L is not used.
CautionL and the supplier invoices act on everything in the tableBefore clicking L or generating the invoices, check that the number of services and the amounts match the tickets found in the reconciliation report. If other services appear, adjust the filters.
Module

Manage BSP files

What it is for

Shows the imported BSP files, with their IATA number and period, and lets you edit them, delete them or export the list.

When to use it

To check that an import has worked or to remove a file loaded by mistake.

Task: review the imported BSP files. Recreation of the window with sample data.

Step by step

  1. Open the window with Manage Files BSP (third button or the Actions menu) and use Search to find a file.
  2. Export the list to Excel or PDF with the buttons on the right.
  3. On each row, click the pencil to edit the file or the bin to delete it.
CautionDeleting a file removes it from reconciliationsOnce deleted, it no longer appears in the File filter. If you made a mistake, you will have to import it again.
Guidelines

Best practices

One period at a time

Reconcile file by file: the list is shorter and the differences are easier to find.

Dates that match the file

Set the sale and payment dates to the period of the BSP file instead of leaving the defaults.

Realistic deviation

A small deviation absorbs rounding without hiding real errors. Avoid raising it just to “clean up” the list.

No duplicates

Before importing, check in Manage Files BSP whether that period is already loaded.

Before reconciling
  • The settlement PDF has been converted to TXT with BSP Convert.
  • The BSP file for the period has been imported and appears in the Files BSP window.
  • The file is ticked in the File filter.
  • The issue, sale and payment dates cover the period of the file.
  • The configuration (voids, ACMs, refunds and deviation) is what you need.
  • The branch has the automatic creation customer and supplier for ACMs and ADMs set up.
  • You have generated the booking file for the ACMs and ADMs not found.
  • You have balanced the incorrect tickets and none are left with the ticket-does-not-match key.
  • You have decided on the dummy date (usually 31 December of the following year) you will give the tickets found.
Support

Common problems

The file I have just imported does not appear in the File filter.Check in Manage Files BSP that it has been imported and that you imported the converted TXT, not the PDF. If it is not there, import it again from Import File BSP.
Tickets with differences of a few cents are shown as incorrect.Check the Maximum Deviation (Absolute Value) setting. Differences above that value are treated as discrepancies.
Differences appear for voided or refunded tickets.Check Include Voids and Exclude refunded tickets in the Configuration block.
I cannot see the tickets that match.By default the list does not show them. Tick Show correct tickets in the report and reconcile again.
Ticketing Control shows more services than expected.Other services also have that payment date. Narrow it down with Supplier, Ticketing Type or the ticket range, and give the tickets found a dummy date that no other service has.
Ticketing Control shows hundreds of services without a payment date.Untick Services Without Payment Date in the filters and click Filter again.
Tickets from the reconciliation are missing in Ticketing Control.Clear From Date Services Start and check that From Payment Date and Until Payment Date contain exactly the date you set in New Date.
I have changed a lot of filters and do not know which one is wrong.Click Reset Filters to restore the default values and adjust only what you need.
Still not working?Contact Pipeline Software support through your agency's usual channel. Give the IATA number and period of the BSP file, the filters you used and an example of an affected ticket number.