470 likes | 579 Views
BGSU/PeopleSoft . Meet Your FMS Chartfields. Learning Objectives. State the goal of the chartfield selection process Explain the process used to select the FMS chartfields Define the term Chart of Accounts (COA) and explain its function in financial accounting. Learning Objectives.
E N D
BGSU/PeopleSoft Meet Your FMS Chartfields
Learning Objectives • State the goal of the chartfield selection process • Explain the process used to select the FMS chartfields • Define the term Chart of Accounts (COA) and explain its function in financial accounting
Learning Objectives • List and define the AFIN legacy fields and the FMS chartfields • Discuss how the AFIN legacy fields equate to the FMS chartfields • Provide an example of the FMS chartfields applicable to your department
Primary Goal • Maximize ability to store meaningful data • Minimize the number of fields users must input
Important Considerations • Identify BGSU Stakeholders • Consider all alternatives • Base recommendations from delivered PeopleSoft functionality • Consider federal, state, and local accountability demands • Make the best use of resources
The Chart of Accounts • Made up of segments and codes • Uses segments to categorize transactions • Uses codes to identify specific transactions within segments
Segments and Codes 22, 51, 01 019, 150 599 1000, 5000 6000, 7000
Reviewing the AFIN Legacy Fields Account Type Fund Agency Organization Sub-Organization Expense Object Sub-Expense Object Revenue Source Sub-Revenue Source Activity Balance Sheet Account
Account Type • 2-digit code • Describes type of transaction • Examples (20 Pre-encumbrance, 21 Encumbrance, 22 Expenditure)
Fund • 4-digit code • Designates funding source • Examples (1000 Educational/General)
Agency • 3-digit code • Denotes Vice-Presidential, College, or Departmental area • Examples (033, Romance Languages)
Organization • 4-digit code • Itemizes activities within the agency • Examples ( 0470, Romance Languages; 0483, Summer in Spain)
Sub-Organization • 2-digit code • Provides additional detail for the organization • Examples ( 50, Chemistry Graduate Programs; 51, Chemistry/Faculty Search)
Expense Object • 4-digit code • Denotes item purchased or charged • Examples (3012, Copiers)
Sub-Expense Object • 2-digit code • Provides additional detail of expenditure • Examples (02, Copier Maintenance; 03, Lease Payments)
Revenue Source • 4-digit code • Denotes an income source • Examples (0210, Instructional Fees)
Sub-Revenue Source • 2-digit code • Provides additional detail of income • Examples (02, Undergraduate; 03, Graduate)
Activity • 4-character code • Groups transactions for reporting purposes • Examples ( Ohio Board of Regents Reporting)
Balance Sheet Account • 4-digit code • Denotes the permanent accounts used to classify assets, liabilities, and equity • Examples (1001, Cash; 1200, Accounts Receivable)
Previewing Your FMS Chartfields Account Type Account Class (Revenue) Fund Department Cost Center Program Project/Grant
Business Unit • 5-character code • Collects all transactions relating to one federal tax identification number • BGSUN
Account Type • One-digit code • Describes type of transaction • Examples (Expense, Revenue, Asset, Liability, Equity)
Account • 5-digit code • Uses the account type code as its first digit • Further classifies nature of transaction • Examples (Revenue Account: Instructional Fee; Expense Account: Postage)
Class (Revenue) • 3-digit code • Provides additional layer of revenue detail • Examples (Undergraduate, graduate; to further clarify instructional fee)
Fund • 5-digit code • Designates the funding source • Examples (Educational/General)
Department Cost Center • 6-digit code • Defines the spending authority for fiscal year transactions • Examples (President’s Office; Springboard)
Program • 4-digit code • Further defines activities within Department Cost Center • Example (Art Department: Ceramics or Painting)
Project/Grant • 8- digit code • 8 digits for Projects • 8 digits for Grants • Defines the spending authority for multi-year transactions • Examples (Sebo Athletic Center; Upward Bound)
A Framework for Comparison • Spending Authority, Revenue, and Expense Functions • Balance Sheet Functions
Spending Authority, Expense, and Revenue Functions • Concern General Ledger Transactions • Purchasing • Accounts Payable • Accounts Receivable
AFIN Recorded in General Ledger FMS Recorded in FMS’s Commitment Control Ledger, Not its General Ledger Pre-Encumbrance and Encumbrance Transactions
Balance Sheet Functions • Handled by campus accounting personnel • Concern General Ledger transactions • What the university owns (assets) • What the university owes (liabilities) • What the university has in reserve funds (equity)
Assigning Copier Expense for Chemistry Faculty Search Appropriation Chemistry Operating 0380550O AFIN Fund 1000 Agency Chemistry 038 Org Main Oper 0550 Sub-Org Fac Search 51 E Object Copiers 3012 Sub E-Object Usage 01 FMS Fund 10000 Department Cost Center Chemistry 038100 Program Fac Search CH52 Account Copier Usage 53301
Assigning Copier Expense for Upward Bound Grant Appropriation Upward Bound 4205013O AFIN Fund 4402 Agency Multicultural Prgrms 420 Org 5013 E Object Copiers 3012 Sub-E Object Usage 01 FMS Fund 40000 Project/Grant 14200009 PC Bus Activity Account Copier Usage 53301
University Bookstore Balance Sheet Account AFIN Fund Bookstore 2310 Account Type Asset 01 Bal Sheet Acct Cash 1001 FMS Fund Bookstore 23310 Account Type Asset 01 Account Cash 10001
Sample Department Cost Center TreeExecutive Rollup • PRESIDENT • EXECUTIVE VICE-PRESIDENT • Chief Information Officer • Information Technology Services • Instructional Media • Equity and Diversity • EVP Office/administration • University Libraries • ……. • PROVOST Range = 010100-182999 • Academic Affairs • College of Arts and Sciences Range = 020100-055999 • Special Programs • Biological Sciences • English • Chemistry Range = 038100-038999 • Chemistry Dept Operating • McMaster Institute • Mead Imaging • College of Business
Summary • Chartfield Design and Selection • Chart of Accounts • Review of AFIN Legacy Fields • Preview of FMS Chartfields • Comparison of Legacy Fields and Chartfields • FMS Chartfields at Work
For Inquiring Minds • BG@100 - Phase I Scope Document • BG@100 - Chart of Accounts Design • http://www.bgsu.edu/BGat100 • Click on BG@100 Project Related Documents • BG@100 Email Address • BGat100@bgsu.edu
Certificate of Completionis hereby granted to_______________to certify that he/she has completed to satisfactionMeet Your FMS ChartfieldsDate Completed: Supervisor Signature and Title