Go-To Reports


Sponsored Projects Non-Sponsored Projects General Ledger Endowments Procure to Pay Expense Reports Payroll-PeopleSoft Payroll-Tableau 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
Reconcile Project Transactions to the General Ledger RU GL 089 Accuont 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 (PDF)

RU GL 089 Training Video

Tools -> Scheduled Processes -> Account Analysis Report

General Ledger
Task

Recommended Report (click on link)

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

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 (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 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
Endowments
Task

Recommended Report (click on link)

Report Description Report Job Aid Navigation Path to Report
View Unused Spending for Endowment Operating Tasks Endowment Spend Allocation Status Report Dashboard This dashboard presents both a detail and summary view to analyze the spend allocation for Endowment Operating Tasks. The column Project Inception to Date Balance With Full Year Spend Allocation is important as it shows at a glance the Potential Unused Spend. This column assumes there are no additional expenses through year-end.  RU Saved Queries (PDF) Tools -> Reports & Analytics -> Shared Folders -> Custom -> RU Saved Queries -> RU Saved Queries - Projects
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-PeopleSoft
Task

Recommended Report (click on link)

Report Description Report Job Aid Navigation Path to Report
FWS (Federal Work Study) employees paid by department Link

This report lists the name 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 that have 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 along with 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 3 tabs to the report:

Funding Dates End in 90 Days

The report lists employees that have a project in their employee charging instructions (ECI) that will expire within 90 days

Emps Expired Funding End Dates

The report lists employees with projects in their employee charging instructions (ECI) that have already expired, therefore the payroll will be charged to their Department Suspense account

ECI Inactive Combination Code (CC) The report lists combination codes that have expired and\or have been made invalid due to Cross Validation Rules (CVRs)
  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 The report provides confirmation of Work Study hours   Main Menu -> Rutgers Reports -> Time and Labor
Time and Labor: Department comp time (compensation) report    The report lists employees by department and shows compensation time balances   Main Menu -> Rutgers Reports -> Time and Labor
Payroll-Tableau
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 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, HR and FTE data by GL string by employee   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
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 COA Listing With Alternate Hierarchies Report 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