BeyondERP.Newsletter
Menu

Setup step on the Expense tax recovery page · Expense management

Check and release expenses for VAT recovery

Verify receipts and tax codes and mark reports Ready for recovery.

Used by
Expense administrator
Business process
Manage time and attendance
Menu item
TrvTaxRecovery
Main table
TrvExpenseTaxRecovery
Data entity
None for this page's own settings
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA page where the back-office team reviews expense reports that are eligible for VAT recovery.
What you do hereUse this page to check receipts and tax codes on eligible expense reports and to mark them Ready for recovery.
ExampleFor example, a back-office clerk filters the page to reports marked Ready for recovery and exports them to Excel for the third-party vendor that files international VAT returns.
Expense tax recovery page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter expense reports with recoverable VAT are posted and their paper receipts arrive.
How oftenPer VAT claim, for example monthly or quarterly.
What the output showsReports marked Ready for recovery, ready to export to Excel for the third-party VAT vendor or to claim domestically.

Source: Microsoft Learn

Setup steps on this page

Check and release expenses for VAT recovery

Verify receipts and tax codes and mark reports Ready for recovery.

Steps from Microsoft

  1. Go to Expense management > Process tax recovery > Expense tax recovery.
  2. Select the expense report to check.
  3. Check that the required receipts are attached and the sales tax group and item sales tax codes are correct.
  4. When the paper receipts arrive, compare them with the digital receipts.
  5. Change the status of the expense report to Ready for recovery.
  6. To send data to a third-party vendor, filter on Ready for recovery and select File > Export to Excel.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
StatusWhere the report is in recovery; set it to Ready for recovery once receipts and tax codes are checked.Microsoft Learn Ready for recovery
Sales tax groupThe tax group of the expense, filtered by the expense's country/region.Microsoft Learn
Item sales tax groupThe item tax group of the expense; a report without one can't be posted.Microsoft Learn

Common errors and fixes

MessageWhat to do
The approved expense report can't be posted because an item sales tax group is missingOpen Expense management > Setup > General > Tax configurations, find the item sales tax group for the country/region of the expense, add it to the line and post again. Microsoft Learn
Tax recovery can't be turned on in the parametersEnable tax recovery from expenses can't be used when US sales tax and use tax rules are on (Apply sales tax taxation rules = Yes). Microsoft Learn
A domestic receipt is refused for recoveryFor domestic recovery the receipt must be in the company's name, not the employee's. Microsoft Learn

Test checklist

  1. Turn on Enable tax recovery from expenses in Expense management parameters (not possible if US sales tax and use tax rules are on).
  2. Post an expense report with a foreign Country/region, sales tax group, item sales tax group and receipts attached; check the posting message lists the VAT transactions found for recovery.
  3. Open Expense tax recovery, select the report and check receipts, sales tax group and item sales tax codes.
  4. Change the status to Ready for recovery, filter on that status and use Export to Excel to check the VAT data exports.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check and release expenses for VAT recoveryWork the VAT recoverable work items each claim period; compare paper and digital receipts, then set Ready for recovery and export the list for the third-party vendor.Posting creates a VAT recoverable work item for each eligible report, and only reports marked Ready for recovery go into the claim.Should VAT on employee expenses be recovered?Claiming domestic VAT on receipts made out to the employee rather than the company, which the tax authority refuses.Test: A posted report reaches tax recovery

Number sequences

ReferenceShared or per companyNote
Tax recovery numberPer companyRecovery records take their number from the TrvTaxRecoveryNumber reference; BEAT uses number sequence Trav_9. Checked in Dynamics 365

Feature management and licence

Licence or add-inIn this system Employee and Contractor enter their own expenses, and Expense administrator sets up the module and processes documents. The expense mobile app needs the Employee role, a company on the user account and a link to an employee with active employment. A back-office team member handles the VAT recoverable work item created at posting; no Feature management feature is needed, but Enable tax recovery from expenses must be on in the parameters.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Recovery work items are created when the report is posted; missing tax data must be fixed before posting.
If you change it laterExpense tax recovery can't be turned on when US sales tax and use tax rules are enabled. Microsoft Learn
Technical architect

6Technical

Menu itemTrvTaxRecovery Checked in Dynamics 365
FormTrvTaxRecovery Checked in Dynamics 365
TableTrvExpenseTaxRecoveryShown as “Recoverable taxes” in Record infoKey field: TaxRecoveryNumberChecked in Dynamics 365
Data entitiesTrvExpenseTaxConfigurationEntityExpense tax recovery configuration (the tax configurations used on this page, not the recovery records) Microsoft data model
Who can open itPrivilegesMaintain expense tax recovery configurations TrvTaxRecoveryMaintainDutiesMaintain expense management process TrvTravelAndExpenseProcessMaintain
1 security roleExpense administrator ExpenseAdministrator
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TrvTaxRecovery
Data migrationTrvExpenseTaxConfigurationEntity (Expense tax recovery configuration): the tax configurations used to find the groups, not the recovery records.Load order: Recovery records come from posting; finish open recoveries before cutover and load only the tax configurations.Load first: Sales tax groups, Item sales tax groupsMicrosoft Learn
Table definitionTrvExpenseTaxRecovery columns and relations Microsoft data model
Everyone

8Sources