Full Sail Partners Blog | Matt McCauley

Business analytics has become increasingly important for professional services firms. However, finding a business intelligence (BI) tool that works with Deltek Vision and gives us the analytics we want has been challenging. We need flexibility, customization and ease of use to answer important questions about our firms yet often we find that this type of analysis is not accessible in Vision. Thus, we are faced with the export/import/number crunch process in an external tool like Excel plus countless hours spent doing the calculations over and over. We need a better solution, instant access, and easy updates.

Enter Informer 5

Introducing Informer 5, the BI tool which works with Deltek Vision to make instant analytics readily available. Informer 5 is an integrated customizable interface to Vision data for use in various analytical scenarios. Using the Blackbox Connector, direct integration with Vision is now a reality.

You simply select the data fields you want in your database including standard Vision fields, User Defined Fields, and User Defined Info Centers, and you’ll quickly be able to visually see project metrics, employee measurements, marketing results, and firm forecasting. You’ll be able to answer questions such as:

• How are my projects performing?
• How is that new branch office doing?
• Are my employees billing enough hours?
• How is the firm doing compared to the last three years?

Also, remember those spreadsheets with all that data we built over the past years? Informer 5 can integrate this data with your Vision data. No need to reinvent the wheel, we can use it as a data source. Other data sources? Informer 5 can access those too.

Visualize Your Data with Informer 5

Are you interested in where your work is being done and where the profits are made? Well, Informer 5 also includes geographical presentations including maps. You can easily visualize and determine these specifics with Informer 5. You can even find the numbers behind the pictures. Informer 5 has built in drill down capabilities that can take you directly to the detail data. From Profit Center to Project Manager, Project Manager to Project, and all the way down to line item detail, data can be acquired with Informer 5, and all of this can be gathered from the same graph with no need to run additional reports.

Make Smarter Decisions with Informer 5

On a final note, the Informer 5 package includes set calculations for many of our industry standard metrics. Additional calculations can be added to customize this solution for any firm. Also, firm data can be updated regularly on schedule or updated on demand from Vision. It is up to you. So, with all of these awesome features of Informer 5 and its integration with Vision, isn’t it time for your firm to start making smarter decisions?

Revenue Method B is the most widely used revenue method in Deltek Vision. In fairness, this is Vision’s default method for projects whose charge type is Regular. As a result, most firms use it since it’s easy to deploy and seems to work, or so we think.

How Revenue Method B Works

Revenue Method B works well when we have a time & materials project that is billed frequently. In this scenario, we have a perfect match between revenue and costs and can easily measure project performance. On the other hand, when billings and costs don’t align, measuring interim project performance becomes more challenging. Milestone billings or fixed fee projects are billed on cycles that don’t always coincide with a proper revenue accrual or as the associated costs are incurred on the project. Keep in mind that we are not matching revenues and expenses, and this can lead to unreliable financial results during the project life cycle.

For example, a project has a contract provision that calls for $10,000 to be billed at the end of month two. We complete the work in month one at a cost of $3,000 (10,000 billing rate). The financial reconciliation for this project is:

In month one, the project has no income (no billings) and incurs costs of $3,000. With Revenue Method B, the project incurs a $3,000 gross margin loss.

In month two, when the project is billed, we have the reverse situation; $10,000 Revenue and no cost, which results in a $10,000 Gross Margin profit.

So…did we make money or not?

The Results of Using Revenue Method B

From month to month, it is very difficult to assess the true profitability of the project. Therefore, we must wait until a point where billings and costs align or the project is closed. In this simple example, we can look at the end of month 2 and determine our performance. However, what if this project spans over a year or more? With Revenue Method B, we may never have a point where revenue and costs align to make an informed decision on profitability.

To accurately measure performance, a proper matching of revenue and costs is mandatory. Revenue must be earned as work is completed or as the associated costs are incurred. This is the best accounting practice, and with the impending requirement of FASB 606, will now be part of Generally Accepted Accounting Principles (GAAP).

Clearly, Revenue Method B will not work well when the earnings process does not align with the billing process. For those of us using this method, we are reporting inaccurate results to our stakeholders or making manual adjustments to accommodate for Revenue Method B’s shortcomings. Fortunately, Deltek Vision offers alternatives that will help us properly record revenue and comply with FASB 606.

FASB 606 Implications

In May 2014, FASB 606 was released and will be required by December 2018. FASB 606 will render Revenue Method B obsolete for most projects.

FASB 606 has five elements:

• Identify the contract with the client
• Identify the performance obligations in the contract
• Determine the transaction price
• Allocate the transaction price to each performance obligation
• Recognize Revenue as we satisfy the performance obligations

FASB 606 does not reference billings unless billings specifically follow the earnings process described above. Therefore, to be in compliance with this new requirement, we must abandon Revenue Method B for most of our projects.

Revenue Method B Alternatives in Deltek Vision

Stay tuned for the next chapter…User Defined Revenue Methods. We will look at how we can use Deltek Vision to create Revenue Methods that will comply with FASB 606. In the meantime, click here to learn more about FASB 606. 

Knowing how your AE firm compares to your peers is critical for evaluating the health of your business. Fortunately, regularly monitoring your firm’s performance doesn’t have to be a challenge for Deltek Vision users. In this article, we’ll take a quick look at the background of the AE Clarity study and introduce the Vision Performance Management (VPM) interactive dashboard.

What is the Deltek AE Clarity Study?

Each year, Deltek works in conjunction with the American Counsel of Engineering Companies (ACEC), ACEC Canada and the Society for Marketing Professional Services (SMPS) to gather and benchmark key performance metrics for the AE industry. The study draws from over 250,000 data points provided by 386 US and Canadian AE firms of every shape and size.

As the oldest and longest running study of its kind, Deltek AE Clarity report is the authoritative industry standard and the 37^th annual Deltek AE Clarity Study is out and available for download. This report is a comprehensive summary of performance results for 2015.  Additionally, these results include several key statistics that are easy to calculate and monitor, plus allows you to compare your firm’s performance against your industry peers.

How Can Your AE Firm Use the Results?

Having measurable insight into the key performance metrics of your firm plays a vital role in strategic planning and decision-making. The Clarity report shows a number of measurements, and all are important items to track. However, every firm should track several key measures regularly such as:

• Operating Net Profit on Net Revenue
• Utilization Rate
• Net Labor Multiplier
• Total Payroll Multiplier
• Overhead Rate
• Net Revenue per Employee

Some of these statistics can be calculated in Vision, but they are not encapsulated into one comprehensive report without extracting individual measurements into a summary table like Excel. However, the spreadsheet will need to be a manual update for ultimate presentation to firm stakeholders. Surely, there’s got to be an easier way, right?

Introducing Deltek Vision Performance Management

With Deltek VPM, these statistics incorporate easily into an interactive Vision Dashboard. As a result, executives can simply view these vital statistics on the screen and use built in filters to “slice and dice” the numbers as shown below.

But wait, there’s more! With VPM, you also have interactive graphs to monitor performance. These graphs allow users to transform rows and columns into bars and colors. VPM will also enable users to see performance using visual metrics. In other words, Vision Performance Management is more like Visual Performance Management as demonstrated below.

Start Monitoring Your AE Firm

Staying ahead of the competition requires knowing where your firm matches up in terms of these key performance indicators. Luckily, VPM allows Vision users to see where their firm stands on a regular basis.