File #: 2015-474    Version: 1 Name:
Type: Staff Report Status: Passed
File created: 11/17/2015 In control: City Council
On agenda: 12/9/2015 Final action: 12/9/2015
Title: Approval of a Contract with OpenGov for Software to Access to Financial Data
Sponsors: City Manager, Charles McClendon
Attachments: 1. OpenGov Software Agreement_City of Cathedral City CA_111715
Related files: 2015-461

City Council

 

MEETING DATE: 12/9/2015                                                                                                                              

TITLE:

Title

Approval of a Contract with OpenGov for Software to Access to Financial Data

End

 

FROM:                                          

Charlie McClendon, City Manager

 

RECOMMENDATION:                     

Recommendation                     

Staff recommends the City Council approve a contract with OpenGov for software to provide improved access to financial data at an annual cost of $8,550.

Body

 

 

BACKGROUND:

OpenGov software is a web-based platform that will provide financial and non-financial information to both internal and external users. It provides an intuitive, user-friendly interface that allows users to easily access the City's financial and budgetary information. Over 500 governments around the nation have launched the OpenGov platform in an effort to make government finances more transparent, build civic engagement and increase community trust. The software makes it easy for users to see financial and non-financial data in both a graphical/visual format as well as raw numbers, enabling simple analysis of trends over time as well as side by side comparisons.  Council received a presentation on OpenGov on11-16 and directed staff to prepare a contract for approval.

 

 

DISCUSSION:

Staff has found that the City's financial management software, which meets the general ledger and accounting needs of the City is limited in the reports that can be generated and cumbersome for casual users to negotiate. It is difficult for departments to extract data into anything other than simple list-type reports and no graphical or trend analysis is built into the system.  All analysis of the data must be performed by staff, primarily Finance Department staff, which can be very time consuming. In addition, this data is only available to staff that have login access to the system; it is not publicly available in any format except the City's published budget, annual financial reports, and cash disbursement reports.

OpenGov provides for operating departments and Council to access the City's financial data without needing any specialized software knowledge, provides ease of data analysis, and communicates complex budget and financial information in an easy-to-understand way.  It will also allow public access to financial data over the City website as appropriate. 

OpenGov implementation is completed by OpenGov staff in conjunction with Finance staff and can be completed in a relatively short period of time.  The City will then be able to phase in report access to operating departments, City Council, and ultimately, over time, the public, as appropriate.

 

 

FISCAL IMPACT:

The annual cost of the OpenGov system will be $8,550.  Because the agreement will be executed prior to December 15, 2015 the $2,500 initial set up fee will be waived. This is an unbudgeted item, therefore a budget transfer will be required.

 

 

ATTACHMENTS:

OpenGov Standard Software Agreement