trending_up Reporting

OBI Dashboard: Financial Reporting Directory (FRD)

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 iJournals transaction 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  
Award Attributes Award Attributes including org, name, status, type, purpose, owner, manager, and relevant dates  
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  
Projected Budget Variance  Projected variance between budget and the sum of actuals, expenditure commitments and anticipated remaining endowment payout. Actuals can be pivoted by GL Period and reporting can be by incremental budget amount, i.e. year-to-date budget vs year-to-date actuals.  
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 by Org Review count of withdrawn PCard transactions by task organization
PCard Returned by Org Review count of returned PCard transactions by task organization
PCard Verifier Stats Review count of PCard transactions that were returned to or withdrawn by verifier.
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.  
Trial Balance by Object Code (non-customizable) Non-customizable 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
Last Updated: Feb 28, 2024

Associated Reports

Questions?

arrow_upward
Back to Top