This article describes the fund views in NUPlans Contributor that provide budgeters with two years of historical budget and actuals data.
NUPlans Contributor Fund Views
The centers of budget preparation in NUPlans are the Fund views: 110, 120, Clearing (131, 133), 151, 156, 160, 171, 172, Gifts, Endowments(400 series), Student Loans (500 series), Agency Funds (700 Series).
For reference and context, the views give budgeters two years of historical budget and actuals data. The current year budget, actuals to date, and encumbrances appear next. Data entry columns enable budgeters to enter budgets for the next fiscal year. Two more data entry columns enable budgeters to plan the use of reserves (if applicable) and enter comments.
NUPlans integrates budgeting with carry forward planning with functionality called “automatic balancing.” For each base chart string where it applies, automatic balancing nets revenue and expense and associates any out-of-balance amount with one of two dedicated account codes
– revenue account 88992 USE OF RESERVES or expense account 88991 BUILDUP OF RESERVES.
§ All Areas in the University use automatic balancing in the 171, Gift, and Endowment funds.
§ Areas opt-in to or opt-out of automatic balancing in all other funds.
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
|
Additional Resources
Access related training materials at: NUPlans Fund Budgeting
Fund 110 Input
The Fund views exist to collect and balance all expenses and revenue for departmental, program, and project budgets.
- There are only 2 columns on the Fund views for user input: Budget Input and Notes.
- Columns are accessible by scrolling right. Summary roll-up columns are bold. When they are expanded, the child columns appear to the left of the parent column.
- All chart strings in the fund are shown in numeric order. Row filters are available. Using the “wildcard” option and a text string surrounded by asterisks, you can filter by chart string or ChartField (for example *10007783*). Using the attribute option, you can filter by department, project, account, and status.
- Rows exist for qualifying accounts imported from NUFinancials, ordered in ascending numeric order by chart string and categorized under revenue or expense. Full chart strings are imported from NUFinancials on a nightly basis.
- Revenue and expense net at the base chart string level, and a separate row called Net appears at the fund level (only to users with access to the entire budget grouping.) All calculated amounts are rounded to the nearest dollar.
Columns
Column Name
|
Type
|
Definition
|
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.
|
Note: the same columns are seen in the same order on all fund views. Only the Endowments view has additional columns.
Endowments View
Several differences distinguish the Endowments view from the other fund views. There are three additional columns (shown below) and the column FYXX Bud Input is prepopulated with the Budget Office revenue estimate.
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.
|
Endowment Rates View
The Endowment Rate view is an informational view that displays pools and payout rates.
Drills to Detail in Linked-in Data
Drills to detail are available in the linked-in data columns of all the Fund views.
· The most useful may be the drill to compensation detail in the Linked from Compensation column.
· To access the drill-to command, right-click in a cell, mouse over the word Drill, and click the drill name.
· The example below shows the drill to detail for faculty salary expenses summarized in account 60011.
· There are two steps to employee names as explained below.
----------------------
------------------------
There are two steps to employee names, explained below.
How to Drill to Employee Compensation from the Fund Views
Drilling to employees is a two-part procedure.
1. Drill from Linked-In Compensation to Comp Budget by Chartstring (as shown above). Result: an intermediate view appears.
2. Drill again in the cell Budgeted Salary from Comp Input. Result: the employee names appear.
Budgeting with Automatic Balancing
Automatic balancing refers to functionality that integrates carry forward planning with budget input
- Chart strings with unequal revenue and expense are forced to zero (0) plus any area allocations, and the out-of-balance amount is inserted as a row with one of the automatic balancing accounts.
- Automatic balancing applies to 171 (opt out available), Gift, and Endowment Funds in all Areas of the University, and the example below is an Endowment. Some Areas apply automatic balancing to all Funds.
- Where it applies, you see the following effects in the Fund and Carry Forward views.
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
|
Spending Authority with Automatic Balancing
Below is a guide to finding the sources of spending authority for chart strings in Funds where automatic balancing applies. Sources of spending authority may be one or a combination of the following:
· 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.
|
For more information about allocations, refer to the NUPlans Allocations View training guide.
Spending Authority without Automatic Balancing
Areas that opt-out of automatic balancing in Funds 110, 150s, 160, and 172 see revenue minus expense at the chart string and net levels of FYXX Bud Input. Out-of-balance amounts are common and allowed. Nonetheless, it is good to know where to find the source of spending authority for the given chart string in NUPlans, whether one or a combination of the following:
· 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.
|
For more information about allocations, refer to the NUPlans Allocations View training guide.
Create Zero Dollar Salary Budgets
Agency Funds budgeters can flag chart strings that need a zero dollar salary budget created, using the Create $0 Salary Budgets view in NUPlans Web.
Navigation: NUPlans Web > Applications > Chart String Maintenance > Create $0 Salary Budget
Method
The method you use to establish budgets may vary, but in general, a method that you can follow is: For each chart string:
1. Review linked-In revenue and expenses.
o What compensation was already budgeted on the chart string?
o Is revenue from a Dean’s Commitment flowing into the chart string?
2. Review historical and current year financial data (budget, actuals, and carry forward).
3. Use NUPlans Web to add needed items to chart strings.
o Do you need to allocate spending authority to projects in Fund 171?
o Do you need to add accounts to a chart string?
o Do you need to add placeholders for salary expense that was not already budgeted?
o Create zero dollar salary budgets for Agency Funds (as needed).
4. Enter revenue and non-salary expense budgets.
5. Review the final budget, chart string balances, and variances.
6. Ensure each chart string has sufficient spending authority.
7. Enter comments to record your intentions.
Data Entry Tips
Follow the tips below to enter data in the NUPlans user input fields.
· Single-click a cell and type to overwrite the entire contents.
o Use the arrow keys to exit a cell to the right, left, up, or down.
· Double-click a cell to selectively edit or delete specific digits, or characters, within a cell.
o Use the
· Use the mouse to exit one cell by clicking into another cell, adjacent or non-adjacent.
· Track your changes since you last saved by observing the data in green font.
· Click Recalculate to save your changes privately and see your changes in blue font.
· Click Commit to save your changes publicly.
· Notify the members of your budget team when you start and finish.
For additional assistance please contact the IT Support Center at 847-491-4357 (1-HELP) or email servicedesk@northwestern.edu.