Video · 1:29

Client Profitability Tracker walkthrough

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.

Chapters

  1. 0:00Which clients pay
  2. 0:06Start Here
  3. 0:20Setup
  4. 0:29The Dashboard
  5. 0:39Add a Work Log row
  6. 0:49Row checks
  7. 1:05Dashboard checks
  8. 1:10Your own data
  9. 1:20Help

Transcript

The video has no sound. This is what it shows, in order: each caption, then what is on screen.

  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.