Save Time, Discover More: Operational Reporting in OpenGov

August 27, 2015 – OpenGov


Five Minutes. Ten Minutes. The hardworking Finance Director sits at her computer trying to determine historical pension expenses as a percentage of total operating expenses so she can answer Council’s question. Query the ERP system and import each department’s data into Excel. Twenty Minutes. Find each department’s pensions. Add them up. Thirty-five Minutes. Remove historical data for departments outsourced to the county. Forty Minutes. Create charts, annotate them, and export to Microsoft Word. Sixty Minutes. Double check and send to Council. Seventy Minutes. Sound familiar?

Public administrators across the country spend countless hours piecing together data. Historically, government financial information has been siloed and locked away in legacy enterprise systems that are difficult to learn and to access. Working hand-in-hand with our customers, our engineers and our experts, we have developed a solution that changes this. See how our customers leverage real-time Operational Reporting in OpenGov to expedite report generation and glean new insights that inform policy decisions.

Employ Current Year Capabilities With OpenGov
Officials in cities ranging from St. Petersburg, FL to Tyler, TX to Orange County, CA use the Current Year report to deliver real-time year-to-date (YTD) operational insights to department heads and other decision makers on a monthly or quarterly basis. Some applications of Current Year reporting include:

  • Compare monthly budgeted vs. actual expenses across Departments. Instantly recognize escalating costs.
  • Evaluate YTD revenues/expenses against previous years. Immediately determine whether a Department is self-sustaining.

Explore the Employee Compensation Report
Building the Employee Compensation report in OpenGov affords new insights into payroll data. By uploading actual pay registers to internal OpenGov reports, cities such as McKinney, TX, Sausalito, CA and Red River, NM visualize multiple dimensions of their payroll, such as Pay Codes (Normal Pay, FLSA Overtime, FMLA Leave, Sick Leave Paid, Special Pay, etc.), Employer Paid Benefits and Deductions. Analyzing employee compensation in OpenGov enables decision makers to:

  • Visualize individual pay history over multiple years to learn who in the organization is paid the most.
  • Discover year-over-year (YoY) payroll trends across Departments. Understand where overtime dollars are spent.

Infuse the Checkbook with Intelligence
Answering questions such as “How much money did we spend with AT&T in 2012?” or “Have we processed a check for the electrician’s services?” is a daunting task. Cities across the U.S. like Bainbridge Island, WA, Huber Heights, OH and Milton, GA bring their check registers to life with the OpenGov Checkbook report and answer questions in seconds that would otherwise take hours. Some applications of Checkbook include:

  • Review and share specific payments with Department Heads and Council. Drill into the details.
  • Save time. Aggregate, visualize, and analyze payments by Vendor, Department, Object, Date to compare program spending and uncover trends.

At OpenGov, we engage the best minds in government, technology, and finance to create 21st century tools for efficient governance. In addition to building trust with the community through better transparency, our world-class data visualization technology enables internal stakeholders to inform key management decisions in real-time.

From Council’s question, to OpenGov, to discovery. Thirty Seconds.

Get Started with Operational Reporting

Are you an existing customer? Please contact your Account Manager to get started.

New to OpenGov? Simply complete a Demo Request and we’ll walk you through what OpenGov can do for your agency.

Category: OpenGov Updates