Full Sail Partners Blog
Red Flags There’s an Accounting Problem

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:
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.
Subscribe Here!
Latest Posts
Posts By Category
- Professional Services (222)
- Technology Solutions (156)
- Deltek Vision (125)
- Building Business (107)
- Accounting (92)
- Project Management (88)
- Deltek Vantagepoint (80)
- CRM (64)
- Press Release (62)
- HR (51)
- ERP (50)
- Client Relationships (47)
- Marketing (42)
- Deltek Clarity Report (25)
- Professional Services Firms (23)
- Support (20)
- Employees (18)
- Cloud (17)
- Video (17)
- Deltek Talent (16)
- Mobile (15)
- Business Intelligence (14)
- A&E Firms (11)
- Communication (9)
- Deltek Insight (9)
- Project Based Firms (9)
- Project Information Management (PIM) (8)
- Case Study (6)
- Data Visualization (6)
- Mergers and Acquisitions (6)
- Driving Growth (4)
- Finance (4)
- Connect Add-In (2)
- Resource Management (2)
- Contract Management (1)
- Deltek + ComputerEase (1)
- Human Capital Management (1)
- Outsourced HR (1)
- Project Con (1)
- ProjectCon (1)
- Proposal (1)
- SEO (1)
- business development (1)
- human resources (1)
- password security (1)
Posts by Author
- Amanda Roussel (16)
- Amy Balassone (7)
- Bob Kottmeier (1)
- Brian McNamara (5)
- Cate Phillips (7)
- Charlene Kerr (2)
- Chris Simei (2)
- Dale Busbey (5)
- Evan Creech-Pritchett (8)
- Full Sail Partners (101)
- Gina Stamper (1)
- Heath Harris (3)
- Jeff Robers (5)
- Jennifer Renfroe (64)
- Jennifer Wilson (1)
- Joel Slater (7)
- Katie Sanner (1)
- Kelly Duquette (2)
- Kevin Hebblethwaite (9)
- Lee Frederiksen (1)
- Lindsay Diven (34)
- Matt McCauley (6)
- Michael Kessler, PMP (20)
- Nicole Temple (7)
- Peter Nuffer (3)
- Rana Blair (18)
- Rick Childs (8)
- Ryan Felkel (89)
- Ryan Suydam (10)
- Sarah Gonnella (65)
- Scott Gailhouse (19)
- Scott Seal (12)
- Sean Keller (1)
- Tasia Grant, PHR (13)
- Terri Agnew, CPA (7)
- Theresa Depew (8)
- Timothy Burns (4)
- Tom Vandervort (1)
- Wayne Johnstone (1)
- Wendy Gustafson (17)
- Wes Renfroe (16)