PeopleSoft Expenses Reports: A to Z

This table lists the PeopleSoft Expenses reports, sorted alpha-numerically by report ID. Use this table to find general information about any PeopleSoft Expenses report.

For more information about running these reports, refer to this corresponding topic in the product documentation:

PeopleTools: SQR Language Reference for PeopleSoft

PeopleTools: BI Publisher for PeopleSoft

See PeopleSoft Global Options and Reports: A-Z for additional PeopleSoft Expenses reports.

For samples of these reports, see the Report Samples that are published with this online documentation.

To access each report, select the report from one of these navigation paths:

Travel and Expenses > Manage Accounting > Print Reports.
Travel & Expenses > Travel & Expense Administration Center > Print Reports.
Travel and Expenses > Manage Employee Information.
Set Up Financials/Supply Chain > Product Related > Expenses > Reports.

Report ID and Report Name	Description	Run Control Page
EX_AEMP_XRPT Employee Average Expenses	Lists the average amount spent by an employee over a period of time. Select Direct Report Employees to list the employees that report directly to the user that is signed on.	RUN_EXAVEM_XRPT
EX_BUDG_XRPT Standard Budgets	This run control page provides an option to run two reports: Select Expense Sheet Report to list the amount of expense reports (pending and approved) versus the amount in the standard budget, and the difference between the two amounts. Select Travel Authorization Report to list the amount of travel authorizations (pending and approved) versus the amount in the standard budget, and the difference between the two amounts.	RUN_EXBUDG_XRPT
EX_CCOVRD_RPT Overdue Credit Card Transactions	Lists credit card transactions that have not been added to an expense report within the time allowed by the business unit. Select the Direct Report Employee check box to filter the report by the employees that report to the User ID that is signed into the system when the report is run.	RUN_CCOVRD_RPT
EX_CCRD_XRPT Credit Card versus Other Spending	Lists the usage of corporate credit cards versus other types of spending. Select Direct Report Employees to list the employees that report directly to the user that is signed on.	RUN_EXCCARD_XRPT
EX_ETRD_XRPT Employee Trends	Lists the trend of an employee's expenses over a specified period of time. Select Direct Report Employees to list the employees that report directly to the user that is signed on.	RUN_ETRD_XRPT
EX_EVLT_XRPT Employee Violation Amounts	Lists the employees that have amounts that are in violation. Select Direct Report Employees to list the employees that report directly to the user that is signed on.	RUN_EXEVLT_XRPT
EX_MRCH_XRPT Total Merchant Costs	Lists the dollar amount spent for each merchant, and groups the amount by expense type and currency. This report can be run for preferred merchants or all merchants. It can be run at a high level (location not included), or at a more detailed level, which lists the location of the expense.	RUN_EXMRCH_XRPT
EX_NONRMB_RPT Non-Reimbursable Expenses	Lists transactions that are non-reimbursable. Select the Direct Report Employee check box to filter the report by the employees that report to the User ID that is signed into the system when the report is run.	RUN_NONRMB_RPT
EX_TSPD_XRPT Employee Top Spenders	Lists the amount that an employee has spent over a given period of time. The report is displayed in descending monetary amount (the highest spenders are at the top of the page). Select Direct Report Employees to list the employees that report directly to the user that is signed on.	RUN_EXESPD_XRPT
EXC1500 Business Units	Lists business units.	RUN_EXC1500
EXC2500 Employee Data by Department	Lists employee personal, organizational, and job data by department.	RUN_EXC2500
EXC2501 Employee Data by Business Unit	Lists employee personal, organizational, and job data by business unit.	RUN_EXC2501
EXC2510 Business Purposes	Lists Business Purposes defined in PeopleSoft Expenses.	RUN_EXC2510
EXC2515 Earnings Code	Lists the Earnings Codes defined in PeopleSoft Expenses.	RUN_EXC2515
EXC2521 Expense Type Groups	Lists the Expense Type Groups defined in PeopleSoft Expenses.	RUN_EXC2521
EXC2522 Expense Types	Lists Expense Types defined in PeopleSoft Expenses.	RUN_EXC2522
EXC2523 Expense Billing Code	Lists Expense Billing Codes defined in PeopleSoft Expenses.	RUN_EXC2523
EXC2525 Preferred Merchants	Lists Preferred Merchants defined in PeopleSoft Expenses.	RUN_EXC2525
EXC2529 Authorized Expense Amounts by Location	Lists Expense Location Amounts defined in PeopleSoft Expenses.	RUN_EXC2529
EXC2530 Expense Locations	Lists Expense Locations defined in PeopleSoft Expenses.	RUN_EXC2530
EXC2531 Expense Location Groups	Lists Expense Location Groups defined in PeopleSoft Expenses.	RUN_EXC2531
EXC2540 Reimbursement Actions	Lists Reimbursement Actions defined in PeopleSoft Expenses.	RUN_EXC2540
EXC2550 Corporate Card Information	Lists employee corporate credit card information.	RUN_EXC2550
EXC2551 Credit Card Supplier	Lists Corporate Card Suppliers defined in PeopleSoft Expenses.	RUN_EXC2551
EXC2561 Payment Type	Lists Payment Types defined in PeopleSoft Expenses.	RUN_EXC2561
EXC2570 Auto Mileage Standard Distance Rates	Lists Standard Distance Rates defined in PeopleSoft Expenses.	RUN_EXC2570
EXC2571 Auto Mileage Varied Distance Rates	Lists Varied Distance Rates defined in PeopleSoft Expenses.	RUN_EXC2571
EXC2581 Cash Advance Source	Lists Cash Advance Sources defined in PeopleSoft Expenses.	RUN_EXC2581
EXC2596 Templates	Lists Templates defined in PeopleSoft Expenses.	RUN_EXC2596
EXC2597 Wizard Types	Lists Wizard Types defined in PeopleSoft Expenses.	RUN_EXC2597
EXC3500 General Ledger Balancing	Lists transaction balancing with general ledger entries.	RUN_EXC3500
EXC4500 Expense Report-XMLPub	Prints a standard expense report.	RUN_EXC4500
EXC4600 Expense Transactions by Department-XMLPub	Lists all expense transactions billed to a specific department.	RUN_EXC4600
EXC4601 Expense Transactions by Unit	Lists all expense transactions billed to a specific business unit.	RUN_EXC4601
EXC5600 Cash Advances by Department-XMLPub	Lists all cash advances billed to a specific department.	RUN_EXC5600
EXC5601 Cash Advances by Business Unit	Lists all cash advances billed to a specific business unit.	RUN_EXC5601
EXC5700 Cash Advance Aging by Department-XMLPub	Lists all outstanding cash advances for a department and how long they have been outstanding.	RUN_EXC5700
EXC5701 Cash Advance Aging by Business Unit	Lists all outstanding cash advances for a business unit and how long they have been outstanding.	RUN_EXC5701
EXC7500 Time Report-XMLPub	Lists project hours and project descriptions.	RUN_EXC7500
EXC9000 Supplier Payments	Summarizes all payments by supplier, payment bank account, payment date, and employee ID.	RUN_EXVNDRPMT
TE_ICRFORM Bar Code Receipt Form	Prints a form to attach receipts to if using receipt imaging.	HTML page