Go-To Reports


General Ledger Projects Procure to Pay Expense Reports Payroll COA/Security

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) 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) 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) 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) Financial Reporting Center -> Use the Magnifying Glass and Search for 072
Review Unit Budget vs. Actual Variance for All Units RU GL 075 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, viz , Camden , New Brunswick , Newark, RBHS, Central  and finally  consolidated for the entire University.

 Includes Budgets , Actuals and associated variances. 

Financial Reporting Center Reports (PDF) Financial Reporting Center -> Use the Magnifying Glass and Search for 075
Review Unit Budget ss. Actual Variance for New Brunswick Units RU GL 076 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) Financial Reporting Center -> Use the Magnifying Glass and Search for 076
Review Unit Budget vs. Actual Variance for Newark Units RU GL 077 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) Financial Reporting Center -> Use the Magnifying Glass and Search for 077
Review Unit Budget vs. Actual Variance for Camden Units RU GL 078 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) Financial Reporting Center -> Use the Magnifying Glass and Search for 078
Review Unit Budget vs. Actual Variance for RBHS Units RU GL 079 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) Financial Reporting Center -> Use the Magnifying Glass and Search for 079
Review Unit Budget vs. Actual Variance for Central Divisions RU GL 080 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) 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 transcations to General Ledger. RU GL 089 Account Analysis Report - Custom Output Layout (DOCX) 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) 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
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 -> RU Saved Queries -> GL and 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) 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 -> RU Saved Queries -> GL and Projects
Review Activity of a Sponsored Project for a PI Awards and Projects Financial Review This query returns basic grants information such as F&A rate, award type, start/end date, along with inception to date Award/Project Financial Summary RU Saved Queries (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries -> Sponsored Projects -> Department Reports
Review Activity of a Sponsored Project Inception to Date RU PJ 071 Sponsored Summary - Budget Cost and Encumbrance Sponsored Projects  Summary Balances by Expenditure Type Category: This report displays Project number, Description, Associated contract number, PI, Project Start Date& End Date, Project Inception to date total budget, Raw cost, Indirect costs,  Actual Balance, Encumberance and Balances with and without encumbrance. BI Reports (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> PGM Reports
Review Activity of a Sponsored Project for an Accounting Period RU PJ 072 Sponsored Period Actual Report   BI Reports (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> PGM Reports
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) 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) 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) 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) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Custom -> Reports -> Global Reports