Import Tax table

The Setup Wizard's Import Tax Table command allows you to import pre-defined tax tables rather than setting up the Tax Table manually. Once imported, the Tax Table is populated with the related choice's associated values. Normally, this action is only performed once during the initial set up of your system. Typically, you do not need to clear the existing Tax Table unless you started to enter information manually in the Tax Table before realizing you could import an applicable Tax Table.

To complete the tax setup you then perform the following:

• define default tax names.
• specify the company tax number and create ledger codes specified while setting up the Tax Table.
• where applicable, specify tax (G.S.T.) credit information.
• where applicable, set up Contractor tax in two ways; either by flagging an invoice as a contractor invoice or by associating a Contractor tax to individual inventory items.
• where applicable, track the Duties and /or Tariffs owed Customs and associate individual inventory items with the appropriate code (s).
• Warning: These tax rates may be out of date or may not apply to your industry. Importing after setting up a Tax Table and using the system is NOT recommended. If absolutely necessary it is recommended that you back up your data and then clear the existing tax table before importing a pre-defined tax table.

Access

To import a tax table, select Setup Tools> Setup Wizard>Taxes> Import Tax Table. The Import Tax Table window shown in Figure 1 appears.

Figure 1: The Import Tax Table window

To import a pre-defined tax table

1. Optionally, check the Clear existing tax table check box.
2. Click the Pre-defined Tax Table down-arrow and select the desired pre-defined tax table from the list. Currently your choices are:

• TAXRATES-BCAUTOMOTIVE.BTR - includes provincial sales tax, federal sales (GST) tax, and environmental taxes for tires and batteries
• TAXRATES-BC.BTR - includes provincial sales tax, federal sales (GST) tax
• TAXRATES-TENNESSE.BTR - includes Tax 1, ANDERSON tax and Tax 3

3. Click [Import] to import the table. The Tax Table is populated with the associated values and the Tax Table Summary grid on this window displays the associated taxes. (If the Clear existing tax table check box is clear, these values are added in addition to the existing ones in your Tax Table).
4. Now you need to change the Tax Name defaults to match the selected pre-defined Tax Table.
   
   If applicable, you specify the Tax Credit information, Duty Codes (Jamaican customers only), Tariff Codes or set up contractor tax.

To select your default tax zone

1. Click the Select your default tax zone down arrow and select the default tax zone (usually this is the region/county your office is located in) from the drop-down list. The available choices are related to the pre-defined tax table you selected as follows:

• TAXRATES-BCAUTOMOTIVE.BTR - includes tax zones CA |PST and HT |PST
• TAXRATES-BC.BTR - includes tax zones CA |PST and HT |PST
• TAXRATES-TENNESSE.BTR - includes 95 county zones from 01 |ANDERSON to 95 |WILSON

2. Click [Apply] to set the default tax zone. In the Tax Table this default zone (area) appears blank to indicate it is the default zone.
    

< Return to: Taxes setup overview