Skip to main content
Balance import
Search
Search Indirect Tax Support Help and Support.

This article applies to:

  • Product: ONESOURCE Indirect Tax,ONESOURCE Sales and Use Tax Compliance
  • Subject: Import

Balance Import wizard: Options window Tables/Lists tab

This tab includes selections for geographic tables and entity lists.

Geographic tables

Geographic tables include:
  • Geographic Name
  • Place Code
You can use a
Geographic Name
 table if you're passing ZIP Codes along with city, county, and district names to the system, and the spellings of the jurisdictional names in your system don't match the spellings in the system. Also, you can use this table if your system uses numerical references or alpha abbreviation for state designations that don't match the ones used by the United States Postal Service. By creating this cross-reference table, you can create import files that cross-reference your internal jurisdictional codes or names to the abbreviations or spellings found in the system's rate database without having to change your internal spellings.
You can use a
Place Code
 table to pass place codes instead of ZIP Code information to the system. With this table, you can cross-reference your internal country unique place codes to tax areas found in our rate database. By creating this cross-reference table, you can create balance import files without having to change your method of identifying tax areas.
If you've created a geographic table and want Balance Import to access your tables to use the cross-references, you can select the desired tables from the dropdown list associated with each geographic table.

Entity lists

Entity lists include:
  • Department
  • Customer
  • Vendor
Lists for Department, Customer, and Vendor differ from entity code lists, tables and charts in that they're tools designed to enhance reports as opposed to tools used to assist data processing for compliance reporting.
The
Department
 list lets you enter your internal department codes with their corresponding department names. You can then assign each department code as a parent department or as a child to an existing department code in the list. Assigning department information lets you furnish department codes on balance import files, and generate reports based on the parent/child hierarchy you have established in the list.
The
Customer
 list lets you enter and store customer information. You can then provide customer numbers in balance import data and view balance data in the ledger by customer number.
The
Vendor
 list lets you enter and store vendor information. You can then provide vendor numbers in balance import data and view balance data in the ledger by vendor number.If you've created any of the entity lists and include the required fields for those lists in your balance import file, you can select the lists you want from the dropdown list associated with each entity list.

Related Content