Tax Authority Relationships Import Template
Collectors of tax must report it to the designated tax authority. A tax authority is a government agency that imposes a tax financial obligation on businesses conducting activities in their jurisdiction. The relationship is the reporting requirements for that financial obligation — it defines which tax forms you file, how often, and under which license numbers.
The Tax Authority Relationships Import Template enables you to bulk-import these relationships rather than configuring them one at a time in the SureTax portal. Each row captures the authority level, geographic details (state, county, city), filing information (tax form, frequency, filing method), license numbers, and contact information. Use this template to establish your compliance filing profile across all relevant jurisdictions within the CCH SureTax system.
Overview
All field names are case-sensitive. Data should be provided in CSV, XLSX, or XLS format.
You can also configure tax authority relationships manually through the SureTax portal at Menu > SureTax Returns > Tax Authority Relationships. The import template is the recommended approach for organizations with a large number of jurisdictions.
Import Field Reference
The table below lists all fields for the Tax Authority Relationships Import Template, including the display name, field name, field type, whether the field is required, and guidance on accepted values.
| Display Name | Field Name | Field Type | Required | Notes |
|---|---|---|---|---|
| Tax Authority Level | TaxAuthorityLevel |
string | Yes | The jurisdiction tier. Accepted values: State, County, City, Local, or Other. |
| State | State |
string | Yes | Two-character state/province abbreviation (e.g., TX, CA, LA). Max 2 characters. |
| Tax Form | TaxForm |
varchar(50) | Yes | The tax form name as listed in the SureTax Returns Forms List. Must match exactly (e.g., ST-100, R-1029, TPT2). You can find the available forms for a tax authority in the portal under Menu > SureTax Returns > Tax Authority Relationships. |
| County | County |
string | No | County name. Provide when the Tax Authority Level is County or when additional jurisdiction detail is needed. |
| City | City |
string | No | City name. Provide when the Tax Authority Level is City or when additional jurisdiction detail is needed. |
| Frequency | Frequency |
tinyint | Yes | Filing cadence. Accepted values: Monthly, Quarterly, Semi-Annually, or Annually. The system defaults to the lowest frequency available for the form. Update based on your actual filing requirements. |
| Effective Date | EffectiveDate |
date | Yes | The date from which this relationship is active. Provide in MM/YYYY format. This date drives when a return will be generated. The system defaults to the current month. |
| Expiry Date | ExpiryDate |
date | Yes | The date on which you want the form to no longer be generated for this authority. Provide in MM/YYYY format. |
| Filing Method | FilingMethod |
char(1) | No | How you submit the return to the tax authority. Accepted values: Paper, E-file, Web Upload, or EDI. Filing method availability varies by tax authority. This field can be updated at any time. |
| License | License |
nvarchar(25) | Yes | Your license or registration number with the tax authority. Provide the value without hyphens. |
| Preparer Contact Information | PreparerContactInformation |
nvarchar(512) | No | Email address of the preparer. Required when filing method is EDI. |
| Location ID | LocationID |
string | No | Location identifier associated with the return, if applicable. |
| Location License | LocationLicense |
string | No | Location-specific license number. Accepts alpha, numeric, or alphanumeric values. |
| Bank Account Name | BankAccountName |
string | No | Name from your Bank Account set-up in SureTax, if applicable. |
| Tax Type | TaxType |
string | No | Accepted values: Sales or Use. Required for tax forms that distinguish between sales and use tax returns (e.g., Alabama). |
| Custom Field 1 | CustomField1 |
nvarchar(50) | No | State- and form-specific value. See the Custom Fields Reference table below for details on which forms require this field and what values to provide. |
| Custom Field 2 | CustomField2 |
nvarchar(50) | No | State- and form-specific value. See the Custom Fields Reference table below for details. |
Custom Fields 1 & 2 Reference
Custom Field 1 and Custom Field 2 are used for state- and form-specific values that are required to complete the relationship set-up for certain tax forms. If your state/form combination is not listed below, these fields can be left blank.
| State | Tax Form | Custom Field 1 | Custom Field 1 Notes | Custom Field 2 | Custom Field 2 Notes |
|---|---|---|---|---|---|
| AL | MAT | Tax Type — Manage Locals ONLY | Optional. Value can be Sales, Sellers Use, Consumers Use, or Rental. | N/A | N/A |
| AZ | TPT2 | Location Code City | Optional. Provide numeric value (3 digits). | N/A | N/A |
| BC | Canada - BC Return | Business Number | Optional. Provide alpha or numeric value. | N/A | N/A |
| CA | CDTFA1150 | Other Deduction Description | Optional. Provide alpha or numeric value. | N/A | N/A |
| CA | CDTFA401A | Other Deduction Description | Optional. Provide alpha or numeric value. | N/A | N/A |
| IL | ST1 | Signature Code | Optional. Provide alpha or numeric value. | Other Deduction Description | Optional. Provide alpha or numeric value. |
| IL | ST2COMBO | Signature Code | Optional. Provide alpha or numeric value. | Other Deduction Description | Optional. Provide alpha or numeric value. |
| IL | ST2SellersUse | Signature Code | Optional. Provide alpha or numeric value. | Other Deduction Description | Optional. Provide alpha or numeric value. |
| LA | PARISH | Import ID | Optional. Provide alpha or numeric value. | N/A | N/A |
| LA | R-1029 | NAICS Code | Optional. Provide alpha or numeric value. | N/A | N/A |
| LA | R-1031E | NAICS Code | Optional. Provide alpha or numeric value. | N/A | N/A |
| ME | ST-7 | Business Code | Optional. Provide alpha or numeric value. | N/A | N/A |
| OK | STS20002A | Include Consumer Use | Optional. Value: Yes or No. Defaults to Yes if left blank. | N/A | N/A |
| SC | ST3 | Retail License | Optional. Provide alpha or numeric value. | N/A | N/A |
| SK | Canada - SK Return | Business Number | Optional. Provide alpha or numeric value. | N/A | N/A |
| TN | SLS-450 | Location ID | Optional. Provide alpha or numeric value. | N/A | N/A |
| VA | ST8Sch8B | Include Consumer Use | Optional. Value: Yes or No. Defaults to Yes if left blank. | N/A | N/A |
| VA | ST9Sch9B | Include Consumer Use | Optional. Value: Yes or No. Defaults to Yes if left blank. | N/A | N/A |
| WA | 2406 | Other Deduction Description | Optional. Provide alpha or numeric value. | N/A | N/A |
Importing a Tax Authority Relationship
To import tax authority relationships using this template:
- Navigate to Menu > SureTax Returns > Tax Authority Relationships.
- Click the Import icon below the map and to the right.
- You can either:
- Click Download Template to get a pre-formatted file with the correct column headers, or
- Prepare your own CSV/XLSX/XLS file with the column headers listed in the Import Field Reference above.
- Populate the template with your tax authority relationships. Ensure all required fields are filled in and values match the accepted formats described above.
- Click My File is Ready.
- Drag the file to the drop-box, or click Browse..., locate your file, and click Open.
- Click Next.
- Verify that your Source File Header and Row 1 Data match the Map To column, then click Next. The Summary displays.
- Click Finish to complete the import.
Viewing Import History
To view the import history and check whether each import was successful or failed:
- Navigate to Menu > Reports > Imports. The Import Log list displays.
- Select the desired imported file to review additional information about the import.
Exporting Tax Authority Relationships
You can export your existing tax authority relationships to a CSV file for review or backup:
- Navigate to Menu > SureTax Returns > Tax Authority Relationships.
- To export for all states, proceed to step 3. To export for a specific state, first select the desired state on the map.
- Click the Export icon below the map and to the right.
- A CSV file is downloaded with the tax authority relationships.
Setting Up Remote Sellers Tax Authority Relationships
Depending on your type of registration with a Department of Revenue (DOR), you may be required to file a different or additional return compared to the typical sales tax return. The table below lists the states that require separate filings for sales tax, sellers use tax, and consumers use tax returns, along with the configuration requirements in SureTax.
| State | Tax Form Reporting | Types of Activity | Nexus Sourcing Override (Import Only) | Rule Override | Regulatory Code (Pass in Data) |
|---|---|---|---|---|---|
| AL | 2100A & MAT | Sales Tax (in-state retailer) | Default or Sales | None or 1 | 70 |
| AL | 2100A, 2620, & MAT | Sales Tax & Sellers Use | Default | None | 70 |
| AL | 2620 & MAT | Sellers Use (out-of-state retailer) | Default or Use | None or 2 | 70 |
| AL | SSUT_2630 | SSUT — Simplified Sellers Use | Default or Use | None or 2 | 74 |
| AZ | TPT-2, Bus Code 017 | Sales Tax — Retail Sales in AZ | Default or Sales | None or 1 | 70 |
| AZ | TPT-2, Bus Code 605 | Sellers Use — Marketplace Facilitator — 3rd Party Sales in AZ | Default or Use | None or 2 | 74 |
| AZ | TPT-2, Bus Code 017 | Sellers Use — Marketplace Facilitator — Retail Sales in AZ | Default or Sales | None or 1 | 70 |
| AZ | TPT-2, Bus Code 605 | Sellers Use — Remote Seller outside AZ | Default or Use | None or 2 | 74 |
| FL | DR15 (single location), DR15CON (multiple) | Sales Tax | Default or Sales | None or 1 | 70 |
| FL | DR15 | Sellers Use | Default or Use | None or 2 | 70 |
| IL | ST-1 (single location), ST-2COMBO (multiple) | Sales Tax — Retailer’s Occupation Tax: origin rate | Default or Sales | None or 1 | 70 |
| IL | ST-2COMBO | Sellers Use — Retailer’s Occupation Tax: destination rate (interstate only) | Default or Use | None or 2 | 70 |
| IL | ST-1 | Sellers Use — Retailer’s Occupation Tax: state rate only (no nexus) | Use | None or 2 | 70 |
| KS | ST-36 | Sales Tax — Retailer’s Sales Tax | Default or Sales | None or 1 | 70 |
| KS | CT-9 | Sellers Use — Retailer’s Compensating Use | Default or Use | None or 2 | 70 |
| LA | R-1031 | Direct Marketer — Remote Sellers — flat rate | Default or Use | None or 2 | 74 |
| LA | R1029 & Parish | Sales Tax — Dealer | Default or Sales | None or 1 | 70 |
| LA | R-1029 & Parish | Sellers Use — Remote Retailer — all rates | Default or Use | None or 2 | 70 |
| MO | 53S | Sales Tax | Default or Sales | None or 1 | 70 |
| MO | 53V | Sellers Use — Vendors Use | Default or Use | None or 2 | 70 |
| OK | STS20002A | Sales Tax | Default or Sales | None or 1 | 70 |
| OK | SVU20005A | Sellers Use — Vendors Use | Default or Use | None or 2 | 70 |
| TX | 0114 (single location), 0115-0116 (multiple) | Sales Tax | Default or Sales | None or 1 | 70 |
| TX | 0115-0116 | Sellers Use — Remote Seller — single local rate | Default or Use | None or 2 | 74 |
| TX | 0115-0116 | Sellers Use — Remote Sellers — all rates | Default or Use | None or 2 | 70 |
| VA | ST9Sch9b (aka ST-9) | Sales Tax | Default or Sales | None or 1 | 70 |
| VA | ST8Sch8b (aka ST-8) | Sellers Use | Default or Use | None or 2 | 70 |
Column Definitions
- Types of Activity:
Sales= in-state retailer;Sellers Use= out-of-state retailer selling into the state. - Nexus Sourcing Override: Controls how sourcing rules are applied.
Defaultuses standard rules;SalesorUseforces the corresponding sourcing logic. This field is available via import only. - Rule Override:
Noneuses default rules;1applies sales-specific overrides;2applies use-specific overrides. - Regulatory Code: The code passed in your transaction data to route the transaction to the correct return.
70= standard sales/use;74= simplified sellers use or marketplace facilitator.
Example CSV
TaxAuthorityLevel,State,TaxForm,County,City,Frequency,EffectiveDate,ExpiryDate,FilingMethod,License,PreparerContactInformation,LocationID,LocationLicense,BankAccountName,TaxType,CustomField1,CustomField2
State,TX,0114,,,Monthly,01/2026,12/2026,E-file,123456789,preparer@company.com,,,,,,
State,AL,2100A,,,Monthly,01/2026,12/2026,Paper,987654321,,,,,,Sales,,
County,LA,PARISH,Orleans,,Quarterly,01/2026,12/2026,EDI,112233445,edi@company.com,,,,,,
CSV Template
Download the blank CSV template: TaxAuthorityRelationships.csv