BeyondERP.Newsletter
Menu

Setup step on the Posted transactions page · Expense management

Reconcile posted expenses to the ledger

Prove that what Expense management posted equals the ledger.

Business process
Manage time and attendance
Menu item
output:TrvXpenseSettlement
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 report that finds posted expense transactions.
What you do hereUse this report to list posted expense transactions for a date range, filtered by expense report number, personnel number or posted date.
ExampleFor example, at the end of June the accountant runs the report for 1 to 30 June and compares its 18,400.00 USD total with the travel expense accounts in the trial balance.
Posted transactions 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 › Posted transactions
Set up firstApproved expense reports Microsoft Learn
Used next byExpense tax recovery Microsoft Learn
Related pagesAll expense reports Microsoft Learn
In this process Review expense dates moved at posting · List expenses for a VAT claim
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 itAt period end, when you reconcile posted expenses with the ledger or answer questions about what was paid.
How oftenMonthly, at period end, or on demand.
What the output showsPosted expense transactions with the expense report number, posted date and employee name. A total that differs from the ledger usually points to manual journal entries on the expense accounts or a different date range.

Source: Microsoft Learn

Setup steps on this page

Reconcile posted expenses to the ledger

Prove that what Expense management posted equals the ledger.

Steps from Microsoft

  1. Go to Expense management > Inquiries and reports > Posted transactions.
  2. Under Report date, check or change the From date and To date of the posting period.
  3. In Records to include, filter by expense report number, personnel number or Posted date.
  4. Run the report and compare the totals with the expense accounts in the general ledger for the same period.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Expense report numberThe expense report that holds the posted transactions.Microsoft Learn
Posted dateThe date the expense transactions were posted.Microsoft Learn
NameThe employee who submitted the expense transactions.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. Post two test expense reports in one month.
  2. Run the report for that month.
  3. Check both reports are listed with posted date and employee.
  4. Check the total equals the expense postings in the ledger for the month.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Reconcile posted expenses to the ledgerRun it for the closed month and compare totals with the expense accounts; filter by personnel number to answer an employee's question.The report lists posted transactions by report number, employee and posted date, the same dates the vouchers use.How are expense postings reconciled at month end?Comparing it with the transaction dates of expenses instead of the posted dates, so late reports look missing.Test: Posted reports 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 undoneReversible: The report reads data and changes nothing.
If you change it laterOnly posted expense reports appear. A report that is approved but not posted isn't on it until it is posted. Microsoft Learn
Technical architect

6Technical

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

To cite this step: EM-RPT-030, Reconcile posted expenses to the ledger. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/EM-RPT-030