BeyondERP.Newsletter
Menu

Report page · Expense management

Expense types per employee

A report that finds expenses by the expense type that employees entered.

Business process
Manage time and attendance
Menu item
output:TrvCost
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 report that finds expenses by the expense type that employees entered.
What you do hereUse this report to list employee expenses by type, filtered by expense report number, expense category and legal entity.
ExampleFor example, a controller runs the report for legal entity BEAT and the Meals category for the quarter and sees one employee at 3,100.00 USD against a team average of 900.00 USD.
Expense types per employee 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 › Inquiries and reports › Expense types per employee
Set up firstExpense categories Microsoft Learn
Used next byExpense report policies Microsoft Learn
Related pagesStatistics on cost groups 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.

When to run it

When to run itWhen you analyze spending by employee and expense type, for example in a budget review or policy check.
How oftenOn demand, for example monthly or quarterly.
What the output showsEmployee expenses grouped by expense type, with totals per employee. An employee with a much higher total in one category is a candidate for a policy review.

Source: Microsoft Learn

Setup steps on this page

Compare employee spending by category

Spot unusual spending per employee and expense type.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Expense types per employee.
  2. In Records to include, filter on Legal entity (Record-ID) to choose the company to report on.
  3. Filter on Expense category to see only the expense types you want to compare, such as travel or meals.
  4. Run the report and compare employees' spending per expense type to spot unusual patterns.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Legal entityThe legal entity to report on.Microsoft Learn
Expense categoryThe expense categories for the expense types.Microsoft Learn

Common errors and fixes

MessageWhat to do
The report prints no linesRecords to include filters out everything, or the data isn't posted yet. Clear the filters, check the date range, and run it again. Microsoft Learn
The report runs but shows another company's data is missingReports read the current legal entity only. Change company and run the report again. Microsoft Learn

Test checklist

  1. Enter test expenses for two employees in two categories.
  2. Run the report for the legal entity and one category.
  3. Check each employee's total for that category.
  4. Check the header shows personnel number, worker name, company and accounting currency.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Compare employee spending by categoryRun it quarterly per category with a clear date range and follow up on employees far above the team average.The report groups each employee's expenses by category and expense type with totals, so outliers stand out.Should spending outliers lead to a policy rule?Comparing employees with different travel roles as if they should spend the same.Test: Totals per employee and category

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. The expense administrator runs this report; no Feature management feature is needed.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: the report runs in the legal entity you are signed in to and reads that company's expense data. Microsoft Learn
Can it be undoneNothing to undo: The report only reads expense data; it changes nothing. Microsoft Learn
If you change it laterTotals follow the expense category on each line, so a category change on old lines changes the grouping. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TrvCost Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itExpense administrator ExpenseAdministratorGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:TrvCost
Data migrationLoad order: The report has no data entity in Data management, so it can't be loaded from a file or a configuration template. It reads posted or entered expense data and prints it; nothing on it is loaded or migrated. Run it in each environment after the data is there.Microsoft Learn
Everyone

8Sources