Tracking Project Profitability: A Guide for Agencies and Consultants

The Service Business Trap: Busy but Unprofitable

For agencies, law firms, and consultants, it’s easy to fall into the trap of being incredibly busy but not actually making money. When you look at your overall Profit and Loss statement, you might see a net profit. But without tracking profitability at the project or client level, you have no way of knowing which engagements are driving your success and which ones are quietly draining your resources.

To scale a service business safely, you must know your margins. This requires structuring your QuickBooks Online file to track direct costs against specific revenue streams.

Separating Direct Costs from Overhead

The first step to tracking project profitability is fixing your Chart of Accounts. You must clearly separate Cost of Services (COS) from general Operating Expenses (Overhead).

• Cost of Services: Expenses directly tied to delivering the project. This includes subcontractor fees, specific software licenses purchased for the client, and the direct labor cost of your employees working on the account.
• Overhead: Expenses required to run the business regardless of client load. This includes office rent, marketing, administrative salaries, and general software (like your own QuickBooks subscription).

By separating these, you can calculate your Gross Profit Margin - the true measure of whether your service delivery model is financially viable.

Using Classes, Locations, or Projects in QuickBooks

Once your Chart of Accounts is structured correctly, you need a way to tag income and expenses to specific clients. QuickBooks Online offers several ways to do this:

1. Class Tracking

Classes are best used to track different service lines or departments (e.g., “SEO Services” vs. “Web Development”). This allows you to run a P&L by Class to see which department is the most profitable.

2. Project Tracking

If you are on QuickBooks Online Plus or Advanced, the Projects feature is the most powerful tool for agencies. It allows you to assign revenue, contractor bills, and employee timesheet data directly to a specific project. You can then run a Project Profitability report with a single click.

The Challenge of Allocating Payroll

For many agencies, the biggest direct cost is employee payroll. If you just dump your entire bi-weekly payroll run into a general “Salaries” expense account, your project profitability will be completely skewed.

To get accurate data, your team must track their time. You can then use tools like QuickBooks Time or third-party integrations to allocate those payroll dollars to the specific projects they worked on. This reveals the true cost of delivering the service.

Ready to Get Visibility into Your Margins?

Setting up project tracking and restructuring your Chart of Accounts can be complex, but the clarity it provides is game-changing. Learn more about my bookkeeping for service businesses or book a free consultation to discuss your setup.