• Project & Time Tracker for Google Sheets and Excel, dashboard shown on a tablet
  • How it works: enter data, statuses update, read the dashboard
  • Feature: Budget used and deadline flags
  • Feature: Unbilled work in the time log
  • Feature: Hours per month and KPIs
  • What is included: sheet list, example edition and blank edition
  • Settings, colour key and printing
  • Start Here guide opens the file
  • Frequently asked questions
  • Part of a set of five Hornbeam trackers

Template · Google Sheets + Excel

Project & Time Tracker

Every hour you forget to bill is money left on the table. Log hours per project and see what is still unbilled.

$9one-time

One-time payment. Checkout and receipt by Polar. You receive the files straight after checkout.

  • Example edition and blank edition
  • One-time payment, no subscription
  • Google Sheets and Excel 2016+

Tour

See it in 15 seconds

A silent 15-second walkthrough, recorded from the real file with sample data.

Features

What it does

Time log

Date, project, task, hours and billable or billed, one row per session.

Rates per project

Each project uses its own rate, or your default rate.

Projects tab

Hours logged, budget used %, billable and unbilled amount, deadline flags.

Dashboard

Hours this week and month, billable this month, unbilled total and a monthly chart.

Rate calculator

Bonus tab: your minimum hourly and day rate.

What is included

Two editions, one set of tabs

You get two .xlsx files with identical formulas, charts and layout. Open the example edition to explore, or the blank edition to start clean.

Example edition

Filled with sample data (rows marked EX-) so you can see every dashboard and flag working. Delete the EX- rows or switch to the blank edition when you are ready.

Blank edition

The same file, empty and ready for your own data. Capacity: 100 projects and 1,500 time entries. Copy the last row down if you need more.

TabWhat it is for
Start Here5-minute guide and colour key
DashboardKPIs, monthly table and chart
SettingsCurrency and default hourly rate
ProjectsRate, budget hours, status, deadline
Time LogOne row per work session
Rate calculator BonusYour minimum hourly and day rate

There is no timer: you enter hours after each session and the sheet does the math.

Compatibility

Works where you already work

AppSupport
Google SheetsYes. Upload the .xlsx to Google Drive, then right-click and choose Open with Google Sheets. A free Google account is enough.
Microsoft ExcelExcel 2016 or later opens the .xlsx directly.
Macros and add-onsNone. Plain formulas, dropdowns and charts.
Other appsNumbers, LibreOffice and similar apps are not officially supported.

FAQ

Questions about Project & Time Tracker

Is there a timer?

No. You enter hours after each session; the sheet does the maths.

Can each project have its own rate?

Yes. Leave it empty to use your default rate.

Excel or Google Sheets?

Both. Excel 2016+, or upload the .xlsx to Google Drive and open with Google Sheets.

How many entries fit?

100 projects and 1,500 time entries. Copy the last row down for more.

Can I edit the formulas?

Yes. Excel: formulas locked, no password. Google Sheets: add protection via Data › Protect ranges.

Is there a subscription?

No. It is a one-time payment, with free updates for this version.

Can I use it for my clients' work?

Yes. Use it to run your own business, including work you do for clients. Please do not resell or share the files.

How do payment, receipts and refunds work?

Checkout is handled by Polar, our merchant of record, which also issues your receipt. For refunds, Polar's terms apply. If a file does not work, we will fix it or refund you.

Get the Project & Time Tracker.

One-time payment, instant download. A tracking tool, not accounting, tax, legal or financial advice.

$9Buy now