Reports
Expense Requests and Stanford Credit Card Activity Reporting
Effective February 9, 2015, Expense Requests system transaction detail reporting can be performed using the Oracle Business Intelligence (OBI) Expense Requests and SU Credit Card Activity dashboard. Use the dashboard to report on Expense Requests system transaction details (e.g., expense reports / reimbursements, Stanford Travel Card transactions, advances, non-PO payments, and petty cash replenishments), historical iOU transactions, and Stanford Purchasing Card transactions recorded in the PCard module of Oracle Financials.
See OBI Financial Reporting for information about getting access, available training, report overviews and other resources.
ReportMart3 Reports
The following reports are available in ReportMart3 (RM3) to help staff track business and travel expenses and reimbursements.
*Note – The RM3 reports marked below will be replaced by OBI Expense Requests and SU Credit Card Activity dashboard reports February 9, 2015. After February 9, 2015, RM3 iOU reports will only include historical iOU transactions. Expense Requests system transaction details will not be included in RM3 iOU reports. RM3 iOU reports will be retired at a future date to be announced.
| Report Title | Report Description |
|---|---|
| FIN_PO_201_AP_Invoice_Detail | Provides detailed information associated with all types of payments processed by Accounts Payable, including supplier invoice and expense report / reimbursement payments created in Expense Reports and historic iOU. |
| FIN_EXP_279a_Transaction_Detail | The report provides transaction detail expenditure information by PTA. It does not present budget or commitment data. It can be used to query activity in an account (PTA), expenditure type or by many other search criteria for expenditure analysis. This report contains detailed JCC level information on salary expenditure line items that is not contained in any other expenditure report and has a rich data download tab. Authority is required. Note – This report contains historical iOU and Expense Requests system transaction details. |
| *FIN_CREDIT_257_Custodian_Report | The Credit Card Custodian Report provides a list of active Stanford Travel Cardholders (University-paid JPMorgan MasterCards) as well as purchasing (PCard) cardholders. |
| *FIN_IOU_265_Reimbursement_Trans | The Reimbursement Transaction report provides a summary and detailed view of reimbursement transactions created in iOU. The report includes iOU transaction number, date, and category; originator, payee, business purpose, total amount, and transaction status. A data download tab is also available. Salary or non-salary authority is required. |
| *FIN_IOU_266_Other_Check_Trans | The Other Check Transaction report provides a summary and detailed view of iOU Other Check transactions. The report includes iOU transaction numbers, date and category; originator, payee, business purpose, amount, and transaction status. A data download tab is also available. Salary or non-salary authority is required. |
| *FIN_IOU_267_Other_Check_MP_Trans | The Other Check MP Transaction report provides a list of iOU transactions created with multiple payees. |
| *FIN_IOU_268_Petty_Cash_Replenish | The Petty Cash Replenishment report provides a summary and detailed view of petty cash replenishment checks created in iOU. The report includes iOU transaction number and date; Petty Cash fund number, custodian name, department, replenishment total, and transaction status. A data download tab is also available. Salary or non-salary authority is required. |
| *FIN_IOU_269_Advance_Transaction | The Advance Transaction report provides a summary and detailed view of advance transactions created in iOU. The report includes iOU transaction number and date; expected clearing date, transaction category, originator, payee, SU clearing contact, business purpose, amount, and transaction status. A data download tab is also available. Salary or non-salary authority is required. |
| *FIN_TCARD_301_Transaction_Report | The TCard Transaction Detail report lists Travel Card charges based on user-defined search criteria, and is used to identify transaction status, aging transactions, and in reconciling TCard charges on Fund Statements. TCard transaction statuses include:
|
