Client Profitability Report Pack
Your Client Profitability Tracker's months, clients and projects side by side in Power BI Desktop, with every total matching the tracker's Dashboard.
30-day money-back guarantee. No questions asked.
One-time purchase. No subscription. Includes free 1.x updates. 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. Works with Power BI Desktop (Windows), a free app from Microsoft. It reads the full Excel 365 edition of the Client Profitability Tracker 2.x (tested on versions 2.0.0 and 2.1.0) and nothing else.
Six pages, one tracker file
• Start Here: what the report reads, three setup steps, the version, not-for, limits, license and support.
• 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.
• Clients: any range of months by client, with margin against a target margin you set.
• Trends: up to 24 months of net fees, delivery cost, contribution and hours, with year to date and the last 12 months.
• Projects: client to project to month, and projects ranked by contribution per delivery hour.
• Data Checks: six checks, the tracker's Dashboard figures beside the report's own, and every row in Review with the check it failed.
Built to be checked
No money maths of its own: every figure is a sum of columns the tracker already calculates, over the rows the tracker marks OK.
A status box on every page reads OK, SAMPLE or CHECK, in words as well as color.
Check 1 compares the report with the tracker's Dashboard for its report month, to 0.005.
If the file is missing, is not a 2.x tracker or is the lite edition, the report says so in one plain sentence instead of showing partial figures.
Built-in visuals only. No custom visuals, no scripts, and no connection except the one tracker file you name.
Setup
Install Power BI Desktop (free), open the template, paste the path to your tracker and choose Load: about 5 minutes. Each month, save the tracker in Excel and choose Refresh.
Try it first with the tracker's worked example (the 2.0.0 and 2.1.0 files give the same figures): the status box reads SAMPLE and Overview shows Aug 2026 net fees of 24,055.00 and contribution before overhead of 8,343.50, the same as the tracker's Dashboard.
Your tracker can be version 2.0.0 or 2.1.0: the report finds its settings by name, so the 2.1.0 layout change (settings on Setup, the report month picked on the Dashboard) needs nothing from you.
Tested in Power BI Desktop 2.159.1231.0 (October 2026, installer edition) on Windows Server 2025: 36 of 37 checks passed, 1 not yet run, report pack 1.0.2, Nov 13, 2026. The queries were also run against 20 test cases in Excel 365's Power Query, the engine Power BI Desktop uses. Windows 10 and 11, Windows on Arm, a Mac through a virtual machine and the Power BI service are not yet tested.
What's in the download
One ZIP file:
• client-profitability-report-pack-v1.0.2.pbit: the report template. Open it in Power BI Desktop; it asks for the path to your tracker
• START-HERE.html: open this first. It lists every file and where to begin.
• quick-start.md: install, point the report at your tracker, refresh, and the monthly routine
• report-guide.md: every page, every measure and the six checks, in words
• support-and-compatibility.md: what it needs, where it's tested, sharing and licenses, and how to get help
• license.md: the license terms
• release-notes-v1.0.2.md: what changed in this version, and what is in it
• money-back-guarantee.md: the 30-day money-back guarantee
• MANIFEST-client-profitability-report-pack-v1.0.2.sha256: checksums, so you can check every file arrived intact
Not for you if
• 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
• 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.
• Power BI reads the values Excel last saved. Save the tracker in Excel before you refresh.
• 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.
• 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: https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing
• Contribution is before overhead. It is not net profit, accounting profit or cash flow.
• Light theme only, built-in visuals only, one tracker file at a time.
• 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.
License
Single-business, 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 it or posting it online.
Agency/Team is store-wide
If your business holds a Metricvalley Agency/Team license, it covers this report pack too, with working copies for up to 5 client businesses you manage. The report pack has no Agency/Team price of its own. Agency/Team comes with the Client Profitability Tracker (US$99, https://payhip.com/b/jq87M) or with the Agency Operating Bundle's Agency/Team tier (US$129, https://payhip.com/b/Vv6y2).
Power BI Desktop and any Power BI license come from Microsoft under Microsoft's terms. The full terms are in license.md in your download and at https://metricvalley.com/license/
30-day money-back guarantee
If the report pack isn't right for your business, email support@metricvalley.com 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 reply within 1 business day and start the refund then. Downloading the files doesn't affect the guarantee. 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.
Updates: free updates to the 1.x line, delivered through your Payhip download link.
Support: email support@metricvalley.com. We reply within 1 business day, Monday to Friday, Australian Eastern time. Included: help getting the report working as described, and fixes for anything that doesn't. Not included: building your own visuals, Power BI service or gateway setup, importing other data, or accounting and tax advice.
Prices are in US dollars. Any sales tax or VAT that applies is shown at checkout before you pay.
Metricvalley is independent of Microsoft. Power BI is a trademark of the Microsoft group of companies.