BTerrell Group Blog

Acting on KPIs Benefits Businesses in the Service Industry

Posted by Brian Terrell on Thu, May 08, 2014

The capabilities of software these days are endless, so it comes as no surprise that ERP publishers promote dashboards and “information at your fingertips” to business leaders. I believe recognizing successes and potential problems from the statistics helps me take action toward continuous improvement. The cost of not taking action pales in comparison to understanding and acting on the information you have.

For example, this past year we adjusted pricing after reviewing our historical gross margin and the proforma budget. Understanding and acting on that key information adds purpose and intention to our pricing going forward, which is much better than pricing based on reaction and reflection.

The first step is to determine your company’s specific KPIs. There are great industry standard KPIs for the service industry, such as gross margin and net profit, but many times the company-specific KPIs are even more relevant. At BTerrell Group, I track a mix of industry-specific and company-specific KPIs. I use revenue per loaded labor dollar and conversion ratios for each step of the sales cycle, to help predict future revenue and utilization when applied to the size of the current pipeline.

Once you determine and understand your company’s KPIs, you need a way to see them in real-time, at anytime. Good business intelligence systems enable you to view vital company data instantly and accurately, so it is important to set up and present the data in way that works for you. Sage 300 ERP even allows you to build dashboards based on user roles, so each person can see the metrics that matter most to them!

Below are a two examples using Sage 300 ERP. As you can see, they are very intuitive.

Top 5 Expenses Dashboard Sage 300 ERP

Top 5 Customers resized 600

Tags: Sage 300 ERP, KPI, KPI service industry, service industry, KPIs

KPIs Lead to Improved Performance in the Service Industry

Posted by Keith Karnes on Fri, May 02, 2014

When it comes to staying on top of company performance, industry-specific KPIs such as new projects booked per month and A/R aging as well as company-specific KPIs are imperative for CFOs and Presidents of professional service organizations to know. Unfortunately, the information isn’t always real-time, which makes it ineffective.

I found a great whitepaper recently from Intacct and Service Performance Insight, LLC about KPIs for businesses in the professional service industry, recommending a focus on financial performance for greater financial success. It advises integrating financial management solutions with other departmental solutions for seamless reporting. Reporting is crucial when it comes time to present to key stakeholders, and it is crucial for timely visibility into the performance of the organization.

By narrowing your lens of focus on only those KPIs that are relevant to your role, it will allow you to communicate effectively and make better business decisions. For me, an opportunity would have been missed to improve our company’s utilization and realization if I had not been aware of our metrics in real-time. Now, I am able to tie employee rewards and compensation to metrics to drive improved performance and employee satisfaction.

Here’s an example of what it looks like to track KPIs using Intacct:

Intacct KPI dashboard

In January, CodePartners posted a great blog explaining how to set up a dashboard in Intacct. Once you set up your dashboard, you are on your way to optimal success!

Tags: KPI, KPI service industry, service industry

Sage 300 ERP (Accpac): Purchase History and KPIs Using PowerPivot

Posted by Tony Zhang on Fri, Oct 18, 2013

This blog is a continuation on the Sage 300 ERP business intelligence journey using PowerPivot, and covers Purchase Analysis.

In the following Purchase History example, I created a KPI to compare the purchase unit cost with the number from the previous year.  The unit cost is greater than 105% from the previous year, so it's highlighted in red.  This screenshot shows a number as green if the number is within the target and yellow as a warning you are about to be out of the target.

I track this purchase KPI by vendor, vendor group, vendor payment term, item, item category, item segments, etc., by using this particular data model.  

10 18 1

10 18 2

In the end, I gain insight into the purchasing operations while also producing the same results as I do with the standard Purchase History (please see the following two screen shots).

10 18 3

10 18 4


I hope you found this blog helpful as you continue to understand PowerPivot’s position and the level of professional services we provide here at BTerrell Group. Feel free to view the report in static form to grasp a better view of the look and feel.

Related Content in this Series


Tags: Accpac, Sage 300 ERP, KPI, Purchase history, PowerPivot

Sage Accpac ERP 6.0 Product Roadmap

Posted by Meredith Gooch on Mon, Mar 01, 2010

In an earlier post, we mentioned some of the features included in the newest version of Sage Accpac ERP 5.6 such as:

  • New serialized inventory and lot tracking
  • Improved bank reconciliation
  • Sage Accpac Intelligence
  • Simplified installation and data activation
  • Free training
  • Built-in A/R inquiry tool

On his blog, Stephen Smith, the Chief Architect of the Sage Accpac product, gives us insight into what we may expect in the future from Sage Accpac ERP 6.0. He states that the main goal of version 6.0 is to solve customer requests with Web technology in 3 main areas:

*Usability: Improve Productivity

  • role-based, personalized portal
  • task-oriented navigation
  • contextual user assistance

*Reporting: Faster Information Access

  • integrated dashboards/KPI's
  • ad-hoc inquiry tool - quick information lists

*Integration: Streamline Processes

  • enhanced quote-to-order workflow for SageCRM users
  • elimination of Lanpak requirement for SageCRM users for Order Entry
  • SageCRM 7.0 support

Read More From Stephen Smith's Blog

- Brian Terrell, CPA and Managing Partner

Source: Smith, Stephen. "SageERP Accpac 6.x Product Roadmap." smist08.wordpress.com. February 19, 2010. <http://smist08.wordpress.com>/2010/02/

Tags: Sage Accpac ERP, SageCRM, bank reconciliation, version 6.0, KPI, 5.6, lot tracking, serialized inventory, LanPak, dashboard, inventory, Sage Accpac Intelligence, Stephen Smith