Know what each client leaves after delivery costs.

Log fees, hours and direct costs for each client project. One Excel workbook shows what each client contributes before overhead, month by month. One-time purchase, no macros. Metricvalley has no subscription; editing still needs a licensed copy of Excel.

30-day money-back guarantee. No questions asked.

client-profitability-tracker-v2.1.0-worked-example.xlsx Demo data

Report month: Aug 2026. Report currency: USD.

Summary sheet of the Client Profitability Tracker: contribution by demo client for Aug 2026.
Client Net fees Delivery cost Contribution before overhead Contribution margin
Aurora Dental4,800.002,390.002,410.0050.2%
Beacon Legal3,120.002,310.00810.0026.0%
Copper & Co3,025.001,204.501,820.5060.2%
Driftwood Fitness1,950.002,160.00-210.00-10.8%
Elm Street Hospitality2,000.00720.001,280.0064.0%
Fable Studio3,500.003,017.00483.0013.8%
Greenfield SaaS2,160.001,740.00420.0019.4%
Harbor Retail3,500.002,170.001,330.0038.0%
All clients24,055.0015,711.508,343.5034.7%
  • Yellow cells: you type. Leave every other cell to the workbook.
  • Yellow: you type here
  • White: calculated, don't type here
  • Grey: lists and reference values

Summary sheet from the worked-example file. Previously released as Client Fees & Delivery Tracker. Open full-size image of the Summary sheet

  • No macros
  • One-time purchase
  • 30-day money-back guarantee

01What it answers

Two questions, answered every month

  1. Which clients and projects left the most after delivery costs?

    Contribution and margin for every client in the month you pick.

  2. Where did the hours outrun the fee?

    Contribution per delivery hour shows which work paid for the time, and negative results stay visible instead of being hidden.

02How it works

Once a month

  1. Log the work.

    Add one row per client project for the month: fees billed, credits, direct costs, hours and your internal hourly cost.

  2. Read the Dashboard.

    Pick the report month at the top. See net fees, delivery cost, contribution and margin for it, ten named checks and a chart by client, with problem rows flagged and kept out of the totals.

Yellow cells: you type. Leave every other cell to the workbook.

03Video

See what the templates do

A 0:45 captioned video of the worked-example files in Excel 365: which clients pay for the work they take, one Work Log row going in, which retainers run out of hours, how many months the cash covers, what a quote clears the walk-away price by, the color key and the ten checks. All four tools are on sale. Works with the sound off; every client is fictional.
Read what the video shows
  1. See which clients pay for the work they take. Driftwood Fitness did not. Client Profitability Tracker, Summary sheet, By client, Aug 2026, with eight fictional clients. Driftwood Fitness is outlined: net fees 1,950.00, delivery cost 2,160.00, contribution before overhead -210.00 USD.
  2. Type one row per client project a month. Clients are fictional. Work Log, row 21: the Aurora Dental row for August is being typed. Cost currency USD, external costs 850.00 and delivery hours 28.0 go in, one cell at a time.
  3. Complete the row: Aurora Dental's contribution now reads 2,410.00. Summary, By client: before the last cell, Aurora Dental shows 0.00 with one row in review. After the hourly cost is typed, it shows net fees 4,800.00, delivery cost 2,390.00 and contribution 2,410.00, outlined.
  4. See which retainers will run out of hours. Aurora Dental runs out on 24 August. Retainer Burn & Capacity Planner, Dashboard: the retainers with the least projected hours left in Aug 2026: Harbor Retail -28.5 (Over); Aurora Dental -10.2 (Runs out early, 24 Aug 2026); Greenfield SaaS -1.1 (Runs out early, 27 Aug 2026); Sample Studio 1.7 (Close to limit); Beacon Legal 4.3 (On track); Copper & Co 11.6 (Under-used). Aurora Dental is outlined: 36.0 hours available, 22.0 used to date, -10.2 projected hours left at month end, runs out early on 24 Aug 2026.
  5. See how many months the cash covers. Losing one client cuts 9 months covered to 5. Cash & Runway Planner, Dashboard: Plan: Oct 2026 to Sep 2027. Currency: USD. Change them on Setup. Outlined: months covered of 12, base case 9; Client leaves 5, fewer than the base case.
  6. Price a project so it still pays. The quote clears walk-away by 6,063.32. Project Quote Calculator, Dashboard, Key figures for quote EX-Q0142 for Harbor Retail: Website rebuild: quote price 25,500.00 USD, delivery cost 13,919.00, contribution before overhead 11,581.00, quoted margin 45.4%, markup on delivery cost 83.2%, headroom over walk-away price 6,063.32. The headroom figure is outlined.
  7. Yellow cells: you type. Leave the rest to the workbook. Client Profitability Tracker, Start Here, row 3: the color key. The key sentence and the yellow swatch are outlined; the white and grey swatches sit beside it.
  8. Ten checks, each with a fix if it reads CHECK. Client Profitability Tracker, Dashboard Checks block: ten named checks, each with a count, a result (nine read OK; check 10, Sample data, reads SAMPLE) and what to do if it reads CHECK.
  9. All four tools are on sale: profit, quotes, retainers, cash. Card, "Templates by decision": Price & quote, Project Quote Calculator, on sale. Client profitability, Client Profitability Tracker, on sale. Capacity & utilization, Retainer Burn & Capacity Planner, on sale. Cash & runway, Cash & Runway Planner, on sale. Each tool goes on sale only after it passes our release checks in desktop Excel. On sale now: all four tools.
  10. Spreadsheet tools for small agencies. Live demo: metricvalley.com. End card: Spreadsheet tools for small agencies. On sale: the Client Profitability Tracker, the Project Quote Calculator, the Retainer Burn & Capacity Planner and the Cash & Runway Planner. No macros, one-time purchase. Excel 365 · Google Sheets edition when it ships. metricvalley.com. Note: every sheet shown is the worked-example file in Excel 365 (the tracker v2.1.0, the three planners v1.1.0), every client is fictional, and one Work Log row was removed before the video, then typed back in.

Watch the explainer on its own page

Watch the full 1:29 walkthrough on the product page

04Live demo

Try it before you buy

The demo uses three sample records across two months and runs in your browser; nothing you change is sent anywhere.

client-profitability-tracker-v2.1.0-worked-example.xlsx Demo data
Work Log sheet with 14 demo rows: yellow input columns for record ID, client, project, month, fee currency, fees billed, credits, cost currency, external delivery costs, delivery hours, hourly delivery cost and notes, then white calculated columns.
Work Log. One row per client project per month. You type in the yellow columns; the white columns check each row.See all eight sheets
Try the live demo

The browser demo is a small illustration of the workbook's calculations. It is separate from the Excel file.

Previously released as Client Fees & Delivery Tracker. Same product, new name; the files for version 1.x keep the original name.

05Templates

Templates by decision

Each tool answers one business question. Pick the question you have this month.

Each tool goes on sale only after it passes our release checks in desktop Excel.

View all templates

Free lite edition, not released yet

A smaller version of the Client Profitability Tracker: one month per file, with the same contribution calculations and the same review flags. It isn't released yet and has no release date, so there's nothing to sign up for today.

06FAQ

Questions before you buy

Is contribution the same as profit?

No. Contribution is net fees minus direct delivery costs (your team's hours at an internal cost rate, plus external costs such as freelancers). It is before overhead like rent, software and admin time, so it is not net profit, and it is not cash flow.

Which version of Excel do I need?

Excel 365 on a Windows desktop computer. That is where the current version is tested. Excel for the web, mobile Excel, Excel for Mac, LibreOffice and Apple Numbers have not been tested yet, so check results carefully if you use them.

Is there a Google Sheets version?

A native Google Sheets edition is in progress, and it is included free for all buyers when it ships. Importing the Excel file into Google Sheets is not supported; use the native edition when it ships.

What happens after I pay?

Checkout is handled by Payhip. You get a download link on the confirmation page and by email: one ZIP file with a blank workbook, a filled-in example workbook and eight short files, including START-HERE.html, the license terms and a checksum manifest.

What if it isn't right for me?

Email us within 30 days and you'll get a full refund to your original payment method. No questions asked, and your rights under consumer law are not affected.

More answers in the help center