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.
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.
| Tab | What it is for |
|---|---|
| Start Here | 5-minute guide and colour key |
| Dashboard | KPIs, monthly table and chart |
| Settings | Currency and default hourly rate |
| Projects | Rate, budget hours, status, deadline |
| Time Log | One row per work session |
| Rate calculator Bonus | Your 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
| App | Support |
|---|---|
| Google Sheets | Yes. Upload the .xlsx to Google Drive, then right-click and choose Open with Google Sheets. A free Google account is enough. |
| Microsoft Excel | Excel 2016 or later opens the .xlsx directly. |
| Macros and add-ons | None. Plain formulas, dropdowns and charts. |
| Other apps | Numbers, 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 as described, message us and we will help fix it.
Get the Project & Time Tracker.
One-time payment, instant download. A tracking tool, not accounting, tax, legal or financial advice.


