Help · Client Profitability Report Pack
Set up the Client Profitability Report Pack
This guide covers version 1.0.2, the version you download today. If you use version 1.0.0 or 1.0.1, see "If you use version 1.0.0 or 1.0.1" below and the changelog. Setup takes about 5 minutes once Power BI Desktop is installed.
Before you start
- You need a Windows 10 or Windows 11 PC. Power BI Desktop runs on Windows only; there is no Mac version. The report was tested in Power BI Desktop on Windows Server 2025. Other environments are listed on the compatibility page.
- You need Power BI Desktop, a free app from Microsoft. Using the report on your own PC needs no Power BI account and no paid license.
- You need your Client Profitability Tracker 2.x workbook, the full Excel 365 edition. The free lite edition, the Etsy Starter edition and the Google Sheets edition can't be read.
- Page names and labels below are quoted exactly as they appear in version 1.0.2.
1. Download and unzip
About 2 minutes.
- After payment, Payhip shows a download link on the confirmation page and sends the same link by email.
- Save the ZIP file and extract it: right-click it, choose Extract All, then Extract.
- Open
START-HERE.htmlfor the file list. The file you need isclient-profitability-report-pack-v1.0.2.pbit.
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. Install Power BI Desktop
About 5 minutes, once.
Install Power BI Desktop from Microsoft's download page. It's free. Use the installer edition: it is the edition this report pack is tested on. If it asks you to sign in when it starts, you can close that window: the report doesn't need a Power BI account. Microsoft releases a new version every month and supports only the latest, so keep it up to date.
3. Save your tracker in Excel
About 1 minute.
Open your tracker in Excel, check the status in row 3 of any sheet, and save it. The report reads the values Excel saved, so an edit you haven't saved won't show.
Then copy the tracker's full path: in File Explorer, right-click the file and choose Copy as path (on Windows 10, hold Shift while you right-click).
4. Open the template and point it at your tracker
About 2 minutes.
- Double-click
client-profitability-report-pack-v1.0.2.pbit. Power BI Desktop opens and asks for TrackerFile. - Paste the path. The quotes Windows adds are fine.
- Choose Load. The report loads and opens on Start Here, which says which file it read and when.
- Save the report as a
.pbixfile (File > Save as), for example next to your tracker.
Try it first with the tracker's worked example. The status box reads SAMPLE, and Overview shows Aug 2026: net fees 24,055.00, delivery cost 15,711.50 and contribution before overhead 8,343.50 USD, the same figures as the tracker's Dashboard.
5. Read the status box
Every page has a status box at the top right.
- OK: all six checks pass, including the match with the tracker's Dashboard for its report month, to 0.005.
- SAMPLE: the tracker still holds its sample rows. Every other check passes.
- CHECK (n): n checks fail. Data Checks lists each check with what to do. CHECK (6) means the file couldn't be read: Start Here says why in one sentence.
6. Every month
- Add the month's rows to the tracker and save it in Excel.
- Open your
.pbixand choose Home > Refresh. - Read the status box.
To read a different tracker file: Home > Transform data > Edit parameters, paste the new path into TrackerFile, choose OK, then Apply changes.
7. The pages
- 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. Leave the month box empty to follow the tracker, or pick a month.
- Clients: any range of months by client, with a total, and each client's margin against a target margin you pick (30% until you pick one; it's your target, not a benchmark).
- Trends: up to 24 months of net fees, delivery cost and contribution, a 3-month average and hours by month, with year to date and the last 12 months.
- Projects: expand from client to project to month, and rank projects by contribution per delivery hour.
- Data Checks: the six checks, the tracker's Dashboard figures beside the report's own, and every row in Review with the check it failed and its Work Log row number.
Every money figure is a sum of a column the tracker already calculates, over rows whose Row status is OK, in the tracker's report currency. The report adds no money calculations of its own.
8. Sharing results
Exporting to PDF (File > Export > Export to PDF) is free and is the simplest way to send results to a partner, adviser or client. Every page opens fitted to width, which is how the template exports cleanly. If you switched pages to View > Page view > Fit to page and a page in the PDF sits lower than the rest with its bottom cut off, switch each page back to Fit to width, save, close and reopen the file, then export again. 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. The report pack is not yet tested in the Power BI service.
If you use version 1.0.0 or 1.0.1
Version 1.0.2 is a free update through your Payhip download link. Reports you saved from 1.0.0 or 1.0.1 (.pbix files) keep working and show the same figures, and their Overview line keeps its old wording. To get the corrected Overview line (and, coming from 1.0.0, the 1.0.1 changes too), open client-profitability-report-pack-v1.0.2.pbit, paste the same path into TrackerFile, choose Load, and save the report as a new .pbix. The changelog lists every change.
If something looks wrong
- "No file found at this path": check the folder and file name, including
.xlsx, then refresh. - "is a single-currency edition of the tracker" (version 1.0.0: "is the lite edition"): the report reads the full tracker only, the edition with a Dashboard and FX Rates.
- "can't be read: the Work Log is missing …": a column in the tracker's Work Log was renamed or deleted. Use an unedited 2.x tracker.
- Check 1 reads CHECK: save the tracker in Excel, then refresh. If it still reads CHECK, a Dashboard or Work Log formula in the tracker was typed over; restore it from a fresh copy.
Still stuck? Email [email protected] with the report pack version (on Start Here), your Power BI Desktop version (Help > About), the page and what you saw. Send demo or redacted data only. We reply within 1 business day (Monday to Friday, Australian Eastern time).