How do I track project-based revenue and expenses as a consultant or creative agency?

Every project needs its own profit and loss view. Without it, you know whether the business made money overall, but you have no idea which projects drove that profit and which ones quietly drained it. That distinction shapes your pricing, your proposals, and which clients you want more of.

Start by creating each engagement as a separate tracking category in your accounting software. In QuickBooks Online, the Projects feature lets you group income and expenses under a single client engagement. Name them consistently, something like “Client Name - Project Description,” so they’re easy to find and compare. If you run multiple projects for the same client, each one gets its own entry.

On the revenue side, record income against the specific project when you invoice. Hourly billing is straightforward since each invoice ties directly to the project. For fixed-fee work, recognize revenue when you invoice or as milestones are completed. Retainers that cover ongoing monthly work should be recognized each month rather than all at once when the check arrives.

Direct expenses are anything you can tie to a specific project. Subcontractor fees, stock photography, paid media spend managed on a client’s behalf, travel to a client meeting, a software license purchased for a specific engagement. Code every one of these to the project. Indirect expenses like your office lease, general subscriptions, and insurance are overhead. Track them separately rather than trying to split them across projects. For most small creative services firms and consultancies, the added complexity of full overhead allocation doesn’t improve your decision-making enough to justify the effort.

Time tracking is the piece most people skip, and it matters more than anything else. Labor is typically the largest cost in a service business. If you don’t know how many hours went into a project, you don’t know your real margins. A $12,000 fixed-fee project sounds great until you realize your team put in 180 hours, which works out to about $67 per hour before overhead. Track time on every project, especially fixed-fee ones, because that’s how you learn whether your pricing reflects reality.

Review project profitability at least monthly. Pull a report showing revenue minus direct costs for each active engagement. Compare actual hours against your original estimate. If a project is running over, you want to catch it while you can still adjust scope or have a conversation with the client rather than discovering it after the final invoice goes out.

Over time, this data becomes your most valuable business asset. You’ll see patterns in which types of work generate the best margins and which clients consistently run over scope. That insight feeds directly into smarter proposals and better resource planning. Bookkeepers in Orlando who understand service-based businesses can structure your chart of accounts and project tracking from the start so the numbers actually tell you something useful, instead of leaving you guessing about where the money went.