Tax Table

In this topic, we continue our discussion of commands located on the Invoicing Menu.

Management of the various tax rates required by individual states are a critical part of your AIM system. The Tax table is used to add, edit, or delete tax rate information required by the states in which you do business.

  • On the Invoicing menu, click Tax Table.

Taxes for states are displayed on the Tax Table tab in the grid layout. In the following table, we will discuss the various button located in the Add/Edit Tax Record dialog box and their respective functions.

Button Function
Add a new tax record
Edit an existing tax record
Copy the selected tax information for insertion into a new tax record
Delete the selected tax record
Close the Add/Edit Tax Record dialog box

In the steps that follow, we will discuss how to search the Tax table for tax records, and how to add a new tax record. This information can be used later to edit existing tax records.

  1. Click on the StateName button to select a search operator. Choose from the following options:
    1. State – two letter state abbreviation
    2. StateName – name of the state
    3. Effective – date that the tax record goes into effect
  2. In the text box, type a search parameter that corresponds to the search operator that you just selected.
    For example, if you selected Effective, type the effective date of the tax record.
  3. In the state list, select a state to limit the search results to the state that you select.
    As an alternative, you can click ALL to view tax records from all states.
  4. Click the Add button to begin adding a new tax record.
    1. To use an existing record as a starting point, select the record in the grid, click Copy, and then modify the record as needed.
    2. To change or delete an existing record, select the record, then click Edit or Delete. You can modify our steps as needed to change an existing record.

Boxes and fields shaded in yellow indicate a required field. You must enter text into these fields in order to be able to save your changes.

  1. Enter the properties of the tax record on the Tax Detail table.
    1. State
    2. Municipality – must be enabled in the States table. The entry used only with Kentucky municipality taxes.
    3. Tax Code ID – select the tax code (type of tax) that you are adding. The list is populated with the tax transaction codes in the Invoice Codes table. The ID appears in the unlabeled box next to the Tax Code ID box.
    4. Tax – percentage or flat amount of the tax.
      1. Select either Percent or Amount (Flat) in the unlabeled box to define the tax amount (type).
      2. The Value box is populated automatically based on the entries in the preceding Tax boxes.
    5. Tax Line – select the which tax line the tax will occupy on invoices. This number should not be duplicated within the same state.
      1. Minimum – minimum tax amount to be used on invoices
      2. Max – maximum tax amount to be used on invoices
    6. Collected By – select the entity that is responsible for collecting the tax
      1. Company
      2. In House (your agency)
      3. Other
      4. Retail Agent/Broker
      5. Not Applicable
      6. Pay To Company ID – company to which payments are made. This list is populated with companies that have a category of taxing entity in the Company table.
      7. Applies Only to These Coverage Codes – coverage code that the tax applies to.
        1. Each code should be begin and end with a /. For example, if you want to include all coverage codes, type /ALL/.
    7. Alternatively, you can click the Select Codes and Rounding button, and then pick the coverage classes in the Coverage PickList dialog box.
      1. In the list, click Select All to select all coverage codes or Unselect All to deselect all coverage codes.
      2. Click Save when you are finished editing coverages or click Cancel to abandon your changes.
      3. Click Round to the Penny on individual codes and select a rounding option from the list.

        Alternatively, you can click Reset all to Round to the Penny to ensure that taxes on all state codes are rounded to the penny.

    8. Include Fees – tax should apply to the fees as well as the premium.
    9. Allow Override – person creating the invoice will have the ability to override the tax rate.
    10.  Fully Earned – tax is fully earned.
    11. Exclude TRIA – indicate whether the tax applies to Terrorism Risk Insurance Act (TRIA) premium
    12. Assign to Admitted Companies – tax applies to an admitted company.
    13. Use Endorsement Date – tax rate will be calculated based on the date an endorsement is processed or the original inception of the policy.
    14. Optional – tax is optional on policies, that is, users can remove the tax.
    15. Assign to Exempt Insured – tax should apply to a tax exempt named insured.
    16. Applies to Policy and/or Endorsement – tax applies to the selected option.
    17. Effective – date the tax rate is effective. You can type the date or click and use the Calendar.
    18. Expiration – date the tax expires. You can type the date or click and use the Calendar.
    19. Rounding – rounding method that applies to the tax.
    20. Applies To – tax applies to the selected agent type.
    21. Premium % – percentage of the premium to which the tax applies
    22. Section – type of coverage that the tax applies to

  1. In the Multi-State Options pane, enter the Non-admitted and Reinsurance Reform Act (NRRA) multi-state tax rules, if applicable.
    1. Rate Type – specific tax rule set that will be applied to the tax calculation. The list is only available when Surplus Lines Tax or Stamping Office Fee is selected in the Tax Code ID list.
      1. Blended – All home state premiums are taxed at the normal home state rates and any out of state premium is taxed at a special blended rate.
      2. Home State – All taxes and fees are calculated at the home state rate.
      3. Inter-State –  If the policy is a multi-state policy, a different rate applies to the whole premium.
    2. Apply to Gross Amount – Applies the tax to the total amount of the premium
    3. Apply when Risk State –  applies the tax to the amount of the risk state only

The Apply to Gross Amount and Apply when Risk State options become available when you have selected a valid tax ID code.

  1. Click the Tax Guidelines tab.
  2. Enter any incidental tax information for the state to which the tax applies. The information will be displayed in the AIM Tax Calculator.
  3. Click Save to save your changes or click Save/Add to save your changes and begin adding a new tax rate.
    Click Cancel to abandon any unsaved changes.

Related Topics Link IconRelated Topics

Concept Link IconSee Also