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.
| Measure | How to calculate it | What it tells you |
|---|---|---|
| Project gross margin | (Revenue minus direct labor and direct costs) ÷ revenue | Whether the work itself makes money |
| Effective hourly rate | Revenue (or fee) ÷ hours actually spent | What you really earn per hour, whatever the pricing model |
| Contribution by client | Gross margin in dollars across all of a client's projects | How 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.
- 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.
- 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.
- 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.
- 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.
- 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.
| Item | Client A (retainer) | Client B (fixed fee) | Client C (paid media) |
|---|---|---|---|
| Agency fee | $12,000 | $8,000 | $7,000 |
| Team hours | 140 | 60 | 70 |
| 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 fee | 27% | 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
- 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.
- 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.
- 03
Lock in hours
Make sure timesheets for the month are complete and approved, then apply the loaded rates to each project.
- 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.
- 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.
- 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.

