Online Services: Upload Formats

OBG Full UUT-1 File Upload Formats

Overview

File upload options have been added to the UUT-1 in order to facilitate data entry of Use Tax data. This functionality allows the taxpayer/practitioner to upload all UUT-1 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. You may also test your file before uploading it to OBG by going selecting this link.

  1. In order to take advantage of the "Full UUT-1 File Upload" capability, you will first need to format your UUT-1 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 Use Tax (UUT-1) Return page.
  3. When you get to the screen below, select the "Full UUT-1 File Upload" radio button. Then browse to and select the file to be uploaded. Select the "Next" button.

               

  1. If any fields did not properly upload, you will be prompted to complete them manually. So please carefully follow the on-line instructions.
  2. Continue to follow the on-screen instructions. The tax liability field will automatically be calculated for you by OBG based on the tax rate and the amount of taxable purchases uploaded.
  3. OBG will automatically calculate the rest of the UUT-1 return for you. If the return is correct, select the Accept Data button on the final UUT-1 screen and respond to the questions concerning your payment options.
  4. When complete, this will mark the UUT-1 return as ready to file but will not file it yet.
When filing the UUT-1 return on OBG, you have the choice to enter return data while on-line or prepare a data file in advance and then uploadit to OBG.  Submitted files must be incomma delimited text format (.TXT or .CSV) and adhere to the County File Formatguidelines below. 

TXT File Rules:

  • Use a carriage return (Enter key) at the end of each county data set.
  • DO NOT use dollar signs or any special characters within the file.
  • Decimals are required to separate the whole dollars from the cents.  (100 = 100.00)
  • Data for only one report can be contained in each file.
  • Negative numbers may be used (-100.00, -7.05), as long as the total purchases and liability lines are positive.
  • File extensions must be TXT.
  • County sets do not need to be listed in numerical order by county.
  • The taxable liability field and any interest due will be calculated by the OBG application after you upload the file.  So any incorrect values will be changed based on the "Rate Code" and taxable purchase amounts.
  • Only data for counties that have taxable sales need to be included in this file.
  • The county code for the state is always 89 and the "Rate Code" is usually 23.
  • The application will calculate the Taxable Liability based on the entered "Rate Code". The rate code table is shown below.

Rate Codes

 

Rate Code

Rate

 

Rate Code

Rate

 

Rate Code

Rate

01

.0025%

 

 

02

.005%

 

03

.0075%

04

.010%

 

05

.0125

 

06

.015%

07

.0175%

 

08

.020%

 

09

.0225%

10

.0250%

 

11

.0275%

 

12

.030%

 

Below is an example of a full UUT-1 file upload format.  The following page demonstrates where the data comes from when looking at a UUT-1 paper return.   

 

<img v:shapes="_x0000_s1680 _x0000_s1679 _x0000_s1658 _x0000_s1659 _x0000_s1660 _x0000_s1661 _x0000_s1662 _x0000_s1663 _x0000_s1664 _x0000_s1665 _x0000_s1666 _x0000_s1667 _x0000_s1669 _x0000_s1670 _x0000_s1671 _x0000_s1672 _x0000_s1673 _x0000_s1674 _x0000_s1675 _x0000_s1676 _x0000_s1677 _x0000_s1678" src="http://www.tax.ohio.gov/portals/0/online_services/images/uut9.jpg" alt="UUT 1 Long Form" />

CSV File Rules:

  • Download the Ohio Department of Taxation Excel Template (10/28/13).
  • DO NOT change the format of the Excel file or the data may not upload successfully.
  • DO NOT type data into the fields that are shaded grey, as they will calculate for you.
  • DO NOT use commas, dollar signs or any special characters within the fields. Decimals are required.
  • The "Taxable Liability" field will be recalculated by the OBG application after you upload the file so minor one-cent rounding errors occasionally occur. 
  • Interest due will be calculated by the OBG application after you upload the file. So any incorrect values will be changed based on the "Rate Code" and taxable purchase amounts.
  • The "Totals" fields will be ignored by the OBG application. They are on the spreadsheet so users can ensure the correct amounts were entered.
  • If you need to add a duplicate county (because 2 rates apply for the filing period), you will need to add the county name and number at the bottom of the spreadsheet.
  • Negative numbers may be used, as long as the total sales and liability lines are positive.
  • Enter all County data in the Excel spreadsheet that is provided by the Ohio Department of Taxation (ODT).
  • Save the file to be uploaded as "CSV (Comma delimited)" format.
  • Then upload the CSV file to OBG the application, following the on-line prompts.

See sample below:

  • Step 1: Download Full UUT-1 Template
  • Step 2: Enter the following:
    • Account Number
    • Company Tax ID (FEIN:XX-XXXXXXX or SSN)
    • Report Start and End Dates
    • Type (Original or Amended)
    • Less Accelerated Payments (if applicable)
    • Plus accelerated payments (if applicable)
    • Interest (if applicable)
      Note:  interest will be recalculated by the application if return is late.
    • “Place a zero in this field because it will automatically be populated based off the current credit balance in your account for the period.”

Example

Rate Codes

 

Rate Code

Rate

 

Rate Code

Rate

 

Rate Code

Rate

01

0.00%

 

 

02

0.01%

 

03

0.01%

04

0.01%

 

05

0.01%

 

06

0.02%

07

0.02%

 

08

0.02%

 

09

0.02%

10

0.03%

 

11

0.0275%

 

12

0.03%

 

  • Step 3: Enter rate code and taxable purchases for each applicable county. Use the table above to determine the rate code.

Example

 

  • Step 4: Save as file as a CSV type.
  • Step 5: Upload the saved file to OBG as the system prompts.