Go-To Reports


Sponsored Projects Non-Sponsored Projects General Ledger Procure to Pay Expense Reports Payroll COA/Security
Non-Sponsored Projects
Task

Recommended Report (click on link)

Report Description Report 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 (PDF) 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 g/l string, Expenditure comments and whom it is created by.

BI Reports (PDF)

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 This report will show you all the details that hit your projects, similar to the Manage Revenue Distributions Oracle application including GL postings.  This report will only show you revenue for your project, not cost RU Saved Queries (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> Projects

General Ledger
Task

Recommended Report (click on link)

Report Description Report Job Aid Navigation Path to 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 (PDF) 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 (PDF)

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 (DOCX) 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 GGP account level by Business Line for a specific period. Includes comparison of Total Business Line Budget vs Actual.

Financial Reporting Center Reports (PDF)

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. The report can be filtered by location.

Financial Reporting Center Reports (PDF)

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 GP level, expenses at P level by natural account and non-operating revenues & expenses at GP level. It also provides budget and encumbrances and variances.

Financial Reporting Center Reports (PDF)

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 for each  of the four campuses (Camden , New Brunswick , Newark, RBHS), Central,  and finally  consolidated for the entire University.

 Includes Budgets , Actuals and associated variances. 

Financial Reporting Center Reports (PDF)

How to Run a Report in FRC (Video)

Financial Reporting Center -> Use the Magnifying Glass and Search for 075
Review Unit Budget ss. 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 the  New Brunswick Campus.


Inlcudes Budgets, Actuals and associated variances.

Financial Reporting Center Reports (PDF)

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  Newark Campus.


Includes Budgets, Actuals and associated variances.

Financial Reporting Center Reports (PDF)

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  Camden Campus.


Inlcudes Budgets, Actuals and associated variances.

Financial Reporting Center Reports (PDF)

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 the RBHS Campus.


Includes Budgets, Actuals and associated variances.

Financial Reporting Center Reports (PDF)

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 (PDF)

How to Run a Report in FRC (Video)

Financial Reporting Center -> Use the Magnifying Glass and Search for 080
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 Sub Ledgers to include project number, task number, contract number, revenue source and PO number  as applicable. Helpful in reconciliation of various Sub Ledger transactions to General Ledger.

RU GL 089 Account Analysis Report - Custom Output Layout (DOCX)

RU GL 089 Training Video

Tools -> Scheduled Processes
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) Report displays purchase order/commitment details based on chart of account string parameters entered.

BI Reports (PDF)

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 (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries -> GL Reconciliation
Procure to Pay
Task

Recommended Report (click on link)

Report Description Report 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 (PDF) 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 (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries - P2P
Expense Reports
Task

Recommended Report (click on link)

Report Description Report Job Aid Navigation Path to Report
Review Employee Expense Reimbursement Summary Information 101 - Expense Reports Summary Summarizes employee expense reimbursement information. RU Saved Queries (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries - P2P
Review Employee Expense Reimbursement Detail Information 102 - Expense Reports Detail Provides detailed information on employee expense reimbursements. RU Saved Queries (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries - P2P
Payroll
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 GL string How to use Discoverer (DOC) Discoverer
Review the GL COA String Charged for a Payroll Event FMS Appointment Level Charging Instructions Displays the GL string charged for a payroll event How to use Discoverer (DOC) Discoverer
Review an Employee's Pay Components FMS Employee Status Report Displays salary information, HR and FTE data by GL string by employee How to use Discoverer (DOC) Discoverer
COA / Security
Task

Recommended Report (click on link)

Report Description Report 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 IT 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 Chart of Accounts Segment Listing Detail listing of the COA by individual components of the COA Structure. Displays the Child to the Great Grandparent level and description of each component.

BI Reports (PDF)

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 Report shows the default project string for each project, old project number ,name, project manager and contract and task  numbers.

BI Reports (PDF)

Scheduling a BI Publisher Report (Video)

Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> PGM Reports
Look up the Appropriate Approver for Expense Reinbursements RU GL 081 Finance Approver Lookup Report Provides listing of all employees with access to post journal entries and relevant details of their   finance approver to include their net ID , employee ID , email address , UDO.  Available search parameters include employee name, finance approver, Unit, Div. 

BI Reports (PDF)

Scheduling a BI Publisher Report (Video)

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