Sis simplified interline settlement sis functional review
This presentation is the property of its rightful owner.
Sponsored Links
1 / 76

SIS – Simplified Interline Settlement SIS Functional Review PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

SIS – Simplified Interline Settlement SIS Functional Review. SIS Awareness Regional Workshop, Beijing April 2011 Gianna Monsch, aerwise. Agenda. General & Basics IS Functionality – more in detail Special Cases. SIS Overview. Interline Settlement - Today.

Download Presentation

SIS – Simplified Interline Settlement SIS Functional Review

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Sis simplified interline settlement sis functional review

SIS – Simplified Interline SettlementSIS Functional Review

SIS Awareness Regional Workshop, Beijing April 2011

Gianna Monsch, aerwise


Agenda

Agenda

  • General & Basics

  • IS Functionality – more in detail

  • Special Cases

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS Overview

SIS P3 – Bejing Workshop - SIS Functional Review


Interline settlement today

Interline Settlement - Today

Paper invoices, with coupon listing, coupons, rejects, supporting documents

(monthly)

Settlement sheets – (weekly)

Recap sheets - weekly

Billed

Entity

ACH

Billing

Entity

F3– (weekly)

F12 – (weekly)

F1 – net amounts of inv

F2 - summary

ICH

ATPCO

Cargo IDEC File (monthly)

Cargo IDEC File (monthly)

Pax IDEC File (monthly)

Pax IDEC File (monthly)

(incl F&F pre IDEC

Validation)

prorate

engine

prorate

engine

ARC-Compass

(NFP storage)

Previously released sales record

GDSs

BSPs

F&F: receives NFP value

AIA F&F

SIS P3 – Bejing Workshop - SIS Functional Review


Integrated settlement

Integrated Settlement

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Integrated Settlement

IS-WEB

IS-WEB

Billed

Entity

Billing

Entity

“Digital

Signature”

Company

IS-XML

IS-XML

Overall Processes

Overall Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

SIS P3 – Bejing Workshop - SIS Functional Review

5


Sis simplified interline settlement sis functional review

File Formats

SIS P3 – Bejing Workshop - SIS Functional Review


File formats

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

File Formats

Integrated Settlement

Format Conversion:

  • Billed Entity’s choice of format does not depend on the billing carrier’s

IS-WEB

IS-WEB

Billed

Entity

Billing

Entity

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

Send files

(or enter online)

Receive (or download) invoices

Validation

Format Conversion

SIS P3 – Bejing Workshop - SIS Functional Review


Invoice data input

Invoice Data Input

SIS P3 – Bejing Workshop - SIS Functional Review

Invoice Input Data Files can be transferred using secure FTP or secure HTTP protocols

Members also have an option of manually capturing Invoice information on IS-WEB


Input output formats

Input & Output Formats

Files (upload & download)

IS-IDEC-Passenger and Cargo

IS-XML-Passenger, Cargo, Miscellaneous and UATP

IS-WEB-All

Others – Usage File for Pax

All formats contain same fields for a given record type

Billing participant can use any format at any time (“input combination”)

Billing participant choice doesn’t affect billed participant (“format conversion”)

Billing participant may submit billing data as often as they want

Billing data files to be uploaded to IS via iiNetor secure FTP

Record layouts and descriptions are documented in the Integrated Settlement Participant Guide (ISPG) located at:

http://www.iata.org/whatwedo/finance/clearing/sis/Pages/materials-ISPG.aspx

SIS P3 – Bejing Workshop - SIS Functional Review

9


File formats is idec

File Formats – IS-IDEC

No longer data exchange file, but rather used to create an invoice and settlement file

Similar to IDEC, with enhancements:

Existing fields made mandatory (source codes, etc)

New records added (Rejection Memos, tax breakdowns, etc)

New fields added (for e-billing, additional info, etc)

Unnecessary records / fields removed (batch total records, etc)

500 byte records (instead of 160 byte)

Every carrier will need system enhancements to support IS-IDEC

SIS P3 – Bejing Workshop - SIS Functional Review

10


File formats is xml

File Formats – IS-XML

New XML format for Integrated Settlement

Based on IATA Aviation Invoice Standard, used by IATA InvoiceWorks

Identical fields and validation requirements to IS-IDEC

Every carrier will need to make system enhancements to support IS-XML

IS-IDEC vs. IS-XML is an IT decision – it is immaterial to the RA department

Potential Benefits of IS-XML

IS-XML format is more flexible and thus better than IS-IDEC for variable record structure (like miscellaneous billings)

Potential Benefits of IS-IDEC

Relatively little system development for carriers with a sophisticated IDEC solution in place already

IS-IDEC format is more efficient (processing, storage, and internet bandwidth) than IS-XML for a fixed record structure

SIS P3 – Bejing Workshop - SIS Functional Review

11


Breakdown records

Breakdown Records

Breakdown Records have been added where necessary to provide for detailed, possibly repeating, data and to provide for large amounts of text

E.g., a coupon can have 0 or more tax breakdown records, each detailing a tax type and amount

Examples

Coupon Prime Billing breakdown records:

Tax, VAT breakdown

Breakdown records for Rejection, Billing, Credit Memos:

Reason Breakdown, Coupon Breakdown (with Tax & VAT)

SIS P3 – Bejing Workshop - SIS Functional Review

12


Example breakdowns pax rejection memo

Example Breakdowns (Pax Rejection Memo)

Rejection Memo

(SFI = 21)

Reason Breakdown

(SFI = 31)

Coupon Breakdown

(SFI = 32)

VAT Breakdown

(SFI = xx)

Reason Breakdown

(SFI = 31)

Coupon Breakdown

(SFI = 32)

VAT Breakdown

(SFI = xx)

Coupon Breakdown

(SFI = 32)

VAT Breakdown

(SFI = 34)

Tax Breakdown

(SFI = 33)

Tax Breakdown

(SFI = 33)

Tax Breakdown

(SFI = 41)

SIS P3 – Bejing Workshop - SIS Functional Review

13


Is web

IS-WEB

Web-based user interface to create and receive invoices and records

Identical fields and validation requirements to IS-IDEC and IS-XML

Validation in real-time minimizes possibility of later validation errors

Potential Benefits

The web interface is hosted by IATA, so no system development is required by carriers

Potential Negatives

More internet bandwidth will be required than file formats, and the connection will have to be stable

IS transaction fees 25% higher

 Not an alternative to a Revenue Accounting system

SIS P3 – Bejing Workshop - SIS Functional Review

14


Sis simplified interline settlement sis functional review

Validation

SIS P3 – Bejing Workshop - SIS Functional Review


Validation

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Validation

Integrated Settlement

Validation:

  • Guarantees links between records (e.g. 2nd and 1st RMs)

  • Enforces timeframes and “order” (1st RM -> 2nd RM -> 3rd RM)

  • Ensures file is properly formed

  • Other validations

IS-WEB

IS-WEB

Billed

Entity

Billing

Entity

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

Send files

(or enter online)

Receive (or download) invoices

Validation

Format Conversion

SIS P3 – Bejing Workshop - SIS Functional Review


Sanity check first then validation

Sanity Check First, Then Validation

  • Files will go through and must pass, “Sanity Check” before moving to the next, more rigorous, “Validation” process

  • Sanity Check will:

    • Check for formatting issues

  • Validation will:

    • If errors encountered, file will continue to go through Validation process and report all errors

      • In IS-WEB

      • Email with validation error report (in detail) as per Member Profile

    • Take up to 4 hours to complete

      • CAUTION: Be sure to finalize your invoices allowing enough time for validation to complete and time to correct any errors before the submission deadline (same as Recap Sheet due date and time)

SIS P3 – Bejing Workshop - SIS Functional Review


Examples of validation

Examples of Validation

Format Rules

Ensures data types (e.g. numeric/alphanumeric), length, etc as defined

Correct Values

e.g. Settlement method cannot be “ACH” if both airlines are only ICH members

Mandatory Fields

Source Code, Ticket Issuing Airline, Coupon Number, etc

Rejection & Correspondence Timeframes and Order Enforced

1st RM  2nd RM  3rd RM  Correspondence

Mandatory Breakdown Records Are Present

Tax breakdown records are present if coupon tax is populated and the breakdown record sums match the tax field

Billing entity will be notified of validation results

Invoices (and possibly files) failing validation will not go any further

SIS P3 – Bejing Workshop - SIS Functional Review

18


After validation

After Validation

Validated invoice billing totals sent to the ACH for settlement

Clearing House will combine the IS billing totals with the Recap Sheet billing totals and settle the combined totalCAUTION: Do not add IS billing totals to a Recap Sheet or it will be billed to the other participant TWICE

The billed participant may retrieve their billed and settled invoices data via the IS Web(At period end – as per IS Calendar)

The billed participant will be able to retrieve their billed data files (At period end – as per IS Calendar)

The billed participant will receive a billing file at the end of each period instead of one time per month

SIS P3 – Bejing Workshop - SIS Functional Review

19


Sis simplified interline settlement sis functional review

Correspondence

SIS P3 – Bejing Workshop - SIS Functional Review


Correspondence

Correspondence

Settlement Processes

ICH

ACH

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Integrated Settlement

IS-WEB

IS-WEB

Billed

Airline

Billing

Airline

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Central

Repository

Prorate

Engine

Usage File

Enter Correspondence

(including attachments)

Receive Correspondence

(including attachments)

Validation

SIS P3 – Bejing Workshop - SIS Functional Review

21


Correspondence1

Correspondence

Correspondence can include an “authority to bill” flag which identifies when the authority to bill has been granted

Not tied to settlement periods like transactions in Integrated Settlement – real-time and similar to e-mail but via IS-WEB interface

Notifications sent when Correspondence has been created and sent to you

Additional notifications sent when time limits are set to expire

Validation ensures

no “cross-over” – correspondence

can only be in reply to another correspondence (or 3rd-stage RM Pax and Cargo or 2nd stage RM ACH non transport)

cannot be out-of-order

SIS P3 – Bejing Workshop - SIS Functional Review

22


Sis simplified interline settlement sis functional review

Supporting Documents

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents

Supporting Documents

Supporting documents can be attached to most record types (including Pax Prime Billings, Cargo, miscellaneous)

Two types of supporting documents:

Electronic Presentation - Supporting document that is digital but not in a defined and structured format. The document might be a PDF file or an image that a computer can read but not extract data from.

E-Electronic Document – Supporting document that is in a defined and structured format which can be parsed by a computer. Example formats are IDEC, XML, or CSV.

SIS P3 – Bejing Workshop - SIS Functional Review

24


Supporting documents with is

Supporting Documents – With IS

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Integrated Settlement

IS-WEB

IS-WEB

Billed

Airline

Billing

Airline

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

Batch Transfer

e.g. FTP

Batch Transfer

e.g. FTP

SIS P3 – Bejing Workshop - SIS Functional Review

25


Central repository supporting docs

Central Repository & Supporting Docs

What?

Any type of accepted supporting document (image, PDF, etc)

How long?

As long as the data is operationally required

When?

Before or after the associated record is uploaded (with “pending attachments” flag, which allows for notifications if not uploaded)

SIS P3 – Bejing Workshop - SIS Functional Review

26


Sis simplified interline settlement sis functional review

Audit Trail

SIS P3 – Bejing Workshop - SIS Functional Review


Audit trail rejection history

Audit Trail & Rejection History

With operational data being stored:

Future records (e.g. rejections) don’t need supporting documents re-attached

IS-WEB can be used to search and take action on previous billings:

Search & browse through all records for which your carrier billed or was billed

Drill down through tickets, coupons, tax breakdowns, correspondences, etc

View audit trail of linked correspondences, rejections, and prime billings

Find outgoing correspondences that haven’t been responded to

Go directly to appropriate action (create RM, create correspondence, create billing memo)

SIS P3 – Bejing Workshop - SIS Functional Review

28


Sis simplified interline settlement sis functional review

Member Profile

SIS P3 – Bejing Workshop - SIS Functional Review


Bringing it all together

Bringing it All Together

  • Member Administration will contain centralized preferences for your company:

    • User Administration with the ability to create users and customize user permissions

    • Member Profile to set your own preferences, such as:

      • Who to contact for IS alerts, file validation failures, etc

      • Rules as to how IS will operate for your company (apply digital signatures, allow corrections, etc)

  • Processing Dashboard will provide a centralized overview of all submitted files and their statuses throughout the Integrated Settlement

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Key Differences forCargo & Miscellaneous

SIS P3 – Bejing Workshop - SIS Functional Review


Key differences for cargo

Key Differences for Cargo

  • All Cargo record types also represented in IS-IDEC, IS-XML, and IS-WEB

  • The IATA e-Freight project will introduce e-electronic formats (structured data) for these supporting documents over time

  • Before then, carriers can bilaterally decide to use e-electronic formats, or to not transfer supporting documents at all

SIS P3 – Bejing Workshop - SIS Functional Review


Key differences for miscellaneous

Key Differences for Miscellaneous

  • IS-IDEC cannot be used for Miscellaneous billings (only IS-XML and IS-WEB)

  • All Miscellaneous and UATP billings are uniquely defined by a charge category and charge code, allowing for routing to the correct person/department, automatic posting, or even automatic reconciliation

  • UATP: carriers can opt-in to a service, where UATP-ATCAN will send the billing (via IS-XML) to SIS on behalf of the billing carriers.

  • Miscellaneous and UATP use Rejection Invoices (not Memos) and Credit Notes (not Memos)

  • Examples:

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Questions?

SIS P3 – Bejing Workshop - SIS Functional Review


Agenda1

Agenda

  • General & Basics

  • IS Functionality – more in detail

  • Special Cases

SIS P3 – Bejing Workshop - SIS Functional Review


Sis overview

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

SIS Overview

Integrated Settlement

IS-WEB

IS-WEB

Billed

Entity

Billing

Entity

“Digital

Signature”

Company

IS-XML

IS-XML

Overall Processes

Overall Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Only the functionality is shown, which you are allowed to use

(Member Profile – User – Permissions)

Alerts

(from the system and additionally sent by email to this user)

Upcoming Milestones

Messages from SIS-Operation

On behalf of

- SIS-Ops

- ICH Ops

- ACH Ops

Announcements

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Insight into IS(Integrated Settlement)

SIS P3 – Bejing Workshop - SIS Functional Review


Is integrated settlement

Integrated Settlement

Settlement Processes

IS-WEB

IS-WEB

ICH

ACH

Central

Repository

Billed

Entity

Billing

Entity

Billing & Invoicing Processes

“Digital

Signature”

Company

IS-XML

IS-XML

Billing

Record DB

Overall Processes

Overall Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

Processes at time of Sales

NFP

engine

ARC

COMPASS™

IS – Integrated Settlement

SIS P3 – Bejing Workshop - SIS Functional Review


Billing and invoicing process

Billing and Invoicing Process

ICH

ACH

IS-WEB

Interface

ICH

Interface

ACH

Validation

IS-WEB

Supp. Doc.

Invoice

PDF

Supp.

Doc.

IS-XML

Billing

Outward

IS-IDEC

Billing

Record DB

IS-XML

Supp.

Doc.

IS-IDEC

Supp.

Doc.

Digital

Signature

Billing Value

Confirmation

Validation &

Correction(IS-WEB)

Value Determination

& Auto-Billing

Usage File

Digital

Signature

DS Provider

Billing Carrier

ATPCO

ATPCO

SIS P3 – Bejing Workshop - SIS Functional Review


Is web for everybody

IS-WEB For Everybody

IS-WEB is also used for other web-based services

Audit Trail

Pax & Cargo & Miscellaneous Correspondence

Online Corrections after validation failure

Processing Dashboard

Airline profile updates

Web Analysis Reports

View and print invoices in a standard format

Extensive user access controls (your company’s administrator can grant detailed permissions)

SIS P3 – Bejing Workshop - SIS Functional Review

41


Is web various processes

Billing

Record DB

IS-WEB - Various Processes

Audit Trail

Correspondence

Member

Administration

Web Analysis

Reports

Processing

Dashboard

IS-WEB

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS P3 – Bejing Workshop - SIS Functional Review


Correspondence is sent immediately

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Correspondence is sent immediately

Integrated Settlement

IS-WEB

IS-WEB

Billed

Entity

Billing

Entity

“Digital

Signature”

Company

IS-XML

IS-XML

Overall Processes

Overall Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

IS Validation

SIS P3 – Bejing Workshop - SIS Functional Review


Is validation of data files 1 of 4

IS Validation of Data Files (1 of 4)

  • Sanity Checks (General)

    • File naming convention

    • Duplicate filename check

    • Successful Decompression of file

    • Invalid character set check

SIS P3 – Bejing Workshop - SIS Functional Review


Is validation of data files 2 of 4

IS Validation of Data Files (2 of 4)

  • Sanity Checks (IS-IDEC)

    • Bad Structure check (missing mandatory record/incorrect sequencing)

    • Missing mandatory fields within records check

    • Incorrect record length/counts/ data type check

    • Inclusion of Non-migrated transaction checks

  • Sanity Checks (IS-XML)

    • Check against XML schema definition file

    • Total number of Invoices and Total amounts listed in Transmission Summary

    • Inclusion of Non-migrated transaction checks

  • In case of Sanity Check Errors, the entire file is rejected. Invoice data is not loaded in the Billing Record Database.

SIS P3 – Bejing Workshop - SIS Functional Review


Is validation of data files 3 of 4

IS Validation of Data Files (3 of 4)

  • Detail Validation

    • Reference Data validation (e.g. Airline Codes, Airport Codes, Tax Codes, etc)

    • Settlement Details (e.g. Settlement Method Indicator, Currency of Clearance, etc)

    • Calculation of Total Values (e.g. Sum of all amounts specified at coupon level should be equal to the total amount of the respective Source Code, etc)

    • Billing Audit Trail check in case previous billing was through IS (e.g. Link information provided for a Rejection Memo, Rejection Stage, etc)

    • Invoice Number check to be unique within a Calendar year across Billing Categories (Pax, Cargo, UATP, Misc) for a Billing Entity

SIS P3 – Bejing Workshop - SIS Functional Review


Is validation of data files 4 of 4

IS Validation of Data Files (4 of 4)

  • All errors encountered are reported in the Validation Report

  • Validation report is made available in 2 to 4 hours of receipt of the Invoice File

  • Actions in case of Error

    • Sanity Check Error: Correct the errors reported and submit a fresh file

    • Non Correctable Error: Correct the errors reported and submit the Invoice/file

    • Correctable Error: If Online Correction option is used then Correct the error on IS-WEB and revalidate the Invoice OR Correct the errors reported and re-submit the Invoice/file

  • Note: Any online correction made only in IS will result in Billing Data to be out of sync with the Carrier’s Internal Accounting System

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Supporting Documents

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents 1 of 5

Supporting Documents (1 of 5)

  • 100% Paperless billings in SIS

    • Invoice data as well as Supporting Information to be in electronic format

  • If IS Format Invoice data provided then there is NO need to provide printed and/or scanned copies of:

    • Invoices

    • Listings (Coupon Listing, Rejection/Billing/Credit Memos etc)

    • Memos (Rejection/Billing/Credit Memos)

    • Paper Coupons to support Prime Billings

  • IS Format provide placeholders to provide

    • Detailed Reason for raising a Memo

    • Prorate Slip Details

  • Supporting Documents uploaded and linked in IS need not be re-uploaded while rejecting the billing. Only new Supp Docs (if any) need to be provided

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents 2 of 5

Supporting Documents (2 of 5)

  • Electronic File Type Supported

    • Plain text files (.txt and .csv)

    • Plain HTML files (.htm and .html) without any embedded hyperlinks or image file references

    • Rich Text files (.rtf)

    • Portable Document Format files (.pdf)

    • JPEG Image files (.jpg or .jpeg) – Min Resolution 200 dpi

    • TIFF Image files (.tif or .tiff) - Min Resolution 100 dpi

  • IS will only validate the file extension and not the content

  • Additional file formats accepted by the members can be specified in the Member Profile

  • Supporting Documents can be provided even after the Billing Period Closure till the Supporting Documents Linking Deadline timestamp

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents 3 of 5

Supporting Documents (3 of 5)

Linking of Supporting Documents

Manually linked on IS-WEB

Automatically Linked by IS if a Supporting Documents zip file with Index information (Folder based, CSV Index file based or XML Index file based) is provided

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents 4 of 5

Supporting Documents (4 of 5)

  • Automated Linking by IS

    • Reads the Index information provided in the Supporting Documents Zip file

    • Searches for the transaction referred by the Index file in its Billing Record Db

    • If a match found, links the Supporting Documents to the transaction

SIS P3 – Bejing Workshop - SIS Functional Review


Supporting documents 5 of 5

Supporting Documents (5 of 5)

  • IS will only consider transactions of Invoices which are successfully validated for Automatic Linking

  • IS will take care of timing issues

    • Supporting Document File submitted first and Invoice File (IS-IDEC, IS-XML) submitted later

    • Supporting Document File submitted and Invoice successfully validated later

  • In case IS not able to link documents due to invalid/incorrect Index information, correction of Index will be allowed through IS-WEB

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

IS Outputs

SIS P3 – Bejing Workshop - SIS Functional Review


Is outputs 1 of 2

IS Outputs (1 of 2)

  • IS Output files are made available to Billed Entities by the “Billing Output Generation Date” as published in the IS Calendar which is typically 3 days after Billing Period Closure

  • Outputs include:

    • Invoice Files in IS-IDEC and/or IS-XML format

    • As a Billed Participant :

      • PDF Copy of Invoices

      • Detailed Listings (Coupon listing, RM/BM/CM Listing... Etc)

      • Digital Signature and Other Legal files

      • Memo copies (RM, BM, CM)

      • Supporting Documents

SIS P3 – Bejing Workshop - SIS Functional Review


Is outputs 2 of 2

IS Outputs (2 of 2)

PAX-P-AA-0001-20120403

BA-0125

INV-ACBCE12345

E-INVOICE

LISTINGS

MEMOS

SUPPDOCS

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Questions?

SIS P3 – Bejing Workshop - SIS Functional Review


Agenda2

Agenda

  • General & Basics

  • IS Functionality – more in detail

  • Special Cases

SIS P3 – Bejing Workshop - SIS Functional Review


Sis simplified interline settlement sis functional review

Passenger

SIS P3 – Bejing Workshop - SIS Functional Review


Some of the changes

Some of the Changes

Source Codes

Are mandatory for all billings

Stages of rejections now have unique source codes

Rejections

Have rejection memo numbers

Standardized method to calculate and display billed, accepted and rejected amounts

Batches

No longer limited to 200 transactions. Expanded to 99,999

Numbers must be unique within an invoice, but not within a clearance period or clearance month

Invoices

Invoice number is A/N and XXXX in length; number must be unique, across all billing categories, for a calendar year

i.e.: Passenger invoice numbers cannot duplicate UATP, miscellaneous or Cargo invoice numbers

SIS P3 – Bejing Workshop - SIS Functional Review

66


Sampling

Sampling

Provisional Invoice (as today with prime coupon billing, but with elements from Forms A and B)

Coupon level taxes and breakdown records included in provisional billing

Universe Adjustment (Form C)

Digit Evaluation (Forms D and E)

Form G (ACH)

Rejection Memos & Correspondence (as today with non-sample but with elements from Forms F and XF)

All via IS-IDEC, IS-XML, and IS-WEB

Optional Service allows the billed airline to receive one monthly file for provisional billings; in addition to a file at the end of each period

SIS P3 – Bejing Workshop - SIS Functional Review

67


Processes at time of sales changes

Processes at time of Sales – Changes

NFP engine will be available to carriers for FIRST & FINAL™ (NFP Final) and non-F&F (NFP non-final) purposes (as today)

NFP non-final could minimize rejections without any obligation by the carriers

Additional fields have been added to the records

New Optional Functionalities

Own Prorate Switching and Storage process will allow

the sales carrier to send prorated coupons to ATPCO (Record 6)

which are then forwarded or made available to the addressed carrier (planned uplifting carrier)

Additionally carriers can have these values checked via the BVC (Billing Value Confirmation) process at time of billing

Storage: Coupon records are also stored in the ARC Compass database and can be used in Auto-Billing.

SIS P3 – Bejing Workshop - SIS Functional Review

68


Sis simplified interline settlement sis functional review

Billing Value Confirmation

SIS P3 – Bejing Workshop - SIS Functional Review


Pre idec validation now

Pre IDEC Validation – Now

Billed

Airline

Billing

Airline

Pre-IDEC Validation

for F&F NFP values

(updates the PMI)

ATPCO

Pax IDEC File (monthly)

Pax IDEC File (monthly)

(incl F&F pre IDEC

Validation)

prorate

engine

prorate

engine

ARC-Compass

(NFP storage)

GDSs

BSPs

Previously released sales record

F&F: receives NFP value

All: May receive sales records

AIA F&F

SIS P3 – Bejing Workshop - SIS Functional Review

70


Billing value confirmation with is

Billing Value Confirmation – With IS

Settlement Processes

ICH

ACH

ARC

COMPASS™

Integrated Settlement

IS-WEB

IS-WEB

Billed

Airline

Billing

Airline

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Central

Repository

Prorate

Engine

Usage File

Processes at time of Sales

NFP

engine

Billing Value Confirmation

(Leaves “Original PMI”, updates “Value Confirmation PMI”)

SIS P3 – Bejing Workshop - SIS Functional Review

71


Sis simplified interline settlement sis functional review

Value Determination

&

Auto-Billing

SIS P3 – Bejing Workshop - SIS Functional Review


Value determination

Value Determination

Settlement Processes

ICH

ACH

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Integrated Settlement

IS-WEB

IS-WEB

Billed

Airline

Billing

Airline

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Central

Repository

Prorate

Engine

Usage File

Usage File

Prorate Values

SIS P3 – Bejing Workshop - SIS Functional Review

73


Auto billing

Auto-Billing

Settlement Processes

ICH

ACH

Central

Repository

Processes at time of Sales

NFP

engine

ARC

COMPASS™

Integrated Settlement

No Billing File

From Carrier

IS-WEB

IS-WEB

Billed

Airline

Billing

Airline

“Digital

Signature”

Company

IS-XML

IS-XML

Enabling Processes

Enabling Processes

Billing & Invoicing Processes

IS-IDEC

IS-IDEC

Prorate

Engine

Usage File

Usage File

Billing and Invoice Files

Created Within IS

Daily Revenue Recognition File

Weekly Invoice Posting File

SIS P3 – Bejing Workshop - SIS Functional Review

74


Sis simplified interline settlement sis functional review

Questions?

SIS P3 – Bejing Workshop - SIS Functional Review


Thank you

Questions?

We’d be glad to address all your questions through the SIS Forums, register for an account at:

www.iata.org/SISForum

Thank you.

SIS P3 – Bejing Workshop - SIS Functional Review

76

February 2011


  • Login