SIS Simplified Interline Settlement IS Functionality

SIS – Simplified Interline Settlement IS Functionality – How IS works? 15 th September 2010 Robin PAUL, Kale Consultants

Agenda Ö Ö Ö IS Overview Invoice Data Input IS Validation Supporting Documents IS Outputs Q&A SIS P 3 c – Materials – RA 44 IS Functionality 2 15 th Sept 2010

IS Overview SIS P 3 c – Materials – RA 44 IS Functionality 3 15 th Sept 2010

IS Overview IS-IDEC IS-XML Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality IS-IDEC / IS-XML Offline Archive File 4 15 th Sept 2010

Invoice Data Input SIS P 3 c – Materials – RA 44 IS Functionality 5 15 th Sept 2010

Invoice Data Input Ö 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 Passenger Cargo Miscellaneous UATP IS-IDEC - - IS-XML IS-WEB SIS P 3 c – Materials – RA 44 IS Functionality 6 15 th Sept 2010

IS Validation SIS P 3 c – Materials – RA 44 IS Functionality 7 15 th Sept 2010

IS Validation of Data Files (1 of 4) Accept Invoice Data Files Perform Sanity Checks Perform Detail Validation Further Processin g Ö Sanity Checks (General) Ö Ö File naming convention Duplicate filename check Successful Decompression of file Invalid character set check SIS P 3 c – Materials – RA 44 IS Functionality 8 15 th Sept 2010

IS Validation of Data Files (2 of 4) Ö Sanity Checks (IS-IDEC) Ö Sanity Checks (IS-XML) Ö 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 Ö 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 P 3 c – Materials – RA 44 IS Functionality 9 15 th Sept 2010

IS Validation of Data Files (3 of 4) Accept Invoice Data Files Perform Sanity Checks Perform Detail Validation Further Processin g Ö 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 P 3 c – Materials – RA 44 IS Functionality 10 15 th Sept 2010

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 P 3 c – Materials – RA 44 IS Functionality 11 15 th Sept 2010

Supporting Documents SIS P 3 c – Materials – RA 44 IS Functionality 12 15 th Sept 2010

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 P 3 c – Materials – RA 44 IS Functionality 13 15 th Sept 2010

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 P 3 c – Materials – RA 44 IS Functionality 14 15 th Sept 2010

Supporting Documents (3 of 5) Ö Linking of Supporting Documents Passenger Cargo Miscellaneous UATP Prime Billing Coupon Original AWB Rejection Memo Billing Memo Credit Memo Invoice Rejection Memo Billing Memo Credit Memo RM/BM/CM Coupon Breakdown Invoice RM/BM/CM Coupon Breakdown Ö 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 P 3 c – Materials – RA 44 IS Functionality 15 15 th Sept 2010

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 P 1 125 IN 231138 Loadsheet. pdf Jan 2010 P 1 125 IN 232339 Lounge-Access. jpg Jan 2010 P 1 157 PXB 133433 Loan. Details. txt SIS P 3 c – Materials – RA 44 IS Functionality 16 15 th Sept 2010

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 P 3 c – Materials – RA 44 IS Functionality 17 15 th Sept 2010

IS Outputs SIS P 3 c – Materials – RA 44 IS Functionality 18 15 th Sept 2010

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 P 3 c – Materials – RA 44 IS Functionality 19 15 th Sept 2010

IS Outputs (2 of 2) PAX-P-AA-0001 -20120403 BA-0125 INV-ACBCE 12345 E-INVOICE LISTINGS MEMOS SUPPDOCS SIS P 3 c – Materials – RA 44 IS Functionality 20 15 th Sept 2010

Thank you. Email: sis@iata. org SIS Website: www. iata. org/sis SIS P 3 c – Materials – RA 44 IS Functionality 21 15 th Sept 2010