BeyondERP.Newsletter
Menu

Page · Expense management

Matched expenses

A list page of expenses that were matched to another expense, such as an imported card line reconciled against an expense already submitted, with their transaction date, category, merchant, amount, currency and approval status.

Used by
Expense administrator, Contractor, Employee
Business process
Manage time and attendance
Menu item
TrvExpenseMatchedLines
Data entity
TrvCopilotAutomationExpenseEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page of expenses that were matched to another expense, such as an imported card line reconciled against an expense already submitted, with their transaction date, category, merchant, amount, currency and approval status.
What you do hereUse this page to check which expenses have been matched and to open the matched pair with View matched expenses.
ExampleFor example, an employee entered a 48.00 USD taxi fare by hand and later the same charge arrived from the card file; after matching, the card line is reconciled against the submitted expense and appears here instead of being paid twice.
Matched expenses 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

Business processManage time and attendance
Menu pathExpense management › My expenses › Matched expenses
Set up firstExpenses Microsoft Learn
Used next byExpense reports Microsoft Learn
Related pagesCredit card transactions Microsoft Learn
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.

Setup steps on this page

Check matched expenses

Confirm that keyed expenses and imported card lines for the same charge are reconciled once.

Steps from Microsoft

  1. Go to Expense management > My expenses > Matched expenses.
  2. Filter the list by Transaction date, Expense category, Merchant, Transaction amount, Currency or Approval status.
  3. Select an expense in the list.
  4. Select View matched expenses to see the expense it was matched to and check the amounts agree.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
View matched expenses (button)Opens the expense that the selected line was matched to.Checked in Dynamics 365
Approval statusThe workflow status of the matched expense, such as draft, in review or approved.Checked in Dynamics 365Approved
Transaction amountThe amount of the expense in its transaction currency.Checked in Dynamics 36548.00

Common errors and fixes

MessageWhat to do
You do not have access to enter expenses because you are not mapped to an employee record. Contact your manager or support team for assistance.Link the user to an employee with active employment and set a company on the user account. In the live system the pages under My expenses, Process expense reports and Process cash advances showed this message for a user with no employee record. Checked in Dynamics 365
A card line stays unattached after matchingMatching against submitted expenses needs the Expense reports reimagined enhancements feature. Turn it on and match the line again. Microsoft Learn

Test checklist

  1. Submit an expense report with a hand-entered expense.
  2. Import the same charge from the card file.
  3. Use Merge/Match on the Expenses page to match the card line to the submitted expense.
  4. Open Matched expenses and check the pair appears with View matched expenses.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check matched expensesFilter on the last month and on card payment methods, and open View matched expenses for any amount that differs from the card line.A keyed expense and the later card line describe one charge; the match is what stops the second line from being reported.Should employees reconcile card lines against submitted expenses?Reading a matched card line as a second, separate expense and adding it to a new report.Test: A late card line is matched to a submitted expense

Feature management and licence

Feature to turn onExpense reports reimagined enhancements (Must be on)
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. Employees use this page to check their reconciled expenses.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: matches are kept with the employee's expenses in their legal entity. Microsoft Learn
Can it be undoneReversible: The page only lists matches; it changes no data. Microsoft Learn
If you change it laterReconcile against submitted expenses comes with the Expense reports reimagined enhancements feature; matching an unattached card line to a submitted expense stops it from being reported again. Microsoft Learn
Technical architect

6Technical

Menu itemTrvExpenseMatchedLines Checked in Dynamics 365
FormTrvExpenseMatchedLines Checked in Dynamics 365
Data entitiesTrvCopilotAutomationExpenseEntityExpense Line Expense AI Agent Entity Checked in Dynamics 365TrvExpMobileExpenseEntityExpense Line Expense Mobile Entity Checked in Dynamics 365TrvExpMobileExpenseLineAttachedToReportEntityExpense Lines Attached to a Report for Approvals Checked in Dynamics 365TrvExpTransMobileEntityExpenses Checked in Dynamics 365TrvExpTransMobileV2EntityMobile Expenses Checked in Dynamics 365ProjExpenseExportEntityProject Operations integration project expenses export entity Checked in Dynamics 365TrvExpTransEntityExpenses (the expense lines; the matches themselves have no data entity) Microsoft data model
Who can open itPrivileges TrvExpenseReportMaintainDutiesMaintain travel requisitions and expenses TrvTravelRequestsAndExpensesMaintain
3 security rolesExpense administrator ExpenseAdministratorContractor HcmContractorEmployee HCMEmployee
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itExpense administrator ExpenseAdministratorContractor HcmContractorEmployee HCMEmployeeGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TrvExpenseMatchedLines
Integrate withTrvCopilotAutomationExpenseEntity data entity Checked in Dynamics 365
Data migrationLoad order: Matched expenses has no data entity in Data management, so it can't be loaded from a file or a configuration template. Matches are made by employees in the system; settle open reports before cutover so no match needs to move.Microsoft Learn
Everyone

8Sources