Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The next step is to create the tax rate structure. To enter tax rates:

  1. Expand Expense by clicking on the plus signarrow Image Added.
  2. Expand Taxes by clicking on the plus signarrow Image Added.
  3. Click on Tax Rate.
  4. Click on the Add button.
  5. Fill in the following fields:
    1. Operating Unit: Applies tax rate to single Operating Unit. If the field is left empty, the rate will apply to all Operating Units. (If T&E Option "Expense - VAT Rate" is set to Operating Unit)

    2. Active*: Check the box if this tax code is to be available for selection now. (Checked by default)
    3. Location: Applies tax rate to single Location. If the field is left empty, the rate will apply to all Locations. (If T&E Option "Expense - VAT Rate" is set to Location)
    4. Expense Type*: The expense type that this tax rate is applicable.
    5. Country*: The country in which this tax rate is applicable.

    6. State ID*: If a specific state is subjugated to this tax rate, enter it here

    7. Currency*: The currency in which this tax rate is applicable

    8. Effective Date*: The date in which the tax rate takes effect.

    9. Description: Enter text to further identify the tax rate. This field is limited to 255 characters.
    10. Tax 1 Code*: VAT will be charged to this code (The code must first be created. See Tax Code.)

    11. Tax 1 Rate %*: The rate for the Tax 1 Code.

    12. Tax 1 Calculation*: Defaults to VAT: Based on Total Amount
    13. Tolerance (%)*: If a tolerance is allowed from the tax calculation
    14. Recovery (%)* : If there is a recovery percentage allowed from the tax calculation
    15. Tax 2 Code: An optional second level tax code.

    16. Tax 2 CodeRate %: The rate for the Tax 2 Code.

    17. Tax 2 Calculation*:
      1. VAT: Prorated - If the tax calculation is prorated.
      2. VAT: Based on Total Amount - If tax amount is calculated based off the business total.
    18. Tolerance (%)*: If a tolerance is allowed from the tax calculation
    19. Recovery (%)*: If there is a recovery percentage allowed from the tax calculation
    20. Description: Enter text to further identify the tax rate. This field is limited to 255 characters.
    21. Active*: Check the box if this tax code is to be available for selection now. (Checked by default)
  6. Click Save.
  7. Repeat the above processes until all required tax rates are entered.

...

Two levels of taxes: If there are two levels of Tax, the second level is set up in the same fashion as the first. Different rates and tolerances can be configured for each level. If there is a second level, the first level rate must be greater than 0.00 and tax 2 Code should be set to VAT: Prorated. If there is only one VAT tax, it must be set as Tax1. If there are two VAT taxes and one is VAT prorated, the prorated must be set up as Tax 2 Code.

Expense Type > Optional Compute Tax Optional: Use this expense attribute to allow to zero out the tax rate. See the tax setup matrix below for details.

Expense Type > City Field→ City Field: If Tax rates are set up, the City Field must be enabled.Expense Type > Tax Field: If users are not to review or change the VAT calculation, the value in this field should be zero (0).

Taxable and non-Taxable expenses: Expense Reports can have expenses that have a Tax and expenses that do not have a Tax field enabled.

...

Example of how to does the Tolerance % works:

If tolerance rate TL= 10%, Tax rate T = 15%, expense before tax amount Amt=$100,


Tax Amount TX_Amt= Amt* t = $100*15% = $15;

Tolerance amount TL_Amt= TX*TL = $15*10%=1.5

Tax tolerance range: Max allowed amount = TX + TL_Amt = $15 + $1.5 = $16.5

                                  Min allowed amount = TX – TL_Amt = $15 - 1.5 = $13.5

The user input tax amount will be invalid if the amount is greater than $16.5 or less than $13.5