OBG Full UUT-1 File Upload Formats
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.
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.
- 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.
- After signing into OBG, navigate to the Use Tax (UUT-1) Return page.
- 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.
- If any fields did not properly upload, you will be prompted to complete them manually. So please carefully follow the on-line instructions.
- 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.
- 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.
- 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 upload it to OBG. Submitted files must be incomma delimited text format (.TXT or .CSV) and adhere to the County File Format guidelines 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.
- Only data for counties that have taxable purchases need to be included in this file.
- The county code for the state is always 89 and the "Rate Code" is currently 23. The state portion of the rate code is made up of the state code (89) and the rate code (5.75% divided by .25% = 23).
- The application will calculate the Taxable Liability based on the entered "Rate Code". The rate code table is shown above.
Below is an example of a full UUT-1 file upload format.
- Account No = Account Number or Vendors License Number
- Tax ID = Federal Employer Identification Number or Social Security Number
- Report Start = First day of the reporting period you are filing for in the format MMDDYYY
- Reporting End = Last of the reporting period you are filing for in the format MMDDYYYY
- Less Accelerated = Prepayments that have been made on the account for the period
- Plus Accelerated = Prepayment that will be made for the next reporting period
- Type = Can be Original (if it the first return being filed for the period) or Amended (a return has been filed but changes need to be made)
- Balance Due = Sum of the tax liabilities
- Purchase Detail by County: County Number, Rate Code, Taxable Purchases, Tax Liability
CSV File Rules:
- Download the Ohio Department of Taxation Excel Template (1/5/18).
- 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.
- 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 or Vendors License Number
- Company Tax ID (Federal Employer Identification Number or Social Security Number)
- Report Start and End Dates
- Type (Original or Amended)
- Less Accelerated Payments (if applicable)
- Plus accelerated payments (if applicable)
- Step 3: Enter rate code and taxable purchases for each applicable county. Use the table above to determine the rate code.
- Step 4: Save as file as a CSV type.
- Step 5: Upload the saved file to OBG as the system prompts.