WEEKORA: Timesheet Template for Google Sheets

WEEKORA is for people whose time goes to several projects or clients and who need to show where it went. You log each block of work with a start and an end; the sheet works out the hours, prices the billable ones at the project's rate and summarizes the week by day and by project. It is a timesheet template for Google Sheets, a free .xlsx download that also opens in Excel. It suits freelancers, consultants and small teams that report hours per project.

A weekly timesheet template for Google Sheets by project

The Entries tab has one row per block of work: date, project, task, start, end, break in minutes, hours, billable and notes. Hours are calculated with MOD(end - start, 1) * 24 minus the break, so a block that runs past midnight still comes out right. The project comes from a dropdown fed by the Projects tab, where each project has a client and an hourly rate. Mark a row as billable and its amount is hours times the project rate; non-billable rows show in grey and add nothing. Blocks longer than six hours shade amber as a reminder to check for a missing break.

Billable hours and amounts per project

On the Week tab you type the Monday of the week. A by-project table lists every project with its client, hours, billable hours and amount for those seven days, using SUMIFS limited to the week, so entries from earlier weeks stay in the log without being counted. Above it, the week shows total hours, billable share and billable amount: what an invoice or a weekly report needs.

Daily totals in the weekly timesheet

The same tab gives one row per day, Monday to Sunday: hours, billable hours, billable percentage and amount, with a total row. Days over eight hours shade amber and weekends shade grey. Fourteen sample entries over four projects, two of them from the week before, show the week filter at work before you replace them.

How to fill in the timesheet template

1. List your projects, clients and hourly rates on Projects.
2. Log each block of work on Entries with its start, end and break.
3. Mark whether each block is billable.
4. Type the Monday of the week on Week.
5. Copy the totals by project into your invoice or weekly report.

A Google Sheets timesheet template in eleven languages

WEEKORA is available in eleven editions with translated tabs and headings and local time, date and currency formats; the formulas are identical. The opening guide covers opening the .xlsx. For a pay-period timesheet with overtime split out, use BIHORA, the biweekly timesheet; invoices themselves can be built in INVIX. More sheets are under HR and time tracking templates.