The real P&L of a creative project: what your best job actually paid you per hour
You tracked the $8,000. You never tracked the $31/hour. Run the real P&L of a creative project, revenue minus your true time and expenses, and find out which client actually pays.
Most people track revenue. Very few track profitability. That is why busy months feel broke.
You know what your projects bring in. The $8,000 brand job, the $5,000 video, the retainer. What you almost certainly do not know is what any of them paid you per hour, after the real time you put in and the expenses you ate. Those are two completely different numbers, they live in two completely different apps, and the gap between them is exactly why a packed quarter can still leave your account looking thin. This guide runs the math on one project, then on a whole client list. The second number will surprise you.
The project that looked great
You quoted $8,000. The client said yes. For two months it was the project, the one that made the quarter feel handled. You watched the invoice. You never watched the rate. Here is the part you skipped:
| Line | Amount |
|---|---|
| Project revenue | $8,000 |
| Hours you actually worked | 180 hrs |
| Time cost (180 × your $50 internal rate) | −$9,000 |
| Direct expenses (stock, fonts, contractor, shipping) | −$1,200 |
The two numbers that matter
Revenue is a vanity number. Two others tell the truth:
- Real profit, what is left after your time and your expenses. Strip the $1,200 in expenses and you are at $6,800 before you have paid yourself a cent for 180 hours of work.
- Effective hourly rate, that profit divided by the hours you actually worked. Include the unscoped revisions, the calls, the email that never hit a timesheet, and the $8,000 job lands around $31/hour. You quoted a great project. It paid you like a middling one.
The exact decimal moves with your rate and hours, that is why there is a worksheet below that uses yours. The point is the gap between the price you celebrated and the rate you earned.
Your best-paying client isn't your most profitable one
Run it across everyone and sort by effective rate. The list reorders:
| Client | Revenue (yr) | Hours | Expenses | Effective rate | by revenue | by profit |
|---|---|---|---|---|---|---|
| Big Retainer Co. | $48,000 | 1,050 | $4,200 | ~$42/hr | 1st | 3rd |
| "$8k Brand Refresh" client | $24,000 | 720 | $5,800 | ~$25/hr | 2nd | 4th |
| Quiet Monthly Studio | $18,000 | 230 | $900 | ~$74/hr | 3rd | 1st |
| One-Brief Wonder | $9,000 | 120 | $600 | ~$70/hr | 4th | 2nd |
The client who writes the biggest checks is third on the list that actually pays your rent. The "small" retainer you nearly dropped is your most profitable relationship. Revenue ranks your clients one way; profit ranks them the opposite way, and most people make their keep-or-drop, raise-or-hold decisions off the wrong list.
Why nobody runs this number
It is not laziness, it is that the calculation is structurally impossible with the tools most people own. Your time lives in one app, expenses in another, invoices in a third. The one equation that tells you whether the work paid needs all three in the same place, and they never are. So "am I actually making money?" becomes a Sunday-night spreadsheet you build twice and abandon. Busy months feel broke because busy counts hours and broke counts profit, and nothing you own holds both at once.
Run your own P&L
Enter one project’s revenue, the hours you really worked, and the expenses. Get your real profit and your effective hourly rate in under a minute. Then do it for your top three clients and watch the ranking flip.
Common questions
Take the revenue, subtract direct expenses, then subtract the cost of the hours you actually worked at your internal rate. What is left is real profit; divide it by the hours for your effective rate.
Busy counts hours; profit counts what is left after time and expenses. A high-revenue project with huge hours can quietly pay a low effective rate.
What a project actually paid you per hour after all the real time (meetings, revisions, email) and expenses, not the rate you quoted.
Time, expenses, and invoices usually live in three different tools, so the one calculation that needs all three never has them in the same place.