Utilization, realization and project margin, the same number every month
Month-end means pulling hours from Harvest, invoices from QuickBooks and rates from a spreadsheet, then arguing about which filter was used. Connect Harvest and QuickBooks, or upload your exports. Quiriz defines each metric once, so the partners' deck, the Excel sheet and the answer in Slack all show the same figure, and next month's pack is a refresh.
Every services firm measures the same few things: utilization, realization, effective rate, project and client margin, unbilled time. The work is not the analysis. It is reconciling three systems and rebuilding the pack by hand each month.
What you get
- The same number in the deck, the cell and Slack. When Harvest connects, Quiriz adds its datasets and metric definitions to Company Context. Every surface reads the same definitions, so utilization in the partners' deck matches the cell and the Slack answer. An admin can edit a definition, and the daily refresh never overwrites an edited one.
- Next month's pack is a refresh, not a rebuild. Build the utilization sheet, the partner memo and the deck once. Next month, Refresh all updates every figure and chart in PowerPoint or Slides, and the live figures in Word and Docs update too.
- Your Harvest and QuickBooks data stays read-only. Both connectors read, never write, refresh once a day and are included on Plus, Pro and Max. No connector for your tool? Upload its export.
- Your whole team on one subscription. A project manager asking about a project's margin uses the admin's keys and Slack binding. There is no per-seat fee for people who only ask questions.
- It says what it cannot compute. Utilization needs capacity, so from a timesheet export you get billable ratio and it is labeled as that, not renamed to match what you hoped for.
How it works
- Connect or upload. Connect Harvest and QuickBooks Online from the connectors page, or upload timesheet, invoice, project and people exports from Harvest, Toggl, Clockify or Xero by upload, email or Slack.
- Quiriz sets up the datasets and definitions. Harvest adds six datasets: time by day, utilization by month, project costs by month, invoices, project budgets and expenses. QuickBooks adds profit and loss, balance sheet, ledger, open invoices and open bills. Each comes with metric definitions you can read and edit.
- Ask where you already work. In Excel:
=QUIRIZ.ASK("Harvest utilization by month this year", "table"). In Google Sheets:=QUIRIZ("Harvest margin by client last quarter", "table"). In Slack, ask the delivery channel. In the web app, use Quick Answer or Generate Report. - Deliver. A utilization table in a cell range, a partner memo in Word or Docs with live figures, or a partners' deck in PowerPoint or Slides.
- Keep it current. Connected data refreshes daily. Next month, refresh the sheet, the memo and the deck instead of rebuilding them. Uploaded files refresh on a schedule you set (scheduled data refresh is included from Plus), including from a OneDrive folder.
The metrics that come with Harvest and QuickBooks
These are definitions that compile to queries, not hints to an AI. Every connected metric is a ratio or a sum, so it stays right when you group it by client, project or month.
| Metric | Definition | Source |
|---|---|---|
| Harvest utilization | billable hours / capacity hours | Harvest, by month. Employees only; contractors are left out. |
| Harvest billable share | billable hours / hours | Harvest, by day. |
| Harvest margin | billable amount − cost on billable time | Harvest, by client, project and month, using cost rates. |
| Harvest unbilled amount | billable amount of time not yet invoiced | Harvest, by day and client. |
| Harvest invoiced, outstanding and overdue | invoice totals, amount due on open invoices, and on those past due | Harvest invoices, as of the last refresh. |
| Open and overdue receivables | open invoice balances, and those past due | QuickBooks, as of the last refresh. |
| Operating expenses, net income, net margin | from the books, by month | QuickBooks, on your report basis. |
Harvest also has project budgets (spent, remaining, percent used) and expenses by client and project, so "which projects are close to budget" is a question you can ask. Every metric is listed on the Harvest and QuickBooks connector pages.
On utilization specifically. Connected Harvest carries each person's weekly capacity, so utilization is billable hours over capacity hours, published as Harvest utilization. It is an approximation: capacity is spread over the calendar month with no holidays or time off. From uploaded timesheets there is no capacity figure, so Quiriz answers billable ratio (billable hours over hours logged) and says so. We would rather name the metric we compute than put your firm's number under a label it does not match.
Across Harvest and QuickBooks
With both connected, Quiriz can answer across them, joined on month or on a customer name you keep consistent. You can also define your own metric from metrics on different datasets, and map a Dimension (one column per dataset that means the same thing) to break it down.
- Harvest against the books. "Do Harvest invoiced totals tie to QuickBooks revenue each month?" The join is by month and needs no shared key. Harvest dates by invoice issue date and QuickBooks by your report basis, so a gap is expected and the question shows its size. In a spreadsheet this is two reports reconciled by hand at every month end.
- Unbilled work beside overdue receivables. "Which clients have the most unbilled time, and which of them already have overdue invoices?" This needs a shared key: Harvest client names must match QuickBooks customer names, or you supply a mapping. Harvest alone answers the unbilled half and its own overdue invoices.
Cross-source figures are not on the pre-defined list. Each answer states whether it came from a stored definition or was answered freehand, and a figure you rely on is worth defining once in Company Context.
If you upload exports instead
Uploaded timesheets and invoices get their own pre-defined metrics. Here is every formula, so you can check it against how your firm measures before you upload anything.
| Metric | Definition | Breaks down by |
|---|---|---|
| Billable ratio | billable hours / total hours | person, role, seniority, client, project, service line, month |
| Delivery margin | (value at standard rates − cost) / value at standard rates | person, role, seniority, client, project, service line, month |
| Realization rate | invoiced / value of the same work at standard rates | client, project, fee type, service line, month |
| Effective hourly rate | invoiced / hours invoiced | client, project, fee type, service line, month |
| Project margin | (invoiced − cost) / invoiced | client, project, fee type, service line, month |
Every ratio sums before it divides. A realization rate averaged across projects weights a $2,000 job the same as a $200,000 one, and reads high. These are defined as a sum over a sum, so they stay right when you group them by client, by month, or by both.
What to export:
- Timesheets (Harvest, Toggl, Clockify) with hours, date, person, project and a client column. Without the client column, hours by client is unavailable rather than quietly wrong.
- Invoices (QuickBooks, Xero or your practice system) with line detail including hours. A single lump sum with no lines gets the hours metrics but not realization, effective rate or project margin.
- Projects and people: whatever carries service line, fee type, role and cost rate.
Connected or uploaded, figures are as current as the last daily refresh or export, which suits month-end and weekly reviews rather than live tracking.
Three questions, and what comes back
Illustrative, from the sample consultancy on the demo: 3,774 time entries and 597 invoice lines across 18 months, January 2025 to June 2026.
“What is our realization rate by client?”
91.0% across the book, 90.1% to 92.2% by client, each a sum of invoiced over a sum of standard value, not an average of per-invoice percentages.
“What was the effective hourly rate last quarter?”
$179.46 for the quarter to 30 June 2026: $821,521 invoiced across 4,578 hours. A relative window like “last quarter” is resolved against today's date, then stated back to you as the dates it used, so you can see which three months the figure covers rather than assuming. The sample data ends in June 2026, so ask it later in the year and it will tell you that quarter is empty instead of quietly answering about a different one.
“Show billable hours by month.”
An 18-month series, each month bucketed on the entry's own date, so a six-month engagement spreads across the six months it was worked, not into the month it started.
What it breaks down by
Pre-defined answers break down by client, project, service line and fee type, and on the money side by invoice line type. Anything computed from timesheets also breaks down by person, seniority, role and billable flag, so “billable ratio by seniority” is a compiled answer, not a re-derivation.
A row with no value on one of these is reported under a named bucket rather than dropped, so the breakdown still adds up to the total. A time entry with no client shows as Unassigned, often internal work, and one where billable was never set shows as Not recorded.
What it will not answer
Asked for any of these, Quiriz says so and names the nearest figure it does have.
- Unbilled work in progress, from uploaded exports. Nothing in a time or invoice export links the two well enough. A connected Harvest account does: it knows which time has been invoiced, so unbilled amount by client is available (fixed-fee projects add no amount).
- Days sales outstanding and cash collected by date. Exports carry no payment date. Connected Harvest and QuickBooks supply open and overdue balances as of the last refresh, so a receivables aging by client works.
- Utilization against capacity, from uploaded timesheets. Connected Harvest supplies it, as an approximation: weekly capacity spread over the month, with no holidays or time off, and contractors left out.
- Realization rate from connected Harvest. Harvest does not carry the value of the work at standard rates beside the invoice, so realization comes from an invoice export with line detail.
- Headcount, bench, attrition and forecasts of unsold work. A people export carries roles and cost rates, not joiners, leavers or availability.
- Net profit by project. Overhead is not in time and invoice exports. Connected QuickBooks gives firm-wide operating expenses and net income by month, not allocated to projects.
The monthly practice pack, without the month-end weekend
A services firm's month-end produces the same pack every time: a utilization and realization sheet, a partner memo, and a deck for the partners' meeting. In Quiriz each one is a set of questions over the same definitions.
- The utilization sheet, in Excel or Google Sheets.
=QUIRIZ.ASK("billable ratio by person last month", "table")and=QUIRIZ.ASK("realization rate by client this quarter", "table")from uploaded exports, or=QUIRIZ.ASK("Harvest utilization by person last month", "table")from connected Harvest. Google Sheets uses=QUIRIZ("...", "table"). Each is a sum over a sum, so the client rows add up to the firm total. - The partner memo, in Word. Write it once with effective rate, realization and project margin as live Figures inside your sentences. Next month, refresh with Mark refreshes as tracked changes on: partners see the old and new figures in Word's own revision marks, and Lock stops anyone typing over a number. In Google Docs, type the question where the table belongs and press Table.
- The partners' deck, in PowerPoint or Google Slides. Describe it, edit the plan, build it, and Refresh all next month. Two prompts are below.
- The project manager's question, in Slack. "What is the margin on the Acme rebrand so far?" asked in the delivery channel and answered in a thread. Bind the channel to one project to keep what it can see narrow. Slack is included from the Plus plan.
Make a deck: two prompts to try
Run these on the sample consultancy or on your own data. Make a deck (Beta) plans the slides first, so any title or question can be edited before it builds. In PowerPoint each chart and table carries two to four takeaways written from that slide's own figures; Slides closes with an executive summary.
Monthly practice review
PowerPoint, Consulting style. Tick your timesheet, invoice, project and people datasets.
"Monthly practice review for June 2026. Billable ratio by month for the last 12 months, billable ratio by seniority for June, realization rate by client for Q2 2026, effective hourly rate by month, project margin by service line for Q2 2026, and the five projects with the lowest margin. End with recommendations."
What comes back, about ten slides:
- Agenda and executive summary.
- Billable ratio by month: a line chart over twelve months.
- Billable ratio by seniority: a bar chart for June.
- Realization by client: a bar chart for the quarter.
- Effective hourly rate by month: a line chart.
- Project margin by service line: a bar chart.
- The five lowest-margin projects: a table.
- Recommendations, written from those slides.
Client profitability review
Google Slides. Tick your timesheet, invoice and project datasets.
"Client profitability review for the first half of 2026. Invoiced amount by client, realization rate by client, effective hourly rate by client and fee type, project margin by client, and billable hours by client by month."
What comes back: invoiced amount and realization by client as bar charts, a table of effective rate by client and fee type, project margin by client, and billable hours by client by month as a stacked column, then the executive summary. It is the deck for deciding which clients to reprice.
Pricing
Free is $0 (5 files). Plus is $12 a month ($120 a year), Pro $30 ($300) and Max $60 ($600). The Harvest and QuickBooks connectors, Slack and scheduled reports start at Plus. You pay for the people who build, not for everyone who asks a question: a project manager checking a margin uses the admin's keys and Slack binding at no extra cost. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- Harvest connector: every dataset and metric
- QuickBooks connector: every dataset and metric
- Harvest reporting beyond the built-in reports
- Harvest project profitability
- Client profitability analysis
- Harvest unbilled time and overdue invoices
- QuickBooks profit and loss analysis
- A QuickBooks receivables aging report
- Utilization, realization and effective rate: three questions, and which one your exports cannot answer
- How to calculate utilization rate in Excel
- Realization rate formula, and the write-off it hides
- Project profitability from a timesheet export
- Combining Harvest and QuickBooks exports
- The monthly reporting pack for a small consulting firm
- How to build a monthly client reporting pack
- All guides →