A timesheet template gives you a consistent place to record when work was done, how much time it took, and what the time was for. Using one carefully makes it easier to review hours, correct misunderstandings, and submit a clear record. Before you begin, check which dates the timesheet covers and whether your workplace or project has specific instructions for recording breaks, overtime, leave, or approvals.
What You’ll Need
- A blank timesheet template, printed or in a format you can edit.
- The dates for the reporting period and your work schedule, if applicable.
- A reliable way to check start times, finish times, breaks, and time spent on tasks, such as a calendar or personal work notes.
- Any instructions about rounding, project codes, breaks, overtime, or approval that apply to your timesheet.
- A calculator if the template does not total hours automatically.
Step-by-Step
- Confirm the reporting period. Find out which start and end dates belong on the form and when it is due. Check whether the period runs by calendar week, pay period, project phase, or another schedule. Write the covered dates at the top before entering hours. This prevents entries from the wrong week being mixed into the record. If you are completing a template for someone else, confirm the period with them rather than assuming it matches yours.
- Enter identifying details. Fill in the requested name, team, department, project, or other identifying fields. Use the name or identifier your reviewer expects, and check spelling and numbers against the relevant records. Include only information the form asks for; avoid adding sensitive personal details to a general timesheet. If a field does not apply, follow the form’s instructions for leaving it blank or marking it not applicable.
- Record each work date separately. Put each day on its own row, using the date format shown on the template. Include days with no work only if the form or your instructions ask you to account for them. Do not combine several days into a single entry just because the total hours are the same. Separate daily records make it easier to check shifts, breaks, assignments, and totals later.
- Write down actual start and finish times. Enter the time you began and stopped work, not the time you planned to work. Use one format consistently, such as 9:00 a.m. and 5:00 p.m., or 09:00 and 17:00. If a shift crosses midnight, make clear which date each part belongs to or follow the template’s overnight-shift instructions. Do not change an entry to match a schedule when the actual time was different; note an approved adjustment according to your workplace process.
- Account for unpaid breaks and interruptions. Record break length in the field provided, using minutes or hours as labelled. If the form asks for paid and unpaid breaks separately, keep them distinct. Do not subtract a break twice: some templates calculate net hours from start, finish, and break fields, while others ask you to enter the net hours directly. If you are unsure whether a particular break or interruption counts as work time, check the applicable instructions before submitting.
- Describe the work or assign the correct code. Use the task, client, project, location, or activity field to explain where the time went. Keep descriptions brief but specific enough for a reviewer to understand, such as “inventory count” or “site preparation,” rather than “work.” If a project code is required, copy it carefully and use the same code consistently for the same work. Avoid putting confidential details into a field that may be shared widely.
- Calculate daily hours and totals. If the template has formulas, enter information only in the intended input cells and check that the calculated result looks reasonable. For a manual calculation, subtract the unpaid break from the elapsed time between start and finish. For example, 9:00 a.m. to 5:00 p.m. is eight elapsed hours; subtracting a 30-minute unpaid break gives 7.5 hours worked. Add daily hours to get the period total, and keep regular, overtime, leave, or other categories separate when the form provides separate fields.
- Review, sign, and submit the record. Compare dates and times with your notes, calendar, schedule, or other permitted records. Check that there are no duplicate dates, unexplained gaps, incorrect codes, or arithmetic errors. Complete any employee confirmation or signature field, then send or hand in the timesheet using the required process. Keep a copy or note of the submission date if that is allowed and useful for following up.
Timesheet Template
Use this generic layout as a printable daily record. Add rows or copy the table for the full reporting period. If your organization uses different categories or approval steps, adapt the headings to match its instructions before entering time.
| Date | Start | Finish | Unpaid break (minutes) | Task or project | Hours worked | Notes | Initials or approval |
|---|---|---|---|---|---|---|---|
| Period total |
Sample entry — fictional example: On 12 May, Jordan Lee records a start of 9:00 a.m., a finish of 5:00 p.m., a 30-minute unpaid break, the task “stockroom labeling,” and 7.5 hours worked. These names and details are made up to show how one row might be completed. The sample is not a rule for deciding which breaks count as work time; use the instructions that apply to your situation.
Common Mistakes
- Entering scheduled hours instead of actual hours: A planned shift and the time actually worked may differ. Record actual times and use the approved process to explain changes.
- Using inconsistent time formats: Mixing 12-hour and 24-hour times can make entries ambiguous. Choose the format requested and include a.m. or p.m. when needed.
- Forgetting to record breaks: An omitted break can make the total inaccurate. Check the break field for each applicable day and make sure it is not already accounted for by a formula.
- Adding time to the wrong date: Overnight work and shifts near a reporting-period boundary need careful date handling. Follow the template’s instructions for allocating those hours.
- Rounding without checking the rules: Do not round each entry just for convenience. Use the stated rounding method, if there is one, and apply it consistently.
- Leaving unclear task descriptions: Entries such as “project” or “admin” may not tell a reviewer what the time relates to. Use a concise description or required code.
- Overwriting formulas or leaving required fields empty: In an editable form, typing into a calculated cell can break totals. Confirm which cells are for input and complete required signature or approval fields.
Tips
- Record time soon after each shift or task while details are fresh, rather than trying to reconstruct a whole period at the deadline.
- Keep brief notes during the day if work moves between projects. You can transfer the notes to the official form later, while preserving the correct dates and time amounts.
- Use one row for each date and, when the form allows, separate rows for distinct projects or activities. This makes the record easier to review without changing the total.
- Before using a blank template repeatedly, make a clean copy for each reporting period. Keep the original version empty so that old entries are not accidentally carried forward.
- For a printed sheet, write legibly and leave enough room for corrections or reviewer comments. For an editable version, save a working copy with a clear period in its filename.
- Make corrections in a transparent way. Follow the required correction or resubmission process rather than hiding an original entry or changing an approved record without explanation.
- Ask the reviewer what level of task detail is useful. A short, consistent label can be clearer than a long description that includes unnecessary or sensitive information.
Troubleshooting
The total does not match the time between start and finish. Recalculate the elapsed time, then subtract the break only if the template expects you to do so. Check whether you entered a.m. and p.m. correctly, used minutes rather than hours in the break field, or crossed midnight. If the form calculates totals automatically, inspect the input cells and avoid typing over formula cells.
The spreadsheet shows an error or a blank total. Confirm that times are entered in the format the template recognizes and that required date or hour fields are not missing. A cell may treat a typed time as plain text instead of a time value. Try selecting the intended time format or re-entering the value according to the template’s directions. If the calculation still fails, save a copy of your entries and ask the form’s owner for an unmodified template.
You forgot a shift or entered the wrong date. Do not quietly alter a submitted or approved record. Contact the person responsible for reviewing it and ask how to submit a correction. Provide the correct date and time details, explain what needs changing, and retain the updated copy or confirmation according to the normal process.
You are unsure how to classify a break, absence, or extra hours. Check written workplace or project instructions and ask the designated supervisor or timesheet reviewer before guessing. Rules can vary by location and work arrangement. For questions about local wage, record-retention, or payroll requirements, ask a qualified payroll or legal professional.
The form has no room for your situation. Do not squeeze several kinds of time into one field if that would make the record unclear. Add a clearly labelled page only if the recipient accepts attachments, and identify the reporting period on it. Otherwise, ask for the correct version of the form or instructions for recording the exception.
Frequently Asked Questions
What should I include on a timesheet?
Usually, include the reporting dates, identifying details requested by the form, actual start and finish times, applicable breaks, task or project information, hours, and any required confirmation or approval. Follow the specific template instructions if they differ.
How do I calculate hours worked?
For a straightforward shift, subtract the start time from the finish time, then subtract any unpaid break that the form requires you to exclude. For instance, 8:30 a.m. to 4:30 p.m. is eight elapsed hours; a 30-minute unpaid break leaves 7.5 hours. Use the template’s rules for overnight shifts or other categories.
Should I fill in days when I did not work?
Only if the template or the person reviewing it asks you to account for every day. Some forms expect blank non-work days; others need a zero, leave entry, or another category. Check the instructions rather than assuming.
Can I use a timesheet template for project work?
Yes, if it has space for the relevant project or task information and the recipient accepts that format. Add a project code or separate activity rows when required, and make sure each entry still shows the date and time clearly.
What if I notice an error after submitting?
Tell the reviewer promptly and ask for the correction process. Give the accurate details and avoid silently replacing a submitted record unless you have been instructed to do so. Keep the corrected version or confirmation if the process calls for it.
Do I need to keep a copy?
Keeping a copy can help you answer questions about an entry, but follow any instructions about storage, privacy, and record retention. Store personal work records securely and do not keep information you are not authorized to retain.