PRACTICAL GUIDE · PROJECT MARGIN

A busy project can still be the least profitable work in the portfolio.

Revenue alone cannot show whether a client project was healthy. The project record needs a fee, a time log and direct expenses connected by one stable ID. That structure reveals margin while the work is active and after it closes.

Practical methodReviewed 17 August 2026Excel + Google Sheets

Core takeaway

Track fee, labor and direct expenses with the same project ID, then review margin and collections together before quoting the next engagement.

1. Create a master project record

Store project ID, client, fee, budget, dates, status and amount collected. The ID connects time and expenses without relying on a project name that may change.

2. Convert time into an internal labor cost

Log hours by project and multiply them by a consistent internal cost rate. This is a management assumption, not necessarily payroll cost, and should be documented clearly.

3. Add direct expenses before calculating margin

Travel, subcontractors, materials, transaction fees and other project-specific costs reduce profit even when they do not appear in the time log.

4. Read active margin as an interim signal

An active project may still incur hours and costs. Use margin to spot drift, not to declare a final result early. Compare completed projects separately and review outstanding fees beside profit.

Educational organization and planning content only. It does not replace tax, legal, accounting, financial or technical advice where applicable.

WORKFLOW CHECKLIST

The complete routine in six steps.

  1. 01Assign a stable project ID
  2. 02Record agreed fee and budget
  3. 03Log every hour
  4. 04Apply an internal labor cost
  5. 05Add direct expenses
  6. 06Review margin and collections together

APPLY THE METHOD

Use a workbook that already connects the steps.

The template turns this method into editable inputs, checks and summaries with realistic example rows.

Client Project Profitability Tracker

Client Project Profitability Tracker: real dashboard

FREQUENTLY ASKED QUESTIONS

Before you begin.

What internal hourly cost should I use?

Use a documented management assumption that reflects the cost you want the project to cover. Keep it consistent for comparisons and update it when the economics change.

Is active-project profit final?

No. It is an interim view based on recorded work and costs so far. Review the final result after delivery and complete cost capture.

Should unpaid fees count as profit?

Profitability and cash collection are different views. Track the contracted fee and outstanding amount separately so neither hides the other.