How do marketing agencies track profitability by client?
Revenue alone tells you very little about whether a client is worth keeping. A $6,000 per month retainer client looks great until you realize you’re spending $4,800 in labor and contractor costs to service them. Meanwhile a $2,500 client takes ten hours of internal time and almost no outside help. You need to see the full picture, and that means tracking costs at the client level.
The first step is deciding which costs belong to individual clients and which stay at the company level. Direct costs get assigned to the client. These include billable staff hours spent on that client’s work, freelancer and contractor invoices for work done on their projects, and pass-through expenses like ad spend, stock photography, printing, or software purchased specifically for that account. If a cost exists because of a particular client, it belongs on their record.
Shared overhead stays at the company level. Rent, your project management software subscription, general admin salaries, insurance, and utilities benefit every client equally. Trying to allocate a slice of rent to each client creates a false sense of precision without adding useful information. Keep it simple. What you really want to know is the gross margin each client generates after direct costs. That number tells you whether the client is contributing enough to cover their share of overhead and still leave profit.
In QuickBooks Online, use the Projects feature to create a project for each client or engagement. When your team logs time, that time gets assigned to the correct project. When you receive a bill from a freelance designer or a developer you subcontracted, code it to the right project. When you pay for Facebook ads on a client’s behalf, same thing. Every direct expense touches the right project so that nothing falls through the cracks.
Contractor costs deserve extra attention because they tend to be the biggest variable. Agencies that rely heavily on freelancers for design, copywriting, or development can have wildly different margins from one client to the next depending on how much outside help each account requires. If contractor invoices aren’t coded to specific clients, you lose visibility into this completely. Make it a habit to assign every contractor bill before it gets paid.
Run profitability reports quarterly at minimum. QuickBooks has a Project Profitability report that shows revenue minus direct costs for each client. Review the list and look for patterns. You might find that your biggest client by revenue is actually your thinnest margin. Or that a handful of smaller accounts are incredibly efficient and profitable. This information changes how you price new work, which clients you invest in retaining, and where you need to renegotiate scope.
The discipline of creative services bookkeeping is really about consistency. The system only works if every billable hour, every contractor invoice, and every pass-through expense lands in the right place every time. It takes a few extra minutes per transaction, but the quarterly insight it produces is worth far more than the effort.
If your books aren’t currently set up this way, it’s not too late to start. Getting QuickBooks configured properly and building the right habits around cost assignment is straightforward with some guidance. Our Wisconsin small business bookkeeping services include helping agency owners set up project-level tracking so they can finally see which clients are driving their business forward and which ones are quietly draining it.
Wisconsin's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business. We'll talk through what you need, answer your questions, and give you a clear quote.
More Questions
How do I track profitability by building maintenance contract?
Set up each contract as a project or sub-customer in QuickBooks Online. Allocate direct labor and materials to the contract while keeping shared overhead at the company level. Monthly gross margin per contract tells you which deals are worth renewing.
Read answerHow do I set up sales tax for a Wisconsin retail boutique in QuickBooks?
Enable automated sales tax in QuickBooks Online, add the Wisconsin Department of Revenue as your tax agency, and assign the correct tax code to every product. QBO handles rate lookups based on location, applying the 5% state rate plus any applicable county tax.
Read answerHow do I track recurring cleaning contracts in QuickBooks?
Use recurring invoices for each contract and set up classes or customer types to separate monthly contract revenue from one-time jobs. This gives you a clear view of your monthly recurring revenue.
Read answerWhat's the Wisconsin state sales tax rate?
Wisconsin's base state sales tax rate is 5%. Most counties add a 0.5% county tax, bringing the typical combined rate to 5.5%. A few jurisdictions have additional local taxes that push the total slightly higher.
Read answerHow do you do weekly inventory counts for restaurant COGS?
Count everything on hand Sunday night after close, apply standard costs, then compare your actual usage to theoretical usage based on recipes and POS sales. The gap between those two numbers tells you where food cost is leaking.
Read answerDo restaurants need accrual accounting or is cash okay?
Cash basis is legal for most restaurants, but accrual accounting gives you a much clearer picture of monthly profitability. Many well-run restaurants use accrual internally for decision-making even when they file taxes on a cash basis.
Read answer