Exploring OpenGov Reporting 4 of 5: Employee Compensation

September 24, 2015 – Brandon Camhi


OpenGov’s tabular reporting capabilities allow users to visualize Employee Compensation data — delivering important insights into your payroll information. 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. OpenGov’s enables public administrators 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, and use OpenGov to determine where overtime dollars are spent.

Many OpenGov users view their employee compensation by department. The image below shows the breakdown for one of our customers:


Users can explore the data in a wide range of ways. For example, the customer depicted above spends the most on police. Clicking on the police department displays information on the allocation of police payroll costs amongst different payment types:


OpenGov’s reporting tools also break down pay by position within departments. This image shows police payments by position for the same customer:


Join OpenGov on October 7th at 1:30 EST/10:30 PST to learn how to visualize employee compensation and see other features of OpenGov Intelligence!

Sign up for the October 7 Webinar

Category: Government Finance