Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Design Agency Time and Billing Tracker

A time and billing tracker for a design studio: a Dashboard with 3 charts, a Time Log and client rates. XLSX with a blank copy.

ForFreelancers

Dashboard tab: Hours 53, Billable 76.7%, Unbilled value $2,673, Effective rate $51; doughnut chart of Hours by client (hours); bar chart of Top clients by hours (hours); column chart of Hours by...Time Log tab: columns Date, Client, Task, Hours, Billable?, Billed?, Rate (auto) ($), Value (auto) ($), Month (auto), Year (auto); 15 sample rows.Settings tab: Currency symbol, Symbol position, Start month, Year and more.Clients tab: Client, Lumen Coffee, Fern and Co, Atlas Fitness and more.

DashboardPreviews of the Dashboard, Time Log, Settings and Clients tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
5 tabs · 3 charts
Version
1.1 · Updated 7 Oct 2026
Licence
Commercial What this means
Checked
Checked before it ships
  • design-agency-time-and-billing-tracker.xlsxXLSX · 61 KB
  • design-agency-time-and-billing-tracker-blank.xlsxXLSX · 60 KB
  • design-agency-time-and-billing-tracker.csvCSV · 3 KB
  • LICENSE.txtadded to every download

About this item

A time and billing tracker for a design studio. It has 5 tabs: Start Here, Dashboard, Time Log, Clients, Settings. The Dashboard with 3 charts shows hours for the month you pick, the billable share, the value of billable work you have not invoiced yet ($2,673 in the sample data) and your effective hourly rate, with a doughnut of hours by client and billable against other hours for every month. Log one row per block of work. Each client has an hourly rate in Settings, so value is worked out for you and only billable time counts. Mark rows Billed when you invoice them. You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab