In the News

At the beginning of 2019, Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) jointly implemented the Accounting Standards Codification (ASC) 606, Revenue from Contracts with Customers. Essentially, ASC 606 now requires forms to recognize revenue from contracts with customers when goods or services are transferred. For professional services firms that use their expertise to sell their time, this has a significant impact on how firms recognize revenue.

About FASB ASC 606

With the new guidelines in ASC 606, firms must recognize revenue in their income statement during the period in which the revenue is earned and not when it is billed. Since professional services firms manage projects that can span across multiple periods, they might not bill until the project is complete. As a result, firms must use a form of percent complete for the project to determine how much revenue to state on their income statement for that period. For example, if during a specific period a firm completes 25% of the project, they must recognize 25% of the revenue that will be earned from the contract for that period.

There are three distinct ways to calculate percent complete:

1. Billing Percent Complete
2. Financial Percent Complete
3. Physical Percent Complete

Billing Percent Complete

Using billing percent complete is the most common method. Typically, this is driven by the project manager during the invoicing process. There are two options:

• Overall percent applied to the total contract value
• Percent complete by phase used to invoice based on the various components of scope/deliverables and these phases are broken down using either internal or external contract value

For many firms, this also drives revenue or earnings. Furthermore, it is recommended for people to review the current FASB 606 regulations. This will explain why earning what you invoiced may not be an acceptable solution any longer.

Financial Percent Complete

Another common technique is the financial percent complete. The formula for this method is job to date/job to date + estimate to complete. This indicates how much of the total estimate at completion has been spent or burned. When applied to the contract value, we can calculate revenue. Deltek Vision can facilitate this calculation using Resource Planning.

Physical Percent Complete

Lastly, physical percent complete can be utilized. This is usually calculated when the user or project manager has entered and can provide the following:

• Compared to financial percent complete, indicated whether the project’s progress is tracking with the financial burn
• When begin to drive earned value
• Have control earnings based upon contractual stipulations such as deliverables which can accelerate or slow down earnings and at the same time drive Work in Process (WIP) in tandem but that is separate from invoicing

Which Form is Right for Your Firm?

Let’s do some homework. Using a project your firm is executing, calculate/stipulate all three forms of percent complete and compare them. Then write a business case elaborating on the project’s health from these three statistics. You might surprise yourself with the results.  

Mergers and acquisitions (M&A) in the architectural and engineering (A&E) industry are on the rise. Unfortunately, many firms are not prepared to successfully implement the M&A process. With an acquisition, it is imperative that the “buying” entity have a well-defined set of procedures to easily onboard the incoming firm. In the case of a merger, all involved firms would need a set plan which would dictate the transition to a new firm. However, first a firm must decide the direction it will take regarding the M&A process and evaluate how it will affect the current organization’s structure.

Navigating Forks in the Road for Your Firm 

There are many reasons a firm may decide to begin the M&A process. Each firm has its own vision for the future. On this path, there are 3 “forks in the road,” and a firm must choose one:

1. Absorbing the acquisition into an existing organization
2. Creating a new organization within an existing company
3. Creating a new company 

Making the Acquired Company Part of the Buying Company

Absorbing the acquisition into an existing organization is the easiest and most straight forward. This scenario is usually the result of a simple employee purchase. For example, a design engineering firm acquires a mechanical engineering firm. In this case, the incoming engineers are integrated into an existing profit center (department). They may have brought projects with them or are going to be staffed on existing projects. Since it requires no structural changes to the database, very little of any testing is needed. The focus would be more human resources related blending the culture of the acquired firm into the existing one. 

Making a New Organization within the Buying Company 

Creating a new organization within an existing company is most often the result of expanding service offerings. For example, a base building architectural firm acquires an interiors firm. If the firm’s current structure is studio based, a new studio would be required for the interior work. Under this scenario, a change to the existing structure is made that will require testing. This will include: 

• Cross Charging
• Overhead Allocation
• T&E group management 

In addition, reporting parameters need to be updated to ensure the new organization is included in all metrics and indicators. This will require reasonable lead time to do a test and final cutover. 

Making a New Company Altogether

Creating a new company by merging firms is the most common scenario, and regardless of the dynamics, is often driven by numerous outside factors such as: 

• Tax implications
• Buyout and payout provisions
• Currency requirements
• Country, state, and other municipal requirements
• Banking relationships
• Investment and or holding company requirements
• Professional licensing requirements 

In a merger situation, a change to the existing structure is made that will require testing. This will include: 

• Intercompany Billing
• Foreign currency management
• Consolidated reporting (in addition to the reporting parameter updates noted above) 

Additional factors that will need to be considered in risk mitigation are: 

• Rules defining internal pricing
• New currency being introduced into the environment 

This situation will require at least one test cutover and lead time needs to be considered during the process. 

Final Considerations for Mergers and Acquisitions   

Once you have selected which of the forks on the M&A road to take, the real work begins. Beyond the integration testing noted above, there are two other risk areas that must be considered. 

1. Data import
2. Revenue management 

Regardless of which direction your firm chooses to take in the M&A process, Full Sail Partners can offer consulting from subject matter experts. Contact us and we will be happy to help. You don’t have to walk alone. Additionally, we will be at the 2018 Southeast States M&A Symposium in Miami, Florida on January 24th and 25th. 

With the New Year approaching, it is a fitting time for accountants and project managers to review the previous year and identify areas of improvement. While we usually think of New Year’s resolutions for our personal lives, there can also be professional ones. Let’s take a look at some of them.

New Year's Resolution for Accountants

For accountants, it’s all about preparing for next year and making changes that streamline and automate processes. Here are the top five resolutions for accountants:

1. Examine the current revenue/earning methods and determine if the firm is in compliance with FASB 606
2. Take a hard look at the organizational structure to determine if changes need to be made
3. Clean-up the firm’s chart of accounts and overhead projects
4. Define the differences between a project administrator and a project controls role
5. Try to learn more about challenges the accounting team experiences and create solutions

New Year’s Resolutions for Project Managers

Project managers must consider how to evaluate the success of projects and how to better manage them. Here are the top five resolutions for project managers:

1. Use the tools within the project management system to better budget and plan projects
2. Elevate the level of project review beyond invoicing to earned value
3. Better record and manage change orders
4. Build a work breakdown structure based on fee and scope
5. Encourage the team and peers to be timely in submitting time and expense

Start 2018 Off Right!

The New Year brings fresh opportunity to improve a firm’s operations and efficiency. Accountants and project managers must first take time to determine what areas need adjustment or refinement. Full Sail Partners can help! Let us conduct a Navigational Analysis to pinpoint those areas and start 2018 off right. 

The following account is a true story. It begins with an AE firm recognizing the need for change in order to support its growth. This firm quickly realized that bringing disparate systems to one integrated platform like Deltek Vision was the fix they needed.

Here’s the firm’s story…

Identifying the Need for Change

Initially to manage its business, this firm was using several different systems that communicated poorly. Specifically, each critical function for the firm used a separate system which had its own unique database:

• Accounts Receivable – MS Access database
• Accounts Payable – MS Access and an outdated accounting program
• Project Management – Internally developed and managed databases, spreadsheets, and online systems
• Reporting – Internally developed and supported 

Desiring the ability to make better and faster decisions, the firm opted to move to a single enterprise-wide and industry-proven software platform. The move would allow this firm to streamline operations and reduce overhead time/costs by eliminating duplicate efforts and manual operations. The software of choice for this firm was Deltek Vision. 

Implementing Deltek Vision 

The implementation began with the drafting of processes using the project life cycle as a template. It was built to engage project managers earlier and more often throughout the entire process. Additionally, the firm recognized the need to ensure a budget could be developed using Resource Planning (RP). 

Having a budget became a requirement before a project could be initiated. As a result, the contract compensation was directly tied to the budget making routine maintenance integral to the project’s life. Furthermore, time charging, invoicing, and revenue recognition were not allowed without a project budget. 

The firm also sought to embrace the automation capabilities of Deltek Vision. Automation, of course, enabled the streamlining of processes. As an example, they decided to utilize invoice review automation to allow accounting to work in tandem with operations to deliver financial results. 

Most importantly, the philosophy around reporting changed dramatically. The firm now wanted to standardize reporting practices. Originally, employees had created and used their own desired data and had determined not only individual key performance indicators, but how and what those measurements were based upon.  

The Result of Choosing Deltek Vision 

I began working with this firm three years ago, and there is so much success to share: 

• Reduction of invoicing time
• Faster and more reliable monthly closes
• More and better insight into project performance based on standardized reports 

These are just a few of the identified areas where using Deltek Vision has improved this firm’s performance. In the end, using Deltek Vision, the firm has seen its overall financial performance improve. 

Advice for Implementing Deltek Vision 

Here are some tips to help ensure successful Vision implementations:

• Engage and work closely with a Deltek consulting partner like Full Sail Partners
• Plan, design and configure based on your firm’s unique requirements
• Testing, testing and more testing - both transactional and end to end
• Make necessary changes and continue testing
• Prepare for go live including preparing your staff with training  

There has been an uptick in interest recently from C-Level financial leaders to become more involved with the CRM functions within Vision. You may ask yourself why this new trend is occurring since the CRM module of Vision is for marketing and business development functions. The reason must surely be based on an informational need so that actionable decisions can be made.

CRM Information for Financial Leaders 

CRM databases are full of information to help the marketing and business development team drive new business. So, what information can provide financial leaders the insight they need to make better decisions?  

1. The Life Cycle of Projects – More often than not, a project is born during the opportunity stage. More specifically, the opportunity can trigger a promotional project and/or a resource plan. As a result, there are financial considerations that must be taken into account: 

• The numbering of both the promo project and the plan
• Determining when the pursuit trigger will need to include resources in the staffing heat map
• Figuring out the rate tables and a multiplier that are going to be used in the plan 

2. Pipeline and Backlog – A conversation that often occurs between a CFO and director of business development is about the movement of future revenue from the pipeline to soft backlog to hard backlog. This can result in some level of double counting and is especially prevalent in task ordering agreements or infinite deliver/infinite quantity (IDIQ’s). C-Level financial people need to be involved in the definition stage of how future revenue is separated and quantified.
3. Cost of Winning and Losing Work – Opportunities afford us the ability to track hit rates. These are metrics showing win/loss ratios and can be filtered by unique attributes that are meaningful to your organization. One suggested attribute to track separately is sole source versus competitive wins. From this metric, financial managers can begin to quantify and measure the effort that goes into these wins and losses. However, this requires creating a promo project once the decision is made to bid on an opportunity.
4. Utilization – Having the fluidity to evaluate time spent on a proposal is a value add. Moreover, C-Level financial types are also aware of utilization. By moving time from a promo project to a regular type project, the time moves from non-productive to productive. When we use Vision functionality to isolate proposal time on utilization reports, it provides insight into why employees are not being productive. 

Sharing Information Firm Wide

It’s always best practice to share important firm data with key individuals from all teams, but those people should also be able to find the information on their own. Like this new trend for financial leaders to learn more about using the CRM module in Vision, marketing and business development people also need to know how to access information from the financial side of Vision. Most importantly, everyone should be involved in the implementation of all Vision modules to ensure the initial setup, data structure and reports are valuable to the firm.

A KPI, or Key Performance Indicator, is a measurable value that demonstrates how effectively a company is achieving crucial business objectives. Organizations should use KPIs to evaluate their success at reaching targeted goals. Simply stated, KPIs provide your firm with metrics that compare budgeted amounts to the actual values. KPIs are no longer just for accounting and finance as they now reach deeper into a firm’s operational side examining marketing, business development and project management.

KPIs vs Traditional Reporting Methods 

Let’s take a look at how firms benefit from KPIs and how KPIs differ from standard reporting. A common reporting technique is to compare current profit & loss results to the same period the previous year, or to compare year to date then versus year to date for the current year. Budget data for one or both comparisons can be incorporated. Now, what if we graphed this information and included a desired growth line? We will then have a visual of actual performance in relation to a chosen measurement. This measurement will inherently become an indication of whether we are achieving our goals, and would allow us to be proactive in correcting potential challenges. 

Using KPIs to Measure Success 

As mentioned earlier, KPIs are not just a tool for the finance team. For example, a chief operating officer may not relate well to traditional financial statements and focusing on project related metrics would be more to his liking. These indicators can be project specific, relate to a grouping of projects, or be sliced and diced based on the organizational breakdown structure (OBS) or work breakdown structure (WBS). Click here to learn more about OBS and WBS.

In another scenario, a chief strategy officer believes there is a benefit from evaluating trending data regarding hit rates filtered by a predetermined criterion. However, we must keep in mind that unless a benchmark or some other distinguished metric is established, this may not result in a clear and meaningful measurement. 

Here are two examples of KPIs that have proven to be successful: 

1. Cost and Schedule Variance – Using Deltek Vision reporting, actual project cost performance index (CPI) and schedule performance index (SPI) is calculated and compared to an acceptable mean-variance.
2. Estimate at Completion (EAC) Analysis – This can be as simple as a two-column report showing EAC in comparison to the contract value. The criteria can also be set by contract type to “flag” anomalies that need to be further investigated. 

The Bottom-line on KPIs 

KPIs can be used company wide. C-level executives can look across client and project types and evaluate revenue multipliers or collections success. These same evaluations can be done at all levels across your enterprise from managers that are accountable for sections of your organization down to individual project managers driving the lowest levels of WBS. What is required is a benchmark, a budget or a goal. Whether top down or bottom up, the view into why businesses perform the way they do will kept top of mind.

So, how does your firm measure success across the enterprise? Is it profit centers, projects, employees or pursuits? Every firm is unique and can’t just use “off the shelf” KPIs. It all begins with a discussion of what you need to drive your firm to the finish line. Once decided, designing the reports and data is easy.

Within Deltek Vision lies a very handy tool, which enables a firm to have multi-company functionality. However, the benefits of this multi-company functionality feature seem to elude many firms that would greatly appreciate its capabilities. So let’s talk in detail about multi-company functionality and the why, when and how firms should use this fantastic feature.

Intro into Deltek Vision Multi-Company

Basically the need for a multi-company environment comes down to having to track a separate entity with its own tax id number in a single Deltek Vision database. Some of the scenarios that require multi-company management include:

• Banking relationships
• Investments and/or holding company requirements
• Tax reporting
• Professional licensing requirements
• Foreign country reporting requirements

Additionally, the need for intercompany billing can occur when two or more related companies make payments on behalf of the others. The most common reason for intercompany billing is the sharing of labor resources between companies that have separate payrolls and/or making vendor payments for another related company.

When a firm decides to utilize multi-company functionality, it is recommended that sub-ledgers be set up to track the due to and from, and clear intercompany balances. This creates the ability to use both the AP and AR aging reports for the intercompany balances.

Determine Internal Pricing Structure

Upon implementing multi-company functionality in Deltek Vision, firms must determine what internal pricing structure to adopt. The options are:

• Re-class only - moves the transaction to intercompany AR/AP at cost
• Project Centric - leaves the transaction on the books of the project’s company with some amount of compensation also moving to keep the loaning organization whole
• Employee Centric - moves the transaction back to the employee’s company with some amount of revenue moving back as well
• High Accountability – which uses work breakdown structure to manage transactions and point directly to the company who owns the transaction

Keep in mind, there is a lot of flexibility within the options above. Different scenarios can be created for different transaction types. Also, by order of operation, the various options can be overwritten at the individual company level or at the lowest work breakdown structure level by project.

Intercompany billing makes accounting’s job easier in regard to multi-company transactions. When transactions are made to projects not in the home company (company where the transaction is being posted), invoices and vouchers are created through a series of postings that are reflected in GLs of the respective companies. These invoices and vouchers also appear on the AR and AP aging reports noted above. Accounting can then clear the reports using standard check processing and cash receipts.

More Benefits of Multi-Company

Using Deltek Vision’s multi-company functionality provides another benefit to firms with consolidated reporting. Consolidated reporting allows a view of the performance of all the companies within the database. Consolidated groupings can represent all companies or a cross section of companies depending on the needs of company leadership. The consolidation process incorporates standard eliminations of configured control accounts as well as client-defined accounts, such as capital investments in related companies. Consolidations are “memo” entries and not posted to the GL.

A multi-company database permits each company to maintain a unique GL while still only creating one set of shared GL account numbers. Furthermore, firms can restrict GL account numbers, and other master records can be shared and/or restricted as well. Also, Vendors can be shared. However, the accounting tab is company specific for account and 1099 purposes.

In addition to the benefits mentioned above, the multi-currency function works in tandem with multi-company to allow firms to have unique GL/functional currency. This is a great feature for firms that work internationally. Lastly, the consolidation process can include GAAP compliant currency translation and a gains/losses entry.

Final Thoughts on Deltek Vision Multi-Company

Firms of all sizes can benefit in many ways by using the multi-company functionality that is part of the core capabilities in Deltek Vision. Being aware of when, why and how to use a multi-company database will help your firm make important business decisions and operate efficiently. For more information, contact Full Sail Partners here.

For project-based firms, timesheets are essential to ensure that an employee’s time is reflected to a specific project. I’m sure you already knew this, but do you manage timesheets correctly in Deltek Vision? Here are some facts and best practices for different scenarios to help you better manage timesheets in Deltek Vision.

Intro to Timesheets in Deltek Vision

Hopefully, one of the first things your Deltek Vision Consultant explained to you about timekeeping is that timesheets create payroll cost not payroll. As a “nuts and bolts” accountant, at least one side of our brain struggles with processing this information. So let’s break it down: 

1. The employee’s job cost rate on the accounting tab of their info center should represent their rate of pay. If they are true hourly, this is quite easy to determine. On the other hand, if they are salaried the hourly rate should reflect their annual salary divided by 2080 hours.
2. If adjusted salary job costing is used, the amount should reflect their salary based on the configured interval. For example, weekly, biweekly or a set number of days.

How Timesheets Work

When a timesheet is posted an amount based on the hourly rate multiplied by the hours charged is applied to the selected projects. Thereby creating direct or indirect (overhead) labor/payroll cost in the General Ledger. The credit created by the timesheet can go to either one of two places: 

1. The Income Statement as job cost or payroll variance - This account is an overhead line item used to adjust the total of the timesheet posting to the actual payroll distributed. Furthermore, amounts that remain in this account after the payroll journal entry has been entered reflect a net of uncompensated overtime (OT) for salary staff (negative amounts), and based on this process, the premium portion of OT for hourly staff (positive amounts).
2. The Balance Sheet as a payroll liability - After the payroll journal entry has been entered, the remaining amount needs to be reclassified to the Income Statement as stated above.

Accounting Tip for Paid Time Off

Have you ever noticed your Paid Time Off (PTO) balance not being relieved even during peak vacation periods? You might want to consider booking PTO taken to the Balance Sheet. To do this, you need to configure timesheet postings for PTO to go to a PTO liability account. Then when time off is taken and posted, the debit entry reduces the liability. Based on a true computed liability, an entry can be made on a pre-determined interval to accrue additional PTO and book the expense. If you are using benefit accruals in Vision, the entry can be taken from that report.

Handling Leave without Pay

Many firms fail to account for leave without pay (LWOP) properly. Sure, there is a need to track hours for statutory purposes when employees are on leave, however, no payroll cost should be recorded. The simple fix is to enable cost rate tables and attach one to LWOP projects. The table should contain either a labor code(s) or a list of employees with a ZERO job cost rate. This will override the employees default job cost rate and avoid any recording of payroll costs.

Punch the Clock

Some of this might seem complicated at first, but these best practices should help keep your books in order. I hope that this has taken the mystery out of Deltek Vision timesheets. Now punch the clock and update your timesheets.

Most firms that I work with utilize independent contractors to supplement their workforce. This isn’t a blog about “walks and talks like an employee, must be an employee.” For that, I recommend a good labor attorney. However, what I am going to clue you in on is about the proper way to track and account for independent contractor’s time in Deltek Vision.

Processing Contractor Time in Deltek Vision

In most situations, the desire is for the contractor to complete a timesheet and submit an invoice for processing by Accounts Payable (AP). There are two prevailing methods within Deltek Vision to process these types of situations:

1. Zero Job Cost Rate

The contractor is set up as an employee, but doesn’t have a job cost rate only a billing rate. When time is posted there is no entry to the General Ledger (GL), but both the Time and Materials (T&M) invoice and project ledger reflect a billing dollar value. As a result, the AP invoice creates the GL entry reflective of the true cost of the contactors time

2. Job Cost Variance

For this option, setup the contractor as an employee with a job cost rate. When the timesheet posts, the cost gets booked to a unique GL code reflective of contract labor. Additionally, this cost can also be included in the base for an overhead calculation. The credit end of the timesheet posting goes to Job Cost Variance similar to all other timesheets. As a result, the AP invoice is booked to an overhead project using the Job Cost Variance Account and thereby clearing it.

That Seems Simple…Right?

This is where the accounting can start to go awry. If method one is used and care isn’t taken to ensure the AP doesn’t also create a bill extension (effort) then the potential for exposure can be:

1. Double counting of effort in project reporting leading to an understatement of profit or positive variance.
2. Double earnings of revenue if the method is associated to effort.

To alleviate these concerns, apply the following workaround in Deltek Vision:

1. Create an expense GL code table under Billing/Billing Rate Tables.
2. Enter the AP GL code used above and attach a “0” multiplier.

By following these steps, the AP billing value will not be included in project reporting and you will not experience the effects of doubling down on your effort.

You know you have spent your whole workweek devoted to a specific project, but you’re only showing 35 hours being billed/charged to the project. Where did the value of those 5 hours go? In many cases, these missing hours can be attributed to non-billable labor, and many AEC firms overlook the importance of documenting how this time is spent. However, accurately accounting for non-billable labor is extremely important to track accurate project performance.

How Can My AEC Firm Track Non-billable Labor?

If your AEC firm utilizes Deltek Vision, then tracking non-billable labor is relatively simple. Before we get started, it is important to make a distinction between the labor we are billing clients and the labor that contributes to the cost of our project. With cost in this case being the “burn” or “retail” value of this labor. Within Vision, users are able to remove the labor from both the invoice and the project ledger in two ways:

1. A non-billable labor code under billing configuration
2. A zero billing rate attached to a person, code or category in the billing tables

Keep in mind that best practice states that the only time we would use either of the above is if the labor is invoiced and costed through a Unit for activities such as surveying or lab testing.

What Are Reasons for Non-billable Labor?

There are several possible scenarios that would warrant not invoicing a client for time charged to a project such as:

1. On-the-job training
2. Rework
3. Discounts

While all of these are valid reasons, the costs associated with this effort should be included in the project sub ledger. This is missed opportunity cost or potential lost revenue. If labor cost is nullified using any of the above, the true performance of the project becomes misstated. When reviewing project financial reports the missing cost is not there to net against revenue thereby creating a false and overstated profit amount.

What Happens to Non-billable Labor?

Ah ha, the Million Dollar question and you won’t even need to phone a friend. There are actually at least two ways to accomplish removing time from an invoice while ensuring it remains as cost for project metric measurement:

1. Write-off the hours/cost in Interactive Billing. This removes it from the invoice, but appears on the billing status in the Project Detail Report. This allows missed opportunity cost to be valued into the overall project profitability or more commonly known as a loss.
2. Allow the labor hours/cost to be included on the invoice. Then using an Add-On, create a discount to remove the amount. This will provide your client with the visibility of the benefit you are providing them. Additionally, it will ultimately be reflected accurately in project reporting since the overall impact is a reduction in revenue.

Following these simple rules will create accurate reporting and prevent any misunderstanding in regards to the projects true performance.