Skip to main content

Guide · 7 min read · November 12, 2026

Agency project profitability: track margin by client and project

Most agencies know their biggest clients by revenue. Far fewer know which of those clients actually make money. This guide is for agency and consultancy owners who want margin by client and project straight from their books: how to structure your accounts, how to put a real cost on your team's hours, how to keep pass-through spend from distorting the numbers, and how to review it all every month.

What's inside

  • · Why revenue by client hides your real margin
  • · Setting up your books to track profit by client and project
  • · Putting a real cost on team time, with a worked example
  • · Handling pass-through costs and retainers
  • · A monthly project profitability review

Why revenue by client hides your real margin

An agency sells time and expertise. That means your biggest cost, people, is spread across every client, and a standard profit and loss statement doesn't show where it went. Your P&L can say the agency earned a 20% net margin while one large retainer quietly loses money and two small projects carry the business.

Agency project profitability is the answer to a simple question: after paying for the people and outside costs that delivered the work, what was left from each client and each project? To answer it, your books need three things: revenue tagged to a client or project, direct costs tagged the same way, and a fair cost for the hours your salaried team spent.

MeasureHow to calculate itWhat it tells you
Project gross margin(Revenue minus direct labor and direct costs) ÷ revenueWhether the work itself makes money
Effective hourly rateRevenue (or fee) ÷ hours actually spentWhat you really earn per hour, whatever the pricing model
Contribution by clientGross margin in dollars across all of a client's projectsHow much each client adds toward overhead and profit

Set up your books to track profit by client and project

You don't need a separate project tool to start. You need a consistent structure in your accounting system, and the discipline to tag every relevant transaction.

  1. 01

    Split direct costs from overhead

    Create cost of revenue accounts for the costs that exist because of client work: contractor and freelancer fees, direct labor, and client-specific software or production costs. Rent, admin salaries and general tools stay in operating expenses.

  2. 02

    Give every engagement a home

    Set each client up as a customer, and each engagement as a project under that customer. Retainers can be one project per year or per scope; fixed-fee and hourly work get one project each.

  3. 03

    Tag revenue at the invoice

    Every invoice line should carry the project. If a client pays one invoice for two engagements, split the lines so each project gets its share.

  4. 04

    Tag direct costs at the bill

    Contractor bills and client-specific expenses get the same project tag when you enter them. Untagged direct costs are the most common reason project reports look better than reality.

  5. 05

    Track time for everyone who delivers work

    Salaried staff included. Without hours by project, you can't assign labor cost, and labor is usually the largest cost an agency has.

Putting a real cost on team time

Contractor costs land on a project automatically because they arrive as bills. Salaried team members don't, so you have to assign their cost using hours and a loaded hourly rate: what an hour of that person's working time actually costs the agency.

Work out a loaded hourly cost

Take annual salary, add employer payroll taxes and benefits, and divide by the hours the person is actually available to work after holidays and time off. Say a designer earns $78,000 and payroll taxes and benefits add 20%, for a total cost of $93,600. If they're available for 1,800 hours a year, their loaded cost is $52 per hour. Use your own payroll figures, and update the rate when salaries change.

A worked example: three clients in one month

Here's a hypothetical agency with three clients in a single month. Everyone's time is costed at $52 per hour to keep the math simple.

ItemClient A (retainer)Client B (fixed fee)Client C (paid media)
Agency fee$12,000$8,000$7,000
Team hours1406070
Labor cost at $52/hr$7,280$3,120$3,640
Contractor costs$1,500$800$0
Gross margin$3,220$4,080$3,360
Margin on fee27%51%48%
Effective hourly rate$86$133$100

Client A brings in the most revenue and the least margin. Its effective hourly rate of $86 tells you why: the retainer is absorbing far more hours than it was priced for. That's a scope or pricing conversation, and you can only have it with numbers like these in hand.

Handling pass-through costs and retainers

Client C also had $18,000 of ad spend that the agency bought and rebilled at cost, so the invoice was $25,000. Measured against $25,000, the $3,360 margin looks like 13%. Measured against the $7,000 fee the agency actually earned, it's 48%. Mixing the two makes media-heavy clients look like your worst accounts when they may be among your best.

  • Track pass-through spend in its own accounts. Use a dedicated revenue line and a matching cost line for rebilled media, software and other third-party costs, so you can always see fee revenue on its own.
  • Report margin on fees, not on total billings. Agency gross margin should exclude pass-through amounts, or the ratio swings with every media budget.
  • Get the gross-versus-net question right. Under ASC 606, whether you report pass-through spend as revenue or show only your fee depends on whether you control the service before it reaches the client. FASB's principal versus agent guidance covers this; confirm your presentation with your CPA.
  • Don't book prepaid retainers as earned. When a client pays before the work is done, the payment is a liability until you deliver. Recognize it as you perform, so each month's project margin matches that month's hours.
  • Watch unbilled work. Hours logged on a project you haven't invoiced yet are a cost without revenue this month. Track unbilled time so a project doesn't look like a loss just because the invoice goes out next week.

A monthly project profitability review

  1. 01

    Close the month first

    Profitability reports are only as good as the books under them. Reconcile bank and card accounts and book accruals before you look at any project numbers. Our month-end close checklist covers the steps.

  2. 02

    Check for untagged transactions

    Run a report of direct costs and revenue with no client or project assigned. Fix them before you move on.

  3. 03

    Lock in hours

    Make sure timesheets for the month are complete and approved, then apply the loaded rates to each project.

  4. 04

    Review margin and effective rate by project

    Compare each project's margin and effective hourly rate to your target. Flag anything below it, and anything whose hours ran well past the estimate.

  5. 05

    Roll it up by client

    Add up contribution across each client's projects. A client with one great project and two loss-making ones may not be the client you thought.

  6. 06

    Decide one action per problem account

    Repricing, a scope reset, a change order or a staffing change. Write it down and check it next month.

Doing it in QuickBooks Online or Xero

Both major small business systems can carry this structure. In QuickBooks Online, the Projects feature is available on the Plus and Advanced plans: each project sits under a customer and tracks income, expenses and labor costs, and Advanced adds project estimates compared to actuals. Class tracking, also on Plus and Advanced, is useful if you want to report by service line as well as by client.

In Xero, Xero Projects is included in the Established plan in the US. It records time and costs against a project, creates quotes and invoices from it, and shows project financials on a profitability dashboard.

Whichever system you use, the tool matters less than the habit: every invoice, every direct bill and every hour tagged, every month. If you'd rather have that done for you, our agency and professional services accounting team sets up the structure, and our financial reporting delivers margin by client alongside your monthly statements.

Frequently asked questions

What is a good gross margin for an agency project?
It depends on your service mix and pricing, so set a target from your own numbers: the margin a project needs to cover overhead and leave the profit you want. Then measure every project against that same target, using fee revenue rather than total billings.
Should salaried employees' time be charged to projects?
Yes, for profitability reporting. Salaries are usually an agency's largest cost, and leaving them out makes every project look far more profitable than it is. Assign their cost using hours and a loaded hourly rate.
Do I need separate project management software to track project profitability?
Not to start. QuickBooks Online Plus or Advanced and Xero's Established plan both track income and costs by project. Many agencies add a time tracking tool, but the profitability numbers should still come from the books.

Do you know which of your clients actually make money?

We'll look at how your books are set up today and show you what it takes to get margin by client and project every month, starting with one short call.