Report Definitions

 

Report Name

Report Description

Parameters

GL 003 Chart of Accounts Segment Listing

Provides excel listing of current chart of account (COA) segments. Includes all Parent and Child relationships as well as descriptions. COA segments can be queried one at a time or for all segments.

 

Unit; Division; Organization; Location;

Fund Type; Business Line; Account; Activity; Intra-Unit; Future

 

GL 005 Transaction Report by Document Number

Displays General Ledger Chart of Accounts document activity based on lookup parameters

 

Batch Number; Accounting Sequence ; Amount Type; Journal Source; Preparer; Approved Period Name; Journal Category

 

GL 010 Encumbrance Summary Report

Displays the count of commitments and total amount based on parameters chosen.

 

Encumbrance Type; Unit; Division; Organization

 

GL 013 Intra Unit & Fund Transactions Control Report 

Displays Intra Unit and Fund Type Transactions.

 

Report By; Journal Source; Journal Category; Journal Batch; Period Name; Accounting Date

 

GL 014 Suspense Transactions Report

Displays Chart Detail information for transactions in suspense by journal category.

 

Journal Category; Journal Source; Accounting Period; Period Start Date; Period End Date

 

GL 021 Management P&L by Business Line

Displays revenues, expenses, transfers and cost pools by Natural Account and Business Line. Includes Budget and Actuals.

 

Accounting Period; Ledger; Unit; Division; Organization; Location; Fund Type ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 022 Management P&L with MTD, YTD & Full Year w/ Location Page Parameter

Displays revenues, expenses, transfer and cost pools by Natural Account in the Monthly, Year to Date and Full Year Formats. Includes Prior Year Actuals, Actuals, Budget, Actuals+Forecast along with $ Variance and % Variance (Note: enter beginning period in Dialog Box "Starting Period" ie JUL-17)

 

Accounting Period; Ledger; Unit; Division; Organization; Location; Fund Type ; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 025 Management P&L by Business Line w/ Unit Page Parameter

Displays revenues, expenses, transfer and cost pools by Natural Account and Major Business Lines (Instruction, Research, Healthcare/Clinical, Public Service and Other) Note: Unit is not included in the parameter as it is part of Page Header. When the report is exported, each unit shows on its own worksheet. Includes Actuals by Major Business Line and Budget in total.

Accounting Period; Ledger;  Division; Organization; Location; Fund Type ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 026 Management P&L with MTD, YTD & Full Year w/ Rev by FT and Exp by BL

 

Displays revenues by Natural Account, expenses, transfer and cost pools by Business Line in the Monthly, Year to Date and Full Year Format. Includes Prior Year Actuals, Actuals, Budget, Actuals+Forecast along with $ Variance and % Variance (Note: enter beginning period in Parameter and Dialog Box "Starting Period" ie JUL-17)

 

Accounting Period; Ledger; Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

 

Report Name

Report Description

Parameters

GL 027 Management P&L with MTD, YTD & Full Year w/ Months & Rev by FT and Exp by BL

Displays revenues by Natural Account, expenses, transfer and cost pools by Business Line in the Monthly (includes individual months), Year to Date and Full Year Format. Includes  Actuals, Budget, Actuals+Forecast along with $ Variance and % Variance (Note: enter beginning period in Parameter and Dialog Box "Starting Period" ie JUL-17)

 

Accounting Period; Ledger; Unit; Division; Organization; Location; Fund Type ; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 028 Management P&L with Variance by Fund Type

 

Displays revenues, expenses transfers and cost pools by Natural Account and Fund Types. Fund Types include Unrestricted Internally Designated and Other Unrestricted Operating, Restricted Contributions and Grants, Endowments and All Other Fund Types.

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 029 Management P&L with Variance by Fund Type and Exp by BL

 

Displays revenues by Natural account and expenses by Business Line by Unrestricted, Restricted, and Other Fund Types. Includes Budget, Actual and $ Variances.

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 030 RBHS P&L by Business Line w/ Unit Page Parameter

 

RBHS Units - revenues, expenses, transfers and cost pools by Natural Account Grand Parents. RBHS units included in Page Header. When exported to excel each unit shows on worksheet.

 

Accounting Period; Ledger; Unit; Division; Organization; Location; Fund Type ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 031 Management P&L with MTD, YTD & Full Year w/ Unit Page Parameter

 

Displays revenues and expenses, transfers and cost pools  by Natural Account in a Monthly, Year to Date and Full Fiscal Year format. Includes Prior year actuals, Budget and Actuals along with $ Variance and % Variance. The Full Year format adds forecasts to the actuals.

 

Accounting Period; Ledger;  Division; Organization; Location; Fund Type ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 032 Management P&L with Encumbrances

 

Displays revenues and expenses, transfer and cost pools by natural account in a Year to Date and Full Year Format. Includes Budget, Actuals, Encumbrances and Funds Available.

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount, Amount Type; Currency; Currency Type

 

GL 033 Asset/Liability Account Balance Report

 

Displays assets and liabilities by Natural Account by Current Period, Prior Year Period and Prior FY (Jun-Adj-xx).

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

 

Report Name

Report Description

Parameters

GL 034 Budget Detail Report by FT within BL

 

Displays Budget Data by Business Line and Fund Type. Includes Transfers and Operating Expenses.

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 035 Trial Balance Report

 

Displays Assets, Liabilities, Revenues, Expenses and Net Position by Natural Account. Includes Beginning Balance, Total Debits, Total Credits and Ending Balance. Includes Page Header for Unit.

 

Accounting Period; Ledger; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 036 Multi-Year Expense Trend Report

 

Expenses by Natural Account - Year to Date by Period based on From and To Periods entered.

Accounting Period from and to; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 037 Management P&L by Unit

 

Displays revenues, expenses, transfers and cost pools by Natural Account and Grand Parent Unit (Camden, New Brunswick, Newark, RBHS and Central).

 

Accounting Period; Ledger; Division; Organization; Location; Fund Type; Business Line ;Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 038 Balance Sheet by Fund Type

 

Displays Balance Sheet including Assets, Liabilities, and Net Position by Fund Types.

 

Accounting Period; Ledger; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 040 Management P&L for Variance Reporting

 

Displays revenues, expenses, transfers and cost pools by Natural Account in the following Grandparent categories: Educational and General, Grants and Contracts, Healthcare & Professional Services and Auxiliary.

 

Accounting Period from and to; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 043 Year-End Redistribution Report

 

Displays Retained Earnings Combinations by General Ledger Chart String.

 

Period Name: GL Batch Name

 

GL 044 Management P&L with MTD, YTD & Full Year w/ Months & Exp by Personnel/Non-Personnel

 

Displays revenues by Natural Account in the following categories: Educational and General, Grant and Contract Revenues, Healthcare and Professional Services, Auxiliary Revenues and Non-Operating, Expenses by Natural Account (Personnel and Non-Personnel) and Transfers by natural account (Transfers and Cost Pools).

 

Accounting Period from and to; Ledger; Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

 

 

Report Name

Report Description

Parameters

GL 045 Management P&L with MTD, YTD & Full Year w/ Rev by FT and Exp by BL

 

Displays revenues by Fund Type and Expenses by Business Line. Includes Prior Year Actuals, Budget, Actual with $ Variance to Budget and % Variance to Budget in a Monthly and Year To Date Format.

 

Accounting Period ; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

 

 

 

GL 053 Cost Pool Allocation Transfers by Location

 

Displays cost pool allocations or charges and cost pool transfers or offsets by Location (University Wide, New Brunswick, NonHealthSciences Campus, Newark University Ave Campus, Camden Regional Campus, and RBHS Campus). Includes Budget and Actuals.

 

Accounting Period ; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 059 UDO Balance - Budget-Actual-Committed-Forecast

 

Displays expenses and revenues by child Natural Account. Includes Budget, Actual, Committed, "Planned Financial Activities" and Available Balance.

 

Accounting Period ; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 060 Salary & Fringe Benefits Expense Report by Fund Type

 

Displays salary and wages, fringe benefits and FTE's by Natural Account and Fund Type (Unrestricted, Restricted, Agency and Net Investments in Capital Assets). Includes Prior Year Actuals, Actuals, Budget and $ Variance.

 

Accounting Period ; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 061 Salary & Fringe Benefits Expense Report by Business Line

 

Displays salary and wages, fringe benefits and FTE's by Natural Account and Business Line-Major Missions. (Instruction, Research, Healthcare and Clinical, Public Service and Other). Includes Prior Year Actuals, Actuals, Budget and $ Variance.

 

Accounting Period; Ledger;  Unit; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type

 

GL 066 Balance Sheet by Unit

 

Displays assets, liabilities and net position by Unit (Camden, New Brunswick, Newark, Rutgers Biomedical and Health Sciences-RBHS and Central).

 

Accounting Period ; Ledger; Division; Organization; Location; Fund Type; Business Line; Activity; IntraUnit; Future; Balance Amount; Amount Type; Currency; Currency Type