Dollar General Information System by kzn42472

VIEWS: 42 PAGES: 52

Dollar General Information System document sample

More Info
									                            GENERAL INFORMATION
     General Data Entry
1. All gallon and dollar numbers must be entered as whole numbers. Do not use decimals. Round to the
     nearest gallon or dollar amount.
2.   Dates must be entered using a proper date format. Proper date formats are MMMM DD, YYYY (i.e.
     August 13, 2003) or MM/DD/YY (i.e. 08/13/03 or 8/13/3).
3.   BOE account numbers should be entered using only the 8 digit numeric portion of the account number.
     No letters or dashes should be included. An account number, like PS MT 04-999999, should be entered
     as 04999999.
4.   FEINs and SSNs should be entered using only the 9 digit numeric portion of the number. No dashes
     should be included. An FEIN, like 95-1234567, should be entered as 951234567 and a SSN, like 987-65-
     4321, should be entered as 987654321.
5.   No Activity Reports. When submitting a No Activity report, be sure to do the following: 1) Identify the
     file as a No Activity file on the Cover worksheet, 2) Make sure no transactions are reported on the
     Schedule worksheet, 3) Delete all but the first two rows on the Flat File worksheet, and 4) Click the
     "Create Flat File" button on the Instructions worksheet.
                                           Click here to return to "Cover" worksheet



     Cover Worksheet
1. Dates must be entered using a proper date format. Proper date formats are MMMM DD, YYYY (i.e.
     August 13, 2003) or MM/DD/YY (i.e. 08/13/03 or 8/13/3).
2.   BOE account numbers should be entered using only the 8 digit numeric portion of the account number.
     No letters or dashes should be included. An account number, like PS MT 04-999999, should be entered
     as 04999999.
3.   FEINs and SSNs should be entered using only the 9 digit numeric portion of the number. No dashes
     should be included. An FEIN, like 95-1234567, should be entered as 951234567 and a SSN, like 987-65-
     4321, should be entered as 987654321.
4.   All gallon and dollar numbers must be entered as whole numbers. Do not use decimals. Round to the
     nearest gallon or dollar amount.
5.   No Activity Reports. When submitting a No Activity report, be sure to identify the file as a No Activity
     file on the Cover worksheet.


     Schedule Worksheet
1. If aircraft jet fuel is delivered to an airport location, provide the airport code in the detination field in
   column G.
2. If entries are added to or inserted into the Schedule worksheet, re-copy the rows in the Flat File
   worksheet to ensure that the data is captured.
3. Transactions do not need to be grouped by schedule number or be in numeric order.
4. Dates must be entered using a proper date format. Proper date formats are MMMM DD, YYYY (i.e.
   August 13, 2003) or MM/DD/YY (i.e. 08/13/03 or 8/13/3).
5. All gallon and dollar numbers must be entered as whole numbers. Do not use decimals. Round to the
   nearest gallon or dollar amount.

87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                              Version 1.1
                            GENERAL INFORMATION
6. BOE account numbers should be entered using only the 8 digit numeric portion of the account number.
   No letters or dashes should be included. An account number, like PS MT 04-999999, should be entered
   as 04999999.
7. FEINs and SSNs should be entered using only the 9 digit numeric portion of the number. No dashes
   should be included. An FEIN, like 95-1234567, should be entered as 951234567 and a SSN, like 987-65-
   4321, should be entered as 987654321.
8. No Activity Reports. When submitting a No Activity report, be sure to make sure no transactions are
   reported on the Schedule worksheet.


     Flat File Worksheet
1. If entries are added to or inserted into the Schedule worksheet, re-copy the rows in the Flat File
   worksheet to ensure that the data is captured.
2. No Activity Reports. When submitting a No Activity report, be sure to delete all but the first two rows
   on the Flat File worksheet.


     Security Settings
     If the "Save As" pop-up box does not appear when you click on the "Create Flat File" button, your
     security settings may be set too high to allow the associated program to function. To change the security
     setting, follow these steps:

1. Save the Excel workbook containing your tax information.
2. Close all open Excel workbooks.
3. Select 'Tools' from the menu. Then select 'Macro' followed by 'Security' from the drop down menus.

4.   Change the security to 'low'.
5.   OK the change
6.   Open your Excel workbook and repeat Step 7 on the 'Instructions' worksheet.
7.   Once you have successfully created a Flat File, it is highly recommended that you change your security
     settings back to a higher level.
                                      Click here to return to "Instructions" worksheet


     Mode Codes
     B        Barge
     CE       Summary Information
     GS       Gas Station
     J        Truck
     PL       Pipeline
     R        Rail
     RT*      Removal from Terminal
     S        Ship (Ocean marine vessel)


87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                          Version 1.1
                           GENERAL INFORMATION
  *RT - Removal from Terminal (other than by truck or rail) for sale or consumption.
  A supplier should use this mode code when a sale or transfer is made within the bulk transfer/terminal
  system to an unlicensed customer; when the sale is to a licensed industrial user and a removal is made
  from a vessel or pipeline; when the removal is made from a vessel and the fuel will be consumed in the
  operation of the vessel; when the disbursement is from a hydrant system at an airport; or when the
  disbursement is from qualifying truck removals at a secured airport.

                                      Click here to return to "Instructions" worksheet


   Aircraft Jet Fuel Dealer - General Information

  Every dealer of aircraft jet fuel will use this tax return to remit the tax imposed on the sale of aircraft jet
  fuel to an aircraft jet fuel user or on the use of aircraft jet fuel by the dealer as an aircraft jet fuel user. If
  you sell ex-tax aircraft jet fuel to other aircraft jet fuel dealers, obtain the aircraft jet fuel dealer
  account number from each purchaser. If you purchase aircraft jet fuel ex-tax from an aircraft jet
  fuel dealer, provide the dealer with your aircraft jet fuel dealer account number.

   Aircraft Jet Fuel Dealer - Filing Requirements

  If you are required to register as an aircraft jet fuel dealer, you must file an Aircraft Jet Fuel Dealer Tax
  Return and supporting schedules with the State Board of Equalization (Board) on a monthly basis. The
  tax return and any remittance owing, which must be made payable to the State Controller, must be filed
  on or before the last day of the calendar month following the reporting period to which it relates. Paying
  your tax or filing your tax return after the due date will result in interest and penalty charges. You must
  file a tax return even if no tax is due for the reporting period. To prepare the tax return, you must first
  complete the applicable schedules.

   Accountability
  You must report all transactions required by this tax return on the supporting schedules. The Board will
  be comparing the information reported on your schedules with information provided by third parties. We
  will also be comparing your imports and exports of aircraft jet fuel against imports and exports reported
  to us by other states.

   Document Numbers
  The document number used on Receipt schedules must be the same document number provided on the
  bill of lading. The document number used on Disbursement schedules must be the same document
  number provided on the bill of lading by the terminal from which the product is being removed when
  applicable.

   Reporting Airport Codes


87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                              Version 1.1
                           GENERAL INFORMATION
  If aircraft jet fuel is delivered to an airport location, provide the airport code in the detination field in
  column G on the 'Schedule' worksheet.
  The 'Airport Codes' worksheet has been developed for your reference. It lists airports in alphabetical
  order by city. The list may not include all airports in California. It is your responsibility to report the
  correct Airport Code.




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                             Version 1.1
Instructions For:
                                   Aircraft Jet Fuel Dealer Tax Return

  1. Enter all schedule information for transaction schedules on the "Schedule" worksheet. All gallon
     amounts must be entered as whole gallons. Do not use decimals. Round to the nearest whole
     gallon.

     For schedule descriptions and instructions on completing schedules:
     http://www.boe.ca.gov/sptaxprog/pdf/boe810fte.pdf

     For product codes:
     http://www.boe.ca.gov/sptaxprog/pdf/boe810fta.pdf

     For mode codes:
     Click here for a list of valid transportation mode codes



  2. Prepare the Tax Computation Worksheet. The Tax Computation Worksheet will assist you in
     calculating the tax due and completing your return.
     Click here to go to the Aircraft Jet Fuel Dealer Tax Computation Worksheet


  3. Enter all information requested on the "Cover" worksheet. Note: All gallon and dollar amounts
     must be entered as whole numbers. Do not use decimals. Round to the nearest whole number.
     Tax Computation worksheets are available to assist you.


  4. Copy row 9 on the "Flat File" worksheet and paste the copied row as many times as necessary to
     capture the schedule information entered on the "Schedule" worksheet.


  5. Clear the contents of all rows on the "Flat File" worksheet that display "Unused Row" in column A.
     Do so by selecting the "Unused Rows" and selecting "Edit, Clear, Contents" from the menu. Note:
     If you do not see any rows displaying "Unused Row", you may not have all of your transactions on
     the "Schedule" worksheet displayed on the "Flat File" worksheet. Confirm that you correctly
     completed Step 3.


  6. Review the "Flat File" worksheet for errors. Cells with errors will have "#N/A" in them. These
     errors must be corrected before creating a flat file. Uncorrected errors may cause the file to be
     rejected upon submission to the BOE. Note: Errors should be corrected on the "Cover" worksheet
     or the "Schedule" worksheet.


  7. Save the Excel workbook and the data input for this tax form for your records. Do so by selecting
     "File, Save As" from the menu and then identifying the file name and location.


  8. Create a Flat File by clicking on the button below. You will be required to identify a file name and
     location for your flat file. Note: If the program does not execute and display a 'Save As' pop-up
     box or opens the 'Microsoft Visual Basic' macro editor, your security setting may be set too high.

                                     Click here for instructions on changing the security setting



                                           Create Flat File


   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                                 Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     6 of 52                                                                                Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   7 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     8 of 52                                                                                Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   9 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     10 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   11 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     12 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   13 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     14 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   15 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     16 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   17 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     18 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   19 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     20 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   21 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     22 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   23 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     24 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   25 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     26 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   27 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     28 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   29 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     30 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   31 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     32 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   33 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     34 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   35 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     36 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   37 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     38 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   39 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     40 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   41 of 52   Version 1.1
Schedule Product                              Carrier                   Point of                               Buyer/Seller   Document Date   Document
  Code    Code                Carrier Name     FEIN     Mode   Origin        Destination   Buyer/Seller Name      FEIN        (MM/DD/YY)       Number    Net Gallons   Gross Gallons




   87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                     42 of 52                                                                               Version 1.1
Billed Gallons




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   43 of 52   Version 1.1
                                                                    Aircraft Jet Fuel Dealer Tax Return

Filing Period:
Period Beginning Date (Format of entry must be "May 1, 2003" or "5/1/03")
Period Ending Date (Format of entry must be "May 31, 2003" or "5/31/03")
Account Information:
BOE Account Number (Enter 8 numeric digits of account number "57250000", "04060000", "33123000", etc.)
Taxpayer's ID Qualifier (Enter "24" if providing FEIN or "34" if SSN)
Taxpayer's FEIN or SSN
Name (Enter legal name on BOE application)
DBA
DBA (If Needed)
Address Line 1 (Enter street address)
Address Line 2 (Use if needed)
City
State (Use abbreviation "CA", "NV", etc.)
ZIP
ZIP +4 (Use if needed)
Return Information:
Click here to go to the Aircraft Jet Fuel Dealer Tax Computation Worksheet
No Activity To Report              (Enter 1 if no activity. Else, leave blank).                                                                                  BOE Use Only:
                                                    Click here for complete 'No Activity' instructions.                                                          Line Item UOM
1. Gallons for which tax applies or refund due (enter from Tax Computation Worksheet Section A, line 3)
2. Rate of tax per gallon                                                                                                                                 0.02 L00001     GA
3. Amount of tax due or refund claimed (multiply line 1 by line 2)
4. Penalty                                                                                                                                                       L00002   USD
5. Interest                                                                                                                                                      L00003   USD
6. Total amount due and payable or refund claimed                                                                                                                L00004   USD
Ending Inventory                                                                                                                                                 L00005   USD
1. Gallons of ending physical inventory of aircraft jet fuel                                                                                                     15C      GA
E-Filing Information:
Authorization Code (Provided by BOE when TPA accepted)
Password (Security Code) (Provided by Information Provider on TPA)
Sender's FEIN (May be same as taxpayer)
Test/Production (T or P to identify test or production filing. Must be capitalized.)
Transaction Set Purpose Code ("00" = Original, "05" = Replace, "15" = Resubmission                        NOTE: Must have permission to use other
than "00")

Transaction Type Code (Blank if Original, "6R" = Resubmission, "6S" = Supplemental, "CO" = Corrected)
Filer's Unique # For This Filing (Must change for each submission, even if same tax form) [4 Characters Minimum and 9 Characters
Maximum]

Contact Information:
General Contact Name
General Contact Area Code (Use numbers only: "916" not "(916)")
General Contact Phone Number (Use numbers only: "2223333" not "222-3333")
General Contact Extension (Use numbers only)
General Contact Fax Area Code (Use numbers only: "916" not "(916)")
General Contact Fax Phone Number (Use numbers only: "2223333" not "222-3333")
General Contact Fax Extension (Use numbers only)
General Contact Email Address
eFiling Contact Name
eFiling Contact Area Code (Use numbers only: "916" not "(916)")
eFiling Contact Phone Number (Use numbers only: "2223333" not "222-3333")
eFiling Contact Extension (Use numbers only)
eFiling Contact Fax Area Code (Use numbers only: "916" not "(916)")
eFiling Contact Fax Phone Number (Use numbers only: "2223333" not "222-3333")
eFiling Contact Fax Extension (Use numbers only)
eFiling Contact Email Address
BOE Use Only:
Report Type                                                                                                                                              DLR
File Type                                                                                                                                                 FLT
Version                                                                                                                                                    2.0
BOE DUNS #                                                                                                                                          617856943



87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                                                                                                       Version 1.1
Qualifier


Billed


Tax
Pen
Int
Total
Inventory




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   Version 1.1
FLT           2.0         617856943   #N/A
FE                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR                                                    00          0
FG                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      L00001   GA         Billed           0
FG                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      L00002   USD        Tax              0
FG                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      L00003   USD        Pen              0
FG                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      L00004   USD        Int              0
FG                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      L00005   USD        Total            0
FI                    0   #N/A        #N/A      #N/A       #N/A   #N/A   DLR      15C             130 I                    GA    19000100              0
Unused Row    #N/A        #N/A        #N/A   #N/A      #N/A       #N/A   DLR      #N/A     #N/A                FALSE




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                   46 of 52                                                             Version 1.1
            0            0            0 TP              CN




CA
                              FALSE




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls     47 of 52        Version 1.1
                                                               EA   '




                                           FALSE   FALSE




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls            48 of 52            Version 1.1
87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls   49 of 52   Version 1.1
   Click here to return to "Cover" worksheet
   Click here to return to the Instructions




87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls       Version 2.0
         AIRCRAFT JET FUEL DEALER TAX COMPUTATION WORKSHEET
        This worksheet should be used to help you complete your return and calculate the tax due.


                                                                                   FROM               AIRCRAFT JET
                 SECTION A. TAXABLE TRANSACTIONS
                                                                                 SCHEDULE             FUEL GALLONS
     1. Taxable Gallons of aircraft jet fuel (enter from Schedule 5)
                                                                                        5
     2. Total Gallons of aircraft jet fuel used by you as an aircraft jet
        fuel user (enter from Schedule 5Q)                                             5Q
     3. Total Transactions Subject to Tax (add lines 1 and 2) Enter on line
        1 of return
                                                                                                                0


                                                                                   FROM               AIRCRAFT JET
                         SECTION B. EXEMPTIONS
                                                                                 SCHEDULE             FUEL GALLONS
     1. Aircraft jet fuel exported (enter from Schedule 7)
                                                                                        7
     2. Aircraft jet fuel sold to the United States Armed Forces (enter
        from Schedule 8)                                                                8
     3. Gallons sold or used for purposes other than as an aircraft jet
        fuel user (enter from Schedule 10A)                                           10A
     4. Sales of aircraft jet fuel to registered aircraft jet fuel dealers
        (enter from Schedule 10B)                                                     10B
     5. Aircraft jet fuel sold to aircraft manufacturers (enter from
        Schedule 10G)                                                                 10G
     6. Aircraft jet fuel sold to air common carrier (enter from
        Schedule 10K)                                                                 10K
     7. Total Exemptions (add lines 1 through 6)
                                                                                                                0


        Preparation of the Tax Computation Worksheet
     A. Taxable Transactions
Line 1. Enter the total gallons of taxable aircraft jet fuel sales by adding the totals from column 11 for each
        disbursement schedule coded 5.
Line 2. Enter the total gallons of aircraft jet fuel used by you as an aircraft jet fuel user from column 11 for each
        disbursement schedule coded 5Q.
Line 3. Enter the total gallons of aircraft jet fuel subject to tax during the reporting period by adding lines 1 and 2.
        Enter this total on line 1 on the front of the return.

     B. Exemptions
Line 1. Enter the total gallons of exempt aircraft jet fuel exported by adding column 11 for each disbursement
        schedule coded 7.
Line 2. Enter the total gallons of exempt aircraft jet fuel sold to the United States Armed Forces by adding column 11
        for each disbursement schedule coded 8.
Line 3. Enter the total gallons of exempt aircraft jet fuel sold or used for purposes other than as an aircraft jet fuel
        user by adding column 11 for each disbursement schedule coded 10A.
Line 4. Enter the total gallons of exempt aircraft jet fuel sold to registered aircraft jet fuel dealers by adding column
        11 for each disbursement schedule coded 10B.
Line 5. Enter the total gallons of exempt aircraft jet fuel sold to aircraft manufacturers by adding column 11 for each
        disbursement schedule coded 10G.
Line 6. Enter the total gallons of exempt aircraft jet fuel sold to air common carriers by adding column 11 for each
        disbursement schedule coded 10K.
Line 7. Enter the total gallons of exempt aircraft jet fuel sold, exported, or used during the reporting period by adding
        lines 1 through 6.




    87c3f814-7ac3-461d-8dd6-fcf96f96d29e.xls                                                                                Version 2.0
Schedule Variable Table                                    Cover Variable Table
          Record      Item         Seller(S)/Buyer(B)      Report    Provider
 Schedule Type      Indicator Position Holder(P)/None(N)    Type       Type              Description
5         FS                  B                            CCR      L9          Vessel/Pipeline Operator
5Q        FS                  B                            DBR      TP          Exempt Bus Operator
7         FS                  B                            DLR      TP          Jet Dealer
8         FS                  B                            DZC      TP          Nontaxable & Export Claim
10A       FS                  B                            SDR      TP          Supplier
10B       FS                  B                            TOR      L9          Terminal Operator
10AB      FS                  B                            DUC      TP          User Claim Refund
10C       FS                  B                            DVM      TP          Vendor Monthly
10G       FS                  B                            DVW      TP          Vendor Weekly
10I       FS                  B
10K       FS                  B                            Taxpayer ID Variable
10Y       FS                  B                              ID     Description
10Z       FS                  B                                24   FEIN
13A       FS                  B                                34   SSN
13B       FS                  B                                49   BOE Account Number
13C       FS                  B
13D       FS                  B
13E       FS                  B
13G       FS                  B
14D       FS                  N
14E       FS                  N
15A       FS                  N
15B       FS                  P
15C       FI       I          N
1A        FS                  S
2         FS                  S
2A        FS                  S
2X        FS                  S
3A        FS                  S
3B        FS                  S
3X        FS                  S
3Y        FS                  S
4         FS                  S
5A        FS                  B
5S        FS                  B
5V        FS                  B
5W        FS                  B
6F        FS                  B
6X        FS                  B
7D        FS                  B
7F        FS                  B
EI        FI       I          N
PD        FS                  N
S02A      FI       S          N
S03A      FI       S          N
S04       FI       S          N
S05I      FI       S          N
TD        FS                  P
TR        FS                  N

								
To top