Agency P&L Template
You need a P&L statement. It's the primary document that shows if your agency is actually making money. Most agency owners run without one or use a generic template that doesn't capture your business structure.
A P&L that doesn't reflect how your agency actually works is useless. You'll have data that doesn't make sense.
You'll miss opportunities to cut costs. You won't know your actual profitability per client.
Here's what a proper agency P&L looks like and how to set one up.
Why Your Agency Needs a Real P&L
Your P&L answers the core question: are we profitable? And if yes, how profitable?
You might think you're profitable because money is in the bank. That's not the same thing.
Profitable means revenue minus all costs equals a positive number. It's more detailed than checking your balance.
A P&L also helps you answer: which clients are actually profitable? Is a big client with thin margins better than a small client with fat margins? Should you raise rates next year?
Also, if you ever want to sell the agency or raise investment, you'll need a clean P&L. Investors and buyers want to see 2-3 years of clean financials. Start building this now.
The Basic Structure
Your P&L has three sections: revenue, costs, and profit.
Revenue is straightforward. Total money you billed. If you bill clients $100k per month, that's $1.2M annual revenue.
Costs break into fixed costs (don't change month to month) and variable costs (fluctuate based on work).
Fixed costs include: salaries, office rent, software subscriptions, insurance.
Variable costs include: contractor fees, freelancer payments, project-specific supplies, client entertainment.
Profit is revenue minus all costs.
What to Actually Include
Revenue should break down by client or project type. This matters. If you have 10 clients and 5 of them are unprofitable, you need to know.
For each client, track revenue monthly. This shows seasonality. Maybe Q4 is always big.
Maybe summer is slow. Understanding your patterns helps with planning.
Include one line for discounts or refunds. Every agency has clients who demand rate reductions. Track the impact.
Costs should include salaries and benefits. Don't skip this. Many owners undercount their own salary.
Include yourself at market rate. If you're not paying yourself fairly, your profitability number is fiction.
Also include all software subscriptions. Your PM tool, your time tracking, your accounting software, Slack.
Add them up. Most agencies spend $10k-20k annually on software.
Don't forget taxes. If you're sole proprietor, account for self-employment tax. If you're a corporation, account for corporate tax.
Also include healthcare and retirement contributions. If the agency covers these, they're costs.
Variable Costs That Agencies Forget
Freelancers and contractors. This is often your biggest variable cost. Track how much you spend on freelancers per month.
Project costs. If you reimburse travel for client work or buy supplies, track it.
Payroll taxes and employer contributions. If you have employees, you're also paying Social Security, Medicare, unemployment insurance. These add 15% on top of salary.
Client entertainment or travel. Client dinners, conference travel to meet clients, hosting events.
Also include depreciation of equipment if you've bought cameras, computers, or other depreciable assets.
Setting Up the Template
Use Google Sheets or Excel. Simple structure is better than fancy.
Create 12 columns: one for each month, plus a YTD column.
Create rows for: each revenue stream, then fixed costs, then variable costs.
At the bottom, create a row for "gross profit" (revenue minus cost of goods sold) and "net profit" (gross profit minus operating expenses).
Include a formula to calculate profit margin: profit divided by revenue, multiplied by 100. For a healthy agency, this should be 20-40%.
Monthly Routine
Update the P&L monthly. Don't wait until the end of the year. Monthly updates show trends quickly.
Spend 30 minutes entering data. Pull revenue from your accounting software.
Pull costs from expense reports and invoices. Enter into your P&L.
Review monthly results. What changed from last month?
Is it expected? If revenue dropped or costs spiked unexpectedly, investigate why.
Compare this month to the same month last year. Are you growing? Are you more profitable?
Identifying Unprofitable Clients
This is where a good P&L shines. Calculate profit per client.
For each client, enter revenue. Estimate the cost to serve them (salaries, freelancer fees, software allocation). Calculate profit.
If a client generates $100k revenue but costs $120k to serve, they're unprofitable. You need to either raise rates, reduce scope, or fire them.
Many agencies discover that their largest client is their least profitable client. This forces a conversation: renegotiate terms or let them go.
Forecasting and Planning
Once you have historical data, you can forecast. If you've grown 20% year over year, you can project growth for next year.
Also use historical data to budget. If you know Q4 is your biggest quarter, plan hiring and cash flow accordingly.
When to Hire Help
If managing the P&L yourself is overwhelming, hire a bookkeeper or accountant. The cost (typically $500-2,000 per month) is worth it for accuracy and peace of mind.
Common Pitfalls
Don't mix personal and business finances. If you spend personal money on business or vice versa, separate it clearly. This ruins your P&L accuracy.
Don't estimate costs. Actually count. Many owners guess "we spend about $5k on software" when they actually spend $12k.
Don't ignore small costs. That $30 subscription you forgot about is real. Over a year, forgotten small costs add up.
Also don't just run this once. A P&L is only useful if you're checking it regularly and using it to make decisions.
FAQ
How often should I update my P&L?
Monthly. At minimum quarterly. More frequent is better for catching problems early.
What if revenue is lumpy because clients pay in advance?
Record revenue when you earn it, not when you're paid. This is accrual accounting. It's more accurate than cash accounting.
Should I include owner salary?
Yes. Include yourself at market rate. If you're the founder, pay yourself what you'd pay someone else in your role.
What's a healthy profit margin for an agency?
20-40% net profit is typical. Less than 15% means you're either growing at the expense of profitability or something's broken.
What if the P&L shows we're losing money?
You need to fix it. Either raise rates, cut costs, or change your business model. Don't ignore it hoping it improves.
Can I use my accounting software's P&L instead of a custom template?
Yes, if your accounting software's categories match your business. Many generic templates don't work well for agencies.