{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","General Information","Cover","Schedule","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":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,0,15,1],[16,0,16,1],[17,0,17,1],[0,2,17,2],[18,0,18,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["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.\nCDTFA-770-DVW-E (7-22)","STATE OF CALIFORNIA","Intentionally left blank"]
["DIESEL FUEL TAX CLAIM FOR REFUND—SALES TO ULTIMATE PURCHASERS","CALIFORNIA DEPARTMENT OF TAX AND FEE ADMINISTRATION"]
["INSTRUCTIONS"]
["1.  Enter all transaction information for summary schedule codes and transaction schedule codes on the Schedule worksheet. Note: All summary schedule code \n     transactions must be entered before any other schedule code transactions are entered. 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"]
["2.  Enter all information requested on the Cover worksheet. Detailed instructions are provided on the General Information worksheet. Note: All gallon and dollar \n     amounts must be entered as whole numbers. Do not use decimals. Round to the nearest whole number. "]
["3.  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 \n     and location."]
["4.  Create a Flat (FLT) file by clicking on the button below. You will be required to identify a file name and location for your FLT 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, your security setting may be set too high."]
["Click here for instructions on changing the security setting"]
["Press Enter to create FLT file","intentionally left blank"]
["5.  To upload the FLT file you created, go to onlineservices.cdtfa.ca.gov, and log in to your account. Note: The FLT file has a .txt extension, not .xlsm."]
["Click here to go to the login webpage"]
["For more information, visit our website at www.cdtfa.ca.gov. You may also call our Customer Service Center at 1-800-400-7115 (CRS:711). \nCustomer service representatives are available Monday through Friday from 7:30 a.m. to 5:00 p.m. (Pacific time), except for state holidays."]
["End of worksheet"]

{"sheet":"General Information","index":1,"n_rows":63,"n_cols":2,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,0,62,1],[0,1,61,1]]}
["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.\nGENERAL INFORMATION","Intentionally left blank"]
["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 MM DD, YYYY\n     (for example, August 13, 2022) or MM/DD/YY (for example, 08/13/22 or 8/13/22)."]
["3.  Enter the California Department of Tax and Fee Administration (CDTFA) nine-digit account number excluding letters or dashes \n     (for example, 123456789).  Eight-digit account numbers require a leading zero (for example, 012345678)."]
["4.  Employer Identification numbers (EINs) and Social Security numbers (SSNs) must be entered using nine digits \n     without dashes or letters."]
["5.  Two-digit identification (ID) type codes are required to identify ID numbers. Use 24 for EIN, 34 for SSN, \n     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 (for example .360 or .357)."]
["Cover Worksheet - General"]
["1.  Dates must be entered using a proper date format.  Proper date formats are MM DD, YYYY\n      (for example, August 13, 2022) or MM/DD/YY (for example, 08/13/22 or 8/13/22)."]
["2.  CDTFA account numbers must be entered using the nine-digit numeric portion, without dashes or letters\n      (for example, 123456789). Eight-digit account numbers require a leading zero (for example, 012345678)."]
["3.  EINs and SSNs must be entered using nine digits without dashes or letters."]
["4.  Two-digit ID type codes are required to identify ID numbers. Use 24 for EIN, and 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."]
["Cover Worksheet - Instructions"]
["1.  Enter the filing period dates in rows 3 and 4."]
["2.  Enter the account information requested in rows 6 through 17."]
["3.  Enter the taxable gallons for Diesel Fuel in column B on row 19 (line1)."]
["4.  Enter the tax rate for the taxable gallon amount in column B on row 20 (line 2). \n     Proper rate format is .NNN (for example, .130)."]
["5.  Enter the amount of refund claimed in column B on row 21 (line 3). Multiply the amount reported on row 19 (line 1) \n     by the rate reported on row 20 (line 2)."]
["6.  The total gallons reported in column B on row 19 (line 1) is entered on row 22 (line 4). The workbook will make this \n     calculation for you."]
["7.  The total amount of refund claimed as reported in column B on row 21 (line 3) is entered on row 23 (line 5). \n     The workbook will make this calculation for you."]
["8.  Enter the eFiling information requested in rows 25 through 28."]
["9.  Enter the contact information requested in rows 30 through 45."]
["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 MM DD, YYYY\n      (for example, August 13, 2022) or MM/DD/YY (for example, 08/13/22 or 8/13/22)."]
["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, without dashes or letters\n     (for example, 123456789). Eight-digit account numbers require a leading zero (for example, 012345678)."]
["5.  EINs and SSNs must be entered using nine digits without dashes and letters."]
["6.  Two-digit ID type codes are required to identify ID numbers. Use 24 for EIN, 34 for SSN, or 49 for account number."]
["Excel 2016 Security Settings"]
["If the Save As pop-up box does not appear when you click on the Press enter to create FLT 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 5 on the Instructions worksheet."]
["12.  Once you have successfully created a FLT 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. Ultimate purchasers are farmers who use fuel on a farm for farming purposes and exempt bus operators who use fuel in exempt bus operations. 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 (CDTFA-770-DV)."]
["Filing Requirements\nIf 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 (CDTFA-770-DV) with CDTFA, 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 (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 CDTFA to release, as necessary, certain otherwise confidential transaction information regarding volumes, invoice numbers, bills of lading, locations, dates, or methods 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":"Cover","index":2,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,5],[0,5,47,5],[15,2,16,4],[45,0,45,1],[0,0,0,1],[0,2,14,4],[23,2,47,4]]}
["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.\nDIESEL FUEL ULTIMATE VENDOR REPORT/CLAIM FOR REFUND",null,"Intentionally left blank",null,null,"Intentionally left blank"]
["Filing Period:","Date"]
["Period Beginning Date (Format of entry must be \"May 1, 2022\" or \"5/1/22\")"]
["Period Ending Date (Format of entry must be \"May 31, 2022\" or \"5/31/22\")"]
["Account Information:","Info"]
["CDTFA Account Number (Enter the nine numeric digits of account number for example \"123456789\" )"]
["Taxpayer's ID Qualifier (Enter \"24\" if providing EIN or \"34\" if SSN)"]
["Taxpayer's EIN or SSN"]
["Name (Enter legal name on CDTFA 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",null,"CDTFA USE ONLY"]
["ZIP +4 (Use if needed)"]
["Return Information:","Diesel\nCurrent Rate","Line Item","UOM","Qualifier"]
["1. Gallons of tax-paid diesel fuel to be refunded",null,"L00031","GA","Billed"]
["2. Tax rate (Note: Tax rate is reported with a decimal point and three digits for example \".100\" or \".130\")",null,null,"USD","Rate"]
["3. Amount of refund due",{"$f":"ROUND(B19*B20,0)","v":0},"L00031","USD","Tax"]
["4. Total gallons of tax-paid diesel fuel to be refunded",{"$f":"B19","v":0},"L00001","GA","Billed"]
["5. Total amount of refund",{"$f":"B21","v":0},"L00002","USD","Tax"]
["eFiling Information:","Info","Intentionally left blank"]
["Purpose Code  (“00” – Original; \"Blank\" – Resubmission or Supplemental)"]
["Purpose Transaction Type (\"Blank\" – Original; “6R” – Resubmission; “6S” – Supplemental)"]
["Sender's EIN (May be same as taxpayer)"]
["Production Filing (P to identify production filing.)","P"]
["Contact Information:","Info"]
["General Contact Name"]
["General Contact Area Code (Use numbers only: \"916,\" not \"(916)\")"]
["General Contact Telephone 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 Telephone 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 Telephone 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 Telephone Number (Use numbers only: \"2223333,\" not \"222-3333\")"]
["eFiling Contact Fax Extension (Use numbers only)"]
["eFiling Contact Email Address"]
["CDTFA USE ONLY:"]
["Report Type","DVW"]
["CDTFA Software Version","4.0"]
["End of worksheet"]

{"sheet":"Schedule","index":3,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,16,1048575,16]]}
["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","Intentionally left blank"]
[]
[]
[null,null,null,null,null,""]

{"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","7/1/2022",null,null,"RF"]
["Period End Date From Cover","7/5/2022",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"]