sis – simplified interline settlement
DESCRIPTION
SIS – Simplified Interline Settlement. IS Functionality – How IS works? ICH UG 2010 – Breakout Session Robin PAUL, Kale Consultants. Agenda. IS Overview IS Validation Supporting Documents Digital Signature Process IS Outputs. 2. IS Overview. IS-XML. IS-XML Offline Archive File. - PowerPoint PPT PresentationTRANSCRIPT
SIS – Simplified Interline Settlement
IS Functionality – How IS works?
ICH UG 2010 – Breakout Session
Robin PAUL, Kale Consultants
Agenda IS Overview
IS Validation
Supporting Documents
Digital Signature Process
IS Outputs
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 2
IS Overview
Billing Entity
IS Validation
IS-XML
IS-WEB
Supporting Document
HandlerSupportingDocuments
Central Repository
Billing Record Db
ICHACH
Digital Signature / Verification
ATOS Worldline
Billed Entity
IS-XMLOffline Archive File
Generate PDF Invoice
Billing Record Db
Generate Settlement
File
IS-WEB
Central Repository Generate
Output Files
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 3
Agenda IS Overview
IS Validation
Supporting Documents
Digital Signature Process
IS Outputs
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 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
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 5
IS Validation of Data Files (2 of 4)
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.
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 6
IS Validation of Data Files (3 of 4)
Detail Validation Reference Data validation (e.g. Airline Codes, Airport Codes, etc)
Settlement Details (e.g. Settlement Method Indicator, Currency of Clearance, etc)
Billing Audit Trail check in case previous billing was through IS (e.g. Link information provided for a Rejection Invoice, Rejection Stage, etc)
Invoice Number check to be unique within a Calendar year across Billing Categories (Pax, Cargo, UATP, Misc) for a Billing Entity
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 7
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
IS Validation of Data Files (4 of 4)
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 8
Agenda IS Overview
IS Validation
Supporting Documents
Digital Signature Process
IS Outputs
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 9
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
Supporting Documents uploaded and linked in IS need not be re-uploaded while rejecting the Invoice. Only new Supp Docs (if any) need to be provided
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 10
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
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 11
Supporting Documents (3 of 5) Linking of Supporting Documents
Supporting documents are to be linked to the Miscellaneous Invoice
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
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 12
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
Billing Month Billed Airline Invoice No File Name
Jan 2010 P1 125 IN231138 Loadsheet.pdf
Jan 2010 P1 125 IN232339 Lounge-Access.jpg
Jan 2010 P1 157 PXB133433 LoanDetails.txt
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 13
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 IS-XML Invoice File 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
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 14
Agenda IS Overview
IS Validation
Supporting Documents
Digital Signature Process
IS Outputs
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 15
Digital Signature (DS) Process Optional Service provided by IS through ATOS Worldline
Trusted Company based in EU
Following DS related preference for can be defined in Member Profile
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 16
Digital Signature (DS) Process Following DS related preference for can be defined in Member Profile
Digital Signature (DS) Required on Invoices (Yes/No) If Yes: Is it only as a Billing Entity or as a Billed Entity or for both If Yes: Can be setup to consider Invoices of only specific countries for DS
Digital Signature Verification Required for Incoming invoices
Digital Signature applied based on the country of the Billing and Billed Entity specified on the Invoice
Digitally Signed Invoices as well as Verification log provided to the Billing and Billed Entity as part of the Weekly Output from IS
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 17
Agenda IS Overview
IS Validation
Supporting Documents
Digital Signature Process
IS Outputs
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 18
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 File in IS-XML format As a Billed Participant :
PDF Copy of Invoices (PDF Invoice with DS embedded if opted for) Line Item Detail Listings (PDF file format) Digital Signature Related files (DS Verification log file in XML format) Supporting Documents
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 19
IS Outputs (2 of 2)
MISC-P-AA-0001-20120403
UA-0016
INV-Z7B12345
E-INVOICE
LISTINGS
SUPPDOCS
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 20
Thank you
Email:
SIS Website:
www.iata.org/sis
October 2010SIS P3 – Materials – ICH UG 2010 IS Functionality 21