Topics Map > Accounting & Budgeting > Sponsored Programs

Sponsored Programs - Multi-Year Labor Encumbering

This article provides information about Multi-Year Labor Encumbering

Encumbrances provide financial forecasting functionality that users currently use to manage funds over the course of a fiscal year or project. Encumbrances can be used to earmark funding for specific purposes, such as anticipated salary or purchases. Encumbrances reduce the budget balance available for the associated Fund, Organization, and Program code accounting string combination.

Payroll encumbrances are created from job records entered into the Employee Jobs Form (NBAJOBS) or the HR Front End (HRFE). An encumbrance is created for each employee job record based on the beginning and end date of the job (if applicable based on employee class). The Banner labor and fringe encumbrance functionality was previously limited to the current fiscal year (through June 30). However, grant funds and federal appropriations typically span multiple fiscal years. This multi-year labor encumbrance enhancement creates separate labor encumbrances representing labor and fringe charges to be incurred in future fiscal years. This feature gives users a reliable method for tracking and managing future salary charges on grant funds and federal appropriations which span multiple fiscal years.

Table of Contents

Setup for Multiple Year Labor Encumbering

The setup and maintenance required for multiple year labor encumbrances is transparent to most users and does not require business process changes in the departmental units. Payroll encumbrances are created from job records entered on NBAJOBS or the HR Front End. However, anticipated labor charges on grant funds are now obligated for the entire project or funding period of the grant.

The following describes how grant and federal appropriation funds are identified for multiple year labor encumbering in Banner.

The new enhancement includes an Encumber Multi Year Labor checkbox on the Fund Type Maintenance form (FTMFTYP) in Banner. All sponsored project fund types: 4A, 4C, 4E, and 4G are set up to encumber multi-year labor. Federal appropriations (Fund Type 4Y) also has this configuration.

In addition to the Multi Year checkbox on FTMFTYP, there is a new Encumber Multi Year Labor checkbox on FZMRFND, a form used to set up grant funds. The Multi-Year indicator defaults from the fund type so all sponsored project funds, by default, encumber all future salary charges (regardless of the fiscal year the salary charges are incurred). The Grants Office has the option to uncheck the box for individual funds. (No action is needed by the departmental units.) Certain federal appropriations also have this box checked.

Date Logic

The multiple year encumbering process uses various Finance and HR dates to determine the start and end dates of the encumbrance calculation. It is important for units to have a working knowledge of the date logic used to calculate salary and fringe encumbrances.

Start Date

The multiple year encumbering process uses the logic below to determine the encumbrance start date. Encumbrance Start Date is the greater of:

  • 1st day of the current fiscal year
  • NBAJOBS Job Begin Date
  • NBAJOBS Contract Begin Date
  • NBAJOBS Labor distribution change
  • NBAJOBS Latest recast date (most common) – on the Job Labor Distribution tab, this is the Banner process that tracks the next work days not yet paid.

End Date

The multiple year encumbering process uses the logic below to determine the encumbrance end date.

    1. If the Budget Period End Date on the Research Accounting Fund Maintenance Form (FZMRFND) is populated, the encumbrance end date is the earliest of the following:
      • FZMRFND Budget Period End Date (most common)
      • FZMFUND Termination Date
      • NBAJOBS Encumbrance Override End Date
      • NBAJOBS Job labor distribution FOAPAL changes in the active FY
      • NBAJOBS Contract End Date
      • NBAJOBS Job End Date
      • Maximum Fiscal Year defined on Fiscal Year form, NBAFISC
      • Maximum Payroll Year/Payroll ID defined on Payroll Calendar Rules form, PTRCALN
    2. If Budget Period End Date on FZMRFND is NOT populated, and the Project End Date on FZAGRNT is populated, the encumbrance end date is the earliest of the following:
      • FZAGRNT Project End Date
      • FZMFUND Termination Date
      • NBAJOBS Encumbrance Override End Date
      • NBAJOBS Job labor distribution FOAPAL changes in the active FY
      • NBAJOBS Contract End Date
      • NBAJOBS Job End Date
      • Maximum Fiscal Year defined on Fiscal Year form, NBAFISC
      • Maximum Payroll Year/Payroll ID defined on Payroll Calendar Rules form, PTRCALN
    3. If the FZMRFND Budget Period End Date and the FZAGRNT Project End Date are not populated, no MYE is calculated. The earliest of the following is used when calculating the end of the current year encumbrance:
      • FZMFUND Termination Date
      • NBAJOBS Encumbrance Override Date
      • NBAJOBS Job labor distribution FOAPAL changes in the active FY
      • NBAJOBS Contract End Date
      • NBAJOBS Job End Date
      • End Date of the Active Fiscal Year

Setup and Maintenance of Dates used in Multiple Year Encumbrance Calculations

In most cases, two dates that the your university sponsored programs post-award office maintains are the dates used for encumbrance end date calculations: the Grant Budget End Date on FZMRFND and the Grant Project End Date on FZAGRNT. The definitions and process for entering and maintaining these dates is as follows:

Research Accounting Fund Maintenance Form (FZMRFND)

FZMRFND: Budget Period End Date

  • Represents the obligated funding period.
  • your university sponsored programs post-award office maintains as the funding period changes.

Grant Maintenance Form (FZAGRNT)

FZAGRNT: Project End Date

  • Reflects the entire project period of the grant.

Use of Grant Dates in Multi-Year Labor Encumbering Example

A sponsored project award has a five-year period of performance: 6/01/2009 through 5/31/2014, with budget currently obligated for the first year. The your university sponsored programs post-award office enters Project and Budget End Dates as follows:

  • FZAGRNT Project Start Date: 6/01/2009
  • FZAGRNT Project End Date: 5/31/2014
  • FZMRFND Budget Period Start Date: 6/01/2009
  • FZMRFND Budget Period End Date: 5/31/2010

(your university sponsored programs post-award office updates as additional years of funding are obligated.) In most cases, the multiple-year encumbering process for this example encumbers salary and fringe through 5/31/2010. However, as described previously, other factors such as a job end date earlier than 5/31/2010, a terminated fund, etc., will impact the encumbrance calculation end date.

Encumbrance Calculation Examples

Example 1 – Multiple Year Projection with a Change in the Labor Distribution during the Current Fiscal Year

The fiscal year is 7/1/2009 to 6/30/2010.

An employee is appointed to a position as of 7/1/2009, paid monthly, with an annual salary of $60,000, and charged to one C-FOAP funded from institutional funds. Assign Salary is $5,000 (salary per pay period from NBAJOBS).

The employee is assigned to work under a grant effective 2/16/2010. Therefore, a labor distribution change is entered effective 2/16/2010 moving from institutional funds to a grant fund. The grant obligated funding period runs for two years from 10/16/2009 to 9/15/2011.

Encumbrance process is run with a Recast Date of 1/16/2010.

The encumbrance calculation determines that, as of the Recast Date, the 7/1/2009 institutional C-FOAP has a current encumbrance amount of $5,000 (Assign Salary x Number of Pays left = $5000 x 1). The encumbrance process also determines that the 2/16/2009 FOAPAL has a current encumbrance amount of $22,500.00 (Assign Salary x Number of Pays left = $5,000 x 4.5), and a future encumbrance of $72,500 (Assign Salary x Number of Pays left = $5,000 x 14.5).

Example 2 – Multiple Year Projection with a Job End Date Prior to End of Grant Funding Period

The fiscal year is 7/1/2009 to 6/30/2010.

An employee is appointed to one C-FOAP with a grant fund on 7/1/2009 with an NBAJOBS Job End Date of 3/15/2011. The employee is paid monthly with an annual salary of $12,000. Assign Salary is $1,000.

The grant fund has obligated funding through 5/15/2011. The Budget Period End Date on FZMRFND is 5/15/2011. Encumbrance process is run with a Recast Date of 1/16/2010.

The calculation determines that, as of the Recast Date, the current encumbrance amount for this employee for this fiscal year is $5,500 (Assign Salary x Number of Pays left = $1000 x 5.5). The process also determines that the future encumbrance is $8,500 (Assign Salary x Number of Pays left = $1,000 x 8.5).

The grant funding period allows for another two pays through 5/15/2011, but because a Job End Date of 3/15/2011 exists, the future year encumbrance is limited to that date.

Example 3 – Multiple Year Projection with Multiple Labor Distribution C-FOAPs

The fiscal year is 7/1/2009 to 6/30/2010.

An employee is appointed to a position as of 9/1/2009, paid monthly, with an annual salary of $60,000, and the Assign Salary is $5,000. The labor distribution is assigned to one institutional fund at 66.67% and one grant fund at 33.33%.

The grant funding period runs from 9/16/2009 to 8/15/2012.

The encumbrance process is run with a Recast Date of 9/16/2009. The calculation determines that, as of the Recast Date, the current encumbrance of the job is $47,500 (Assign Salary x Number of Pays left = $5,000 x 9.5). The process also determines that the future encumbrance for the grant funded portion is $42,495.75 (Assign Salary x Number of Pays left x Grant C-FOAP% = $5,000 x 25.5 x .3333).

Multiple Year Encumbrance Data in Banner

Future year encumbrances post to Banner within the currently active fiscal year and period.

Grant Inception to Date Form (FZIGITD)

Encumbrances for current and future years for a specific grant C-FOAP can be viewed in total using the FZIGITD form.

Detail Encumbrance Activity Form (FGIENCD)

The Detail Encumbrance Activity Form (FGIENCD) is used to query detailed transaction activities against encumbrances. The form displays useful information such as encumbrance status, creation date, and overall balance. With the multiple-year encumbering enhancement, details of both current and future year labor and fringe are available and delineated by unique encumbrance item numbers.

Current Fiscal Year Encumbrance Item Numbers

Caption
Encumbrance Item Number Encumbrance Item Description
0 Gross Salary
11 Medicare
12 OASDI
13, 14, 15 Retirement
16 Federal Retirement
17, 18, 19 Health, Life, Dental
20 Urbana Grad Assistant Health Benefit
21 Chicago Grad Assistant Health Benefit

Future Fiscal Year Encumbrance Item Numbers

Caption
Encumbrance Item Number Encumbrance Item Description
3 Future Year Gross Salary
31 Medicare
32 OASDI
33, 34, 35 Retirement
36 Federal Retirement
37, 38, 39 Health, Life, Dental
40 Urbana Grad Assistant Health Benefit
41 Chicago Grad Assistant Health Benefit

Reports

Several reports incorporate future year encumbrance data and dates used in multiple year encumbrance calculations.

  • Asset/Liability Detail and Summary Statements and the Revenue/Expense/Transfer Detail and Summary Statements: Budget Period Start and End Dates from FZMRFND are available.
  • Revenue/Expense/Transfer Detail and Summary Statements Inception to Date: Reflects total (current and future year) encumbrances.
  • HRPAY00098 Payroll Encumbrance by Person Pay Period: FZAGRNT Project Start and End Dates, FZMRFND Budget Period Start and End Dates, and Fund termination date are available. Current and future year personnel encumbrance totals are separated.
  • HRPAY00102 Payroll Encumbrance by Person Month End: FZAGRNT Project Start and End Dates, FZMRFND Budget Period Start and End Dates, and Fund termination date are available. Current and future year personnel encumbrance totals are separated.


KeywordsNBAJOBS FZMRFND FTMFTYP FZAGRNT FZMFUND FZIGITD FGIENCD   Doc ID132516
OwnerLearning Systems SupportGroupUI Training and Development Resources
Created2023-11-03 09:10:16Updated2024-06-26 15:18:40
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0