Marketing Agencies

Agency Project Profitability

Track time and team rates to see real margin on every project. Auto-calculated cost, margin %, and Profitable / Thin / Underwater status pills. Spot underwater projects before they sink the month.

What's Inside

Start Here — How rates link to Time Log, what the margin math is, and tips on quoting.
Time Log — One row per time entry. Person, Date, Project, Hours.
Team Rates — Hourly rate per person — the multiplier behind every cost calculation.
Project Summary — One row per project with Quoted Price + auto-calculated Total Hours, Cost, Margin $, Margin %, and Status pill.
Dashboard — Snapshot (Total Revenue, Cost, Margin, Avg Margin %, Billable Hours), Project Margin Breakdown table, Hours-by-Person column chart.

Key Features

Per-project Cost = Σ(Hours × Person's Rate), auto-calculated from Time Log + Team Rates.
Margin % auto-calculated. Status pills: Profitable (≥20%), Thin (0-20%), Underwater (<0%).
Underwater projects called out in red — early warning before they ship the quarter.
Hours-by-Person chart shows where capacity is going.
Average effective rate across the agency surfaced as a tile.
Time Log keys off person name = Team Rates name — one place to update.

Sample Formulas

Here are some of the formulas powering this template:

Per-project cost (hours × rate, lookup per person)

=SUMPRODUCT(('Time Log'!A2:A=A2)*'Time Log'!D2:D*IFERROR(VLOOKUP('Time Log'!C2:C,'Team Rates'!A:B,2,FALSE),0))

Margin %

=(C2 - E2) / C2

Status pill logic

=IF(G2>=0.2,"Profitable",IF(G2>=0,"Thin","Underwater"))

Get this template free

Enter your email and we'll give you instant access to copy this template into your Google Drive.

You're in.

Click below to copy this template into your Google Drive. Check your email for setup instructions.

Make a Copy

Need this connected to your time tracker?

We build custom profitability systems that sync with Harvest, Toggl, or Clockify — real-time margin tracking with automatic rate calculations and budget alerts.

Start a build