Your biggest client by revenue can be your least profitable one. The invoice total won't show it. You see it only after you count the revision rounds, the standing weekly call, and the share of overhead that client quietly absorbs.
The invoices go out, the payments come in, the bills get paid, and everything lands in one pile. Once you have real volume, that pile turns into an expensive blind spot. The math reads as revenue minus costs, but the costs sit scattered across tools instead of in one place.
To track profitability by client without paying for extra software, you need four things you already own: an invoice export, bank transaction history, a spreadsheet, and a checking account structure that pre-sorts spending as it happens.
What client-level profit really measures
Client profitability is the revenue from one client minus all direct and allocated costs of serving that client. A big client by revenue can earn less than a smaller one when extra time, revisions, and support raise the cost to serve. A quiet mid-tier client who pays on time and stays off your calendar might carry your best margin.
Say last quarter you invoiced across several clients, but one of them consumed an outsized share of your team's hours for a modest share of the revenue. On paper that client looks like a win. On the books, after you account for the revision cycle and the standing weekly call, it might be your worst performer.
Once you have a team, the calculation matters more than it did when you were solo. You pay people at different rates, and shared costs like rent and insurance, plus your own salary, all have to split across engagements somehow. To get a real per-client number, customer profitability analysis breaks into three buckets:
Direct revenue: what you invoiced that client for the period.
Direct costs: materials, subcontractor payments, and labor hours tied specifically to that client.
Allocated overhead: that client's fair share of the shared costs that keep the whole business running.
The simplest banking tools to track profitability by client
Most of the data you need sits in your invoicing tool and your bank account. The quarter's invoice export lands in a spreadsheet with client names, invoice totals, and dates beside them. Revenue arrives tagged by client, because every invoice is addressed to someone. Drop each invoice into a spreadsheet with the client name in its own column, and your revenue side is done.
Costs take more work, because expenses don't arrive labeled by client. Add a client column to every cost row in your spreadsheet. Pull your bank transaction history for the period, paste it in, and go line by line tagging each cost to the client it served. A pivot table grouped by client then shows revenue and direct costs side by side, per client, on one screen.
Start with the costs you can tag without much guesswork:
Materials, supplies, and subcontractor payments: anything you bought for one client's work, including the freelancer or specialist you brought in for a particular engagement.
Labor hours: your team's time spent on that client, converted to dollars.
These two categories cover the bulk of direct costs, and tagging them first puts the biggest movers on the page before you spend time on smaller line items.
Cleaner bank data at the source speeds up the tagging. Vague transaction descriptions cost you an afternoon of detective work. That kind of friction is what makes managing multiple clients feel harder than it should. Descriptions that name the client turn the job into copy-paste.
How to allocate overhead without accounting software
Pick one allocation base, apply the same one to every client, and treat the result as your working number. Dividing shared costs across clients is overhead allocation. No method is perfect, so choose one you can repeat.
Say your monthly rent serves every client, but your biggest client takes up most of your team's time for a smaller share of the revenue. How much of that rent does the big client owe? An allocation base is the ruler you use to split that shared cost. Pick one, apply it to every client, and move on. Start with the bases that fit service businesses:
Revenue share: split overhead in proportion to each client's revenue. Quick to run, but it lets high-revenue, low-effort clients carry more cost than they cause.
Labor hours: split overhead in proportion to the hours your team spent. Most defensible for service businesses, because overhead supports effort, not billing.
Between these two, labor hours gives the cleaner read for a service business. If your jobs run similar in size, then job count works as a fallback: split overhead across active engagements and accept a fast answer over a precise one. Overhead pays for the people, the space, and the systems behind the work, so splitting it by where the work went matches how the cost gets incurred.
The steps don't change: total your overhead for the quarter, find each client's share of the base, multiply overhead by that share, and add it to that client's direct costs. Run the same method every quarter and the numbers stay comparable, even when the method is rough. That same math feeds margin analysis when you want to see where revenue turns into profit and where costs need a closer look.
How to capture hidden labor costs per client
Non-billable hours are real labor costs, and leaving them out makes a draining client look profitable. A designer on your team spends time on revision emails for one client, and none of that effort appears on an invoice. Multiply that across a quarter, across another revision, the standing Tuesday call, and the "quick question" that ate an afternoon. You have a real labor cost that cuts into the margin: time no one billed for.
To put those hours into dollars, estimate the loaded cost of an hour by adding payroll taxes and benefits to the base wage. According to BLS data, benefits run close to 30% of total private-industry compensation, so the loaded rate runs well above the hourly wage on paper. The loaded rate is the number you multiply against the untracked hours.
You don't need time-tracking software to find those hours. Use the records your team already has:
Calendar and email patterns: count the recurring calls and meetings already on the books for each client, then scan the sent folder for clients generating heavy back-and-forth.
Friday tally: have the team jot a quick guess of hours per client before they log off.
Run the math on one client and the gap shows up fast. Count the revisions and emails, and the team logged more hours than they billed. At the loaded rate, that difference is labor you never charged for. Once you can see those dollars, you have a reason to reprice.
A sample client P&L
Here's the client profitability formula worked out for one quarter, using "Client A," a recurring service engagement.
Direct revenue (invoiced): $42,000
Direct costs:
Subcontractor (freelance specialist): $6,500
Materials and tools specific to the engagement: $1,200
Tracked billable labor (60 hours × $75 loaded rate): $4,500
Hidden labor (non-billable): 18 hours of revisions, calls, and email back-and-forth × $75 loaded rate = $1,350
Allocated overhead (labor-hours base): Client A consumed 12% of total team hours this quarter; quarterly overhead was $35,000, so 12% × $35,000 = $4,200
Client A profit: $42,000 − ($6,500 + $1,200 + $4,500 + $1,350 + $4,200) = $24,250
Client A margin: $24,250 ÷ $42,000 = 57.7%
The same template runs across every client. Drop the hidden labor line and Client A looks like a 64% margin engagement; add it back and the real number is closer to 58%. That six-point gap is what you raise at the next scope review.
What throws off the per-client number
Most per-client numbers come in wrong for the same handful of reasons. Watch for these to keep the analysis honest:
Forgetting non-billable hours. Revision rounds, "quick" calls, and email threads eat margin. Leave hidden labor out, and draining clients look healthy.
Mis-tagging shared expenses as direct costs. A software subscription used across every client isn't a direct cost for one of them. Push it into overhead and allocate.
Ignoring scope creep mid-quarter. The number reflects the original engagement, not the work that got done. Update tags as scope expands instead of waiting for quarter-end.
Inconsistent allocation bases. Switching from revenue share to labor hours between quarters makes the trend line meaningless. Pick one and stay with it.
Counting owner time at zero. If you're billable on engagements, your loaded rate belongs in the labor cost line. Free founder labor flatters every client.
How bank account structure replaces the software
A cleaner account structure is one of the simplest banking tools for per-client margin tracking, because it does much of the sorting before the export and leaves less to reconstruct in the spreadsheet later. A quarterly export from a single checking account opens with every client's revenue, materials, subcontractor payments, and overhead mixed together. The spreadsheet can still sort it, but the account has already blended everything into one pile.
Restructure the accounts and the sorting happens as money moves, instead of as a forensic exercise after the fact. Relay lets you open up to 20 checking accounts on every plan and assign dedicated debit cards³ to client-specific spending, so much of the data arrives pre-sorted and needs less reconstruction.
A few features do most of the work. Dedicated debit cards tie every charge on a given card to a spending purpose, so the tagging from the previous step gets easier before you open the spreadsheet. Separate checking accounts let you split money by purpose: direct costs, overhead, profit, and tax. Automated transfers move a set dollar amount or percentage of every deposit into those accounts, on every plan, so the allocation discipline lives in your cash flow instead of your memory. If you already run a Profit First spreadsheet, the same separate accounts double as the structure that makes per-client profitability readable.
³The Relay Visa® Debit Card is issued by Thread Bank, Member FDIC, pursuant to a license from Visa U.S.A. Inc. and may be used anywhere Visa debit cards are accepted.
What to do once you know which clients are profitable
A ranked client list earns its keep only when it changes a decision. Sort your clients into margin bands and give each band a clear next move:
Healthy margin: keep and grow. These clients pay their way and then some. Protect them, and look for more like them.
Thin margin: reprice or restructure. The work is fine but the terms are tight. Raise the rate, cut the scope, or change how you deliver before the margin slips further.
Break-even: watch closely. The client covers their direct costs and overhead share, but there isn't much room for scope creep, cost increases, or extra support.
Negative margin: fix fast or exit. This client costs you money to serve. Reprice hard, and if they won't move, let them go.
To draw the line, set a break-even threshold for each client: the minimum revenue needed to cover their allocated direct costs plus their overhead share. Any client invoicing below that number costs you money to keep. That gives you a concrete keep-or-reprice number instead of a gut feeling.
Run the exercise each quarter, because margins drift. Scope creeps, costs rise, and a client who looked healthy in January can slip by April. Finding a negative-margin client is the win here, not a red flag.
Turning the analysis into an ongoing habit
Treat the spreadsheet as a control panel for client commitments, not a one-time report. The next scope-change email lands before lunch, and the margin sheet tells you whether the client can absorb it. The pivot table buys you a pause before you agree to more work, more meetings, or looser scope.
If a profitable client stays simple, protect the model. If a client needs extra support, use the margin view to decide whether the price, scope, or delivery process has to change. Keeping direct tags separate from allocated costs also tells you what kind of problem you have: heavier work, a shifted overhead burden, or pricing that no longer matches effort.
Per-client profitability is only as clean as the data you feed it, and the data gets cleaner when the accounts do the sorting before the quarter ends. Relay gives you up to 20 checking accounts with no monthly maintenance fees on the lowest tier, so you can separate direct costs, overhead, tax, and profit into their own buckets, with automated transfers that move a set percentage of every deposit where it belongs. Set the structure once, and the margin review stops being a forensic exercise. Open a Relay account to build the cash setup you use to read client margins.
Frequently asked questions
What are the simplest banking tools to track profitability by client without extra software?
A business checking account that supports multiple sub-accounts, dedicated debit cards per spending category, downloadable transaction exports, and a spreadsheet with a pivot table. Together they cover revenue tagging, direct cost tagging, overhead allocation, and per-client margin reporting without paying for a dedicated profitability platform.
Can I really track client profitability in just a spreadsheet?
Yes. The work is tagging each transaction to a client and choosing one method to split shared overhead. The pivot table does the rest.
What's the difference between project profitability and client profitability?
Project profitability measures one engagement in isolation. Client profitability rolls up every project, retainer, and ad-hoc request for a single client over a period, including the hidden support costs that don't belong to any one project. A client can post profitable individual projects but a negative overall margin once standing meetings, account management, and non-billable revisions are counted.
How do I handle clients whose work spans multiple quarters?
Tag revenue and costs to the period they hit, not the project as a whole, then look at the rolling view across quarters. A long project can show a thin quarter during heavy delivery and a strong one during lighter maintenance, and the rolling number tells you whether the engagement pays overall.
What if a client refuses a price increase after I run the numbers?
You have the data to walk away calmly or to restructure the relationship: trim the scope, cap revisions, shift to async communication, or move them to a lower-touch service tier. The margin number turns a hard conversation into a business decision instead of a personal one.
