Full Sail Partners Blog | Jenny Labranche

Why are the month-end financials so vital to professional service firms? Why does the finance team have deadlines? Understanding the importance of accurate and timely financial reports across all roles in a professional service firm is vital to the organization's health. Let us understand the “what” behind the “why” of the deadlines imposed on us by our friendly finance and accounting professionals. Finance and accounting professionals are often the rule enforcers, the data junkies, and the last group of people we want to disrupt because their head might just pop off their necks. I know, because I was once in that hot seat, constantly “encouraged” to produce accurate reports and metrics, and close the books as soon as possible. Forget about taking a vacation during the first two weeks of the month. Anyone else with me?

So, before we dive into the tools available for our finance friends, I hope that non-finance team members will take a few minutes to read this article and have a better understanding of why monthly financials are so vital to everyone in an organization.  

We plan our lives; we plan our projects but how do we measure that success? It all comes down to the actuals. The actual results of our planning and hard work in every aspect of our lives are how we determine what decisions we are going to make in the future. Logically, the actual financial results of a firm will help drive future decisions, right? So, the next time your finance and accounting friends ask you to submit your timesheet, submit your expense report, review a subconsultant invoice for your project, and review a client invoice for submittal know that they are doing their part to prepare the data necessary for accurate and timely reporting for EVERYONE in the firm. The data gathered and reported on for that financial period may impact your future as well.  

Let us work together to find a better solution to close those books faster, provide better project metrics, and help the firm make quick and accurate decisions.  

Now, moving on to some tips and tricks for our finance friends to help them leverage the most of their Deltek Vantagepoint system. Part of the monthly close process is to ensure that one can document and justify the balances on the financial reports. If your process involves ticking and tying to a manual spreadsheet, STOP! Deltek has tools that can help you!  

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 File Reconciliation Report (Utilities/Analysis/GL Reconciliation/File Reconciliation Report) provides a big picture of the general ledger 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 that occur by user entry in the transactions.

For example, when entering an AP (Accounts Payable) 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 File Reconciliation Report are:

• YTD Revenue: Accounts (Set in Configuration/Accounting/System Settings) Settings/Accounting/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 the indirect and expenses.
• 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 or Voucher Schedule)
• Unbilled Revenue: Accounts (Set in Settings/Accounting/Revenue) = Office Earnings Report or Project Earnings Report (My Stuff/Reporting/Office Earnings or Project Earnings)

The reports listed above can be run to verify the balances of the sub-ledger, and the File Reconciliation 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 (Accounts Receivable), AP (Accounts Payable), Revenue, and Unbilled and 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. Depending on your financial department structure, you could choose to use the Bank Reconciliation tool more frequently than waiting until the month-end. If you do not have systems in place to prevent fraud in your bank accounts, it may be beneficial to review and use this tool weekly or 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 in the bank reconciliation are only those 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:

Beginning Balance (which should agree to the Bank Statement ending balance from the prior month.

• + Cleared Deposits
• - Cleared Payments
• Calculated Balance – this should agree to the Bank Statement ending balance
• + Uncleared Deposits
• - Uncleared Payments
• Reconciled GL Balance – This should agree to the GL account balance on the Trial Balance and Balance Sheet

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.

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. Having a published monthly close calendar will help the entire organization stay on track with timely reporting both on a financial and project reporting level. With both the File Reconciliation Report and Bank Reconciliation tools offered in Deltek Vantagepoint, accountants can quickly identify red flags in their accounting processes.

For more tips and tricks on how to streamline your financial close reach out to one of our friendly financial consultants. One of the most valuable investments a firm can make is ensuring the entire firm gets the most out of its ERP system. Deltek Vantagepoint provides real-time data to help all members of an organization manage their projects, financials, opportunities, resources, and more. Give yourself a break, it is ok not to know what you do not know; Full Sail Partners is here to help!

Approval workflows in Deltek Vantagepoint streamline organizational processes, offering a comprehensive range of features that enhance efficiency and flexibility. From multi-tiered and multi-step approvals to flexible role-based assignments, these workflows cater to complex approval hierarchies and specific organizational needs. Let’s dive into the different features and uses of these workflows and explore how they can make your approval processes smoother and more efficient.

Approval Workflows

Since some readers might be new to approval workflows, let’s review the functions of approval workflows in Vantagepoint.

• Multi-tiered Approvals – Allows approval workflows to have the ability to assign one person or multiple people with approval responsibilities for a specific request.
• Multi-step Approvals – Allows additional steps to be added in an approval workflow.
• Flexible Assignments – Instead of assigning the approval to a person, make the approval assignment to a specific role or function within the organization.
• Reassignments – Quickly reassign an action to add additional approvers or reassign the approval assignment to another person.
• Conditions – Allows for the use condition when approval is required, such as a dollar amount for an expense.
• Actions – Send and receive notifications of an approval request by email or an alert.
• Validations – Allows for notifications when criteria are not met, such as requiring a receipt on an expense report.

Workflow Failure Notifications – Workflows are smart! They will notify the approval administrator if a terminated employee or a role with no employees has been assigned approval responsibilities.

Applications That Have Approval Workflows

Here are some examples of applications that you can apply workflows to:

• Expense Reports
  • Both Line-item approval and Whole Report approval
• Timesheet Approvals
  • Both Line-Item approval and Whole Report approval
• Absence Requests
• AP Invoice Approvals
• Billing Invoice Approvals
• Purchase Requisitions
• Request for Price Quotes
• Purchase Orders (PO’s, Change Orders, and Releases)
• Item Requests

For those of you transitioning from Vision to Vantagepoint and enjoying the flexibility of Expense Report approvals for both line items and the whole reports, you’re in luck because Vantagepoint allows more flexibility in the Timesheet approval process.

Timesheet and Timesheet Line Approval Workflows Overview

In Vantagepoint, with improved Timesheet and Timesheet Line Approval workflows, users can leverage some of the benefits outlined below:

• Approval Workflows that are multi-step and based on specific parameters to align the approval process with your organization’s operations.
• Send approval requests to specific employees or roles within your organization.
• Approve all lines of a timesheet or just approve a specific line.
• Set up notifications to alert people about the status of the approval process and let the approver know a request is pending.  

Are you ready to enable Timesheet and Timesheet Line approvals? If you are not sure, here are some things to think about.

• Does your organization have a defined process for timesheet approvals?
• Which roles and individuals need approval assignments?

Since Deltek has allowed more flexibility in Timesheet and Timesheet Line approvals your firm will benefit from revisiting your current approval process.

Billing Invoice Approvals

Have you evaluated your billing process lately? Are you still printing drafts on paper?

In Vantagepoint, Deltek has introduced a way to process your monthly client invoices through the system including a way to use markup tools on the draft invoice(s).

Starting in Vantagepoint 6.5, you can review multiple drafts up until the final acceptance of the invoice. This “in system” back and forth communication between the finance/billing team and the project manager could help streamline your current process. Reduce back-and-forth emails and get your invoices out faster. Update your approval workflow to send notifications to employees identified on the project records.

Do you need multiple steps in your billing approval process?

While this workflow is not as dynamic as the timesheet and expense workflows there are ways to leverage the comment fields to allow for multiple review steps. For some tips and tricks on this creative solution please contact your Full Sail Consultant.

Enhance Efficiency with Approval Workflows

Vantagepoint's approval workflows provide a comprehensive solution for enhancing efficiency across various organizational tasks. With capabilities like multi-tiered and multi-step approvals, role-based assignments, and real-time notifications, these workflows cater to diverse needs. They are applicable to numerous areas, including expense reports, timesheets, billing invoices, and more, helping streamline processes and improve overall functionality. By implementing these workflows, your organization can achieve smoother operations and better compliance, ultimately boosting productivity and reducing administrative hassle.

Want to see more about approvals? Take a look at our webinar on Deltek Vantagepoint’s Accounts Payable (AP) Invoice Approvals!

Welcome to the matrix, you have the power to build a solid structure and allow your data to flow.  However, it is beneficial for one to understand the difference between Work Breakdown Structure (WBS) and Organizational Breakdown Structure (OBS) before you lay that foundation. During both the implementation of Deltek Vantagepoint and throughout a firm’s growth, professional services firms should understand the connection between the Organizational Breakdown Structure and the Work Breakdown Structure.  

A typical first step is to consider whether the firm needs to re-organize these structures. Whether it be the uniqueness of each, or the relationship between the two, the attention paid to these early stages of development is instrumental to the flow and reporting of information in your Deltek Vantagepoint database. In the following, we’ll explore some areas to consider when designing these structures in your database.  

Organizational Breakdown Structure (OBS)

When it comes to designing the Organizational Breakdown Structure (OBS) in Deltek Vantagepoint, it's important to consider the specific needs of your professional services firm. The OBS can range from simple to complex, depending on the size and requirements of your organization. Here are some examples of different OBS approaches.  

• Location Approach: With this approach, the OBS is organized based on the physical locations of your offices or project sites. Each location represents a hierarchical level in the structure, allowing you to track and manage projects and resources across different geographic areas.  
• Discipline/Department Approach: In the discipline or department approach, the OBS is structured around different functional areas or departments within your organization. This allows for efficient resource allocation, project assignment, and collaboration within specific areas of expertise.  
• Market Sector or Business Development Driven: This approach focuses on organizing the OBS according to your firm's market sectors or business development strategies. Each market sector or business development unit can be assigned a hierarchical level, enabling you to analyze performance and profitability based on these segments.  

Deltek Vantagepoint provides flexibility in designing your OBS, offering up to five hierarchical levels to accommodate your specific requirements. It also allows for the allocation of overhead requirements within the structure of the database. If you plan to utilize the multi-company functionality in your database, it's important to reserve level one for different companies within your enterprise.   

Financial accountability is a crucial aspect of any professional services organization. When building your OBS, it's essential to consider the financial implications. For example, if you use a two-level OBS structure, such as office and department, each combination will generate an income statement. This means that someone within your organization should be responsible for reviewing and managing these statements.  

Deltek Vantagepoint also enables the extraction of various cross-sections for combined financial reporting. For instance, if you have a mechanical department in three offices, you can create a mechanical income statement that provides accountability at different levels:  

• Office Accountability: You can track the financial performance of each individual office separately, gaining insights into the profitability and expenses associated with specific locations.  
• Office/Department Accountability: This level of accountability allows you to analyze the financial performance of different departments within each office. It helps in evaluating the contribution of each department to overall profitability.  
• Overall Department Accountability: By consolidating the financial data of the mechanical department across all offices, you can assess the department's overall performance and make informed decisions regarding resource allocation and strategic planning.  

The OBS in Deltek Vantagepoint offers the flexibility to design a structure that aligns with your professional services firm's needs. By carefully considering the OBS approach, financial accountability, and the ability to generate cross-sectional reports, you can effectively manage projects, resources, and profitability within your organization.  

Projects and the Work Breakdown Structure (WBS)

The Work Breakdown Structure (WBS) is a critical component that determines how a project is organized and how revenue and costs flow within a professional services firm. Most firms find it effective to build their WBS based on project budgets, aligning with the fee and scope defined in the client contract using a bottom-up approach. The best practice is to build your WBS to mirror your contract for smooth management of resources, budgets, and billing.    

Deltek Vantagepoint provides the flexibility to define up to three levels in the WBS, commonly referred to as Project, Phase, and Task. However, these labels can be customized to match your firm's preferences. Furthermore, the WBS allows for the assignment of accountability within a project. You can designate a project manager, as well as phase and task managers, based on their scope and budget responsibilities.  

It's important to note that project builds and WBS structures do not have to be identical across all projects. While each professional services firm may have its own unique requirements, it is generally recommended to have at least one WBS level 2 for every project, indicating another variation in the WBS. Additionally, projects can be built with no WBS level 3 or only certain portions of the WBS level 2 extending into the WBS level 3.  

The OBS and WBS structures function both individually and in tandem to support overall financial and operational accountability within your organization. At the lowest level, the WBS drives how revenue and costs are allocated within the OBS. Here are some additional factors to consider when working with the OBS and WBS structures:  

• "Mirroring" the OBS in WBS for Overhead Projects: For projects involving overhead costs, it can be beneficial to mirror the OBS structure within the WBS. This helps ensure that the appropriate overhead costs are accurately assigned to specific projects, allowing for better cost tracking and financial reporting.  
• Combinations of Cross-Charge, Intercompany Billing, and High Accountability in WBS: Consider how cross-charges, intercompany billing, and high levels of accountability will be incorporated into your WBS. Deltek Vantagepoint offers capabilities to support these requirements, allowing you to accurately allocate costs between different departments, offices, or business units within your professional services firm.  

By carefully considering these aspects of the OBS and WBS structures, you can establish a robust framework for financial and operational accountability within your professional services organization. Deltek Vantagepoint empowers you to customize and tailor the OBS and WBS to meet your firm's specific needs, ensuring accurate project tracking, cost allocation, and financial reporting.  

Is it Time to Update Your OBS and WBS Structures? 

In the ever-evolving landscape of professional services firms, it's crucial to regularly assess and update your Organizational Breakdown Structure (OBS) and Work Breakdown Structure (WBS) in Deltek Vantagepoint. As your business needs change and evolve, it becomes imperative to optimize your system to ensure it aligns with your current requirements. This is where Full Sail Partners can help. There is no one size fits all, and with the guidance of our consultants, we can help you develop a solution.   
 
By combining project attributes, you can create a powerful framework that enables efficient project management, resource allocation, and financial reporting. However, implementing such changes requires expertise and guidance from both functional and data consultants to ensure a smooth transition. We specialize in Deltek Vantagepoint consulting services, including OBS and WBS optimization.  

Our experienced consultants can work closely with your team to analyze your current structures, identify areas for improvement, and design a new and more productive system tailored to your unique needs. Timing and cutover planning are critical to the success of any system update. Our consultants will guide you through the entire process, ensuring that the implementation is seamless, minimizing disruption to your operations, and maximizing the benefits of the new OBS and WBS structures.  
 
Now is the perfect time to get creative and strive to get the most out of your Deltek Vantagepoint system. Don't let outdated structures hold your firm back. Explore the possibilities of a Navigational Analysis and let us help you unlock the full potential of Deltek Vantagepoint and drive efficiency, profitability, and growth within your organization. Learn more about how a Navigational Analysis can help your firm by clicking the image below.