14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses
Key Takeaways
- The Expense management workspace and mobile application provide automated Optical Character Recognition (OCR) receipt scanning, parsing merchant, date, amount, and category directly into draft expense reports.
- Hotel folio itemization enables splitting a single complex invoice into distinct room charges, occupancy taxes, business meals, and personal non-reimbursable lines.
- Corporate credit card feeds (AMEX, Visa/Mastercard VCF/CDF) import unattached transaction records that reconcile with mobile receipts and employee draft lines.
- Intercompany expense reporting allows an employee in their home legal entity to assign lines to a destination legal entity, automatically generating Due-To / Due-From intercompany ledger vouchers upon posting.
- Posted expense reports debit P&L expense accounts and credit employee vendor accounts in Accounts Payable for automated disbursement via vendor payment proposals, while reconciling travel requisitions and pre-issued cash advances.
14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses
Quick Summary: Managing corporate expenses requires an intuitive employee submission experience, robust multi-level approval workflows, automated corporate credit card reconciliation, and precise intercompany ledger postings. In Microsoft Dynamics 365 Finance, employees capture receipts using mobile OCR technology, itemize complex folio bills across multiple legal entities and financial dimensions, and settle cash advances, while finance teams maintain automated workflow governance and automated AP reimbursement.
1. Expense Report Lifecycle & Mobile Receipt Capture
The expense report lifecycle transitions through draft creation, receipt capture, automated policy validation, workflow approval, ledger posting, and AP payment disbursement.
+---------------------------------------------------------------------------------------------------------+
| Expense Report Processing Lifecycle |
+---------------------------------------------------------------------------------------------------------+
| Stage | User / System Action | Document & Workflow Status |
| :------------------ | :-------------------------------------- | :-------------------------------------- |
| **1. Capture** | Mobile app photograph or web upload; | **Draft** (Unattached Receipts Pool) |
| | OCR extracts merchant, date, and amount.| |
| ------------------- | --------------------------------------- | --------------------------------------- |
| **2. Entry** | Assigns categories, projects, payment | **Draft** |
| | methods, and itemizes complex folios. | |
| ------------------- | --------------------------------------- | --------------------------------------- |
| **3. Submission** | Policy engine validates limits; employee| **Submitted / In Review** |
| | clicks Submit into workflow. | (Locked from editing) |
| ------------------- | --------------------------------------- | --------------------------------------- |
| **4. Approval** | Routed to Line Manager, Project Manager,| **Approved** |
| | or AP Auditor based on rules. | |
| ------------------- | --------------------------------------- | --------------------------------------- |
| **5. Posting** | System posts GL journal voucher; | **Posted / Ready for Payment** |
| | creates open AP employee invoice. | |
| ------------------- | --------------------------------------- | --------------------------------------- |
| **6. Disbursement** | AP payment proposal generates payment | **Closed / Settled** |
| | via EFT direct deposit. | |
+---------------------------------------------------------------------------------------------------------+
Mobile Receipt OCR Scanning
Dynamics 365 Finance integrates with Azure Cognitive Services to provide Optical Character Recognition (OCR) receipt processing:
- An employee captures a receipt image using the Dynamics 365 mobile app or Expense workspace.
- The OCR engine parses the receipt text to automatically extract Merchant Name, Transaction Date, Currency, Total Amount, and predicted Expense Category.
- The captured receipt resides in the employee's Unattached receipts pool.
- When creating an expense report, the employee clicks Add unattached receipts, and the system generates pre-populated draft expense lines linked directly to the receipt image.
2. Itemization & Financial Dimension / Project Splitting
When a single receipt contains multiple expenditure types or applies across multiple organizational cost centers, employees use Itemization and Split functions.
+---------------------------------------------------------------------------------------------------+
| Worked Example: Hotel Folio Itemization ($1,250 Total) |
+---------------------------------------------------------------------------------------------------+
| Sub-Line | Expense Category | Amount | Payment Method | Accounting Treatment |
| :------- | :--------------- | :-------- | :------------- | :------------------------------------- |
| **1** | **Hotel Room** | $900.00 | Company Paid | Debit: Lodging Expense (601200) |
| **2** | **Hotel Tax** | $150.00 | Company Paid | Debit: Sales Tax / VAT Reclaim |
| **3** | **Meals** | $120.00 | Company Paid | Debit: Meals Expense (601100) |
| **4** | **Personal** | $80.00 | Company Paid | Debit: Employee Advance Offset (132000)|
| **Total**| | **$1,250**| | Credit: Credit Card Clearing ($1,250) |
+---------------------------------------------------------------------------------------------------+
Splitting Across Financial Dimensions & Projects
- Dimension Splitting: A single $500 software subscription line can be split by percentage (e.g., 60% Department 100 - Operations, 40% Department 200 - Marketing) or fixed amount.
- Project Allocation: When an expense is incurred for client project work, the employee toggles the line to Project, selecting the Project ID, Activity ID, and Project Category. Posting automatically generates project cost transactions and billable customer invoices in Project Management and Accounting.
3. Corporate Credit Card Import & Automated Reconciliation
Organizations issuing corporate credit cards (e.g., American Express, Visa, Mastercard) automate transaction ingestion via periodic batch jobs (Expense management > Periodic tasks > Credit card import).
+---------------------------------------------------------------------------------------------------------+
| Credit Card Feed Integration Architecture |
+---------------------------------------------------------------------------------------------------------+
| Feed Standard | File Format Specification | Transaction Matching Rules |
| :------------------- | :-------------------------------------- | :------------------------------------- |
| **AMEX GL1025 / 1022**| American Express proprietary flat file | Matches Card Number to Employee Worker |
| | format with rich merchant data. | profile; matches Date & Amount to OCR. |
| -------------------- | --------------------------------------- | -------------------------------------- |
| **Mastercard CDF 3.0**| Common Data Format XML standard for | Imports into Unattached Credit Card |
| | commercial cards. | Transactions repository. |
| -------------------- | --------------------------------------- | -------------------------------------- |
| **Visa VCF 4.0** | Visa Commercial Format transaction feed | Auto-links imported charges to matching|
| | containing enhanced Level 3 data. | draft expense report lines. |
+---------------------------------------------------------------------------------------------------------+
Reconciliation & Dispute Processing
- Imported credit card transactions appear in the employee's Unattached credit card transactions list.
- The system automatically reconciles and merges card transactions with mobile OCR drafts matching on date, currency, and amount.
- If an unrecognized charge appears (e.g., fraudulent charge), the employee or AP specialist marks the transaction as In dispute, which suspends the item from expense reports pending bank investigation.
4. Intercompany Expense Allocations & Accounting
In multinational enterprises, employees frequently incur expenses in their home legal entity on behalf of a different operating subsidiary or project entity.
Intercompany Line Entry Workflow
- An employee employed in USMF (Home Legal Entity) travels to London to support an implementation for GBSI (Destination Legal Entity).
- When entering the expense report in USMF, the employee changes the Legal entity field on the expense line from
USMFtoGBSI. - The line immediately updates its category lookups, project lists, and financial dimension structures to reflect GBSI's chart of accounts and master data.
+---------------------------------------------------------------------------------------------------+
| Intercompany Expense General Ledger Voucher Postings |
+---------------------------------------------------------------------------------------------------+
| Legal Entity | Main Account & Subledger Detail | Debit Amount | Credit Amount |
| :----------- | :------------------------------------------- | :--------------- | :--------------- |
| **GBSI** | `601200 - Travel & Lodging Expense (P&L)` | **$3,000.00** | |
| (Destination)| `211000 - Due to USMF (Intercompany Liab)` | | **$3,000.00** |
| ------------ | -------------------------------------------- | ---------------- | ---------------- |
| **USMF** | `131000 - Due from GBSI (Intercompany Asset)`| **$3,000.00** | |
| (Home / AP) | `210100 - Accounts Payable (Employee Vendor)`| | **$3,000.00** |
+---------------------------------------------------------------------------------------------------+
[!IMPORTANT] The expense P&L is charged to the destination company (GBSI), while the Accounts Payable reimbursement liability is created in the employee's home company (USMF). Intercompany Due-To and Due-From accounts balance the cross-entity transaction automatically based on the General Ledger Intercompany Posting setup.
5. Expense Approval Workflows & AP Posting Integration
Expense reports are routed through configurable approval workflows (Expense management > Setup > Expense management workflows).
+---------------------------------------------------------------------------------------------------------+
| Expense Workflow Approval Architecture |
+---------------------------------------------------------------------------------------------------------+
| Workflow Element | Evaluation Criterion | Typical Routing Destination |
| :------------------- | :-------------------------------------- | :------------------------------------- |
| **Automated Policy** | Evaluates compliance rules; if 0 errors | Auto-approves and bypasses manual |
| **Check** | and amount < $100, passes automatically.| review. |
| -------------------- | --------------------------------------- | -------------------------------------- |
| **Manager Approval** | Managerial hierarchy routing based on | Direct Line Manager (from HR Worker |
| | HR supervisory tree. | reporting relationship). |
| -------------------- | --------------------------------------- | -------------------------------------- |
| **Signing Limits** | Evaluates manager approval limits | Escalates to Director / VP if total |
| | (e.g., Manager: $1,000; VP: $10,000). | exceeds line manager spending limit. |
| -------------------- | --------------------------------------- | -------------------------------------- |
| **Project Approval** | Routes project-related expense lines. | Project Manager assigned to Project ID.|
| -------------------- | --------------------------------------- | -------------------------------------- |
| **AP Audit Review** | Triggers on flagged receipts, policy | Accounts Payable Expense Audit Clerk. |
| | warnings, or random statistical sample. | |
+---------------------------------------------------------------------------------------------------------+
General Ledger & Accounts Payable Posting
Upon final workflow approval:
- The system executes the Post expense report batch process.
- General Ledger vouchers debit departmental expense accounts and credit either the Employee Vendor Account (for out-of-pocket expenses) or the Credit Card Clearing Account (for corporate card expenses).
- In Accounts Payable, an open vendor invoice transaction is created for the employee.
- The AP team executes the standard Vendor payment proposal, disbursing funds directly to the employee's bank account via EFT.
6. Travel Requisitions & Cash Advances
Travel Requisitions (Pre-Trip Authorizations)
- Employees submit a Travel requisition (
Expense management > Travel requisitions) prior to booking travel. - Contains estimated airfare, hotel, and per diem costs.
- When approved, it pre-encumbers or reserves budget funds in Budget Control.
- Approved travel requisitions link directly to final expense reports for automated reconciliation against authorized budgets.
Cash Advances & Reconciliation
When employees require cash prior to travel (e.g., international travel to remote locations):
+---------------------------------------------------------------------------------------------------+
| Cash Advance Lifecycle & Accounting |
+---------------------------------------------------------------------------------------------------+
| Stage / Event | Functional Action & Workflow | Accounting Voucher Entry |
| :------------------- | :------------------------------------- | :------------------------------------- |
| **1. Request** | Employee requests $1,000 cash advance; | None (Pending workflow approval). |
| | routes to manager for sign-off. | |
| -------------------- | -------------------------------------- | -------------------------------------- |
| **2. Disbursement** | AP disburses $1,000 via payment journal| **Dr: Employee Advance (132000) $1,000**|
| | to employee bank account. | **Cr: Operating Cash (110100) $1,000** |
| -------------------- | -------------------------------------- | -------------------------------------- |
| **3. Final Expense** | Employee submits $1,200 out-of-pocket | **Dr: Travel Expense (601100) $1,200** |
| **Reconciliation** | expense report; applies $1,000 advance.| **Cr: Employee Advance (132000) $1,000**|
| | Net AP Reimbursement = **$200.00** | **Cr: Employee AP Vendor (210100) $200**|
+---------------------------------------------------------------------------------------------------+
[!NOTE] If an employee requests a $1,000 advance but only incurs $800 of valid business expenses, the final expense report clears $800 of the advance, leaving a $200 debit balance on the employee's advance account. The remaining $200 is returned via cash receipt journal or deducted from payroll.
A senior consultant employed in legal entity USMF travels to the United Kingdom to deliver billable implementation services for a customer owned by legal entity GBSI. The consultant pays $2,500 out-of-pocket for travel expenses and enters an expense report in USMF, setting the line-level Legal Entity field to GBSI. Which General Ledger voucher entries are created across USMF and GBSI upon posting the expense report?
An employee receives a pre-approved cash advance of $1,500 disbursed via Accounts Payable prior to an international trade mission. Upon returning, the employee submits an out-of-pocket expense report totaling $1,900 for airfare, meals, and lodging, and applies the $1,500 cash advance to the report. When the expense report is approved and posted, what is the net reimbursement amount created in Accounts Payable for payment to the employee?
An enterprise requires that all employee expense reports containing corporate credit card transactions be automatically matched and reconciled with incoming banking transaction feeds. Which standard format feeds does Dynamics 365 Finance support out-of-the-box for periodic credit card imports?