Financial Reporting Directory (FRD) Dashboard
This page provides a complete listing of all the OBI Finance reports available. They are organized in collapsible sections matching the dashboard pages with report descriptions and links to the Fingate pages with more details and launch buttons. For a searchable directory view, see the Searchable OBI Financial Reporting Directory. A version is also available within OBI itself Financial Reporting Directory within OBI.With all sections expanded, use Ctrl-f and key words to search the directory for specific terms, report names or RM3 report cross-references.
The directory also displays Central Administration Reports which generally require central office financial authority to access. These links point directly to the BI Publisher reports which they describe.
Report | Subprocess | Formerly RM3 |
---|---|---|
Expenditure Balance | Review and compare budget to expenditures and hard commitments | |
Monthly Expenditure Details Statement | Review and compare budget to expenditures and hard commitments (non-customizable) | FIN_EXP_285 |
Expenditure Award to Date and Award Detail | Review summarized budget, expenditures, commitments, prepaid expenses, and remaining balances | |
Expenditure Trend | Review expenditure patterns over time | |
Expenditure Variance | Review and compare expenditures between two sets of period ranges | |
Expenditure Details | Review expenditure details for posted transactions | |
Expenditure Details Download | Review expenditure details for posted transactions in a format suitable for external analysis | |
Sponsor Awards' Actual Expenditures - by MTDC, Exclusions, Indirect Costs | Review expenditures summarized by modified total direct costs, exclusions, and indirect costs | |
iJournals | Review iJournal details | |
Commitment Details | Review hard commitments |
Report | Subprocess | Formerly RM3 |
---|---|---|
Summary | Review summary of Actual Earnings, charges on the organization suspense account (OSA), employees with incomplete labor schedules, and compare schedule against actuals by PTA | |
Salary, Fringe, and Indirect Costs by Employee | Review salary, fringe, and indirect cost expenditures and commitments by employee | |
Actual Pay | Review earnings details | |
Actual Pay Details By Employee | Review labor schedule, earnings details, and paycheck information by employee | |
Prepare Bulk Labor Distribution Adjustment Upload | Review earnings details in a format that aids with doing bulk labor distribution adjustments (LDA) | |
Labor Distribution Adjustments (Real-time) | Review Labor Distribution Adjustment (LDA) details (Non-customizable) | FIN_LABOR_247 |
Labor Schedule | Review Labor Schedule details | |
Labor Schedule Details by Employee | Review Labor Schedule details by employee | |
Labor Schedule Trend | Review labor schedule details including schedule percentage and amount by employee and pay period | |
Scheduled v Actual | Review and compare scheduled earnings with actual earnings | |
Scheduled v Actual Details by Employee | Review and compare scheduled earnings with actual earnings by employee | |
Timecard | Review timecard details | |
Timecard Approvals | Review timecard approvals | |
Leave Summary | Review employee leave balance and leave accrual summary | |
Leave Details | Review employee accrual and leave details |
Report | Subprocess | Formerly RM3 |
---|---|---|
Award at Glance | Review award summary for SU and EN ledgers, merge pool payout, and endowment shares | |
Fund Statement | Review SU and EN ledger summary and transactions details | |
Fiscal to Date Fund Statement (Current and prior year only) | Review summary and GL transaction details for current or prior fiscal year (Non-customizable) | FIN_FUND_153_Fund_Statement |
Fiscal to Date Fund Statement | Review summary and GL transactions details (Non-customizable) | FIN_FUND_153_Fund_Statement |
Award Status Fund Statement | Review account summary report including budgets, receipts, transfers, expenses and commitments (Non-customizable) | FIN_FUND_253_YTD_Award_Status |
Operating Statement and Clinical Trials Statement | Review GA and GL summary and transaction details including break even percent (Non-customizable) | FIN_OP_101_Operating_Detail & FIN_OP_101A_SPO_Clinical_Trials_Statement |
GL Journal Details | Review GL journal details | |
Posted Journals by Object Code (Real-time) | Review journal transactions by PFOO for a GL Period (Non-customizable) | FIN_GL_161_Post_Jrnl_By_Obj_Code & FIN_GL_162_Central_Jrnls_By_Obj |
Transfer Summary Report | Review fund transfer summary | |
Transfer Detail Report | Review fund transfer details | |
Fund Trend | Review SU and EN ledger fund trend summary | |
Comparative Trial Balance by Object Code | Review ending balances as of a GL Period | |
Operating Statement Month by Month | Review summary report by GL Period and Object Code/Expenditure Type (Non-customizable) | FIN_OP_284_Mo_By_Mo _Month-by-Month |
Operating Statement Year by Year | Review summary report by fiscal year and Object Code/Expenditure Type (Non-customizable) | FIN_OP_284_Mo_By_Mo_Year-By-Year |
Fund Variance | Review and compare SU and EN ledger summary between two sets of period ranges | |
Budget Variance | Review receipt, transfer, and expenditure amounts against budget | |
Budget Transactions Details | Review budget activity | |
Endowment and Donor | Review endowment investment activity and donor information | |
Endowment Award Summary and FTD Investment History | Review endowment investment summary and detail breakdown (Non-customizable) | FIN_ENDOW_123_Endow_Display |
Endowment Investment Summary by Pool | Review endowment investment summary by pool type (Non-customizable) | FIN_ENDOW_128_Endow_Investment |
Pledge Report | Review pledge summary information and pledge schedule details | |
Unused and Underwater Endowment Funds Dashboard | Review awards that are unused and/or market value is less than the book value | |
Inactive Awards Report | Review awards with no activity and/or no balance |
Report | Subprocess | Formerly RM3 |
---|---|---|
PTA Inquiry | Review project, task and award setup details | |
Expenditure Type and Object Code Search | Review expenditure type or object code setup information | |
Org Inquiry | Review organization hierarchy information | |
Award Configuration Report (Real-time) | Review award setup details (Non-Customizable) | FIN_REF_216 |
Fund Authorization Report (Real-time) | Review fund authorization report (Non-customizable) | FIN_REF_225 |
Report | Subprocess | |
---|---|---|
Procure to Pay at a Glance | Review summary of procurement transactions that require action including purchase requisitions pending approval, purchase orders (POs) with a balance, AP invoices that are on hold, and AP invoice aging | |
Procure to Pay Inquiry | Review summary or details information for a single purchase requisition, purchase order (PO), AP Invoice, or payment | |
Purchase Requisitions | Review purchase requisition details | |
Purchase Requisition Approval History | Review purchase requisition approver history | |
Purchase Orders | Review purchase order (PO) details | |
Purchase Order Approval History | Review purchase order approver history | |
Purchase Order Trend Analysis | Review summarized purchase order (PO) information including top X purchased orders | |
Purchase Order and Related AP Invoices | Review PO and related AP invoices | |
AP Invoices | Review AP invoice details | |
Supplier | Review supplier and supplier site summary information | |
Payments by Supplier | Review AP invoice payment information | |
Procure to Pay Efficacy Dashboard | Review count of rejected purchase requisitions by task organization or preparer | |
Invalid PTAs | Review purchase requisitions, purchase orders (POs) and AP Invoices with an invalid PTA |
Report | Subprocess | Formerly RM3 |
---|---|---|
Advances | Review advances that have a balance or have been cleared | |
Advances - Aging | Review advances with a balance | |
Advances - Force Clear | Review advances that were force cleared | |
Credit Card Transactions | Review posted and unposted PCard and/or TCard transactions and related credit card information | |
Credit Card Transactions - Aging | Review unposted PCard and/or TCard transactions | |
Expense Requests | Review Expense Requests transactions submitted, rejected, paid or in progress related to business and travel expenses including reimbursements to Stanford affiliates and non-affiliates | |
Expense Requests - Aging | Review non-posted Expense Requests transactions related to business and travel expenses including reimbursements to Stanford affiliates and non-affiliates | |
Petty Cash Replenishment Transactions Detail | Review Petty Cash Transactions | |
SU Credit Card Custodian | Review Credit Card Profile Information (no transactional data) (Non-customizable) | FIN_PCARD_257_Custodians |
Report | Subprocess | |
---|---|---|
ER Rejection Stats | Review count of rejected or returned expense request transactions by task organization, rejection reason, and expense request transaction type. | |
ER Rejection Detail by Employee | Review count of rejected or returned expense request transactions by preparer, approver, and supplier | |
ER Processing Stats | Review expense request transaction count and average time for submission and approval | |
Expense Requests in Range | Review summary of expense request transactions for a specific amount and date range | |
ER Detail by Employee | Review count of submitted transactions, count of rejected or returned transactions, and transaction amount by preparer, approver, and supplier | |
ER Escalation | Review count of escalated expense request transactions |
Report | Subprocess |
---|---|
Credit Card Metrics by Employee | Review count and amount of SU credit card transactions that were force cleared by verifier, custodian, and award manager. |
Advance Metrics by Employee | Review count and amount of advances that were force cleared by supplier, preparer, and award manager |
Force Clear Summary by Task Org | Review count and amount of SU credit card transactions and advances that were force cleared |
Report | Subprocess |
---|---|
PCard Withdrawn Stats | Review count of withdrawn PCard transactions by task organization |
PCard Returned Stats | Review count of returned PCard transactions by task organization |
PCard Withdrawn Stats by Employee | Review count of withdrawn PCard transactions by verifier or verifier's supervisor |
PCard Processing Stats | Review PCard transaction count and average time for approval and verification |
PCard Transactions in Range | Review summary of PCard transactions for a specific amount and date range |
PCard Detail by Employee | Review PCard transaction count by card holder, verifier, and approver |
PCard Detail by Expenditure Type | Review PCard transaction count by expenditure type and merchant MCC description |
Report | Subprocess | |
---|---|---|
Gift Securities Net Investment Income Excise Tax | Review detail of excise tax levied on the capital gains |
Report | Subprocess | Formerly RM3 |
---|---|---|
Burden Reports | ||
PTA Burden Schedule Listing (Real-time) | The Burden Report shows the burden and burden override setup information for all or a selected list of PTA combination that have been baselined. This report shows which awards have ISC flag, ISC alternate PTA, Off Campus flag, task billable and chargeable flag. | FIN_REF_212 |
Burden Schedule Data Extract (Real-time) | The Burden Schedule Data Extract lists all of the fields related to burden schedules. | FIN_REF_220 |
Burden Schedule Attributes (Real-time) | The Burden Schedule Attributes Report shows the setup information for all or a selected list of burden schedules. | FIN_REF_221 |
Burden Structure Data Extract (Real-time) | The Burden Structure Data Extract lists all of the fields related to burden structures. | FIN_REF_222 |
Burden Structure Attributes (Real-time) | The Burden Structure Attributes shows the setup information for all or a selected list of burden structures. | FIN_REF_223 |
OSR Burden Reconciliation Report | Compares the burden applied through Oracle Grants Accounting and Oracle General Ledger via recalculation based on currently assigned burden schedules and identifies variances. | FIN_OSR_240 |
Endowment Reports | ||
Endowment Donor Statement Data Download | Detailed data by donor related to annual changes in the associated funds. | FIN_ENDOW_237A |
Endowment Central Summary | The Endowment Central Summary is a summary report of YTD investments in various endowment pools including the number of shares and book value. | FIN_ENDOW_126 |
Endowment Control Summary | The Endowment Control Summary provides a high level summary of funds in various endowment pools. | FIN_ENDOW_125 |
Endowment Control Data Download | The Endowment Control Data Download provides data in a tabular format about endowment journals related to funds in various endowment pools. | FIN_ENDOW_125a |
Specific Asset Summary Report | The Specific Asset Summary Report displays the beginning and ending specific asset balance for funds invested in the endowment investment pools. | FIN_ENDOW_136 |
Endowment Income Activity by Object Code (Real-time) | Summary of endowment income by award and object code for the fiscal year to date for use in the reconciliation of endowment balance and preparation of year-end financial statement footnotes. | FIN_ENDOW_127 |
Endowment Fund Audit (Real-time) | Exception reporting for active awards participating in the endowment investment pools to identify potential setup problems. | FIN_ENDOW_130 |
Endowment Balance Summary (Real-time) | Summary of book value, market value, and the number of shares for each award separated by investment pools with monthly share price. | FIN_ENDOW_131 |
Endowment Payment History Details | Month-by-month summary of endowment payout by share type for a single fund over a fiscal year. | FIN_ENDOW_138 |
Annual Donor Endowment Financial Report | Printable report for donors containing the share balance and activity for the fiscal year. | FIN_ENDOW_237 |
Journal Reports | ||
Posted Journals by Object Code (Real-time) | A Posted Journals by Object Code report displays the posted journal line detail for a single period and given PFOO. | FIN_GL_162 |
Trial Balance by Object Code | The Trial Balance by Object Code report summarizes PFOO balances for a given PTA range by object code. | FIN_GL_163 |
Project to Date Trial Balance by Object Code (Real-time) | The Project to date Trial Balance by Object Code report summarizes PFOO beginning and ending balances for a given PTA range by object code. | FIN_GL_164 |
Fund Management Reports | ||
Central YTD Non Sponsored Fund Balance | The Central YTD Non Sponsored Fund Balance displays fiscal year-to-date summarized receipts, transfers, expenses, investments, fund and uninvested fund balances by award type and award. | FIN_FUND_159 |
Central Fund Statement Data Download | The Central Fund Statement Data Download provides data in a tabular format about journal transactions related to a specified award. | FIN_FUND_157A |
Central Fund Statement (Real-time) | Detailed transaction level fund statement with month to date and fiscal year to date perspectives. | FIN_FUND_157 |
Sponsored Fund Statement | Non-customizable sponsored fund Statement of project to date activity for all sponsored awards from GA and GL with detail data by object code from SEP-2003. | ORA_366_SPO_Fund_Statement |
Investment Pool FTD Endowment Rate (Real-time) | Non-customizable Fiscal year to date history of Interim and ending share value by investment pool. | FIN_ENDOW_134_Pool_Share_Rates |
Accounts Receivable Reports | ||
Accounts Receivable Aging Report – Miscellaneous AR View (Real-time) | Summary and detail reports on past due accounts receivable. Includes detail on Sponsor, invoice and days past due. Miscellaneous AR perspective. | FIN_OSR_AR_233 |
Accounts Receivable Aging Report – Receivables/Cash Management View (Real-time) | Summary and detail reports on past due accounts receivable. Includes detail on Sponsor, invoice and days past due. RCM perspective. | FIN_OSR_AR_233 |
OSR AR Payment Register (Real-time) | The OSR AR Payment Register displays payment receipt details by batch number for a given range of awards. | FIN_OSR_AR_115 |
OSR AR Receipts Pending (Real-time) | The OSR AR Receipts Pending shows payments that are unapplied, unidentified and/or on-account. | FIN_OSR_AR_117 |
Accounts Receivable History (Real-time) sponsored awards |
Detailed listing of all installments, expenditures, invoices, and payments related to a sponsored award with monthly cumulative funded amount, total expenditures, and remaining fund and receivable balances. | FIN_OSR_AR_235 |
Accounts Receivable History (Real-time) Program Income and Service Centers awards |
Detailed listing of all installments, expenditures, invoices, and payments related to Program Income and Service Centers awards with monthly cumulative total expenditures, and receivable balances. | FIN_OSR_AR_235A |
Unapproved Draft Invoice Details (Real-time) | Detailed listing of all unapproved draft invoices for sponsored awards in Grants Accounting. | FIN_OSR_AR_111 |
Misc AR Billing and Payment History | The Misc AR Billing and Payment History shows all invoices and payments for a single or range of miscellaneous awards. | FIN_ARMSC_234 |
Research Administration Federal Forms Reports | ||
Federal Financial Reporting Form (SF-425) | Non-customizable Federal Financial Reporting form (SF-245). The SF-425 form is a required Office of Management and Budget (OMB) financial reporting form to track the status of financial data tied to a particular Federal grant award. | ORA_368_Federal_Form_425 |