Import Template

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.

Important: Tax authority relationships must be configured before generating returns. Without these relationships, the Returns API will not have the filing obligations needed to produce return documents. The availability of a tax authority or tax form for creating a relationship is directly tied to establishing active nexus for the tax authority.

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
ALMATTax Type — Manage Locals ONLYOptional. Value can be Sales, Sellers Use, Consumers Use, or Rental.N/AN/A
AZTPT2Location Code CityOptional. Provide numeric value (3 digits).N/AN/A
BCCanada - BC ReturnBusiness NumberOptional. Provide alpha or numeric value.N/AN/A
CACDTFA1150Other Deduction DescriptionOptional. Provide alpha or numeric value.N/AN/A
CACDTFA401AOther Deduction DescriptionOptional. Provide alpha or numeric value.N/AN/A
ILST1Signature CodeOptional. Provide alpha or numeric value.Other Deduction DescriptionOptional. Provide alpha or numeric value.
ILST2COMBOSignature CodeOptional. Provide alpha or numeric value.Other Deduction DescriptionOptional. Provide alpha or numeric value.
ILST2SellersUseSignature CodeOptional. Provide alpha or numeric value.Other Deduction DescriptionOptional. Provide alpha or numeric value.
LAPARISHImport IDOptional. Provide alpha or numeric value.N/AN/A
LAR-1029NAICS CodeOptional. Provide alpha or numeric value.N/AN/A
LAR-1031ENAICS CodeOptional. Provide alpha or numeric value.N/AN/A
MEST-7Business CodeOptional. Provide alpha or numeric value.N/AN/A
OKSTS20002AInclude Consumer UseOptional. Value: Yes or No. Defaults to Yes if left blank.N/AN/A
SCST3Retail LicenseOptional. Provide alpha or numeric value.N/AN/A
SKCanada - SK ReturnBusiness NumberOptional. Provide alpha or numeric value.N/AN/A
TNSLS-450Location IDOptional. Provide alpha or numeric value.N/AN/A
VAST8Sch8BInclude Consumer UseOptional. Value: Yes or No. Defaults to Yes if left blank.N/AN/A
VAST9Sch9BInclude Consumer UseOptional. Value: Yes or No. Defaults to Yes if left blank.N/AN/A
WA2406Other Deduction DescriptionOptional. Provide alpha or numeric value.N/AN/A

Importing a Tax Authority Relationship

To import tax authority relationships using this template:

  1. Navigate to Menu > SureTax Returns > Tax Authority Relationships.
  2. Click the Import icon below the map and to the right.
  3. 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.
  4. Populate the template with your tax authority relationships. Ensure all required fields are filled in and values match the accepted formats described above.
  5. Click My File is Ready.
  6. Drag the file to the drop-box, or click Browse..., locate your file, and click Open.
  7. Click Next.
  8. Verify that your Source File Header and Row 1 Data match the Map To column, then click Next. The Summary displays.
  9. Click Finish to complete the import.
Note: The file format must be CSV, XLSX, or XLS. Ensure your file adheres to the expected format and includes all required fields. Malformed files will be rejected with error details.

Viewing Import History

To view the import history and check whether each import was successful or failed:

  1. Navigate to Menu > Reports > Imports. The Import Log list displays.
  2. Select the desired imported file to review additional information about the import.
Note: For any import, the far-left column shows a check mark icon for success or an alert icon for failure. See the far-right column for details on the specific error.

Exporting Tax Authority Relationships

You can export your existing tax authority relationships to a CSV file for review or backup:

  1. Navigate to Menu > SureTax Returns > Tax Authority Relationships.
  2. To export for all states, proceed to step 3. To export for a specific state, first select the desired state on the map.
  3. Click the Export icon below the map and to the right.
  4. 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)
AL2100A & MATSales Tax (in-state retailer)Default or SalesNone or 170
AL2100A, 2620, & MATSales Tax & Sellers UseDefaultNone70
AL2620 & MATSellers Use (out-of-state retailer)Default or UseNone or 270
ALSSUT_2630SSUT — Simplified Sellers UseDefault or UseNone or 274
AZTPT-2, Bus Code 017Sales Tax — Retail Sales in AZDefault or SalesNone or 170
AZTPT-2, Bus Code 605Sellers Use — Marketplace Facilitator — 3rd Party Sales in AZDefault or UseNone or 274
AZTPT-2, Bus Code 017Sellers Use — Marketplace Facilitator — Retail Sales in AZDefault or SalesNone or 170
AZTPT-2, Bus Code 605Sellers Use — Remote Seller outside AZDefault or UseNone or 274
FLDR15 (single location), DR15CON (multiple)Sales TaxDefault or SalesNone or 170
FLDR15Sellers UseDefault or UseNone or 270
ILST-1 (single location), ST-2COMBO (multiple)Sales Tax — Retailer’s Occupation Tax: origin rateDefault or SalesNone or 170
ILST-2COMBOSellers Use — Retailer’s Occupation Tax: destination rate (interstate only)Default or UseNone or 270
ILST-1Sellers Use — Retailer’s Occupation Tax: state rate only (no nexus)UseNone or 270
KSST-36Sales Tax — Retailer’s Sales TaxDefault or SalesNone or 170
KSCT-9Sellers Use — Retailer’s Compensating UseDefault or UseNone or 270
LAR-1031Direct Marketer — Remote Sellers — flat rateDefault or UseNone or 274
LAR1029 & ParishSales Tax — DealerDefault or SalesNone or 170
LAR-1029 & ParishSellers Use — Remote Retailer — all ratesDefault or UseNone or 270
MO53SSales TaxDefault or SalesNone or 170
MO53VSellers Use — Vendors UseDefault or UseNone or 270
OKSTS20002ASales TaxDefault or SalesNone or 170
OKSVU20005ASellers Use — Vendors UseDefault or UseNone or 270
TX0114 (single location), 0115-0116 (multiple)Sales TaxDefault or SalesNone or 170
TX0115-0116Sellers Use — Remote Seller — single local rateDefault or UseNone or 274
TX0115-0116Sellers Use — Remote Sellers — all ratesDefault or UseNone or 270
VAST9Sch9b (aka ST-9)Sales TaxDefault or SalesNone or 170
VAST8Sch8b (aka ST-8)Sellers UseDefault or UseNone or 270

Column Definitions

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