Rutgers logo
University Finance and Administration
  • Home
  • Resource Library

Reports

Go To Reports

View training and job aids for how to complete Go To Reports.

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Review Summary of a Sponsored Project Inception to Date

    Sponsored Summary - Budget Cost and Encumbrance

    Displays the project number, description, associated contract number, principal investigator (PI), project start date and end date, total budget (from project inception to date), raw cost, indirect costs, actual balance, encumbrance, and balances with and without encumbrance.

    RU Saved Queries

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Review Summary and Detail of Sponsored Projects

    NEWSponsored Projects - Summary and Detail (of expenses and PO encumbrances)

    Provides a summary of Sponsored Projects’ budget, cost, and encumbrance by expenditure type. Displays further details on expenses and encumbrances, minimizing or eliminating the need to go to manage project cost and manage commitment cost to review details and download them for analysis. 

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Review and Reconcile Project Cost Transactions to the General Ledger

    RU PJ 073 Project Costs Detail Report

    Shows project costs by period. Includes general ledger string, expenditure comments, and creator.

    BI Reports

    Scheduling a BI Publisher Report (Video)

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Review Activity of a Project - Summary and Detail

    505 - Project Cost, Revenue, Budget, Commitments

    Provides a top-down approach from a summary projects consolidated view to detailed costs, revenues, budget and commitments

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Look up Projects Chart of Account Values RU PJ 013B COA Segment Listing for Sponsored Projects Report Shows the default project string for each project, old project number, name, project manager, contract, and task numbers.

    BI Reports

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Review Awards Pending Termination

    RU PJ 002 Sponsored Program Award Termination Report

    Shows awards expiring within 90-180 days, expired awards, and awards pending close. 

    BI Reports

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Reconcile Project Transactions to the General Ledger

    RU GL 089 Account Analysis Report (see Navigation Path)

    Displays general ledger chart of accounts transaction activity. The report has expanded values from the subledgers to include project number, task number, contract number, revenue source, and PO number, as applicable. Helpful in reconciliation of various subledger transactions to the general ledger.

    RU GL 089 Account Analysis Report - Custom Output Layout 

    RU GL 089 Training Video

    Tools > Scheduled Processes > Account Analysis Report

    Review Awards in Deficit and Pending Execution

    Award Deficit Report Dashboard

    Shows awards in deficit and all projects within those awards, listing award number, award organization, project number, PI, budget, project status, cost, and variance.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Sponsored Projects - Summary and Detail

    Sponsored Projects – Summary and Detail (of expenses and PO encumbrances)

    Shows project and award information, summary by expenditure type, and project details across multiple views.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Review Activity of a Project - Summary and Detail

    505 - Project Cost, Revenue, Budget, Commitments

    Provides a top-down approach from a summary projects consolidated view to detailed costs, revenues, budget and commitments

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Review and Reconcile Project Cost Transactions to the General Ledger

    RU PJ 073 Project Costs Detail Report

    Shows project costs by period. Includes general ledger string, expenditure comments, and creator.

    BI Reports

    Scheduling a BI Publisher Report (Video)

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Look up Projects Chart of Account Values RU PJ 013 COA Segment Listing for Projects Report Shows the default project string for each project, old project number, name, project manager, contract, and task numbers.

    BI Reports

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Review and Reconcile Project Revenue Transactions to the General Ledger

    Project Revenue with Accounting Details

    Shows all project-related details including general ledger postings, similar to the Manage Revenue Distributions Oracle application. Only displays project revenue, not cost.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > Projects

    Reconcile Project Transactions to the General Ledger

    RU GL 089 Account Analysis Report (see Navigation Path)

    Displays general ledger chart of accounts transaction activity. The report has expanded values from the subledgers to include project number, task number, contract number, revenue source, and purchase order (PO) number, as applicable. Helpful in reconciliation of various subledger transactions to the general ledger.

    RU GL 089 Account Analysis Report - Custom Output Layout

    RU GL 089 Training Video

    Tools > Scheduled Processes > Account Analysis Report

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Review GL Transactional Data

     NEWRU GL 145 GL and Sub-ledger Transaction Report

    This report is similar to the Account Analysis and RU GL 089 reports in the details it provides, with additional sub-ledger data for all transactions.

    RU GL 145 Job Aid

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > ATC Reports

    Review GL Transactional Data

    RU GL 089 Account Analysis Report (see Navigation Path)

    Displays general ledger chart of accounts transaction activity. The report has expanded values from the subledgers to include project number, task number, contract number, revenue source, and PO number, as applicable. Helpful in reconciliation of various subledger transactions to the general ledger.

    RU GL 089 Account Analysis Report - Custom Output Layout

    RU GL 089 Training Video

    Tools > Scheduled Processes > Account Analysis Report

    Search and Obtain Information about a Journal

    Manage Journals (see Navigation Path)

    Provides capability to search for journals.

    How to Search for Journal Entries

    General Accounting > Journals > Manage Journals

    Review GL Balances (all Accounts)

    RU GL 088 Trial Balance with Account Number

    Displays all accounts. Includes beginning balance, total debits, total credits, and ending balance.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 088

    Review Detail GL Balances (Selected Chart Values)

    Inquire on Detail Balances (see Navigation Path)

    Displays all chart segments with the ability to add filtered values and see periodic or year-to-date activity.

    Inquire on Detail Balances 

    General Accounting-> Period Close > Inquire and Analyze Detail Balances

    Review YTD GL Revenues and Expenses

    RU GL 021 Management P&L by Business Line

    Summary P&L report at the great grandparent (GGP) account level by Business Line for a specific period. Includes comparison of total Business Line budget vs. actual.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 021

    Review PTD/YTD/Full Year GL Revenues and Expenses

    RU GL 022 Management P&L with MTD YTD & Full Year with Location Page Parameter

    Summary P&L report at the GGP account level comparing budget to actual on-the-month to date, year-to-date, and full-year periods. Can be filtered by location.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 022

    Review Calculated Ending Net Position Balance

    RU GL 072 GL Transaction Summary

    Report provides opening fund balance, revenues at grandparent (GPlevel, expenses at parent (P) level by natural account and non-operating revenues, and expenses at GP level. Also provides budget, encumbrances, and variances.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 072

    Review Unit Budget vs. Actual Variance for All Units

    RU GL 075B Summary P&L by Unit - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account by campus Central, and the entire university. Includes budgets, actuals, and associated variances. 

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 075

    Review Unit Budget vs. Actual Variance for New Brunswick Units

    RU GL 076B P&L New Brunswick - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account for Rutgers UniversityNew Brunswick. Includes budgets, actuals, and associated variances.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 076

    Review Unit Budget vs. Actual Variance for Newark Units

    RU GL 077B P&L Newark - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account for the Rutgers UniversityNewark. Includes budgets, actuals, and associated variances.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 077

    Review Unit Budget vs. Actual Variance for Camden Units

    RU GL 078B P&L Camden - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account for the Rutgers UniversityCamden. Includes budgets, actuals, and associated variances.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 078

    Review Unit Budget vs. Actual Variance for RBHS Units

    RU GL 079B P&L RBHS - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account for Rutgers Biomedical and Health Sciences (RBHS). Includes budgets, actuals, and associated variances.

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 079

    Review Unit Budget vs. Actual Variance for Central Divisions

    RU GL 080B P&L Central Divisions - Variance

    Displays a summary of revenues, expenses, transfers, and cost pools by Natural Account for the central area. Includes budgets, actuals, and associated variances.


     

    Financial Reporting Center Reports 

    How to Run a Report in FRC Video

    Financial Reporting Center > Use the Magnifying Glass and Search for 080

    Review GL Encumbrance Balances

    407 - Open and Closed Commitment Report

    Displays supplier, concatenated segments, purchase order number, invoiced amount, status and balances.

     

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - P2P

    Review GL Encumbrance Detail

    RU GL 074 Encumbrance Detail (in development)

    Displays purchase order/commitment details based on chart of account string parameters entered.

    BI Reports 

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > ATC Reports

    Find GL String Postings Outliers

    GL Reconciliation Queries

    Trial balance and journal detail.

    RU Saved Queries

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries > GL Reconciliation

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    View Unused Spending for Endowment Operating Tasks

    Endowment Spend Allocation Status Report Dashboard

    Presents a detail and summary view to analyze spend allocation for endowment operating tasks. The column "Project Inception to Date Balance with Full-Year Spend Allocation" shows the potential unused spend at a glance. This column assumes that there are no additional expenses through year-end. 

    RU Saved Queries

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - Projects

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Review Vendor Invoice Information

    401 - AP Invoice Register

    An invoice register that provides detailed invoice information based on a variety of parameters.

    RU Saved Queries

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - P2P

    Review Vendor Payment Information

    402 - AP Payment Register

    A payment register that provides detailed payment information based on a variety of parameters.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - P2P

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Review Employee Expense Reimbursement Summary Information

    101 - Expense Reports Summary

    Summarizes employee expense reimbursement information.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - P2P

    Review Employee Expense Reimbursement Detail Information

    Updated102 - Expense Reports Detail

    Provides detailed information on employee expense reimbursements. Allows users to drill into expense items.

    RU Saved Queries 

    Tools > Reports & Analytics > Shared Folders > Custom > RU Saved Queries > RU Saved Queries - P2P

  • Task

    Report

    Description

    Job Aid

    Navigation Path to Report

    Look up User's or Department's Oracle Access

    RU SEC 002 Security Access Lookup Report

    Provides detail listing of OIT security permissions by employee, NetID, and job role.

    BI Reports (PDF)

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > Global Reports

    Look up GL Chart of Account Values

    RU GL 003 COA Listing With Alternate Hierarchies Report

    Detailed listing of the Chart of Accounts (CoA) by individual components of the CoA structure. Displays the child to the great grandparent level with a description of each component.

    BI Reports

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > Global Reports

    Look up Projects Chart of Account Values

    RU PJ 013 COA Segment Listing for Projects Report

    Shows the default project string for each project, old project number, name, project manager, and contract and task numbers.

    BI Reports

    Scheduling a BI Publisher Report Video

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > PGM Reports

    Look up the Appropriate Approver for Expense Reimbursements

    RU GL 081 Finance Approver Lookup Report

    Lists all employees with access to post journal entries and relevant details of their finance approver (NetID, employee ID, email address, and unit-division-organization [U-D-O]). Available search parameters include employee name, finance approver, unit, and division. 

    BI Reports

    Scheduling a BI Publisher Report

    Tools > Reports & Analytics > Shared Folders > Custom > RU Custom > Reports > Global Reports

     

  • Task 

    Recommended Report (click on link) 

    Report Description 

    Navigation Path to Report 

    FWS (Federal Work Study) employees paid by department 

    Link 

    Lists the names of students on FWS and the actual employee earnings by pay period end date. 

    Main Menu > Rutgers Reports  

    Appointments ending report 

    Link 

    Run by department, the report lists employees with an expected job end date. 

    Main Menu > Rutgers Reports 

    Roster of employees paid 

    Link 

    Run by department and pay end date, the report lists all employees paid on that date and their job title, job code, and gross pay. 

    Main Menu > Rutgers Reports 

    Active payroll employees 

    Link 

    Run by department, the report lists all active employees with job code, job title, hire date, compensation rate, last check date, and supervisor name. 

    Main Menu > Rutgers Reports 

    Commitment Accounting: Action required – Empl Chrg Inst 

    Employee Charging Instructions (ECI) 

    Link 

    Run by fiscal year. There are three tabs to the report: 

    Funding Dates End in 90 Days 

    Lists employees with a project in their employee charging instructions that will expire within 90 days. 

    Emps Expired Funding End Dates 

    Lists employees with projects in their employee charging instructions that have already expired. The payroll will be charged to their Department Suspense account. 

    ECI Inactive Combination Code  

    Lists combination codes that have expired and/or been made invalid due to cross validation rules. 

    Main Menu > Rutgers Reports > Commitment Accounting 

    Commitment Accounting: Payroll distributions by department 

    Link 

    Run by department and pay end date, the report lists all employees paid on a pay period end date and where the employees’ pay was charged. 

    Main Menu > Rutgers Reports > Commitment Accounting 

    Time and Labor: Rutgers time certification 

    Link 

    Provides confirmation of work study hours. 

    Main Menu > Rutgers Reports > Time and Labor 

    Time and Labor: Department comp time (compensation) report  

      

    Lists employees by department and shows compensation time balances. 

    Main Menu > Rutgers Reports > Time and Labor 

  • Task 

    Recommended Report (click on link) 

    Report Description 

    Report Job Aid 

    Navigation Path to Report 

    Review Employee Detail Posted to the General Ledger 

    FMS Payroll Distribution Report (PD) - Financial Management 

    Displays payroll information for a position that is charged to a General Ledger (GL) string. 

    Payroll Distribution (PDF) 

    Tableau > Finance > MR > Payroll 

    Review the GL COA String Charged for a Payroll Event 

    FMS Appointment Level Charging Instructions 

    Displays the GL string charged for a payroll event. 

      

    Tableau > Finance > MR > Payroll 

    Review an Employee's Pay Components 

    FMS Employee Status Report 

    Displays salary information, Human Resources, and FTE data by employee GL string. 

      

    Tableau > Finance > MR > Payroll 

    Review Department Default Employee Charging Instruction 

    FMS Department Default ECI 

    Displays default GL string, project, and task numbers of the employee charging instruction for department(s). 

      

    Tableau > Finance > MR > Payroll