{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["General Information","Instructions","Schedule","Cover","Tables (CDTFA Staff Only)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"General Information","index":0,"n_rows":57,"n_cols":1,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["This workbook has 4 active worksheets - General Information, Instructions, Schedule, and Cover.  There is a hidden worksheet labeled Tables which you will not have access to.  Press the down arrow to read through the worksheet. If you receive a Security Warning, select Enable Content to allow the macros to run."]
["GENERAL INFORMATION"]
["General Data Entry"]
["1.  All gallon and dollar amounts must be entered as whole numbers.  Do not use decimals.  Round to\n     the nearest gallon or dollar amount."]
["2.  Dates must be entered using a proper date format.  Proper date formats are MMMM DD, YYYY\n     (i.e., August 13, 2019) or MM/DD/YY (i.e. 08/13/19 or 8/13/19)."]
["3.  Enter the CDTFA nine-digit account number excluding letters or dashes (e.g. 123456789).  Eight-\n     digit account numbers require a leading zero (e.g. 012345678)."]
["4.  Federal Employer Identification Numbers (FEINs) and Social Security Numbers (SSNs) are to be\n     entered using nine digits without dashes and letters."]
["5.  Two-digit identification (ID) type codes are required to identify ID numbers: Use 24 for FEIN, 34\n     for SSN, or 49 for account number."]
["6.  No Activity Reports.  When submitting a \"No Activity Report,\" be sure to do the following: 1)\n     Identify the file as a \"No Activity Report\" file on the Cover worksheet; 2) Make sure no\n     transactions are reported on the Schedule worksheet; and 3) Click the \"Create FLT File\" button on\n     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\n     (i.e., August 13, 2019) or MM/DD/YY (i.e. 08/13/19 or 8/13/19)."]
["2.  CDTFA account numbers must be entered using the nine-digit numeric portion, no dashes or\n     letters (e.g. 023456789). Eight-digit account numbers require a leading zero (e.g. 012345678)."]
["3.  Federal Employer Identification Numbers (FEINs) and Social Security Numbers (SSNs) are to be\n     entered using nine digits without dashes and letters."]
["4.  Two-digit identification (ID) qualifier codes are required to identify ID numbers: Use 24 for FEIN,\n     and 34 for SSN."]
["5.  No Activity Reports.  When submitting a \"No Activity Report,\" make sure that no transactions are\n     reported on the Schedule worksheet."]
["Schedule Worksheet"]
["1.  Dates must be entered using a proper date format.  Proper date formats are MMMM DD, YYYY\n     (i.e., August 13, 2019) or MM/DD/YY (i.e. 08/13/19 or 8/13/19)."]
["2.  All gallon and dollar amounts must be entered as whole numbers.  Do not use decimals.  Round to\n     the nearest gallon or dollar amount."]
["3.  CDTFA account numbers must be entered using the nine-digit numeric portion, no dashes or\n     letters (e.g. 023456789). Eight-digit account numbers require a leading zero (e.g. 012345678)."]
["4.  Federal Employer Identification Numbers (FEINs) and Social Security Numbers (SSNs) are to be\n     entered using nine digits without dashes and letters."]
["5.  Two-digit identification (ID) type codes are required to identify ID numbers: Use 24 for FEIN, 34\n     for SSN, or 49 for account number."]
["6.  No Activity Reports.  When submitting a \"No Activity Report,\" make sure that no transactions are\n     reported on the Schedule worksheet."]
["Excel 2016 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.  Click on the File tab."]
["4.  Click on the Excel Options button at the bottom of the pop-up window."]
["5.  Select Trust Center from the left column options of the Excel Options pop up window."]
["6.  Click on the Trust Center Settings button in the primary window."]
["7.  Select Macro Settings from the left column options of the Trust Center pop up window."]
["8.  Choose Enable All Macros from the Macro Settings option list."]
["9.  OK the change in the Trust Center pop up window."]
["10.  OK the change in the Excel Options pop up window."]
["11.  Open your Excel workbook and repeat Step 7 on the 'Instructions' worksheet."]
["12.  Once you have successfully created a Flat File, it is highly recommended that you change your\n        security settings back to a higher level."]
["Click here to return to Instructions worksheet"]
["Schedule Codes"]
["14D = Carrier Receipt"]
["14E = Carrier Delivery"]
["Click here to return to Instructions worksheet"]
["Mode Codes"]
["B            Barge"]
["PL          Pipeline"]
["R            Rail"]
["S            Ship (Ocean marine vessel)"]
[" Click here to return to Instructions worksheet"]
["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 shown on the bill of lading provided by the terminal from which the product is being removed."]
["General Information"]
["The Vessel/Pipeline Operator Information Report allows bulk transport operators (vessels, barges, and pipelines) to report receipts and deliveries of liquid product from and to an approved terminal or refinery."]
["Filing Requirements"]
["You must file a report with the CDTFA reporting every gallon of fuel products you received from and delivered to registered California terminals for the reporting period.  The report must be filed on or before the last day of the calendar month following the reporting period for which it relates.  You must file a report even if you have no activity for the reporting period."]
["CERTIFICATION"]
["Filers submitting their tax form electronically hereby consent to disclose and authorize the CDTFA to release, as necessary, certain otherwise confidential transaction information regarding volumes, invoice numbers, bills-of-lading, locations, dates, or method of delivery of reportable products to any person identified by you in this return as being involved in a reported transaction for the sole purpose of verifying the accuracy of the reportable product transaction information concerning your transactions with such person as reported in this return."]
["End of worksheet"]

{"sheet":"Instructions","index":1,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Instructions For:"]
["PETROLEUM CARRIER REPORT"]
["1.  Enter all information requested on the Cover worksheet."]
["2.  Enter all Carrier Receipts and Deliveries schedule information on the Schedule\n     worksheet.  Note: All gallon amounts must be entered as whole gallons.  Do not use\n     decimals.  Round to the nearest whole gallon."]
["For schedule descriptions and instructions on completing schedules:"]
["Click here for schedule descriptions and instructions on completing schedules"]
["For product codes:"]
["Click here for Product Code Table"]
["For mode codes:"]
["Click here for a list of valid transportation mode codes"]
["For schedule code information:"]
["Click here for a list of valid schedule codes"]
["3.  Save the Excel workbook and the data input for this tax form for your records.  Do\n     so by selecting \"File, Save As\" from the menu and then identifying the file name and\n     location."]
["4.  Create a FLT File by clicking on the button below.  You will be required to identify a\n     file name and location for your flat file.  Note: If the program does not execute and\n     display a \"Save As\" pop-up box or opens the \"Microsoft Visual Basic\" macro editor,\n     your security setting may be set too high."]
["Click here for instructions on changing the security setting"]
["Press Enter to create FLT file"]
["5.  Log-in to Online Services and upload the FLT File you created.  Note: The FLT File\n     has a \".txt\" extension, not \".xlsm.\""]
["Click here to go to the log-in webpage"]
["End of worksheet"]

{"sheet":"Schedule","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Schedule\nCode","Product\nCode","Consignor Name","Consignor ID","Consignor ID Type\n(24, 34, 49)","Mode","Origin\nTerminal TCN","Destination\nTerminal TCN","Document Date\n(MM/DD/YY)","Document\nNumber","Net Gallons"]
["14D","065","Alpha Oil Company","765432198","24","PL","T33CA8765",null,"2018-08-01","876554",2245990]
["14D","065","Alpha Oil Company","765432198","24","PL","T94CA9876",null,"2018-08-05","1234567",1050990]
["14D","167","Alpha Oil Company","765432198","24","PL","T94CA9876",null,"2018-08-02","1230167",600950]
["14D","130","Alpha Oil Company","765432198","24","PL","T94CA9876",null,"2018-08-10","1241818",61777]
["14D","130","Hardt Oil Company","659876543","24","PL","T94CA9876",null,"2018-08-15","9876224",100000]
["14D","167","Alpha Oil Company","765432198","24","PL","T33CA8765",null,"2018-08-07","877054",1110910]
["14D","167","Alpha Oil Company","765432198","24","PL","T33CA8765",null,"2018-08-09","877154",988090]
["14D","167","Alpha Oil Company","765432198","24","PL","T94CA9876",null,"2018-08-15","1238765",1099180]
["14D","167","Alpha Oil Company","765432198","24","PL","T94CA9876",null,"2018-08-25","1239165",499980]
["14D","167","Hardt Oil Company","659876543","24","PL","T33CA8765",null,"2018-08-06","876954",1865110]
["14D","167","Hardt Oil Company","659876543","24","PL","T94CA9876",null,"2018-08-24","1242345",795870]
["14E","065","Alpha Oil Company","765432198","24","PL",null,"T94CA9876","2018-08-01","876554",2245990]
["14E","167","Alpha Oil Company","765432198","24","PL",null,"T94CA9876","2018-08-07","877054",111910]
["14E","167","Alpha Oil Company","765432198","24","PL",null,"T94CA9876","2018-08-09","877154",988090]
["14E","167","Hardt Oil Company","659876543","24","PL",null,"T94CA9876","2018-08-06","876954",1865110]

{"sheet":"Cover","index":3,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["PETROLEUM CARRIER REPORT"]
["intentionally left blank"]
["Filing Period:","Date"]
["Period Beginning Date (Format of entry must be \"May 1, 2019\" or \"5/1/19\")","2018-08-01"]
["Period Ending Date (Format of entry  must be \"May 31, 2019\" or \"5/31/19\")","2018-08-31"]
["Account Information:","Info"]
["CDTFA Account Number ((Enter 9numeric digits of account number .  e.g. \"005050000\")","005052966"]
["Taxpayer's ID Qualifier (Enter \"24\" if providing FEIN or \"34\" if SSN)","24"]
["Taxpayer's FEIN or SSN","987654321"]
["Name (Enter legal name on CDTFA application)","Pipeline A Company"]
["DBA"]
["DBA (If needed)"]
["Address Line 1 (Enter street address)","123 Oil Lane"]
["Address Line 2 (Use if needed)"]
["City","Any Town"]
["State (Use abbreviation \"CA,\" \"NV,\" etc.)","CA"]
["ZIP","95704"]
["ZIP +4 (Use if needed)"]
["Return Information:","Info"]
["No Activity To Report (Enter 1 if no activity. Otherwise, leave blank). "]
["Click here for complete No Activity instructions.","intentionally left blank"]
["E-Filing Information:","Info"]
["Purpose Code  ( “00” – Original; \"Blank\" – Resubmission or Supplemental)","00"]
["Purpose Transaction Type ( \"Blank\" – Original; “6R” – Resubmission; “6S” – Supplemental)"]
["Sender's FEIN (May be same as taxpayer)","987654321"]
["Production Filing (P to identify production filing)","P"]
["Contact Information:","Info"]
["General Contact Name","Timothy C. Doe"]
["General Contact Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["General Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",5550101]
["General Contact Extension (Use numbers only)"]
["General Contact Fax Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["General Contact Fax Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",5550102]
["General Contact Fax Extension (Use numbers only)"]
["General Contact Email Address","timdoe@pipelinea.com"]
["eFiling Contact Name","Bobby G. Doe"]
["eFiling Contact Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["eFiling Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",5550303]
["eFiling Contact Extension (Use numbers only)"]
["eFiling Contact Fax Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["eFiling Contact Fax Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",5550304]
["eFiling Contact Fax Extension (Use numbers only)"]
["eFiling Contact Email Address","bobbydoe@pipelinea.com"]
["CDTFA USE ONLY:"]
["Report Type","CCR"]
["CDTFA Software Version","4.0"]
["End of worksheet"]

{"sheet":"Tables (CDTFA Staff Only)","index":4,"n_rows":93,"n_cols":5,"rows_kept":93,"cut":false,"hidden":true,"merged":[[0,2,40,2]]}
["CDTFA USE ONLY DO NOT MODIFY",null,"CDTFA USE ONLY DO NOT MODIFY","Schedule","Mode Codes"]
[null,null,null,"14D","J"]
[null,null,null,"14E","IJ"]
[null,null,null,null,"EJ"]
[null,null,null,null,"B"]
[null,null,null,null,"IB"]
[null,null,null,null,"EB"]
[null,null,null,null,"R"]
[null,null,null,null,"IR"]
[null,null,null,null,"ER"]
[null,null,null,null,"PL"]
[null,null,null,null,"IP"]
[null,null,null,null,"EP"]
[null,null,null,null,"S"]
[null,null,null,null,"IS"]
[null,null,null,null,"ES"]
["Not Used",null,null,null,"RT"]
["Not Used",null,null,null,"RS"]
["Random Generated Interchange Control Number","705547806",null,null,"RR"]
["Period Beginning Date From Cover","7/1/2019",null,null,"RF"]
["Period End Date From Cover","7/30/2019",null,null,"AH"]
["Default Date","01/01/2002",null,null,"AJ"]
["First Date Return is Valid","07/01/2019",null,null,"BA"]
["CDTFA Internal Version Number","4.0.1",null,null,"CE"]
[null,null,null,null,"GS"]
[null,null,null,null,"ST"]
[null,null,null,null,"j"]
[null,null,null,null,"ij"]
[null,null,null,null,"iJ"]
[null,null,null,null,"Ij"]
[null,null,null,null,"ej"]
[null,null,null,null,"eJ"]
[null,null,null,null,"Ej"]
[null,null,null,null,"b"]
[null,null,null,null,"ib"]
[null,null,null,null,"iB"]
[null,null,null,null,"Ib"]
["Report Type","CCR",null,null,"eb"]
["File Type","FLT",null,null,"eB"]
["Version","4.0",null,null,"Eb"]
["BOE/CDTFA DUNS #",617856943,null,null,"r"]
[null,null,null,null,"ir"]
[null,null,null,null,"iR"]
[null,null,null,null,"Ir"]
[null,null,null,null,"er"]
[null,null,null,null,"eR"]
[null,null,null,null,"Er"]
[null,null,null,null,"pl"]
[null,null,null,null,"pL"]
[null,null,null,null,"Pl"]
[null,null,null,null,"ip"]
[null,null,null,null,"iP"]
[null,null,null,null,"Ip"]
[null,null,null,null,"ep"]
[null,null,null,null,"eP"]
[null,null,null,null,"Ep"]
[null,null,null,null,"s"]
[null,null,null,null,"is"]
[null,null,null,null,"iS"]
[null,null,null,null,"Is"]
[null,null,null,null,"es"]
[null,null,null,null,"eS"]
[null,null,null,null,"Es"]
[null,null,null,null,"rt"]
[null,null,null,null,"rT"]
[null,null,null,null,"Rt"]
[null,null,null,null,"rs"]
[null,null,null,null,"rS"]
[null,null,null,null,"Rs"]
[null,null,null,null,"rr"]
[null,null,null,null,"rR"]
[null,null,null,null,"Rr"]
[null,null,null,null,"rf"]
[null,null,null,null,"rF"]
[null,null,null,null,"Rf"]
[null,null,null,null,"ah"]
[null,null,null,null,"aH"]
[null,null,null,null,"Ah"]
[null,null,null,null,"aj"]
[null,null,null,null,"aJ"]
[null,null,null,null,"Aj"]
[null,null,null,null,"ba"]
[null,null,null,null,"bA"]
[null,null,null,null,"Ba"]
[null,null,null,null,"ce"]
[null,null,null,null,"cE"]
[null,null,null,null,"Ce"]
[null,null,null,null,"gs"]
[null,null,null,null,"gS"]
[null,null,null,null,"Gs"]
[null,null,null,null,"st"]
[null,null,null,null,"sT"]
[null,null,null,null,"St"]