BeyondERP.Newsletter
Menu

Report page · Expense management

Personal expenses report

A report that shows the personal expenses an employee entered on an expense report.

Business process
Manage time and attendance
Menu item
output:TrvPersonalExpenses
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 shows the personal expenses an employee entered on an expense report.
What you do hereUse this report to list personal expenses, filtered by expense report number.
ExampleFor example, after a card statement shows 85.00 USD of personal restaurant charges on a sales trip, the expense administrator runs the report for that expense report number to confirm the employee marked them as personal and they aren't reimbursed.
Personal expenses report 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 › Personal expenses report
Set up firstExpense management parameters Microsoft Learn
Used next byApproved expense reports Microsoft Learn
Related pagesExpense management parameters (Personal expenses paid by) 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 need to follow up on personal charges, such as personal items on a company credit card, that employees marked on their expense reports.
How oftenOn demand, for example before reimbursing or when reconciling card statements.
What the output showsThe personal expenses entered on the selected expense reports, by expense type. Who pays these amounts depends on the Personal expenses paid by parameter; an unexpected amount usually means a line was marked personal by mistake.

Source: Microsoft Learn

Setup steps on this page

Check personal charges on corporate cards

List the personal amounts employees marked on their reports.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Personal expenses report.
  2. In Records to include, filter on the Expense report number of the reports you want to review.
  3. Filter on the Expense type to show only the personal expense type you are interested in.
  4. Run the report and compare the personal amounts with what the employee must repay or what was deducted from the reimbursement.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Expense report numberThe number of the expense report to show.Microsoft Learn
Expense typeThe personal expense type to show on the report.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. Mark one card line on a test report as personal.
  2. Run the report for that expense report number.
  3. Check the personal line and amount are listed.
  4. Check how it is settled against the Personal expenses paid by parameter.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Check personal charges on corporate cardsRun it per expense report or per card statement period, and compare the personal amounts with the card statement.Personal amounts on a corporate card are either paid by the employee or charged back, depending on Personal expenses paid by.Who pays personal amounts on corporate cards?Reading the report as amounts the company owes, when it lists amounts the employee owes or pays themselves.Test: Personal lines are listed

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 laterWho pays the personal part depends on Personal expenses paid by in the parameters: the employee pays the card provider, or the company pays the whole bill and charges the worker's account. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TrvPersonalExpenses 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:TrvPersonalExpenses
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