How to Track Time & Billable Hours in Notion

If you bill by the hour, every untracked minute is money left on the table. You don't need a separate time-tracking app — Notion can do it, and because it links to your projects, your logged hours can flow straight into invoices.

Step 1: Create a "Time" database

Add a table with these fields:

• Date — the day the work happened.
• Project — a Relation to your Projects database.
• Task — a text description ("Wireframes", "Call with client").
• Hours — a Number.
• Billable — a Checkbox (untick for admin/unpaid work).
• Rate — a Number (your hourly rate for that project).

Step 2: Add an auto-computed amount

Create a Formula field: if(prop("Billable"), prop("Hours") * prop("Rate"), 0). Now each row shows exactly what that block of time is worth — and the non-billable admin hours show as zero so they don't inflate your invoice.

Step 3: Group by week

Make a board or table view grouped by the Date's week. At the end of the week, you see total billable hours per project. That's your invoice, basically pre-filled.

Step 4: Connect to invoicing

Because Time relates to Projects, and Projects relate to Income, you can build a Rollup that sums billable amounts per project and drops them straight into your income log. One entry in Time becomes one line on an invoice — no double entry.

Prefer it ready-made?

The Time Management database above — with billable flags, auto-amount formulas, weekly views, and project rollups — is included in Freelancer OS. Duplicate it and start the timer (mentally) today.

Related: The Ultimate Notion Project Tracker · How to Track Income & Invoices