State/Fed Reports
Table of Contents
Federal
ST-1 Backup Withholding | This report lists all owners gross and withholding by period and State/US. This report can be run at the Distribution level by checking the box Print/Accumulate by Distribution to have the ability to separate out the withholding done at the distribution level, interest type, sequence, and amounts that the withholding was based on. |
SF-2 ONRR Form 2014 | This creates a royalty report and upload file for Federal royalty reporting. |
ST-5 Severance Tax Exemptions | This report provides the Supporting Schedule for Severance Tax basis reduction. |
ST-9 Severance Tax Effective Rate Report | Supporting schedule for severance tax effective rates. |
NOTE: You must be authorized for each state to run the corresponding reports. Please contact your Account Manager for pricing and more information.
Also see: OGP State Specific Setups or FP Setup for Specific States
Arkansas
T-12 AR Severance Tax Report | This report creates the Arkansas Oil Severance Tax Report and online filing. Enter the Account and/or Sub-account and the Effective Date range. |
T-13 AR Conservation Internal Review Report | This creates an internal report for Arkansas Conservation Tax. |
Colorado
CO Conservation Tax File | This report creates a PDF for filing the Colorado Oil and Gas Conservation Levy quarterly report. |
Illinois
IL Severance Tax Report | This report creates the Illinois Severance Tax Report. Enter the Account and or Sub-Account and the Effective Date range in order to create the report for the desired time frame. |
Indiana
IN Severance Tax Report - (Form MF 600) | This report creates the Indiana Severance Tax Report. Enter the Account and/or Sub-Account and the Effective Date range in order to create the report for the desired time frame. The tax payer information for this report pulls in from the First Purchaser > Company Maintenance > Company > General tab. |
Kansas
KS Severance Tax KDOR Report | Running this report will provide the detail necessary to fill out the Kansas Oil Severance Tax Monthly Report (KDOR). A CSV file can also be created to upload to the state.Define the Tax Liability account and/or Sub-Account, the conservation account and/or Sub-Account, the effective date range, and the report type. |
Kentucky
KY Severance Tax Report | This report creates the Kentucky Severance Tax Report. Enter the Account and or Sub-Account and the Effective Date range in order to create the report for the desired time frame. |
KY Property Tax Return - Gas | Kentucky Gas Property Tax Return |
KY Property Tax Return - Oil | Kentucky Oil Property Tax Return |
Louisiana
LA Severance Tax Report | This report will provide a list summarized by parish, barrels, and amt due. Check the corresponding box to create the EDI file to upload. Validation exists to print an error log if any parish code, field code, producer code, LUW code, tax rate code, or schedule code is missing. If there is amended data covering more than one month, a separate amended report will be produced for each month being amended. |
LA Gas Severance Tax Report | This provides the detail to fill out the Louisiana Gas Severance Tax Monthly Report. Also has the option to create an EDI file to upload to the state. Includes reports G1-S and G1-D. |
LA Oilfield Site Restoration Fee Report | This creates the PDF for filing the quarterly Louisiana Oilfield Site Restoration Fee Form R-9050. |
Michigan
T-14 MI Oil Severance Tax Report |
This exports the Michigan Oil Severance Tax Return forms: 381 Oil Severance Tax Return 383 Production Report- Gross Production by Well Schedule 384 Exempt Production and Value Report by Well Schedule |
T-15 MI Gas Severance Tax Report |
This exports the Michigan Gas Severance Tax Return forms: 382 Gas Severance Tax Return 383 Production Report- Gross Production by Well Schedule 384 Exempt Production and Value Report by Well Schedule |
SF-5 Michigan PR4227-7 Royalty Remittance | This creates a royalty report for the state of Michigan Department of Natural Resources. |
Missouri
MO First Purchaser Fee Report | This creates a PDF for filing the Missouri Oil and Gas First Purchaser Fee Report. |
Montana
SF-3 MT Form 5 | This creates a royalty report for the state of Montana. |
New Mexico
NM Oil and Gas Taxes Detail Report |
This report prints the New Mexico Oil & Gas Taxes Detail Report (internal reference only) and creates an electronic file, which can be uploaded to the state. The report creates a Total Tax Due amount that is visible on the internal report and is a part of the electronic file. Note: NM Severance Tax EDI file reports will display a line for each State Property#. If more than one property has the same State Property#, you will see one line for the total of those properties with a (+) plus sign. Then below that line you will see each property listed that is in that (+). |
NM Quarterly Withholding Report | This provides the detail to complete the Quarterly New Mexico Withholding report RPD-41284 and RPD-41355. In addition, the New Mexico Annual Withholding Reports RPD-41374 can also be created. The Annual Report, RPD-41374, will be saved as a PDF and as an XML file. All reports can be submitted to the state as a PDF by clicking on the PDF button at the bottom of the screen. |
North Dakota
ND Production/Extraction Tax File |
This report creates an Excel file for the North Dakota T-12 Report, which reports both Production and Extraction Tax. Notes:
|
SF-6 ND Royalty Report - Form ND-Roy | This creates a royalty report for the state of North Dakota Department of Trust Lands. |
Ohio
ST-4 OH Severance Tax File | This option will create a text file for Oil and Gas reporting for the state of Ohio. |
Oklahoma
OK Production/Excise Tax File | This report creates the Oklahoma Gross Production Monthly Tax Report XLS file for review, as well as the CSV upload. This supports Oil and Gas products as well as any "other" deductions from the Gross Value. |
Tennessee
ST-1 TN Severance Internal Review Report | This creates an internal report for TN Severance. This is NOT a state form. |
Texas
TX OIL Severance Tax EDI Report |
This report provides a listing to show oil to be reported to the state in the EDI file and creates EDI file to upload. The file being generated will validate for counties, well type according to State Property ID Number, and State Operator Code among other fields. Additionally, this report will make allowances for negative amounts, allow drilling permit RRC numbers on the report, allow the number seven as the first digit of the permit number, and allow and ID of STATEWIDE to be reported. If there is amended data covering more than one month, a separate amended report will be produced for each month being amended. This report is for Oil wells only. Tax Exempt- To set up Tax Exempt Codes you must set up the Severance Tax Code with the last two digits of the Tax Code to be the State Exemption Code. For example, if the Exemption Code is 03 then the Severance Tax Code could be OILEX-03. This code will then translate to the EDI record accordingly. Note: The Average Gravity is populated from the Run Tickets for that period. If there are not any Run Tickets found then the system will use the Estimated Gravity from the Production > Property Master > Production Tab. |
TX Gas Severance Tax EDI Report |
This report provides a listing to show gas to be reported to state. The EDI file can also be created to upload. Tax Exempt- To set up Tax Exempt Codes you must set up the Severance Tax Code with the last two digits of the Tax Code to be the State Exemption Code. For example, if the Exemption Code is 03 then the Severance Tax Code could be OILEX-03. This code will then translate to the EDI record accordingly. Note: Both Texas Severance Tax EDI file reports will display a line for each RRC#. If more than one property has the same RRC#, you will see one line for the total of those properties with a (+) plus sign. Then below that line you will see each property listed that is in that (+). |
Texas GLO-3 Report | This creates a royalty report for the state of Texas General Land Office. |
Also see TX Exempt Tax Code for TX Severance Tax EDI Report
West Virginia
ST-6 WV Producer/Operator Return | This report provides the West Virginia Oil & Gas Producer/Operator Return. This report will include revenue for all non-oil and non-gas quantities/receipts. |
Wyoming
SF-1 WY MR10 Report | This creates a royalty report and upload file for the state of Wyoming. |
SF-2 WY Ad/Val Est for Operators | This creates a report for Ad/Val taxes collected on behalf of the operator. NOTE: this is NOT the official state report. |
SF-3 WY Severance Tax Est for Operators | This creates a report of severance taxes collected on behalf of the operator. NOTE: this is NOT the official state report. |
SF-4 WY Conservation Tax Attachment for State | This creates an internal review report of conservation tax collected that can be used in filing Wyoming Oil and Gas Conservation Commission (WOGCC) Conservation tax form OG-001 |