540 likes | 558 Views
A Gentle Introduction to UAccess Planning. Foundations for Adaptive Planning at the UA. Tara Mysak, Analyst – Planning, Consulting and Data Solutions Team. The GBBO. Why “Gentle”?. “I’m never gonna say, ‘I don’t think I can.’ I can and I will.”. Before we get started…. Thank you!.
E N D
A Gentle Introduction to UAccess Planning Foundations for Adaptive Planning at the UA Tara Mysak, Analyst – Planning, Consulting and Data Solutions Team
Why “Gentle”? “I’m never gonna say, ‘I don’t think I can.’ I can and I will.”
Before we get started… Thank you! Brian Berrellez, ALVSCE Data Solutions José Fragoso, Housing and Residential Life Zach Hoffman, Budget and Planning Garth Perry, Budget and Planning Andrew Wang, RDI Business Services Greg Wessels, UITS Project BA Services Cameron Wiles, UITS Student/Academic Tech Catherine Zavala, UITS Training Team
UAccess Planning The Elephant in the Room
Agenda • Signature Bake: Overview of Planning • Focus on Academic and Grants • The Technical: Planning and Analytics • Connecting the two systems • The Showstopper: Two Use Cases • Project Codes Budget to Actuals • Cost Share
Adaptive Insights • Web-based planning tool • Cloud storage • Information is not hidden on individual computers • Generally for business applications • Interested in the Higher Ed market
UAccess Planning Instance:
UAccess Planning Sheets and Reports:
UAccess Planning Sheets:
UAccess Planning Sheets:
Academic vs Grants Levels:
UAccess Planning Versions:
UAccess Planning Reports:
UAccess Planning • Account: UAObject code • Timespan: The official calendar • Dimension: Categories • UA Account, Object Codes, Fund/Sub-Fund • Attributes: Additional categories for dimensions Some other Vocabulary:
UAccess Planning Available support: Getting Access
UAccess Planning Available support: UAccess Forums
UAccess Planning Available support: https://confluence.arizona.edu/display/uaccessplanning
UAccess Planning Available support: Adaptive Resources
UAccess Planning • Academic: Brian Berrellez, bberrell@email.arizona.edu • Grants: Jason von Fange, vonfange@email.arizona.edu Available support: People!
UAccess Planning • Student Affairs: Brian Pierson, pierson1@email.arizona.edu, and Erik Reinold, ereinold@arizona.edu • College of Medicine – Tucson: Rosa Fung, rmfung@email.arizona.edu Available support: People!
Analytics vs Planning • Analytics is : • The auditable system of record • Reconciliation and trending data • Non-Financial information • Looking into the past What should I use and when?
Analytics vs Planning • Planning is: • Focused on financial information • A tool for financial planning • A collaborative workspace • Future focused What should I use and when?
Analytics vs Planning Chart of Accounts in Analytics:
Analytics vs Planning Chart of Accounts in Analytics:
Analytics vs Planning Chart of Accounts in Planning:
Analytics vs Planning Chart of Accounts in Planning:
Analytics vs Planning • Official Budgets are not loaded into Planning: • Grants only has actual expenses • Academic has both actual revenue and expenses • YOU enter the budget at the level of detail YOU need
Analytics vs Planning Current Account Balance Income/Expense Adaptive 136,797 + 1,792,316 =1,929,113
Analytics vs Planning Current Account Balance Income/Expense Adaptive
Analytics vs Planning A couple quick notes: System Encumbrances • They are loaded into both instances from the data warehouse • We didn’t include them in the standard reports • Recommend entering system and soft encumbrances in the Planned versions
Analytics vs Planning A couple quick notes: Cost Share • Cost share transfer object code expenses (7932, 7933, etc.) are not loaded in either instance • They appear under the original object code for the expense
Analytics vs Planning A couple quick notes: Cost Share
Analytics vs Planning A couple few quick notes: Updates • Analytics is updated nightly • Grants is updated nightly • New accounts are added on Monday • Academic is updated on Monday
The Showstopper https://culturess.com/2016/08/31/nadiya-winning-great-british-bake-off/
Ingredients for Good Reports Accurate Complete Clear Have Context Documented Reproducible
Use Case: Academic Budgeting to Project Code:
Use Case: Academic Budgeting to Project Code:
Use Case: Academic Budgeting to Project Code:
Use Case: Academic Budgeting to Project Code:
Use Case: Grants Budgeting Cost Share:
Use Case: Grants Budgeting Cost Share: Project Period Entry Sheet, Budget Original Version
Use Case: Grants Budgeting Cost Share: Budget Entry Sheet, Budget Original Version Enter Cost Share Account #
Use Case: Grants Budgeting Cost Share: