The next step is to create the tax rate structure. To enter tax rates:
- Expand Expense by clicking on the arrow .
- ExpandTaxes Taxes by clicking on the arrow .
- Click on on Tax Rate.
- In the Tax Rate screen, click the Add Click on the Add button.
- Follow the steps in the table below to enter tax rates.
- Fill in the necessary fields defined in the table below (Note: The first field is contingent on the selection made in System Options under Expense - VAT Rate):
- When the appropriate fields in the Setup Tax Rate screen are complete, click the Save button.
- Click the Back button.
- Repeat the above processes until all required tax rates are entered.
*Indicates a Required Field
...
Field
...
Description
...
Operating Unit:
- following fields:
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)
- Active*: Check the box if this tax code is to be available for selection now. (Checked by default)
- 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)
...
- Expense Type*:
...
- The expense type that this tax rate is applicable.
Country*:
...
The country in which this tax rate is applicable.
State
...
*:
...
If a specific state is subjugated to this tax rate, enter it here
Currency*:
...
The currency in which this tax rate is applicable
Effective Date*:
...
The date in which the tax rate takes effect.
- Description: Enter text to further identify the tax rate. This field is limited to 255 characters.
Tax 1
...
*:
...
VAT will be charged to this code (The code must first be created. See Tax Code.)
Tax 1 Rate %*:
...
The rate for the Tax 1 Code.
- Tax 1 Calculation*: Defaults to VAT: Based on Total Amount
- Tolerance (%)*: If a tolerance is allowed from the tax calculation
- Recovery (%)* : If there is a recovery percentage allowed from the tax calculation
Tax 2 Code:
...
An optional second level tax code.
Tax 2
...
Rate %:
...
The rate for the Tax 2 Code.
- Tax 2 Calculation*:
- VAT: Prorated - If the tax calculation is prorated.
- VAT: Based on Total Amount - If tax amount is calculated based off the business total.
- Tolerance (%)*: If a tolerance is allowed from the tax calculation
- Recovery (%)*: If there is a recovery percentage allowed from the tax calculation
- Click Save.
- Repeat the above processes until all required tax rates are entered.
*Indicates a Required Field
Tax Rate Notes
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.
...
Tax on Per Diem and Mileage/Fixed Rate expense types: Tax cannot be calculated on a per diem and fixed rate expense types.
Tax Setup Matrix:
Expense Type Setup Screen | ||||
| Optional Compute Tax is Enabled | Optional Compute Tax is Enabled | Optional Compute Tax is Disabled | Optional Compute Tax Is Disabled |
End User Interface |
"Tax Included" checkbox is checked | Yes (see ex. 1) | No (see ex.2) | Yes | No |
Business Amount is Tax inclusive: | Yes | No | Yes | No |
Tax is added to Business to calculate Business Total | No | Yes | No | Yes |
Auto Compute Tax is checked | Yes | No | Not Available | Not Available |
The Tax field can be set to zero | No | Yes | No | No |
Changing Business field triggers re-calculation of Total | Yes | Yes | Yes | Yes |
Changing Business field triggers re-calculation of Tax | Yes | No | Yes | Yes |
Changing Tax field triggers re-calculation of Business | No | No | No | No |
Changing Tax field triggers re-calculation of Total | Yes | Yes | Yes | Yes |
Example 1:
Screenshot of end user interface screen when "Tax Included" checkbox is checked.
The end user enters the tax-inclusive amount in the Business field and the system derives the business amount and tax.
Example 2:
Screenshot of end user interface screen when "Tax Included" checkbox is un-checked.
...
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 |