{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions - Create File","Cover","Schedule","Summary","Tables","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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 - Create File","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1]]}
["Instructions For"]
["Minnesota Revenue Fuel Reporting Schedule"]
["1.","Save the original template.  When you begin entering shipment data, resave the template according to the month you will be filing (example:  August 2012 return could be saved as \"Aug_2012\").  The next month you will start with the original template and repeat the above step for the next month."]
["2.","Enter all information requested on the \"Cover\" worksheet (click on the \"Cover\" tab below). "]
["3.","Enter all schedule information for summary schedules and transaction schedules on the \"Schedule\" worksheet (click on \"schedule\" tab below).  To sort by column, click on the column you wish to sort on.  Click again to change sort order.  Note: Every transaction must contain a schedule code (click on the \"table\" tab below to view schedule, product, mode, and state codes)."]
[null," Note: All gallons must be entered as whole numbers."]
["4.","Do not skip rows between shipments or leave the schedule code blank.  This may cause the summary to be inaccurate"]
["5.","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 and location."]
["6.","Create a Flat File by clicking on the button below.  You will be required to identify a file name and location for your flat file.  The summary page is calculated when the file is created.  If the button to create flat file doesn't work please press CTRL + w to create flat file."]

{"sheet":"Cover","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Minnesota Revenue Fuel Reporting Schedule"]
[]
["Filing Period:"]
["Period Ending Date (Format of entry  must be \"05/31/04\", MM/DD/YY)"]
["Account Information:"]
["Minnesota License Number (Enter 7 numeric digits of account number \"1234567\")"]
["Location Code (\"1\", \"2\")"]
["Taxpayer's FEIN or SSN"]
["Name (Enter legal name on BOE application)"]
["DBA"]
["Address Line 1 (Enter street address)"]
["Address Line 2 (Use if needed)"]
["City"]
["State (Use abbreviation \"CA\", \"NV\", etc.)"]
["ZIP"]
["ZIP +4"]
["Return Information:"]
["1. Total Gallons reported",{"$f":"Summary!D3+Summary!E3+Summary!E4+Summary!D4+Summary!D25+Summary!D26+Summary!D27","v":0}]
["E-Filing Information:"]
["Sender's FEIN (May be same as taxpayer)",null,null,"P","O"]
["Test/Production (T or P to identify test or production filing. Must be capitalized.)","P",null,"O","A"]
["Transaction Set Purpose Code (\"O\" = Original, \"A\" = Amended)","O"]
["No Activity Code (No Activity = \"1\")"]
["Minnesota Revenue Use Only:"]
["Report Type","SDR"]
["File Type","TXT"]
["Version","1.0.5"]
["File Signature","804832376066"]
["Total Tax Due",0]

{"sheet":"Schedule","index":2,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Schedule Code","Product Code","Supplier Name","Supplier FEIN",null,null,"Carrier Name","Carrier FEIN","Mode","Terminal or Origin","Dest. State","Dist/Buyer Name","Dist/Buyer FEIN","Ship Date (mm/dd/yy)","Bill of Lading",null,"Gross Gallons"]

{"sheet":"Summary","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5]]}
["Taxpayer:",{"$f":"IF(Cover!B9<>\"\",Cover!B9,\"Not Available\")","v":"Not Available"},null,"Period:",{"$f":"IF(Cover!B4<>\"\",Cover!B4,\"Invalid Period\")","v":"Invalid Period"}]
["Gasoline","PDA-46",null,"Gasoline","Other than Gasoline"]
[null,null,"From MN Terminals",0,0]
[null,null,"Imports",0,0]
[]
[null,null,"Exports",0,0]
[]
[null,null,"US Gov. from Terminals",0]
[null,null,"US Gov. from tax-paid stock",0]
[null,null,"Sales to Farmers",0]
[]
[null,null,"Adjustments",null,"Less Evap - 2.5%"]
[null,null,"Aviation",0,0]
[null,null,"E-85",0,0]
[null,null,"Qualifying Svc Stns",0,0]
["Special Fuel","PDA-49"]
[null,null,"Undyed Diesel/Kerosene",0]
[null,null,"Dyed Diesel/Kerosene",0]
[null,null,"Jet Fuel",0]
[]
[null,null,"Jet Fuel","Taxable Fuel"]
[null,"Credits",0,0,"Less Evap - 1%"]
[null,null,"Qualifying Svc Stns",0,0]
["Alternative","PAF-1"]
[null,null,"LPG",0]
[null,null,"CNG",0]
[null,null,"LNG",0]

{"sheet":"Tables","index":4,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":false,"merged":[[85,5,87,8],[21,5,21,6],[22,5,22,6],[23,5,23,6],[36,5,36,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[35,5,35,6],[29,5,29,6],[31,5,31,6],[33,5,33,6],[34,5,34,6],[13,5,13,6],[6,5,6,6],[8,5,8,6],[9,5,9,6],[4,0,4,2],[7,5,7,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[5,5,5,6]]}
[]
[]
[]
[]
["Schedule Codes",null,null,null,null,"Product Codes"]
["Code","Description","Record",null,null,"Description",null,"Codes"]
["2A","Gallons received from Minnesota terminals or refineries, origin tax-unpaid.","Detail",null,null,"Alcohol",null,123]
["2C","Gallons received imported, tax-unpaid.","Detail",null,null,"Methanol",null,243]
["5A","Sales of jet fuel sold to non-licensed distributors, retailers, bulk-end users","Detail"]
["5F","Taxable sales of Dyed diesel or Dyed kerosene","Detail",null,null,"Gasoline"]
["5PI","Qualifying Service Station Credit - Iowa","Summary",null,null,"Gasoline  (non-oxygenated and racing)",null,"065"]
["5PN","Qualifying Service Station Credit - North Dakota","Summary",null,null,"Gasohol",null,124]
["5PS","Qualifying Service Station Credit - South Dakota","Summary",null,null,"E85",null,"079"]
["5Q","Taxable sales of alternative fuels (LPG,CNG,LNG,E85) Summary per product","Summary",null,null,"Aviation Gasoline",null,125]
["5XA","Gallons sold to airport partially taxed","Detail "]
["7D","Tank Wagon sales for export","Summary"]
["8R","Gallons sold to U.S. Government tax-exempt from refinery.","Summary",null,null,"Diesel Fuel - undyed",null,160]
["10G","Special fuel sold for residential heating ","Summary",null,null,"Renewable Diesel - Undyed",null,"180"]
["13A","Transport loads sold for export","Detail",null,null,"Biodiesel- Undyed (B100)",null,284]
["13C","Sales to the United States Government from tax paid stock","Summary"]
["13D","Bulk gasolines sales to farmers from tax paid stock.","Summary",null,null,"Kerosene - undyed",null,142]
["15B","Terminal Disbursements.","Detail"]
[null,null,null,null,null,"Jet Fuel",null,130]
[null,null,null,null,null,"Sustainable Aviation Fuel (S100)",null,"131"]
["Transportation Type Mode Codes",null,null,null,null,"Diesel Fuel - dye added",null,228]
[null,null,null,null,null,"Diesel Fuel #4,#5,#6 - dye added",null,"153"]
["Code","Description",null,null,null,"Kerosene - dye added",null,"072"]
["J_","Truck",null,null,null,"Renewable Diesel - Dyed",null,"181"]
["R_","Rail",null,null,null,"Biodiesel  Dyed (B100)",null,290]
["B_","Barge"]
["S_","Ship",null,null,null,"Compressed Natural Gas (CNG)",null,224]
["PL","Pipeline"]
["GS","Gas Station",null,null,null,"Liquid Natural Gas (LNG)",null,225]
["BA","Book Adjustment"]
["ST","Stationary Transfer",null,null,null,"Propane (LPG)",null,"054"]
["CE","Summary Information"]
["RT","Removal from Terminal (other than by truck or Rail) for sale or consumption",null,null,null,"Waste Oil",null,"091"]
[]
[]
["State and Province Codes",null,null,null,null,"Minnesota Terminal Codes"]
["United States (US)",null,"Canadian (CA)",null,null,"Terminal ID#","Operator","City"]
["Code","State","Province","Code",null,"T41MN3400","NuStar Pipeline Operating Partnership, L.P. - Moorhead","Moorhead"]
["AK","Alaska","Alberta","AB",null,"T41MN3401","NuStar Pipeline Operating Partnership, L.P. - Sauk Centre","Sauk Centre"]
["AZ","Arizona","British Columbia","BC",null,"T41MN3402","Kinder Morgan Liquid Terminals LLC","Spring Valley"]
["AR","Arkansas","Manitoba","MB",null,"T41MN 3403","NuStar Pipeline Operating Partnership, L.P. - Roseville","Roseville"]
["CA","California","New Brunswick","NB",null,"T41MN3404","Marathon Petroleum ","St. Paul Park"]
["CO","Colorado","Newfoundland","NF",null,"T41MN3405","Magellan Pipeline Company, L.P.","Wrenshall"]
["CT","Connecticut","Northwest Territory","NT",null,"T41MN3406","Newport Terminal Corporation","Newport"]
["DE","Delaware","Nova Scotia","NS",null,"T41MN3407","Flint Hills Resources, LP-Pine Bend","St. Paul"]
["DC","District of Columbia","Nunavut","NU",null,"T41MN3410","Calumet Superior LLC","Esko"]
["FL","Florida","Ontario","ON",null,"T41MN3412","Magellan Pipeline Company, L.P.","Alexandria"]
["GA","Georgia","Prince Edward Island","PE",null,"T41MN3413","Magellan Pipeline Company, L.P.","Mankato"]
["HI","Hawaii","Quebec","QC",null,"T41MN3414","Magellan Pipeline Company, L.P.","Marshall"]
["ID","Idaho","Saskatchewan","SK",null,"T41MN3415","Magellan Pipeline Company, L.P.","St Paul"]
["IL","Illinois","Yukon Territory","YT",null,"T41MN3416","Magellan Pipeline Company, L.P.- Rochester","Eyota"]
["IN","Indiana",null,null,null,"T41MN3417","BNSF - Northtown","Minneapolis"]
["IA","Iowa",null,null,null,"T41MN3419","Swissport Fueling Inc","Minneapolis"]
["KS","Kansas",null,null,null,"T41MN3420","Signature Flight Support Corp.","Minneapolis"]
["KY","Kentucky",null,null,null,"T41MN3425","Northern States Power Co, Wisconsin","Eau Claire, WI"]
["LA","Louisiana",null,null,null,"T41MN3800","REG Albert Lea","Glenville"]
["ME","Maine",null,null,null,"T41MN3801","Minnesota Soybean Processors","Brewster"]
["MD","Maryland",null,null,null,"T41MN3802","EverCat Fuels","Isanti"]
["MA","Massachusetts",null,null,null,"T41MN3803","Al-Corn Clean Fuel","Claremont"]
["MI","Michigan",null,null,null,"T41MN3804","Archer Daniels Midland","Marshall"]
["MN","Minnesota",null,null,null,"T41MN3805","BioFuels Energy-Buffalo Lake Energy, LLC","Fairmont"]
["MS","Mississippi",null,null,null,"T41MN3806","Bushmills Ethanol, Inc","Atwater"]
["MO","Missouri",null,null,null,"T41MN3807","Central MN Ethanol Coop","Little Falls"]
["MT","Montana",null,null,null,"T41MN3808","Chippewa Valley Ethanol Co.","Benson"]
["NE","Nebraska",null,null,null,"T41MN3809","Corn Plus, LLP","Winnebago"]
["NV","Nevada",null,null,null,"T41MN3810","DENCO II","Morris"]
["NH","New Hampshire",null,null,null,"T41MN3811","GEVO","Luverne"]
["NJ","New Jersey",null,null,null,"T41MN3812","Granite Falls Energy, LLC","Granite Falls"]
["NM","New Mexico",null,null,null,"T41MN3813","Green Plains Renewable Energy","Fergus Falls"]
["NY","New York",null,null,null,"T41MN3814","Guardian Energy","Janesville"]
["NC","North Carolina",null,null,null,"T41MN3815","Heartland Corn Products","Winthrop"]
["ND","North Dakota",null,null,null,"T41MN3816","Heron Lake BioEnergy, LLC","Heron Lake"]
["OH","Ohio",null,null,null,"T41MN3817","Highwater Ethanol LLC","Lamberton"]
["OK","Oklahoma",null,null,null,"T41MN3818","Land O'Lakes","Melrose"]
["OR","Oregon",null,null,null,"T41MN3819","POET Biorefinering - Bingham Lake","Bingham Lake"]
["PA","Pennsylvania",null,null,null,"T41MN3820","POET Biorefinering - Glenville","Albert Lea"]
["RI","Rhode Island",null,null,null,"T41MN3821","POET Biorefinering - Lake Crystal","Lake Crystal"]
["SC","South Carolina",null,null,null,"T41MN3822","POET Biorefinering - Preston","Preston"]
["SD","South Dakota",null,null,null,"T41MN3823","Purified Renewable Energy","Buffalo Lake"]
["TN","Tennessee",null,null,null,"T41MN3824","Valero Renewable Fuels","Welcome"]
["TX","Texas",null,null,null,"T41MN3825","HUGO Railyard transfer station","Hugo"]
["UT","Utah",null,null,null,"*For terminals outside of Minnesota, check the IRS website at www.irs.gov.  A current list can be found at www.irs.gov/businesses/page/0,,id=6964,00.html"]
["VT","Vermont"]
["VA","Virginia"]
["WA","Washington"]
["WV","West Virginia"]
["WI","Wisconsin"]
["WY","Wyoming"]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}