1 / 61

Spring Campus Forum May 2007

Spring Campus Forum May 2007. Presented by the Office of University Controller Procurement Service Center. Agenda. Initiatives Expenditure Control Phase 2 New Expense System Overview Systems Finance System Updates Reporting System Enhancements Policies and Procedures

lave
Download Presentation

Spring Campus Forum May 2007

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spring Campus ForumMay 2007 Presented by the Office of University Controller Procurement Service Center

  2. Agenda • Initiatives • Expenditure Control Phase 2 • New Expense System Overview • Systems • Finance System Updates • Reporting System Enhancements • Policies and Procedures • including Personal Technology and Telecommunications (PTT)

  3. Expenditure Control Phase 2 • Overview • Funds • Decisions • Deadlines • Resources

  4. Expenditure Control Overview • Comprehensive approach to promoting sound fiscal management by addressing the problem of deficit spending • Implemented at the direction of President Brown • Phase 1 (Funds 26, 72, 78, 80) went live in January • Phase 2 (Funds 10, 34) go live in October

  5. Expenditure Control Phase 2 Decisions • Taking place now • Collaborative effort between respective campus finance office and departments • Determine Attributes • Expenditure Control Rule • Available Resource Basis

  6. Expenditure Control Rule (ECR) • Tells the Finance System how to aggregate information • Org,* Program/Project, or SpeedType (Subclass) • All Expenses or Expenses by Budget Pool * Expenditure Control at Org level must be approved by campus controller

  7. ECR Attributes • Attached to the Program/Project • PA Budget by Program/Project, All Exp • DA Budget by Org, All Expenses • DB Budget by Org, Budget Pool • PB Budget by Program/Project, Budget Pool • SA Budget by SpeedType (Subclass), All Exp • SB Budget by SpeedType (Subclass), Budget Pool • ECR is an attribute on the Program/Project ChartField

  8. ECR Screenshot

  9. ECR Fund 10 Choices • PA • Budget by Program/Project, All Exp • P = Program • A = All Expenses • DA • Budget by Org, All Expenses • D = Department (Org) • A = All Expenses • Requires approval by campus controller

  10. ECR Fund 34 Rule • PA • Budget by Program/Project, All Exp • P = Program • A = All Expenses Note: There is no choice here due to the nature of gift funds being driven by donor restrictions.

  11. Available Resource Basis (ARB) • Tells Finance System whether the SpeedType will use Budget or Net Assets to determine available resources • BL Budget (BL = Budget Ledgers) • Sum of all four budget ledgers • NA Net Assets • Prior Year Rollforward + Current Year Revenues • For linked Fund 34 ST, NA will include CUF Available Amount (cash balances only which will be updated nightly) • Available Resource Basis is an attribute on the SpeedType ChartField

  12. ARB Screen Shot

  13. ARB Funds 10 and Fund 34 Rules • Fund 10 will generally be BL (Budget) • Departments can discuss NA with Finance Office • Fund 34 will always be NA (Net Assets) • Except for Fundraising Special Events which will be BL (Budget) • Based upon approved budget for the event

  14. Expenditure Control Deadlines • May 1, 2007 • OUC will upload provided Fund 34 attributes • July 2007 • Control will be turned off in Phase 1 funds (26, 72, 78 and 80) • August 1, 2007 • Campus Finance Office to provide Fund 10 attributes • OUC will upload by August 20 • August 6, 2007 • Control for Phase 1 funds will be turned back on • October 8, 2007 • Phase 2 goes live (i.e., control will be turned on)

  15. Expenditure Control Resources • Expenditure Control Initiatives Page • https://www.cusys.edu/controller/Expenditure_Control.html • Finance Procedural Statement (FPS) • Articulates key concepts, processes, responsibilities, appropriate actions • Monitoring pages in the Finance System • https://www.cu.edu/controller/documents/SBS-Available_Resource_Page.pdf • Targeted Phase 2 training in September

  16. CU Expense System • What • Why • How • Benefits • Implementation process • Other Considerations

  17. CU Expense System What is the CU Expense System? • 100% hosted web-based system, accessed through web browsers, provided by Concur Technologies • Capture all expense (PV, Procurement Card, TV) transactions in one place • Automate processes to assist departments in complying with University policy and procedures • Automate the review process within the Procurement Service Center (PSC) • Add consistency and transparency to University transactions

  18. CU Expense System Why does CU need another new system? • CU must shore up all areas of compliance, including the review and approval of accounting and procurement transactions • Procurement Service Center must assist in compliance efforts related to procurement and payable transactions • A system was deemed to be more cost effective than: • Add compliance aspects without adding staff • Add compliance aspects and additional staff

  19. CU Expense System How will this system be used at CU? • Procurement Card Allocations • Replaces the ACARD system • Travel Authorization and Reimbursement • Replaces the TAP system • Replaces the Travel Voucher form • Payment to Employees and non-PO/SPO Vendors • Replaces the Payment Voucher form (at least most usages)

  20. CU Expense System What are some of the benefits of the Expense System? • Web based hosted software - no software needed • May be used with all University supported browsers • Internet Explorer 6.0 & 7.0 • Safari 1.2.3 and 2.0 • Mozilla 1.7.8 • No need to send documents through campus mail to approvers or the PSC … it will all be done electronically

  21. CU Expense System What are some of the benefits of the Expense System? • Scanned images using your fax machine will replace hard copy original receipts • Online tracking of an expense report • Electronic routing -- once the report is submitted it goes to an approver, possibly to sponsored programs or another approver, and then to the PSC • Progress is tracked via an online status page • All activity is time/date stamped

  22. CU Expense System What are some benefits of the Expense System? • the Expense System will assist users in understanding university policies and procedures (and in overall compliance) through the use of pop-up forms and built in business rules • Red flags will stop further processing until they are cleared • Yellow flags represent deviations from policy that can be approved within the approval hierarchy • When a transaction is not approved, an explanation why will be required • All of this activity is tracked so users know the status of a expense report at any time

  23. CU Expense System What are some of the benefits of the Expense System? • PSC still needs to perform pre-audit of TV and PV documentation • System rules will allow pre-audits to focus on non-enforced rules • PSC continue review of Procurement Card documentation on a post audit basis • Departments will not have to send documentation to the procurement card compliance staff as it will be available online

  24. CU Expense System What are some of the benefits of the Expense System? • Frequently used information such as vendors (employees), SpeedTypes, account numbers, etc. readily available • Credit card charges (travel card, event card and procurement card) pre-populated • It will NOT pre-populate from personal credit cards • Sends e-mails to employees and approvers as expense reports are electronically routed

  25. CU Expense System What are some of the benefits of the Expense System? • Interface and single sign on through the CU portals as well as on the University’s system page • You can pop-out to non related websites without losing data • Security ensured through SAS 70, ISO certification and PCI standards

  26. CU Expense System Where are we in the implementation process? • The contract has been signed • Concur is putting together a team to help us with configuration • After the system is configured, there will be several weeks of testing • First implementation to pilot groups of departments • August through December 2007 • Full implementation in January/February 2008

  27. CU Expense System What is involved in the implementation? • Configure University specific business rules • Official Functions • CONUS Per Diem tables • 80% rule is like a dinosaur … will be extinct upon system implementation • Personal technology policy • Alcohol policy and forms • Scope of Work

  28. CU Expense System What is involved in the implementation? • Test interface with the finance system • ChartFields (Speedtypes, FOPPS, Accounts) • Vendors • Voucher information • Payment information • Test that pop-up forms work as planned • Test that auto-fill capabilities • Credit card pre-population

  29. CU Expense System What is involved in the implementation? • Implement pilot groups beginning with: • System offices • UCDHSC College of Liberal Arts and Sciences • Currently confirming other pilot departments • University policies (business rules) may be tweaked but no major changes planned • Except travel meal receipt rule • Goal is to enforce 80% of the current rules via the Expense System, leaving the remaining 20% under manual control

  30. CU Expense System What are the other considerations? • No customization of the system • We can configure it but we can not customize it • Some business process will change • Reallocation of Procurement card charges must be done timely • All employees must log on to submit and approve reports • E-mails to inform appropriate staff of reports awaiting approvals and transactions that have been downloaded

  31. CU Expense System What are the other considerations? • Training on the System • Online training and workshops • No formalized classroom training unless determined to be necessary during the pilot phase • Department experts and the Finance/Procurement Help Desk will be available for questions

  32. CU Expense System What are the other considerations? • New Project Website https://www.cusys.edu/controller/documents/Exp_Reporting_Sys_Announce.doc

  33. Reporting System • What’s New • What’s Next • Resources

  34. Reporting System What’s New? • New Report Header • Report Output Selector • No Data Available Message • Date Range Selector on the R&E Detail

  35. New Report Header

  36. Report Output Selector

  37. No Data Available Message

  38. Date Range Selector on the R&E Detail

  39. Date Range Selector on the R&E Detail

  40. Reporting System What’s Coming Next? • Bottom Line on R&E Summary • Financial Summary Report • Simple SpeedType Query • Batch Report Printing • R&E Detail Report w/ Bottom Line • Fiscal Certification • Break By Reports

  41. Bottom Line on R&E SummaryFund 10

  42. NET ASSETS ENDING Bottom Line on R&E Summary2x Funds

  43. Bottom Line on R&E SummaryFund 34

  44. Financial Summary Report

  45. Simple Speed Type Query • Who can use it? • Anyone with access to the CU Connect or myCU portals. • Where can I find it? • On the Tools channel in your CU Connect or myCU portals. • What does it tell me? • The amount available to spend for a selected SpeedType as of the business day before • Will also show details by account that impacted the SpeedType • How does it work?

  46. Simple Speed Type Query

  47. Simple Speed Type Query

  48. Reporting System Resources • Reporting System Step by Steps https://www.cusys.edu/controller/reportguides.html • Reporting Project Updates http://www.cu.edu/controller/reportingproject/ • Report Conversion List https://www.cu.edu/controller/reportingproject/downloads/Conversion%20Report%20Plan.xls • Send Feedback to reportingproject@cusys.edu

  49. Finance System Enhancements • Finance (General Ledger) • Fiscal Role Inquiry Page • Expenditure Control Attribute Inquiry • Procurement • SPO Funding Changes • PO/SPO Emails to Requestors • Technology Request Pages

  50. Fiscal Roles Inquiry Page • What is it? • On these pages you can lookup fiscal roles by either name, EmplID or position number • Where is it located? • General Ledger -> Chartfields -> Department Table Inquiry

More Related