Skip to content
Monthly Timesheet cover: a sample sheet with hours logged, hours planned and billable hours and a bar chart, beside the Dashboard, Daily hours and Summary tabs

Monthly Timesheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Monthly Timesheet is for someone who tracks time by project across a whole month, such as a contractor, a consultant or a team lead covering several workstreams. On the Daily hours tab, projects run down the side and the days of November 2026 across the top, and totals close every row and every day. The Summary tab holds the planned and logged hours per project and the hours left, and the dashboard totals these and breaks them down by project.

Set the planned hours on the Summary tab before the month starts, so the Left column shows the room you have. Type hours into the grid as the day goes, and leave weekends blank so the totals stay honest. At month end, copy each project total into the Logged column, then compare billable and internal time before you send the sheet to a client or a manager.

Useful for

  • Record a month of project hours for a client invoice
  • Compare planned and logged time for each workstream
  • Show a manager how much time went to internal training

What's included

  • 4 tabs: Dashboard, Daily hours, Summary, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Daily hours: a grid
  • Summary: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Daily hours tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Can I log half hours and quarter hours?

Yes. Type 0.5 for half an hour and 0.25 for fifteen minutes. The row and column totals add decimals in the same way, so a project that took two hours and fifteen minutes shows 2.25 in its total.

How do I reuse the sheet for a different month?

Copy the file, change the month in the Daily hours title and clear the values in the grid. Change the day columns if the new month has a different number of days, such as thirty-one for December. Keep the project names so the Summary still matches.

Why do the Summary totals not update from the grid?

A grid on one tab cannot feed formulas on another tab in this template, so the Logged column on the Summary tab is typed in. Copy each row total from the Daily hours tab across once the month is finished, and the dashboard will show the new figures.

  • #timesheet
  • #monthly-timesheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More timesheet templates

See all 10

Also in Human resources

All human resources templates
Get this template

Preparing your template…