{"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":14,"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":70,"n_cols":1,"rows_kept":70,"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 the\n      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-digit\n      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 for\n      SSN, or 49 for account number."]
["6.  The Tax Rate is reported with a decimal point and three digits.  No leading zero should be entered.\n      Proper rate format is .nnn (e.g., .360 or .357)."]
["7.  No Activity Reports.  When submitting a \"No Activity Report,\" be sure to do the following: \n      1) 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 - General"]
["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 letters\n      (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, and\n      34 for SSN."]
["5.  All gallon and dollar amounts must be entered as whole numbers.  Do not use decimals.  Round to the\n      nearest gallon or dollar amount."]
["6.  No Activity Reports.  When submitting a \"No Activity Report,\" make sure that no transactions are\n      reported on the Schedule worksheet."]
["Cover Worksheet - Instructions"]
["1.  Enter the filing period dates in rows 4 and 5."]
["2.  Enter the account information requested in rows 7 through 18."]
["3.  If the return is a \"No Activity\" return, enter \"1\" on row 21 and follow the \"No Activity\" reporting\n      instructions on this worksheet.  No additional information is reported in the Return Information section\n      when reporting a \"No Activity\" return."]
["4.  Enter the taxable gallons for Diesel Fuel in column B on row 23 (line1)."]
["5.  Enter the tax rate for the taxable gallon amount in  column B on row 24 (line 2).  Proper rate format is\n      .nnn (i.e., .130)."]
["6.  Enter the amount of refund claimed  in  column B on row 25 (line 3).  (Multiply the amount reported \n      on row 23 [line 1] by the rate reported on row 24 [line 2].)"]
["7.  The total gallons reported in column B on row 23 (line 1) is entered on row 26 (line 4).  The\n      workbook will make this calculation for you."]
["8.  The total amount of refund claimed as reported in column B on row 25 (line 3) is entered on row 27\n      (line 5).  The workbook will make this calculation for you."]
["9.  Enter the eFiling information requested in rows 29 through 32."]
["10.  Enter the contact information requested in rows 34 through 49."]
["Click here to return to Cover worksheet"]
["Schedule Worksheet"]
["1.  Transactions do not need to be grouped by schedule number or be in numeric order."]
["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.  All gallon and dollar amounts must be entered as whole numbers.  Do not use decimals.  Round to the\n     nearest gallon or dollar amount."]
["4.  CDTFA account numbers must be entered using the nine-digit numeric portion, no dashes or letters\n     (e.g. 023456789). Eight-digit account numbers require a leading zero (e.g. 012345678)."]
["5.  Federal Employer Identification Numbers (FEINs) and Social Security Numbers (SSNs) are to be\n      entered using nine digits without dashes and letters."]
["6.  Two-digit identification (ID) type codes are required to identify ID numbers: Use 24 for FEIN, 34 for\n      SSN, or 49 for account number."]
["7.  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"]
["Mode Codes"]
["GS         Gas Station"]
["J             Truck"]
["R            Rail"]
["Click here to return to Instructions worksheet"]
["General Information"]
["Ultimate Vendors are persons who sell undyed diesel fuel without tax to an ultimate purchaser for use on a farm for farming purposes or for use in an exempt bus operation.  As an ultimate vendor of diesel fuel in California, you may use this form to file a claim for refund of tax you paid on undyed diesel fuel you sold, and did not collect tax reimbursement, to ultimate purchasers for use on a farm for farming purposes or for use in an exempt bus operation.  Your claim must cover a period of not less than one week and total at least $200, or you may include these sales in your periodic report/claim for refund (Form CDTFA-770-DV)."]
["Filing Requirements"]
["If refund amount is less than $200, do not submit claim."]
["You may use this form to file a claim for refund of tax paid on undyed diesel fuel sold without tax reimbursement to ultimate purchasers.  Your claim must cover a period of not less than one week and total at least $200.  The period covered by your claim can include more than one week's sales, if necessary, to reach the $200 minimum.  You must submit completed Schedules 13D and 13E with your claim."]
["You are required to file a periodic report (Form CDTFA-770-DV) with the State Board of Equalization, listing your diesel fuel receipts and disbursements of dyed diesel fuel.  If you prefer you may claim a refund on that report instead of filing this weekly claim form.  You must file the periodic report whether or not you file separate weekly claims."]
["NOTE: Even if you qualify to file weekly claim forms, any exempt sales to ultimate purchasers for the last week of the period must be claimed on the periodic report (Form CDTFA-770-DV)."]
["Document Numbers"]
["The document number used on Receipt and Disbursement schedules must be the same document number provided on the bill of lading."]
["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":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Instructions For:"]
["DIESEL FUEL ULTIMATE VENDOR REPORT/CLAIM FOR REFUND"]
["1.  Enter all transaction information for summary schedule codes and transaction schedule codes on\n     the Schedule worksheet.  Note: All summary schedule code transactions must be entered\n     before any other schedule code transactions are entered.  All gallon amounts must be \n     entered as whole gallons.  Do not use 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"]
["2.  Enter all information requested on the Cover worksheet.  Detailed instructions are provided in\n     the General Information worksheet.  Note: All gallon and dollar amounts must be entered \n     as whole numbers.  Do not use decimals.  Round to the nearest whole number.  A tax\n     computation worksheet is available to assist you."]
["3.  Save the Excel workbook and the data input for this tax form for your records.  Do so by\n      selecting \"File, Save As\" from the menu and then identifying the file name and location."]
["4.  Create a FLT File by clicking on the button below.  You will be required to identify a file name\n     and location for your flat file.  Note: If the program does not execute and display a \"Save\n     As\" pop-up box or opens the \"Microsoft Visual Basic\" macro editor, your security setting\n     may be set too high."]
["Click here for instructions on changing the security setting"]
["Press Enter to create FLT file"]
["5.  Log-in to our Online Services and upload the FLT File you created.  Note: The FLT File has\n     a \".txt\" extension, not \".xlsm.\""]
["Click here to go to the log-in webpage"]
["End of Worksheet"]

{"sheet":"Schedule","index":2,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Schedule Code","Product\nCode","Carrier Name","Carrier ID","Carrier ID Type\n(24, 34, or 49)","Mode","Point of\nOrigin","Destination","Buyer/Seller Name","Buyer/Seller ID","Buyer/Seller ID Type\n(24, 34, or 49)","Document Date\n(MM/DD/YY)","Document\nNumber","Net Gallons","Gross Gallons","Billed Gallons"]
["13D","167","JJ Trucking","456789123","24","J","CA","CA","Steve Farming","987085555","24","2019-05-01","480963",169,170,169]
["13D","167","JJ Trucking","456789123","24","J","CA","CA","Steve Farming","987085555","24","2019-05-05","484779",419,420,419]
["13E","167","JJ Trucking","456789123","24","J","CA","CA","SJ City Bus Line","870111115","24","2019-05-09","481030",5176,5175,5176]
["13E","167","JJ Trucking","456789123","24","J","CA","CA","SJ City Bus Line","870111115","24","2019-05-14","482784",1710,1709,1710]

{"sheet":"Cover","index":3,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["DIESEL FUEL ULTIMATE VENDOR REPORT/CLAIM FOR REFUND"]
["intentionally left blank","intentionally left blank"]
["Filing Period:","Date"]
["Period Beginning Date (Format of entry must be \"May 1, 2019\" or \"5/1/19\")","2019-05-01"]
["Period Ending Date (Format of entry  must be \"May 31, 2019\" or \"5/31/19\")","2019-05-15"]
["Account Information:","Info"]
["CDTFA Account Number (Enter 9 numeric digits of account number .  e.g. \"057250000\" )","057996633"]
["Taxpayer's ID Qualifier (Enter \"24\" if providing FEIN or \"34\" if SSN)","24"]
["Taxpayer's FEIN or SSN","443571595"]
["Name (Enter legal name on CDTFA application)","3D Fuel Vending"]
["DBA"]
["DBA (If needed)"]
["Address Line 1 (Enter street address)","23 Main Street"]
["Address Line 2 (Use if needed)"]
["City","Anytown"]
["State (Use abbreviation \"CA,\" \"NV,\" etc.)","CA"]
["ZIP","95822"]
["ZIP +4 (Use if needed)"]
["Return Information:","Diesel\nCurrent Rate","CDTFA USE ONLY"]
["intentionally left blank","intentionally left blank"]
["No Activity To Report (Enter 1 if no activity. Otherwise, leave blank). "]
["Click here for complete No Activity instructions.","intentionally left blank","Line Item","UOM","Qualifier"]
["1. Gallons of tax-paid diesel fuel to be refunded",7474,"L00031","GA","Billed"]
["2. Tax rate (Note: Tax rate is reported with a decimal point and three digits.  e.g. \".100\" or \".130\")",".360",null,"USD","Rate"]
["3. Amount of refund due",{"$f":"ROUND((B23*B24),0)","v":2691},"L00031","USD","Tax"]
["4. Total gallons of tax-paid diesel fuel to be refunded",{"$f":"ROUND(SUM(B23:B23),0)","v":7474},"L00001","GA","Billed"]
["5. Total amount of refund",{"$f":"ROUND(SUM(B25:B25),0)","v":2691},"L00002","USD","Tax"]
["eFiling 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)","443571595"]
["Production Filing (P to identify production filing.)","P"]
["Contact Information:","Info"]
["General Contact Name","John Smith"]
["General Contact Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["General Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",3222155]
["General Contact Extension (Use numbers only)",987]
["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","js@3d.com"]
["eFiling Contact Name","Ben Smith"]
["eFiling Contact Area Code (Use numbers only: \"916,\" not \"(916)\")",916]
["eFiling Contact Phone Number (Use numbers only: \"2223333,\" not \"222-3333\")",3222155]
["eFiling Contact Extension (Use numbers only)",789]
["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","bs@3d.com"]
["CDTFA USE ONLY:"]
["Report Type","DVW"]
["CDTFA Software Version","4.0"]

{"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 Codes","Mode Codes"]
[null,null,null,"13D","J"]
[null,null,null,"13E","IJ"]
[null,null,null,"13d","EJ"]
[null,null,null,"13e","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","8/1/2019",null,null,"RF"]
["Period End Date From Cover","8/31/2019",null,null,"AH"]
["Default Date","01/01/2002",null,null,"AJ"]
["First Date Return in Valid","01/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","DVW",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"]