Invoice for Air Tickets - Excel by zhi83591

VIEWS: 299 PAGES: 19

More Info
									Report for XXX Company Ltd.
                                                                                                                             report
Report for the month of December 2007                                                                                        prepared by



                              Dec 2007        Dec 2006
Number of documents                  16               8            Expenditure
Total air ticket costs       £13,882.00      -£1,589.00          18,000
Total air tax cost            £1,393.20          £79.30          16,000                                                        Dec 2007
Total rail ticket costs           £0.00           £0.00          14,000
                                                                 12,000                                                        Dec 2006
Total handling charges         £756.10          -£79.80          10,000
Other charges                  £381.90           £45.00           8,000
Total value                  £16,413.20      -£1,544.50           6,000
Number of air tickets                12               6           4,000
                                                                  2,000
Average air ticket cost       £1,156.83        -£264.83               0
                                                                 -2,000




                                                                                                                                                             Total handling charges




                                                                                                                                                                                                      Total value
                                                                                                                                   Total rail ticket costs
                                                                               Total air ticket costs




                                                                                                        Total air tax cost




                                                                                                                                                                                      Other charges
                                                                 -4,000




This report contains ten pages:

  Summary              this contains one line for each invoice/credit note for December 2007.
  Summary (2)          this contains one line for each invoice/credit note along with the itinerary, airline and class for invoices/credit notes that refer to air travel.
  Regions              the breakdown of invoice expenditure and air ticket spending by region for December 2007.
  Regions (2)          the breakdown of invoice expenditure and air ticket spending by region for December 2007
                        compared to December 2006.
  Class                the breakdown of air ticket spending by class for December 2007.
  Class Numbers        the breakdown of air ticket numbers and spending by class for December 2007.
                        The average ticket cost is shown.
  Class Numbers Detail a detailed breakdown of air ticket numbers and spending by class and region for December 2007.
  Class (2)            the breakdown of air ticket spending by class for December 2007
                        compared to December 2006.
  Class Numbers (2)    the breakdown of air ticket numbers and spending by class for December 2007
        compared to December 2006.
Notes   notes and explanations.
redit note along with the itinerary, airline and class for invoices/credit notes that refer to air travel.
Overall summary for December 2007
Document                                                                        Allocated              Allocated          Allocated
  Number                                                                            region               country                city
 credit notes      Booking   Document     Departure                       All invoices/credit notes in a given booking are allocated to    Total for   Number of Total for air Total for rail
  start with '1'    Number         Date         Date     Lead Passenger                   the same region/country/city                      services    air tickets    tickets        tickets
      93608          55326     3-Dec-07     8-Jan-08   Mr.A               Europe (not UK)      Germany                Munich                 118.80               1     39.00
      93653          55364     4-Dec-07   12-Dec-07    Mr.B               Europe (not UK)      Russia                 Moscow                 286.10               1    184.00
      93654          55365     4-Dec-07   12-Dec-07    Mr.C               Europe (not UK)      Russia                 Moscow                 282.10               1    184.00
      93707          55411     6-Dec-07     8-Jan-08   Mr.D               Europe (not UK)      Germany                Munich                 118.70               1     39.00
      93773          55461     7-Dec-07   11-Dec-07    Mr.E               Europe (not UK)      Russia                 Moscow                 851.45               1    727.00
      93864          55461    11-Dec-07   11-Dec-07    Mr.F               Europe (not UK)      Russia                 Moscow                 190.50               0
      93778          55464     7-Dec-07   15-Dec-07    Mr.G               Africa               South Africa           Cape Town            4,306.55               1  3,877.00
      17577          55515    12-Dec-07   12-Dec-07    Mr.H               Japan                Japan                  Tokyo               -3,310.60               0 -2,980.00
      93850          55515    11-Dec-07   12-Dec-07    Ms I               Japan                Japan                  Tokyo                3,310.60               1  2,980.00
      93889          55515    12-Dec-07   12-Dec-07    Ms J               Japan                Japan                  Tokyo                   20.00               0
      93856          55519    11-Dec-07   20-Dec-07    Ms K               Europe (not UK)      Russia                 Moscow                 190.50               0
      93892          55549    12-Dec-07   20-Dec-07    Ms L               Europe (not UK)      Spain                  Barcelona              288.50               1    218.00
      94007          55651    18-Dec-07   20-Dec-07    Ms M               Europe (not UK)      Russia                 St Petersburg        1,438.60               1  1,204.00
      94023          55667    19-Dec-07    13-Jan-08   Ms N               North America        USA                    New York             3,309.35               1  2,939.00
      94034          55677    19-Dec-07   20-Dec-07    Ms O               Europe (not UK)      Russia                 St Petersburg        1,699.45               1  1,491.00
      94045          55689    20-Dec-07   26-Dec-07    Ms P               Japan                Japan                  Tokyo                3,312.60               1  2,980.00
                                                                                                                                          16,413.20              12 13,882.00            0.00
Overall summary for December 2007 - (II)
Document                                                                                                                              Class of
  Number                                                                                                          Airline name           travel                                   Itinerary
 credit notes      Booking   Document    Departure                    Allocated Total for air Total for rail
  start with '1'    Number        Date        Date   Lead Passenger         city      tickets        tickets                    see notes 4 and 5 for explanation
                                                                                                                                                   London Heathrow Apt to Munich - Munich to
      93608          55326    3-Dec-07    8-Jan-08             Mr.A      Munich         39.00                    British   Airways Economy                             London Heathrow Apt

                                                                                                                                                           London Heathrow Apt to Moscow
                                                                                                                                                  Sheremetyevo Apt - Moscow Sheremetyevo
      93653          55364    4-Dec-07   12-Dec-07             Mr.B     Moscow        184.00                               Aeroflot Economy                     Apt to London Heathrow Apt

                                                                                                                                                           London Heathrow Apt to Moscow
                                                                                                                                                  Sheremetyevo Apt - Moscow Sheremetyevo
      93654          55365    4-Dec-07   12-Dec-07             Mr.C     Moscow        184.00                               Aeroflot Economy                     Apt to London Heathrow Apt
                                                                                                                                                  London Heathrow Apt to Munich - Munich to
      93707          55411    6-Dec-07    8-Jan-08             Mr D      Munich         39.00                    British Airways Economy                               London Heathrow Apt

                                                                                                                                                          London Heathrow Apt to Moscow
                                                                                                                                                    Domodedovo Apt - Moscow Domodedovo
      93773          55461    7-Dec-07   11-Dec-07             Mr E     Moscow        727.00                     British Airways Economy                       Apt to London Heathrow Apt

                                                                                                                                                           London Heathrow Apt to Moscow
                                                                                                                                                   Domodedovo Apt - Moscow Domodedovo
      93864          55461   11-Dec-07   11-Dec-07             Mr F     Moscow                                   British Airways Economy                        Apt to London Heathrow Apt
                                                                                                                                                  London Heathrow Apt to Cape Town - Cape
      93778          55464    7-Dec-07   15-Dec-07            Mr G    Cape Town      3,877.00                    British Airways Business                     Town to London Heathrow Apt

                                                                                                                                                   London Heathrow Apt to Tokyo Narita Apt -
      17577          55515   12-Dec-07   12-Dec-07             Mr.H       Tokyo     -2,980.00                  JAPAN AIRLINES Business               Tokyo Narita Apt to London Heathrow Apt

                                                                                                                                                   London Heathrow Apt to Tokyo Narita Apt -
      93850          55515   11-Dec-07   12-Dec-07             Ms I       Tokyo      2,980.00                  JAPAN AIRLINES Business               Tokyo Narita Apt to London Heathrow Apt

                                                                                                                                                   London Heathrow Apt to Tokyo Narita Apt -
      93889          55515   12-Dec-07   12-Dec-07            Ms J       Tokyo                                 JAPAN AIRLINES Business               Tokyo Narita Apt to London Heathrow Apt
      93856          55519   11-Dec-07   20-Dec-07            Ms K      Moscow
                                                                                                                                                         London Heathrow Apt to Barcelona -
      93892          55549   12-Dec-07   20-Dec-07             Ms L    Barcelona      218.00                     British Airways Economy                   Barcelona to London Heathrow Apt
                                                                                                                                                      London Heathrow Apt to St.Petersburg -
                                                                                                                                                     St.Petersburg to Paris Charles De Gaulle
                                                                                                                                                  Apt - Paris Charles De Gaulle Apt to London
      94007          55651   18-Dec-07   20-Dec-07            Ms M St Petersburg     1,204.00                        Air France Business                                         Heathrow Apt

                                                                                                                                                  London Heathrow Apt to New York JFK Intl -
      94023          55667   19-Dec-07   13-Jan-08            Ms N     New York      2,939.00                    British Airways Business           New York JFK Intl to London Heathrow Apt
                                                                                                                                                     London Heathrow Apt to St.Petersburg -
      94034          55677   19-Dec-07   20-Dec-07            Ms O St Petersburg     1,491.00                    British Airways Business              St.Petersburg to London Heathrow Apt

                                                                                                                                                   London Heathrow Apt to Tokyo Narita Apt -
      94045          55689   20-Dec-07   26-Dec-07            Ms P        Tokyo     2,980.00                   JAPAN AIRLINES Business               Tokyo Narita Apt to London Heathrow Apt
                                                                                   13,882.00           0.00
Regional breakdown of expenditure for December 2007

                         Total
                      invoice         Air ticket                  Airport
                   expenditure             costs                    taxes
Africa                4,306.55   26.2% 3,877.00           27.9%    234.70    16.8%
Asia (not Japan)
Australasia
Europe (not UK)       5,464.70   33.3%         4,086.00   29.4%    722.70    51.9%
Japan                 3,332.60   20.3%         2,980.00   21.5%    213.40    15.3%
Middle East
North America         3,309.35   20.2%         2,939.00   21.2%    222.40    16.0%
South America
United Kingdom
TOTAL                16,413.20             13,882.00              1,393.20


Total invoice expenditure by region                        Total air ticket costs by region



                                      Africa                                                  Africa
                                      Asia (not Japan)                                        Asia (not Japan)
                                      Australasia                                             Australasia
                                      Europe (not UK)                                         Europe (not UK)
                                      Japan                                                   Japan
                                      Middle East                                             Middle East
                                      North America                                           North America
                                      South America                                           South America
                                      United Kingdom                                          United Kingdom
Regional breakdown of expenditure for December 2007 compared to December 2006

                     Total invoice                                     Total invoice              Year on                              Air ticket                       Year on                                       Year on
                      expenditure                                       expenditure                  year                             costs this Air ticket costs          year     Airport taxes    Airport taxes       year
                        this month                                          last year              change                                 month          last year       change        this month         last year    change
Africa                     4,306.55                                            268.80               1602%                               3,877.00           132.00         2937%             234.70          121.80       193%
Asia (not Japan)                                                                                       n.a.                                                                  n.a.                                          n.a.
Australasia                                                                                            n.a.                                                                  n.a.                                          n.a.
Europe (not UK)                          5,464.70                          -3,237.00                -169%                               4,086.00            -2,916.00     -140%            722.70          -220.20      -328%
Japan                                    3,332.60                           1,423.70                 234%                               2,980.00             1,195.00      249%            213.40           177.70       120%
Middle East                                                                                            n.a.                                                                  n.a.                                          n.a.
North America                            3,309.35                                                      n.a.                             2,939.00                             n.a.          222.40                          n.a.
South America                                                                                          n.a.                                                                  n.a.                                          n.a.
United Kingdom                                                                                         n.a.                                                                  n.a.                                          n.a.
TOTAL                                   16,413.20                          -1,544.50               -1063%                              13,882.00            -1,589.00     -874%          1,393.20            79.30      1757%

  Total invoice expenditure by region                                                                                                     Dec 2007
   6,000                                                                                                                                  Dec 2006
   5,000
   4,000
   3,000
   2,000
   1,000
       0
                                                                                                                      South America
            Africa



                     Asia (not Japan)




                                                                                                      North America
                                           Australasia




                                                                            Japan



                                                                                    Middle East
                                                         Europe (not UK)




                                                                                                                                           United Kingdom




  -1,000
  -2,000
  -3,000
  -4,000
Breakdown of air ticket expenditure by class for December 2007

                      Air ticket                                                                                                Restricted                                      Premium
                           costs                                               First              Business                       Business                                       Economy       Economy            Apex
First                                            Africa                                           3,877.00
Business              12,491.00    90.0%         Asia (not Japan)
Restricted Business                              Australasia
Premium Economy                                  Europe (not UK)                                      2,695.00                                                                                 1,391.00
Economy                1,391.00    10.0%         Japan                                                2,980.00
Apex                                             Middle East
Unknown                                          North America                                        2,939.00
TOTAL                 13,882.00                  South America
                                                 United Kingdom




  Air ticket costs by class                                     Classes by destination                                                                                                     First
                                                                                                                                                                                           Business
                                                              4,500
                                                              4,000                                                                                                                        Restricted business
                                                              3,500                                                                                                                        Premium economy
                                                              3,000                                                                                                                        Economy
                                                              2,500                                                                                                                        Apex
                                                              2,000
                                                              1,500
                                      First
                                                              1,000
                                      Business                  500
                                      Restricted Business         0




                                                                                                                                                                South America
                                                                      Africa




                                                                                                                        Japan




                                                                                                                                                North America
                                                                                            Australasia




                                                                                                                                  Middle East




                                                                                                                                                                                 Kingdom
                                                                                Asia (not




                                                                                                          Europe (not
                                                                                 Japan)




                                                                                                                                                                                  United
                                      Premium Economy
                                                                                                             UK)
                                      Economy
                                      Apex
Breakdown of air ticket numbers by class for December 2007
                                                                                                                       Average ticket cost
                                                                                            2,500
                      Air ticket           Number of                   Average
                           costs            air tickets              ticket cost            2,000
First                                                                           ######
Business              12,491.00    90.0%             6      50.0%      2,081.83 ######      1,500
Restricted Business                                                             ######
Premium Economy                                                                 ######      1,000
Economy                1,391.00    10.0%             6      50.0%        231.83 ######
Apex                                                                            ######       500
Unknown                                                                         ######
TOTAL                 13,882.00                     12                 1,156.83                0




                                                                                                                                    Economy


                                                                                                                                              Economy
                                                                                                                        Business
                                                                                                            Business




                                                                                                                                                        Apex
                                                                                                    First




                                                                                                                        Restricte



                                                                                                                                    Premium
                                                                                                                           d
  Air ticket costs by class                                         Air ticket numbers by
                                                                             class


                                                                                                                       Only those tickets with
                                                                                                                       identified classes are
                                                                                                                       included in the graphs
                                                                                                                       on the left
                                      First
                                      Business
                                      Restricted Business
                                      Premium Economy
                                      Economy
                                      Apex
Unknown
Breakdown of air ticket numbers and expenditure for December 2007

Expenditure
                                       Restricted   Premium                     Unrecorded
                   First   Business     Business    Economy   Economy    Apex    or unkown        Total
Africa                     3,877.00                                                           3,877.00
Asia (not Japan)
Australasia
Europe (not UK)             2,695.00                          1,391.00                        4,086.00
Japan                       2,980.00                                                          2,980.00
Middle East
North America               2,939.00                                                          2,939.00
South America
United Kingdom
TOTAL                      12,491.00                          1,391.00                       13,882.00




Ticket numbers
                                       Restricted   Premium                     Unrecorded
                   First   Business     Business    Economy   Economy    Apex    or unkown       Total
Africa                            1                                                                 1
Asia (not Japan)
Australasia
Europe (not UK)                    2                                 6                               8
Japan                              2                                                                 2
Middle East
North America                      1                                                                 1
South America
United Kingdom
TOTAL                              6                                 6                              12
Average ticket cost
                                          Restricted   Premium                     Unrecorded
                      First   Business     Business    Economy   Economy    Apex    or unkown      Total
Africa                         3,877.00                                                         3,877.00
Asia (not Japan)
Australasia
Europe (not UK)                1,347.50                            231.83                         510.75
Japan                          1,490.00                                                         1,490.00
Middle East
North America                  2,939.00                                                         2,939.00
South America
United Kingdom
                               2,081.83                            231.83                       1,156.83
Breakdown of air ticket expenditure by class for December 2007 compared to December 2006

                                  Air ticket            Air ticket
                                 costs this            costs last                    Year on year                                    Restricted     Premium
                                     month                    year                   changes                    First   Business      Business      Economy     Economy
First                                                                     n.a.       Africa                       n.a        n.a             n.a          n.a        n.a
Business                          12,491.00                -1,054.00 -1185.1%        Asia (not Japan)             n.a        n.a             n.a          n.a        n.a
Restricted Business                                                       n.a.       Australasia                  n.a        n.a             n.a          n.a        n.a
Premium Economy                                                           n.a.       Europe (not UK)              n.a     -256%              n.a          n.a      -75%
Economy                            1,391.00                  -667.00 -208.5%         Japan                        n.a        n.a             n.a          n.a        n.a
Apex                                                          132.00      n.a.       Middle East                  n.a        n.a             n.a          n.a        n.a
Unknown                                                                   n.a.       North America                n.a        n.a             n.a          n.a        n.a
TOTAL                             13,882.00                -1,589.00                 South America                n.a        n.a             n.a          n.a        n.a
                                                                                     United Kingdom               n.a        n.a             n.a          n.a        n.a




   Air ticket costs by class                                                                            The figures in the table above show this
                                                                          Dec 2007                      year's expenditure as a percentage of the
 14,000                                                                   Dec 2006                      same category's figure last year.

 12,000                                                                                                 The entry n.a. implies either that this
 10,000                                                                                                 year's figure is zero, last year's figure
  8,000                                                                                                 was zero - or both.
  6,000
  4,000
  2,000
      0
                                                                        Apex
                                                 Economy


                                                              Economy
            First



                      Business


                                    Restricted



                                                 Premium
                                    Business




  -2,000
by class for December 2007 compared to December 2006


                                                       Apex
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
                                                         n.a
Breakdown of air ticket numbers by class for December 2007 compared to December 2006

                       Air ticket            Air ticket
                      costs this            costs last          Percentage
                          month                    year              change                                 Average ticket cost
First                                                                   n.a.   ######    2,500
Business               12,491.00    90.0%     -1,054.00   66.3%   -1285.1%     ######
Restricted Business                                                     n.a.   ######
                                                                                         2,000
Premium Economy                                                         n.a.   ######
Economy                 1,391.00    10.0%      -667.00    42.0%     -308.5%    ######
                                                                                         1,500
Apex                                            132.00    -8.3%         n.a.   ######
Unknown                                                                 n.a.   ######
                                                                                         1,000
TOTAL                  13,882.00              -1,589.00             -973.6%
                                                                                           500

                                                                                             0




                                                                                                                                                                              Apex
                                                                                                                                                                Economy
                                                                                                  First


                                                                                                             Business




                                                                                                                                              Premium Economy




                                                                                                                                                                                     Unknown
                                                                                                                        Restricted Business
                      Number of             Number of
                      air tickets           air tickets         Percentage                -500
                      this month              last year             change
First                                                                   n.a.   -264.83   -1,000
Business                       6    50.0%            1    16.7%     500.0%     -264.83
Restricted Business                                                     n.a.   -264.83   -1,500
Premium Economy                                                         n.a.   -264.83
Economy                        6    50.0%            4    66.7%      50.0%     -264.83                    This year                                                       Lastyear
Apex                                                 1    16.7%         n.a.   -264.83
Unknown                                                                 n.a.   -264.83                    Average this year                                               Average last year
TOTAL                         12                     6              100.0%
                         Average       Average
                      ticket cost   ticket cost    Percentage
                      this month       last year        change
First                                                      n.a.
Business                2,081.83      -1,054.00        -297.5%
Restricted Business                                        n.a.
Premium Economy                                            n.a.
Economy                   231.83        -166.75        -239.0%
Apex                                     132.00            n.a.
Unknown                                                    n.a.
                        1,156.83        -264.83        -536.8%
          Unknown




Average last year
Notes and conditions

   1    All figures are compiled by JTB from internal databases. JTB databases contain more detail
        than that shown here and the figures here represent summaries. As a result, the figures here
        are not necessarily those that appear on the invoices and credit notes that you hold, although
        differences are likely to be very small.
            If you wish to talk to anyone at JTB about the figures here please contact us on 020 8237
        1600.

   2
        Invoices and credit notes are organised into bookings. These bookings are identified by an
        individual booking number. For example, an air ticket, hotel booking and hire car charge might
        all be found in one booking but could be the subject of three distinct invoices.
           Each booking has a region, country and city allocated to it. Usually, this would be an
        unambigous allocation of destination. However, if the flight booked stopped in a number of
        destinations the destination is not clear. In this case JTB allocates a specific destination to the
        booking from the various destinations in the itinerary. Usually, this will be the most distant
        destination.

   3
        The air tickets used in finding expenditure on air travel may have been used or unused. If they
        were fully refunded, the net cost of zero would enter the calculatons. However, if they were not
        refundable the cost here would not actually correspond to a journey actually made.
          Note that other pages at the JTB website give expenditure on used tickets only, excluding the
        unused tickets from the calculation. This accounts for differences seen here and the figures
        found in the quick summary and invoice summary pages.

   4    The class of air travel is usually that of the first flight in an itnerary. Thus, if the first leg of a
        journey is in business class, for example, and subsequent legs are in economy class, the whole
        of the invoice total will be allocated to business class. This is the result if the 'start time' radio
        button is selected prior to generating the report.
            If, however, the 'flight duration' radio button is selected before the report is generated,
        however, the airline chosen is the one with the longest flight. This usually makes little
        difference. However, if a client flies, say, from Glasgow to Heathrow in economy class and then
        to Japan in business class, the 'start time' option would allocate the flight to economy class and
        the 'flight duration' option to business class.

   5    Only one itinerary is stored for a given booking and, if tickets are cancelled or altered, it is
        usually only the latest itinerary that remains in JTB's database. So it is possible that the itinerary
        seen here is not the same as that on the invoice.
            If no itinerary in Summary (II) but an air ticket cost appears it might be because the ticket
        has been cancelled and no itinerary remains in our database or the ticket was obtained for you
        from another vendor or is an open ticket.
           If no air ticket cost appears it is likely that the invoice/credit note referred to covers a non-air
        item such as a rail ticket, insurance purchase of foreign currency transactions.

								
To top