Severance Tax File Upload

SV-6 Severance Tax Data File Upload

Overview

File upload options have been added to the SV-6 in order to facilitate data entry of Severance Tax data. This functionality allows the taxpayer/practitioner to upload oil and gas production data from a file, reducing the number of keystrokes that need to be performed within the OBG application.

Instructions

(Note: If you need assistance with registration or navigation of OBG, there are tutorials on the Ohio Business Gateway introduction page that can help.)

1.    In order to take advantage of the “file upload” (or express data entry) capability, you will first need to format your Oil and Gas Severance Tax data file properly. There are two formats that will be accepted: .txt and .csv. The file format specifications are provided at the end of this document.

2.    After signing into OBG, navigate to the Severance Tax Return page.

3.    When you get to the screen below, select the “File Upload” radio button, and then click the green box labeled “Select the file to be uploaded.” Then browse to and select the file to be uploaded. Select the "Next" button.

               

 

          4. Continue to follow the on-screen instructions.

5.    The Oil and Gas Severance Tax data screen should be pre-populated with the data that you uploaded. Any errors in the file or with the calculations will be indicated prior to the tax data screen. After verifying that the data is correct, select the Next button.

6.    Continue to follow the on-screen instructions and enter all severance tax data, as needed, to complete the Severance Tax return. Select the Next button.

7.    OBG will automatically calculate the SV-3 return for you. If the return is correct, select the Accept Data button on the final Severance Tax screen. This will mark the Severance Tax return as “ready to file” but will not file it yet.

 

File Upload Formats

Submitted files must be in a comma delimited text format (.csv or .txt) only and adhere to the File Format guidelines below.   There is a slightly different format for .txt than there is for .csv. 

 

.csv File Rules:

§  Download the Excel Template.

§  DO NOT change the format of the Excel file or the data may not upload successfully.

§  DO NOT use commas, dollar signs or any special characters within the fields. Decimals are required.

§  DO NOT include a period within the file name (i.e., Jan. 2009).

§  Each API well number should be 14 numeric characters. 

§  Enter all oil and gas production data in the Excel spreadsheet that is provided by the Ohio Department of Taxation.

§  Save the file to be uploaded as “.csv (comma-delimited)” format.

 

OBG SV-6 .csv (from Excel) Oil & Gas Schedule Data File Format

 

.txt File Rules:

§  Use a carriage return (Enter key) at the end of each oil and gas production schedule data set.

§  DO NOT use dollar signs or any special characters within the file.

§  DO NOT include a period within the file name (i.e., Jan. 2009).

§  Data for only one report can be contained in each file.

§  Each API well number should be 14 numeric characters. 

§  File extensions must be .txt.

 Oil and Gas Schedule Data File Format       

 

File Format

 

                         

API Well Number, Oil Production, Gas Production
API Well Number, Oil Production, Gas Production
API Well Number, Oil Production, Gas Production

                            

                                                                                       

 Sample File

                 

12345678910123,  100,  100
98765432109874,  200,  200