How to track agency profitability by client

Most agencies know their overall margin. Few know which clients are actually profitable.

You have 10 clients. Your blended margin is 35%. But Client A runs at 50% margin while Client B is barely breaking 15%.

You're working just as hard on both. One is subsidizing the other.

That's a problem. You can't fix what you don't measure.

Per-client and per-project P&L tracking is the foundation of profitable agency operations. It's not complicated. You need three numbers: revenue, direct costs, and overhead allocation. Everything else is just math.

The Three-Number System

Every client needs a profit and loss statement. It doesn't need to be fancy. Three columns work:

Revenue: What you billed the client (this quarter, this year, whatever period you're tracking).

Direct Costs: Salaries, contractors, software licenses, and third-party services directly tied to delivering work for this client. If you spend $2,000 on a specialized tool just for Client A's work, it goes here.

Overhead Allocation: Your share of the costs that benefit all clients. Rent, office admin, accounting software, your salary. Calculate it as a percentage of revenue or hours spent.

Profit = Revenue - Direct Costs - Overhead Allocation

That's it. Everything else is just accurate accounting.

Revenue by Client is Easy (If Your Invoicing Is Clean)

Pull numbers directly from your accounting software. If you use FreshBooks, Quickbooks, or Wave, you can already segment revenue by client.

Export a report. Look at the numbers. If they're messy, that's a signal that your invoicing isn't consistent. Fix it before moving to the next step.

One caveat: only count invoiced revenue, not time logged or work completed. If you invoice quarterly or on NET-30 terms, adjust for that. You want to match revenue to the period it was earned, not when cash came in.

Direct Costs Are Where Most Agencies Get Lazy

Direct costs should include:

Salaries and benefits for staff assigned to this client
Contractor payments (freelance designers, developers, etc.)
Third-party software or tools purchased specifically for this client's work
Outsourced services (copywriting, design, research, etc.)
Expenses directly attributable to the engagement (travel, equipment, etc.)

Most agencies skip salaries. They think "my designers work on multiple clients, so it's not direct." That's incorrect. If your designer spent 40 hours on Client A this month, their hourly rate times 40 hours is a direct cost.

Here's the quick method:

Pull your timesheet data from Asana, ClickUp, Linear, or whatever tool you use.
Tag or filter for each client.
Sum the hours per person.
Multiply hours by fully-loaded hourly cost (salary or contractor rate plus benefits).

If you don't have timesheet data, you need it. Start tracking this week. You can't manage what you don't measure.

Overhead Allocation: The Fair Method

You have costs that benefit all clients: rent, your salary, accounting software, project management tools, office supplies. These need to be allocated fairly.

The fairest method is percentage of revenue.

Calculate it quarterly:

Total Company Overhead / Total Company Revenue = Overhead percentage

Example: You spend $50,000 per quarter on overhead costs. Your total revenue is $200,000. That's 25% overhead allocation.

Client A generated $40,000 in revenue. Allocate $10,000 of overhead to them.

Client B generated $160,000 in revenue. Allocate $40,000 of overhead to them.

This rewards you for working with high-revenue clients and surfaces the cost of managing low-revenue ones.

An alternative is allocation by hours. If Client A consumed 15% of your total billable hours, allocate 15% of overhead to them. Both methods work. Pick one and use it consistently.

Building the P&L Report

Create a simple spreadsheet or pull it from your accounting software. Here's what it looks like:

Client	Q1 Revenue	Direct Costs	Overhead (25%)	Total Costs	Profit	Margin %
Client A	$40,000	$18,000	$10,000	$28,000	$12,000	30%
Client B	$160,000	$96,000	$40,000	$136,000	$24,000	15%
Client C	$25,000	$8,000	$6,250	$14,250	$10,750	43%

Client C is your margin leader despite generating the least revenue. Client B is your largest revenue source but barely profitable. That's valuable information.

What to Do With This Information

Now that you have the data, the real work begins.

Low-margin clients: Have a conversation about pricing or scope. Maybe you're over-servicing them. Maybe your estimate was wrong. Maybe the relationship isn't as profitable as it should be and you need to either restructure the deal or move on.

High-margin clients: Ask why they're profitable. Are they less demanding? Do they have clearer scope? Are they paying premium rates? Can you clone this model for other clients?

Portfolio imbalance: If one client is subsidizing others, you have three options. Raise prices on the subsidized clients. Lower your costs on their work. Or replace them with clients who fit your margin targets.

Don't get sentimental about this. Profitability isn't personal. It's arithmetic.

Per-Project P&L: The Advanced Move

Once you're comfortable with client-level P&L, track individual projects.

For a web design agency, each website redesign is a project. Revenue: the engagement fee. Costs: the hours spent by designers and developers. Result: profit or loss.

This reveals which project types are most profitable. You might discover that custom WordPress sites are money-makers while Webflow projects always run over. That's directional data for your business.

Track it the same way: Revenue - Direct Costs - Proportional Overhead = Project Profit.

Tools to Make This Easier

Spreadsheets work. So do these options:

Accounting software: FreshBooks and Quickbooks have built-in profitability reports by client.
Project management tools: Some PM tools (Asana, ClickUp, Monday) have time-tracking and basic profitability features.
Hybrid approach: Pull timesheet data from your PM tool. Pull revenue from accounting. Combine in a spreadsheet.

The tool doesn't matter. Consistency matters. Pick one method and run the numbers quarterly.

The One Metric That Matters Most

If you're tracking only one thing, track margin percentage by client.

Revenue can be deceiving. You can have high revenue and low profit. Margin percentage is the truth. It's the percentage of every dollar that actually stays with your company.

Target should be 40%+ for healthy agencies. If you're below 30%, something is broken. Could be pricing.

Could be inefficiency. Could be scope creep. But something needs to change.

FAQ

Q: How often should I run these reports? A: Quarterly is standard. Monthly if you want faster feedback loops. Annual is too slow. You'll have already made decisions based on gut feeling instead of data.

Q: What if my timesheet data is incomplete? A: Start tracking this month. Pull estimates for past months if you need historical data. Imperfect data that you improve is better than no data.

Q: Should I share these numbers with my team? A: Yes. Your team should know which work is profitable. It changes how they approach problems. High-margin projects deserve high-quality attention. Low-margin projects need ruthless scope management.

Q: What if a client is unprofitable but I can't afford to lose them? A: Then you need to restructure the relationship. Raise prices, reduce scope, or find a way to deliver more efficiently. Staying unprofitable to keep revenue is a path to bankruptcy.