An agency time, scope and profitability dashboard

Most agency owners know their busiest clients. Fewer know their most profitable ones, and the two are often not the same. The client who sends a steady stream of small requests, approves slowly and adds "just one more thing" may be costing more in hours than their retainer covers. The fixed fee website project that felt like a win at kickoff may have quietly run over by a third. By the time the year-end numbers show it, the work is done and the chance to fix it has passed.

A time, scope and profitability dashboard gives you that picture while the work is still running. This guide covers what the current way costs, what the dashboard should contain, a plain-words request you can hand to FORGE, a rollout plan, mistakes to avoid and how to measure the result. It is written for agency owners, managing directors, operations leads and finance managers.

What the current way costs you

• Profit is known only after the fact. Projects are reviewed after they close, if at all, so lessons arrive too late to save that project.
• Timesheets are filled in on Friday from memory. Hours get spread evenly or dumped into "general," which makes project costs fiction.
• Scope creep is invisible. Small requests are absorbed without a record, so there is nothing to point to when you need a change order.
• Retainers are judged by feel. You cannot tell whether a monthly retainer is covering the hours it uses.
• Pricing guesses repeat. Without real hours from past projects, the next quote for the same kind of work uses the same optimistic estimate.
• Spreadsheets break. A profitability spreadsheet assembled from a time tracking export, a budget sheet and accounting numbers takes hours each month and breaks when someone adds a column.
• Off-the-shelf tools rarely match your model. Time tracking tools capture hours well, but agencies that mix retainers, fixed fees, time and materials, and pass-through costs often find the reports do not show margin the way their business works.

What the dashboard should contain

Roles

• Team member: logs time against projects and tasks, sees their own hours and targets.
• Producer or project manager: sets up projects, budgets and tasks, watches burn, raises scope changes.
• Account lead: sees their clients' projects, budgets and margins, approves change orders.
• Finance or operations: maintains cost rates, fees and invoices received, reconciles with accounting.
• Owner: sees everything across clients, teams and time.

Cost rates and individual pay are sensitive. Only finance and owners should see them, and the dashboard should show other people margins and burn, not salaries.

Records

• Clients: name, account lead, billing model, start date.
• Projects: client, name, type, billing model (retainer, fixed fee, time and materials, or a mix), fee or monthly retainer amount, budgeted hours by role or phase, start and end date, status.
• Tasks or phases: for example discovery, strategy, design, development, content, production, project management, revisions, so you can see where hours go.
• Time entries: person, date, project, task, hours, billable or not, notes.
• Roles and rates: each role's bill rate and cost rate, with effective dates so old projects keep their old rates.
• Scope changes: project, description, requested by, date, hours estimate, fee, status (Proposed, Approved, Declined, Absorbed). Absorbed changes matter: they record the generosity you chose to give.
• Expenses and pass-throughs: media, freelancers, printing, stock, with markup if you apply one.

Calculations

• Hours used against hours budgeted by project, phase and role.
• Budget burn percentage: hours or cost used divided by budget.
• Earned fee to date: for fixed fee projects, based on progress or milestones; for retainers, the monthly amount; for time and materials, billable hours times rates.
• Cost to date: hours times cost rate plus direct expenses.
• Gross margin: earned fee minus cost, in dollars and percent.
• Effective hourly rate: earned fee divided by hours used.
• Utilization: billable hours divided by available hours for each person or team, for capacity planning.
• Retainer health: hours used each month against hours the retainer covers.

A worked example of the math

Here is how the numbers come together for one made-up project, to show what the dashboard calculates for you. Say an agency sells a fixed fee brand refresh for $30,000, budgeted at 200 hours. Its blended cost rate across the roles involved is $60 an hour.

• At the budget, cost would be 200 hours times $60, or $12,000, leaving a margin of $18,000, which is 60 percent. The effective hourly rate would be $30,000 divided by 200, or $150.
• Now say the project actually takes 260 hours because of two extra revision rounds that were absorbed. Cost becomes $15,600, margin falls to $14,400, or 48 percent, and the effective hourly rate drops to about $115.

Nothing about that project looked like a problem from the outside. The dashboard shows the slide at 75 and 90 percent burn, while there is still time to raise a change order or adjust the plan. These figures are an illustration, not a benchmark; your own rates and budgets drive the real numbers.

Screens

1. Log time: fast, phone friendly, with recent projects at the top and a daily reminder.
2. Project health: each active project with burn, margin, effective rate and a color when it crosses your thresholds.
3. Client view: margin and effective rate by client over the last quarter and year, retainers over and under.
4. Scope log: every change, approved, declined or absorbed, by client.
5. Team capacity: utilization by person and team, next weeks' booked work.
6. Owner summary: total margin this month and year, the five most and least profitable clients, projects at risk.

Notifications

• Team members: a reminder at the end of each day to log time, and a nudge if a day is missing.
• Producers: project hits 50, 75 and 90 percent of budget, and when hours are logged against a closed project.
• Account leads: a retainer goes over its hours two months in a row, and a scope change is waiting for approval.
• Owner: a weekly summary.

Example request

Example request: "Build a time and profitability dashboard for our 25-person agency. Clients have an account lead and a billing model. Projects can be monthly retainers, fixed fee or hourly, with a fee, budgeted hours by role and a list of phases: discovery, strategy, design, build, content, project management and revisions. Everyone logs time daily on their phone or computer against a project and phase, with a note; remind them at 5 p.m. if nothing is logged. Each role has a bill rate and a cost rate with an effective date, and only finance and the owners see cost rates. Show each project's hours used against budget, budget burn percent, cost to date, earned fee, margin and effective hourly rate, and color it amber at 75 percent burn and red at 90. Alert the producer at 50, 75 and 90 percent. Keep a scope change log with description, hours, fee and status: proposed, approved, declined or absorbed. For retainers, show hours used each month against the hours covered and alert the account lead when a retainer runs over two months in a row. Give the owners a dashboard with margin by client for the quarter and year, the most and least profitable clients, projects at risk and team utilization."

Comparing the options

Rollout plan

1. Set your cost rate method with your accountant and calculate a rate per role.
2. Define phases that match how you sell work, and keep the list short.
3. Load active clients and projects with fees and budgeted hours. Where budgets do not exist, set them now from the original estimate.
4. Explain why to the team. Time tracking feels like surveillance unless people hear the real reason: better quotes, fewer weekends, protecting the team from scope creep.
5. Start with daily logging for everyone, owners included, from a set Monday.
6. Review project health weekly in the producers' meeting for the first two months.
7. Reconcile with accounting monthly so the numbers stay trusted.
8. Use a quarter of real data to revisit pricing and retainers.

Mistakes to avoid

• Weekly or monthly time entry. Memory fails after a day. Daily is the habit that makes everything else true.
• Too many tasks. Twenty phases produce random choices. Six to ten that match how you sell work produce clean data.
• Hiding absorbed scope. Log free work as absorbed scope. It is still a cost, and it is valuable in renewal talks.
• Exposing salaries. Use role-based cost rates and keep them to finance and owners.
• Judging people by utilization alone. Utilization is for planning capacity. Using it as a performance score teaches people to log the wrong things.
• Never acting on the numbers. The payoff comes from repricing, renegotiating retainers and changing how you scope. Put a date on that first review.

How to measure that it works

• Share of days with time logged, aiming for nearly every working day.
• Projects that finish within budget, compared with the year before.
• Gross margin by client trend over quarters.
• Change orders raised and their value.
• Estimate accuracy: budgeted against actual hours on completed projects.
• Time to produce the monthly profitability report, which should drop to minutes.

Checklist before you build

1. Agree on the cost rate method and rates by role.
2. List billing models and how each earns fee.
3. Define phases or task types.
4. Gather active projects, fees and budgets.
5. Decide alert thresholds.
6. Decide who sees cost rates and margins.
7. Set the daily logging start date and reminder time.
8. Schedule the first monthly reconciliation and the first pricing review.

How FORGE handles it

With FORGE, your operations lead or finance manager describes the dashboard in plain words, like the example above. A panel of top AI models plans it, a dedicated AI crew builds it, and every piece is checked for quality and security before it is saved. Most teams have their first real tool the same day, on desktop and phone.

Every app lives inside your company, and people join only by invite. Roles in FORGE decide who builds and who uses, the dashboard itself keeps cost rates to the people you choose, and FORGE keeps a complete record of who did what. Team members who only log time are free. When you add a billing model or change a threshold, describe it; a change costs a small fraction of a build and only counts when something actually changes.

It is $49 a seat a month for each person who builds, with 3 builds included. Our team onboards every agency starting with a workflow workshop. If you want to know which clients really pay the bills, talk to us.

Questions people ask