Help · Client Profitability Tracker
Set up the Client Profitability Tracker
This guide covers version 2.1.0, the version you download today. Estimate: setup takes about 10 minutes, plus about 1 minute for each client project you log. A first month with 10 client projects takes about 20 minutes in total.
Previously released as Client Fees & Delivery Tracker. Same product, new name; the files for version 1.x keep the original name.
Before you start
- You need Excel 365 on a Windows desktop computer. That is where this version was tested. Other apps are listed on the compatibility page.
- Have one month of figures ready: fees billed, any credits, direct costs such as freelancers, and delivery hours for each client project.
- Sheet names and column labels below are quoted exactly as they appear in the version 2.1.0 file.
Yellow cells: you type. Leave every other cell to the workbook.
1. Download the ZIP file
About 2 minutes.
- After payment, Payhip shows a download link on the confirmation page and sends the same link by email.
- Click the link and save the ZIP file (about 466 KB) somewhere you will find it again, such as a "Metricvalley" folder in Documents.
Can't find the email? Search your inbox and spam folder for "Payhip". If it isn't there, email [email protected] with the address you used at checkout and we'll resend the link.
2. Unzip it
About 1 minute.
Excel can open a file from inside a ZIP, but it opens a temporary read-only copy, and your changes may be lost. Extract the files first.
- Windows: right-click the ZIP file, choose Extract All, then Extract.
- Mac: double-click the ZIP file. The files appear in a new folder beside it.
You now have ten files:
| File | What it is |
|---|---|
client-profitability-tracker-v2.1.0-blank.xlsx |
The workbook for your own data |
client-profitability-tracker-v2.1.0-worked-example.xlsx |
The same workbook with fictional sample rows and illustrative rates |
START-HERE.html |
Open this first: what each file is and where to begin |
quick-start.md |
Setup steps and how to read the result |
metric-dictionary.md |
Every input and calculated field defined |
support-and-compatibility.md |
What is tested, what isn't, and how to ask for help |
license.md |
License terms for both licenses |
release-notes-v2.1.0.md |
What changed in version 2.1.0, and where the settings went |
money-back-guarantee.md |
The 30-day money-back guarantee |
MANIFEST-client-profitability-tracker-v2.1.0.sha256 |
SHA-256 checksums, so you can check every file arrived intact |
START-HERE.html opens in any browser. The .md files open in any text editor, such as Notepad or TextEdit.
3. Open the worked example, then save your own copy of the blank file
About 2 minutes.
- Open
client-profitability-tracker-v2.1.0-worked-example.xlsxto see a finished Dashboard. Every client in it is fictional, and the status readsSAMPLEuntil the sample rows are cleared. - Open
client-profitability-tracker-v2.1.0-blank.xlsx. Excel may show a yellow Protected View bar that says the file came from the internet. This is normal for any downloaded file. Click Enable Editing. The file has no macros, so you will not see a macro or content warning. - Choose File > Save As and save a copy with your business name and the year in the file name, for example
northfield-client-profitability-2026.xlsx. Keep the format as Excel Workbook (.xlsx). - Keep the original download untouched in its folder. It is your clean copy if you ever need to start again.
If Excel says it can't open the file in Protected View, close it, right-click the file in File Explorer, choose Properties, tick Unblock, then click OK and open it again.
The workbook has eight sheets: Start Here, Setup, Dashboard, Work Log, FX Rates, Summary, Reference and Guide. It opens on Start Here. Read it once: its Do this next line says what to do, and its sheet map lists the eight sheets in tab order. Nothing on Start Here is typed in. The Guide sheet explains every input, calculation and check, so you can work without this page.
Every sheet is protected without a password, so a formula can't be overwritten by accident. You never need to unprotect a sheet to enter data. If you want to change the workbook itself: Review > Unprotect Sheet.
4. Fill in Setup
About 2 minutes.
On Setup, one column holds every setting you set once, in the order Tab moves through them:
| Setting | What to enter |
|---|---|
Business name |
Your business or brand name. It appears in the Start Here and Dashboard titles |
Report currency |
The currency for every Dashboard and Summary figure: USD, EUR, GBP, AUD, CAD, NZD, JPY, SGD, HKD or CHF. Both files start on USD |
First month in month lists |
The first day of the earliest month you will log. Month dropdowns list 60 months from here |
Theme |
Light or Dark, for Start Here and the Dashboard. Printing always uses Light |
The last line on Setup, Setup complete, reads Yes, or names the first setting to fix. Start Here's Do this next line follows it. Setup complete never changes the status in row 3, so a blank file still reads OK.
The report month is not a setting. You pick it each time you read the Dashboard, so it sits at the top of the Dashboard (step 8).
5. List your clients on Reference
About 2 minutes.
On Reference, type each client name once in the yellow cells of the client list, exactly as you want it on reports. The Client dropdown on the Work Log reads this list, and it holds 200 clients. The Client check column flags a name typed twice.
6. Add the month's rates on FX Rates
About 3 minutes.
On FX Rates, add one row for each currency you need this month:
- Month (first day): choose the month from the dropdown.
- Currency: the currency code.
- AUD per 1 unit: how many Australian dollars one unit of that currency was worth that month.
- Source note: optional, for example "Bank statement rate, 31 Aug 2026".
Check that the Rate status column shows "OK" for each row.
Which rates you need. The workbook uses the Australian dollar as a fixed reference, so one rate per currency covers every pair. AUD is always 1 and needs no row. Enter a rate for every other currency you billed or paid in that month, plus your report currency if it isn't AUD.
Example: you report in USD, bill one client in GBP and pay a freelancer in EUR. For August you enter three rows: USD, GBP and EUR, each for Aug 2026. If every row that month is in USD and you report in USD, no rate is needed.
Converting a quoted rate. Many sources quote the other way around, for example "1 AUD = 0.66 USD". To get AUD per 1 USD, divide 1 by the quoted rate: 1 ÷ 0.66 = 1.5152. Use four decimal places. The guide to recording exchange rates monthly lists free central bank sources and more conversions.
There is no live rate feed. You decide which rate your business uses, and the numbers stay fixed once a month is closed.
7. Log the month on Work Log
About 1 minute per client project.
On Work Log, the table header is on row 7 and the first entry row is row 8. Add one row for each client project in the month, typing left to right:
| Column | What to enter |
|---|---|
Record ID |
A unique code for the row, for example 2026-08-001. IDs that start with EX- mark sample rows |
Client |
Choose the client from the dropdown |
Project |
Project or retainer name. Keep it the same each month |
Month (first day) |
Choose the month, or type its first day |
Fee currency |
Currency the client was billed in |
Fees billed excl. sales tax (fee currency) |
Fees billed this month, before sales tax |
Credits and refunds (fee currency) |
Credits as a positive number. Leave blank for none |
Cost currency |
Currency of the external costs and hourly cost on this row |
External delivery costs (cost currency) |
Freelancers and other outside costs for this project. Leave blank for none |
Delivery hours |
Hours spent delivering this project this month. More than 300 asks you to confirm |
Hourly delivery cost (cost currency) |
Your internal cost per hour, not the rate you charge the client |
Notes |
Optional. Not used in any calculation |
Not sure what hourly cost to enter? How to set an internal hourly cost rate works through one.
Typing dates. Excel reads dates using your computer's regional settings. On a US-format computer, type 8/1/2026 for 1 August 2026. On an Australian or UK-format computer, type 1/8/2026. Months show as Aug 2026, so a swapped day and month is easy to spot.
Room for rows. The Work Log holds 1,000 rows, FX Rates 600 rows and the client list 200 clients. The Guide's "Adding capacity" steps add more; they were tested at 5,000 Work Log rows.
Pasting from another file. Paste values only (Home > Paste > Paste Values) so you keep the yellow format and the dropdowns. Pasting skips the cell rules, so check the Row status column after you paste.
Checking each row. The white columns to the right of your entries convert each row to the report currency and check it. The Row status column shows "OK" or "Review". A row marked "Review" has a missing detail, an off-list value, a number typed as text, a duplicate, or a missing or duplicate rate, and the check columns name the problem. It stays visible, is counted as a row needing review, and is left out of every total until you fix it.
A negative contribution is not an error. It is a real result and stays in the totals.
8. Read the Dashboard
About 1 minute.
On Dashboard:
- At the top, pick the report month: leave it blank to see the latest month with OK rows, or pick a month. The month shown sits beside it.
- Check the status in row 3.
OKmeans every check passes.CHECK (n)means n checks fail; the Checks block names them and says what to do.SAMPLEmeans only sample rows remain. - Read the key figures for the report month, in your report currency: net fees, delivery cost, contribution before overhead, contribution margin and rows needing review.
- Read the Do this next line: one next step for the file as it stands, such as a setting to finish, the first check to fix, the sample rows to clear, rows to add, or the client with the lowest contribution to look at first.
- Look at the two charts: contribution before overhead by client for the report month, and by month for the 12 months ending in the report month.
The Summary sheet has the totals for the report month and for all months, the last 12 months, and a table by client that prints as a one-page client report.
Contribution before overhead is net fees minus delivery cost: outside costs plus the internal cost of delivery hours. It is before overhead such as rent, software and admin time, so it is not net profit and not cash flow.
9. Clear the worked example (only if you want to reuse it)
About 3 minutes.
For your own data, start from the blank workbook. You don't need to clear anything.
If you have been practicing in the worked example and want to keep going in that file:
- Save a copy of the worked example under a new name first.
- Click the Name Box, the box left of the formula bar that shows the cell address.
- Choose
MV_Clear_WorkLogand press Delete. Then do the same forMV_Clear_FXRatesandMV_Clear_Reference. - Check the Dashboard: the Sample data check reads OK and the status reads OK. Your settings on Setup are kept.
To remove one record, select its yellow cells and press Delete. Rows are never deleted.
10. Save, print and keep a month-end copy
About 1 minute.
- Press Ctrl+S (Windows) or Cmd+S (Mac) as you go.
- Keep one working file for the year and add each month's rows and rates to it.
- At month-end, use File > Save a Copy to keep a dated snapshot, for example
client-profitability-2026-08.xlsx, before you start the next month. - Start Here, Setup, Dashboard, Summary and Guide print 1 page wide on US Letter and on A4. For the Work Log, select your rows, then File > Print > Print Selection; the header row repeats on every page.
- Always save as Excel Workbook (.xlsx). Saving as CSV or an older format removes the formulas and the checks.
If you use version 2.0.0: where Setup went
Version 2.0.0 kept every setting on Start Here. From version 2.1.0, a free update delivered through Payhip, the settings you set once are on the new Setup sheet, and the report month is at the top of the Dashboard. Every name, table and column is the same, so every formula works as before and your 2.0.0 rows paste straight in. Your 2.0.0 file keeps working as it is; moving is optional.
| Setting | In 2.0.0 | In 2.1.0 |
|---|---|---|
Business name |
Start Here B17 | Setup B7 |
Report currency |
Start Here B18 | Setup B8 |
First month in month lists |
Start Here B19 | Setup B9 |
Theme |
Start Here B22 | Setup B11 |
Report month (blank = latest) |
Start Here B20 | Dashboard B4 |
Report month shown (calculated) |
Start Here B21 | Dashboard D4 |
The workbook status that was in Start Here B23 is in row 3 of every sheet, as before. The version block moved from Start Here B6:D7 to B8:D9.
To move your data into the 2.1.0 file:
- Open your 2.0.0 file and the 2.1.0 file.
- In the 2.0.0 file, click the Name Box, choose
MV_Clear_WorkLogand press Ctrl+C. - In the 2.1.0 file, choose
MV_Clear_WorkLogin the Name Box, then Home > Paste > Paste Values. - Do the same with
MV_Clear_FXRates, your rates, andMV_Clear_Reference, your client list. - On Setup, type your business name and any setting you had changed: report currency, first month or theme. If you had picked a report month, pick it again at the top of the Dashboard.
Moving from version 1.x
Version 2.0.0 is a major version: the sheets and the Work Log columns changed, so a 1.1.0-rc1 Work Log doesn't paste straight in. The calculations are unchanged, so the same rows give the same net fees, delivery cost and contribution before overhead. The version 2.0.0 release notes (release-notes-v2.0.0.md, "Moving from 1.1.0-rc1") show how to copy your rows across, one column at a time. If your download no longer has them, email [email protected] and we will send them. You can keep using your 1.x file as long as you like.
A native Google Sheets edition is being built from the same specification. It is included free for every buyer when it ships.