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.
It would be very helpful to others to know some tips or tricks about how YOU use the timesheet templates.
- 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 Vertex42 Uses a Timesheet Template
I've added some information to the basic Timesheet Template page explaining how to use the timesheet template as an online timesheet solution. In a nutshell, here is what I do:
- Customize the template for a specific employee
- Upload the timesheet to a secure cloud and share it with the employee (Google Drive, OneDrive, Dropbox, etc.)
- Have the employee update it online.
- Save a backup copy at the end of each week.
At the end of each week, I can process the payroll without ever having to deal with paper or getting sent copies of timesheets via email.
After recording the hours in my payroll spreadsheet, I clear the timesheet and update the start 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?