NUPlans Contributor Fund Views

Contents

Upon completion of this guide, you should be able to:

·        Describe the purpose and functionality of the Fund views.

·        Define the columns and rows of the Fund views.

·        Define the four additional columns on the Endowments view.

·        Find linked-in data on the Fund views and drill to detail.

·        Describe budgeting with automatic balancing and find examples in the Fund and Carry Forward views.

·        Describe budgeting without automatic balancing and find sources of spending authority in NUPlans.

Who has access?

The NUPlans Fund Input views are available to budget group members with the access below.

General - Access to budget input for fund tabs, carry forward tab, and the ability to add chart strings and/or change chart string status

Planner - Access to budget input for fund tabs and the carry forward tab

Prep File - Includes all other roles except Salary – Confidential; intended for users who have responsibility for submitting the budget for their entire prep file area

FYXX Original Bud

Expanded

Import/Display

The current year budget data are imported from NUFinancials and displayed to provide context for next year’s budget decisions.

FYXX Recurr Adj

Expanded

Import/Display

The amount of any recurring adjustment made in the current year.

FYXX N/R Adj

Expanded

Import/Display

The amount of any non-recurring adjustment made in the current year.

FYXX Bud

Import/Display

The current year budget, including recurring adjustments. Click the handle (+/-) to expand or collapse the column.

FYXX Beg CFWD

Import/Display

The Carry Forward amount associated with the chart string at the beginning of the current year is displayed at the intersection of this column and account 79999.

FYXX Act FYXX Act

Import/Display

Two years of historical actuals data are imported from NUFinancials and displayed to provide historical context and to help budgeters identify trends.

FYXX YTD Act

Expanded

Import/Display

Actual revenue and expenses representing transactions that have taken place in the current year-to-date.

FYXX YTD

Encumbrances

Expanded

Import/Display

Pending expenses representing encumbrances that have taken place in the current year-to-date.

myHR FYXX Enc

Expanded

Import/Display

Pending payroll expenses representing encumbrances in the current year-to-date, which is relevant only for compensation chart strings. A drill to employee detail is available.

myHR FYXX Act

Expanded

Import/Display

Actual payroll expenses in the current year-to-date, which is relevant only for compensation chart strings. A drill to employee detail is available.

FYXX YTD Obligations

Import/Display

The sum of actuals and encumbrances from NUFinancials (FYXX YTD Act + FYXX YTD Encumbrances). Click the handle (+/-) to expand or collapse the column.

FYXX Forecast

Import/Display

The forecast amount is imported from the Total Forecast column of NUPlans Forecasting.

Prelim Allocation

Expanded

Import/Display

This year’s budget times next year’s percent increase equals the preliminary allocation.

Suppl Allocation

Expanded

Import/Display

Schools and units will receive a communication from their Budget Office analyst identifying any approved recurring supplements and non-recurring commitments.

Prelim % Increase

Expanded

Calculated

The increase parameter is applied to the current year budget, per each budget class, to provide guidance on growth, shrinkage, or stability, and to calculate a preliminary allocation.

FYXX Budget Target

Calculated

This year’s budget plus all allocations equals next year’s budget target.

Budget Target is the size of next year’s budget, per each budget class, expressed as a positive number. Budget Target is provided as guidance to budgeters.

FYXX Bud Input

User Input

Use this column to input the entire budget at the account level.

NUPlans first checks the Status of the chart string. If active, input is allowed in the cell.

Some accounts do not allow data entry in this column (salary accounts, some utilities accounts, 79999, 88544, 88545, 88547, 88991, and 88992).

The column is summed vertically at four levels: revenue, expenses, chart string, and net.

·        Revenue is the sum of all revenue values entered in the column.

·        Expense is the sum of all expense values entered in the column.

·        The chart string row differs with the use of automatic balancing.

§  With automatic balancing (A/B), the chart string is: Revenue – Expense + Use of Reserves (88992) or – Buildup of Reserves (88991). Net is the same.

§  Without A/B, the chart string is Revenue – Expense. Net is the same.

§  The row for the Net of all chart strings appears at the fund level (to users with access to the entire budget grouping only).

Linked from Compensation

Expanded

Calculated

A summary of salary and benefits expenses, next to the applicable salary and benefits account in the Fund views.

Linked from Grants

Expanded

Calculated

A summary of Indirect Cost Recovery (ICR) revenue linked from the Grant Input view, displayed in the cell at the intersection of the column and account 40856. In most Areas, this revenue flows to a chart string at the Dean’s Office or Central Office level.

Linked from Commitments

Expanded

Calculated

A summary of commitment revenue linked from the Commitment process, displayed in the cell at the intersection of the applicable account.

Linked from Utilities

Expanded

Calculated

A summary of utility expenses. In some Areas, this expense flows to a chart string at the Dean’s Office or Prep File level.

Total Linked In

Calculated

The total of all linked-in amounts from Compensation, Grants, Commitments, and Utilities

FYXX Final Budget

Calculated

Horizontally, this column displays the sum of Budget Input and Total Linked In. Vertically, the column is summed at four levels: revenue, expenses, chart string, and net. Revenue is the sum of all revenue values displayed in the column, except 88992.

·        Expense is the sum of all expense values displayed in the column, except 88991.

·        The chart string row differs with the use automatic balancing (A/B):

§  With A/B, the chart string is zero (0) + Dean/VP Allocations. Net is the same.

§  Without A/B, the chart string is Revenue – Expense. Net is the same.

With A/B, a Dean/VP Allocation figures into the amounts at the intersections of the chart string row and the Net row. Net appears at the fund level (to users with access to the entire budget grouping only).

Var: FYXX Bud vs FYXX Bud Target

Calculated

FYXX Budget Target minus FYXX Final Budget

Var: FYXX Budget vs FYXX Bud

Calculated

This column displays the difference, if any, between the current year budget and next year’s budget.

Var %: FYXX Budget vs FYXX Bud

Calculated

Percent change between the current year budget (original + recurring adjustments) and next year’s budget.

Var: FYXX Budget vs FYXX Fcst

Calculated

This column displays the difference, if any, between the current year forecast and next year’s budget.

Var %: FYXX Budget vs FYXX Fcst

Calculated

Percent change between the current year forecast and next year’s budget.

FYXX Bud FYXX Bud

Import/Display

Two years of historical budget data are imported from NUFinancials and displayed to provide historical context and to help budgeters identify trends.

Notes

User input

Use the column to note or explain budget decisions.

Status

Import/Display

This column displays the status. If the chart string is inactive or has a status of do not budget, all fields will be gray and un-enterable in NUPlans.

Fund, Dept, Project, Account Code, Type

Import/Display

ChartFields provided for export to excel.

Column Name

Type

Definition

FYXX Income Est

Import/Display

The endowment income estimate provided by the Budget Office in the prior fiscal year.

FYXX Income Est

Import/Display

The endowment income estimate provided by the Budget Office.

FYXX Bud Input

User Input

The revenue budget input is prepopulated with the amount estimated by the Budget Office. Budgeters can accept the estimate or edit the amount to reflect cases where this is updated information. In case of edits, add comments to explain.

View

Example

Fund View

As you input amounts in the “FYXX Bud Input” column and recalculate:

·        NUPlans nets revenue and expense within the base chart string.

·        If they are equal, the chart string balance is zero and nothing further happens.

·        If they are unequal, NUPlans inserts a row for the out-of-balance (OOB) amount into the revenue or expense section.

§  The chart string is forced to zero (plus the area allocation if it exists).

§  The surplus amount is associated with expense account 88991 BUILDUP OF RESERVES, or

§  The deficit amount is associated with revenue account 88992 USE OF RESERVES.

§  As you continue budgeting and recalculating, OOB amounts update dynamically and disappear if revenue equals expenses.

In this example, the surplus on an endowment chart string – 19,491 – is associated with account 88991, and the net of revenue and expense is forced to zero in the FYXX Final Budget Column. No allocation exists and so does not figure into the calculation.

               Fund View: Endowment chart string with a buildup of reserves 

View

Example

§  Amounts associated with 88991 and 88992 flow to the Carry Forward view.

Carry Forward View

·        Amounts from the Fund views associated with accounts 88991 and 88992 flow to the Carry Forward view.

·        They are summarized in the column “FYXX (Use) or Buildup of Reserves – Net.”

§  This column works with other columns in the Carry Forward view.

·        It helps you predict carry forward at the end of the next fiscal year. Your beginning carry forward plus your use or buildup of reserves equals your ending carry forward:

§  Beg CFWD + (Use) or Buildup = End CFWD.

In this example, the surplus from an endowment chart string – 19,491 – appears in the Carry Forward View in the column “FYXX (Use) of Buildup of Reserves – Net.”

     Carry Forward View: Endowment chart strings with (use) and buildup of reserves

·        Central Allocation

·        Dean/VP Allocation

·        Carry Forward Funding

·        Revenue (external, internal, or transfer)

Spending Authority

Where is it visible?

Does it affect the Fund views?

Does it affect budgeting?

Central Allocation

Allocations View

No

Yes

It communicates the amount by which your expense budget can exceed revenue.

Carry Forward Funding

Carry Forward View – Find current year amounts and next year’s predicted beginning and ending amounts AND

Fund Views – Find current year amounts at the intersection of FYXX Beg CFWD and account 79999.

No

Carry Forward is separate from your final budget. Amounts do not add to the FYXX Final Budget.

Budget inputs on account 79999 are not allowed.

Yes

With automatic balancing, you can compare the use of reserves on account 88992 to the amount of carry forward that is currently available and estimated to be available. Is the balance sufficient for the planned use?

Revenue

Fund Views

You enter estimates at the account level.

Yes

Revenue is summed and netted with Expense.

Yes

A revenue budget is possible on any chart string.

·        Central Allocation

·        Dean/VP Allocation

·        Carry Forward Funding

·        Revenue (external, internal, or transfer)

Spending Authority

Where is it visible?

Does it affect the Fund views?

Does it affect budgeting?

Central Allocation

Allocations View

No

Yes

It communicates the amount by which your expense budget can exceed revenue.

Carry Forward Funding

Carry Forward View – Find current year amounts and next year’s predicted beginning amount.

AND

Fund Views - Find current year amounts at the intersection of FYXX Beg CFWD and account 79999.

No

Carry Forward is separate from your final budget. Amounts do not add to the FYXX Final Budget.

Budget input on account 79999 is not allowed.

Yes

You can compare the expense budget to the amount of carry forward that is currently available and estimated to be available. Is the balance sufficient for the planned use?

Revenue

Fund Views

You enter estimates at the account level.

Yes

Revenue is summed and netted with Expense.

Yes

A revenue budget is possible on any chart string.