{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","General Information","Schedule","Cover","Diesel Tax Refund Computation","Tables (CDTFA Staff Only)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,4,1],[7,0,7,1],[8,0,8,1],[21,0,21,1],[0,2,21,2],[16,0,16,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[2,0,2,1],[3,0,3,1],[9,0,9,1],[10,0,10,1],[5,0,5,1],[6,0,6,1]]}
["This workbook has 5 active worksheets - General Information, Instructions, Schedule, Cover, and Diesel - Tax Refund Computation.  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-DV-E (7-22)","STATE OF CALIFORNIA","Intentionally left blank"]
["DIESEL FUEL ULTIMATE VENDOR REPORT/CLAIM FOR REFUND","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 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 on CDTFA website"]
["For product codes:"]
["Click here for a product code list"]
["For mode codes:"]
["Click here for a list of valid transportation mode codes"]
["2. Prepare the Diesel Tax Refund Computation worksheet. The Diesel Tax Refund Computation worksheet will assist you in calculating the tax due and completing your return."]
["Click here to go to Diesel Tax Refund Computation worksheet"]
["3.  Enter all information requested on the Cover worksheet. Detailed instructions are provided on the General Information worksheet. Note: All gallon and dollar amounts \n     must be entered as whole numbers. Do not use decimals. Round to the nearest whole number. A tax computation worksheet is available to assist you."]
["Click here to go to Diesel Tax Refund Computation worksheet"]
["4. 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 \n     name and location."]
["5. 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 settings may be set too high."]
["Click here for instructions on changing the security settings"]
["Press Enter to create FLT file","Intentionally left blank"]
["6. 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 state holidays."]
["End of worksheet"]

{"sheet":"General Information","index":1,"n_rows":71,"n_cols":2,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,70,1]]}
["This workbook has 5 active worksheets - General Information, Instructions, Schedule, Cover, and Diesel - Tax Refund Computation.  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\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      (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 \n     dashes (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\n     entered using nine digits without dashes or letters."]
["5.  Two-digit identification (ID) type codes are required to identify ID numbers: Use 24 for EIN, 34\n     for 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 (for example, .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; \n     2) Make sure no transactions are reported on the Schedule worksheet; and \n     3) Click the Press enter to create FLT file button on 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     (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,\n     and 34 for SSN."]
["5.  All gallon and dollar amounts must be entered as whole numbers. Do not use decimals. Round to\n     the 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 3 and 4."]
["2.  Enter the account information requested in rows 6 through 17."]
["3.  If the return is a No Activity return, enter \"1\" on row 20, and follow the No Activity reporting\n      instructions on this worksheet. No additional information is reported in the Return Information\n      section when reporting a No Activity return."]
["4.  Enter the taxable gallons for diesel fuel in the appropriate columns on row 22 (line 1). Diesel fuel\n      gallons at the current rate are reported in column B, and diesel fuel gallons at the prior rate are\n      reported in column C. (One tax rate per column. Do not repeat diesel fuel tax rates.)"]
["5.  Enter the tax rate for each taxable gallon amount reported on row 22 (line 1) in the appropriate\n      columns on row 23 (line 2). Proper rate format is .nnn (for example, .100)."]
["6.  The total gallons reported in column B row 22 (line 1) multiplied by the rate reported on row 23 (line 2) is now \n     entered on row 24 (line 3). The workbook will make this calculation for you. "]
["7.  The total gallons reported in all columns on row 22 (line 1) is entered on row 25 (line 4). The\n      workbook will make this calculation for you."]
["8.  The total amount of refund claimed as reported in all columns on row 24 (line 3) is entered on row\n      26 (line 5). The workbook will make this calculation for you."]
["9.  Enter the eFiling information requested in rows 28 through 31."]
["10.  Enter the contact information requested in rows 33 through 48."]
["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      (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\n      the nearest gallon or dollar amount."]
["4.  CDTFA account numbers must be entered using the nine-digit numeric portion, without dashes or \n      letters (for example, 023456789). 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\n      for 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 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 settings, 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 Flat (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"]
["B—Barge"]
["CE—Summary Information"]
["GS—Gas Station"]
["J—Truck"]
["PL—Pipeline"]
["R—Rail"]
["S—Ship (ocean marine vessel)"]
["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 be reimbursed for tax you paid on diesel fuel you subsequently sold without tax to ultimate purchasers. Ultimate purchasers are farmers who use fuel for farming purposes and exempt bus operators who use fuel in exempt bus operations. You may also use this form to request a refund of the tax paid on undyed diesel fuel exported for use outside California, sold to the U.S. government and its agencies or instrumentalities, or sold to train operators, and tax paid on undyed diesel fuel you used for purposes other than operating vehicles on highways in this state."]
["Filing Requirements"]
["You must file a periodic report with CDTFA listing your total diesel fuel purchases. On the same form, you may file a claim for refund of tax you paid on diesel fuel sold or used for the exempt purposes explained under General Information, provided you have not previously claimed a refund for the exempt sales on CDTFA-770-DV or CDTFA-770-DVW. You must file the report even if you have no exempt transactions or refunds to claim for the reporting period. The report is due on or before the last day of the month following the reporting period. Failure to file this report will result in the claim not being accepted."]
["Note: If you are filing a claim for refund, you must complete all appropriate schedules and submit them with this report/claim. Failure to properly complete the schedules will result in a delay in processing the refund."]
["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":"Schedule","index":2,"n_rows":2,"n_cols":18,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Schedule\nCode","Product\nCode","Carrier Name","Carrier ID","Carrier ID Type (24, 34, or 49)","Mode","Point of Origin","Destination","Buyer/Seller Name","Buyer/Seller ID","Buyer/Seller ID Type\n(24, 34, or 49)","Document Date\n(MM/DD/YY)","Document Number","Net Gallons","Gross Gallons","Billed Gallons","Tax Rate (.nnn)","Import/Purchase Date\n(MM/DD/YY)"]
["",null,null,null,null,""]

{"sheet":"Cover","index":3,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,6,51,6],[0,2,16,5],[0,0,0,1],[26,2,50,5],[48,0,48,1],[51,0,51,5],[17,3,17,5]]}
["This workbook has 5 active worksheets - General Information, Instructions, Schedule, Cover, and Diesel - Tax Refund Computation.  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,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,\" among others)"]
["ZIP Code"]
["ZIP Code + 4 (use if needed)"]
["Return Information:","Diesel\nCurrent Rate","Diesel\nPrior Rate","CDTFA USE ONLY"]
["Click here to go to the Diesel Tax Refund Computation Worksheet","intentionally left blank","intentionally left blank"]
["No Activity To Report (Enter 1 if no activity. Otherwise, leave blank.) ",null,"intentionally left blank","Line Item","UOM","Qualifier"]
["Click here for complete No Activity instructions.","intentionally left blank","intentionally left blank"]
["1. Gallons of tax-paid diesel fuel to be refunded",null,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,null,"USD","Rate"]
["3. Amount of refund due",{"$f":"ROUND((B22*B23),0)","v":0},{"$f":"ROUND((C22*C23),0)","v":0},"L00031","USD","Tax"]
["4. Total gallons of tax-paid diesel fuel to be refunded",{"$f":"SUM(B22:C22)","v":0},null,"L00001","GA","Billed"]
["5. Total amount of refund",{"$f":"SUM(B24:C24)","v":0},null,"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","DVM"]
["CDTFA Software Version","4.0"]
["End of worksheet"]

{"sheet":"Diesel Tax Refund Computation","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,21,3],[0,4,21,4],[13,0,13,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[12,0,12,3],[20,0,20,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3]]}
["This workbook has 5 active worksheets - General Information, Instructions, Schedule, Cover, and Diesel - Tax Refund Computation.  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 TAX REFUND COMPUTATION WORKSHEET",null,null,null,"Intentionally left blank"]
["Click here to return to Cover worksheet"]
["Click here to return to the Instructions worksheet"]
["This worksheet should be used to help you complete your return and calculate the refund due."]
["SECTION A. TAX-PAID CREDITS","FROM SCHEDULE","A\nDIESEL AT\nCURRENT RATE\n","B\nDIESEL AT\nPRIOR RATE\n"]
["1.  Tax-Paid Fuel Exported","13A"]
["2.  Tax-Paid Fuel Sold to the United States\n     Government","13C"]
["3.  Tax-Paid Fuel Sold for Use on Farms","13D"]
["4.  Tax-Paid Fuel Sold to Exempt Bus Operators","13E"]
["5.  Tax-Paid Fuel Sold to Train Operators","13G"]
["6.  Tax-Paid Fuel Used in an Exempt Manner Not\n     Reportable on Another Schedule ","13J"]
["7.  Total of Tax-Paid Credits (enter this amount in columns B and C on \n      line 1 of the Cover worksheet)","Intentionally left blank",0,0]
["Preparation of the Tax Refund Computation Worksheet"]
["A.  Tax-Paid Credits"]
["Line 1.  Enter, by tax rate, the total gallons of tax-paid diesel fuel exported below the California terminal racks by \n              adding the billed gallons (column P of the Schedule worksheet) of all Schedule 13A transactions."]
["Line 2.  Enter, by tax rate, the total gallons of tax-paid diesel fuel sold to the United States government by adding\n              the billed gallons (column P of the Schedule worksheet) of all Schedule 13C transactions."]
["Line 3.  Enter, by tax rate, the total gallons of tax-paid diesel fuel sold to a person who uses the fuel for farming\n              purposes by adding the billed gallons (column P of the Schedule worksheet) of all Schedule 13D\n              transactions."]
["Line 4.  Enter, by tax rate, the total gallons of tax-paid diesel fuel sold to exempt bus operators by adding the billed\n              gallons (column P of the Schedule worksheet) of all Schedule 13E transactions."]
["Line 5.  Enter, by tax rate, the total gallons of tax-paid diesel fuel sold to train operators by adding the billed gallons\n              (column P of the Schedule worksheet) of all Schedule 13G transactions."]
["Line 6.  Enter, by tax rate, the total gallons of tax-paid diesel fuel used in an exempt manner not reportable on any\n              other credit schedule by adding the totals (column P of the Schedule worksheet) for each disbursement\n              schedule coded 13J."]
["Line 7.  Enter the subtotal of gallons of diesel fuel transactions subject to credit during the reporting period by\n              adding lines 1 through 6 for columns A and B."]
["End of worksheet"]

{"sheet":"Tables (CDTFA Staff Only)","index":5,"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,"1A","J"]
[null,null,null,"12A","IJ"]
[null,null,null,"12B","EJ"]
[null,null,null,"12C","B"]
[null,null,null,"13A","IB"]
[null,null,null,"13C","EB"]
[null,null,null,"13D","R"]
[null,null,null,"13E","IR"]
[null,null,null,"13G","ER"]
[null,null,null,"13J","PL"]
[null,null,null,"2A","IP"]
[null,null,null,"1a","EP"]
[null,null,null,"12a","S"]
[null,null,null,"12b","IS"]
[null,null,null,"12c","ES"]
["Not Used",null,null,"13a","RT"]
["Not Used",null,null,"13c","RS"]
["Random Generated Interchange Control Number","705547806",null,"13d","RR"]
["Period Beginning Date From Cover","8/1/2019",null,"13e","RF"]
["Period End Date From Cover","8/31/2019",null,"13g","AH"]
["Default Date","01/01/2002",null,"13j","AJ"]
["First Date Return in Valid","01/01/2019",null,"2a","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","DVM",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"]