Fascinating Facts about Timesheets in Deltek Vision
For project-based firms, timesheets are essential to ensure that an employee’s time is reflected to a specific project. I’m sure you already knew this, but do you manage timesheets correctly in Deltek Vision? Here are some facts and best practices for different scenarios to help you better manage timesheets in Deltek Vision.
Intro to Timesheets in Deltek Vision
Hopefully, one of the first things your Deltek Vision Consultant explained to you about timekeeping is that timesheets create payroll cost not payroll. As a “nuts and bolts” accountant, at least one side of our brain struggles with processing this information. So let’s break it down:
- The employee’s job cost rate on the accounting tab of their info center should represent their rate of pay. If they are true hourly, this is quite easy to determine. On the other hand, if they are salaried the hourly rate should reflect their annual salary divided by 2080 hours.
- If adjusted salary job costing is used, the amount should reflect their salary based on the configured interval. For example, weekly, biweekly or a set number of days.
How Timesheets Work
When a timesheet is posted an amount based on the hourly rate multiplied by the hours charged is applied to the selected projects. Thereby creating direct or indirect (overhead) labor/payroll cost in the General Ledger. The credit created by the timesheet can go to either one of two places:
- The Income Statement as job cost or payroll variance - This account is an overhead line item used to adjust the total of the timesheet posting to the actual payroll distributed. Furthermore, amounts that remain in this account after the payroll journal entry has been entered reflect a net of uncompensated overtime (OT) for salary staff (negative amounts), and based on this process, the premium portion of OT for hourly staff (positive amounts).
- The Balance Sheet as a payroll liability - After the payroll journal entry has been entered, the remaining amount needs to be reclassified to the Income Statement as stated above.
Accounting Tip for Paid Time Off
Have you ever noticed your Paid Time Off (PTO) balance not being relieved even during peak vacation periods? You might want to consider booking PTO taken to the Balance Sheet. To do this, you need to configure timesheet postings for PTO to go to a PTO liability account. Then when time off is taken and posted, the debit entry reduces the liability. Based on a true computed liability, an entry can be made on a pre-determined interval to accrue additional PTO and book the expense. If you are using benefit accruals in Vision, the entry can be taken from that report.
Handling Leave without Pay
Many firms fail to account for leave without pay (LWOP) properly. Sure, there is a need to track hours for statutory purposes when employees are on leave, however, no payroll cost should be recorded. The simple fix is to enable cost rate tables and attach one to LWOP projects. The table should contain either a labor code(s) or a list of employees with a ZERO job cost rate. This will override the employees default job cost rate and avoid any recording of payroll costs.
Punch the Clock
Some of this might seem complicated at first, but these best practices should help keep your books in order. I hope that this has taken the mystery out of Deltek Vision timesheets. Now punch the clock and update your timesheets.



Creativity, when used in the accounting world, is usually considered a “no-no”. However, I am not talking about misrepresenting the state of affairs. In fact, I am talking about the exact opposite - providing the client exactly what you told them to expect at the beginning of the proposal process. Let’s take a look at how setting client expectations early can improve your firm’s cash flow.
Most firms that I work with utilize independent contractors to supplement their workforce. This isn’t a blog about “walks and talks like an employee, must be an employee.” For that, I recommend a good labor attorney. However, what I am going to clue you in on is about the proper way to track and account for independent contractor’s time in Deltek Vision.
You know you have spent your whole workweek devoted to a specific project, but you’re only showing 35 hours being billed/charged to the project. Where did the value of those 5 hours go? In many cases, these missing hours can be attributed to non-billable labor, and many AEC firms overlook the importance of documenting how this time is spent. However, accurately accounting for non-billable labor is extremely important to track accurate project performance.
Professional service firms don’t traditionally sell products; rather they sell their time and expertise. Increasingly, they ARE selling products and time, and are spending a great deal of capital on tools to deliver both.
Marketing and finance often seem destined to clash. The common misconception is that marketing’s sole purpose is to spend money, while finance does everything in their power to throw up hurdles to spending. Marketing focuses on building quality relationships and creating brand equity, while finance has an, admittedly sometimes myopic, focus on hard numbers and empirical evidence. Let’s examine how we can help marketing better communicate with finance and bring these two opposite ends of the spectrum together!
I recently sat down with 
D
I don’t know of a single Professional Service firm without a formal contract management process. Firms spend significant dollars purchasing contract templates and some even retain legal counsel for review. Everyone knows that the contract is an important document in any project undertaking.
As a virtual employee I often have a computer within arm’s reach. The need to access Deltek Vision on a mobile device has largely been non-existent for my work situation. However, recently I attended back-to-back conferences and I quickly found myself behind on my timesheets and desperately needing to submit an expense report. So one afternoon, as traffic died down while manning a tradeshow booth, I decided to install the Deltek Touch Time and Expense app on my phone.