Upload/Return File Instructions

Uploading Customer 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: 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
Taxable Amount †† Currency Format (99999999.99) numeric 11


* 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.
††  Minimum is $0.16, maximum is $90,000,000.

Retrieving Updated Customer 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}STAR.csv" and "{user_id}_{job_id}STAE.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
Taxable Amount Currency Format (99999999.99) numeric 11
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
Tax Amount Currency Format (99999999.99) numeric 11
Taxable Amount with Tax Currency Format (99999999.99) numeric 11
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 15
Reference # Reference ID for the specific transaction (9999-9999999999) alpha/numeric 15
Address Street Name and Number alpha/numeric 40
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 40
City City Name alpha 40
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
Taxable Amount Currency Format (999999999.99) numeric 12
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.
E031 Invalid taxable amount.
E033 Address found was not in Ohio.
E035 Invalid input state (OH only).


Examples Files

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

Sample Results File
1,0904-2926,1615 GARFIELD AVE, ,ASHLAND,OH,44805,3549,8/17/2004,2.91,39,5,N/A,0.0725,0.22,3.13
2,0904-2927,7137 MARTIN RD, ,WEST SALEM,OH,44287,9065,8/17/2004,9.03,39,169,N/A,0.0675,0.61,9.64
3,0904-2928,5002 N MYERS RD, ,GENEVA,OH,44041,7704,8/17/2004,9.3,39,7,N/A,0.07,0.66,9.96
4,0904-2929,6698 DEERVIEW DR, ,LOVELAND,OH,45140,5919,8/17/2004,2.37,39,25,N/A,0.07,0.17,2.54
5,1104-4398,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,8/17/2004,16.89,039,051,N/A,0.07,1.19,18.08,11/18/2004
6,0904-2931,2383 STATE ROUTE 61, ,NORWALK,OH,44857,9183,8/17/2004,12.34,39,77,N/A,0.075,0.93,13.27
7,0904-2932,13834 FANCHER RD, ,JOHNSTOWN,OH,43031,8129,8/17/2004,3.86,39,89,N/A,0.07,0.28,4.14
8,0904-2933,29761 STANLEY RD, ,NEW MARSHFIELD,OH,45766,8903,8/17/2004,18.38,39,163,N/A,0.075,1.38,19.76
9,0904-2934,4454 WING VIEW LN, ,KETTERING,OH,45429,3102,8/17/2004,3.8,39,113,57000,0.075,0.29,4.09

Sample Error File
10,1104-4403,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,8/17/2004,4.32,E022


Upload your Customer Address File