PeopleSoft Financials 8.4 Implementation Project Chart Of Accounts Rollout December 3, 2002 Agenda • • • • • • Chart Of Account (COA) History Introduction Of New Chart Of Accounts Comparison Of.
Download ReportTranscript PeopleSoft Financials 8.4 Implementation Project Chart Of Accounts Rollout December 3, 2002 Agenda • • • • • • Chart Of Account (COA) History Introduction Of New Chart Of Accounts Comparison Of.
PeopleSoft Financials 8.4 Implementation Project Chart Of Accounts Rollout December 3, 2002 Agenda • • • • • • Chart Of Account (COA) History Introduction Of New Chart Of Accounts Comparison Of Old vs. New Examples Communications Team Questions History • Effort Started Two Years Ago • Campus Wide Committee – Amy Taylor • Focus Groups • Visited Other Universities – James Madison University – Princeton Objectives • • • • • New Technology New Reporting Needs Reduce Complementary Systems Capture New Data Needs Ease Of Data Entry Design Objectives • Ease of Reporting • Capture Data Elements – (New and Old) • Use Trees To Summarize • User Defined Field(s) • INITIAL SIGHT RECOGNITION – Purpose Design The Big Rule: Each Chartfield Should Have a One-ToMany Relationship With EACH Other Individual Chartfield. (If This Relationship Does Not Exist Then It Should Not Be A Chartfield) Chartfield Comparison PeopleSoft Chartfield Account = UD Legacy Object Code PeopleSoft Chartfield Account Accounts classify transactions as expenditure, revenue, asset, liability, or Net Assets (Equity) transactions Chartfield Comparison PeopleSoft Chartfield Account = UD Legacy Object Code Class = Line Number PeopleSoft Chartfield Class A budget line associated with a position (or person) within the University Chartfield Comparison PeopleSoft Chartfield UD Legacy Account = Object Code Class = Line Number Purpose = 11 Digit Account PeopleSoft Chartfield Purpose • Crosswalk - 11 Digit legacy code for immediate future • An Activity that can have revenue, expense, and balance sheet components. Ease Of Data Entry • SpeedType/SpeedChart – – – – Fills in Chartfields Attach security Unique Name Equal Purpose Code • Example: CHEM11 Chartfield Comparison PeopleSoft Chartfield Fund = UD Legacy OPBAS OPSS OPBAL NOLOA NOLEND NOPLT AGNCY PeopleSoft Chartfield Fund Fund maintain a self-balancing set of accounts that record cash and other financial resources, together with the related liabilities and residual equities or balances, as well as the changes therein. Funds segregate financial information for the purpose of carrying on specific activities and attaining certain objectives in accordance with GASB definition, restrictions, and limitations. Examples of fund codes are OPBAS, OPSS, NOEND. PeopleSoft Chartfield DeptId Indicates who is responsible for (source) or impacted by (owner) a transaction. DeptId is a systematic representation of the divisional breakdown of an entity. Each DeptId represents an operating unit within an entity. The proposed UD DeptId values mirror the values in HR/Payroll. DeptId will be used for hierarchical roll-ups and reporting PeopleSoft Chartfield Program Program, is defined by NACUBO as an ongoing specific regular event. Programs may cross organizations, funds, sources of funds, and they may have revenues and expenses. Programs generally do not have a specific end-date, but instead, they continue on for the foreseeable future. PeopleSoft Chartfield Project Projects are an event or activity that has a specific beginning and end date. Further breakdown of project costs is done in the Project Costing module (PC). PeopleSoft Chartfield Source Source is meant to describe the different sources of funds or revenue collected by the University. Source will allow the University to record revenue by source and to provide specialized reporting data to the funding source. PeopleSoft Chartfield User Field(s) User Fields are designed to meet end-user criteria for recording and reporting data. Currently there is one designed into the system though there can be as many as three. Chartfield Mapping Chemistry Supplemental Funds 1-7-09-2522-50-410 CHEM17S 141000 OPBAL INST2 BLANK 70000000 02522 Purpose & Speedtype Account Fund Program Project Source Dept Id Web Availability • • • • • Account Purpose Source Department Id Program Examples • • • • Account Purpose Program DeptId Trees Trees Hierarchical representation or organization of data Chartfield Road Map OLD FIELD NEW UD FIELD 11-digit code Object code Line number Purpose Account Class SELECTION FIELDS: ADDITIONAL FIELDS FOR REPORTING: Fund Type Function (characters 4 & 5) No UD Equivalent Fdg sources & agency codes No UD Equivalent Fund Program Project Source Chartfield 3 (User field) CENTRAL HIERARCHICAL STRUCTURE FOR REPORTING: Current UD hierarchical “tree” Dept ID Comments • Review Chartfield Values – www.udel.edu/UDFS/info/ • Help Tab – www.udel.edu/UDFS/coa110402.html • See What We Missed – (Values) • Contact Your Comm Team Member PS Financials Communication Team Name Anderson, Paul Bloch, Anna Bottorff, Peggy Broadway, Michelle Cook, Chris Fanjoy,Al Fitzpatrick, Bill Grasson, Steve Huber, Lisa Knutsen, Ginger Lepine, Ellen McCarren, Dave Miller, Tim Murphy,Chris Prazniak, Eileen Smith, Dee Somers, Linda Taylor, Amy Department Title Library Assistant Director HRSA HR Systems Administrator Provost Office Assistant Provost Budget Office Associate Director Engineering - Dean's Office Assistant Dean PCS Admin of Special Sessions Financial & Info Services Assistant Director Student Health Service Asst Director for Administration Ctr for International Studies Financial Manger ANR Accountant Treasurer's Office Assistant Director Marine Studies Executive Officer CHEP - Dean's Office Assistant to the Dean User Services Systems Planner General Accounting Senior Accountant A&S - Dean's Office Manager B&E Dean Business Manager HNS Business Manager Phone 2231 8677 2101 1234 2401 2853 8279 8331 0247 2501 2107 8255 2397 3738 1026 4104 8278 8927 Email [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] Questions PS Financials Communication Team Name Anderson, Paul Bloch, Anna Bottorff, Peggy Broadway, Michelle Cook, Chris Fanjoy,Al Fitzpatrick, Bill Grasson, Steve Huber, Lisa Knutsen, Ginger Lepine, Ellen McCarren, Dave Miller, Tim Murphy,Chris Prazniak, Eileen Smith, Dee Somers, Linda Taylor, Amy Department Title Library Assistant Director HRSA HR Systems Administrator Provost Office Assistant Provost Budget Office Associate Director Engineering - Dean's Office Assistant Dean PCS Admin of Special Sessions Financial & Info Services Assistant Director Student Health Service Asst Director for Administration Ctr for International Studies Financial Manger ANR Accountant Treasurer's Office Assistant Director Marine Studies Executive Officer CHEP - Dean's Office Assistant to the Dean User Services Systems Planner General Accounting Senior Accountant A&S - Dean's Office Manager B&E Dean Business Manager HNS Business Manager Phone 2231 8677 2101 1234 2401 2853 8279 8331 0247 2501 2107 8255 2397 3738 1026 4104 8278 8927 Email [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected]