The Tax Detail page is available when Expense is interfaced to Accounts Payable and the 'Enable Advanced Tax' option has been checked on the Expense tab in System Settings. Users will also need to be assigned permissions to the 'Tax Detail' processing option in Security.
This window displays the tax details calculated for the associated transaction line and allows for manual editing of the information. If the user modifies the amounts on the supporting record or changes the assigned Tax ScheduleTax Schedule, the tax amounts are recalculated and any previous manual changes will be lost.
Within the Procurement solution, the Tax detail information is transferred from Requisition to Purchase Order but the Invoicing process will recalculate the tax detail information based on the assigned tax schedules.
This read-only field displays the selected Tax Schedule from the transaction line.
This read-only field displays the Vendor for the transaction line.
This read-only field will appear for Requisition and Procurement transactions to display the Item ID that was selected on the transaction line.
This read-only field will appear for Travel and Expense transactions to display the line description.
This read-only field displays the total line amount from the associated transaction line to be used for tax calculations.
This read-only field will display the total tax amount included in the Price for the transaction line. This amount will include the total of all Tax Amount lines that have the 'Tax Included' option checked for the associated Tax ID.
This read-only field will display the total additional tax amount for the transaction line. This amount will include the total of all Tax Amount lines where the 'Tax Included' option is not checked for the associated Tax ID.
This read-only field will display the total tax amount applied to the transaction line. The total tax will be a sum of the Tax Included and Additional Tax amounts for the line item.
Select this box, then the Save Button to remove the entered line.
This is the tax id that was either loaded by default based on the assigned Tax ScheduleTax Schedule or manually entered by the user.
This field is available to optionally select a Vendor Tax Class when using the advanced Tax Class Rates functionality. The value will default based on the Tax Classes assigned at the Vendor level and is used in conjunction with the Item Tax Class to determine the tax percentage. Only Tax Classes setup with a Type of 'Vendor' will be available for selection.
This field is available to optionally select an Item Tax Class when using the advanced Tax Class Rates functionality. The value will default based on the Tax Classes assigned at the Item level and is used in conjunction with the Vendor Tax Class to determine the tax percentage. Only Tax Classes setup with a Type of 'Item' will be available for selection.
Checking this option will indicate that the tax amount is included in the Price for this Tax ID on the transaction line. This value will default from the 'Tax Included' setting for a Vendor that is setup with Tax Class Rates for the Tax ID or from the 'Tax Included in Amount' setting for the Tax ID itself. This setting can only be enabled when the Tax ID has the 'Tax Included in Amount' option enabled.
The Tax Included value will be marked to reflect the type of tax calculation for the selected Tax ID. For Tax ID's setup based on 'Tax Included with Item Price', this will be checked. Otherwise, it will be unchecked to indicate that the tax will be added to the line amount.
When tax is included in the amount for a transaction line, the true taxable amount will be automatically calculated based on the associated tax percentages for all 'Tax Included' lines and displayed in the 'Taxable Amount' field.
The taxable amount will default based on the transaction line amount and 'Tax Included' option for each Tax ID. The amount is calculated as the original transaction line amount divided by 1 + the sum of all the 'Tax Included' percentages. If none of the tax lines are marked as tax included, this value will be the transaction line amount and can be manually edited to recalculate the tax for the specified Tax ID. If the 'Tax Included' option is selected for any Tax ID, the Taxable amount cannot be edited and will always be recalculated. Users will not be permitted to update the taxable amount when the 'Tax Included' flag is checked and will receive a message indicating 'Manual Tax Amount is not allowed when using Tax Included' when they attempt to do so.
This is the calculated tax amount based on the selected Tax ID, Tax Classes and Taxable Amount. This amount can be manually edited by the user. If either the Vendor Tax Class or the Item Tax Class has been marked as 'Exempt', this value will always be zero (0).
This read-only field displays the percentage or amount from the Tax setup. When the Tax Class Rates functionality is not being used, this will default from the Tax ID. If Tax Classes have been configured and applied to the tax line, the percentage will be populated based on the Vendor and Item Tax Class combination defined on the Tax Class Rates page.
A transaction line is entered with a Quantity of 1 and Price of $100 for a total 'Line Amount' of $100 that is subject to 3 taxing authorities outlined by the Tax ID's below;
Tax ID |
Taxable Amount |
Tax Amount |
TaxID1 = 25% Tax Included CHECKED |
$57.14 |
25% = $14.29 (included) |
TaxID2 = 50% Tax Included CHECKED |
$57.14 |
50% = $28.57 (included) |
TaxID3 = 2% Tax Included UNCHECKED |
$57.14 |
2% = $1.14 (additional) |
The Taxable amount for the transaction line is calculated to be $57.14 (100/(1 + 0.25 + 0.50) which serves as the basis for each tax calculation. The tax calculations above result in the following;
Line Amount = $100.00
Tax Included = $42.86
Additional Tax = $1.14
Total Tax = $44.00
Line Total = $101.14 (Original Line Amount + Additional Tax)
Save
Default Tax
Select this button to recalculate the taxes and amounts based on the assigned Tax Schedule.
calculate Tax
Select this button to recalculate the tax amounts for the selected Tax ID's.
Close