metricvalley Spreadsheet tools for small agencies

Video · 1:31

Client Profitability Tracker walkthrough

Walkthrough, 1:31: which clients pay for the work they take, then one demo row goes in and checks itself, then the Summary, the Dashboard and its checks. Captioned, no narration needed.

Chapters

  1. 0:00Which clients pay
  2. 0:06The color key
  3. 0:15Add a Work Log row
  4. 0:26Row checks
  5. 0:41Other currencies
  6. 0:46Summary
  7. 0:56Dashboard
  8. 1:11Your own data
  9. 1:21Help

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. 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.
  5. 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.
  6. 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".
  7. 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.
  8. 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.
  9. Bill in other currencies? FX Rates holds one rate per currency per month. FX Rates sheet. The six August 2026 rates are outlined: USD, GBP, EUR, CAD, NZD and JPY, each in Australian dollars per 1 unit.
  10. Summary totals August: 24,055.00 USD net fees, 8,343.50 contribution. Summary totals for Aug 2026: net fees 24,055.00 and contribution before overhead 8,343.50 USD are outlined.
  11. By client, Driftwood Fitness is negative: its hours cost more than its fee. Summary, By client, Aug 2026. Driftwood Fitness is outlined: net fees 1,950.00, delivery cost 2,160.00, contribution -210.00, margin -10.8%.
  12. The Dashboard shows the month's key figures: a 34.7% contribution 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.
  13. 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."
  14. Charts: contribution by client, and a 12-month line that fills in over time. Two charts. Contribution by client for Aug 2026 (bars; Driftwood Fitness is the one negative bar, -210). Contribution by month for the 12 months to Aug 2026 (a line at 0 until Jun 2026, then 4,470, 6,350 and 8,344, because the example holds three months of data).
  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 and the report month reads "No month yet". 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.0.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.