Home / Consultancies
For consultancies and firms that bill time

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.

Try it on a sample consultancy → No signup. Five sample exports: 18 months, 12 people, 30 projects.

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

How it works

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

MetricDefinitionSource
Harvest utilizationbillable hours / capacity hoursHarvest, by month. Employees only; contractors are left out.
Harvest billable sharebillable hours / hoursHarvest, by day.
Harvest marginbillable amount − cost on billable timeHarvest, by client, project and month, using cost rates.
Harvest unbilled amountbillable amount of time not yet invoicedHarvest, by day and client.
Harvest invoiced, outstanding and overdueinvoice totals, amount due on open invoices, and on those past dueHarvest invoices, as of the last refresh.
Open and overdue receivablesopen invoice balances, and those past dueQuickBooks, as of the last refresh.
Operating expenses, net income, net marginfrom the books, by monthQuickBooks, 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.

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.

MetricDefinitionBreaks down by
Billable ratiobillable hours / total hoursperson, role, seniority, client, project, service line, month
Delivery margin(value at standard rates − cost) / value at standard ratesperson, role, seniority, client, project, service line, month
Realization rateinvoiced / value of the same work at standard ratesclient, project, fee type, service line, month
Effective hourly rateinvoiced / hours invoicedclient, project, fee type, service line, month
Project margin(invoiced − cost) / invoicedclient, 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:

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.

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.

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:

  1. Agenda and executive summary.
  2. Billable ratio by month: a line chart over twelve months.
  3. Billable ratio by seniority: a bar chart for June.
  4. Realization by client: a bar chart for the quarter.
  5. Effective hourly rate by month: a line chart.
  6. Project margin by service line: a bar chart.
  7. The five lowest-margin projects: a table.
  8. 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.

Ask the sample consultancy → Then try your own data and check it against a figure you already trust.

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

Questions

Should I connect Harvest and QuickBooks or upload exports?
Either. Harvest and QuickBooks connect read-only, refresh daily and are included on paid plans (Plus, Pro and Max). Toggl, Clockify and Xero come in as the CSV or XLSX exports they already produce. Connect when you want daily-fresh numbers and answers across systems; upload when you would rather not sign in, or the tool has no connector. Both routes use the same definitions.
How is utilization calculated?
With Harvest connected, Harvest utilization is billable hours divided by capacity hours, using the weekly capacity set for each person in Harvest, spread over the calendar month with no holidays or time off. Contractors are left out. From uploaded timesheets there is no capacity figure, so Quiriz answers billable ratio (billable hours over hours logged) and names it as that.
How is realization rate calculated?
Invoiced amount divided by the value of the same work at standard rates, both summed before dividing. It needs an invoice export with line detail, because the connected Harvest data has no standard-value figure to compare against. Because numerator and denominator sit on the same invoice lines, it rolls up correctly by client, by project and by month.
What if our invoices have no line detail?
You still get the hours side: billable ratio, delivery margin, and hours by client, person, project and month. Realization, effective rate and project margin from an export need the invoiced and standard amounts on the same line, so they stay unavailable until the export carries them. Connected Harvest still gives margin by client and project from its cost rates.
Can Quiriz build the monthly partners' deck?
Yes. In Quiriz for PowerPoint or Google Slides, Make a deck (Beta) takes a description such as utilization by month, realization by client and project margin by service line, and shows a plan of slide titles and questions to edit before it builds. Every figure uses the same definitions as your spreadsheet and Slack answers, and next month you press Refresh all instead of rebuilding the deck.
Does my team need its own subscription?
No. Project managers and partners who only ask questions use the admin's keys in the add-ins and the admin's Slack binding, with no per-seat fee. Plus allows 5 add-in keys, Pro 10 and Max unlimited.
How many clients and projects can it handle?
The demo runs 30 projects across 8 clients and 18 months. Quiriz routes each question to the right datasets itself, so adding clients does not mean picking the right file before every question.