Resources: Oracle Financials Report Types and Uses

Reporting against the financial data in the Oracle Financial System is done primarily in the ReportMart3 web portal. Select an activity below to view related reports and descriptions.

Report Types and Uses by Activity
Account Structure: Stanford's Chart of Accounts Payroll Administration
Banking and Commerce Payroll for Employees
Buying and Paying Petty Cash Administration
Capital Equipment and Capital Projects Reimbursement
Financial Authority Supporting Students
Financial Reporting Tools Tax Compliance
Funds Management Travel
Month-End / Year-End Close  

 

back to top

 

Account Structure: Stanford's Chart of Accounts

The following reports are available in ReportMart3 to help staff track the setup status of Projects, Tasks, and Awards.

Related Report Types and Uses for Projects, Tasks, and Awards
Report Title Report Description
FIN_REF_216_Award_Config_Report The Award Configuration Report shows the setup values, funding installments, award budget, and project funding information for a selected list of awards. The budget information is consistent with the data displayed in the Oracle "Award Budgets" form updated during Award entry. All tasks (baselined and not baselined) associated with any project which has been budgeted, will be represented in the report table. One report will print per award.
FIN_REF_217_Award_Listing The Award Listing Report provides a quick listing of Awards for a specific organization, award name, or award creation date range.
FIN_REF_225_Fund_Authorization The Fund Authorization Report provides the award setup information pertinent to gift and endowment funds together with the fund authorization "long" text for the requested Fund/Award number(s).
FIN_REF_227_Project_Task_Listing The Project Task Listing Report provides a quick listing of Projects and associated Tasks for a specific project-owning organization, project name, legacy activity number, project owner name, project number, task-owning organization, or creation date range.
FIN_REF_229_PTA_Listing The PTA Listing Report displays the title, owning organization, principal owner, manager, type, start date, end date, and legacy account for requested Project, Task, and Award combinations.
back to top

Banking and Commerce

The following reports are available in ReportMart3 to help staff manage receipts.

Related Report Types and Uses for Managing Receipts
Report Title Report Description
FIN_FUND_153_Fund_Statement The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. All balances and transfers included in this report are derived from tables within Oracle's General Ledger module. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt.
FIN_REV_283_Mo_By_Mo_Revenue

This report provides a month-by-month summary of actual revenue by Award / Award-Project at the revenue object level.
FIN_OP_101_Operating_Detail_FTD This report can be used for all award types but is set to report by fiscal year. It contains detailed revenues and expenditures (salary and non-salary) transactions for the last month selected in the reporting period, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances.
back to top

Buying and Paying

The following reports are available in ReportMart3 to help staff track purchase requisitions, purchase orders, invoice payments, purchasing card transactions, and other check requests.

Related Report Types and Uses for Requisitions, Purchase Orders, and Invoices
Report Title Report Description
FIN_PO_209_AP_Supplier_Info Provides a listing of all vendors that currently have records in Stanford's Oracle Internet Procurement system. Also includes records for University faculty, staff, and affiliates which are used in the iOU reimbursement system.
FIN_PO_207_AP_Requisition_Detail Run this report to see all the information pertinent to your requisitions, including Purchase Order, Invoice, and Payment information.
FIN_PO_206_AP_Purch_Order_Detail Use this report to find and display information specific to Purchase Orders. This report is searchable by PO Number, Supplier Name, or Buyer Name. Provides detailed information associated with a given Purchase Order, including Receiving, Invoice, and Payment information.
FIN_EXP_148_Purch_Order_Recon This report can be used to aid in the detailed review of Purchase Orders. The report includes information related to the Purchase Order including any PO Change Order Number, Receiving information, Invoice information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling to the purchase order information.
FIN_PO_201_AP_Invoice_Detail Provides detailed information associated with invoices based on the search criteria provided. Includes Supplier, Invoice, and Payment information.
FIN_EXP_138_Invoice_Detail_Recon This report can be used to aid in the detailed review of invoices. It can also be used to provide additional details to facilitate PI Quarterly Certification for Sponsored Projects. The report includes information related to the Invoice including Supplier Information, Invoice Information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling all the way to the Invoice information and image of the actual vendor invoice.
FIN_PO_205_AP_Remittance_Advice Provides complete information about checks generated from the Accounts Payable system. Displays check number, date, and amount, and all invoices and invoice amounts related to that check.
Related Report Types and Uses for Purchasing Cards (PCards)
Report Title Report Description
FIN_PCARD_186_Transaction_Summary Shows total amount of PCard transactions for a given date range. This report was created to validate the amount that is owed to the bank for PCard transactions posted in Oracle regardless of status. The Summary Report lists the total amount for the period as entered in the beginning and end date and a total count of transactions for the same criteria.
FIN_PCARD_187_Transaction_Detail Provides a list of PCard transactions based on entered criteria. Includes the Oracle feed transaction ID number, Merchant Name, Transaction Date, Transaction Total, Business Purpose, Cardholder Name, Verifier Name, Approver Name, Approver Date, Status, Disputed Yes or No, Receipt of File Yes or No, Sales Tax Yes or No, PTAE, Task-Owning Org, Allocation Amount and Allocation Reason.
FIN_PCARD_189_Aging_Report Provides Cardholders, Card Administrators, and PCard Administration a list of PCard transactions that are pending verification and approval (e.g. current, past due 10-30 days, past due 31-60 days and past due 61+ days)
FIN_PCARD_257_Custodians Provides a list of "active" PCards based upon the search criteria entered. Data elements include Card Number (last four digits shown), Cardholder Name, Verifier Name, Verifier Email, Verifier Phone Number, Training Date, Card Approving Manager, Per Transaction Limit amount, Per Period Limit amount, and Default PTAE.
Related Report Types and Uses for Check Requests
Report Title Report Description
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.
back to top

Capital Equipment and Capital Projects

The following reports are available in ReportMart3 to assist with managing capital equipment and capital projects.

Related Report Types and Uses for Capital Equipment
Report Title Report Description
FIN_PMO_196_CEET The Capital Equipment Expenditure Transactions Report shows all expenditures by expenditure type and by transaction detail by Project Task Award in a given month. This report contains Expenditure Types 531% and 550%. This report is searchable by Project, Task and/or Award Number.
FIN_PMO_198_Fabrication_Exp The PMO Fabrication Expenditures Report is a summarized report of expenditures for all Fabrication PTA where through the reporting period. This report is searchable by Project, Task and/or Award Number.
FIN_PMO_199_Non_Capital_Exp The Non Capital Expenditures Report shows all expenditures by expenditure type and by transaction detail by Project Task Award in a given month. This report contains Expenditure Types 55135, 55140, 55145 and 55150. This report is searchable by Project, Task and/or Award Number.
Related Report Types and Uses for Capital Projects
Report Title Report Description
FIN_CAP_107_Prj_to_Date_Mo This report intended for use by those who are managing Capital and Non-Capital Projects. The report displays detailed and summary budget, expenditure, and commitment information for each project, top task, task and award where the project status is not "Closed" in the Oracle system. It combines salary and non-salary information into one report.
FIN_CAP_192_Cap_and_NonCap_Proj This report displays budget, expenditure, and encumbrance information for each project and task.
FIN_CAP_193_Open_Pos_Cap_Acct This report provides a list of capital accounting contracts based on Project Number, Award, and Purchase Order Number. Report will display contract totals, total invoices received, payments to date and remaining contract accounts.
FIN_CAP_195_Proceeds_Used This report shows total award amount, funding and expenditures by project.
back to top

Financial Authority

Anyone with a valid SUnet ID and password can view authority roles for an individual, a department or unit, or an authority privilege using Authority Reports available in Authority Manager. Use the reports to verify that the correct level of authority has been granted to you or your department(s).

For information on how to use Stanford's Authority Manager Web application and the Signature Authority Query tool to view authority assignments, see How To: View Authority Assignments.

back to top

Financial Reporting Tools

Not applicable to this activity. Select one of the other activities to view related Oracle Financials reports available in ReportMart3.

back to top

Funds Management

The following reports are available in ReportMart3 to help manage funds. The reports are organized in the following sections:

Related Report Types and Uses for Fund Restrictions
Report Title Report Description
FIN_REF_216_Award_Config_Report The report shows the setup values, funding installments, award budget, and project funding information. All tasks associated with any project which has been budgeted, will be represented in the report table. Primarily used for sponsored projects.
FIN_REF_225_Fund_Authorization The report provides the award setup information pertinent to gift and endowment funds together with text describing fund usage as detailed by donor / department. Used for non-sponsored projects.

back to Funds Management menu list

back to top
Related Report Types and Uses for Receipts
Report Title Report Description
FIN_FUND_153_Fund_Statement The Fund Statement shows the General Ledger beginning fund balance, transactional activity, ending fund balance and available balance. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt.  Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt whereas "SU" is used for operating funds. Fund Statements group receipts into meaningful categories such as Endowment Payout, Other Additions and EFP Allocations. Authority is required.
FIN_REV_283_Mo_By_Mo_Revenue

This report provides a month-by-month summary of actual revenue by Award / Award-Project at the revenue object level. Authority is required.
FIN_OP_101_Operating_Detail_FTD This report can be used for all award types but reports by fiscal year. It contains detailed revenues and expenditures (salary and non-salary) transactions for the last month selected, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. Authority is required.
FIN_OP_284_Mo_By_Mo This report provides Operating Statement summary information by Award / Award-Project in a monthly or yearly columnar format. This report also provides monthly and yearly asset and liability information not found on other reports. The report is useful in identifying trends. Authority is required.

TIP:  In order to receive 3 years of data on the yearly summary tab (tab 2), enter SEP of the first year in the "Report Period Begin Date" prompt and AUG of the third year in the "Report Period End Date" prompt.

back to Funds Management menu list

back to top
Related Report Types and Uses for Transfers In / Transfers Out / Other Journals
Report Title Report Description
FIN_JNL_252_Core_Journals

The report provides detailed descriptions and other information for Core Oracle journals (which are originated by central office staff). The beginning of the journal name is displayed on the FUND_153 report (and other FUND or GL reports) in the "Journal" column.

TIP:  Use the "Journal Name" prompt ( and eEnter the journal name as displayed, on Fund Reports followed by the % sign, in case the name was truncated to fit on the report. Authority is required.
FIN_JNL_230_Journal_Inquiry This report displays the entries that were made in iJournals. One tab shows a brief display (including business purpose and originator) regardless on whether the entries are from an individual iJournal or a Feeder. This report retrieves the entire journal entry for individual iJournals. However, for Feeder journals, it does not contain journal line transactions due to the volume of data in each feeder journal entry. Summary information for Feeder journals is visible to all users; Salary authority is required for other iJournals.
FIN_LABOR_247_Distrib_ Adj_Detail

The report provides information and explanation about Labor Distribution Adjustments (LDA). The Brief Display tab contains summary information. The Detail Display tab also includes details on each debit and credit entry of the LDA, as well as approval history information. Salary authority is required.

TIP:  To find a specific LDA that appears on an expenditure report, enter "%" followed by the contents of the "Acct Ref" column in the Batch Name prompt.

The new "Labor Distribution Adjustment Batches – All statuses" report is available in on the OBI Payroll and Labor Management Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.

Using this report, you can see both summary and detailed information of each Labor Distribution adjustment that was created. The report includes detail lines with the Project, Task, Award, Expenditure Type, Expenditure Date, Credit, Debit, Assignment Number, and Name for each adjustment line. It also includes Approval History, which shows each Approver chosen for the transaction and their contact information. It is very helpful in reconciling your accounts (PTAs) on payroll distribution after you have processed LDA in clearing the Org Suspense Account balance.

The report page includes an "instructions" tab, the main "LD Adjustments" tab, and a "View comments" tab.
FIN_FUND_153_Fund_Statement The Fund Statement shows the General Ledger beginning fund balance, transactional activity, ending fund balance and available balance. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt whereas "SU" is used for operating funds. Fund Statements group fund transfers into meaningful categories such as Operating Budget Support, Transfers In, Transfers Out and Capital Purchases. Authority is required.
FIN_OP_101_Operating_Detail This report can be used for all award types but reports by fiscal year. It contains detailed revenues, transfers and expenditures (salary and non-salary) transactions for the last month selected, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. Authority is required.

back to Funds Management menu list

back to top
Related Report Types and Uses for Expenditures – Summary
Report Title Report Description
FIN_EXP_275_Award_View
FIN_EXP_276_Project_View
FIN_EXP_277_Task_View
The three "view" reports provide a consistent approach towards viewing report data. Tabs are available to view data at a summary PTA level, and by category or expenditure type. Based on your role or perspective, you can choose to view expenditures by Award, Project, or by Task. Data provided includes Budget, Expenditure, Commitments and variance. All the reports include a data-rich download tab ready for use in excel. Authority is required.
FIN_EXP_278_Executive_Summary The Executive Summary report provides a summary level overview of expenses, budget and commitment to date data for a specific reporting period, by high level Award Type. It is an aggregate report and combines all PTAs in search result into one summarized report, grouped and totaled by high level Award Type and to the Expenditure Category level. It can be used to look across an organization and answer the question "what was spent on...?". Authority is required.
FIN_EXP_280_Month_By_Month_Drill The report provides view and drill-down on monthly expenditure data from an Award, Project or Task focused perspective. Report contains 3 tabs, each with different drill paths (Award, Project or Task). Users may look at summary pages or drill through to Expenditure Type totals. Authority is required.

FIN_EXP_281_PTA_Interactive_Drill

The report provides view and drill-down on expenditure data from a Project, Task or Award focused perspective. Report contains 3 tabs, each with different drill paths (Award, Project or Task). Users may look at summary pages or drill through to Expenditure Type totals. Authority is required.
FIN_OP_284_Mo_By_Mo This report provides Operating Statement summary information by Award / Award-Project in a monthly or yearly columnar format. This report also provides monthly and yearly asset and liability information not found on other reports. The report is useful in identifying trends. Authority is required.

TIP:  In order to receive 3 years of data on the yearly summary tab (tab 2), enter SEP of the first year in the "Report Period Begin Date" prompt and AUG of the third year in the "Report Period End Date" prompt.

back to Funds Management menu list

back to top
Related Report Types and Uses for Expenditures – Detail
Report Title Report Description
FIN_EXP_285_Mo_Detail_Statement The Expenditure Statement provides detailed transactions posted to the PTA for the month requested, as well as actual-to-date balances, expense control (budget) and commitments. It is designed to facilitate the review and reconciliation of each PTA. For a detailed review of the report features, visit the Expenditure Detail Report web page. Authority is required.
FIN_EXP_279_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.
FIN_LABOR_169_Earnings_Dist_Emp
FIN_LABOR_173_Suspense_Account

These reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports.

The Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform.

To explore all support resources on how to access PLM dashboard reports, visit

FIN_LABOR_247_Distrib_ Adj_Detail

This report provides more detail about Labor Distribution transactions (Expenditure Detail Report source code: LDACT or LD_DA).

The "Labor Distribution Adjustment Batches – All statuses" report will be available in OBI Payroll and Labor Management Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.

Using this report, you can see both summary and detailed information of each Labor Distribution adjustment that was created. The report includes detail lines with the Project, Task, Award, Expenditure Type, Expenditure Date, Credit, Debit, Assignment Number, and Name for each adjustment line. It also includes Approval History, which shows each Approver chosen for the transaction and their contact information. It is very helpful in reconciling your accounts (PTAs) on payroll distribution after you have processed LDA in clearing the Org Suspense Account balance.

The report page includes an "instructions" tab, the main "LD Adjustments" tab, and a "View comments" tab.
FIN_EXP_138_Invoice_Detail_Recon
FIN_EXP_148_Purch_Order_Recon
FIN_PO_201_AP_Invoice_Detail
These reports provide more detail about Accounts Payable transactions. (Expenditure Detail Report source code: APINV; Acct Ref: invoice number; Dept Ref: Purchase Order number.)
FIN_IOU_265_Reimbursement_Trans
FIN_IOU_266_Other_Check_Trans
FIN_IOU_267_Other_Check_MP_Trans
FIN_IOU_269_Advance_Transaction
These reports provide more detail about iOU transactions. (Expenditure Detail Report source code: REIMB or OTHCK; Acct Ref: request number.)
FIN_IOU_268_Petty_Cash_Replenish This report provides more detail about Petty Cash transactions. (Expenditure Detail Report source code: PCASH; Acct Ref: request number; Dept Ref: Petty Cash Fund number.)
FIN_PCARD_186_Transaction_Summary
FIN_PCARD_187_Transaction_Detail
These reports provide more detail about Pcard transactions. (Expenditure Detail Report source code: PCARD; Acct Ref: transaction ID; Dept Ref: Cardholder's name.)
FIN_JNL_230_Journal_Inquiry This report provides more detail about iJournals transactions. (Expenditure Detail Report source code: iJRNL or feeder name; Acct Ref: journal number.)

back to Funds Management menu list

back to top
Related Report Types and Uses for Fund Balance
Report Title Report Description
FIN_FUND_153_Fund_Statement The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page.
FIN_Fund_154_YTD_Fund_Balance_Listing The report provides a brief listing (one line per Award) of the beginning balance receipts, transfers, expenses, investments and available balance. It has a rich data download tab. Authority is required.

back to Funds Management menu list

back to top
Related Report Types and Uses for Budgeting
Report Title Report Description
FIN_BGT_165_Current_iBudget_Sum The report displays budget information. Initial 9/1 consolidated Budget data from Hyperion Planning is displayed, along with budget changes or additions entered via the iBudgets application. This report is generally run for non-sponsored and non-capital PTAs. Authority is required.
FIN_BGT_166_iBudget_Download The report displays detailed budget information. Initial 9/1 consolidated Budget data from Hyperion Planning is displayed, along with budget changes or additions entered via the iBudgets application. The report is intended for download to Excel where the data can be further manipulated for budget management and decision making purposes. This report is generally run for non-sponsored and non-capital PTAs. Authority is required.
FIN_BGT_211_PTA_Budget_Report The report lists budget details and budget amounts by each budget period. The report can be used to verify the budgets on sponsored projects only. This report can be used as a detail budget to accompany the Awards Configuration Report. The report will identify budget lines for different GL periods as well as total project-to-date budget lines. Authority is required.

back to Funds Management menu list

Related Report Types and Uses for Endowment
Report Title Report Description

FIN_FUND_153_Fund_Statement

View Sample Report

  • Shows beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user.
  • Endowment Principal Funds displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page.
  • When run for "SU" Set of Books, actual endowment payout posted monthly. Includes footnote showing "Anticipated Remaining Payout," "Anticipated Annual Payout" and "Anticipated Available Balance."

FIN_FUND_154a_YTD_Fund_Balance_Listing_Noting_Anticipated_Endow_Payout

View Sample Report

  • Provides a brief listing (one line per Award) of the beginning balance receipts, transfers, expenses, investments and available balance.
  • Receipts increase as actual endowment payout posts monthly.
  • Data Download tab includes columns for "Anticipated Future Payout" and "Anticipated Available Balance."

Note:  154a is functionally the same as 154, but includes additional columns on the data download tab.

FIN_ENDOW_123_Endow_Display

View Sample Report

  • Reflects an endowment fund's investment holdings including book value, market value and share quantity by pool and share type.
  • Investments broken out by pure and quasi shares.
  • Provides share value

Note:  Reports run for closed periods will reflect Ending Share Value. Reports run for a current, open month will reflect Interim Share Value. See Share Value Calculations.

FIN_ENDOW_128_Endow_Investment

View Sample Report

  • Summary of share book value and market value by fund / pool.
  • Data Download tab provides breakdown of quasi, pure limited and pure unlimited shares, allowing assessment of available Payout Resources for each share type.

Note:  Reports run for closed periods will reflect Ending Share Value. Reports run for a current, open month will reflect Interim Share Value. See Share Value Calculations.

FIN_ENDOW_134_Pool_Share_Rates

  • Displays the selected rate type up through the selected period, by period and by investment pool.
  • The "Matrix" report displays the selected rate type in a crosstab format with the periods represented in columns and the pools represented in rows

back to Funds Management menu list

back to top

Month-End / Year-End Close

The following reports are available in ReportMart3 to help staff manage tasks related to closing the books on a monthly and annual basis. See also Year-End Report Matrix for additional information about each of the reports listed below including purpose, required reporting authority (Salary or Non-Salary View), and frequency of updates.

Related Report Types and Uses for Summary Level Information
Report Title Report Description
FIN_EXP_285_Mo_Detail_Statement The Monthly Expenditure Statement provides detailed transactions posted to the PTA for the month requested, as well as actual-to-date balances, expense control (budget) and commitments. It is designed to facilitate the review and reconciliation of each PTA. For a detailed review of the report features, visit the DoResearch web site.
FIN_OP_101_Operating_Detail_FTD This report can be used for all award types but is set to report by fiscal year. It contains detailed revenue and expenditure (salary and non-salary) transactions for the last month selected in the reporting period as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances.
FIN_OP_284_Mo_By_Mo This report provides monthly and yearly Operating Statement summary information by Award / Award-Project. This report also provides monthly and yearly asset and liability information not found on other reports.
FIN_FUND_253_YTD_Award_Status Provides GL & GA category summary level data in a data download format. Allows Budget Officers to see the current status (FTD actuals, expense control) of Projects and Funds prior to year-end and during year-end close. Provides information that will assist in the ability to fund deficits or reallocate surpluses as needed to close their operating budget awards at year-end.
FIN_FUND_154_YTD_Fund_Bal_List Displays Fund Balance for each Fund / Award. Report provides a summary of beginning balance, receipts, operating budget transfers, other transfers, expenses, net investments and available balance.
FIN_FUND_152_Fund_Mo_By_Mo Provides monthly summarized fund information broken down into the following categories: Beginning fund balance, available balance forward, receipts, transfers, expenses, net investments and available balance.
FIN_FUND_254_Balance_Sheet_List Report identifies the types of assets and liabilities held within an Award.
FIN_EXP_280_Month_By_Month_Drill The Month-By-Month Interactive Drill report provides view and drill-down on monthly expenditure data from an Award, Project or Task focused perspective. Report contains 3 tabs, each with different drill paths. There is no "Data Download" tab included on this report.
FIN_EXP_281_PTA_Interactive_Drill The PTA Interactive Drill report provides view and drill-down on expenditure data from a Project, Task or Award focused perspective. Report contains 3 tabs, each with different drill paths. There is no "Data Download" tab included on this report.
Related Report Types and Uses for Detailed Level Information
Report Title Report Description
FIN_FUND_153_Fund_Statement The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page.
FIN_REF_225_Fund_Authorization Displays Award set-up information.
FIN_EXP_279_Transaction_Detail

The Transaction Detail report provides transaction detail and JCC level salary expenditure information by Project, Task and Award, for a requested period.

Note:  Use this report to identify Organization Suspense Account (OSA) entries for labor. This involves exporting the report to Excel and running an Excel Macro. For instructions, see How To: Clear Organization Suspense Accounts for Labor.

FIN_JNL_230_Journal_Inquiry This report displays the entries that were made in iJournals, including summary information for Feeder Journals.
FIN_LABOR_173_Suspense_Account

This report has been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports.

Using the Payroll and Labor Management (PLM) Dashboard in OBI, you can view the current balance (as of the most recently posted pay period end-date) of your Organization Suspense Account on the "Summary" tab. You can also drill to the transaction detail by clicking on the "Amount" hyperlink. Based on the transaction detail, you can process the Labor Distribution Adjustment to clear the balance accordingly. Also, you are able to find all LDA transactions being posted to your Org Suspense Account, by using the Suspense Clearing Details on the "Scheduled Vs Actual" tab.

back to top

Payroll Administration

PLEASE NOTE:  Robust and dynamic ad hoc analyses for experienced financial analysts, and simple interactive predefined reports for administrative and financial staff, are available using Oracle Business Intelligence (OBI). For more information, visit OBI Financial Reporting.

The following reports are available in ReportMart3 to help staff evaluate labor schedules and payroll distribution.

Related Report Types and Uses for Payroll Administration Using ReportMart3
Report Title Report Description

FIN_LABOR_167_Earnings_Dist_Plan
FIN_LABOR_168_Earn_Dist_Assig_Org
FIN_LABOR_169_Earnings_Dist_Emp
FIN_LABOR_170_Earnings_Dist_PTA
FIN_LABOR_172_Schedules_Planning
FIN_LABOR_173_Susp_Charge_Reason

These reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports.

The Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform.

To explore all support resources on how to access PLM dashboard reports, visit

FIN_LABOR_247_Distrib_ Adj_Detail

The Distribution Adjustment Detail Report provides information and explanation about Labor Distribution Adjustments. This report should be your primary tool in researching Labor Distribution Adjustments (LDA) entries. To find a specific LDA that appears on an expenditure report, enter "%" followed by the contents of the "Acct Ref" column in the Batch Name prompt. The Brief Display tab contains summary information including Batch Name, Originator, Journal Total, Status, Creation Date, and Comments. The Detail Display tab, in addition to the information listed above, also includes details on each debit and credit entry of the Labor Distribution adjustment, as well as approval history information.

The new "Labor Distribution Adjustment Batches – All statuses" report is available in on the OBI Payroll and Labor Management Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.

Using this report, you can see both summary and detailed information of each Labor Distribution adjustment that was created. The report includes detail lines with the Project, Task, Award, Expenditure Type, Expenditure Date, Credit, Debit, Assignment Number, and Name for each adjustment line. It also includes Approval History, which shows each Approver chosen for the transaction and their contact information. It is very helpful in reconciling your accounts (PTAs) on payroll distribution after you have processed LDA in clearing the Org Suspense Account balance.

The report page includes an "instructions" tab, the main "LD Adjustments" tab, and a "View comments" tab.
FIN_EXP_279_Transaction_Detail

The Transaction Detail report provides transaction detail and JCC level salary expenditure information by Project, Task and Award, for a requested period.

Note:  Use this report to identify Organization Suspense Account (OSA) entries for labor. This involves exporting the report to Excel and running an Excel Macro. For instructions, see How To: Clear Organization Suspense Accounts for Labor.

The following report is available in Oracle Financials to help staff plan and monitor the distribution of employees' earnings.

Related Report Types and Uses for Payroll Administration Using Oracle Financials
Report Title Report Description
LBR 671 Payroll Detail and Planning Report

Payroll detail and planning information found in LBR 671 is now available in OBI Payroll and Labor Management dashboard reports.

The Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform.

To explore all support resources on how to access PLM dashboard reports, visit

back to top

Payroll for Employees

Currently there are no Oracle Financials reports available in ReportMart3 to assist with employee payroll activities.

See Quick Steps in Payroll for Employees for information on how to view personal information like current and historic pay statements, direct deposit enrollments, withholding allowances, W-2 Statements, and more.

back to top

Petty Cash Administration

The following reports are available in ReportMart3 to help staff track petty cash replenishments.

Related Report Types and Uses for Petty Cash Administration
Report Title Report Description
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.
back to top

Reimbursement

The following reports are available in ReportMart3 to help staff track business and travel expenses and reimbursements.

Related Report Types and Uses for Reimbursement
Report Title Report Description
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_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.
back to top

Supporting Students

The following reports are available in ReportMart3 to help staff reconcile Graduate Financial Support (GFS) to Expenditure Reports.

Related Report Types and Uses for Reconciling Graduate Financial Support
Report Title Report Description
FIN_EXP_285_Mo_Detail_Statement The Expenditure Detail Reports:

  • Reflect one month's detail transactions & summary "to date" data
  • Include actual expenditures, commitments & expense control
FIN_EXP_149_Qtrly_EXP_Cert The Quarterly Review and Certification Report includes Salary and Non-Salary detail data for multiple months and can be used for both sponsored and non-sponsored PTAs.
FIN_EXP_279_Transaction_Detail The Transaction Detail report provides transaction detail and JCC level salary expenditure information by Project, Task and Award, for a requested period.
FIN_LABOR_170_Earnings_Dist_PTA

These reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports.

The Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform.

To explore all support resources on how to access PLM dashboard reports, visit

FIN_LABOR_247_Distrib_Adj_Detail

The Distribution Adjustment Detail Report provides information and explanation about Labor Distribution Adjustments. This report should be your primary tool in researching Labor Distribution Adjustments (LDA) entries. To find a specific LDA that appears on an expenditure report, enter "%" followed by the contents of the "Acct Ref" column in the Batch Name prompt. The Brief Display tab contains summary information including Batch Name, Originator, Journal Total, Status, Creation Date, and Comments. The Detail Display tab, in addition to the information listed above, also includes details on each debit and credit entry of the Labor Distribution adjustment, as well as approval history information.

The new "Labor Distribution Adjustment Batches – All statuses" report is available in on the OBI Payroll and Labor Management Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.

Using this report, you can see both summary and detailed information of each Labor Distribution adjustment that was created. The report includes detail lines with the Project, Task, Award, Expenditure Type, Expenditure Date, Credit, Debit, Assignment Number, and Name for each adjustment line. It also includes Approval History, which shows each Approver chosen for the transaction and their contact information. It is very helpful in reconciling your accounts (PTAs) on payroll distribution after you have processed LDA in clearing the Org Suspense Account balance.

The report page includes an "instructions" tab, the main "LD Adjustments" tab, and a "View comments" tab.
back to top

Tax Compliance

Currently there are no Oracle Financials reports available in ReportMart3 related to tax compliance activities.

back to top

Travel

The following reports are available in ReportMart3 to help staff track travel related business expenses.

Related Report Types and Uses for Travel
Report Title Report Description

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_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:
  • New – charges not yet validated in iOU
  • Validated –charges validated in iOU, but not yet expensed in an iOU expense report
  • iOU – charges validated and expensed in an incomplete iOU expense report. (The iOU transactions may be in various incomplete statuses (e.g. Saved not submitted)
  • Expensed – validated charges expensed to the appropriate PTAE in a completed iOU expense report
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_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.
back to top