Client Profitability Tracker · Excel 365

See which clients are worth the hours.

For small agencies, studios and consultancies billing several clients a month, in one currency or several.

Contribution by client, project and month, before overhead.

client-profitability-tracker-v2.1.0-worked-example.xlsx Demo data
Summary sheet with demo data: totals for Aug 2026 and for all months, the 12 months ending in Aug 2026, and contribution before overhead by client.
  • 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
Open full-size image of the Summary sheet Watch the walkthrough (1:29)

01What it answers

Three 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.

  3. What does the month look like in one currency?

    Bill in pounds, pay freelancers in euros, report in dollars. Every money figure converts to the report currency you choose.

02Demonstration

See the actual workbook

Summary · live demo Demo data
Net fees6,357.89
Total delivery cost3,703.95
Contribution before overhead2,653.95
Contribution margin41.7%
Per-client summary for the selected month
Client Net fees Total delivery cost Contribution Margin Status

Figures in USD · Rows needing review: 0

Live demo: change the report currency or a rate and the totals update. Three sample records across two months, running in your browser.

Open the full demo, with an editable Work log

Walkthrough, 1:29: which clients pay for the work they take, then Start Here, Setup and the Dashboard, then one demo row goes in and checks itself. Captioned, no narration needed.
Read what the video shows
  1. See which clients pay for the work they take. In August, Driftwood Fitness did not. Summary sheet, By client, Aug 2026. Eight fictional clients. Driftwood Fitness is outlined: net fees 1,950.00, delivery cost 2,160.00, contribution before overhead -210.00 USD.
  2. Yellow cells: you type. Leave every other cell to the workbook. Start Here, row 3: the key sentence and the yellow swatch, "Yellow: you type here", are outlined.
  3. White cells calculate. Grey cells hold lists and reference values. The white swatch, "White: calculated, don't type here", is outlined, then the grey swatch, "Grey: lists and reference values".
  4. Start Here has nothing to type. Do this next says what to do. Start Here, row 5: Do this next is outlined. It reads "See the sample on the Dashboard, then clear the sample rows (steps below)." Nothing on Start Here is typed.
  5. Set once on Setup: business name, currency and first month. Setup, the first three settings are outlined: Business name (blank in the worked example, and optional), Report currency USD, and First month in month lists, Jan 2026.
  6. Setup complete reads Yes, so Do this next moves on. Setup, row 13: Setup complete reads Yes and is outlined. The note under it says that Start Here's Do this next reads this line.
  7. Pick the report month on the Dashboard. Empty means the latest month with OK rows. Dashboard, top: the Report month box is empty and outlined, with "Showing Aug 2026" beside it. The note beside it says the report currency, USD, is changed on Setup.
  8. The key figures follow it: 24,055.00 net fees, a 34.7% margin. Dashboard key figures for Aug 2026: net fees 24,055.00, delivery cost 15,711.50, contribution before overhead 8,343.50, contribution margin 34.7%, rows needing review 0. The margin is outlined.
  9. Add one row per client project per month. The clients here are fictional. Work Log, with column A and the header row fixed. The next empty row, row 21, is outlined.
  10. Type left to right. Client, month and currencies come from dropdowns. Row 21 is typed one cell at a time: EX-001, Aurora Dental, SEO retainer, Aug 2026, USD, 4,800.00, 0.00.
  11. Each row checks itself. This one reads Missing hourly cost. Then USD, 850.00 and 28.0. Before the hourly cost is typed, the view moves to the check columns: Required check for row 21 reads "Missing hourly cost".
  12. A row in Review stays visible but is left out of every total. Row status for row 21 reads "Review" and is outlined. Every other row reads OK.
  13. Type the last cell and the row reads OK. It now counts in every total. Back on the input columns, 55.00 goes into Hourly delivery cost. The check columns for row 21 now read OK in every column.
  14. Ten checks, each with a fix if it reads CHECK. Only Sample data is flagged. Dashboard Checks block: checks 1 to 9 read OK. Check 10, Sample data, reads SAMPLE, with the fix "Sample rows remain. Clear them from Start Here."
  15. Ready for your own clients? Clear the sample data in three steps. Start Here, "Clear sample data (worked example only)": three numbered steps using the Name Box and the names MV_Clear_WorkLog, MV_Clear_FXRates and MV_Clear_Reference.
  16. The status reads OK, every count is 0, and your settings stay. The Dashboard after the three clear steps: Status reads OK, the report month reads "No month yet" and Do this next reads "Add your clients on Reference, then one row per client project per month on Work Log." Then the Checks block: every count is 0 and every result reads OK.
  17. Help: the Guide sheet, and email support. We reply within 1 business day. The Guide sheet: setup steps with their times. Then Start Here, Support row: [email protected], and what to include in an email.
  18. See every sheet and try the live demo at metricvalley.com. End card: Client Profitability Tracker. Excel 365. Google Sheets edition included when it ships. metricvalley.com. Note on the card: every sheet shown is the v2.1.0 worked-example file in Excel 365, every client is fictional, and one Work Log row was removed before the video, then typed back in.

Watch it on its own page, with chapters

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 convert each row to the report currency and check it.

03What's inside

Eight sheets, one job

Demo data

Start Here

Setup in 5 steps: about 10 minutes, plus about 1 minute per row. The sheet map lists every sheet in tab order, with what it is for.

Nothing here is typed in. Your settings are on Setup. The status in row 3 of every sheet reads OK, CHECK (n) or SAMPLE.

Demo data

Setup

Each setting has its allowed values and its default beside it.

Change a setting at any time: the month lists, the Work Log checks and the results use it straight away.

Demo data

Dashboard

The report month is picked at the top (leave it blank for the latest month). Net fees, delivery cost, contribution before overhead, contribution margin and rows needing review follow it, in your report currency.

Do this next gives one step for the file as it stands. Ten checks, such as totals reconcile, rates present and no duplicate keys, give one overall status: OK, CHECK (n) or SAMPLE.

Demo data

Work Log

Record ID, client, project, month, fee currency, fees billed (before sales tax), credits, cost currency, external delivery costs, delivery hours, internal hourly cost and an optional note.

Holds 1,000 rows; the Guide gives the steps to add more. A row that fails a check reads Review and is left out of the totals until you fix it.

Demo data

FX Rates

Report in USD, EUR, GBP, AUD, CAD, NZD, JPY, SGD, HKD or CHF. The report currency is set on Setup.

Rates are typed as Australian dollars per 1 unit of each currency, so one rate per currency covers every pair. AUD is always 1. A source note is optional.

Demo data

Summary

Net fees, delivery cost, contribution before overhead, margin, delivery hours and contribution per delivery hour, for the report month and for all months.

Rows marked Review are counted and left out of the totals until they are fixed.

Demo data

Reference

Type each client name once; the Work Log client dropdown reads this list. It holds 200 clients.

The currency, month and theme lists and the fixed values, such as capacity and the reconcile tolerance, are shown in grey.

Demo data

Guide

Setup steps, every input and calculated column, every check and how to fix it, printing, protection, adding capacity and clearing sample data.

The changelog is the last section. Read it in Excel, or print it.

Exactly what's in the download

One ZIP file (about 466 KB), delivered by Payhip straight after payment.

FileWhat it isSize
xlsxclient-profitability-tracker-v2.1.0-blank.xlsx The workbook for your own data 470 KB
xlsxclient-profitability-tracker-v2.1.0-worked-example.xlsx The same workbook with fictional sample rows and illustrative rates 477 KB
htmlSTART-HERE.html Open this first: what each file is and where to begin 9 KB
mdquick-start.md Setup steps and how to read the result 7 KB
mdmetric-dictionary.md Every input and calculated field defined 24 KB
mdsupport-and-compatibility.md What is tested, what isn't, and how to ask for help 5 KB
mdlicense.md License terms for both licenses 3 KB
mdrelease-notes-v2.1.0.md What changed in version 2.1.0, and where the settings went 5 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
sha256MANIFEST-client-profitability-tracker-v2.1.0.sha256 SHA-256 checksums, so you can check every file arrived intact 1 KB

04Setup

Setup in 5 steps, about 10 minutes (estimate)

  1. Fill in Setup: business name, report currency, first month and theme.

    About 2 minutes.
  2. List your clients on Reference, one name per yellow cell.

    About 2 minutes.
  3. Add the month's rates on FX Rates, one rate per currency per month (AUD per 1 unit). Not needed for report-currency rows.

    About 3 minutes.
  4. Log the month on Work Log, one row per client project, using the dropdowns.

    About 1 minute per row.
  5. Pick the report month and read the Dashboard. OK means the totals are complete; CHECK names the problem in the Checks block.

    About 1 minute.

About 10 minutes, plus about 1 minute per row: a first month with 10 client projects takes about 20 minutes, including setup. Start Here tells you the next step.

05Worked example

A month at a fictional studio

Fictional example

Northfield Studio is a fictional four-person design studio that bills clients in US dollars, pounds and euros. In August it logged seven client projects; two rows were flagged for review until the August euro rate was added. The Summary then showed US$38,400 in net fees, US$24,100 in delivery cost and US$14,300 contribution before overhead, a 37% margin. One London retainer billed £4,000 (US$5,080 at their August rate) but took 71 hours at an internal cost of US$60 an hour, plus US$900 of freelance illustration, which left −US$80. They repriced that retainer for October and left the other six projects as they were.

August, seven projects (fictional)
Net feesUS$38,400
Delivery costUS$24,100
Margin37%
Contribution before overheadUS$14,300
London retainer, August (fictional)
Fee billed £4,000US$5,080
71 hours × US$60−US$4,260
Freelance illustration−US$900
Contribution before overhead−US$80

Northfield Studio is not a real business. The figures are illustrative, are not a customer result, and are not the data in the worked-example workbook.

06Fit

Is it right for you?

Good fit

  • Small agencies, studios and consultancies with several clients a month
  • Teams that mix staff hours and freelancer costs on the same project
  • Anyone billing or paying in more than one currency
  • Owners who want a monthly view they can check line by line

Not a fit

  • You need bookkeeping, invoicing, sales tax or cash-flow reporting.
  • You need net profit after overhead in the same file.
  • You want figures to arrive automatically from other software.
  • You need several people editing at once with permissions or change history.

Known limitations

  1. Contribution is before overhead. It is not net profit, accounting profit or cash flow.
  2. Exchange rates are typed in by hand each month, as Australian dollars per 1 unit. There is no live feed.
  3. Tested in Excel 365 for Windows desktop. Mac, Excel for the web and Google Sheets are not yet tested.
  4. Excel mobile and the Google Sheets mobile apps are for viewing only, not data entry.
  5. Each row uses one internal hourly cost, so hours are not split by person.
  6. Capacity is 1,000 Work Log rows, 600 rate rows and 200 clients; more needs the steps in the Guide.

07Tested on

Where it has been tested

Each release is tested against written checks, and the results are listed here and on the compatibility page. "Not yet tested" means exactly that: it may work, but we haven't confirmed it.

Latest test run

41/42 checks passed, 1 not yet run
Excel 365, Windows desktop
  • Workbook version2.1.0
  • Last testedNov 3, 2026
  • Excel 365, Mac desktopNot yet tested
  • Excel for the webNot yet tested
  • Google Sheets (native edition)Not yet tested
  • Excel mobile (iOS, Android)Not supported

What the cases cover

  • 41 of 42 release checks passed in Excel 365 for Windows; the other one (a high-contrast theme) needs a person at the screen and was not yet run
  • 25 of 25 deliberate-fault tests: each check reads CHECK when its fault is put in a test copy
  • 36 of 36 validation cases and 41 of 41 input messages
  • 48 of 48 values and 67 of 67 statuses match an independent recalculation: the worked example in USD and AUD, the 3-row setup card and the lite file
  • 1,000 Work Log rows and 600 rate rows at capacity, and 5,000 rows after following the Guide's add-capacity steps
  • Start Here, Setup, Dashboard, Summary and Guide print 1 page wide on US Letter and A4, at 63% scale or more
  • The 2.0.0 worked example pasted into the 2.1.0 blank file as values, each setting at its new cell: 21 of 21 reconciliation cases match an independent calculation
Environment Status Checks Version and build Last tested Notes
Excel 365, Windows desktop Tested with notes 41/42 passed, 1 not yet run Workbook 2.1.0 · Excel 16.0.20527.20112 · Windows Server 2025 Standard 10.0.26100 (build 26100) Nov 3, 2026 Automated native run on temporary copies: calculations, checks, validation, protection, clearing, theme, print on Letter and A4, 5,000-row capacity. Checked by hand in the Excel UI on 2026-11-03: 4.04, 4.05, 4.07. Not yet run: 4.11 (need the Excel UI or a system setting).
Excel 365, Mac desktop Not yet tested — — — Not yet tested.
Excel for the web Not yet tested — — — Not yet tested. No macros are used; editing unlocked cells on protected sheets must be checked there.
Google Sheets (native edition) Not yet tested — — — The Google Sheets edition is free for every buyer when it ships. Not yet tested.
Excel mobile (iOS, Android) Not supported — — — Viewing only; not tested for data entry.
Google Sheets mobile apps Not supported — — — Viewing only; not tested for data entry.
Google Sheets (importing the .xlsx) Not supported — — — Use the native Google Sheets edition.
LibreOffice Calc Not yet tested — — — —
Apple Numbers Not yet tested — — — —

What changed in 2.1.0

Nov 3, 2026

A Setup sheet for the settings you set once, a Start Here that says what to do next, and a report month you pick on the Dashboard. The calculations, checks and columns are unchanged.

  • Moved the settings from Start Here to a new Setup sheet: business name, report currency, first month in month lists and theme. Names unchanged.
  • Moved the report month to the top of the Dashboard, beside the figures it changes.
  • Start Here has a Do this next line and a map of the eight sheets, and nothing to type; the Dashboard has its own Do this next line.
  • Setup ends with a Setup complete line. It never changes the status in row 3.
  • Free for every buyer of 2.0.0, delivered through Payhip. Every column, table and named range is the same, so your 2.0.0 rows paste straight in.
  • Excel 365, Windows desktop: Tested with notes, 41 of 42 checks passed, 1 not yet run, workbook 2.1.0, Excel 16.0.20527.20112, tested Nov 3, 2026. Excel for Mac, Excel for the web and Google Sheets: not yet tested.

Inputs affected: Yes. The settings moved from Start Here to Setup, and the report month to the top of the Dashboard. Every name, table and column is the same, so your rows paste straight in; the release notes list where each setting went.

08What you get

What you get

Each purchase includes the files above, updates, email support and a license for your business.

  • Workbook: 8 sheets, no macros, no external connections; tested in Excel 365 for Windows desktop.
  • Updates: Free updates to the 2.x line for all buyers, delivered through your Payhip download link.
  • License: Single-business, for one business and all its staff. Agency/Team, US$99, adds working copies for up to 5 client businesses you manage, and is store-wide: it covers every Metricvalley business template your business owns.
  • Support: Email support; we reply within 1 business day.
  • Guide: a Guide sheet inside the workbook, plus a setup guide on this site.
  • Google Sheets: the Google Sheets edition is included free for every buyer when it ships.

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

09License

License

Two licenses. Both let you edit the workbook, keep backups and share the reports it produces. Neither lets you pass the editable file to another business. Tracking your own clients is exactly what Single-business is for. You need Agency/Team only if you keep a working copy for another business's own figures.

Single-business

included at US$49

For one business or sole trader, and everyone who works in it: staff and contractors.

Allowed
Edit and extend the workbook, keep backups, share reports and results with your team, clients, advisers and board.
Not allowed
Using it for a second business, giving an editable copy to a client or anyone outside the business, reselling or posting it online.
Buy for US$49

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

Agency/Team

US$99

For an agency and up to 5 client businesses it manages, and everyone who works in the agency. Store-wide: it covers every Metricvalley business template your business owns.

Allowed
Everything in Single-business, plus separate working copies for up to 5 client businesses you manage, as long as you keep the file and send them the results.
Not allowed
Giving clients or anyone outside your agency an editable copy, reselling, or including it in a product, course or template library.
Buy Agency/Team for US$99

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

On the Payhip page, choose Agency/Team under "Select license type".

The full terms are in the download and shown before checkout. Nothing in them limits rights you have under consumer law. Read the full license terms.

10Guarantee

30-day money-back guarantee

If the tracker isn't right for your business, email [email protected] within 30 days of purchase with your order number. You'll get a full refund to your original payment method. No questions asked and no forms to fill in; we only ask that you delete your copies. This guarantee is in addition to your rights under the Australian Consumer Law and any other consumer law that applies to you.

11FAQ

Questions before you buy

Do the exchange rates update automatically?

No. You type one rate per currency for each month; a note of where it came from is optional. That keeps the numbers fixed once a month is closed, and you decide which rate your business uses.

Why are rates entered in Australian dollars when I report in US dollars?

The workbook uses the Australian dollar as a fixed reference, so one rate per currency lets it convert between any two supported currencies. You still choose USD, or any of the 10 currencies, for the report. The Guide shows a worked conversion.

What happens to a row with a problem?

It is marked "Review", stays visible on the Work Log and in the count of rows needing review, and is left out of the totals until you fix it. Missing details, duplicate rows, text typed as numbers, off-list values and missing or duplicate rates are all caught, and the check columns name the problem. A negative contribution is not an error; it stays in the totals.

Can my whole team use it?

Yes, if they all work for the one business that bought it. A separate business, including a client or a related company, needs its own license. An agency that keeps separate working copies for client businesses it manages should use the Agency/Team license, which covers up to 5 client businesses. Agency/Team is store-wide: it covers every Metricvalley business template your business owns.

Can I change the workbook?

Yes, for your own business. Every sheet is protected without a password, so formulas aren't overwritten by accident; Review > Unprotect Sheet turns it off. Keep an untouched copy first. Changes to any cell that isn't yellow can stop the checks working, and support is easiest to give on the original file.

Will I get the Google Sheets edition?

Yes. The Google Sheets edition is included free for all buyers when it ships.

Is this the Client Fees & Delivery Tracker?

Yes. It was first released under that name. It is the same product with a new name. Version 2.0.0 changes the sheets and the Work Log columns, and its release notes show how to move your 1.x rows across. The files for version 1.x keep the original name.

I bought version 2.0.0. What changed in 2.1.0?

Version 2.1.0 is a free update, delivered through Payhip. The settings moved from Start Here to a new Setup sheet, and you pick the report month at the top of the Dashboard. Every name, table and column is the same, so your 2.0.0 rows paste straight in, and your 2.0.0 file keeps working as it is. The setup guide lists where each setting went.

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.

Does it work on a Mac?

It hasn't been tested in Excel for Mac yet, so we don't say it works there. The current version is tested in Excel 365 for Windows desktop, and it uses no macros. The compatibility page lists every environment and its status. If you buy it for a Mac and it doesn't work as described, the 30-day money-back guarantee gives you a full refund.

Does Agency/Team cover your other templates?

Yes. Agency/Team is store-wide: one Agency/Team license covers every Metricvalley business template your business owns, for up to 5 client businesses. No other template has an Agency/Team price of its own. If you start with Single-business, you can upgrade at any time by paying the difference (US$50): email [email protected] with your order number.

More answers in the setup guide and the help center.

Client Profitability Tracker · US$4930-day money-back guarantee. No questions asked.

Buy for US$49