Calculating the P&L (Profit and Loss) by client and by service means breaking down your marketing agency’s revenue and costs at the most granular level possible, in order to determine how profitable each business relationship and each service line is individually. This analysis goes beyond the general income statement: it lets you identify exactly which clients and services generate real profit, which ones erode your margins, and where you need to adjust prices, resources, or cost structures to grow sustainably.
What is P&L and what is it used for in a marketing agency?
P&L, also known as the income statement or profit and loss statement, is a financial document that summarizes the revenue, costs, and net profit or loss for a given period. In a digital marketing agency, building this analysis at the client and service level turns a generic accounting report into an operational management tool.
When you calculate P&L in a disaggregated way, you get concrete answers to questions that a consolidated income statement can never answer: Is the client that bills the most also the most profitable? Does the SEO service justify the resources it consumes? Does the social media account managed by your senior team generate enough margin for that level of dedication?
This analysis is especially useful for:
- Agency owners and directors who need to make growth decisions based on real financial data, not perceptions.
- Performance managers and heads of marketing who manage multiple accounts and want to prioritize resources toward the most profitable clients.
- Freelancers with a client portfolio who need to determine when to raise prices, renegotiate scopes, or drop unprofitable accounts.
- Agencies in the process of scaling who want to replicate the service model with better margins before hiring more staff.
- Operations managers looking to reduce costs without affecting the quality of service delivered.
Key components of P&L by client and by service
Direct revenue
Revenue is all amounts billed to the client in the period analyzed. It includes management fees, monthly retainers, commissions on ad spend, and charges for one-off projects. Classify each revenue item in two simultaneous ways: which client it belongs to and which service it falls under.
Direct costs
Direct costs are those you can attribute unambiguously to a specific client or service. The most relevant ones in a digital marketing agency are:
- Team hours: time spent by each team member, valued according to their hourly cost (total gross salary divided by billable hours in the month).
- Tools and platforms: software licenses assigned to that client or service (SEO tools, automation, design, etc.).
- Subcontracting: freelancers, translators, external designers, or any provider hired specifically for that client.
- Own advertising investment: if the agency advances or manages ad budgets, the associated administrative cost should be recorded here.
Allocated indirect costs
Indirect costs cannot be directly linked to a client, but they must be distributed among all of them so the P&L reflects the full economic reality. The most common ones include office rent, administrative salaries, internet, internal management software, and the agency’s own marketing.
The most practical method for distributing them is proportional allocation by revenue: if a client represents 20% of the agency’s total revenue, they are allocated 20% of the period’s indirect costs.
Reference table: full P&L structure by client
| Item | Client A | Client B | Client C |
|---|---|---|---|
| Revenue | $10,000 | $5,000 | $8,000 |
| Direct costs (team) | $4,500 | $1,800 | $3,200 |
| Direct costs (tools) | $500 | $300 | $400 |
| Direct costs (subcontracting) | $0 | $500 | $1,000 |
| Total direct costs | $5,000 | $2,600 | $4,600 |
| Allocated indirect costs | $1,200 | $600 | $960 |
| Net profit | $3,800 | $1,800 | $2,440 |
| Net margin | 38% | 36% | 30.5% |
How to interpret the P&L results
Gross margin versus net margin
The gross margin results from subtracting only direct costs from revenue. The net margin also incorporates allocated indirect costs. Both metrics serve different purposes: gross margin measures the operational efficiency of each account or service; net margin reflects the actual profitability for the agency.
A healthy net margin for a digital marketing agency varies depending on the business model and team size, but generally a range of 20% to 35% per client is considered acceptable.
Warning signs you should identify
- Clients with a net margin below 15% after allocating indirect costs.
- Services where team cost exceeds 60% of the revenue generated.
- Accounts with high revenue but below-average agency margins, a sign of operational inefficiency or incorrect pricing.
- Services that consume increasing subcontracting without a corresponding price adjustment for the client.
- Clients requiring frequent out-of-scope revisions, whose team cost is not captured in the P&L.
Actions based on results
- If a client has a low margin due to high team costs, review whether the contract scope is well defined and whether the hours logged are proportional to the agreed price.
- If a service has a low margin due to tools, evaluate whether those licenses are being used to their full potential or whether you can consolidate them.
- If indirect costs represent more than 15% of a small client’s revenue, consider whether that client is viable long term or needs a higher price.
How to calculate P&L by client and by service step by step
- Define the analysis period. Choose a month, quarter, or year. Consistency in the period is essential to compare results across cycles.
- Record all revenue by client. Add retainers, one-off projects, commissions, and any other charges associated with each account in that period.
- Classify revenue by service as well. Each revenue item should have two labels: the client generating it and the service it corresponds to (SEO, ads, social media, design, etc.).
- Calculate team cost per client. Multiply the hours dedicated to each client by the hourly cost of each team member who worked on that account.
- Record additional direct costs. Add tools, licenses, and subcontracting specifically assigned to each client or service.
- Add up total indirect costs for the period. Consolidate all expenses that cannot be directly assigned to a client.
- Distribute indirect costs proportionally. Use each client’s revenue as the distribution base: (client revenue / total revenue) × total indirect costs.
- Calculate the individual P&L. Apply the formula: Revenue − Direct costs − Allocated indirect costs = Net profit. Also calculate the margin: (Net profit / Revenue) × 100.
- Compare and prioritize. Rank clients and services by net margin from highest to lowest. Identify profitability patterns and cases that require immediate action.
- Automate the tracking. A tool like Master Metrics lets you centralize revenue data by channel and client, reducing the manual consolidation time needed for this type of financial analysis.
Manual P&L vs. financial analysis tools for agencies
| Criterion | Manual spreadsheet | Generic accounting software | Specialized platform for agencies |
|---|---|---|---|
| Initial setup time | Low | Medium | Medium-high |
| Data updating | Manual, risk of errors | Semi-automatic | Automatic with integrations |
| Breakdown by client and service | Possible with custom design | Limited | Native to the platform |
| Integration with campaign data | No | No | Yes (Google Ads, Meta Ads, etc.) |
| Scalability (more than 10 clients) | Low | Medium | High |
| Cost | Free | Variable | Variable by plan |
The spreadsheet works well for agencies with fewer than five active clients. As the portfolio grows, the manual maintenance time exceeds the value of the initial savings. Specialized platforms for agencies allow you to link campaign data directly with financial records, which speeds up the P&L calculation and reduces consolidation errors.
Frequently asked questions about calculating profit and loss in marketing agencies
How often should I calculate P&L by client and by service?
The recommended minimum frequency is monthly. This allows you to detect trends early and make decisions before an unprofitable client affects quarterly results. Agencies with more than 15 active clients often do biweekly reviews to maintain operational control.
What net margin per client is considered healthy in a digital marketing agency?
There is no universal standard, since the margin varies depending on the type of service, team size, and each agency’s cost structure. As a general reference, a net margin per client between 20% and 35% indicates an efficient operation. Margins below 15% deserve an immediate review of pricing or contract scope.
How do I calculate my team’s hourly cost to allocate it to each client?
Divide each team member’s total monthly cost (gross salary plus social security contributions and benefits) by the billable hours in the month. Then multiply that hourly cost by the hours that person spent on each client. Logging hours by project in a time-tracking tool makes this step much easier.
Are the costs of shared tools like design suites or automation platforms counted as direct or indirect?
It depends on actual usage. If a tool is used exclusively for a specific client, it’s a direct cost for that client. If it’s used across multiple accounts, it’s an indirect cost that you should distribute proportionally. What matters is being consistent with the criteria you choose from the very first analysis period.
What should I do if a client turns out to be unprofitable according to the P&L?
First analyze the cause: is the price too low, are costs too high, or has the service scope expanded without a fee adjustment? With that diagnosis, you have three concrete options: renegotiate the price with the client, reduce the contract scope to adjust costs, or in extreme cases, drop that account to free up capacity for clients with better margins.
Does the P&L by client include sales tax, or is it calculated on net revenue?
An agency’s operating P&L is generally calculated on net revenue, meaning the amount the agency actually receives after sales tax or VAT. If you bill the tax and pass it on to the tax authority without retaining it as your own revenue, it should not be included in the profitability calculation.
How does Master Metrics help manage profitability by client?
Master Metrics automatically centralizes campaign performance data from platforms like Google Ads, Meta Ads, LinkedIn Ads, and TikTok Ads into per-client dashboards. By having actual ad spend, performance metrics, and account results all in one place, agency directors can correlate that data with their cost records to build the P&L by client more accurately and in less time. This eliminates the manual consolidation of multiple sources, which is one of the most time-consuming steps in the process.
Conclusion
Calculating P&L by client and by service turns your agency’s financial management into a competitive advantage. Without this analysis, decisions about growth, hiring, and pricing are based on perceptions or on the consolidated result, which can hide unprofitable accounts that erode overall margin without you noticing in time.
Implementation doesn’t require sophisticated software from day one. A structured template like the one we offer is enough to get started. As your client portfolio grows, tools like Master Metrics allow you to automate campaign data consolidation and cut by up to 50% the operational time your team spends building reports and financial analyses per account.
The ultimate goal isn’t just to know which clients are profitable today, but to build an agency model where every account and every service justify the resources they consume. That level of financial clarity is what sets agencies that grow sustainably apart from those that work hard and earn little.