{"id":327,"date":"2020-12-21T17:43:09","date_gmt":"2020-12-22T00:43:09","guid":{"rendered":"https:\/\/goodreports.ca\/?p=327"},"modified":"2021-01-31T00:07:29","modified_gmt":"2021-01-31T07:07:29","slug":"asset-employee-training-tracking","status":"publish","type":"post","link":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/","title":{"rendered":"Asset and Employee Performance Tracking at an HVAC Firm"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Home<\/a> >> Case Studies<\/a><\/strong><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
<\/div>\n\t\t\t\t
<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\tAsset and Employee Performance Tracking at an HVAC Firm\t\t\t\t\t<\/h1>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Case
Study<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

The Problem<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t

Every week, a management report showing new and current job progress was manually created by a staff member. This involved copy and pasting data from a construction management system into an Excel template, then rearranging to management’s spec. It was a frustrating repetitive task and often resulted in errors copying and pasting the exported data.<\/p>\n

A second issue was a scattered monthly review process for employee performance and pay raises. Collecting the data from multiple sources and building a coherent report took the better part of the day. In addition, there was no cohesive vacation, time off, or scheduling system for employees; everything was tracked manually, usually on paper.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t

The Business<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n
Mid-Sized HVAC (Heating, Ventilation and A\/C) Construction Company based in Vancouver, BC.<\/div>\n<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t

The Solution<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n
Working with the accounting management team, GoodReports created a custom Excel VBA macro to pull data directly from the specialized dispatching system, Servicom. A process that took three hours a week was now done in three minutes.\u00a0<\/div>\n

\u00a0<\/p>\n

For employee performance tracking, we evaluated several systems and working closely with management, chose BambooHR, a modern online SAAS (software-as-a-service) human resource information system (HRIS) system. GoodReports moved the data from many different sources and guided the data cleanup process.\u00a0<\/div>\n
\u00a0<\/div>\n
With strategic messaging and change management principles, the system was delivered on time and well received by employees. The new system allowed the company to track their employee trainings and company assets, and also became a central hub to organize the company’s important events, contacts and dates.\u00a0<\/div>\n
\u00a0<\/div>\n
The modern interface enabled reports like the employee performance measurement report to be generated in seconds, relieving a lot of frustration and helping the company keep their workers up-to-date on certifications and safety trainings. BambooHR’s built-in email notifications were setup to send employees and HR reminders when trainings and certifications were expiring.<\/div>\n<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Every week, a management report showing new and current job progress was manually created by a staff member. <\/p>\n

This involved copy and pasting data from a construction management system into an Excel template, then rearranging to management\u2019s spec. <\/p>\n

It was a frustrating repetitive task and often resulted in errors copying and pasting the exported data…<\/p>\n","protected":false},"author":1,"featured_media":328,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"yoast_head":"\nAsset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Asset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports\" \/>\n<meta property=\"og:description\" content=\"Every week, a management report showing new and current job progress was manually created by a staff member. This involved copy and pasting data from a construction management system into an Excel template, then rearranging to management\u2019s spec. It was a frustrating repetitive task and often resulted in errors copying and pasting the exported data...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\" \/>\n<meta property=\"og:site_name\" content=\"QuickBooks Custom Reporting | GoodReports\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-22T00:43:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-31T07:07:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"superadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"superadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\"},\"author\":{\"name\":\"superadmin\",\"@id\":\"https:\/\/goodreports.ca\/#\/schema\/person\/8a121821d06c47e6ca78a434d12bb603\"},\"headline\":\"Asset and Employee Performance Tracking at an HVAC Firm\",\"datePublished\":\"2020-12-22T00:43:09+00:00\",\"dateModified\":\"2021-01-31T07:07:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\"},\"wordCount\":323,\"publisher\":{\"@id\":\"https:\/\/goodreports.ca\/#organization\"},\"image\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg\",\"articleSection\":[\"Case Study\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\",\"url\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\",\"name\":\"Asset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports\",\"isPartOf\":{\"@id\":\"https:\/\/goodreports.ca\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg\",\"datePublished\":\"2020-12-22T00:43:09+00:00\",\"dateModified\":\"2021-01-31T07:07:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage\",\"url\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg\",\"contentUrl\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg\",\"width\":640,\"height\":400,\"caption\":\"Sample report image caption\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/goodreports.ca\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Asset and Employee Performance Tracking at an HVAC Firm\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/goodreports.ca\/#website\",\"url\":\"https:\/\/goodreports.ca\/\",\"name\":\"QuickBooks Custom Reporting | GoodReports\",\"description\":\"QuickBooks Custom Reporting\",\"publisher\":{\"@id\":\"https:\/\/goodreports.ca\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/goodreports.ca\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/goodreports.ca\/#organization\",\"name\":\"QuickBooks Custom Reporting | GoodReports\",\"url\":\"https:\/\/goodreports.ca\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/goodreports.ca\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/05\/apple-touch-icon-120x120-1.png\",\"contentUrl\":\"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/05\/apple-touch-icon-120x120-1.png\",\"width\":120,\"height\":120,\"caption\":\"QuickBooks Custom Reporting | GoodReports\"},\"image\":{\"@id\":\"https:\/\/goodreports.ca\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/goodreports.ca\/#\/schema\/person\/8a121821d06c47e6ca78a434d12bb603\",\"name\":\"superadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/goodreports.ca\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/06903407770adb233ddcd8e1872fefad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/06903407770adb233ddcd8e1872fefad?s=96&d=mm&r=g\",\"caption\":\"superadmin\"},\"sameAs\":[\"https:\/\/goodreports.ca\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Asset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/","og_locale":"en_US","og_type":"article","og_title":"Asset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports","og_description":"Every week, a management report showing new and current job progress was manually created by a staff member. This involved copy and pasting data from a construction management system into an Excel template, then rearranging to management\u2019s spec. It was a frustrating repetitive task and often resulted in errors copying and pasting the exported data...","og_url":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/","og_site_name":"QuickBooks Custom Reporting | GoodReports","article_published_time":"2020-12-22T00:43:09+00:00","article_modified_time":"2021-01-31T07:07:29+00:00","og_image":[{"width":640,"height":400,"url":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg","type":"image\/jpeg"}],"author":"superadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"superadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#article","isPartOf":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/"},"author":{"name":"superadmin","@id":"https:\/\/goodreports.ca\/#\/schema\/person\/8a121821d06c47e6ca78a434d12bb603"},"headline":"Asset and Employee Performance Tracking at an HVAC Firm","datePublished":"2020-12-22T00:43:09+00:00","dateModified":"2021-01-31T07:07:29+00:00","mainEntityOfPage":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/"},"wordCount":323,"publisher":{"@id":"https:\/\/goodreports.ca\/#organization"},"image":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage"},"thumbnailUrl":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg","articleSection":["Case Study"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/","url":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/","name":"Asset and Employee Performance Tracking at an HVAC Firm | QuickBooks Custom Reporting | GoodReports","isPartOf":{"@id":"https:\/\/goodreports.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage"},"image":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage"},"thumbnailUrl":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg","datePublished":"2020-12-22T00:43:09+00:00","dateModified":"2021-01-31T07:07:29+00:00","breadcrumb":{"@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#primaryimage","url":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg","contentUrl":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/12\/screenshot-sample.jpg","width":640,"height":400,"caption":"Sample report image caption"},{"@type":"BreadcrumbList","@id":"https:\/\/goodreports.ca\/case-studies\/asset-employee-training-tracking\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/goodreports.ca\/"},{"@type":"ListItem","position":2,"name":"Asset and Employee Performance Tracking at an HVAC Firm"}]},{"@type":"WebSite","@id":"https:\/\/goodreports.ca\/#website","url":"https:\/\/goodreports.ca\/","name":"QuickBooks Custom Reporting | GoodReports","description":"QuickBooks Custom Reporting","publisher":{"@id":"https:\/\/goodreports.ca\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/goodreports.ca\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/goodreports.ca\/#organization","name":"QuickBooks Custom Reporting | GoodReports","url":"https:\/\/goodreports.ca\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/goodreports.ca\/#\/schema\/logo\/image\/","url":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/05\/apple-touch-icon-120x120-1.png","contentUrl":"https:\/\/goodreports.ca\/wp-content\/uploads\/2020\/05\/apple-touch-icon-120x120-1.png","width":120,"height":120,"caption":"QuickBooks Custom Reporting | GoodReports"},"image":{"@id":"https:\/\/goodreports.ca\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/goodreports.ca\/#\/schema\/person\/8a121821d06c47e6ca78a434d12bb603","name":"superadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/goodreports.ca\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/06903407770adb233ddcd8e1872fefad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/06903407770adb233ddcd8e1872fefad?s=96&d=mm&r=g","caption":"superadmin"},"sameAs":["https:\/\/goodreports.ca"]}]}},"_links":{"self":[{"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/posts\/327"}],"collection":[{"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/comments?post=327"}],"version-history":[{"count":0,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/posts\/327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/media\/328"}],"wp:attachment":[{"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/media?parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/categories?post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodreports.ca\/wp-json\/wp\/v2\/tags?post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}