Transcript Introduction to SIS

Introduction to SIS
2009 ICH User Group
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 – ICHUG09 – Intro to SIS
2
ATH – 27/28 Oct 2009
Project Overview
SIS P3 – ICHUG09 – Intro to SIS
4
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
Recap sheets - weekly
5
F&F: receives NFP value
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
6
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
7
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
8
ATH – 27/28 Oct 2009
IS
Solution & Features
SIS P3 – ICHUG09 – Intro to SIS
9
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
Recap sheets - weekly
10
F&F: receives NFP value
ATH – 27/28 Oct 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
– ICHUG09
– RA42
– Intro
Breakout
to SIS Interfaces & Validation
IS-WEB
ACH
Overall Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Entity
Prorate
Engine
NFP
engine
11
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
12
ATH – 27/28 Oct 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 (remove)
Correspondence
Audit Trail
 Differences for Cargo
 Differences for Miscellaneous
 Bringing It All Together
 Member Administration
 Processing Dashboard
 Document Storage
SIS P3 – ICHUG09 – Intro to SIS
13
ATH – 27/28 Oct 2009
File Formats &
Validation
SIS P3 – ICHUG09 – Intro to SIS
14
ATH – 27/28 Oct 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 – ICHUG09 – 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)
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
17
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
18
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
19
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
20
ATH – 27/28 Oct 2009
Breakdown Records
 Breakdown Records have been added where necessary to provide for
detailed, possibly repeating, data or to provide for large amounts of text
 In PAX invoices, a coupon can have 0 or more tax breakdown records,
each detailing a tax type and amount
 In Misc invoices, a “Ground Handling – Cleaning” line item contains a
breakdown of line item detail records which show aircraft and route
information
SIS P3 – ICHUG09 – Intro to SIS
21
ATH – 27/28 Oct 2009
Example Breakdowns (Simplistic Misc Invoice)
Invoice
Invoice Header
Line Item
Line Item
Line Item Detail
Line Item Detail
Line Item
Line Item Detail
Tax Details
Tax Details
Attachment
Attachment
Tax Details
SIS P3 – ICHUG09 – Intro to SIS
23
Aircraft Details
Aircraft Details
Aircraft Details
ATH – 27/28 Oct 2009
Validation
Integrated Settlement
Settlement Processes
Validation:
Billed
Entity
IS-IDEC
 Guarantees links between
ICH
ACH
records (e.g. 2nd and 1st RMs,
Misc “referenced invoice #”)
“Digital
 Enforces timeframes
and
Signature”
st
nd
“order” (1 Company
RM -> 2 RM -> 3rd
RM)
 Billing
Ensures
file is properly
formed
& Invoicing
Processes
 Other validations
Central
Repository
Processes at time of Sales
ARC
COMPASS™
Receive (or download)
invoices
SIS P3 – ICHUG09 – 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
24
Send files
(or enter online)
ATH – 27/28 Oct 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 ICH-only members
 Mandatory Fields
 Line Item Net Price, 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 – ICHUG09 – Intro to SIS
26
ATH – 27/28 Oct 2009
Passenger
SIS P3 – ICHUG09 – Intro to SIS
27
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
28
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
ARC
COMPASS™
NFP
engine
Optional Proration (final &
non-final), Storage, Switching
29
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
Sales Records,
NFPs, &
Sales Carrier’s
Own Prorates
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
Billing
Airline
31
F&F: receives NFP value
All: May receive sales records
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
32
ATH – 27/28 Oct 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
Billing
Airline
IS-IDEC
Prorate
Engine
Usage
File
Usage File
Prorate Values
SIS P3 – ICHUG09 – Intro to SIS
33
ATH – 27/28 Oct 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
Billing
Airline
IS-IDEC
Prorate
Engine
Usage
File
Usage File
Daily Revenue Recognition File
Weekly Invoice Posting File
SIS P3 – ICHUG09 – Intro to SIS
34
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
IS-WEB
ACH
Enabling Processes
IS-WEB
IS-XML
IS-IDEC
Usage
File
Billing
Airline
Prorate
Engine
NFP
engine
Validation
36
Enter Correspondence
(including attachments)
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
38
ATH – 27/28 Oct 2009
Audit Trail (Misc example view)
Activity
Date
Details
2nd Rejection
1 Mar
Invoice #1290 Amount: $85
1st Rejection
1 Feb
Invoice #094834 Amount: $100
Original Invoice
1 Jan
Invoice: #1284 Amount: $100
Create Rejection
SIS P3 – ICHUG09 – Intro to SIS
40
ATH – 27/28 Oct 2009
Key Differences for
Cargo & Misc
SIS P3 – ICHUG09 – Intro to SIS
41
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
42
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
Charge Category
Charge Code
GroundHandling
Baggage
GroundHandling
Cargo
PartnerAlliance
FF Miles
----
----
43
ATH – 27/28 Oct 2009
Bringing it Together
SIS P3 – ICHUG09 – Intro to SIS
44
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
45
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
46
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
IS-WEB
ACH
ARC
COMPASS™
NFP
engine
47
Enabling Processes
IS-WEB
IS-XML
Billing
Airline
IS-IDEC
Prorate
Engine
Usage
File
Batch Transfer
e.g. FTP
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
48
ATH – 27/28 Oct 2009
Benefits & Changes
SIS P3 – ICHUG09 – Intro to SIS
49
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
50
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
51
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
52
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
53
ATH – 27/28 Oct 2009
Next Steps
SIS P3 – ICHUG09 – Intro to SIS
54
ATH – 27/28 Oct 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 – ICHUG09 – Intro to SIS
55
ATH – 27/28 Oct 2009
Thank you.
Email:
[email protected]
SIS Website:
www.iata.org/sis
SIS P3 – ICHUG09 – Intro to SIS
56
ATH – 27/28 Oct 2009