Tax Rates
The next step is to create the tax rate structure. To enter tax rates:
- Expand Expense by clicking on the arrow .
- Expand Taxes by clicking on the arrow .
- Click on Tax Rate.
- Click on the Add button.
- Fill in the 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 → 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: If Tax rates are set up, the City Field must be enabled.
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 Mileage: Tax can be calculated on a mileage expense type, but the calculation is not shown to the user.
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:
| ||||
| 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 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 |
2024 DATABASICS, Inc