SIS-NairobiWS-SIS Functional Review

Document Sample
SIS-NairobiWS-SIS Functional Review Powered By Docstoc
					SIS – Simplified Interline Settlement
      SIS Functional Review
SIS Awareness Regional Workshop, Nairobi May 2011
              Adina MINCULESCU
          SIS Operations Manager, IATA
    Agenda

     General & Basics


     IS Functionality – more in detail


     Special Cases




SIS P3 – Nairobi Workshop - SIS Functional Review   2   May 2011
                                                    SIS Overview



SIS P3 – Nairobi Workshop - SIS Functional Review   3              May 2011
   Interline Settlement - Today
                                                           Paper invoices, with coupon listing, coupons, rejects, supporting documents
                                                                                             (monthly)



                                     Settlement sheets –                                            Recap sheets - weekly
                                           (weekly)                       ACH

                                        F3– (weekly)                                                    F12 – (weekly)
                                                                           ICH                      F1 – net amounts of inv
                    Billed                                                                               F2 - summary               Billing
                    Entity         Cargo IDEC File (monthly)           ATPCO                     Cargo IDEC File (monthly)          Entity
                                     Pax IDEC File (monthly)         (incl F&F pre IDEC         Pax IDEC File (monthly)
                      prorate                                            Validation)
                                                                                                                                         prorate
                      engine
                                                                                                                                         engine

                                                                   ARC-Compass
                          GDSs                                     (NFP storage)
                          BSPs
                                                                                                   F&F: receives NFP value
                                                                      AIA F&F


SIS P3 – Nairobi Workshop - SIS Functional Review                             4                                                                    May 2011
   Integrated Settlement
                                                                 Integrated Settlement

                                                                  Settlement Processes
                              IS-WEB                                 ICH                ACH                          IS-WEB


                                                                            “Digital
                                           Overall Processes




                                                                                                 Overall Processes
                               IS-XML                                      Signature”                                IS-XML
                                                                           Company
 Billed                                                                                                                        Billing
 Entity                                                        Billing & Invoicing Processes                                   Entity
                              IS-IDEC                                                                                IS-IDEC
                                                                           Central
                                                                           Repository
                                                                                                                               Prorate
                                                                                                                               Engine
                                                                                                                     Usage
                                                                Processes at time of Sales                            File
                                                                    ARC                  NFP
                                                                    COMPASS™            engine




SIS P3 – Nairobi Workshop - SIS Functional Review                                  5                                           May 2011
                                                    File Formats




SIS P3 – Nairobi Workshop - SIS Functional Review                  May 2011
File Formats
                                                                 Integrated Settlement

                                                                 Settlement Processes
                                                            Format Conversion:
                          IS-WEB                             Billed Entity’s choice of format                        IS-WEB
                                                                                  ACH
                                                               doesICH depend on the billing
                                                                     not
                                                               carrier’s
                                                                          “Digital
                                       Enabling Processes




                                                                                                 Enabling Processes
                          IS-XML                                         Signature”                                   IS-XML
                                                                         Company
   Billed                                                                                                                               Billing
   Entity                                                     Billing & Invoicing Processes                                             Entity
                          IS-IDEC                                                                                     IS-IDEC
                                                                         Central
                                                                         Repository
                                                                                                                                         Prorate
                                                                                                                                         Engine
                                                                                                                      Usage
                                                                Processes at time of Sales                             File
                                                                   ARC                 NFP
                                                                   COMPASS™           engine




Receive (or download)                                             Validation                                              Send files
invoices                                                      Format Conversion                                           (or enter online)

SIS P3 – Nairobi Workshop - SIS Functional Review                                     7                                                       May 2011
    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-IDEC             -           -
             IS-XML                           IS-XML          IS-XML       IS-XML
             IS-WEB                          IS-WEB           IS-WEB       IS-WEB



SIS P3 – Nairobi Workshop - SIS Functional Review      8                            May 2011
    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 iiNet or 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 – Nairobi Workshop - SIS Functional Review     9                                        May 2011
    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 – Nairobi Workshop - SIS Functional Review   10                            May 2011
    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 – Nairobi Workshop - SIS Functional Review   11                                     May 2011
    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 – Nairobi Workshop - SIS Functional Review                             May 2011
    Example Breakdowns (Pax Rejection Memo)
                                                    Rejection Memo
                                                       (SFI = 21)




     Reason Breakdown                           Coupon Breakdown        VAT Breakdown
         (SFI = 31)
    Reason Breakdown                                 (SFI = 32)
                                               Coupon Breakdown        VAT (SFI = xx)
                                                                           Breakdown
            (SFI = 31)                              (SFI = 32)
                                               Coupon Breakdown       VAT (SFI = xx)
                                                                          Breakdown
                                                     (SFI = 32)          (SFI = 34)


                                                  Tax Breakdown
                                                 Tax (SFI = 33)
                                                     Breakdown
                                                    (SFI = 33)
                                                Tax Breakdown
                                                    (SFI = 41)


SIS P3 – Nairobi Workshop - SIS Functional Review                13                     May 2011
    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 – Nairobi Workshop - SIS Functional Review    14                                      May 2011
                                                    Validation



SIS P3 – Nairobi Workshop - SIS Functional Review                May 2011
Validation
                                                                 Integrated Settlement

                                                                 Settlement Processes
                                                            Validation:
                          IS-WEB                             Guarantees links between                                 IS-WEB
                                                                     ICH             ACH
                                                               records (e.g. 2nd and 1st RMs)
                                                             Enforces timeframes and
                                                                            “Digital
                                       Enabling Processes




                                                                                                  Enabling Processes
                                                               “order” (1st RM -> 2nd RM -> 3rd
                                                                          Signature”
                          IS-XML                                                                                       IS-XML
                                                               RM)        Company
   Billed                                                    Ensures file is properly formed                                            Billing
   Entity                                                    Billing & Invoicing Processes
                                                               Other validations
                          IS-IDEC                                                                                      IS-IDEC
                                                                                                                                         Entity
                                                                         Central
                                                                         Repository
                                                                                                                                          Prorate
                                                                                                                                          Engine
                                                                                                                       Usage
                                                                Processes at time of Sales                              File
                                                                   ARC                  NFP
                                                                   COMPASS™            engine




Receive (or download)                                             Validation                                               Send files
invoices                                                      Format Conversion                                            (or enter online)

SIS P3 – Nairobi Workshop - SIS Functional Review                                     16                                                       May 2011
    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 – Nairobi Workshop - SIS Functional Review   17                                       May 2011
    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 – Nairobi Workshop - SIS Functional Review      18                                             May 2011
    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 total
                CAUTION: 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 – Nairobi Workshop - SIS Functional Review   19                                         May 2011
                                                    Correspondence



SIS P3 – Nairobi Workshop - SIS Functional Review    20              May 2011
Correspondence
                                                                Integrated Settlement

                                                                 Settlement Processes
                            IS-WEB                                  ICH                ACH                            IS-WEB


                                                                           “Digital
                                         Enabling Processes




                                                                                                 Enabling Processes
                            IS-XML                                        Signature”                                  IS-XML
                                                                          Company
     Billed                                                                                                                             Billing
     Airline                                                  Billing & Invoicing Processes                                             Airline
                            IS-IDEC                                                                                   IS-IDEC
                                                                          Central
                                                                          Repository
                                                                                                                                        Prorate
                                                                                                                                        Engine
                                                                                                                      Usage
                                                               Processes at time of Sales                              File
                                                                   ARC                   NFP
                                                                   COMPASS™             engine




Receive Correspondence                                              Validation                                          Enter Correspondence
(including attachments)                                                                                                 (including attachments)

  SIS P3 – Nairobi Workshop - SIS Functional Review                                    21                                                   May 2011
    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 – Nairobi Workshop - SIS Functional Review   22                            May 2011
                                                     Supporting
                                                     Documents



SIS P3 – Nairobi Workshop - SIS Functional Review   23            May 2011
    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 – Nairobi Workshop - SIS Functional Review   24                                   May 2011
Supporting Documents – With IS
                                                              Integrated Settlement

                                                               Settlement Processes
                          IS-WEB                                  ICH                ACH                            IS-WEB


                                                                         “Digital
                                       Enabling Processes




                                                                                               Enabling Processes
                          IS-XML                                        Signature”                                  IS-XML
                                                                        Company
   Billed                                                                                                                                      Billing
   Airline                                                  Billing & Invoicing Processes                                                      Airline
                          IS-IDEC                                                                                   IS-IDEC
                                                                        Central
                                                                        Repository
                                                                                                                                               Prorate
                                                                                                                                               Engine
                                                                                                                    Usage
                                                             Processes at time of Sales                              File
                                                                 ARC                   NFP
                                                                 COMPASS™             engine                                  Batch Transfer
                 Batch Transfer
                 e.g. FTP                                                                                                     e.g. FTP




SIS P3 – Nairobi Workshop - SIS Functional Review                                    25                                                            May 2011
    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 – Nairobi Workshop - SIS Functional Review   26                                        May 2011
                                                         Audit Trail



SIS P3 – Nairobi Workshop - SIS Functional Review   27                 May 2011
    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 – Nairobi Workshop - SIS Functional Review   28                       May 2011
                                                    Member Profile



SIS P3 – Nairobi Workshop - SIS Functional Review    29              May 2011
    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 – Nairobi Workshop - SIS Functional Review   30                                      May 2011
                                                    Key Differences for
                                                         Cargo &
                                                      Miscellaneous



SIS P3 – Nairobi Workshop - SIS Functional Review      31             May 2011
    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 – Nairobi Workshop - SIS Functional Review   32                             May 2011
    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:
                       Charge Category     Charge Code
                                    GroundHandling    Baggage
                                    GroundHandling    Cargo
                                    PartnerAlliance   FF Miles

SIS P3 – Nairobi Workshop - SIS Functional Review     33                               May 2011
                                                     Questions?



SIS P3 – Nairobi Workshop - SIS Functional Review   34            May 2011
    Agenda

     General & Basics


     IS Functionality – more in detail


     Special Cases




SIS P3 – Nairobi Workshop - SIS Functional Review   35   May 2011
 SIS Overview
                                                                Integrated Settlement

                                                                  Settlement Processes
                              IS-WEB                                ICH                 ACH                          IS-WEB


                                                                            “Digital
                                           Overall Processes




                                                                                                 Overall Processes
                               IS-XML                                      Signature”                                IS-XML
                                                                           Company
  Billed                                                                                                                       Billing
  Entity                                                       Billing & Invoicing Processes                                   Entity
                              IS-IDEC                                                                                IS-IDEC
                                                                          Central
                                                                          Repository
                                                                                                                               Prorate
                                                                                                                               Engine
                                                                                                                     Usage
                                                                Processes at time of Sales                            File
                                                                   ARC                   NFP
                                                                   COMPASS™             engine




SIS P3 – Nairobi Workshop - SIS Functional Review                                36                                            May 2011
                                                        Only the functionality is shown, which you
                                                                    are allowed to use
                                                         (Member Profile – User – Permissions)



               Upcoming Milestones                            Messages from SIS-Operation
                                                                  Alerts
                                                                        On behalf of
                                                         (from the system and
                                                                          - SIS-Ops
                                                      additionally sent by email to
                                                                          - ICH Ops
                                               Announcements   this user)
                                                                         - ACH Ops


SIS P3 – Nairobi Workshop - SIS Functional Review         37                                   May 2011
                                                         Insight into IS
                                                    (Integrated Settlement)




SIS P3 – Nairobi Workshop - SIS Functional Review       38               May 2011
 IS – Integrated Settlement
                                                                Integrated Settlement

                                                                  Settlement Processes
                              IS-WEB                                ICH                ACH                          IS-WEB


                                                                           “Digital
                                         Billing & Invoicing Processes
                                           Overall Processes




                                                                                                Overall Processes
                               IS-XML                                     Signature”                                IS-XML
                                                                          Company
  Billed                                                                                                                      Billing
  Entity                                                       Billing & Invoicing Processes                                  Entity
                              IS-IDEC                               Billing                                         IS-IDEC
                                                                          Central
                                                                    Record DB
                                                                          Repository
                                                                                                                              Prorate
                                                                                                                              Engine
                                                                                                                    Usage
                                                                Processes at time of Sales                           File
                                                                   ARC                  NFP
                                                                   COMPASS™            engine




SIS P3 – Nairobi Workshop - SIS Functional Review                               39                                            May 2011
      Billing and Invoicing Process
                                                    ICH             ACH

                                                                                                 IS-WEB

IS-WEB
                                              Interface           Interface    Validation
                                                 ICH                ACH                           Supp.
                     Invoice                                                                      Doc.
 Supp.
 Doc.
                       PDF                                                                       IS-XML

                                                                                                 IS-IDEC
IS-XML               Billing                          Billing
                    Outward                           Record DB                                   Supp.
IS-IDEC                                                                                           Doc.

 Supp.
 Doc.
                   Digital             Billing Value Validation &       Value Determination       Usage
                                                                                                   File
 Digital
Signature
                  Signature            Confirmation Correction (IS-WEB)    & Auto-Billing


            DS Provider                    ATPCO           Billing Carrier    ATPCO

SIS P3 – Nairobi Workshop - SIS Functional Review            40                               May 2011
    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 – Nairobi Workshop - SIS Functional Review   41                         May 2011
    IS-WEB - Various Processes

                                                     Billing
                Audit Trail                          Record DB




                                             Member              Web Analysis   Processing
          Correspondence
                                           Administration          Reports      Dashboard



                                                     IS-WEB

SIS P3 – Nairobi Workshop - SIS Functional Review           42                               May 2011
SIS P3 – NairobiWorkshop - -SIS Functional Review
         Bejing Workshop SIS Functional Review      43   May
                                                         April 2011
SIS P3 – NairobiWorkshop - -SIS Functional Review
         Bejing Workshop SIS Functional Review      44   May
                                                         April 2011
SIS P3 – NairobiWorkshop - -SIS Functional Review
         Bejing Workshop SIS Functional Review      45   May
                                                         April 2011
SIS P3 – NairobiWorkshop - -SIS Functional Review
         Bejing Workshop SIS Functional Review      46   May
                                                         April 2011
 Correspondence is sent immediately
                                                                Integrated Settlement

                                                                  Settlement Processes
                              IS-WEB                                ICH                 ACH                          IS-WEB


                                                                            “Digital
                                           Overall Processes




                                                                                                 Overall Processes
                               IS-XML                                      Signature”                                IS-XML
                                                                           Company
  Billed                                                                                                                       Billing
  Entity                                                       Billing & Invoicing Processes                                   Entity
                              IS-IDEC                                                                                IS-IDEC
                                                                          Central
                                                                          Repository
                                                                                                                               Prorate
                                                                                                                               Engine
                                                                                                                     Usage
                                                                Processes at time of Sales                            File
                                                                   ARC                   NFP
                                                                   COMPASS™             engine




SIS P3 – Nairobi Workshop - SIS Functional Review                                47                                            May 2011
SIS P3 – NairobiWorkshop - -SIS Functional Review
         Bejing Workshop SIS Functional Review      48   May
                                                         April 2011
                                                         IS Validation




SIS P3 – Nairobi Workshop - SIS Functional Review   49                   May 2011
    IS Validation of Data Files (1 of 4)
                 Accept                       Perform         Perform
                                                                            Further
                 Invoice                       Sanity          Detail
                                                                          Processing
                Data Files                    Checks         Validation

     Sanity Checks (General)
                File naming convention
                Duplicate filename check
                Successful Decompression of file
                Invalid character set check




SIS P3 – Nairobi Workshop - SIS Functional Review       50                             May 2011
    IS Validation of Data Files (2 of 4)
     Sanity Checks (IS-IDEC)                             Sanity Checks (IS-XML)
             Bad Structure check (missing                   Check against XML schema
              mandatory record/incorrect                      definition file
              sequencing)                                    Total number of Invoices and
             Missing mandatory fields                        Total amounts listed in
              within records check                            Transmission Summary
             Incorrect record length/counts/                Inclusion of Non-migrated
              data type check                                 transaction checks
             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 – Nairobi Workshop - SIS Functional Review   51                                 May 2011
    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 – Nairobi Workshop - SIS Functional Review       52                                     May 2011
    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 – Nairobi Workshop - SIS Functional Review   53                                     May 2011
                                                         Supporting
                                                         Documents




SIS P3 – Nairobi Workshop - SIS Functional Review   54                May 2011
    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 – Nairobi Workshop - SIS Functional Review   55                                    May 2011
    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 – Nairobi Workshop - SIS Functional Review   56                                    May 2011
    Supporting Documents (3 of 5)
     Linking of Supporting Documents
            Passenger                               Cargo             Miscellaneous   UATP
            Prime Billing Coupon                    Original AWB      Invoice         Invoice
            Rejection Memo                          Rejection Memo
            Billing Memo                            Billing Memo
            Credit Memo                             Credit Memo
            RM/BM/CM Coupon                         RM/BM/CM Coupon
            Breakdown                               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 P3 – Nairobi Workshop - SIS Functional Review            57                        May 2011
    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




SIS P3 – Nairobi Workshop - SIS Functional Review     58                                         May 2011
    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 – Nairobi Workshop - SIS Functional Review   59                                      May 2011
                                                         IS Outputs




SIS P3 – Nairobi Workshop - SIS Functional Review   60                May 2011
    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 – Nairobi Workshop - SIS Functional Review   61                          May 2011
    IS Outputs (2 of 2)
                                                         PAX-P-AA-0001-20120403
                                                                BA-0125
                                                            INV-ACBCE12345
                                                               E-INVOICE
                                                               LISTINGS
                                                                MEMOS
                                                              SUPPDOCS




SIS P3 – Nairobi Workshop - SIS Functional Review   62                     May 2011
                                                     Questions?



SIS P3 – Nairobi Workshop - SIS Functional Review   63            May 2011
    Agenda

     General & Basics


     IS Functionality – more in detail


     Special Cases




SIS P3 – Nairobi Workshop - SIS Functional Review   64   May 2011
                                                         Passenger



SIS P3 – Nairobi Workshop - SIS Functional Review   65               May 2011
    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 – Nairobi Workshop - SIS Functional Review            66                                                  May 2011
    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 – Nairobi Workshop - SIS Functional Review      67                                      May 2011
    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 – Nairobi Workshop - SIS Functional Review   68                                 May 2011
                                                    Billing Value
                                                    Confirmation



SIS P3 – Nairobi Workshop - SIS Functional Review   69              May 2011
   Pre IDEC Validation – Now
                                                     Pre-IDEC Validation
                                                     for F&F NFP values
                                                          (updates the PMI)
                    Billed                                                                                              Billing
                    Airline                                       ATPCO                                                 Airline
                                     Pax IDEC File (monthly)    (incl F&F pre IDEC   Pax IDEC File (monthly)
                      prorate                                       Validation)
                                                                                                                         prorate
                      engine
                                                                                                                         engine

                                                               ARC-Compass
                          GDSs                                 (NFP storage)
                          BSPs
                                                                                          F&F: receives NFP value
                                                                 AIA F&F               All: May receive sales records




SIS P3 – Nairobi Workshop - SIS Functional Review                      70                                                          May 2011
   Billing Value Confirmation – With IS
                                                              Integrated Settlement

                                                               Settlement Processes
                          IS-WEB                                  ICH                ACH                            IS-WEB


                                                                         “Digital
                                       Enabling Processes




                                                                                               Enabling Processes
                          IS-XML                                        Signature”                                  IS-XML
                                                                        Company
   Billed                                                                                                                     Billing
   Airline                                                  Billing & Invoicing Processes                                     Airline
                          IS-IDEC                                                                                   IS-IDEC
                                                                        Central
                                                                        Repository
                                                                                                                              Prorate
                                                                                                                              Engine
                                                                                                                    Usage
                                                             Processes at time of Sales                              File
                                                                 ARC                   NFP
                                                                 COMPASS™             engine



                          Billing Value Confirmation
          (Leaves “Original PMI”, updates “Value Confirmation PMI”)
SIS P3 – Nairobi Workshop - SIS Functional Review                                    71                                           May 2011
                                                    Value Determination
                                                             &
                                                        Auto-Billing


SIS P3 – Nairobi Workshop - SIS Functional Review      72            May 2011
   Value Determination
                                                              Integrated Settlement

                                                               Settlement Processes
                          IS-WEB                                  ICH                ACH                             IS-WEB


                                                                         “Digital
                                       Enabling Processes




                                                                                               Enabling Processes
                          IS-XML                                        Signature”                                   IS-XML
                                                                        Company
   Billed                                                                                                                               Billing
   Airline                                                  Billing & Invoicing Processes                                               Airline
                          IS-IDEC                                                                                    IS-IDEC
                                                                        Central
                                                                        Repository
                                                                                                                                        Prorate
                                                                                                                                        Engine
                                                                                                                     Usage
                                                             Processes at time of Sales                               File
                                                                 ARC                   NFP
                                                                 COMPASS™             engine                               Usage File

                                                                                                                    Prorate Values
SIS P3 – Nairobi Workshop - SIS Functional Review                                    73                                                     May 2011
   Auto-Billing
                                                              Integrated Settlement
                                                                                                                              No Billing File
                                                               Settlement Processes                                           From Carrier
                          IS-WEB                                  ICH                ACH                            IS-WEB


                                                                         “Digital
                                       Enabling Processes




                                                                                               Enabling Processes
                          IS-XML                                        Signature”                                  IS-XML
                                                                        Company
   Billed                                                                                                                              Billing
   Airline                                                  Billing & Invoicing Processes                                              Airline
                          IS-IDEC                                                                                   IS-IDEC
                                                                        Central
                                                                        Repository
                                                                                                                                       Prorate
                                                                                                                                       Engine
                                                                                                                    Usage
                                                             Processes at time of Sales                              File
                                                                 ARC                   NFP
                                                                 COMPASS™             engine                              Usage File
                 Billing and Invoice Files
                                                                                Daily Revenue Recognition File
                     Created Within IS
                                                                               Weekly Invoice Posting File
SIS P3 – Nairobi Workshop - SIS Functional Review                                    74                                                    May 2011
                                                     Questions?



SIS P3 – Nairobi Workshop - SIS Functional Review   75            May 2011
    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


SIS P3 – Nairobi Workshop - SIS Functional Review   76                          May 2011

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:7/4/2011
language:English
pages:76