How to Make a Timesheet

Step-by-Step Guide

1. 1

   Step 1: Create a document in your word processor.

   Put the name of your business at the top and add your business's logo if you have the file available.
2. 2

   Step 2: Add lines for your employees to enter their names

   , Some word processors allow you to open a spreadsheet within the document and will provide the appropriate menus for you to create and format the worksheet. ,, For instance, you can enter regular hours, overtime hours, sick and vacation pay.
   
   Label the last column for the total number of hours worked per day.
   
   You can also create separate columns to record hours of work completed on specific projects or for specific clients. ,, If compensation is confidential and someone other than the bookkeeper and the employee's supervisor will see the time sheet, leave this row off or instruct your employees not to fill in this row. ,,, Most software bundles allow you to send the spreadsheet to the other document and will trim and size the spreadsheet to fit.
   
   If not, you must adjust the size of the rows and columns to make the spreadsheet fit. ,, It may be helpful to use a yellow highlighter to write "ORIGINAL" across the master copy so employees won't use it, forcing you to print out another copy. , Be sure to protect the original file so your employees cannot use or corrupt it. ,,, Specify that these cells cannot be altered, but that your employees can fill out other cells. ,
3. 3

   Step 3: the dates the time sheet covers and other information

4. 4

   Step 4: such as their supervisors' name.

5. 5

   Step 5: Open your spreadsheet program.

6. 6

   Step 6: Along the left side of the spreadsheet

7. 7

   Step 7: enter the days of the week.

8. 8

   Step 8: Label the top of each column for the categories of work you pay your employees for.

9. 9

   Step 9: Designate a row at the bottom of the spreadsheet for the total number of hours worked in each category.

10. 10

    Step 10: Add a row

11. 11

    Step 11: if you prefer

12. 12

    Step 12: for an employee to enter her hourly rate for regular hours

13. 13

    Step 13: leave and overtime.

14. 14

    Step 14: Finish with a row for total hours multiplied by the pay rate for each category of work and a cell for the week's grand total

15. 15

    Step 15: which will be the employee's gross pay.

16. 16

    Step 16: Improve the look of the spreadsheet by using bold print for the labels and shading in the label rows with color.

17. 17

    Step 17: Cut and paste the spreadsheet into your word processor document.

18. 18

    Step 18: Include lines below the spreadsheet for the employee and supervisor to sign

19. 19

    Step 19: verifying that the hours listed are accurate.

20. 20

    Step 20: Save and print the document

21. 21

    Step 21: make copies and hand them out to your employees.

22. 22

    Step 22: Invite your employees to keep their time sheets on the computer by making a copy of the file available on your network server.

23. 23

    Step 23: Use the spreadsheet's quicksum or autosum feature to have the program add up the number of hours in each row and column and enter the result in the total row and column.

24. 24

    Step 24: Create a formula or function to multiply the total hours for each category of work by its pay rate

25. 25

    Step 25: and use the quicksum and autosum feature to determine the grand total for the week.

26. 26

    Step 26: Find the spreadsheet feature that allows you protect your time sheet's labels and formulas from being edited or erased.

27. 27

    Step 27: Insert the spreadsheet into the word processor document and test it to make sure that it will recalculate automatically after an employees fill it out.

Detailed Guide

About the Author