Full Sail Partners Blog | Accounting (7)

Our first inclination when the new FASB 606 was announced was this wouldn’t impact many of our Deltek Vision clients. But after more insight, we recognize this has a tremendous impact on our clients. The rule states applicability to ALL entities that deliver goods or services. Though many believe that GAAP, FASB, SOX and other guidelines are good rules to follow regardless of any statutory relevance, the reality is if we are not being overseen we tend to be somewhat lax in compliance.

On May 2014, FASB issued Accounting Standards Update (ASU) 2014-09, Revenue from Contracts with Customers. As a result, nonpublic entities will be required to apply the revenue recognition standard. In the case of FASB 606, if you are subject to any audit oversight, whether it be the bank or a taxing agency, FASB 606 now becomes relevant. This is also relevant if revenue is used and or needed for verification. Lending institutions and those requiring financial statements for qualification have been requiring GAAP compliant financial statements and will likely begin to demand conformance to the new standards. Finally, CPAs offering attestation services will now give increased scrutiny to how firms recognize revenues on their contracts.

“Revenue is recognized when a company satisfies a performance obligation by transferring a promised good or service to a customer (which is when the customer obtains control of that good or service).”

Architects, Engineers, and Professional Service Firms that “sell” labor and drawings fall under this definition and will be subject to FASB 606.

Enter Deltek Vision Revenue Generation

Using Deltek Vision Revenue Generation was always a good idea for Project Management as it allows us to begin recognizing what we have earned as compared to what has been spent. This is done by using basic revenue generation factors such as: 

• Job to Date Spent (or as I refer to it “earn as you burn”)
• Percentage of Complete
• Milestones or Deliverables

Using Vision’s User Defined Revenue capabilities, these and other potential methods and formulas can also be developed.

Preparing Deltek Vision for FASB 606

All firms need to understand how this measure requirement relates to them and seek advice from CPAs and Tax Professionals to ensure they will meet the requirements. Our role is to work with you and your CPA to configure Deltek Vision appropriately to accommodate the methods. In advance of your discussion with your advisors, we will assist in the creation of commonly understood measures. 

To learn more about overall revenue recognition concepts in Deltek Vision, check out this past blog. For further information on how to set-up revenue generation methods related to FASB 606 in Deltek Vision, please reach out to us and a consultant will be in contact.

* Rana Blair contributed to this blog.

If someone were to ask you what do you like least about your job, what would you say? Assuming you like your boss, your environment and co-workers, there is still always a task that you just wish you didn’t have to do. For me, it is my expenses. You would think, getting reimbursed would be motivation in itself. Yes, at some point it absolutely is. It has gotten much easier now that I can take a picture of my receipts and quickly upload through my Deltek Vision Touch application with my phone. However, I still have to fill out the details which takes time. Time I don’t always have. What if I told you it could get even easier? I was then introduced to the Concur expense solution.

I literally was giddy over expenses when I saw what the solution could do. The Concur expense solution automatically imports credit card charges and matches them to receipts and itinerary data. Instead of manually entering your expenses, I can simply take a picture of the receipt and it reads the information and fills out my expenses. Sounds too good to be true, right?

So how can this help Deltek Vision users you might ask? Well, there is an integration being finalized right now. I invite you to view the video below to begin to learn more about the Concur expense solution:

Learn more in the upcoming Concur webinar. This webinar will further show you how Concur expense reports write themselves and we will provide a sneak peek of the upcoming Deltek Vision integration.

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.

Creativity, when used in the accounting world, is usually considered a “no-no”. However, I am not talking about misrepresenting the state of affairs. In fact, I am talking about the exact opposite - providing the client exactly what you told them to expect at the beginning of the proposal process. Let’s take a look at how setting client expectations early can improve your firm’s cash flow. 

Setup a Project Process

I am not saying that project management and marketing get to dictate accounting functions, but I am saying that it is imperative that accounting work with project managers and marketers to ensure the signed agreements match the accounting schedule and billing possibilities. To do that, accounting needs to understand the needs of the client and the project managers, as well as the functions and limitations of the software they use for accounting and billing.

From there, you can create a project set up process that easily allows the project managers to see where they are in the project in relation to the budget and plan. This ensures the invoices match what the client was told to expect. As a result, clients are more likely to pay on time and you can count on the cash flow coming in from your clients.

Understand Reporting and Timing Requirements

In many cases, clients have specific reporting and timing requirements – some are reasonable and some are not. Involving accounting at the front end of the project to have discussions with the clients about what is possible and not possible will go a long way to ensure a smoother billing/collection process down the road.

However, accounting can’t become obstinate with the “we don’t do things that way approach.” There has to be a willingness to work with the others to solve the issues between the client desires and the current accounting process. Having he accounting staff work directly with the client to resolve the issues will ensure both understand where the other is coming from.  

Have the Right Accounting System

Understanding what the client needs and understanding what is possible in the billing system allows accounting to bridge the gap. Of course, having a system that offers many options to bill the client helps too. At a minimum, your system should allow you to create billing cycles that allow for most client timelines.

The better systems will allow for billing to be prepared with multiple options for the way the labor and expense are handled. Additionally, they have ways for managing fees and additional items such as credits. The best systems allow for changes in the invoice format so the final product has the required information in more or less where it is needed. Again, flexibility, creativity and patience are often needed.

Let the Cash Flow

Remember that a good collection process begins by communicating with the client - take the time to understand their needs and explain what is possible. Create a billing process that is flexible enough to support client expectations and is efficient enough to be managed internally. Doing so will go a long way in avoiding issues down the road.

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.

Professional service firms don’t traditionally sell products; rather they sell their time and expertise. Increasingly, they ARE selling products and time, and are spending a great deal of capital on tools to deliver both.

A common problem is that many firms can easily see the profits generated from their services, but overlook the contribution (or lack thereof) of the inventory AND fixed assets used to deliver the service by not managing both.  Even worse, they frequently manage and track them in the same manner.

Inventory management and fixed asset management are not one and the same. Read on to learn the difference between the two and understand the importance of utilizing proper accounting for fixed asset management.

Inventory Management

In the professional services world, inventory management is only slightly different from the retail and the production world. Inventory assets represent the items sold or the materials used to create a final product that will be sold. Inventory assets in professional services firms represent the intangible or intangible assets sold along with the service. This could include software or equipment. This is not to be confused with immaterial items, which are usually expensed as overhead. For most professional service firms, the inventory asset is a relatively small percentage of total firm assets.

Most importantly, unsold inventory appears on the balance sheet as an inventory asset and sold inventory appears in the Cost of Goods Sold on the income statement. This is an important standard of Generally Accepted Accounting Practices (GAAP).

Chances are, if you are selling goods as a part of your service offering, you are likely following the standards and hopefully using the Vision Purchasing module for tracking and control. But what about Fixed Assets?

Fixed Asset Management

Like Inventory, fixed assets exist and have specific accounting treatments for professional services firms, retailers, and other types of businesses.

Fixed assets are purchased assets of the firm for long-term use to support ongoing business operations. For example, fixed assets are laptops, desks, software, and vehicles, just to name a few. Since fixed assets are transferable within the company and will be used for multiple projects and multiple accounting periods, GAAP dictates a different accounting treatment than would be used for inventory management. More importantly, fixed assets in professional services firms are typically a large percentage of the total firm assets. In today’s world, the computer, machine, and installed software are the main tools used in delivering the services and often are given the least attention in the firm.

Why Is This Important?

Inventory management is a relatively simple task, but fixed asset management presents several challenges such as:

• Knowing the location of an asset to ensure you can deliver your projects on time
• Maximizing the usage of an asset to ensure the maximum ROI is gained from the asset
• Knowing the history of similar assets to make informed about purchases of new assets
• Tracking the depreciated value of an asset for tax and insurance purposes
• Keeping the Balance Sheet clean and free of historical errors to provide accurate ROI and other metrics

Overcoming these challenges doesn’t have to be difficult and can be easily accomplished by deploying an asset management tracking system. When choosing to implement an asset tracking system, it’s important that the system is integrated with your project management, purchasing, and accounting systems to ensure information about the asset is accurately maintained and easily accessible.