Laserfiche WebLink
REQUEST FOR <br />COUNCIL ACTION <br />CITY COUNCIL MEETING DATE: <br />DECEMBER 17, 2019 <br />TITLE: <br />AMEND AGREEMENT WITH QUESTICA <br />INC. TO INCREASE ANNUAL AMOUNT BY <br />$15,000 (TOTAL CONTACT AMOUNT NOT <br />TO EXCEED $136,560) TO INCLUDE <br />OPENBOOK FINANCIAL <br />TRANSPARENCY MODULE <br />{STRATEGIC PLAN NO. 4, 11 <br />/s/Kristine Ridge <br />CITY MANAGER <br />CLERK OF COUNCIL USE ONLY: <br />_••e• W <br />❑ As Recommended <br />❑ As Amended <br />❑ Ordinance on 1s' Reading <br />❑ Ordinance on 2ntl Reading <br />❑ Implementing Resolution <br />❑ Set Public Hearing For <br />Elie]► oil ►1.11111q pi[e] <br />FILE NUMBER <br />RECOMMENDED ACTION <br />Authorize the City Manager to execute an amendment with Questica, Inc. to include OpenBook <br />Financial Transparency Module for an increased annual amount of $15,000, subject to non - <br />substantive changes approved by the City Manager and the City Attorney. The total not -to -exceed <br />annual amount will increase to $45,520, for a new contract amount of $136,560. <br />DISCUSSION <br />On January 16, 2018, the City entered into an agreement with Questica, Inc. ("Questica") for a <br />citywide budget management software system. The Questica budget software was implemented <br />during the Fiscal Year 2019-2020 budget process. The software facilitated a more efficient budget <br />process and successfully integrated with the current financial system. proved successful through <br />increased operational efficiencies, provided real-time changes during the budget process, and <br />successfully integrated with the current financial system. Prior to the Fiscal Year 2020-21 budget <br />process, staff plans to implement the Capital module to help automate the Capital Improvement <br />Program document. <br />In addition to their budget and capital modules, Questica offers a variety of other software modules, <br />including an OpenBook ("OpenBook") Financial Transparency module. The tool includes <br />visualization tools (charts, graphs, and maps) for financial information, including budget -to -actual <br />comparison, budget by department or funding source, revenues by fund, and capital projects. <br />OpenBook also has the ability to be used to visualize non -financial data, such as the number of <br />budgeted positions, business licenses, and permits. Questica will host the data visualization tool, <br />and a link will be created on the City's website to provide access to the public. If the amendment <br />(Exhibit 1) to implement OpenBook (Exhibit 2) is approved by the City Council, staff anticipates the <br />module will be available by February 2020. <br />25C-1 <br />