Client Profitability Report Pack · Works with Power BI Desktop (Windows)

Which clients and projects have paid for the work over the last year, not just last month?

For agencies, studios and consultancies on Windows that keep the Client Profitability Tracker and already use Power BI Desktop.

Any range of months, 24-month trends and project drill-down, read straight from your tracker. No money maths of its own.

client-profitability-report-pack-v1.0.2.pbit Demo data
Overview page of the Client Profitability Report Pack with the tracker's worked example: five key figures for Aug 2026, a bar chart of contribution by client and a line chart of the 12 months to Aug 2026.

Screenshots from Power BI Desktop with the tracker's worked example loaded. Every client is fictional.

Open full-size image of the Overview page

01What it answers

Three questions the one-month Dashboard can't answer

  1. Which clients carried the year, and which only had a good month?

    Pick any range of months and see net fees, delivery cost, contribution, margin, hours and each client's share, with a total, against a target margin you set.

  2. Is contribution rising or falling, and why?

    Up to 24 months of net fees and delivery cost side by side, contribution as a line, a 3-month average, hours by month, year to date and the last 12 months.

  3. Which projects earn least for each hour of delivery?

    Expand from client to project to month, and rank every project by contribution per delivery hour for the months you choose.

02Demonstration

See the actual report

client-profitability-report-pack-v1.0.2.pbit Demo data
Overview page of the Client Profitability Report Pack with the tracker's worked example: five key figures for Aug 2026, a bar chart of contribution by client and a line chart of the 12 months to Aug 2026.

Overview. The tracker's report month: five key figures with the tracker's own labels, contribution by client and the 12 months to that month. Pick another month in the box.

03What's inside

Six pages, one tracker file

Demo data

Overview

Follows the tracker's report month until you pick another.

Says whether the totals match the tracker's Dashboard.

Demo data

Clients

Counts clients below your target and clients with negative contribution.

Shows the largest client's share of net fees.

Demo data

Trends

Year to date, last 12 months and the 12-month margin.

A month with no OK rows shows 0.

Demo data

Projects

For any range of months.

Demo data

Data Checks

Check 1 compares the report with the tracker's Dashboard to 0.005.

Rows in Review are listed with their Work Log row number.

Demo data

Start Here

The status box on every page reads OK, SAMPLE or CHECK.

Exactly what's in the download

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

FileWhat it isSize
pbitclient-profitability-report-pack-v1.0.2.pbit The report template. Open it in Power BI Desktop; it asks for the path to your tracker 95 KB
htmlSTART-HERE.html Open this first: what each file is and where to begin 8 KB
mdquick-start.md Install, point the report at your tracker, refresh, and the monthly routine 7 KB
mdreport-guide.md Every page, every measure and the six checks, in words 16 KB
mdsupport-and-compatibility.md What it needs, where it is tested, sharing and licenses, support 7 KB
mdlicense.md The license terms 3 KB
mdrelease-notes-v1.0.2.md What is in this version 6 KB
mdmoney-back-guarantee.md The 30-day money-back guarantee 1 KB
txtMANIFEST-client-profitability-report-pack-v1.0.2.sha256 Checksums to verify your download 1 KB

04Setup

Ready in about 5 minutes

  1. Save your tracker in Excel the report reads the values Excel saved, so save after your last edit.

    About 1 minute.
  2. Open the template and paste the path double-click the .pbit in Power BI Desktop and paste the full path to your tracker when it asks.

    About 2 minutes.
  3. Load, then read the status box OK, SAMPLE or CHECK on every page. Save the report as a .pbix and choose Refresh each month.

    About 2 minutes.

Estimate, with Power BI Desktop already installed. Installing it is a free download from Microsoft.

05Worked example

The tracker's worked example, read by the report

Fictional example

Point the report at the worked example that comes with the tracker. The status box reads SAMPLE, because sample rows remain. Overview shows Aug 2026, the tracker's report month: net fees 24,055.00, delivery cost 15,711.50 and contribution before overhead 8,343.50 USD, a 34.7% margin, the same figures as the tracker's Dashboard. Data Checks lists the five figures side by side. Across all three months, contribution is 19,163.50 USD on 45,855.00 of net fees, and Aurora Dental's 14,400.00 is 31.4% of net fees.

Overview, Aug 2026 (fictional)
Net fees24,055.00
Delivery cost15,711.50
Contribution before overhead8,343.50
Contribution margin34.7%
Trends, Jun to Aug 2026 (fictional)
Jun 2026 contribution4,470.00
Jul 2026 contribution6,350.00
Aug 2026 contribution8,343.50
Year to date19,163.50

The worked example's clients are fictional and the figures are not a customer result. The report shows exactly what your tracker calculates.

06Fit

Is it right for you?

Good fit

  • Agencies, studios and consultancies that keep the Client Profitability Tracker and use Power BI Desktop on Windows
  • Owners who want any range of months, not just the tracker's one report month
  • Consultancies that report to partners or investors in Power BI
  • Anyone who wants proof that the report and the workbook agree, every refresh

Not a fit

  • You use a Mac and no Windows PC. Power BI Desktop runs on Windows only
  • You don't own the Client Profitability Tracker 2.x. The pack reads nothing else
  • You want the workbook's figures calculated a different way. The pack adds no money calculations of its own
  • You need scheduled refresh or sharing through the Power BI service without a paid Power BI license

Known limitations

  1. Reads the full Excel 365 edition of the tracker only, the one with a Dashboard and FX Rates. Other editions, including the Google Sheets edition, are not read.
  2. Power BI reads the values Excel last saved. Save the tracker in Excel before you refresh.
  3. Windows only. Tested in Power BI Desktop on Windows Server 2025. Windows 10 and 11, Windows on Arm, a Mac through a virtual machine and the Power BI service are not yet tested.
  4. Sharing a report through the Power BI service needs a paid Power BI license (Pro or Premium Per User) for you and everyone you share with, and refreshing a file on your PC from the service needs a gateway. Microsoft lists current prices on its Power BI pricing page.
  5. Contribution is before overhead. It is not net profit, accounting profit or cash flow.
  6. Light theme only, built-in visuals only, one tracker file at a time.
  7. Microsoft releases Power BI Desktop every month and supports only the latest version. Each release is re-tested; support-and-compatibility.md lists the versions tested.

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

36/37 checks passed, 1 not yet run
Power BI Desktop, installer edition, Windows Server 2025
  • Report pack version1.0.2
  • Last testedNov 13, 2026
  • Power BI Desktop, Microsoft Store editionNot yet tested
  • Power BI Desktop, Windows 10 and 11Not yet tested
  • Power BI Desktop, Windows on ArmNot yet tested
  • Mac through Parallels Desktop or Windows 365Not yet tested

What the cases cover

  • The tracker's worked example typed into a blank tracker, and as shipped, in USD and AUD
  • The setup-test rows, rows in Review, a blank tracker, 1,000 rows with 200 clients, and seven currencies
  • A typed report month and a Dashboard figure typed over, which check 1 must catch
  • Seven kinds of wrong file and three path cases, each giving one plain sentence and no partial figures
Environment Status Checks Version and build Last tested Notes
Power BI Desktop, installer edition, Windows Server 2025 Tested with notes 36/37 passed, 1 not yet run Report pack 1.0.2 · Power BI Desktop 2.159.1231.0 (October 2026, installer edition) · Windows Server 2025 Standard 10.0.26100 Nov 13, 2026 The queries were also run against 20 test cases in Excel 365's Power Query, the engine Power BI Desktop uses. 1 check needs a person at the screen and had not been run on the release date: the Windows contrast theme check. The optional 10-minute setup test is not counted.
Power BI Desktop, Microsoft Store edition Not yet tested — — — Not yet tested.
Power BI Desktop, Windows 10 and 11 Not yet tested — — — Not yet tested.
Power BI Desktop, Windows on Arm Not yet tested — — — Not yet tested.
Mac through Parallels Desktop or Windows 365 Not yet tested — — — Not yet tested. Microsoft names these as the ways to run Windows apps on an Apple-silicon Mac.
Power BI service (publish, share, refresh) Not yet tested — — — Not yet tested. Sharing there needs a paid Power BI license for you and every viewer.
Mac without Windows Not supported — — — Power BI Desktop runs on Windows only.

What changed in 1.0.2

Nov 13, 2026

A free update for everyone who bought 1.0.0 or 1.0.1, through the same Payhip download link. The same tracker file gives the same checks as in 1.0.1, and the same figures apart from one case on Overview. Reports you saved from 1.0.0 or 1.0.1 keep working.

  • Overview: the line under the Month box says "picked in the box" only after you pick a month there. With a tracker that holds a single month and the box empty, it said "picked in the box" although nothing was picked.
  • Overview: when every row is in one month, none of them is OK yet and no report month is picked on the tracker's Dashboard, Overview now shows "No month yet", as it already did for a tracker with more months.
  • The release notes now describe the 1.0.1 change to Start Here correctly: only the Support and License boxes point to the files in your download, and Known limitations names Microsoft's Power BI pricing page in words.
  • Power BI Desktop, installer edition, Windows Server 2025: Tested with notes, 36 of 37 checks passed, 1 not yet run, report pack 1.0.2, Power BI Desktop 2.159.1231.0 (October 2026, installer edition), tested Nov 13, 2026. The optional 10-minute setup test is not counted. Windows 10 and 11, Windows on Arm, a Mac through a virtual machine and the Power BI service: not yet tested.

Inputs affected: No. The report never changes your tracker.

08What you get

What you get

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

  • Template: One Power BI template (.pbit) with 6 pages, built-in visuals only, no custom visuals or scripts, and one data source: your tracker file. Tested in Power BI Desktop on Windows Server 2025.
  • Reads: Client Profitability Tracker 2.x, full Excel 365 edition. Not the lite, Etsy Starter or Google Sheets editions.
  • Updates: 1.x updates are free and are delivered through Payhip.
  • License: Single-business, for one business and all its staff. Agency/Team is store-wide: the tracker's US$99 Agency/Team license, or the bundle's US$129 Agency/Team tier, covers this report pack too, for up to 5 client businesses.
  • Support: Email support; we reply within 1 business day (Monday to Friday, Australian Eastern time).

09License

License

Two licenses. Both let you edit the report, keep backups and share PDFs and figures from it. Neither lets you pass the template or a saved report to another business.

Single-business

included at US$29

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

Allowed
Edit and extend the report, keep backups, share PDFs, figures and view-only published reports with your team, clients, advisers and board.
Not allowed
Using it for a second business, giving the template or a saved report to a client or anyone outside the business, reselling or posting it online.
Buy for US$29

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

Agency/Team

Store-wide

For an agency and up to 5 client businesses it manages, and everyone who works in the agency.

Agency/Team is store-wide: the Client Profitability Tracker's US$99 Agency/Team license, or the Agency Operating Bundle's US$129 Agency/Team tier, covers every Metricvalley business template your business owns, including this report pack. The report pack has no Agency/Team price of its own.

Allowed
Everything in Single-business, plus separate working copies for up to 5 client businesses you manage, as long as you keep the files and send them the results.
Not allowed
Giving clients or anyone outside your agency the template or a saved report, reselling, or including it in a product, course or template library.
See Agency/Team on the tracker page

The full terms are in the download and shown before checkout. Power BI Desktop and any Power BI license come from Microsoft under Microsoft's terms. Nothing in our terms limits rights you have under consumer law. Read the full license terms.

10Guarantee

30-day money-back guarantee

If the report pack 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 I need a paid Power BI license?

Not to use the report on your own PC. Power BI Desktop is a free download from Microsoft, and the report opens, refreshes and shows every page without a Power BI account. Publishing to the Power BI service and sharing there needs a paid Power BI license (Pro or Premium Per User) for you and everyone you share with; Microsoft lists current prices on its Power BI pricing page.

Does it work on a Mac?

No. Power BI Desktop runs on Windows only. Microsoft names Parallels Desktop and Windows 365 as ways to run Windows on an Apple-silicon Mac, but we haven't tested the report that way.

Will its figures ever differ from the tracker's?

They shouldn't, and the report checks. It sums the same stored values the tracker's own totals sum, over the same OK rows, and check 1 compares its figures with the tracker's Dashboard for the report month, to 0.005. If you edit the tracker and don't save it in Excel, the report shows the last saved figures.

Which tracker files can it read?

The full Excel 365 edition of the Client Profitability Tracker 2.x: your copy of the blank or of the worked example. Not the free lite edition, the Etsy Starter edition or the Google Sheets edition. A file it can't read gets one plain sentence on Start Here, never partial figures.

Can I add my own pages and visuals?

Yes. You own the file and may edit it. Build from the measures in the Pack Measures table: they already apply the tracker's OK-row rule. Your edits aren't covered by our test results, so keep the original .pbit.

Is it in the Agency Operating Bundle?

No. The bundle holds the four agency tools. The report pack is sold on its own at US$29, and an Agency/Team license from the tracker or the bundle covers it too.

What if it isn't right for us?

Every purchase has a 30-day money-back guarantee. Email support within 30 days with your Payhip order number. You get a full refund to your original payment method.

More answers in the setup guide and the help center.

Client Profitability Report Pack · US$2930-day money-back guarantee. No questions asked.

Buy for US$29