Back to all guides
Scale Up~35 min

Figure Out Which Projects Are Actually Making You Money

Most service businesses track revenue, not profitability per project. You know your top line — but not which project types, clients, or phases are actually profitable. The project that looked great on paper? It might have lost money once scope creep hit. This guide walks you through auditing your recent projects to find your real effective hourly rate, flag the ones that are silently underperforming, and build systems to protect your margins. Works for architecture firms, design agencies, consultants, law firms, construction, accounting, and any project-based service business.

Intermediate~35 minChatGPT or Claude · Your project time and fee data

What You’ll Get

  • A profit audit showing your effective hourly rate per project and type
  • A clear view of which project types or clients are quietly unprofitable
  • A scope-management system to prevent margin erosion mid-project

Step-by-Step Guide

1

Pull your project financials

Gather data for your last 5–10 projects so you can see which are actually profitable.

Data you need

For each project, collect: project name/type, contracted fee, hours spent (total and by phase if trackable), hourly rate of each person who worked on it, any additional services billed, and any scope changes or extras done for free.

2

Run a project profit audit

Paste your project data and let AI calculate your real profitability — by project, by phase, and by project type.

Prompt
I run a [BUSINESS TYPE — e.g. design agency, consulting firm, construction company] and I want to understand which projects are actually profitable.

Here is my project data:
[PASTE YOUR PROJECT DATA — for each project include: project name, type, fee, hours by phase if applicable, staff involved and their hourly rates, additional services billed]

Please analyze:
1. Calculate the effective hourly rate for each project (total fee ÷ total hours)
2. Compare profitability across project types — which types are most/least profitable?
3. Flag any projects where my effective hourly rate fell below my target rate
4. Identify patterns — are projects from certain clients, sizes, or scopes consistently underperforming?
5. Calculate what my average project profit margin is
6. Identify the top 2–3 patterns costing me the most money
3

Build scope-proof proposals

Create a proposal template that explicitly defines what’s included and what’s not, so scope creep can’t happen silently.

Prompt
Based on my profitability analysis, help me create a proposal template that prevents scope creep.

My business type: [TYPE]
My typical project size: [RANGE]
My standard hourly rates: [PRINCIPAL/SENIOR/JUNIOR rates if applicable]
My typical project phases: [LIST — e.g. discovery, design, build, QA; or SD/DD/CD]

Please create:
1. A proposal template with explicit scope boundaries for each phase — exactly what’s included and what’s not
2. An "Additional Services" schedule with hourly rates and common add-on services
3. Clear "Not Included" language that prevents scope assumptions — the things clients often assume are included but shouldn’t be
4. A fee structure recommendation: fixed fee, hourly with cap, or phased billing? Based on my data, which protects margins best?
5. A change order template for when scope changes occur mid-project
4

Create a scope management habit

Mid-project is where most margin erosion happens. Build a weekly review habit to catch it early.

Prompt
I want to build a simple weekly scope management habit so I catch margin erosion before it becomes severe.

My typical project duration: [WEEKS / MONTHS]
My team size: [NUMBER]

Please create:
1. A weekly 15-minute project review checklist (scope consumption, hours vs. budget, client behavior signals)
2. An early-warning trigger list — when I should have a scope conversation with a client
3. A client email template for when scope is being exceeded (professional, references the contract, quotes additional services)
4. A project post-mortem template for when a project wraps — to capture lessons for future estimating

What to Expect

Most businesses discover that 1–2 project types or client types are significantly less profitable than assumed. The proposal template (Step 3) prevents the same pattern on future work. The weekly habit (Step 4) is where sustained margin protection comes from.

If you don’t track hours per project, estimate them for your last 3–5 projects. Even rough numbers reveal patterns. This is the first time through — precision comes later.

The audit itself takes 30–60 minutes. The proposal template is a one-time build. The weekly habit is 15 minutes. The ROI is measured in the projects you NO LONGER lose money on.