Transcript Introduction to SIS

Introduction to SIS
RA43
James Shannon, IATA
Goal & Agenda
To familiarize you with Simplified Interline Settlement and prepare you for
tomorrow’s breakout sessions
 Project Overview
 The Need For IS
 Vision
 IS Solution & Features
 Benefits & Changes
 Next Steps
SIS P3 – Materials – RA43 Intro to SIS
2
September 2009
Project Overview
SIS P3 – Materials – RA43 Intro to SIS
4
September 2009
Interline Settlement - Today
Paper invoices, with coupon listing, coupons, rejects, supporting documents
(monthly)
Settlement sheets –
(weekly)
F3– (weekly)
Billed
Entity
Cargo IDEC File (monthly)
Pax IDEC File (monthly)
prorate
engine
GDSs
BSPs
ACH
ICH
ATPCO
(incl F&F pre IDEC
Validation)
F12 – (weekly)
F1 – net amounts of inv
F2 - summary
Cargo IDEC File (monthly)
Billing
Entity
Pax IDEC File (monthly)
prorate
engine
ARC-Compass
(NFP storage)
AIA F&F
SIS P3 – Materials – RA43 Intro to SIS
Recap sheets - weekly
5
F&F: receives NFP value
September 2009
SIS Vision
Fundamentally change, simplify and integrate the interline settlement
process, delivering tangible financial benefits to the industry.




Invoices are electronic and not backed by paper
Prime passenger billings do not require paper invoices or coupon listings
IDEC formats are maintained with increased record types
Passenger rejects, including any attachments, are submitted electronically
without paper
 Cargo and Mail billings are electronic and paperless
 Miscellaneous billings (including any supporting information) are electronic,
whether as data or with attachments
 Settlement action directly from ET systems is enabled
SIS P3 – Materials – RA43 Intro to SIS
6
September 2009
SIS Phase 3
Phase 1
Feasibility
Phase 2
Requirements
Development
Phase 3
Implementation
 Phase 1 – Feasibility followed FC96 in May 2007
 Phase 2 – Requirements Development ran from December 2007-July 2008. Included
the initial RFI
 Phase 3 was too large to handle as a single operation, and was split:
 Phase 3a became the RFP and selection process, from which the Kale/iPayables
proposal was chosen
 Phase 3b is the current System Design and requirements finalisation phase
 Phase 3c is the System Development and Pilot testing
SIS P3 – Materials – RA43 Intro to SIS
7
September 2009
Phase 3 - Steering & Working Groups
Airline participation has been essential to the progress that SIS had made:
 Steering Group
 Passenger WG
 Cargo WG
 Miscellaneous WG
 IT WG
 Over 60 participants from over 30 carriers
 ICH Operations WG
SIS P3 – Materials – RA43 Intro to SIS
8
September 2009
IS
Solution & Features
SIS P3 – Materials – RA43 Intro to SIS
9
September 2009
Interline Settlement - Today
Paper invoices, with coupon listing, coupons, rejects, supporting documents
(monthly)
Settlement sheets –
(weekly)
F3– (weekly)
Billed
Entity
Cargo IDEC File (monthly)
Pax IDEC File (monthly)
prorate
engine
GDSs
BSPs
ACH
ICH
ATPCO
(incl F&F pre IDEC
Validation)
F12 – (weekly)
F1 – net amounts of inv
F2 - summary
Cargo IDEC File (monthly)
Billing
Entity
Pax IDEC File (monthly)
prorate
engine
ARC-Compass
(NFP storage)
AIA F&F
SIS P3 – Materials – RA43 Intro to SIS
Recap sheets - weekly
10
F&F: receives NFP value
September 2009
Integrated Settlement
Integrated Settlement
Settlement Processes
Billed
Entity
IS-IDEC
Overall Processes
IS-XML
ICH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
SIS –
P3Materials
– Materials
– RA42
– RA43
Breakout
Intro toInterfaces
SIS
& Validation
IS-WEB
ACH
Overall Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Entity
Prorate
Engine
NFP
engine
11
September 2008
2009
No F12 files.
No recap sheets, either.
Nothing that you submit to the ICH or ACH today can be submitted after migration.
SIS P3 – Materials – RA43 Intro to SIS
12
September 2009
Main Features of IS
 File Formats & Validation
 Passenger





Time of Sales – NFP final, NFP non-final, and Own Prorate Storage
Value Determination & Autobilling
Sampling
Correspondence
Audit Trail
 Differences for Cargo
 Differences for Miscellaneous
 Bringing It All Together
 Member Administration
 Processing Dashboard
 Document Storage
SIS P3 – Materials – RA43 Intro to SIS
13
September 2009
File Formats &
Validation
SIS P3 – Materials – RA43 Intro to SIS
14
September 2009
File Formats
Integrated Settlement
Settlement
Processes
Format
Conversion:
 Billed Entity’s choice of format
ACH
doesICH
not depend on
the billing
carrier’s
Billed
Entity
IS-IDEC
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Receive (or download)
invoices
SIS P3 – Materials – RA43 Intro to SIS
IS-WEB
Enabling Processes
IS-XML
Enabling Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Entity
Prorate
Engine
NFP
engine
Validation
Format Conversion
15
Send files
(or enter online)
September 2009
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 – Materials – RA43 Intro to SIS
17
September 2008
2009
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 – Materials – RA43 Intro to SIS
18
September 2008
2009
IS-WEB Record Structure
 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
 Won’t be as user-friendly as a dedicated, local system
 Not an alternative to a Revenue Accounting system
SIS P3 – Materials – RA43 Intro to SIS
19
September 2008
2009
IS-WEB For Everybody
IS-WEB is also used for other web-based services
 Audit Trail
 Pax & Cargo 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 – Materials – RA43 Intro to SIS
20
September 2008
2009
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 – Materials – RA43 Intro to SIS
21
September 2008
2009
Example Breakdowns (Pax Rejection Memo)
Rejection Memo
(SFI = 21)
Reason Breakdown
= 31)
Reason(SFI
Breakdown
(SFI = 31)
Coupon Breakdown
(SFI
= 32)
Coupon
Breakdown
(SFI
= 32)
Coupon
Breakdown
(SFI = 32)
VAT Breakdown
= xx)
VAT (SFI
Breakdown
= xx)
VAT (SFI
Breakdown
(SFI = 34)
Tax Breakdown
= 33)
Tax (SFI
Breakdown
(SFI = 33)
Tax Breakdown
(SFI = 41)
SIS P3 – Materials – RA43 Intro to SIS
22
September 2008
2009
Validation
Integrated Settlement
Settlement Processes
Validation:
Billed
Entity
IS-IDEC
 Guarantees links between
ICH
ACH
records (e.g. 2nd and 1st RMs)
 Enforces timeframes and
“Digital
“order” (1stSignature”
RM -> 2nd RM -> 3rd
RM)
Company
 Ensures file is properly formed
 Billing
Other&validations
Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Receive (or download)
invoices
SIS P3 – Materials – RA43 Intro to SIS
IS-WEB
Enabling Processes
IS-XML
Enabling Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Entity
Prorate
Engine
NFP
engine
Validation
Format Conversion
23
Send files
(or enter online)
September 2009
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 – Materials – RA43 Intro to SIS
25
September 2008
2009
Passenger
SIS P3 – Materials – RA43 Intro to SIS
26
September 2009
Time of Sales – Now (Optional)
Settlement sheets –
(weekly)
ACH
F3– (weekly)
ICH
Billed
Airline
Recap sheets - weekly
F12 – (weekly)
F1 – net amounts of inv
F2 - summary
ATPCO
Pax IDEC File (monthly)
prorate
engine
GDSs
BSPs
Sales Records
(incl F&F pre IDEC
Validation)
Pax IDEC File (monthly)
prorate
engine
ARC-Compass
(NFP storage)
AIA F&F
Billing
Airline
F&F: receives NFP value
All: May receive sales records
Sales Records,
NFPs
Optional Proration,
Storage, Switching
SIS P3 – Materials – RA43 Intro to SIS
27
September 2008
2009
Time of Sales – With IS
Integrated Settlement
Settlement Processes
Billed
Airline
IS-IDEC
Enabling Processes
IS-XML
ICH
IS-WEB
ACH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Enabling Processes
IS-WEB
Processes at time of Sales
Sales Records or
Own Prorates
SIS P3 – Materials – RA43 Intro to SIS
ARC
COMPASS™
NFP
engine
Optional Proration (final &
non-final), Storage, Switching
28
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
Sales Records,
NFPs, &
Sales Carrier’s
Own Prorates
September 2008
2009
Neutral Fare Prorates – With IS
 NFP engine will be available to carriers for FIRST & FINAL™ (NFP Final) and non-F&F
(NFP non-final) purposes
 NFP non-final could minimize rejections without any obligation by the carriers
 Own prorate storage and switching will allow the sales carrier to upload prorates, which
are then forwarded or made available to the billing carrier
SIS P3 – Materials – RA43 Intro to SIS
29
September 2008
2009
Time of Billing – Now
Pre-IDEC Validation
for F&F NFP values
Billed
Airline
(updates the PMI)
ATPCO
Pax IDEC File (monthly)
prorate
engine
GDSs
BSPs
(incl F&F pre IDEC
Validation)
Pax IDEC File (monthly)
prorate
engine
ARC-Compass
(NFP storage)
AIA F&F
SIS P3 – Materials – RA43 Intro to SIS
Billing
Airline
30
F&F: receives NFP value
All: May receive sales records
September 2008
2009
Submitting Billing Information – With IS
Integrated Settlement
Billing File / Data
Settlement Processes
IS-WEB
IS-IDEC
Enabling Processes
Billed
Airline
ICH
(similar to today)
IS-WEB
ACH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Enabling Processes
(similar to today)
IS-XML
Billing File / Data
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
NFP
engine
Billing Value Confirmation
(Leaves “Original PMI”, updates “Value Confirmation PMI”)
SIS P3 – Materials – RA43 Intro to SIS
31
September 2008
2009
Time of Billing – IS Value Determination
Integrated Settlement
Billing File / Data
Settlement Processes
IS-WEB
IS-IDEC
Enabling Processes
Billed
Airline
ICH
(similar to today)
IS-WEB
ACH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
NFP
engine
Enabling Processes
(similar to today)
IS-XML
Billing File / Data
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
Usage File
Prorate Values
SIS P3 – Materials – RA43 Intro to SIS
32
September 2008
2009
Time of Billing – IS Auto-Billing
Integrated Settlement
Billing File / Data
Settlement Processes
IS-WEB
IS-IDEC
Enabling Processes
Billed
Airline
ICH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Billing and Invoice Files
Created Within IS
IS-WEB
ACH
NFP
engine
Enabling Processes
(similar to today)
IS-XML
No Billing File
From Carrier
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
Usage File
Daily Revenue Recognition File
Weekly Invoice Posting File
SIS P3 – Materials – RA43 Intro to SIS
33
September 2008
2009
Sampling
 Provisional Invoice (as today with prime coupon billing, but with elements from Forms
A and B)
 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
SIS P3 – Materials – RA43 Intro to SIS
34
September 2008
2009
Pax & Cargo Correspondence
Integrated Settlement
Settlement Processes
Billed
Airline
IS-IDEC
Enabling Processes
IS-XML
ICH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Receive Correspondence
(including attachments)
SIS P3 – Materials – RA43 Intro to SIS
IS-WEB
ACH
Enabling Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
NFP
engine
Validation
35
Enter Correspondence
(including attachments)
September 2008
2009
Pax & Cargo Correspondence
 Correspondence can include an “authority to bill” flag which identifies when
the authority to bill has been issued
 Not tied to settlement periods like transactions in Integrated Settlement –
real-time and similar to e-mail but via IS-WEB interface
 Validation ensures no “cross-over” – correspondence can only be in reply to
another correspondence (or 3rd-stage RM) and cannot be out-of-order
SIS P3 – Materials – RA43 Intro to SIS
36
September 2008
2009
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 – Materials – RA43 Intro to SIS
37
September 2008
2009
Audit Trail (example view)
Activity
Date
Record / Supporting Docs
1st Correspondence
1 May
$35; “I do not agree with your calculation…”
3rd Rejection
1 Apr
$50; Long Explanation.doc
2nd Rejection
1 Mar
$100; “See attached”; ticket.jpg
1st Rejection
1 Feb
$100; “No coupon in our system”
Prime Billing
1 Jan
$100
Create Correspondence
SIS P3 – Materials – RA43 Intro to SIS
38
September 2008
2009
Key Differences for
Cargo & Misc
SIS P3 – Materials – RA43 Intro to SIS
39
September 2009
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 – Materials – RA43 Intro to SIS
40
September 2009
Key Differences for Miscellaneous
 IS-IDEC cannot be used for Miscellaneous billings (only IS-XML and IS-WEB)
 All Miscellaneous 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
 Examples:
SIS P3 – Materials – RA43 Intro to SIS
Charge Category
Charge Code
GroundHandling
Baggage
GroundHandling
Cargo
PartnerAlliance
FF Miles
41
September 2009
Bringing it Together
SIS P3 – Materials – RA43 Intro to SIS
42
September 2009
Bringing it All Together
 Member Administration will contain centralized preferences for your
company:
 User Administration with the ability to create users and roles, customize user
permissions
 Member Profile to set your own preferences, such as:
 Who to contact for ICH 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 – Materials – RA43 Intro to SIS
43
September 2009
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 – Materials – RA43 Intro to SIS
44
September 2008
2009
Supporting Documents – With IS
Integrated Settlement
Settlement Processes
Billed
Airline
IS-IDEC
Enabling Processes
IS-XML
ICH
“Digital
Signature”
Company
Billing & Invoicing Processes
Central
Repository
Processes at time of Sales
Batch Transfer
e.g. FTP
SIS P3 – Materials – RA43 Intro to SIS
IS-WEB
ACH
ARC
COMPASS™
NFP
engine
45
Enabling Processes
IS-WEB
IS-XML
Billing
Airline
IS-IDEC
Prorate
Engine
Usage
File
Batch Transfer
e.g. FTP
September 2008
2009
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)
 How?
 Discussed in more detail during the Breakout Sessions
SIS P3 – Materials – RA43 Intro to SIS
46
September 2008
2009
Benefits & Changes
SIS P3 – Materials – RA43 Intro to SIS
47
September 2009
Key Benefits of IS – Billing Carrier
 Substantial savings due to:





Reduction in paper, postage and courier fees
Reduction in internal paper handling and supply chain efforts
No more loss of supporting documents and re-creation of invoices
Automation of billing directly from uplifts (e.g. Auto-Billing)
Optional à la carte service of “Integrated Settlement”
SIS P3 – Materials – RA43 Intro to SIS
48
September 2009
Key Benefits of IS – Billed Carrier
Substantial savings due to:
 Reduction in internal paper handling and supply chain efforts
(e.g. registration, and reconciliation of invoices to payment)
 Automated data
 Less manual intervention
 Data quality improvements on IS-IDEC
 Pax Rejection Memos, Billing and Credit Memo electronically
 Cargo Original AWB, Rejection and Charge Memo electronically
 Supporting Documents immediately available in electronic
presentation
SIS P3 – Materials – RA43 Intro to SIS
49
September 2009
Key Benefits of IS
 Rejection Memo & Correspondence process improvements due to:
 Enforcement of RAM rules (RM stage and correspondence)
 Opportunity to detect duplicate rejections of the same original billing
 All rejections and correspondence link to previous billings; information and
supporting documents do not have to be re-uploaded
 Time-limit reduction possibilities for Rejection Memos and Correspondence
 Risk management and process improvements due to:
 Fewer items outstanding for a shorter period of time
 Future potential time-limit reduction for prime / original billings
 Benefits to the environment due to reduction of paper and shipping
 Alliance objectives complemented by SIS
SIS P3 – Materials – RA43 Intro to SIS
50
September 2009
Airline Changes (where applicable)
 Change from IDEC to IS-IDEC




500 bytes instead of 160 bytes
Follow rules in RAM
Some detail records mandatory (e.g. taxes)
Other elements mandatory (e.g. Source Code)
 Choose and implement other submission formats (IS-XML, IS-WEB)
 Prepare to scan and upload supporting documents
 Implement e-billing (possible legal implications)
SIS P3 – Materials – RA43 Intro to SIS
51
September 2009
Next Steps
SIS P3 – Materials – RA43 Intro to SIS
52
September 2009
Next Steps
This Week
 Breakout Sessions
Back at Your Office
 Airline Business Case (on the SIS website)
 IS Participation Guide (see the breakout session)
 Internal Planning and Budgeting (based on the IS Participation Guide and
the Migration breakout session)
SIS P3 – Materials – RA43 Intro to SIS
53
September 2009
Thank you.
Email:
[email protected]
SIS Website:
www.iata.org/sis
SIS P3 – Materials – RA43 Intro to SIS
54
September 2009