Full Sail Partners Blog (2)

Search Engine Optimization Basics for Project Based Firms

Posted by Lindsay Diven on April 20, 2022

2022 - DGDM_SEO Basics - Banner

The primary goal for the AEC digital marketing program is to get a firm found online. This can be done through creating content highlighting the firm’s expertise and subject matter experts. However, it’s not enough to just publish this content on the firm’s website or blog. To have the right potential clients find that content, the content needs to appear in searches. This is where search engine optimization (SEO) comes in.  

According to HubSpot, the definition of SEO is techniques which assist a firm’s website rank higher in search engine results pages (SERPs). This makes a firm’s website more visible via search engines like Yahoo!, Google, or Bing for those who are seeking solutions that a firm’s brand, service or product could offer. 

This article is part of the Driving Growth with Digital Marketing series and will provide an introduction to SEO techniques AEC firms can utilize when building their digital marketing program.

How SEO Works

Search engines crawl the internet to scoop up tidbits of phrases and key words to index them. Then when a user types in a phrase, question, or key word into the search engine, it provides results to the user based on those indexes. Search engines are searching for the websites, webpages, blogs, etc. that the firm is publishing.  

Search engines also look at the firm’s website structure and design, visitor behavior, and mobile optimization. So, it’s not just about the content that is being published, but the framework in which it’s published too.  

The Elements that Can Increase Organic Traffic    

Organic traffic is what most AEC firms are aiming for and includes the unpaid visitors (or traffic) that comes to the firm’s website through the search engines. The firm isn’t paying for any of that website traffic.  

There are elements of the website, structure, webpages, and even the firm’s social media channels that help or hurt getting organic traffic. Some of the elements that have the most impact are described below. 

Consistent Content Creation 

The website needs to be updated on a regular basis. Publishing genuine content that interests the targeted personas greatly improves SEO. The more often producing and updating content, the “fresher” it appears to search engines. Make the content easy to read or skim by using small paragraphs, descriptive headings, lists and bullet points. Also, link to internal and other external pages throughout the content.   

SEO Friendly Webpage Structure    

Each webpage has a built-in structure that is universal no matter what program the firm is using for its website software. Each page usually has a hierarchy of headings that tells the search engines the importance of the content. For example, the heading tag called H1 is the main header tag. This is typically reserved for the title of the page. Then there are heading tags H2, H3, etc. Just like in a printed document, these should be used to help guide the reader (and search engines) through the webpage content.  

When creating new content, don’t cram it full of all the keywords. Make sure the keywords, topics, and phrases are spread throughout the piece and flow naturally into the content. Be sure to use keywords in the title tags (H1, H2, etc.). Also, make sure that the content is easy to read and/or skim by using many small paragraphs, descriptive headings, lists, and bullet points, for example. 

Image Optimization 

Another SEO component is how fast the webpage loads, and images are the biggest culprits when it comes to slowing down webpage load times. Since AEC firms tend to have very visual websites, it’s easy for the websites to be slowed down dramatically due to the number of images. Make sure that every image on the website is compressed and is the right image format for the screen (as opposed to print-level quality).  

Meta Descriptions 

A meta description is the text that appears in the search results underneath the page title. See the screenshot below for the example that appears with the search of “Deltek Vantagepoint Upgrade.” Meta descriptions can be added to the backend of the firm’s website builder and should be written to include keywords and phrases. The meta description should also be relevant to the content that is on the page, so keyword stuffing will actually hurt the results. Also, the meta description length should be between 150-300 characters. 

Screen Shot 2022-04-19 at 1.09.05 PM

URL Structure 

Did you know that URL stands for Uniform Resource Locator? Just like the webpage structure and meta descriptions, search engines display the URL on the search results. Consider following these SEO best practices when creating URLs: 

  • Use clear, descriptive words in the URL as opposed to random numbers and letters. For example, www.fullsailpartners.com/fspblog would be better than www.fullsailpartners.com/453=?45659. 
  • Try to use shorter URLs whenever possible. There is some research that shows that shorter URLs perform better because URLs that are too-long will be cut off in search results. However, it’s just as important to be descriptive in the URL so don’t cut the URL length just to cut it. 
  • Use keywords in the URL. If the page is targeting a specific term or phrase, make sure to include it in the URL. But don’t go overboard or appear too spammy. The search engines know it and will penalize the content. For example, a spammy URL might be www.fullsailpartners.com/vantagepoint-partner/upgrade-to-vantagepoint/vantagepoint-upgrade-services. A good way to test this is to look at the URL through the eyes of a searcher and ask if it looks natural or like a robot wrote it.  
  • Use hyphenations instead of spaces. Every search engine interprets special characters or spaces the same. Use hyphens to separate the words in the URL.  
  • Use geographic location names, if applicable. If the content is about a specific location or a project in a specific location, use that location name in the URL. This can include city names, neighborhoods, or other regional descriptors.  

Off-Page SEO  

Some of the secret sauce to improving SEO happens off the firm’s website. Search engines like Google rank how popular a firm’s website is. If the firm’s content is popular, it sends a signal to search engines that it’s the best content, making it more of an authority in that topic area, thus a higher ranking. So, what makes a firm’s website popular? Let’s introduce a few strategies. 

Authority Building Through Backlinks  

One way to build authority in the search engines is how popular they rank a firm’s website. One factor they use is called ‘backlinking.’ Backlinks are links from other domains that points to a firm’s website or particular webpage. Each backlink is considered to be a “vote” of confidence for the content that’s being linked. Other websites should also be linking back to the specific firm’s website. Even better is if the backlinks are from higher authority domains such that end in .edu or .org. 

Think about the various ways in which the firm’s website can be backlinked. Some might include: 

  • Sponsoring industry conferences and events. Ask the host entity to place the firm’s logo on its website and link back to the firm’s website. 
  • Write articles for industry websites. Then, make sure the article has a link back to the firm’s website. 
  • List the firm in online industry directories. For example, Design-Build Institute of America (DBIA) has a rather established one. 

Google My Business 

This is probably the easiest task to improve SEO is to make sure the Google My Business is set up for every office location for your firm. Make sure that the firm’s name, address(es), and phone number(s) are correct on the firm’s website and that they are also the same at what’s displayed on the Google My Business page. It sounds so simple but can be quite complex especially the more offices the firm has and how often the offices move locations.  

Getting Started with SEO 

There is no exact science or formula to rank first, or even on the first page, in a search result. Basically, if the content provides value to the people searching for it, it will rank better. Here are some best practices to keep in mind as content is developed for the firm’s digital marketing program: 

  • Research for the key words, phrases, or questions that the firm’s personas would be searching.  
  • Conduct those same searches on Google, Yahoo!, and Bing to see what pages and content is already ranking high.  
  • Review those pages and content to identify what qualities, format, content type, etc. that those pages possess.  
  • Make sure to create content that is better than those! 
  • And, if some of the firm’s content ranks high with those searches, evaluate those pages and content to see what’s working. Repurpose that specific content in new ways and create new content like that. 

Driving Growth with Digital Marketing 

SEO is just part of the overall digital marketing plan for AEC firms. Other components include identifying the persona, setting goals, and developing a content strategy. To learn more about each of these components, check out the entire Driving Growth with Digital Marketing series by clicking the link below. 

 

New call-to-action

Amplify Business Intelligence Visuals with Informer

Posted by Timothy Burns on April 12, 2022

2022-Informer_Amplify-Business-Intelligence-Visuals_banner-01

A favorite song is structured to be both instantly recognizable and memorable. It’s written with a predefined structure that is thought out to capture the listeners attention and invoke an emotion. There are several standard ways in which a song is written and some basic rules song writers “should follow” when it comes to writing the song.  

The same can be said to developing business intelligence visuals for project-based firms. A business analyst, like a songwriter, must decide on the different visuals that will come together to create a melody to allow firm leaders to make decisive, but critical decisions. The visuals must grab the attention quickly and be easily understood to the audience. 

This article breaks down how to the Blackbox Connector for Informer amplifies the firm’s Deltek Vantagepoint data to make memorable melody. 

Understanding the Business Intelligence Visual Structure

The basic parts of a song include the intro, verse, pre-chorus/lift, bridge, break, and outro. Let’s compare that to creating a business intelligence dashboard using Informer.  

The intro is self-explanatory – it’s the intro the song or the very first visual on the dashboard. And, it’s one of the most important parts. Typically, it’s the very top left corner visual. This is where the most important statistic or data should be displayed.  

The verse gives the listener (or the viewer in our case) the idea of what the song is about. It typically sets the tone or topic of the entire dashboard.  

The pre-chorus/lift can build anticipation. In a song this includes increasing the volume or rhythm or pulling back and creating silence. When building the business intelligence visual stack, it can be the visuals that keep viewers scrolling through or keep them on the page.  

The chorus is often the most memorable melody of the song. It usually repeats itself throughout the entire song. And, just like in a song, it can repeat the same visuals but maybe for different regions or offices. For example, the dashboard may have several charts that show utilization rates by office with different separate visuals scattered throughout for each region of offices. Think about that one main theme of the dashboard – utilization rate, hit rate, profit, sales target – whatever the theme for that dashboard and make sure it’s repeated in a way that makes sense to make it memorable. 

A break is usually an instrumental part of the song that allows for some breathing room. When creating business intelligence visuals, make sure there is ample white space or breathing room between each individual chart or graph. This gives the audience that break before consuming the next information. 

A good song has an outro – the end of the song. The outro closes out the song just like the business intelligence dashboard needs to close out.

Putting the Structure Together   

Understanding the basic structure of a song (or business intelligence dashboard) is just the first step. Next is to understand how each part works together to create different melodies. Below are some common song structures in modern music and how you can think about these when designing dashboards using Informer.  

Verse-Chorus-Verse-Chorus  

This is probably the most common song structure in today’s music, especially in pop music. And, it’s a great way to begin with designing the BI dashboards.  

Examples of some songs using this structure include: 

  • “Smoke on the Water” by Deep Purple 
  • “All You Need is Love” by the Beatles 
  • “Foxy Lady” by Jimi Hendrix 

Informer visuals using this structure can include visuals showing the following: 

  • Total potential revenue in the pipeline 
  • Opportunity count by office 
  • Total revenue won YTD 
  • Opportunity dollar about by stage 

An example Informer visual using this structure is shown below. 

 

Verse-Chorus-Verse-Chorus-Bridge-Chorus   

Songs that use this structure often get stuck in your head and therefore become popular. The bridge helps add a surprise or variance breaking up the repetitiveness of the song. Using this structure when designing the business intelligence dashboards can add a new angle or different theme while supporting the main goal or theme.  

Examples of songs using this structure include: 

  • “Happy” by Pharrell 
  • “Every Breath You Take” by the Police 
  • “Fix You” by Coldplay
 

Taking the example from above, the bridge added could be: 

  • Total potential revenue in the pipeline 
  • Opportunity count by office 
  • Total revenue won YTD 
  • Top 10 largest clients by YTD revenue 
  • Opportunity dollar about by stage

By adding the top 10 largest clients, the viewer can get a sense of what clients the firm should be focused on, which stays with the theme of the overall visual – business development. But that specific chart is revenue earned not expected revenue or sales won. It’s a different angle of information but still very helpful to the business development team. 

An example Informer visual using this structure is shown below. 

Create Visuals Easily with Informer Discover Tool 

Informer is a business intelligence tool that uses the Blackbox Connector to connect to Deltek Vision or Vantagepoint and create a standard set of datasets. Using the Blackbox Connector with Informer allows the team to start building visuals right away instead of spending a lot of time building datasets and programming visuals.  

Once the data is connected, go to a dataset and select the Discover Tool. Then choose a field, in this example Project Summary is selected. The Discover Tool instantly recommends visuals based on the data selected. The tool recommends visuals based on the fields and columns selected and changes the recommendations as you select more or less options. 

Each recommended visual can then be adjusted or further designed based on the needs. It can then be saved to be used later to create dashboards (called Reports in Informer).   

Tips for Choosing the Right Visual Structure 

Knowing the structure and different visual types while using the Informer Discover tool to make the visuals easily, how do you decide what visuals to display for firm leaders? The dashboard should not just be pretty, but also functional. It’s helping firm leaders make critical decisions, after all. Below are a few tips to choose the right visual structure. 

  • Understand the audience – Knowing who will be using this dashboard to make decisions will help determine the key metrics to display. What information does the audience need to be successful? Keep in mind that the visuals are just an overview and the audience can drill down into the data, if desired. 
  • Stick to one main theme – It doesn’t make sense to throw in a chorus of playing ball in a country song about losing ‘the girl.’ So don’t mix in too many different types of data that don’t support the main theme. It’s okay to create multiple dashboards and tools like Deltek Vantagepoint and Informer allow users to quickly access different dashboards, if needed. 
  • Incorporate different visual types – Sticking to one main theme, doesn’t mean using the same visual. Create a visual story by choosing different types of charts, graphs, and tables. Just be careful to select the visual that matches the data type. The Informer Discover Tool does this easily by recommending the visual types for the data selected. 
  • Use color wisely – Every color can tell a story. Don’t use too many colors to distract viewers. Instead use color to show differences or areas to the viewer should focus. Using red for negative, green for positive, and grays to show values is a great way to use color wisely.  
  • Keep it simple – Because the Informer Discover Tool makes it easy to create different types of visuals for any type of Vantagepoint data, it might be tempting to add it all to a dashboard. It’s very important to keep in mind the end-user or audience that is using the visuals to make decisions. Keep the most important visuals in the top left corner. If the viewers are overwhelmed by the sheer amount of visual stimulation or there’s too many clicks to drill down to data, it won’t be valuable to them.  

Write the Firm's "Greatest Hit" with Blackbox Connector for Informer  

Knowing all the parts and possible structures of songs and business intelligence visuals is a first step to writing that greatest hit for the firm. Remember that the point of providing BI visuals to firm decision-makers is to make all the firm’s data understandable and therefore, becoming actionable based on the information presented.  

To see the Informer Discover Tool in action click the image below to access a mini-demo.

New call-to-action

A Few of My Favorite Things About Deltek Vantagepoint Reporting

Posted by Terri Agnew, CPA on April 06, 2022

2022 - Vantagepoint Favorite Things-01-1

In my prior experience as a Controller of Architecture and Engineering (A&E) firms, I was often the “go-to” person for creating reports for PMs and Executives using Deltek Vision. Over time, I learned exactly which tab(s) the options were on for the various reports, which navigation menu item to choose to find the report base I needed, and even which color names were my favorites to use for the group headings.  Now with Deltek Vantagepoint, report creation has been made even easier with a few excellent enhancements. So, with the musical the Sound of Music in mind, let’s highlight the Deltek Vantagepoint report upgrades as “A few of my favorite things” …about reporting!  Feel free to “sing” along. 

Favorite Thing #1 - Organization of Reporting Menu

My first “favorite thing” may not be as pretty as “raindrops on roses” but it sure will save time!  Unlike Deltek Vision, Vantagepoint has only one Reporting option on the Navigation menu. All the standard base reports are now found on one “Reports” tab within Reporting. Likewise, all Saved Global/Personal reports will be listed on one “Favorites” tab. Instead of navigating through a dozen + menu items to find the report needed, now simply search for the report by name on either tab or filter by the type of report if you choose.    

For example:  Don’t scroll through the full list searching for the Time Analysis Report. Using the name of the report, start typing “time” in the search bar and “voila”, the report will populate.   

Screen Shot 2022-04-05 at 3.43.15 PM

Just even knowing the type of report rather than the name of the report, it can be filtered based on report type and list just those reports. This filter is like navigating the reporting menu tree in Vision.  

Graphical user interface, text, application, email

Description automatically generatedFavorite Thing #2 – No more than 4 Option Tabs!   

Unlike the many “whiskers on kittens”, there are no more than four tabs to review for reporting options.  In Deltek Vision, some reports had two tabs, and some had up to seven! In Deltek Vantagepoint, at most there are only four tabs. 

Screen Shot 2022-04-05 at 3.46.36 PM

Columns & Groups:   Always start by deciding how the report should be grouped/sorted and which columns are wanted on the report. Keep in mind the headings of the columns can still be changed just like as in Deltek Vision but now there is only one header, not a header line 1 and line 2.   

Options:  This tab contains all “other” options for the report selected. Time selections, activity options, budget options, financial detail options – if the report has the option, this is where to find them all!  Having all the options consolidated to one tab makes it easier when creating a report as the user can simply skim through the options available from top to bottom.  There is no need to go from tab to tab any longer! 

Chart:  Not all reports have the ability to utilize charts, so this tab is not always an option. However, if the report data makes sense to also be shown in a bar, pie or line chart, this is the tab to set it up. 

Layout:  This is the tab with the choice to override the report defaults for report layout (portrait vs landscape), paper size, font, borders, headings & footers.  Advanced tip:  If a user has special options for a report, consider adding the options selected as a note in the footer for a reference as needed. 

Favorite Thing #3 – Easy Searching for Columns & Groups  

My third “favorite thing” is how easy the column and group options can now be selected in Deltek Vantagepoint. This may seem basic but having one quick and easy selection area is as satisfying as some “crisp apple strudels” with my coffee. 

Does the user want to know part or all of the name of the column or to add YTD data columns only? Does the user want all columns for hours? Use the filter! It will save time as there is no need to scroll through the long list of column options. 

Screen Shot 2022-04-05 at 3.49.36 PM

Favorite Thing #4 – Colors for Grouping & Headers, now Actual Colors not Words!!   

Let’s face it, sometimes data is boring and can be hard to read if there is too much of it on one page!  Adding some color to grouping labels can help the eye focus in on a particular detail.  The new color selections in groupings & headers are related to my favorite thing #2Want a blue like “blue satin sashes”? In Deltek Vision, to figure out if that blue was cornflower blue or light steel blue, the user had to select the color by name, preview the report and decide if it was the color desired. Now the color selection actually shows the true color visually! 

Screen Shot 2022-04-05 at 3.51.36 PM

Another great place to use colors to brighten up a report is in the Column Heading. This option can be found on the “Layout” tab of reporting. Use a nice bright color to liven up what used to be a basic black & white report. Better yet… does the firm have an approved color palette? Find out the color codes for the firm’s colors and type in the code of the color to use in reports. Now reports will match the company branding. The user doesn’t have to be limited to the 140 colors shown in this grid. Here is a website that shows more color options:  Color Hex Color Codes (color-hex.com). Select a favorite color or the company’s brand color to liven up those reports! 

Favorite Thing #5 – Select Report Options, Records and Save the Report - All from One Screen! 

My last favorite thing about Deltek Vantagepoint reporting reminds me of “brown paper packages tied up with strings”. Deltek took three areas from Vision reporting and combined them to one page. In Deltek Vision, users had to go to one screen for Options, go back to the main reporting page and navigate to a second screen for the records selection, navigate again to the main reporting page and go to a third screen to save the favorite report. In Deltek Vantagepoint, all three of these reporting functions are executed from this main reporting screen! 

Screen Shot 2022-04-05 at 3.53.18 PM

Two more quick reporting tips… (1) don’t miss that the report title can be changed directly from this screen as well! Simply click on “Project Earnings” and rename this report to whatever makes sense for the organization.  (2) Users can also email the report directly from this main screen from the “Other Actions” options. 

Enjoy the Enhancements of Deltek Vantagepoint 

While Deltek Vantagepoint users cannot all sing with the voice of Julie Andrews in the Sound of Music, they can certainly benefit from this list of “my favorite things.” In fact, users may discover more to add to this list! In the meantime, let these Deltek Vantagepoint enhancements make reporting a lot easier because like Maria said when feeling sad, “I simply remember my favorite things and then I don’t feel so bad.”   

 


Click the image below to learn how to add the powerful, feature-rich ERP to your toolbox and get your team working on the same page of the same book.

New call-to-action

To Vantagepoint or Not to Vantagepoint, that is the Question...

Posted by Cate Phillips on March 30, 2022

03-30-22 ERP Banner

Project-based firms have many options when it comes to Enterprise Resource Planning (ERP) packages, albeit difficult choices to make. In his well-known play Hamlet, Shakespeare delivered us a Hamlet who was contemplating a major decision in his famous soliloquy. So, are the decisions around life and death that Hamlet considered at all comparable to that of choosing an ERP? Well, let’s have some fun here with Shakespeare and try to make a case for it. 

Avoid the Old Bait and Switch

In the Shakespeare play, Hamlet has all these murderous plans and ways to avenge the death of his father. The famous quote “the lady doth protest too much, methinks” isn’t so much about how fickle women can be (even though everyone knows fickleness has no gender), but rather it’s said as part of a trap to see if Claudius will reveal his guilt. What can be learned from these homicidal maniacs, other than to bring back the word ‘methinks’, one may ask? 

When selecting an ERP, project-based firms must consider the entire cost of the product to avoid feeling trapped. No one likes to feel taken advantage of or stuck in a situation that isn’t meeting expectations. When clients come from other ERPs on the market, one of the main complaints is typically that they felt like their ERP provider or consultants were constantly after more fees. They were sold a product that could do a ton, but the investment necessary to get to all those great features was hidden. The result is feeling like a bait and switch has trapped the firm into pouring more into a system which was thought to be ready for full operation.  

Deltek Vantagepoint is sold as a highly configurable project-based ERP system. Full Sail Partners’ expert Vantagepoint consultants approach sales and implementations with eyes that are wide open to balance cost with efficiencies. Vantagepoint works best when it meets each firm’s business needs, and it does take configuration and therefore an investment, to get there, but it’s well worth it. So, if project-based firms have the right expectations going in, they shouldn’t be feeling trapped. 


Wrap Some CRM/RP Rigor Around the Madness

Some of the most significant and best changes from Deltek Vision to Vantagepoint are happening in the Customer Relationship Management (CRM) and Resource Planning Management (RP) modules. These are complete game changers in the market and none of the competition invested as much as Deltek has into fine-tuning these glorious pieces of functionalities. Deltek has been listening to client feedback for more than a decade and continues to listen as they expand Vantagepoint’s capabilities.  

So going back to the play, Polonius responds to Hamlet at one point by saying “Though this be madness, yet there is method in ’t.” Running a professional services or consulting firm can feel insane some days. Clients can pop up out of nowhere with additional needs, and suddenly, the entire day’s schedule has been turned into something else. Deltek Vantagepoint helps wrap some rigor around the “madness” in a user-friendly way that will actually increase user adoption in project-based firms.  

Keeping the madness at bay, Full Sail Partners has now helped more than 200 firms go from Deltek Vision to Deltek Vantagepoint. The number one reason why system usage increases with Vantagepoint is because of its ability to manage the entire project lifecycle, from a prospect that knows nothing of what it’s like to work with the firm to managing the resources and how the work is delivered. Vantagepoint also offers the type of visibility into finances, operations and performance that firms need to grow. The number two reason usage increases with Vantagepoint is because the CRM makes life easier for marketers, seller-doers, project managers, and leadership. Opportunities are no longer separate files from projects, so it’s all one record in Vantagepoint.  

Additionally, with the Deltek Vantagepoint Outlook Connect and Gmail for business connect, users can see the interaction history between contacts, clients, and projects as well as quickly log emails into Vantagepoint. This feature allows users to bring Vantagepoint into their email inboxes. And this tool comes with other features like the ability to synchronize calendars and schedule meetings while saving them in Vantagepoint at the same time. To learn more about the Vantagepoint Outlook Connect, check out this mini demo. 

 

Keep that New ERP Feeling Longer  

To put it lightly, in the play, Hamlet was worried about the “afterlife” in that other famous soliloquy when he said, “to die, to sleep – to sleep, perchance to dream.”  This is similar to how many of our clients are worried about their “aftercare,” with continuously improving their processes with Vantagepoint once they’ve made the leap to get there. A Full Sail Partners’ service becoming more popular with clients recently is the Navigational Analysis for Vantagepoint. A firm’s entire system is scanned, and current processes are evaluated to discover how well they are serving the firm. It’s like an annual physical exam by a physician that results in a complete work-up on the health of your system.  

It’s important to develop a plan for aftercare that includes regular data clean-up, optimizing processes, increasing efficiencies and overall continuous improvement. A consultant isn’t necessary to keep a firm’s ERP fresh; it’s like anything else. If experts are needed to bring their knowledge and best practices to the table, it can be outsourced, or a firm can do it itself.  

Exit Stage Right   

In review, it is certainly interesting to see how much Shakespeare’s characters in Hamlet seem to have reflected upon similar issues like with the tribulations of project-based firms regarding choosing an ERP. So perhaps they are comparable? However, the answer to Vantagepoint or Not to Vantagepoint appears to be evident. To Vantagepoint!  


Click the image below to learn how to add the powerful, feature-rich ERP to your toolbox and get your team working on the same page of the same book.

New call-to-action

Empowering Your Team with Deltek Vantagepoint Connect Add-in for Outlook

Posted by Sarah Gonnella on March 23, 2022

2022-Outlook Connect-01

The Vantagepoint Connect add-in with Vantagepoint CRM provides two-way synchronization of your contacts and calendar items within your Outlook email application. Outlook Connect empowers users across the firm to help nurture client relationships and collaborate with your team. While in Outlook, users can pin the context pane, so it remains visible. This allows the ability to view contacts and firms in the context of the active email addresses to provide quick insight to contact and firm information along with activity, pursuits, projects, and marketing campaigns. This visibility provides the entire team with valuable information while emailing and scheduling meetings. Let's take a look at how Deltek Vantagepoint Connect empowers users at your firm. 

Executives Seeking to Unify Their Team 

Sharing critical data easily across the firm is a key objective, yet a challenge for every executive. Managing and sharing data across the organization increases the ability to make crucial decisions across the business. Accessing data in a tool, like Outlook, that the firm uses on a daily basis eliminates roadblocks and redundancies for users across the company. With Deltek Vantagepoint Connect, Outlook allows users to search for and view information entered in Vantagepoint for any firm, contact, or project while in the tool. 


Increasing Client Communication Tracking for Marketing & Sales Teams 

When different departments approach tracking data in different ways, it adds barriers for marketing and sales to attain a holistic view across the firm. Identifying how to provide quick access to users entering and pursuing business across the firm ensures marketing and sales are able to provide meaningful reporting about the firm’s efforts. While using Outlook, team members now have the ability to create firms, contacts, pursuits, projects and activities within Vantagepoint as they are responding or sending emails. Having client data at your fingertips promotes transparency across the firm and improves communication to ensure departments are no longer working in silos. Outlook Connect integration is a vital tool to connect to your ERP to help marketing and sales strengthen collaboration across the company.    

Improving Project Management Productivity 

Project Managers live by tasks and schedules. During a project, a task is much more than just a to-do. It is also the way project-based firms bill for their time. Project Managers additionally need the ability to schedule and synchronize internal calendars and meetings. With the Vantagepoint Outlook Connect, users can now synchronize calendar items between Outlook and Vantagepoint. This eliminates the need to enter data twice.  

Outlook Connect also streamlines the process of scheduling meetings through the Scheduling Assistant. Through the Scheduling Assistant, clients can see the team's availability and choose a time to meet that works with both of their schedules. The client only sees available times and does not see any other details or appointments on your calendar. Alternatively, project managers can also provide specific times that are available for the entire team and provide defined time slots to the client. Once they choose a time, all internal team members will receive an invitation on their calendar. Lastly, when a calendar event is shared with Vantagepoint, users can log that time to their timesheet. Talk about improving productivity! 

Accessing Financial and Project Client Communication History   

Many times, firms may overlook finance’s need to access client data from Outlook. Finance always seems to be in the ERP system working on billing, AR and financial reports. However, Outlook is something they also use on a daily basis. One key way finance may find value from Outlook Connect is its ability to log email or correspondence related to billing. Outstanding AR, project contract documentation and contract changes should all be logged in your ERP related to the client, contact and project. Documenting correspondence and keeping client communication up to date guarantees all team members have access to the latest client communication history.   

Enable Your Professional Services Team 

Data has the potential to transform professional services firms' business when users share information across their entire company. No matter what role you are in, getting helpful data into the hands of your users enables them to make informed, data-driven decisions. Check out our past mini-demonstrations to see how Deltek Vantagepoint + Outlook is changing the way CRM is managed by professional services firms. 


Click the image below to learn how Full Sail Partners can help you Synchronize Your Business Outlook Calendar with Deltek Vantagepoint. 

New call-to-action

5 Tips to Keep Passwords Secure at Professional Services Firms

Posted by Evan Creech-Pritchett on March 16, 2022

2022 - Passwords Banner

In an age where technology is intertwined with every aspect of life, it is more important than ever to keep data protected. Since passwords are practically the keys to everyone’s livelihood both professionally and personally, if they fall into the wrong hands then there’s no telling how much trouble this could cause for everyone connected to them. By neglecting to follow proper password protection protocols, companies have unintentionally been responsible for their own data breaches and even those of their business partners. That’s why employees and leadership at professional services firms should use these five tips to help strengthen their passwords and keep security protected.

Tip #1 – Use a Unique Password 

Let’s say someone at the firm has been hacked and an unapproved person has gained access to a password. That’s already a concern, but the effect is multiplied tenfold if that same password has been used on other accounts at the firm. Once the password has been discovered, there will certainly be an attempt to use it wherever possible to get into even more of the unprotected accounts. To prevent this from happening, a completely different password should always be used on every separate firm account. 


Tip #2 – Resist Easy to Guess Passwords 

This one should be obvious, but one would be surprised by how many people use passwords like “12345” and “password” just because they are easy to remember. Personal information such as birthdays, pets’ names, and street addresses should also be avoided. To be safe one should use a password that is more random. A good password should have more than eight characters and contain numbers, special characters, uppercase letters and lowercase letters.  

Tip #3 – Be Very Cautious When Asked to Share Passwords 

Avoid scammers at all costs. Scams come in many forms - some may be emails, some may be phone calls, and some may even impersonate a friend, co-worker, client or relative online just to get access to a password. Some of these scams may try to create a sense of urgency, so always stop and remember to think it through carefully. Consider why that person would need this information, and if the person reaching out is unfamiliar, then do not continue with the contact. Here’s the golden rule to follow for not getting scammed: never give away a password.  

Tip #4 – Keep Software and Browsers Up to Date 

Keep the firm’s web browsers, applications, and operating systems up to date. If there’s an exploit to be found, it’s on an older version. It is not necessary to update to the newest version as soon as it is out, but it is generally a good idea to move to the newer versions as soon as possible. Some applications will come with a pre-set password. These should always be changed, even if they are randomly generated. If there is worry about exploits in newer versions of programs, then do research before the decision is made to update. Software companies will generally release patch notes for users to check before they update. 

Tip #5 – Use Two Factor Authentication or a Password Manager 

Two factor authentication requires a third-party app that will require approval for sign-ins. Once logged into an account, a notification on your authenticator app will be received where entry is approved or denied for whoever is logging in. Password managers are a bit more complex but will ensure safety just the same. Once logged in, the password manager will generate random passwords for the user. With these, only one password will need to be remembered to get into the manager, and it will take care of the rest. For extra safety, feel free to use both in tandem. 

Bonus Tip - Stolen Password.... Now What?

So, how can someone at a professional services firm tell if a password has been stolen? More importantly, what can be done about it? 

Well, the best way to identify if a password has been compromised is to watch for suspicious activity. The critical indicators can be anything from strange posts or questionable emails on firm accounts to even small subtle changes in personal information that seem off to the user. Some applications will inform the user when there is an unusual activity, which is especially helpful in these situations.  

Once there is evidence that an account has been breached, the first thing to do is immediately change the password. If this account is tied to others, those accounts should also have their passwords changed and be reviewed for any confirmation of hacking. One should also inform other firm staff and business partners of the breach to proactively prevent any other data breach complications. 

Stay Diligent and Safe

Professional services firms are not alone in the need to protect security, but with the expert knowledge that they are hired for, data breaches can have long term negative effects on both the firm and clients. These five tips should help strengthen firm security and protect its valuable data and clients. It’s a scary internet world out there, so it is important to keep both professional services firms and their staff safe so they can continue to work hard!  

 


Click the image below to learn how Full Sail Partners can help with Application Hosting. 

New call-to-action

Mergers and Acquisitions: Harness the (Data Integration) Beast

Posted by Charlene Kerr on March 09, 2022

2022 - Mergers and Acquisitions Banner-01

A recent merger and acquisition (M&A) update by Morrissey Goodale, shows that domestic M&A continues to soar 42 percent year-over-year. Mergers and acquisitions in the professional services industry are skyrocketing which means that many firms are learning how to successfully consolidate separate entities into one creating synergy. Much goes into the M&A process. Notably, a merger or acquisition requires significant effort in the areas of change management and rebranding, not to mention the continuation of efforts that drive the business in the first place.  

However, as these professional services firms come together, probably the most consequential matter pertains to integrating the data, and many firms find themselves in a data integration quagmire. Common sense would tell us that it should be easy to combine data from entities within the same industry, but disparate systems and diverse implementations often cause data headaches when not approached carefully. So, what are some best practices to help professional services firms harness this (data integration) beast? 

Pick Crucial Team Members

Choosing the team to make the relevant decisions about the data is the first, and most important, step. Ensure you have stakeholders from the acquiring firm to define current data and processes as well as from the acquired firm to understand the data coming in or stakeholders from both merging entities. At this point, the inclusion of a third party, such as Full Sail Partners, would be beneficial and would serve as a bridge between the uniting professional services firms to make the transition much smoother.


Include the Specialized Experts 

A specialized consultant in areas such as finance, CRM or human resources is an enormous help when needing to identify changes to the acquired firm’s processes or merging firms’ processes as well as any training in the new system that might be required. These experts can manage the project as a whole and ensure that all parties are heard and that the timeline and budget are kept on track. They will call in other specialized consultants as needed to make sure there is the best possible assistance. 

Incorporate a Data Migration Specialist 

A data migration specialist can help locate and identify the data that needs to be migrated, whether it is all held in a single location or coming from multiple systems. This consultant will create an inventory of the data, and then begin profiling the data quality for the firm. Specifically, this expert will evaluate: 

  • Is the data clean?  
  • Is it useful, or can it be retired?  
  • Are there redundancies that need to be eliminated?  

Once those issues have been identified, the work of cleansing and converting the data can begin. Data migration specialists do this all the time, and they know the best ways to handle the data as it flows through the extract, transform, load (ETL) process. Together with the data mapping, this ensures that the data moving into the new system is clean and compatible with the newly integrated professional services firm. 

Data Alignment Musts

Whether the firm relies on internal specialists or brings in an outside consultant, there are areas where there must be data alignment in the Deltek Vision or Vantagepoint system or any ERP for that matter. Specifically, firms that are merging data need to align the following.

Multi-Company

Will the resulting firm be tracking the new company within a multi-company database, or incorporating it completely into the existing company, possibly as its’ own profit center? If the former, make sure the existing system is configured to accept multiple companies and report on them correctly.

Multi-Currency

Will the resulting firm be using a different currency for the incoming company? Again, make sure the existing software can handle all the factors associated with a multiple currency environment. The storage of different currencies and methods of currency translation are just two factors that you must take into account. Be sure that your software can handle these issues, and that it is configured correctly.

Chart of Accounts

The chart of accounts for the incoming company must be mapped to accounts in the existing company, and any new accounts must be added into the software prior to moving over the new data. A data migration specialist can easily make these changes in your data for a smooth transition.

Record Alignment for all Key Tables (Unique Identifiers)

The new data will need to be reviewed for a number of factors, including:

  • Formatting of key fields, such as project, employee and firm numbers,
  • Duplicates in any of the key fields of the database and
  • Bad data in the new company that should NOT be brought over.

Work Breakdown Structure (WBS)

Firms will often use different work breakdown schemes when tracking projects. This is one area where significant adjustments might need to be made in the incoming data. A thorough review of the existing data, and a comparison to the merging company’s data is necessary to avoid headaches down the road. Data transformation specialists should be involved at this point, as they have experience massaging the data prior to the merge.

Maintain Control to Harness the Beast 

The secret to harnessing the data integration beast is to keep the process organized and controlled. Ensure leaders at the professional services firm use best practices and select the integration team wisely. With the right team in place, the changeover will be as seamless as possible. 

Full Sail Partners’ consultants have years of experience in all aspects of mergers and acquisitions for professional services firms and have access to the best minds in the industry. Whether you are just beginning to consider M&A for your firm or you already have one in progress, we can provide support and help guide you through the process to a successful merger. 


Click the image below to see how Full Sail Partners can help with your merger and acquisition data migration. 

CTA Mergers

Seeking Perfection in an Imperfect World - Optimizing the Accounting Calendar

Posted by Rick Childs on March 02, 2022

2022-Accounting Calendar-01

In a perfect world for project-based firms, as soon as a task is performed for a client, money would appear in the firm’s bank account. After all, the firm is contracted to provide services for a fee, and services were performed. End of story, right?  

Well, my bad! In the real world, that performance of services requires a good bit of help along the way, in order to get that payment in the bank. So, the story needs to expand a little to reach this ideal end game. That’s when having and implementing a good accounting calendar becomes a necessity. This routine cadence of work and accounting functions helps firms be able to rely on a regular schedule of deposits for work performed. 

A Good Accounting Calendar is a Necessity

Over the past 30 years, I have worn many hats and filled many roles involved in every step of the revenue process, including being a manager and being managed. I have learned that one of the greatest necessities is a good “Accounting Calendar” because it is essential to control the process and to have a schedule for the activities involved. Furthermore, for this to work, there must be planning, knowledge and “buy-in” by every level and department in the company from executive to “boots on the ground.” There also must be an individual overseeing the activities. That responsibility generally falls within the duties of the controller. 

Venturing back to my “perfect world,” or a reasonable facsimile thereof, if professional services firms setup and work within a good accounting calendar, they can achieve success, lower overhead, reduce billing time and collect payment for services quickly. Moreover, getting the team to follow a schedule is not a “dream.” It can, has been and is being done every day.  


Overview of the Evolution of Revenue

Below is what I call the “Evolution of Revenue.” It walks through from when the work has been performed through money in the bank. The evolution steps include:  

  • Performed Services = Unrecorded Time 
  • Recorded Time = Unapproved Time 
  • Approved Time = Unrecognized Revenue 
  • Recognized Revenue = Unbilled Revenue 
  • Billed Revenue = Uncollected Revenue 
  • Collected Revenue = Money in the Bank 
  • Money in the Bank = Gives the firm options for expansion and compensation… and that’s a whole other story! 

As the “Evolution of Revenue” shows above, it all starts with work being performed and work being recorded. The first tool to be used is a weekly timesheet. Why weekly, you may ask? Weeks don’t coincide with months or years, and firms publish monthly, quarterly, and annually! Granted, but firms are talking about scheduling, efficiency and supervision, therefore, weekly timesheets work the best. Believe me, I have tried them all, and firms can still publish monthly financials. So, let’s look at a sample schedule based on the weekly timesheet: 

  • Work Week is Monday through Sunday. 
  • All time is to be recorded daily. This provides the project manager the opportunity to review, approve and report on work as it is performed – up to the minute budget vs. actual. 
  • Monday - All time for the previous week must be inputted and submitted for approval by noon on Monday. 
  • Noon on Tuesday - The project manager and managerial review of time must be completed by noon on Tuesday. 
  • Close of Business Tuesday - The accounting and human resources review for overhead, benefits, OT, etc. must be completed by close of business on Tuesday. 
  • Wednesday Morning - Time is posted Tuesday afternoon or Wednesday morning. 

So now the firm has time in and posted each week. What then? Well, for one thing, if the firm is using Revenue Recognition – which it should be – it can publish Revenue figures for the previous week on Wednesday morning, along with Employee Utilization figures and Project Management Reports. 

Next Steps in the Evolution

So far, we have covered the first four steps in the Evolution and moved from Performed Services to Unbilled Revenue. Given that, let’s fast forward to Month-End where the Revenue evolves from Unbilled to Billed. Let’s review a couple of thoughts surrounding managing receivables. 

Let’s make the following assumptions:  

  • The billing month-end is the last Friday of the month. 
  • The accounting month end is the last day of the month. 
  • Preferred payroll is bi-weekly. 

Below is a sample of how this schedule lays out on a calendar in Q1 of 2022, spanning 2 weeks and 10 business days. This model has been used successfully with the buy in of project management, billing and accounting and provides principals with revenue by week and for the month on the Wednesday following the last Friday of the month. 

Table

Description automatically generated

Once the invoices have gone out, the responsibilities for follow-up vary by client and role. For clients that are being billed for the first time, the billing department follows up three days after bills are emailed to ensure that the proper individual received the invoice and to see if there are any changes that need to be made to the delivery instructions. For existing clients, billing is responsible for follow-up on accounts receivable (AR) up to 60 days past due, project management is responsible for AR up to 120 days and departmental management gets involved after that. All responsible parties receive auto-generated AR emails weekly so that all are on the same page as to who is on task.

Optimize the Accounting Calendar to Realize the Dream

As John Lennon once said, “You may say I’m a dreamer, but I’m not the only one.” Having a solid billing and accounting calendar is not a dream, it is a necessary and doable reality. Every firm has a plan and the thing that generally separates the dream from the reality is taking on the responsibility of enforcing the schedule and the deadlines. No one should be exempted from completing their assigned tasks at the time.  

Click the image below to find more accounting and finance resources. 

New call-to-action

Resource Planning Enhancements in Deltek Vantagepoint

Posted by Rana Blair on February 23, 2022

Vantagepoint Resource Planning Enhancements Hero Image

Projects are the lifeline for professional services firms. Deltek Vantagepoint provides applications to support the project planning and resource management activities—Project Planning, Resource Management and Plan Reporting. For those firms who are familiar with Deltek Vision planning, you’re in for a real treat with the enhancements added to Vantagepoint.

The enhancements include the ability to Change Planned Hours, select the ETC / JTD basis in system settings, save Resource View searches for roles, and use Spread Variance to push unused plan hours forward. Let’s dig deeper into these improvements.

Set Plan Inclusion System-Wide

Deltek administrators now have the ability from a system-level to set the inclusion of “in pursuit” project plans on some sort of objective basis. The screenshot below shows how these are automatically set based on the pursuit stages. Keep in mind when the project is awarded, it’s included in those calculations. The beautiful part about Vantagepoint is firms have complete visibility into all the plans, even if the project was not included in those utilization calculations and reports.

VPPlanning-InclusionSettings

The administrator can set different options based on the firm’s preferences. Those include:

  • Never – This means that users can plan but the plan won't be included in the calculations.
  • Always – Selecting this option will always include the plans, regardless of the degree of seriousness or clarity that you have.
  • Set by Project – This is not recommended because it relies on the plan creator to remember to mark the plan for inclusion.
  • Automatically Set Based on Selected in Pursuit Stages – This is the recommended option because it leverages the intelligence of the software to determine the stage of the project and then to automatically determine inclusion into those calculations.
  • Automatically Set Based on Probability – This uses the probabilities set up in the system. Preferences can be set to say anything greater than 50% probability, for example, will be included. Vantagepoint provides a lot of flexibility with this, but this flexibility is from the system standpoint and not each individual plan.

Set Estimate to Complete (ETC) and Job to Date (JTD) Basis System-Wide

While the ability to set and/or change the ETC and JTD was available in Deltek Vision Planning, it was often changed for one purpose or another and could be forgotten to be put back. In Vantagepoint, this is a system setting so that every plan is using the same ETC and JTD basis as shown in the screenshot below.

VPPlanning-JTDSettings

Firms can select the system settings and the basis that works best for them. For example, a firm has a JTD basis through Last Week’s End Date, and that is last Saturday. All the JTD is shown through that date and the ETC date starts the next business day. That allows the firm to have certainty about the JTD figures. If the firm customarily has weekly timesheets that are always completed by the end of the week, this may be a great system setting.

Alternatively, firms can use the Last Timesheet Period’s End Date. If the firm lags a little bit on timesheet entries, utilizing this option so that the JTD information being shown in the plan is that of the last timesheet period will most likely work better. Firms can use this option so that the JTD information shown in the plan is as of that last timesheet week. So, for the first few days of the timesheet period, it's not as accurate, but it's more accurate once that timesheet period is posted and closed.

Rescheduling Plans

Vantagepoint Planning is further enhanced with the ability to reschedule plans. The reschedule ability allows users to either shift or change the duration for the labor tab. This is only for the labor tab in Vantagepoint Planning. Users can pick up the entire date range and move the start date or move it to the finish date.

Like Vision Planning, if the duration is the same, the hours can use the same proportions from the time period. When the duration length is increased, it keeps the same pattern. Conversely, when the duration length is decreased, the system can respread it evenly. But, if the duration shrinks, the system will not like it if unplanned hours fall outside the new duration. In Vantagepoint, this becomes very clear with well-written error messages that pop up for the user.

Change Planned Hours

Changing planned hours is a new function in Deltek Vantagepoint. Project managers can use this functionality to update the planned hours in any timeframe. They can choose to spread the hours proportionally or evenly. For example, a user can take all the hours at the project level or work breakdown structure (WBS) level two and change the planned hours from A to B. This can be done in any timeframe. It can also be done backward and forward using the ETC day. There are a lot of options to change planned hours in Vantagepoint Planning.

The screenshot below shows the new Redistribute Hours menu in Vantagepoint where users can change the planned hours.

VPPlanning-RedistributeHours

Replace Planned Hours with Actual Hours

The next enhancement is the ability to replace planned hours with actual hours. This functionality allows users to choose the replacement of hours for a specific date range or across all dates as well as choose to calculate on a weekly, monthly, or total basis. An example is shown below.

VPPlanning-ReplacePlanwithActualHours

Spread Variance

The ability to spread the variance between planned and actual hours can be done in several ways over the time periods selected. It allows the user to control how they spread the differences between actual and planned as well as choose different date ranges. The date range can be a specific date range, an entire date range, or just a short amount of time. The project manager can choose to spread the hours including the negatives or just limit to the positive differences. The variance can be spread evenly or proportionately.

The biggest enhancement is that now this setting is directly available in the plans in Vantagepoint as opposed to another menu or area of the system, providing better visibility, as shown below.

VPPlanning-SpreadVariance

Vantagepoint Planning is Reimagined for Project-Based Firms

With these enhancements to Vantagepoint Planning, project-based firms can not only quickly create project plans but adjust them to the unpredictable nature of the projects. It’s the right project management tool to control project delivery. Do you want to see these Deltek Vantagepoint Planning enhancements in action? Use the button below to see Rana Blair demonstrate each of them.

 

Link to learn the differences between Deltek Vision and Vantagepoint planning

Red Flags There’s an Accounting Problem

Posted by Nicole Temple on February 16, 2022
2022-RedFlags Accounting Problem-03

 

The month-end closing process is a very important practice for the accounting department at professional services firms. Part of the close process is to ensure that one can document and justify the balances on the financial reports. This involves either keeping spreadsheets and/or printing multiple reports and ‘ticking and tying’ the balances. These processes take time and increase the chance of errors.

To assist accounting departments at professional services firms with verifying commonly used balances, Deltek has created some useful tools. There are two such tools in Vantagepoint that accountants can use to monitor activity and know when to raise the red flag to address accounting problems. So, what do these tools look like and how do they benefit accounting?

Financial Analysis Report

The financial analysis report (Analysis/GL Reconciliation/File Reconciliation Report) provides a big picture of the general from the standpoint of the firm’s income statement and balance sheet vs. the supporting sub-ledger reports. Deltek Vantagepoint has implicit entries that happen automatically in transactions based on configurations as well as explicit entries which occur by user entry in the transactions.

For example, when entering an AP voucher, the user selects the expense account (explicit entry) for the voucher but does not select the Accounts Payable account (implicit entry) – the Accounts Payable account is captured in the AP Liability code (which is set Settings/Cash Management/Accounts Payable/Liability Accounts).

The areas covered in the Financial Analysis are:

  • Accounts Receivable Accounts (Set in Settings/Billing/Accounts Receivable) = Open Accounts Receivable (My Stuff/Reporting/AR Aged)
  • Accounts Payable Accounts (Set in Settings/Cash Management/Accounts Payable/Liability Accounts) = Open Vendor Balances (My Stuff/Reporting/Voucher Ledger)
  • Unbilled Revenue Accounts (Set in Settings/Accounting/Revenue) = Office Earnings Report or Project Earnings Report (My Stuff/Reporting/Office Earnings or Project Earnings)
  • YTD Revenue Accounts (Set in Accounts/Chart of Accounts/Type) = Office Earnings Report (My Stuff/Reporting/Office Earnings)
  • YTD Reimbursable/Direct Expense one report that can be used is the Project Detail to total direct and reimbursable expenses.
  • YTD Indirect Expenses one report that can be used is the Project Detail to total indirect and expenses.

The reports listed above can be run to verify the balances on the sub-ledger, and the Financial Analysis Report will provide a professional services firm with a quick snapshot to know if there is a problem immediately. It is recommended to review this report as part of month-end processing, although it can be reviewed at any time during the month.

 

Upon viewing this report for the first time, looking for the differences in AR, AP, revenue, and unbilled of when the out of balance initially began is the first step. There are several reasons an out of balance can occur - for example, making a journal entry directly to a GL account that is linked to an AP Liability Code. Once red-flagged by this report, working with a knowledgeable system consultant to determine which entries caused the out of balances and learning how to correct them is advisable.

Bank Reconciliation

Another critical month-end activity is reconciling the bank account. However, with phishing and echeck technology, it is recommended that bank reconciliations be performed at the very least weekly, if not daily. Vantagepoint allows a professional services firm to create ‘Bank Codes’ for every bank account used by the firm. Each ‘Bank Code’ is linked to a single general ledger account number to track and report transactions for the bank code.

The bank reconciliation process allows for the user to ‘clear’ transactions as they ‘clear’ in the bank. The transactions that show in the bank reconciliation are only those that are entered via a cash transaction type (Cash Receipt, AP Disbursement, Cash Disbursement, AP Vouchers, AP Payment Processing or Expense Payment Processing). The reviewer will know if the transaction type is a ‘cash’ transaction type as they will be asked for a ‘bank code.’              

Any transaction entered against a General Ledger account that is linked to a Bank Account code that is not a cash transaction, for example, a journal entry, will not be available in the Bank Reconciliation feature and could cause a difference from the reconciled bank balance to the general ledger account balance if not added to the misc. tab of the bank rec.

When working through the bank reconciliation process each accounting period it is recommended to compare the “reconciled GL balance” on the printout of the bank reconciliation to the balance sheet GL account that is tied to the bank code. The calculations on the bank reconciliation report are:

02-16-22 Red Flags Blog Image

 

If the reconciled GL balance does NOT tie to the trial balance, research is needed to find the entries that caused the out-of-balance and correct them. Here is another red flag that can help accounting address problems.

An out-of-balance between the reconciled GL and balance sheet can happen and can still show that the bank reconciliation ties to what was deposited and paid from the bank. This is because the reconciled GL is a calculated balance of cash transaction types and not a balance from all transactions being entered against the GL account. Internal processes should be set up so that all cash-related transactions are entered via a cash transaction type.

Close Efficiently and Effectively

Accounting departments at professional services firms need to have efficiency in their month-end closings. Justifying balances on financial documents is a crucial component of closing out the month. With both the Financial Analysis Report and Bank Reconciliation tools offered in Deltek Vantagepoint, accountants can quickly identify red flags in their accounting processes allowing for expedient and effective resolution of accounting problems.

CTA Bank Reconciliation

Latest Posts