Creating Sales Tax Jurisdiction Codes

Create tax jurisdiction codes to identify tax rates for a jurisdiction and the G/L account (tax authority) to post the tax to. A tax jurisdiction code is not necessarily equal to one tax authority. For example, many states charge sales tax and allow counties and cities to add local sales taxes. One jurisdiction code may include the G/L accounts for more than one tax authority. The G/L account for one tax authority may be updated by more than one jurisdiction.

Tax jurisdiction codes are assigned to zip codes. During order entry, tax is applied according to the zip code.

In addition to its regular rate, each tax code can have a reduced tax rate. The reduced rate is triggered by tax exception groups. You can also use a tax jurisdiction code to:

Note: If you use the Eclipse National Sales Tax Database companion product, creating and maintaining tax jurisdiction codes is not required. Geocodes replace tax jurisdiction codes.

To create a tax jurisdiction code:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. In the Code field, enter a unique and descriptive tax code, up to 10 characters.

Do not use SHIPTO, BRANCH, BRANCH.PRC, BRSHIPTO, and PBRSHIPTO as tax codes. These are reserved words used in Eclipse.

The Tax Code IDs menu displays, listing currently defined effective dates and the option NEW.

  1. Select the option NEW.

  2. In the Effective Date field, enter the date when the new tax code becomes effective.

  3. In the Desc field, define the tax code or explain what political entity or entities the tax jurisdiction includes.

  4. In the Juris. G/L Account column, identify the G/L accounts (tax authorities) to which this tax jurisdiction must pay taxes. Press F10 to display a list of G/L accounts.

  5. In the Rate column, enter the normal tax rate for each G/L account. For example, enter a tax rate of 6.5 percent as 6.5.

  6. To allow a jurisdiction type to be assigned to each G/L account, in the Type column, enter one of the following:

  1. In the Use Tax Rate from Original Sales Order on Return Orders (Y/N/BLANK) field, enter one of the following to determine which sales tax rate to use on return orders:

Note: When you want to use the tax rate from the original sales order, and you are entering a return order, you must enter the original sales order number. Otherwise, the system uses the current tax rate. In addition, you cannot include positive quantity items on the return sales order.

Reduced Tax Rates

Some tax authorities identify types of products or customers that are eligible for a reduced tax rate. Each G/L account, or tax authority, can have a reduced tax rate in addition to its regular rate. This is not required, but the option is available.

To associate a reduced tax rate with a tax jurisdiction code:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. Display a tax jurisdiction code.

  3. If a tax authority offers a reduced rate, enter the rate in the Reduced field.

The reduced rate is used when triggered by a tax exception group.

Taxing Freight and Handling Charges

Freight and handling charges are considered to be tax exempt by the system, unless their associated G/L account is listed on this screen.

To make freight and handling charges in a jurisdiction taxable:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. Display a tax jurisdiction code.

  3. Use the Tax Misc G/L ID hot key to display the Tax Misc G/L ID screen, where you can enter the associated G/L account name. Press Esc to return to the Tax Jurisdiction Code Maintenance screen.

  4. In the Frt & Hndl field, enter the tax rate.

If there is...

Then...

a Total Freight amount entered on the Sales Order Entry Totals screen and a G/L account for freight is included on the Tax Misc G/L ID screen

the Total Freight amount will by multiplied by this rate to obtain the tax amount that will be posted for the freight.

no tax rate entered in the Frt & Hndl field when one is needed

the system will use the regular tax rate specified in the Rate field.

no Total Freight amount entered on the Sales Order Entry Totals screen, or there is no G/L account for freight included on the Tax Misc G/L ID screen

no tax will be applied to the Total Freight amount.

Maximum Taxable Dollar Amount

The maximum taxable dollar amount is an option Eclipse provides. Some local tax authorities set a maximum dollar amount on which tax can be charged. For example, if the price of an item on a sales order is $2500 and the Maximum Taxable amount is $1200, the full rate sales tax is only charged on $1200. If more than one authority within the jurisdiction has the same allowance then that amount should be repeated for each authority.

To enter a maximum taxable amount for a tax jurisdiction:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. Display a tax jurisdiction code.

  3. Max Txbl column displays either a blank or * Splt* to indicate that a value has been set on the Split Tax Rate Maintenance screen. Use the Split Rates hot key to enter a dollar amount into this field. For more information, see Splitting Sales Tax Rates.

  4. In the Per column, indicate whether the Maximum Taxable value is based on a single line item, extended line item, or the entire order. Press F10 and select Item, Ext, or Order.

If you select...

Then Eclipse checks...

Example: Max Taxable = $1600

Item

the dollar amount of each single item on the order. When the dollar amount on any item exceeds the Maximum Taxable value, the full rate sales tax is only charged on the maximum taxable amount.

3 widgets @ $2000 each = $6000

full tax on  $4800 (3 x $1600)

reduced or no tax on $1200 (3 x $400)

Ext (extended)

the extended dollar amount of each line item on the order. When the extended dollar amount on any line item exceeds the Maximum Taxable value, the full rate sales tax is only charged on the maximum taxable amount.

3 widgets @ $2000 each = $6000

full tax on $1600

reduced or no tax on $4400

Order

the total dollar amount of the entire order. When the dollar amount of the entire order exceeds the Maximum Taxable value, the full rate sales tax is only charged on the maximum taxable amount.

3 widgets @ $2000 each = $6000
5 tools      @ $1000 each = $5000

full tax on $1600

reduced or no tax on $9400

Product Exception Groups

If a product tax exception group spans all the customers in a jurisdiction, apply the tax exception to the tax jurisdiction rather than individual customers.

To apply a tax exception group to this tax jurisdiction:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. Display a tax jurisdiction code.

  3. Use the Prod Tax Exception Groups hot key to display the Exception Groups screen.

  4. For each group the jurisdiction participates in, press F10 and select the group.

  5. Press Esc to save the data.

Canadian GST and PST

If your company is Canadian, you can also flag a tax account associated with the tax code as a Goods and Services Tax (GST) or Provincial Sales Tax (PST) account. These settings are used for reporting purposes.

To flag a tax account as a GST or PST account:

  1. From the Files > Tax, Duty & Exchange Rates menu, select Tax Jurisdiction Code Maintenance to display the Tax Jurisdiction Code Maintenance screen.

  2. Display a tax jurisdiction code.

  3. Position the cursor on a G/L account.

  4. Use the GST/PST hot key to display the GST/PST Maintenance screen.

Note: This hot key is only used by Canadian distributors who have line item taxability enabled. This hot key must be enabled by setting the Enable GST/PST Hot Key In Tax Jurisdiction Code Maintenance control maintenance record to Y.

  1. Set the appropriate flag. Keep in mind that you cannot enter a Y in both the GST and PST columns.

See Also:

Sales Tax Jurisdiction Codes Overview

Sales Tax Overview