25C ExpenseReportToReimbursement
25C ExpenseReportToReimbursement
Harsh Tulsyan
Principal Product Manager
Oracle Development
Confidential - Oracle Restricted
Rapid Setup
Journal Entry to
Security
Period Close
Reference Data Sets
Tax
Customer Invoice to Customer Invoice to Bank Statement to
Receipt Tax
Receipt Reconciliation
Subledger Accounting
Reports
Approvals Reports Extensibility
Integrations
• Expense Concept
• Additional Features
Confidential - Oracle Restricted
Overview
4
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Process Flow
Cash Advance Approve Advance Audit Advance Process Advance • Employee Invoice
Request (1) Request (2) Request (3) Amount (4) to Payment
5
Confidential - Oracle Restricted
Confidential - Oracle Restricted
6
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Enterprise Structure
InFusion Corporation
Employee
7
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Security Model
Security Reference Manual for Financials
Expense Auditor
User Reviews and audits expense reports on a daily basis to
ensure compliance with the company's reimbursement
policy
Expense Manager
Job Role Duty Role Manages company's expense policies and processes.
Reviews and proposes changes to expense policies
Employee
8
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Manage Users
Business
Unit
Default
Job
Expense
Account
Manager Grade
9
Confidential - Oracle Restricted
Agenda
• Expense Concept
• Additional Features
Confidential - Oracle Restricted
Configurations
Generate Expense
Audit Expense Report
Invoice
• Expense System Options
Enhancements
• In case of refund of the advance amount, it needs to be settled outside the
system (Process to refund the unused amount from the Cash Advance)
• Close Cash Advance
• Record Manual Journal
Dr. Cash A/c
Cr. Cash Advance Clearing A/c
✓ Upload Corporate Travel Policy
✓ Upload Cash Advance Request
11 ✓ Cash Advance Type
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Generate Expense
Audit Expense Report
Invoice
12
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Generate Expense
Audit Expense Report
Invoice
If the expense auditor approves the cash advance request, he specifies a date by
which the cash advance must be applied to the employee's report
13
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Generate Expense
• Schedule the Job “Process Expense Reimbursements and Cash Advances” Audit Expense Report
Invoice
• Payment Request created in the name of the Party (Employee not created as a supplier)
• Process the Payment Request and make payment in order for the advance to be available for
adjustment
Accounting Entry
14
Confidential - Oracle Restricted
Confidential - Oracle Restricted
• Enable specific pay groups for cash advances and expense reports with negative reimbursement
amounts to prevent negative payment requests from getting applied against positive payment
requests and cash advances
• Process cash advances and expense reimbursements separate from refunds collected from
employees
15
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Cash Advance Approve Advance Audit Advance Process Advance
Request Request Request Amount
Generate Expense
Audit Expense Report
Invoice
• Spreadsheet
• Mobile App
• Recurring Expenses
• Digital Assistance
16
Confidential - Oracle Restricted
Confidential - Oracle Restricted
• Setups
✓ Corporate Cards
17
Confidential - Oracle Restricted
Confidential - Oracle Restricted
18
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Payment Employees Pay Corporate Company Pays Corporate Employees Reimburse Company Reimburses
Option Card Issuer Card Issuer Company Employees
Individual • Card business expenses NA NA • Card business expenses
Pay • Card personal expenses • Cash business expenses
Company NA • Card business expenses • Card personal expenses • Cash business expenses
Pay • Card personal expenses
Both Pay • Card personal expenses • Card business expenses NA • Cash business expenses
Predefined Lookup
Corporate Card
Expense Types
Expense Items Display Converted to Expense Converted to Corporate Feed File Transaction
in Expenses Work Area Types Card Expense Types Codes
Formats supported:
21
Confidential - Oracle Restricted
Confidential - Oracle Restricted
✓ All taxes applied on the expense report will be inclusive tax irrespective of the tax definition
✓ Example – Total expense incurred is £2,100 and tax is VAT 5%. In this case, the tax amount will be calculated as £100
( (2,100 × 5) / 105 ) ✓TAX RECOVERABILITY DETERMINATION FOR
EXPENSE PAYMENT REQUESTS (22C)
• Accounting Allocation
✓ The expense distribution accounts can be overwritten by the employee while entering the expenses if access is
provided (Role → Expense Account Allocation Role)
• Project Allocation
✓ Project related expenses pre-requisite
✓ Expenses can be tagged against Projects, if enabled
22
Confidential - Oracle Restricted
Confidential - Oracle Restricted
✓ Applicable for all Expense Categories except Per Diem and Mileage.
23
Confidential - Oracle Restricted
Confidential - Oracle Restricted
• Preferred Locations
(ORA_EXM_MILEAGE_LOCATIO
NS)
• Multiple Stops
✓ Cumulative Mileage
24
Confidential - Oracle Restricted
Confidential - Oracle Restricted
25
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Cash Advance Approve Advance Audit Advance Process Advance
Request Request Request Amount
Generate Expense
Audit Expense Report
Invoice
• Policy Compliance
• Receipt Management
26
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Meals 50
Entitlement
Accommodation 200 Director 140%
Job Level
Breakfast 10 All Other 100%
Deduction Lunch 20 Holiday 110%
Dinner 20
Scenario Accommodation Breakfast Lunch Dinner Amount Director Holiday
Generate Expense
Audit Expense Report
Invoice
29
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Expense
belong to Yes Cost Center
Employee submits
different manager reviews
expense report cost and approve
center
No
Supervisor reviews
and approves
30
Confidential - Oracle Restricted
Confidential - Oracle Restricted
31
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Generate Expense
Audit Expense Report
• Setups Invoice
32
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Expense Type Account Company LOB Account Cost IC Company LOB Cost
Center Center
Accommodation 5210 201 30 5210 400 000 201 30 400
34
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Cash Advance Approve Advance Audit Advance Process Advance
Request Request Request Amount
Generate Expense
Audit Expense Report
Invoice
• Payment Request created in the name of the Party (Employee not created as a supplier)
• Process the Payment Request and make payment in order for the advance to be available for
adjustment
Accounting Entry
35
Confidential - Oracle Restricted
Agenda
• Expense Concept
• Additional Features
Confidential - Oracle Restricted
• Once delegate submits expense report, it will be reviewed and approved by original employees
before usual expense approvals process starts
37
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Employee
Payable Invoice
submits Funds check
generated
expense claim
• Unused funds from spend authorization can be released by closing the spend authorization
38
Confidential - Oracle Restricted
Confidential - Oracle Restricted
• Associate the contingent worker with the supplier in Manage Expense Contingent Worker
• When contingent worker submits the claim, it is approved as per the hierarchy and gets
audited
• The payable invoice is created in the name of the supplier to which the contingent worker was
associated
• Contingent workers cannot raise advance claim, nor any credit card can be associated with
them
39
Confidential - Oracle Restricted
Confidential - Oracle Restricted
40
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Expense Analytics
41
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Expense Dashboard
Expense Dashboard
42
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Create
Navigate to Booked Vs
Trip
GetThere Actual
Import Expense
and make variances are
Itineraries Reports
the highlighted
based on
bookings to Approvers
Itinerary
43
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Submit
Manager Process
Expense Audit
Approval Reimbursements
Report
Create an
Retrieve Create an Invoice Make
XML file
XML file in external system Payment in
with
from by decoding the External
Payment
UCM data in XML file System
information
Co-Existence
Sample XML
files
45
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Best Practice
✓ Topical Essays
46
Confidential - Oracle Restricted
Confidential - Oracle Restricted
Reference Documents
• How To Enable All Flexfields To Be Edited By Employee When Submitting Expense Report
48
Confidential - Oracle Restricted
Thank You