UNM Chart of Accounts Hierarchy - PowerPoint Presentation

404 views
Uploaded On 2018-10-12

UNM Chart of Accounts Hierarchy - PPT Presentation

Presented by Laura Putz August 9 amp 10 2010 revised for reserves 11811 UNM Organizational Structure and Account Hierarchy FOPA Hierarchies and Index Code How UNM is organized for reporting purposes ID: 688466

reporting level banner amp level reporting amp banner data report fund program hierarchy hyperion forms financial statement fopa research index run income

Link:

Copy

Embed:

<iframe width="560" height="315" src="https://www.docslides.com/embed/688466" frameborder="0" allowfullscreen></iframe>

Download Presentation from below link

Download Presentation The PPT/PDF document "UNM Chart of Accounts Hierarchy" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.

Presentation Transcript

Slide1

UNM Chart of Accounts HierarchyPresented by Laura PutzAugust 9 & 10, 2010(revised for reserves 11/8/11)Slide2

UNM Organizational Structure and Account HierarchyFOPA Hierarchies and Index CodeHow UNM is organized for reporting purposesChart of Accounts Structure

How accounting data is recorded and reported

Hyperion Reporting

Banner Forms Slide3

BANNERHyperion(Dynamic)

Forms

Nightly Update &

Weekly Reconciliation

ODS

Overview of UNM Finance Reporting StrategySlide4

What does this mean?You run a Hyperion report:It has data that was in Banner the night before. If a JV posted yesterday and you run the report today, you will see the posted JV reflected in the data for the reporting period.You drill down on a Banner Form to see report data:This data is what is currently in Banner. If a JV was approved and posted an hour ago, that JV will be reflected in the data you are viewing. It will NOT be reflected in your Hyperion report until tomorrow.Slide5

First, the way UNM is structured:Slide6

Index- Speed dial to FOPAPurpose: Facilitates feeder systemsFacilitates data entryReportingAdvantages Control of FOPA combinations

Simplifies data entry

Simplifies basic reporting Simplifies day to day accounting

Disadvantages

Maintenance Masks data grouping advantages of hierarchiesSCT delivered reports do not typically utilize the Index codeSlide7

Index to FOPA ExamplesIndex 258000 = 3u0044258BP131GNACTVIndex 043420 = 3U0034043BP222043E01Index 8510V4 = 379H0851N13P17RGNACTVWhich do you prefer???Slide8

FOPA Structure-FundFundDesignates a fiscal and accounting entity with a self-balancing set of accountsConnection point between GL and OLMust have a financial manager

Determined by SOURCE of funds

Organization

A permanent unit with assigned employees and operational budget

Must have a financial managerProgramDesignates NACUBO functional classifications such as: Instruction, Research, and Public service.Used primarily for Higher Education Department (HED) reportingActivityIs an event, conference, center or other designations that require separate income statement (revenue and expense) tracking Slide9

Fund Type: Level 1

Level 2

Fund Code: Level 1

Level 2 Level 3

Level 4 Level 5Fund Hierarchy

HR Analysis Soil Moisture Dynamics3R01YHR Federal C & G HSC

3RFEDCR - HSC13Current Restricted10

Reserved

for future use

Project Year/

Subproject

Project Year/

Sub ProjectFund Detail/Project

Fund Classification/Source

Fund Entity

Fund Accounting Category

301Y0HR Analysis Soil Moisture DynamicsSlide10

Fund HierarchyIf a report is run at Fund level 2, 3U56-HU General Clinical Service - all 13 funds that roll up into this fund will be included.Contra Program reflected in reports impact reserves reporting at Level 1 and Level 2.If a report is run at Fund level 3, 3U0029-HU Clinical Residuals - all indices that roll up into this subset. This will NOT include any indices in other level three funds.Slide11

Fund Hierarchy in Banner - FTIFNDHSlide12

Eprint-Fund Hierarchy ReportSlide13

FOPA Structure-ProgramFundDesignates a fiscal and accounting entity with a self-balancing set of accountsConnection point between GL and OLMust have a financial manager

Organization

A permanent unit with assigned employees and operational budgetMust have a financial manager

Program

Designates NACUBO functional classifications such as: Instruction, Research, and Public service.Used primarily for Higher Education Department (HED) reportingShould be consistent with Fund choiceActivityIs an event, conference, center or other designations that require separate income statement (revenue and expense) tracking Slide14

Level 1Level 2

Level 3

Level 4

Level 5

Program HierarchyProgram

Reserved for Future Use

Program or Project

(Endowed and Non-Endowed Spending, etc.)

NACUBO Functional Classifications

(Sponsored Research, Dept Administration, etc.)

Mission (Education, Research, Public Svc, etc.)

P163 – Fetal Alcohol Syndrome

P16 – Research UnrestrictedP2 ResearchReserved for Future UseSlide15

Program HierarchyIf a report is run at Program Level 1 for Research, data for ALL indices that have a Research program will be included.Contra-programs included if reports generated by Fund Level 1 or 2If a report is run at Program Level 3, only data for indices for that specific Program or Project will be included.Slide16

Program Hierarchy in Banner - FTIPRGHSlide17

Eprint-Program Hierarchy ReportSlide18

FOPA Structure-OrganizationFundDesignates a fiscal and accounting entity with a self-balancing set of accountsConnection point between GL and OLMust have a financial manager

Organization

A permanent unit with assigned employees and operational budget

Must have a financial manager

Levels 1 – 4 determined by institutionLevels 5 – 8 determined by departmentProgramDesignates NACUBO functional classifications such as: Instruction, Research, and Public service.Used primarily for Higher Education Department (HED) reportingActivityIs an event, conference, center or other designations that require separate income statement (revenue and expense) tracking Slide19

19Level 1Level 2

Level 3

Level 4

Level 5

Level 6 Level 7

Level 8 Organization Hierarchy

PI or other Reporting Unit

Financial Reporting element

Division/Financial Reporting Unit

Department

Classification

College

Vice President

President/Governing Board

AFA2 –

AVP for Finance

AF – Executive VP for HSCA - President

258A - Unrestricted Accounting - HSC258B – HSC Unrestricted AccountingAFA - HSC AdminSlide20

FTMORGNSlide21

FTMORGN Drill DownSlide22

Organizational HierarchyReports run at the “AF” Organizational level (Level 2) will have all index data that rolls up into the AF (VP Health Sciences Center) OrganizationReports run at the “997B” organizational level (Level 6) will have all index data that rolls up into the 997B (Pediatrics Administration Division) Organization, which is WITHIN the VP Health Sciences Center (AF) Level 2 organization.Slide23

Eprint-Organizational Hierarchy ReportSlide24

FOPA Structure-ActivityFundDesignates a fiscal and accounting entity with a self-balancing set of accountsConnection point between GL and OLMust have a financial manager

Organization

A permanent unit with assigned employees and operational budgetMust have a financial manager

Program

Designates NACUBO functional classifications such as: Instruction, Research, and Public service.Used primarily for Higher Education Department (HED) reportingActivityIs an event, conference, center or other designations that require separate income statement (revenue and expense) tracking Does not have a hierarchy structureDetermined by departmentSlide25

ActivityMost HSC reports can be run based on activityDepartments can use Activity codes to simplify reportingProvides grouping options for reportingSlide26

Eprint-Activity Codes ReportSlide27

Hyperion ReportingSlide28

Activity ReportingSlide29

Account Type

Level 1

Level 2

Account Code: Level 1 Level 2Level 3

Level 4Account Hierarchy

Line Item Detail

SRECNA/Notes/Council Higher Education

(Income Statement & State Reporting)

Statement of Net Assets and SRECNA Det

(Balance Sheet & Income Statement)

Statement of Net Assets and SCF Summary(Balance Sheet & Cash Flow)Operating, Non-OperatingCurrent & Non-CurrentRevenue, Expense, Asset, & Liability

Resident Full Time General 0120Resident Full Time 012 Cash Inflow Operating Activities OARevenues & Intra-University Activity 50Tuition Revenue OA1Operating Revenue 51 Slide30

Account Hierarchy in Banner-FTIACTHSlide31

Account Hierarchy and ReportingSlide32

Eprint-Account Hierarchy ReportSlide33

Account Code Resources Slide34

34Utilizing Index and FOPA Hierarchies in ReportingHyperion

Reporting from Operational Data Store (ODS)

Web basedUser identified parameters Report formatting flexibility (grouping options)

Ability to export data to other formats (xls, txt, pdf)Slide35

35Utilizing Index and FOPA Hierarchies in Reporting

Hyperion Reports

Income Statement

FOH0001 & 2- Operating Ledger Detail & Summary