Freelance operations · 2026-11-13

The Money Leak View: Finding the Project That Ate Your Month

You will not discover the losing project at the end of the project. You will discover it somewhere in the middle — probably after the invoice was already sent, when the number is a fact rather than a decision. The fix is not discipline. It is a view that makes the leak visible while it is still small enough to act on.

The project that is quietly costing you

A fixed-fee project can pay you less than your day rate without anyone noticing. The hours log grows by three here, four there; every week the gap between estimate and actual is small, and small numbers are easy to round away. Then the project closes, you add it up, and the "profit" was worked at a rate you would have turned down if anyone had proposed it up front.

This is not a client problem. It is a measurement problem. The work was visible; the arithmetic was not.

Why it hides so well

Three habits keep the leaking project invisible, and all three are normal:

1. Hours get logged late or in blocks. A week of "about ten hours" hides the eleven-hour week and the fifteen-hour week that follow.
2. Estimate and actual are in different places. The estimate lives in the proposal you sent; the actual lives in a time tracker neither of you looks at.
3. The invoice arrived already. Once money has moved, the project stops being a question and becomes a memory — and memory rounds in your favour.

None of these is dishonesty. They are just the default state of a solo business with no review structure.

The three numbers that expose it

You need three numbers per project, and they need to be in the same place:

• Estimated hours — what you told the client at the start.
• Actual hours — what the project really took, kept current.
• Effective rate — fee ÷ actual hours.

The third one is the honest number. Your quoted rate is what you said; the effective rate is what the project is actually paying you, and it is the number that should decide whether you take the next similar job.

One project paying below your floor is a mistake. The second one is a pattern, and patterns are pricing problems.

The view that finds it

A Money Leak view is a filter over your open projects: every project where actual hours exceed the estimate, sorted by the size of the gap. The sorting matters — the leak that costs you the most should be the first thing you see, not the last thing you scroll to.

The view makes three things true at once:

• The gap is quantified, so it stops being a feeling.
• The gap is sorted, so the worst project races to the top.
• The gap is dated, so you can see whether it is getting better or worse week to week.

Most people find one bleeding project the first time they look. That is not a coincidence. It is the difference between a business that checks its math and one that hopes.

What you do with the finding

When a project shows up in the Money Leak view, there are exactly two honest paths, and you should pick one inside a week:

Path one: reprice the remaining scope. Have the conversation now, while the project is still in flight. The frame is not "I under-bid" — it is "here is what the work actually requires, given what we now know; here are the options." Clients accept this far more often than people expect, because the alternative is a deadline that slips and a relationship that sours at delivery.

Path two: absorb it on purpose. Sometimes the project is a relationship investment, a portfolio piece, or a future referral source — and it is fine to lose money on it deliberately. What is not fine is absorbing it by accident, which is the default.

The view does not make the choice for you. It makes sure the choice is made by you, with the number in front of you, instead of by silence.

What it looks like with real arithmetic

Three projects, the same fee, three different stories. The rates and hours below are illustrative — they exist to show how the comparison works, not to suggest what you should charge:

Project B is the one to look at. It invoiced the same as A, took nearly twice the hours, and paid roughly half the rate. Nothing about it felt wrong while it was happening: each week added a few hours, each addition was reasonable, and the invoice was already agreed.

Sort by effective rate and the picture changes immediately. The question stops being "how busy was I" and becomes "which of these should I stop taking" — and the answer is usually a shape of work, not a specific client.

One more thing the table shows: project C is fine. It has the most hours and the lowest headline estimate but a healthy rate. If you judge projects by hours alone, you will misread it. The effective rate is the only column that ranks them honestly.

The five-minute weekly habit

Once a week — the same morning each week — look at the view for five minutes:

1. What moved this week? Any project that crossed into the red?
2. Which project has the largest gap, and what is the one decision that would fix it?
3. What will I do about it before Friday?

Three questions, five minutes, one line in a review log each week. The habit does not create new work; it makes the work you are already doing visible.

The honest limit

This is not accounting. It will not tell you your margin, your tax position, or what to invoice. It answers one question: which of my current projects is quietly paying me less than my rate? That single question is worth more than the rest of the tracking combined, because it is the question nobody else is asking.

The one-line version

A project that eats your month does not announce itself. It leaks three hours at a time, and the only defence is a view that sorts your projects by who is losing you money — looked at once a week, with a decision attached.

Related notes

• Four Numbers Every Freelance Tracker Should Calculate — the arithmetic behind effective rate and hours over.
• How to Estimate Hours Without Lying to Yourself — where the estimate that starts the comparison comes from.
• The Monday Review: Is Your Consulting Business Actually Alive? — the weekly review that this view feeds into.