{"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":49,"n_cols":1,"rows_kept":49,"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"]
["Filing Requirements"]
["Every train operator is required to report the total number of gallons of undyed diesel fuel, dyed diesel fuel and motor vehicle fuel purchased tax exempt for use in this state.  Receipt Schedule (Schedule TO), which details all of your ex-tax purchases of reportable fuel must also be completed. The Train Operator Information Report and Schedule TO must be filed with the CDTFA on or before the last day of the calendar month following the quarterly period shown on the face of the report. No remittance is due with this report."]
["Mode Codes"]
["J             Truck"]
["PL          Pipeline"]
["R            Rail"]
["B            Barge"]
["S            Ship (Ocean marine vessel)"]
["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 report."]
["End of worksheet"]

{"sheet":"Instructions","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Instructions For:"]
["TRAIN OPERATOR INFORMATION REPORT"]
["1.  Enter all information requested on the Cover worksheet."]
["2.  Enter all Carrier Receipts and Deliveries schedule information on the Schedule worksheet.\n      Note: All gallon amounts must be entered as whole gallons.  Do not use decimals. \n      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"]
["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":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Product\nCode","Carrier\nName","Carrier ID","Carrier ID Type\n(24, 34, or 49)","Mode","Origin","Destination\nState","Seller\nName","Seller ID","Seller ID Type\n(24, 34, or 49)","Document Date\n(MM/DD/YY)","Document \nNumber","Net\nGallons","Gross\nGallons","Billed\nGallons"]
["226","R & R Railroad","456123789","24","J","CA","CA","Dave's Oil","654654654","24","2019-04-02","4561",5000,5000,5000]
["226","Toon Town Inc","111222333","24","J","CA","CA","Rebel Gas","789789789","24","2019-04-15","366666",2000,2000,2000]
["226","R & R Railroad","456123789","24","J","CA","CA","Dave's Oil","654654654","24","2019-05-03","4982",3000,3000,3000]
["226","R & R Railroad","456123789","24","J","CA","CA","Dave's Oil","654654654","24","2019-05-28","5048",4500,4500,4500]
["226","Toon Town Inc","111222333","24","J","CA","CA","Rebel Gas","789789789","24","2019-06-15","367668",3600,3600,3600]
[null,null,null,null,""]

{"sheet":"Cover","index":3,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["TRAIN OPERATOR INFORMATION REPORT"]
["intentionally left blank"]
["Filing Period:","Date"]
["Period Beginning Date (Format of entry must be \"May 1, 2019\" or \"5/1/19\")","2019-04-01"]
["Period Ending Date (Format of entry  must be \"May 31, 2019\" or \"5/31/19\")","2019-06-30"]
["Account Information:","Info"]
["CDTFA Account Number ((Enter 9numeric digits of account number .  e.g. \"005050000\")","005059123"]
["Taxpayer's ID Qualifier (Enter \"24\" if providing FEIN or \"34\" if SSN)","24"]
["Taxpayer's FEIN or SSN","987456321"]
["Name (Enter legal name on CDTFA application)","Train Company"]
["DBA"]
["DBA (If needed)"]
["Address Line 1 (Enter street address)","123 Locomotive Way"]
["Address Line 2 (Use if needed)"]
["City","Railroad"]
["State (Use abbreviation \"CA,\" \"NV,\" etc.)","CA"]
["ZIP","99999"]
["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)","987456321"]
["Production Filing (P to identify production filing)","P"]
["Contact Information:","Info"]
["General Contact Name","David Smith"]
["General Contact Area Code (Use numbers only: \"916,\" not \"(916)\")","916"]
["General Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")","1234567"]
["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\")","1234568"]
["General Contact Fax Extension (Use numbers only)"]
["General Contact Email Address","ds@trainco.com"]
["eFiling Contact Name","David Smith"]
["eFiling Contact Area Code (Use numbers only: \"916,\" not \"(916)\")","916"]
["eFiling Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")","1234567"]
["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\")","1234568"]
["eFiling Contact Fax Extension (Use numbers only)"]
["eFiling Contact Email Address","ds@trainco.com"]
["CDTFA USE ONLY:"]
["Report Type","PTR"]
["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",null,"Mode Codes"]
[null,null,null,null,"J"]
[null,null,null,null,"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","PTR",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"]