Agency Profit per Project: How to Build a Simple Tracking System

Key takeaways

• Know your true cost: Agency profit per project isn't just revenue minus obvious costs. You must include all team time, software, and overheads allocated fairly to see the real number.
• Track time religiously: Without accurate time tracking, you're guessing at profitability. Every hour spent on a project is a direct cost that eats into your margin.
• Simple systems win: You don't need complex software to start. A well-organised spreadsheet can become a powerful project margin tracker to guide your decisions.
• Review and act weekly: Checking project profitability weekly lets you catch scope creep early, adjust resourcing, and have better client conversations about budgets.
• Profit informs pricing: Understanding your agency profit per project on past work is the single best input for pricing future projects more accurately and profitably.

What is agency profit per project and why does it matter?

Agency profit per project is the actual money you keep after paying for everything a specific project needs. This includes team salaries, freelancer costs, software subscriptions, and a fair share of your office rent. It's the clearest measure of whether a project was worth doing.

Many agencies look at overall monthly profit and think they're doing okay. But this hides a dangerous truth. You can have one hugely profitable client carrying three others that are slowly losing you money. Tracking profit at the project level shows you exactly where your money comes from.

For a marketing agency, this is especially critical. Creative work, client revisions, and scope changes can quickly turn a profitable project into a loss-maker. A simple per-project profitability system acts as an early warning signal.

It tells you if you're pricing correctly, if your team is efficient, and which types of work you should pursue more of. Without it, you're flying blind, making decisions based on gut feeling rather than hard financial data.

How do you calculate agency profit per project accurately?

You calculate agency profit per project by adding up all project revenue, then subtracting all direct and allocated costs. The formula is simple: Project Revenue - (Direct Labour + Direct Expenses + Allocated Overhead) = Project Profit. The challenge is capturing all those costs correctly.

Start with direct labour. This is the biggest cost for most agencies. If your designer spends 20 hours on a website project, and their fully-loaded cost (salary, benefits, employer taxes) is £50 per hour, that's a £1,000 direct cost. You need a time tracking system to capture this accurately.

Next, add direct expenses. These are costs bought specifically for the project. This could be stock imagery, paid social ad spend you manage on behalf of the client, freelance copywriting, or premium software plugins. These are easy to track if you have a good expense process.

The final piece is allocated overhead. This is the trickiest but most important part. Your office, accounting software, project management tools, and management time aren't free. You need to spread these costs across projects.

A simple method is to use a cost-per-hour rate. Add up all your monthly overhead costs. Divide that by the total number of billable hours your team works in a month. This gives you an overhead cost per billable hour. Then multiply that by the hours spent on the project.

For example, if monthly overheads are £10,000 and your team logs 500 billable hours, your overhead rate is £20 per billable hour. A 50-hour project would carry £1,000 of allocated overhead cost. This gives you a true picture of agency profit per project.

What does a simple project margin tracker look like?

A simple project margin tracker is a spreadsheet or software dashboard that shows, at a glance, the financial health of every active project. It lists each project, its budget, costs to date, and calculated profit margin. The goal is visibility, not complexity.

Your tracker needs a few key columns. Project Name, Client, Total Project Fee (your price), Total Labour Cost (team time x cost rates), Total Direct Expenses, Allocated Overhead Cost, Total Cost, Project Profit (in pounds), and Project Margin (profit as a percentage of the fee).

You can build this in Google Sheets or Excel. The magic happens when you connect it to your time tracking and accounting software. Many tools like Xero, QuickBooks, or Harvest allow you to export data. You can then use simple formulas to pull the numbers into your tracker automatically.

The visual output is powerful. You can use conditional formatting to colour-code projects. Green for profitable (e.g., margin above 20%), amber for at risk (margin between 0-20%), and red for loss-making (margin below 0%). This creates an instant, actionable snapshot for your weekly team meeting.

This project margin tracker becomes your most important commercial tool. It moves the conversation from "Are we busy?" to "Are we working profitably?" For specialist support in setting this up, our team of accountants for digital marketing agencies can help build a system tailored to your workflow.

Why do most agencies get per-project profitability wrong?

Most agencies get per-project profitability wrong because they only track obvious out-of-pocket expenses. They forget to account for the real cost of their team's time and a fair share of company overheads. This makes projects look more profitable than they are, leading to underpricing.

The most common mistake is using salary cost instead of fully-loaded labour cost. An employee costing £40,000 per year doesn't just cost £40,000. You must add employer National Insurance contributions, pension contributions, benefits, and training. Their true cost might be closer to £50,000.

Divide that by their productive hours (not total hours in the year). If they have 1,200 billable hours in a year, their cost per billable hour is about £41.67. Using a lower, salary-only rate distorts your project costing and your understanding of agency profit per project.

Another major error is ignoring non-billable time. Time spent on internal meetings, training, and admin still costs you money. This cost must be covered by the profit from billable work. Your project pricing needs to build in enough margin to cover this essential non-client work.

Finally, agencies often fail to track time accurately. If your team isn't logging time properly, you have no data. You're guessing how long tasks take, which means you're guessing at costs and profitability. Implementing a simple, non-punitive time tracking culture is the first step to fixing this.

What are the essential metrics for a project tracking system?

The essential metrics are project margin percentage, cost overrun percentage, utilisation rate on the project, and estimated final profit. These four numbers tell you everything you need to know about a project's financial health and your team's efficiency.

Project Margin Percentage: This is your project profit divided by the project fee, expressed as a percentage. It's the ultimate measure of success. For example, a £10,000 project with £7,000 in costs has a 30% margin. Most agencies should target 25-40% net project margin for sustainable growth.

Cost Overrun Percentage: This shows how much you've overspent against your planned budget for costs. If you budgeted £5,000 for labour but have already spent £6,000, you have a 20% cost overrun. This is a red flag for scope creep or underestimation.

Utilisation Rate on the Project: This measures how much of the logged time was billable to the client versus internal or write-off time. A low rate suggests process problems or scope confusion. You want this to be as high as possible, typically above 85%.

Estimated Final Profit: Based on costs to date and remaining work, what profit do you expect to make when the project finishes? This forward-looking metric helps you decide if you need to have a budget conversation with the client now.

Tracking these metrics weekly gives you control. You can spot trends, like certain types of projects consistently going over budget. This data is gold when planning your agency's service offerings and pricing strategy. For a deeper dive into your overall financial health, take our free Agency Profit Score.

How can you build a tracking system without expensive software?

You can build an effective tracking system using a spreadsheet, your existing time tracking tool, and disciplined weekly habits. The process is more important than the platform. Start simple, get the habit right, then upgrade your tools if needed.

Step one is choosing a time tracker. Use something free like Clockify or the built-in timer in your project management tool (like Asana or Trello). The rule is simple: every task related to a client project gets logged against that project. Make this non-negotiable for your team.

Step two is building your project margin tracker spreadsheet. Create a tab for each active project. On each tab, have sections for: the project budget, a running log of time entries (pulled from your time tracker), a list of receipts for direct expenses, and a summary box that calculates profit automatically.

Use simple formulas. Your summary box should add up all the hours logged, multiply by the individual's cost rate, add expenses, add allocated overhead, and subtract the total from the project fee to show profit and margin.

Step three is the weekly review. Every Monday, export the time data from last week. Update your spreadsheet. Look at the profit margin for each project. If any project is in the amber or red zone, investigate immediately. Was it scope creep? An inefficient process?

This manual system, while basic, forces you to engage with the numbers. After a few months, you'll have invaluable data on what types of work are most profitable for your agency. You can then consider investing in integrated software like Xero Projects or Accelo, which automate much of this process.

How do you use project profit data to make better decisions?

You use project profit data to guide pricing, service design, client selection, and team development. It turns financial history into a strategic roadmap. The data shows you what you're good at, what you should charge more for, and what you should stop doing.

First, use it for pricing. Look at your historical agency profit per project. If your branding projects consistently hit 35% margins but your social media content projects struggle to reach 15%, you have a signal. You might need to increase prices for social content, improve your processes, or stop offering it.

Second, inform service design. Break down profitability by service type and client size. You might discover that one-off website projects are less profitable than ongoing retainer work. This could lead you to redesign your offerings to encourage longer-term, more predictable engagements.

Third, guide client selection. If a certain client profile consistently leads to low-margin projects due to endless revisions or poor communication, you can spot the pattern. You can then adjust your onboarding process to screen for these red flags or price them accordingly to reflect the higher cost of servicing them.

Finally, drive team development. If projects led by a certain project manager consistently have higher margins, find out why. What processes are they using? Can you train the rest of the team in their methods? This data helps you invest in what works.

According to a report on agency profitability, agencies that track project-level metrics are 30% more likely to exceed their profit targets. The data empowers you to be proactive, not reactive.

What are the common pitfalls in project profitability tracking?

The common pitfalls are inaccurate time tracking, using the wrong cost rates, forgetting to allocate overhead, and not reviewing the data regularly. Each of these can completely distort your view of agency profit per project, leading to bad business decisions.

Inaccurate time tracking is the biggest pitfall. If your team logs time in big chunks at the end of the week, the data is unreliable. Encourage real-time tracking. Make it easy and part of the workflow. The data is only useful if it's accurate.

Using the wrong cost rates is next. As mentioned, you must use fully-loaded labour rates, not just salary. Also, remember that cost rates change. When you give someone a pay rise, their cost per hour goes up. Update your rates in your project margin tracker at least once a year.

Forgetting to allocate overhead is like pretending your office rent is free. It's a real cost of doing business. If you don't allocate it, your project profits will be artificially high. You might think you're making a 40% margin when it's really 25%. This leads to under-pricing and profit stagnation.

Finally, not reviewing the data makes the whole exercise pointless. A tracking system is a tool for conversation and action. Schedule a weekly 30-minute commercial meeting with your leadership team. Review the project dashboard. Discuss any projects in the red or amber. Decide on actions.

Avoiding these pitfalls turns your per-project profitability tracking from an accounting chore into a powerful management tool. It gives you the confidence to say no to bad work, yes to good work, and price your services based on reality, not hope.

How can you improve agency profit per project starting next week?

You can improve agency profit per project by implementing a simple three-step plan: enforce time tracking, build a basic tracker, and institute a weekly review. Focus on your next project that kicks off, not trying to retrofit data onto old work.

On Monday, have a team meeting. Explain the new focus on understanding agency profit per project. Introduce a simple time tracking tool. Frame it positively: "This helps us price fairly, work on the best projects, and build a sustainable business where we can all grow."

On Tuesday, set up your project margin tracker spreadsheet. Use the template structure outlined earlier. For your next new project, create a tab. Input the project fee and budget. This will be your pilot.

For the rest of the week, ensure everyone logs their time to the new project in the tracker. At the end of the week, on Friday afternoon, spend 20 minutes updating the spreadsheet. Calculate the costs to date and the current margin.

Next Monday, review the data. How does it look? Is the project on track? Use this single data point to start a new habit. The goal is consistency, not perfection. Over time, you'll roll this out to all projects. You'll start seeing patterns that allow you to increase profitability across the board.

Getting a clear view of your agency profit per project is one of the highest-return activities you can do. It directly impacts your bottom line. To see how your overall financial health measures up, take our free Agency Profit Score. It takes five minutes and gives you a personalised report.