Reporting the Annual ICAO BTS Supplemental E-F Reports
Department of Transportation
Research and Innovative Technology Administration
Bureau of Transportation Statistics
Office of Airline Information
Accounting and Reporting Directive
No. 306
Issue Date: 1/1/2012
Effective Date: Immediately
As a party to the Convention on International Civil Aviation
(Treaty), the United States is obligated to provide ICAO with financial and
statistical data on operations of U.S. air carriers (Article 67). The Bureau of
Transportation Statistics' (BTS') Office of Airline Information (OAI)
administers this program for the Department of Transportation (DOT).
To meet ICAO needs for electronic submissions and to eliminate the
task of manually entering data, BTS requires carriers to e-submit their ICAO
Financial BTS Supplemental Form E-F data in the comma separated values (CVS)
file format. Each data element is separated by a comma. One thousand is
reported as 1000 not as 1,000 as the comma indicates a new data element. To
submit the BTS Supplemental Form E-F report, go to the website: https://esubmit.rita.dot.gov/ and
following the instructions for creating an account and submitting reports.
The file format for CSV reporting of ICAO Financial BTS
Supplemental Form E-F is attached.
This action is taken under authority delegated by 14 CFR
385.19(h).
Anne Suissa
Director
Office of Airline Information
OMB NO: 2138-0039
EXPIRATION DATE: 9/30/2012
Paperwork Reduction Act Burden Statement
A
federal agency may not conduct or sponsor, and a person is not required to
respond to, nor shall a person be subject to a penalty for failure to comply
with a collection of information subject to the requirements of the Paperwork
Reduction Act unless that collection of information displays a current valid
OMB Control Number. The OMB
Control Number for this information collection is 2138-0039. Public reporting for Schedule EF, ICAO
Supplemental Report, is estimated to be approximately 40 minutes per response,
including the time for reviewing instructions, completing and reviewing the
collection of information. All responses
to this collection of information are mandatory, as authorized by 14 CFR, Part
385.19. Send comments regarding this burden estimate or any other aspect of
this collection of information, including suggestions for reducing this burden
to: Information Collection Clearance Officer, Jeff Gorham, OAI/BTS/RITA,
RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail
jeff.gorham@dot.gov.
Comma Separate Values
Record Layout
BTS Form E-F ICAO
Financial Supplement
|
Field Description |
Comments |
Sample Data |
|
Air Carrier Code |
Code as of December 31 |
ZQ |
|
Year of Data |
ccyy |
2010 |
|
Allowance for depreciation
Flight Equipment |
Excludes non operating equipment |
20345700 |
|
Allowance for
depreciation Ground Property and Equipment |
Excludes non operating Ground Property and Equipment |
138675000 |
|
Flight Equipment
Airworthiness Allowance |
From system Schedule
P-5.2 Direct Maintenance |
6450000 |
|
Flight Equipment under
Capital Lease Total Amount |
Flight Equipment only |
10346000 |
|
Flight Equipment under
Capital Lease Accumulated Amortization |
Flight Equipment only |
9458000 |
|
Total En-route
Facilities Charges |
International
Operation only 1/ |
1534070 |
|
Equity in Income
of Investor Controlled Companies |
See 14 CFR Sec 241.14
Account 87 |
1250800 |
|
Net Balance of Unappropriated Retained Earnings from prior Year |
Last year's 4th
Quarter Schedule B-1 Account 2900 minus 2990 |
1589000 |
|
Profit or Loss(-)
after extraordinary items for this year |
This Year's Net Income
from System Schedule P-1.2 Account 9899 |
1658500 |
|
Adjustments to this Year's
Retained Earnings - Total |
Sum of Adjustments 1,
2, and 3 (below) |
37034000 |
|
Adjustment 1: Transfer
to Reserves |
|
12345000 |
|
Adjustment 2: Amounts
paid as bonus, dividends, etc. |
Can be either cash or
stocks |
23232000 |
|
Adjustment 3: Other |
Specify the adjustment |
Other comprehensive income |
|
Amount of Adjustment
3: |
In dollars |
1457000 |
|
Adjustment 4:
Appropriations |
|
2986000 |
|
Net Balance of Unappropriated Retained Earnings for Current Year |
This year's 4th
Quarter Schedule B-1 Account 2900 minus 2990 |
9815979 |
|
Personnel
expenses(Salary) for Traffic Solicitors on P-10 Acct 33 |
Broken out from system
Schedule P-6, Line 7 |
8128000 |
1/ Includes charges for communications facilities, navigational aids,
air traffic services, meteorological services and other ancillary aviation
services provided by foreign governments or governmental associates such as Eurocontrol, ASECNA and COCESNA.
Note: The addition of the Allowances for Depreciation Flight Equipment
and Ground Property and Equipment should equal Account 1668 on the 4th quarter
Schedule B-1.
Sample Comma Separate
Values Record Layout
ZQ,2010,20345700,138675000,6450000,10346000,9458000,1534070,1250800,1589000,1658500,37034000,12345000,23232000,'other
comprehensive income',1457000,2986000,9815979,8128000