Full Sail Partners Blog | Deltek Vision (4)

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. 

As a Deltek Vision user, having the ability to access the information in your system from anywhere on any device with an internet connection can change the way you work. Good news! Deltek iAccess for Vision makes this possible. Here’s a short video to give you an introduction and a demonstration of how easy iAccess is to use.

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.

It wasn’t long ago that firm management took a “need-to-know” approach with sharing project performance information with staff. Today, most firms have changed their attitude about access to project information. Firm managers want project managers to be engaged with the financial results of their projects and have taken great steps to train them to use the Deltek Vision reporting tools and dashboards. Still, project managers are intimidated and paralyzed by the information they receive.

So why are project managers not taking responsibility for their projects?

• Budgets are not easy to access or review against actual performance
• Reports are complex and rely heavily upon the accounting cycle that many project managers don’t understand
• Too much information in reports makes it difficult to focus on what is important
• Analyzing data requires pulling information into Excel for What-If scenarios
• Access to information “on-the-go” is not available 

How Can We Change This? 

Enter iAccess. The tool built for project managers to provide them the information they need at their fingertips to successfully manage projects. Even more, it’s ready to go right out of the box. Sure, that sounds too good to be true and one might wonder what you get with iAccess’ standard configuration. 

Here’s a high-level summary. An iAccess core feature that requires no configuration provides a simple project review tool that allows users to quickly review, analyze, and focus on projects needing attention. Any project accessed will appear with current contract, labor, and expense information in graphical and tabular formats at the project or lower levels. This removes the need of having complicated reports and performing What-If scenarios. 

Can iAccess Do More? 

iAccess, like Deltek Vision has the flexibility to meet the different and complex needs of each individual firm. From simple custom configuration of reports to in-depth configuration of projects, iAccess provides the same information that’s stored within Deltek Vision to project managers from anywhere they have an internet connection.   

With just some minimal configuration, project managers can use iAccess as a comprehensive project management tool from the beginning of the project through closeout by using the planning functionality. Starting with an original budget, project managers can interact with their projects as needed to review actual data and then provide estimates of additional effort required to complete the project. 

Stay Connected with iAccess 

The real-time connection to your Deltek Vision database and the mobile accessibility of the iAccess tool may be the missing link in motivating your project managers to take more control over their project financial management responsibilities. The use of iAccess allows them to absorb data in a friendly format while creating a platform for predictive information entry and sharing across the firm. Stop giving project managers an easy excuse for not taking responsibility.

Spend Management is a popular term, but what is it really? Spend Management can encompass anything from procurement, supply chain management, expense control, outsourcing and more. For most businesses, managing spending may not seem to provide a competitive advantage nor differentiate them from the competition. While this task doesn’t directly drive revenue, figuring out how to better manage and control your travel costs, expenses and invoicing does provide significant business value.

So, what exactly does a good Spend Management strategy need to accomplish? It should:

• Simplify accounts payable (AP) workflows
• Enhance the end user experience
• Encourage mobility in the AP process
• Improve compliance levels
• Provide increased insight into spending
• Allow for visibility of expenses before they are incurred

What Can All This Do for Your Firm?

Spend Management will lower your capital expense profile, increase employee productivity, lower costs for managing operational functions and drive new capabilities that have a direct impact on business performance. Accomplishing these goals allows your firm to continue to compete in this hypercompetitive environment that continually rewards sustained agility.

Organizations typically start with a manual process for managing purchasing, expense reports, and invoice management. As the company grows in size and complexity, workarounds like spreadsheets and physical reconciliation are simply no longer efficient and directly impact the further ability to grow and manage spending.

According to an IDC study (Document #US42246116 © 2017 IDC), implementing effective strategies can result in:

• 68% less time processing invoices
• Improving company procurement compliance by up to 14%
• Increasing productivity by an average of 11% using mobile/OCR management tools
• Reducing IT staff time to manage spend by 29%

How to Evaluate Solutions to Help Your Firm with Spend Management?

There are many factors to consider when evaluating a Spend Management solution. Here are some key things to contemplate:

• Business ready: Solutions must be able to scale to accommodate your firm now and in the future, and must automatically link into existing accounting and ERP systems. These are secure, cloud-based solutions that fit within the CIO’s IT policy framework, are cost-effective and easy to deploy across the organization.
• Business Intelligence: These solutions must be capable of providing greater business performance visibility and driving smarter decision-making. With a solution that offers more than automation, executives are armed with the insights to identify business opportunities that never existed before. What used to take days or weeks can now take hours.
• Complete visibility: Encompassing all areas of spend in one solution, including travel costs, expenses and invoice management, is ideal. If you only see a piece of the puzzle, it is virtually impossible to view the entire picture. With solutions that can integrate all of the data and incorporate your firm’s spend management regulations, you can ensure there is maximum compliance and have the easiest adoption across the company with only one solution to learn.
• End-user adoptability: As better financial performance rests with reducing accounts receivable turnover and achieving greater efficiency in cash flow management, businesses need to ensure that finance and accounting staff, as well as their employees, are able to quickly and accurately execute a modern, mobile process. When end users are satisfied and are able to employ solutions anywhere and anytime, this results in faster and increased adoption of the solutions and increased financial performance.

The best systems provide better visibility and insight into non-PO spend, P-card spend, and corporate card spend as well as meet employees where they are. They allow for visibility into spend before the money has been spent (PO management) and follow through to auditing with full details completely integrated into your firm’s ERP system. They also can incorporate all of these areas of spend into one solution so it’s easy to quantify spend across all areas.

Gain Control of Your Spend Management

Expectations and demands for employees, especially finance staff, have never been higher. The cost of lower productivity, employee turnover, and inefficient financial operations is now even more critical to a firm’s success and must be addressed. Employees require mobile, efficient solutions to increase their overall satisfaction and productivity. With increased industry compliance regulations, accurate reporting is now a necessity instead of a luxury. Now is the time to get control with a Spend Management solution.

It is a mystery why we deal with time management so badly. This is our commodity which we sell to our clients. However, we treat it like a curse, as if it’s an evil process that accounting forces on us. It somehow escapes us that this is the lifeblood of our business, and without it, we are out of business. So why don’t we manage this better and how can we improve our firm’s practices? 

Well, to begin with, the timesheet function in Deltek Vision is incredibly easy to use. You just need to know what features to focus on. Let’s take a look at timesheets and what is offered in Deltek Vision regarding time management.

Timesheet Best Practices

Project management best practices always include sound timesheet management processes. First of all, timesheets should be entered daily and submitted timely. Secondly, project manager review is mandatory. Timesheets should be corrected before they are posted to our projects and the billing system in Deltek Vision.

Poor timesheet management inherently leads to inefficient processes later. Timesheet miscodes cause incorrect project reporting and erroneous invoices. Additionally, transferring time entries in the billing system is time consuming. This slows down billing, involves the project manager, employee and accounting. Worst of all, this directly affects cash flow because of the delay in processing client invoices.

Features of Timesheets in Deltek Vision

We need sound, efficient and thorough timesheet management policies and procedures. They need to be incorporated into our culture. Along with daily entry and strict deadlines for timesheet submission, Deltek Vision has a number of tools to assist project managers with this process:

Floor Check was introduced in Version 7.2 and is a powerful tool that lets timesheet administrators see if employees are doing their timesheets. It shows the employee’s expected hours and the actual hours entered. Additionally, floor check has email functionality, so you can email employees directly and tell them, “DO YOUR TIMESHEET,” or you can also create pre-defined messages.

Unposted Labor Report is a standard project report that only shows unposted time sheets. This is the ideal tool for project managers to use in order to see what has been charged to their projects before they are posted. This is the perfect opportunity to fix timesheets before they are charged to our projects.

Project Reports with Unposted Time reports can be included in project reports by using the unposted time option. As a result, project managers can see labor being charged to their projects during the timesheet period.

Line Item Approval allows project managers to use line item approvals to put their final approval on time charged to their projects once timesheets are submitted. Line item approvals link to project ownership, so project managers will only see their projects.

Timesheet Audit Trail tracks changes to timesheets after they have been saved or submitted. You can require the employee enter a comment, or just track changes without explanation. Audit trails can also track billing transfers. This is the “where did it go” and “where did it come from” report. A timesheet audit trail report is available in employee reporting.

Get Your Timesheets Done!

With all of these tools within Deltek Vision at your disposal, timesheet management is within your grasp. You can simply start with daily timesheet reminders. Eventually, you will develop a plan that makes timesheet management best practices part of your firm’s culture. 

Does your firm work internationally and deal with multiple currencies? Did you know there is a way to automate the tracking and conversion data? Within Deltek Vision is the Multicurrency function which holds the key to simplifying this process for your firm.

Vision Multicurrency allows you to:

• Manage multiple currencies for transactions, accounting and financial reporting
• Enter and manage exchange rates which can be done manually or can be automated to pull in exchange rates (XE.com has an auto feed subscription for this)
• Support daily and periodic exchange rate changes
• Revalue foreign currency accounts and automatically identify a gain or loss due to currency fluctuations

Considerations when Using Deltek Vision Multicurrency

With any changes to your standard accounting practices, there are always some items that need to be taken into consideration:

Revenue Considerations: Revenue generation will now use the billing currency fields in the project info center.

Project Considerations: Once you set a project to a currency and the project has data on it, the currency code cannot be changed on the project. It is very important to set the project to the correct currency upon initial setup. All lower levels of the work breakdown structure (WBS) must also be set to the same currency as the project. Optionally, a billing currency can be set differently than the project currency, but all lower levels will need to match.

General Ledger Account Considerations: In Vision Multicurrency accounts can be left without a specific currency or set to a single currency. In some situations, the company might set a bank account to a specific functional currency. For example, a bank account is set to USD for use by only the USD company. You might leave other accounts open to be used across companies with different currencies. Once an account is set to a currency that is different than the functional currency, it is then considered a foreign denominated account.

Unit Considerations: You must specify both a project and billing currency.

Vendor Considerations: Vendor records are stored in the functional currency of the active company. Additionally, there are several details to note for vendor records:

• Functional Currency – the home currency or the currency in which the company operates
• Transactional Currency – the currency in which a transaction is entered into Vision
• Presentation Currency - used in reporting to generate a report with all amounts expressed in a single currency
• Billing Currency - the currency used to generate invoices and billing reports for specific projects and their WBS
• Project Currency – the currency in which the project is managed which can be different than the functional currency when needed (this currency should be used for all project management purposes including reporting)
• Payment Currency – the currency in which the payments are made
• Consolidated Reporting Currency – only available in a Multicompany environment and is used to create consolidated financial statements for multiple companies that are using different functional currencies
• Account Currencies – each account setup for use as a bank account and mapped to a GL code can be set to a specific currency directly through the account setup of the GL (if you specify an account currency that is different from the company’s functional currency, the account is then considered a foreign-denominated account)
• Tax Currency – if tax auditing is enabled then a currency must be set for each tax code (this is generally the currency in which you report and pay the tax amounts to the proper tax authority)

Generally Accepted Accounting Practices in Deltek Vision Multicurrency

Deltek Vision Multicurrency is in accordance with the Accounting Standards Codification (ASC) sections ASC-830-10-55-10 and 11. In section 55-10, the guideline states that it is acceptable to use averages or other methods of approximation. Accordingly, it is recommended to use a weighted average of the exchange rate for a period rather than applying actual day-to-day fluctuations.

Furthermore, section 55-11 states that average rates used shall be appropriately weighted by the volume of functional currency transactions occurring during an accounting period. In other words, to translate revenue and expense accounts for an annual period, individual revenue and expense accounts for each quarter or month may be translated at that quarter's or that month's average rate. The translated amounts for each quarter or month should then be combined for the annual totals.

Why Use Multicurrency in Deltek Vision?

Multicurrency can be used for tracking currency exchange gains and losses. Having foreign-denominated accounts creates the need to track gains and losses based on fluctuating exchange rates. For example, if a European company has a bank account denominated in United States dollars and the value of the euro rises against the United States dollar, the value in euros of that bank account balance drops. This results in an unrealized loss to the European company. Using Multicurrency allows you to use the Gains/Losses and Revaluations process in Vision to calculate and post these types of currency exchange gains and losses. As a result, they appear on your financial statements per the generally accepted accounting practices under which you operate.

“I can’t find anything in our CRM system.”

“Our CRM system isn’t user friendly.”

“Our CRM system doesn’t provide me the data I need.”

The statements above can apply to any Client Relationship Management (CRM) system. Yep, you heard me right. These comments are shared with me daily by prospects and clients alike. These complaints may seem valid, but the truth behind why your CRM system sucks is much harder to swallow and admit. Deep down inside, you know the real reasons. Today I’m going to share with you why your CRM system doesn’t work and what you can do about it.

The main reason why CRM implementations usually fail isn’t because of the system, it’s because of you. I told you this was going to be hard to swallow. A CRM system is meant to provide a place to house all of the important information about your clients and opportunities. However, many firms purchase a CRM system thinking it will miraculously do the work for them with no effort required. 

A CRM system can work for you, but not if you haven’t set it up or implemented it with forethought. More importantly, it can’t work for you if you don’t actually touch or use it. So stop pointing your finger at the CRM system and placing the blame. As the saying goes, when you point one finger, there are three fingers pointing back at you. 

If you want a successful CRM implementation, here are some things to consider. 

Stop Focusing on the Wrong Things about Your CRM 

Your CRM system should focus on a few reports to make sure sales people are generating business for your firm. Each of those reports need to be automatically sent to you at the same time every week, month or quarter. As a Sales Manager, you need to know: 

1. Do we have enough pipeline?
2. What opportunities require follow-up?
3. How are we getting new deals?
4. Why are we losing deals?
5. Who previously spoke with the client?

No system in the world can save you if you haven’t set up a way of monitoring these core activities. No bells and whistles of a new system will accomplish this essential task. Stop whining and making excuses. The fact is, if you don’t have these key reports, you haven’t established your processes. Take a step back and identify what really matters first.

Whip It! Whip it Good!

Every system needs someone dedicated to managing it. In the AEC industry, QA/QC is a must with projects to avoid potential failure. Your CRM system is no different. Make sure each area of the system has someone that “owns” it to ensure there is integrity with the data. Give these people some whipping power! Management must stand behind them, it is expected that everyone will update their own clients, contacts and opportunities. Above all, these system “owners” should know the system inside and out and take full responsibility for its success.

Making Excuses, Excuses, Excuses

Firms that are successful at CRM make it a part of their culture. It’s not an option to use the system, but rather a requirement. Don’t let excuses stop your team from using the system. Provide them training and support to learn the system and expect in return that employees use the system as designed. Anyone can find a reason why they can’t or won’t. However, accepting excuses won’t provide your firm the information needed to make informed decisions about sales pursuits.

Don’t Let Your CRM Suck

So what are you going to do? Are you going to keep making excuses and blaming the system or are you going to take the necessary steps to whip your system into shape? We at Full Sail Partners are available to help firms successfully implement their CRM. We expect all of our employees to practice what we preach and will work hard with you to ensure that your CRM no longer sucks.

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.