university of minnesota enterprise financial system l.
Skip this Video
Loading SlideShow in 5 Seconds..
University of Minnesota Enterprise Financial System PowerPoint Presentation
Download Presentation
University of Minnesota Enterprise Financial System

Loading in 2 Seconds...

play fullscreen
1 / 15

University of Minnesota Enterprise Financial System - PowerPoint PPT Presentation

  • Uploaded on

University of Minnesota Enterprise Financial System EFS Update October 13, 2005 1. COA Values Subproject Started with the structure proposed by the COA Design team Looked at requirements from RFP, EFS teams, focus groups, other universities, etc.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'University of Minnesota Enterprise Financial System' - johana

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
university of minnesota enterprise financial system

University of Minnesota Enterprise Financial System

EFS UpdateOctober 13, 2005

1 coa values subproject
1. COA Values Subproject
  • Started with the structure proposed by the COA Design team
  • Looked at requirements from RFP, EFS teams, focus groups, other universities, etc.
  • Creating values and definitions for all ChartFields, except…
      • DeptID
      • Department-defined Program
      • ProjectID
      • ProductID
  • Creating a Chart of Accounts Manual
  • Developing COA maintenance procedures
  • Timeline: May 1 – October 31
current chart coa structure
Fund – source of funding, by campus location

Area – department or unit within college

Org – project or program within an area

SubOrg – for detailed tracking of rev and exp

Function – purpose of project or program (e.g. research, instruction)

Object/Revenue – type of expense or revenue

SubObj/SubRev – further refinement

Balance Sheet – assets, liabilities and fund balances within a fund

Current Chart COA Structure
coa values team approach
COA Values Team Approach
  • 8 work groups for 11 ChartFields
  • Staffed with core team members and University representation:
      • A-REST (Account - Revenue; Expense; Statistics; Transfer) [1]
      • Balance Sheet Account [1]
      • DeptID & Program [2,3]
      • Fund [4]
      • Class [5]
      • ProjectID & Budget Reference [6,7]
      • ProductID [8]
      • CF1/CF2 & Statistical Code [9,10,11]
revenue expense accounts
Revenue & Expense Accounts
  • No significant change in the number of revenue, expense and transfer codes
  • Substantial change in the actual revenue, expense and transfer code ‘values’
  • Unique sponsored accounts are grouped together (and differentiated from non-sponsored accounts)
  • Travel-related activity is being grouped together (mileage; parking; travel)
  • Other like items are together so that users can see all the account options in one place (rather than dispersed, as is the case with the current chart of accounts)
balance sheet accounts
Balance Sheet Accounts
  • Approach to numbering has not changed (1’s for assets; 2’s for liabilities; and 3’s for net assets)
  • This concept is best practice and is similar to CUFS today
  • With more emphasis on the balance sheet, definitions are being written for the first time
  • Some balance sheet accounts have been expanded, while others have been aggregated
deptid program
DeptID & Program
  • Department
    • Campus differentiator is in the DeptID
    • “What is the level at which I need to isolate a group of funds, employees, or academic programs to support effective management of financial, human, and academic resources?”
    • Who does it
    • Eight characters
  • Program
    • “What is the level of activity for which I need to capture financial information?”
    • What you do
    • Started with five characters, but …
    • Renamed CF3 to give us an extra digit: UMProgram
  • Goal was to simplify and reduce the number of funds from today’s 1,400+
  • Campus differentiation will not be in the Fund
  • Agency (9XXX) funds will be reduced greatly
  • Loan funds retain program details, and, therefore are the largest group of funds
  • Working with many parties to combine several unrestricted funds: tuition; O&M; ICR; University fee income; central reserves; and other unrestricted funds
  • Common theme: one activity, multiple funds
  • Fund will not be inferred
class function
Class (Function)
  • 58 function codes today; 35 remain
  • Subtleties are confusing to departments
  • Primarily used by Accounting Services, SPA, and IRR
  • Goal was to simplify and reduce the number of function codes
  • Testing a table for inferring function
  • Class inference is a PeopleSoft customization
  • Departments still need to be involved in the assignment of Class codes
  • Programs must be set sufficiently ‘low’ to be assigned a single Class code
projectid budget reference
ProjectID & Budget Reference
  • Envisioned for sponsored & construction projects, as well as grants-in-aid
  • Additional candidates considered but not pursued: federal & state appropriations, bond issuances, restricted state specials
  • Facilities and sponsored ‘numbering’ schemes in the Compass and EGMS systems
  • Budget Reference – 4-digit numeric value meaningful within the department only
  • Survey of other PeopleSoft universities revealed no use of, or interest in!
  • Purchasing – ‘Item’ and ‘Category’
  • Auxiliaries & ISO’s – no value added as long as they have their current systems
  • Desire to keep the ChartField for its intended purpose
  • Will not use until we find that purpose!
cf1 cf2 statistical code
CF1/CF2 & Statistical Code
  • Statistical Codes
    • Ideas for values collected
    • Will recommend use post-implementation
  • Optional user-defined ChartFields considered for:
    • Security types and portfolio investment managers (OAM)
    • UMF fund tracking
    • More detailed and specific ‘object’ codes
    • Fringe benefit categories
2 purchasing subproject
2. Purchasing Subproject
  • Two teams have been merged into one
  • Includes these subprocesses:
    • Professional Services
    • Receiving
    • U-Wide Contracts
    • Procurement of Standard Goods & Services
    • Management of Bids
    • eProcurement (ePro)
approach scope
Approach & Scope
  • Joint requirements gathering: Purchasing, Accounts Payable, Expenses
  • Sponsored and nonsponsored purchasing, including construction
  • Defining the best future processes
  • Identifying opportunities for business process improvements
  • Timeline: August 1 – June 15
  • Gina Danyluk (COA Values)


  • Henry Hoefer (Purchasing)


    • No new requirements, please!