Petroleum Tax Return Preparation

The spreadsheet file below contains IRS terminal codes for fuel terminals in Minnesota, Iowa, Wisconsin, North Dakota and South Dakota. These codes are used when electronically filing fuel schedules to the department.

IRS Terminal Codes for Minnesota and Surrounding States

For more information on electronically filing tax returns, view our EDI Implementation Guide.

EDI Implementation Guide (PDF)

Schedule File Text Format (PDF)

​You may submit fuel distributor schedules data in Microsoft Excel format, instead of using an Electronic Data Interchange (EDI) file. Use the template posted below, which lets you track all shipments and create the required detail file for sending to the department.

Distributor Report Excel Template (XLS)

Distributor Excel Template Zipped (for use with Excel 2010 and newer)

For more information on transmitting text files see Preparing Petroleum Tax Distributor Schedule Using Excel Template.

You may submit fuel producers data in Microsoft Excel format, instead of using an Electronic Data Interchange (EDI) file. Use the sample template posted below, which allows you to track shipments and create the required detail file for sending to the department.

Minnesota Producers Excel Template

For more information on transmitting text files, see Preparing a Petroleum Tax Schedule Using Excel Template.

​If the macro does not work on the cover worksheet: Check the macro security level. If the security is set too high, the macro will not work. Change the macro security level and then close excel and reopen.

If the Summary tab does not calculate to what you expected: Verify both the Product Code and Schedule Code are correct. Together those codes calculate your Summary worksheet. The product code always has to be three digits. For example, 65 will not calculate for gasoline. It needs to be 065. If only one line is not calculating, retype the codes for that line in case there are spaces within the cell. Be sure to make sure you have a date listed for summary entries as well. For example, "Sales to farmers" should have a date. You can use the last day of the month.

If you cannot see tabs at the bottom of the worksheet: Maximize the document window and/or program window

If a "Run Time" error is displayed while creating a macro: Check for valid dates on the Cover tab and the Schedule tab. Verify that there are not any incomplete or missing fields. If you still receive this error, download a new template.

If you can not log in to submit your Petroleum File: Call the Petroleum Office to verify that you are registered.

If you receive a "Not a Valid File Type" error while submitting your Petroleum File: Verify that the file extension matches the file type you have selected. Your file should be an EDI file (filename.edi) or a Text file (filename.txt).