Notion Time Tracking Template for Billable Hours

Notion Time Tracking Template for Billable Hours

Freelancers and consultants live and die by billable hours, yet most time-tracking apps feel disconnected from the place where the actual work happens. If you already plan projects and manage clients inside Notion, it makes sense to log your hours there too, so a single workspace ties tasks, time, and invoices together. The free Notable Dashboard is a practical starting point for exactly this. It ships with a Tasks & Projects database and a Financial Tracker database, and with a few thoughtful adaptations you can turn those into a system that logs time entries, totals hours per client, and calculates what each of them owes you.

This guide walks through how to repurpose the dashboard’s existing structure for billable time. Nothing here requires a paid plan or a plugin marketplace, and everything is grounded in fields the template already has.

Start With What the Notable Dashboard Already Gives You

The dashboard is built around one principle worth understanding before you customize anything: it is essentially a handful of databases surfaced through multiple linked views, filters, and rollups. The Quick Stats row at the top, for example, does not hold numbers you type in. Each stat, including Monthly Revenue, is a filtered or rolled-up view of a linked database. Monthly Revenue specifically sums the Amount ($) field of the Financial Tracker wherever Type is set to Income for the current month.

Two databases matter for billable work. The Tasks & Projects database carries fields for Name, Status, Due Date, Priority, Progress, a Project category, Tags, and Assigned To. The Financial Tracker database carries Name, Amount ($), Date, Category, Type (Income, Expense, or Investment), Status, and Notes. Between them you already have most of the raw material for a time-and-billing workflow. What you add is a lightweight way to record durations and rates, then let rollups do the arithmetic.

Adapting Tasks & Projects Into a Time Log

The cleanest approach is to treat each row in Tasks & Projects, or a dedicated copy of it, as a single time entry rather than a broad task. One row equals one session of work you intend to bill.

Fields to add

Alongside the existing fields, create a small number of new properties:

• Duration — a Number property holding hours worked, entered as a decimal such as 1.5 for ninety minutes. This is the single most important field to add.
• Billable Rate — a Number property for your hourly rate. Keeping it per row lets you charge different rates for different clients or types of work.
• Billable Amount — a Formula property that multiplies Duration by Billable Rate, so each entry shows its own value automatically.

You can lean on fields that already exist for the rest. The Date field records when the work happened. The Project property, which the template ships with categories like Marketing, Sales, Management, and Finance, can be relabeled or extended to represent clients instead, or you can convert it into a Relation that links each entry to a client. The Status field lets you mark an entry Not started, In progress, or Done, which doubles nicely as a way to flag whether time has been invoiced yet. Tags and Priority remain useful for filtering.

Totaling hours per client

Once entries carry a Duration and a client link, a linked-database view grouped by client gives you running totals. If you connect entries to a client database through a Relation, a Rollup property on the client side can sum every linked Duration to show total hours, and a second rollup can sum Billable Amount to show what is owed. If you prefer to stay within one database, a board or table view grouped by the Project or client field, with a sum shown at the bottom of the Duration column, achieves much the same thing without extra setup.

Connecting Time to the Financial Tracker

The reason to keep this inside the Notable Dashboard rather than a standalone tracker is that the Financial Tracker turns billed time into revenue you can actually see. When an invoice goes out, create a Financial Tracker row with the Amount ($) set to the billable total, the Type set to Income, and a Category such as Client Payment, Client, or Freelance. Because the dashboard’s Monthly Revenue stat already sums Amount where Type is Income for the current month, your invoiced hours flow straight into the headline number at the top of the dashboard.

Use the Status field on that row, Completed or Pending, to distinguish invoices you have sent from payments you have received. The Notes field is a good place to reference which time entries or date range the invoice covers, so your billing stays auditable months later.

The Honest Limitation: Notion Has No Native Timer

It is worth being direct about this, because a lot of guides gloss over it. Notion does not include a built-in stopwatch or timer. There is no button that starts counting when you begin work and stops when you finish. That means you have a few realistic options for capturing duration.

• Manual entry. Note your start and stop times, or simply the elapsed hours, and type the decimal into the Duration field. This is the most reliable method and needs nothing beyond the template.
• Start and end timestamps. Add two Date properties with time enabled, then a formula that calculates the gap between them. This is more precise but relies on you remembering to record both ends.
• A third-party timer that syncs. Several external time-tracking tools connect to Notion through its API or automation services, pushing tracked sessions into your database. This gets you closer to a true timer, at the cost of adding a tool outside Notion.

None of these is a dealbreaker, but knowing the constraint up front saves frustration. For most solo consultants, disciplined manual entry at the end of each work block is accurate enough and keeps the system simple.

Putting It Into Practice

Start small. Duplicate the free dashboard, add the Duration, Billable Rate, and Billable Amount fields to Tasks & Projects, and repoint the Project field at your clients. Log a week of real entries, then build the grouped view and the Financial Tracker link once you trust the data. You can explore the underlying structure by grabbing the free Notable Dashboard template and adapting it as described above. The value compounds quietly: every hour you log is one you can defend on an invoice, and every invoice feeds the same revenue view you already check each month.

Sources & further reading

• Notion Help: Formulas
• Notion Help: Relations and rollups