Full Sail Partners Blog

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!