As I was updating my timesheet templates this week, I got curious to know how people are using them in their businesses. I don’t mean how they actually edit the spreadsheets, but rather how they integrate them into their payroll and time management systems.
I think it would be very helpful to others to know some tips or tricks about how YOU use the timesheet templates. I’m going to delete any comments that say “I don’t actually use a spreadsheet, I just use a web-based time sheet service”. That’s not the purpose of this post. Instead, I’d like to know how people are using the timesheet templates that they download from Vertex42.com.
- Do you just print paper copies?
- Do you have your employees email you the completed timesheet?
- Do you actually require signatures?
- What do you use to keep track of the hours?
- Does using the timesheet template really work for you, or are you only using it to avoid paying for some other service?
- What would make it easier or more useful?
How Does Vertex42 Do It?
I recently added some information to the basic Timesheet Template page explaining “How to turn the timesheet template into an online timesheet solution“. In a nutshell, I’ve uploaded the timesheet to Google Docs and shared it with an employee so that they can update it online. Then, I can process the payroll without ever having to deal with paper or getting sent copies of timesheets via email.
After I’ve recorded the hours in my payroll spreadsheet, I clear the timesheet and update the date. [edit: meaning that i delete the times/hours that the user entered into the timesheet, so that the user can start with a new blank time sheet]. That is the signal that lets the employee know that they can start updating the hours for the following pay period. I’ve been doing this since I became an employer, and haven’t had any problems yet.
I’m using a slightly modified version of the Biweekly Timecard so that I can see the hours worked based on specific projects. I don’t bother with the signatures.
How Do You Do It?
Now it’s your turn … how are YOU using the timesheet templates?
Looking forward to your responses,