{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Select Returns to Export","AC Details","BA-PA-RA Details","BI-OI Details","BL Details","DS Details","FA Details","SP-ES-PS Details","SP-ES-PS Inventory","TO Details","TO Inventory","TR Details","WH Details"],"not_rendered":{"charts":0,"images":46,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,2,10],[3,0,3,10],[0,0,0,10],[1,0,1,10]]}
[" VAETS - Virginia DMV Motor Fuel Tax Return Input  V001    12/20/18"]
["This worksheet is designed to assist in the submission of petroleum tax return information to the Virginia DMV.\nIMPORTANT NOTE:  DO NOT add any sheets to the existing layout.  Do not separate detail sections with 'blank' lines or change the format\nof any cells.  This spreadsheet is read by an automated process that cannot detect any format changes that you may make.  For this\nreason, it is strongly suggested that this 'Master' spreadsheet should NOT be changed in any way.  Instead it is suggested that copies\nare made and named in such a way that 'describes' what information the spreadsheet contains.  For example, a spreadsheet that\ncontains tax return information for November 2018, could be named as one of the following:\n\n                                  VA-FUELTAX-ES1118.xls     or     TAX-FILINGS-201811.xls\n\nOnce the spreadsheet is complete and the export process has been run, the output file will need to be submitted to the Virginia\nDMV.  Please refer to the instructions sent to you by the DMV.  If you do not have the login information needed, please contact the Virginia DMV."]
["Step by step instructions are listed below (scroll down to view all the instructions if necessary):"]
["1.  Enter all data that is required by the Virginia DMV in the format required.  There are informational guidelines on the\n     column headers to explain the required formats.  You may enter tax return information for all of your licensed accounts\n     on one spreadsheet, or you can make individual copies for each account.\n\n2.  If you choose to perform calculations, be sure that you have removed all functions that you have created from the\n     spreadsheet.  Also, if you have inserted any blank lines into your data, remove them.\n\n3.  Once all tax information has been entered, go to the 'Select Returns to Export' sheet and follow the instructions."]

{"sheet":"Select Returns to Export","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Select Returns to Export"]
["On this page you select the returns to export when the 'Export Selected Sheets' button is clicked.  This allows you to control which tax filings are sent to the Virginia DMV.  For example:  You submit your Importer and Alternative Fuel reports in one file.  The next day you access the Motor Fuels system and find an error in the Importer filing which requires removal and resubmission of just that return.  After the corrections have been made to the spreadsheet data, you can select just the Importer Details option below and only those details will get exported.  Each sheet has a 'Validate' button located in column 'A'.  If there are errors in the data, a detailed message will be displayed describing the error.  These errors must be corrected before the data can be exported.  When the export is complete, a window will display indicating that your file has been saved and where it was saved.  The final step is to submit this file to the Virginia DMV.  Please follow the instructions sent to your company from the Virginia DMV.\n"]

{"sheet":"AC Details","index":2,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[2,17,2,18],[1,17,1,18],[1,20,1,21],[2,20,2,21]]}
["Aviation Consumer - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Aviation Consumer - \nEnter 'AC'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","1, 2, 3,\n5A, 5D","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"BA-PA-RA Details","index":3,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Bulk User / Provider / Retailer of Alternative Fuel - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Alternative Fuels\nTax Types:\n\nBulk User: BA\nProvider:  PA\nRetailer:  RA\n(BBA enter BA\nBRA enter RA)","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","1, 2, 3,\n5A, 6, 7,\n8, 8A","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"BI-OI Details","index":4,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Bonded / Occasional Importer of Fuel - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Importer\nTax Types:\n\nBonded:    BI\nOccasional:OI","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","1, 2, 2D,\n3A, 3B,\n6, 7, 8,\n8C, 9, 9F","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]
[]
["O","BI","2020/03","1","065","456321789","VA10006761","BI Seller","951357486","BI Buyer","951357486","BI Carrier","951357486","BI 12345$","20200315","B","T54VA1660",null,null,"T54VA1661",null,null,"10000","10000","10000"]

{"sheet":"BL Details","index":5,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Blender - Schedule of Receipts"]
["Enter a separate line for each receipt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Blender - \nEnter 'BL'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","2B only","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"DS Details","index":6,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Distributor - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Distributor - \nEnter 'DS'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","1, 2, 2D,\n3A, 6, 7,\n8, 8C, 9, 9F, 11A, 11B","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"FA Details","index":7,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Fuel Alcohol Provider - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Fuel Alcohol Provider - \nEnter 'FA'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","2B, 3, 6,\n7, 8, 9","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"SP-ES-PS Details","index":8,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,24],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Supplier / Elective Supplier / Permissive Supplier - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Seller's","Seller's","Buyer's","Buyer's","Carrier's","Carrier's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Supplier\nTax Types:\n\nSupplier:  SP\nElective:  ES\nPermissive:PS","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","1,2A,2B,\n2C,4B,5,\n5A,5AA,\n5AB,5AC,5D,\n5E,5H,6F,\n6H,6P,7,\n8,9,11B","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","If receipt, enter name of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's name.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter FEIN of the company the fuel was purchased from.\n\nIf disbursement, enter the filer's FEIN.\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","If receipt, enter the filer's name.\n\nIf disbursement, enter name of the company the fuel was sold to.\n\n\n\n\n\n\n\n\nMaximum of 35 characters","If receipt, enter the filer's FEIN.\n\nIf disbursement, enter  FEIN of the company the fuel was sold to.\n\n\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   Example: -9999"]

{"sheet":"SP-ES-PS Inventory","index":9,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,9,2,11],[5,12,5,13]]}
["Supplier / Elective Supplier / Permissive Supplier - Inventory Schedules per Product Type and TCN / Bulk Plant"]
["Enter a separate line for each Inventory Type per Product Type per TCN / Bulk Plant",null,null,null,null,null,null,null,"Required for"]
["Required","Required","Required","Required","Required","Required","Required","Required","Terminal Inventory","Required for Bulk Plant Inventory",null,null,"Required","Required"]
["Return","Tax","Report","Product","Inventory","Filer's","Filer's","Inventory","TCN",null,null,"Bulk Plant","Net","Gross"]
["Type","Type","Year/Month","Code","Type","FEIN","License","Date","Terminal Code","Bulk Plant Name","Bulk Plant City","State","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Supplier\nTax Types:\n\nSupplier:  SP\nElective:  ES\nPermissive:PS","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Enter 'BI' for Beginning Inventory \nor\nEnter 'EI' for \nEnding\nInventory","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","Use format \nYYYYMMDD","Mandatory if Bulk Plant Name, City and State are not provided.\n\nUse T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Mandatory if TCN Terminal Code is not provided.\n(Maximum of 30 characters)","Mandatory if TCN Terminal Code is not provided.\n(Maximum of 20 characters)","Mandatory if TCN Terminal Code is not provided.","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   \nExample: -9999"]

{"sheet":"TO Details","index":10,"n_rows":6,"n_cols":25,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,23,5,24],[1,21,1,22],[2,21,2,22],[1,0,1,3],[1,18,1,19],[2,18,2,19]]}
["Terminal Operator - Schedule of Receipts & Disbursements"]
["Enter a separate line for each receipt or disbursement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","TCN Terminal","Carrier","Carrier","Position Holder / Delivering Position","Position Holder/Delivering","Receiving Position","Receiving Position","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin","Origin","Origin","Destination","Destination","Destination","Net","Gross"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Code","Name","FEIN","Holder Name","Position Holder FEIN","Holder Name","Holder FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","Terminal Code","City","State","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Terminal Operator - \nEnter 'TO'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","15A, 15B","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","Enter 9 character Terminal Control Number.\n\nDo not enter dashes.\nEx. T99VA1234","Maximum of 35 characters","Federal Employer Identification Number of the carrier for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","\n\nCompany name of the Position Holder / Delivering Position Holder of the fuel being disbursed.  \n\nMaximum of 35 characters","FEIN of the Position Holder / Delivering Position Holder of the fuel being disbursed.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","\n\nCompany name of the Receiving Position Holder of the fuel being exchanged.  \n\nMaximum of 35 characters","FEIN of the Receiving Position Holder of the fuel being exchanged.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   \nExample: -9999"]

{"sheet":"TO Inventory","index":11,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,11,5,12]]}
["Terminal Operator - Inventory Schedules per Product Type and Position Holder"]
["Enter a separate line for each Inventory Type per Product Type per Position Holder"]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required"]
["Return","Tax","Report","Product","Inventory","Filer's","Filer's","TCN Terminal","Position Holder's","Position Holder's","Inventory","Net","Gross"]
["Type","Type","Year/Month","Code","Type","FEIN","License","Code","Name","FEIN","Date","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Terminal Operator - \nEnter 'TO'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Enter 'BI' for Beginning Inventory \nor\nEnter 'EI' for \nEnding\nInventory","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","Enter 9 character Terminal Control Number.\n\nDo not enter dashes.\nEx. T99VA1234","Maximum of 35 characters","Federal Employer Identification Number of the position holder of this inventory.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Use format \nYYYYMMDD","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   \nExample: -9999"]

{"sheet":"TR Details","index":12,"n_rows":6,"n_cols":24,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,22,5,23],[1,0,1,3],[1,17,1,18],[2,17,2,18],[1,20,1,21],[2,20,2,21]]}
["Motor Fuel Transporter - Schedule of Receipts"]
["Enter a separate line for each receipt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required if both the Origin","Both are Required if the",null,"Required if both the Destination","Both are Required if the "]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Optional","Required","Required","Required","City and State are not provided","Origin Terminal Code is not provided",null,"City and State are not provided","Destination Terminal Code is not provided",null,"Required","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Hiring Company","Hiring Company","Delivered to Company","Delivered to Company","Seller's","Seller's","Bill of Lading (BOL)-","BOL-Document","Transportation Mode","Origin TCN","Origin","Origin","Delivered To","Delivered To","Delivered To","Net","Gross"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Name","FEIN","Name","FEIN","Document Number","Date","(Enter the 1 or 2 letter code)","Terminal Code","City","State","TCN Terminal Code","City","State","Gallons","Gallons"]
["O (Original)\nA (Amendment)","Motor Fuel Transporter - \nEnter 'TR'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","14A, 14B,\n14C ","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","Maximum of 35 characters","Federal Employer Identification Number of the consignor for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the consignee for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 35 characters","Federal Employer Identification Number of the seller for this transaction.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Maximum of 30 characters","Use format \nYYYYMMDD","B   Barge\nBA  Book Adjustment\nGS  Gas Station\nJ   Truck\nPL  Pipeline\nR   Rail\nRT  Remove from Terminal\nS   Ship\nST  Stationary Transfer","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Use T##PC#### format (PC refers to the 2 character postal code of the state where the terminal is located.","Maximum 20 characters","Enter 2 character state code","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.   \nExample: -9999"]

{"sheet":"WH Details","index":13,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["Wholesale Sales Tax - Schedule of Disbursements"]
["Enter a separate line for each disbursement"]
["Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Optional","Required"]
["Return","Tax","Report","Schedule","Product","Filer's","Filer's","Buyer's","Buyer's","Locality","Bill of Lading (BOL)-","BOL-Document","Destination","Destination","Destination","Destination","Sales","Billed"]
["Type","Type","Year/Month","Type","Code","FEIN","License","Name","FEIN","Code","Document Number","Date","Address","City","State","Zip Code","Price","Gallons"]
["O (Original)\nA (Amendment)","Wholesale\nSales Tax - \nEnter 'WH'","Use format YYYY/MM\n(the '/' is required.\nEx. 2018/11)","16A, 16B,\n17A, 17B","Use FTA Product Codes. If code begins with a zero, enter a single quote first.\nEx: '065","Federal Employer Identification Number.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter your current DMV issued license number or your new VAETS issued license number.\nDo not enter dashes or spaces.","Maximum of 35 characters","Federal Employer Identification Number of the company where the product was delivered.\nDo not enter dashes or spaces. If FEIN begins with zero(s) enter a single quote first.\nEx: '012345678","Enter the 5 digit Locality Code","Maximum of 30 characters","Use format \nYYYYMMDD","Physical address where the product was delivered.\nMaximum 30 characters.","City where the product was delivered.\nMaximum 20 characters.","Enter 2 character state code where the product was delivered.","Zip code where the product was delivered.\nDo not use dashes.","Provide sales price with 2 decimals.  Enter the minus sign first for negative values\nExample: -1234.56","Enter whole gallons only. Do not enter commas or decimal points. Enter the minus sign first for negative gallons.\nExample: -9999"]