Upload/Return File Instructions

Uploading Tax District Summary Address Database
Rates and jurisdictions provided through this upload are subject to revision on a quarterly basis. Submitted files must be in comma delimited text format (.CSV) with no header row and with the following fields in the order specified in the Upload File Format description below. Note: The Address, City, Zip Code, and As of Date fields are required and must contain valid alpha/numeric text. If the field is optional, you may leave that field blank in your file, but you need to account for the field in the comma delimited format. If you have any questions concerning the Upload File Format, please review the sample file at the bottom of this page.

Upload File Format
The structure of the upload file is as follows:

Field Name Description Format Length
Invoice # * Optional Retailer Record ID alpha/numeric 15
Address ** Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City ** City Name alpha 29
State State Abbreviation (OH only) alpha 2
Zip Code ** 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
As of Date ** MM/DD/YYYY Format numeric 10
* The Invoice # field in the file format pertains to the record number in which you identify this address on your system.
** Address, City, Zip Code, and As of Date fields are required.
 Date cannot be before 1/1/2004 and cannot be in the future.
Retrieving Updated Tax District Summary Address Database
Following your submission, please check the Upload/Return File Status Page . This page will display the status of your submissions and upon completion of the batch processing, your return file(s) will be available to download. The last 2 submissions will always be available for re-download. Each retrieval will consist of two downloadable files named "{user_id}_{job_id}TSAR.csv" and "{user_id}_{job_id}TSAE.csv" where {user_id} represents the numeric identity of your online user account and {job_id} corresponds to the sequential Upload Job ID of your file at the time of submission.

Results File Format
The structure of the results file is as follows:

Field Name Description Format Length
Invoice # Optional Retailer Record ID alpha/numeric 15
Reference # Reference ID for the specific transaction (9999-9999999999) alpha/numeric 15
Address USPS Standardized Address Line 1 alpha/numeric 61
Suite USPS Standardized Address Line 2 alpha/numeric 61
City USPS Standardized City Name alpha 29
State State Abbreviation alpha 2
Zip Code USPS Standardized 5-digit Zip Code numeric 5
Zip Plus USPS Standardized Zip+4 Extension numeric 4
As of Date MM/DD/YYYY Format numeric 10
State FIPS State FIPS Code numeric 3
County FIPS County FIPS Code numeric 3
Transit FIPS Transit FIPS Place (N/A, if transit does not exist) alpha/numeric 5
Sales Tax Rate Decimal Value of Combined Sales Tax Rate (9.9999) numeric 6
SD Name School District Name alpha 50
SD Number Department of Taxation School District Number numeric 4
ODE Number Department of Education School District Number numeric 6
School District Tax Rate School District Income Tax Rate (9.9999) numeric 6
Municipality Name Name of the municipality in which the address is located. alpha 20
Municipal FIPS Code Municipal FIPS Code. numeric 5
Municipal Income Tax Rate Municipal Income Tax Rate (9.9999) numeric 6
Date Processed MM/DD/YYYY Format numeric 10

Error File Format
The structure of the error file is as follows:

Field Name Description Format Length
Invoice # Optional Retailer Record ID alpha/numeric n/a
Reference # Reference ID for the specific transaction (9999-999999999) alpha/numeric 15
Address Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City City Name alpha 29
State State Abbreviation alpha 2
Zip Code 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
As of Date MM/DD/YYYY Format numeric 10
Result Type Error Match Code alpha/numeric 4

Error Codes

Error Match Code Description
E010 Required fields were not provided.
E011 Input zip code was not in Ohio.
E012 City was not found.
E020 Could not locate matching street.
E022 Could not locate this street number.
E023 Match is unresolved.
E024 Could not locate this street number.
E027 Could not match directional information.
E030 Invalid date.
E033 Address found was not in Ohio.
E034 Required fields were not provided.
E035 Invalid input state (OH only).
E036 An Ohio school district could not be found for the input address.


Examples Files

Sample Upload File
1,1615 GARFIELD AVE,,ASHLAND,OH,44805,,8/17/2004
2,7137 MARTIN RD,,WEST SALEM,OH,44287,,8/17/2004
3,5002 N MYERS RD,,GENEVA,OH,44041,,8/17/2004
4,6698 DEERVIEW DR,,LOVELAND,OH,45140,,8/17/2004
5,6702 US 20,,METAMORA,OH,43540,,8/17/2004
6,2383 RT 61 S,,NORWALK,OH,44857,,8/17/2004
7,13834 FANCHER RD,,JOHNSTOWN,OH,43031,,8/17/2004
8,29761 STANLEY RD,,NEW MARSHFIELD,OH,45766,,8/17/2004
9,4454 WING VIEW LN,,KETTERING,OH,45429,,8/17/2004
10,9439 MEADOWTRAIL CT,,LOVELAND,OH,45140,,8/17/2004

Sample Results File
1,1104-4414,1615 GARFIELD AVE, ,ASHLAND,OH,44805,3549,8/17/2004,039,005,N/A,0.0725,ASHLAND CSD,0301,043505,0,ASHLAND,02568,0.015,11/18/2004
2,1104-4415,7137 MARTIN RD, ,WEST SALEM,OH,44287,9065,8/17/2004,039,169,N/A,0.0675,NORTHWESTERN LSD (WAYNE CO.),8505,050575,0.0125,,,0,11/18/2004
3,1104-4416,5002 N MYERS RD, ,GENEVA,OH,44041,7704,8/17/2004,039,007,N/A,0.07,GENEVA AREA CSD,0404,044057,0,,,0,11/18/2004
4,1104-4417,6698 DEERVIEW DR, ,LOVELAND,OH,45140,5919,8/17/2004,039,025,N/A,0.07,LOVELAND CSD,3108,044271,0,,,0,11/18/2004
5,1104-4418,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,8/17/2004,039,051,N/A,0.07,EVERGREEN LSD,2602,047050,0.0075,,,0,11/18/2004
6,1104-4419,2383 STATE ROUTE 61, ,NORWALK,OH,44857,9183,8/17/2004,039,077,N/A,0.075,MONROEVILLE LSD,3902,047712,0,,,0,11/18/2004
7,1104-4420,13834 FANCHER RD, ,JOHNSTOWN,OH,43031,8129,8/17/2004,039,089,N/A,0.07,JOHNSTOWN-MONROE LSD,4503,047985,0.01,,,0,11/18/2004
8,1104-4421,29761 STANLEY RD, ,NEW MARSHFIELD,OH,45766,8903,8/17/2004,039,163,N/A,0.075,ALEXANDER LSD,0501,045906,0,,,0,11/18/2004
9,1104-4422,4454 WING VIEW LN, ,KETTERING,OH,45429,3102,8/17/2004,039,113,57000,0.075,KETTERING CSD,5705,044180,0,KETTERING,40040,0.0175,11/18/2004

Sample Error File
10,0904-32425,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,8/17/2004,E020


Upload your Tax District Summary Address File