Home / Connectors / Harvest
Connector

Harvest connector: datasets and metric definitionsBeta

Bring in hours, billable and unbilled amounts, utilization, invoices, project budgets and expenses. Updates daily.

6 datasets14 metric definitionsRead-onlyRefreshes daily

When you connect Harvest, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.

DatasetsMetric definitionsWorks withQuestionsFAQ

Datasets

DatasetWhat it holds
[Harvest] Time by dayHours per day, person, client, project and task for the last 13 months, with billable and unbilled amounts (cost and margin are in Project costs by month, never per person). Hours are Harvest's rounded hours (as its reports and invoices use). Amounts are in the client's currency: do not add amounts across currencies. Fixed-fee projects add hours but no amounts. Time-entry notes are never imported.
14 columnsdate, month, user_id, user_name, client_id, client_name, project_id, project_name, task_name, currency, hours, billable_hours, billable_amount, unbilled_amount
[Harvest] Utilization by monthOne row per active employee and month: capacity hours (weekly capacity spread over the calendar month, ignoring holidays and time off), hours and billable hours. Contractors are left out (their hours are in Time by day). Utilization = sum(billable_hours) / sum(capacity_hours).
6 columnsmonth, user_id, user_name, capacity_hours, hours, billable_hours
[Harvest] Project costs by monthOne row per client, project and month for the last 13 months: hours, billable amount, cost (hours times cost rates) and margin (billable amount minus cost on billable time). There is no person column, so no one's pay rate can be worked out. Amounts are in the client's currency: do not add amounts across currencies.
10 columnsmonth, client_id, client_name, project_id, project_name, currency, hours, billable_amount, cost_amount, margin_amount
[Harvest] InvoicesOne row per invoice issued in the last 13 months, plus every open invoice of any age. days_overdue is whole days past the due date for open invoices as of the last refresh (0 otherwise). Amounts are in the invoice currency.
13 columnsinvoice_id, number, client_id, client_name, currency, state, issue_date, month, due_date, paid_date, amount, due_amount, days_overdue
[Harvest] Project budgetsOne row per active project as of the last refresh: budget, spent, remaining and percent used. budget_unit says whether the budget is hours or money: never add hours and money budgets together. Projects with no budget show 0.
11 columnsproject_id, project_name, client_id, client_name, budget_by, budget_unit, budget_is_monthly, budget, budget_spent, budget_remaining, percent_used
[Harvest] ExpensesOne row per expense in the last 13 months: date, person, client, project, category, amount, and whether it is billable and invoiced. Amounts are in the client's currency. Expense notes and receipts are never imported.
13 columnsexpense_id, date, month, user_name, client_id, client_name, project_id, project_name, category, currency, total_cost, billable, is_billed

Metric definitions

Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.

[Harvest] Time by day

MetricHow it is calculatedDated byNotes
Harvest hoursSum of hoursdateHours tracked in Harvest (rounded hours, as Harvest reports and invoices them).
Harvest billable hoursSum of billable_hoursdateBillable hours tracked in Harvest.
Harvest billable shareHarvest billable hours ÷ Harvest hoursdateShare of tracked hours that are billable, as a decimal (0.75 = 75%).
Harvest billable amountSum of billable_amountdateBillable hours times their billable rates, in the client currency. Fixed-fee projects add no amount.
Harvest unbilled amountSum of unbilled_amountdateBillable amount of time not yet invoiced, in the client currency.

[Harvest] Utilization by month

MetricHow it is calculatedDated byNotes
Harvest capacity hoursSum of capacity_hoursmonthHours people could work: weekly capacity spread over the calendar month (no holidays or time off). Contractors are left out.
Harvest utilized hoursSum of billable_hoursmonthBillable hours of the people who have a capacity (employees, not contractors).
Harvest utilizationHarvest utilized hours ÷ Harvest capacity hoursmonthBillable hours per hour of capacity, as a decimal (0.7 = 70%).

[Harvest] Project costs by month

MetricHow it is calculatedDated byNotes
Harvest cost amountSum of cost_amountmonthHours times their cost rates (what the time cost the company), by client, project and month, in the client currency.
Harvest marginSum of margin_amountmonthBillable amount minus cost on billable time, by client, project and month, in the client currency.

[Harvest] Invoices

MetricHow it is calculatedDated byNotes
Harvest invoicedSum of amount, where state <> 'draft'issue_dateInvoice totals by issue date, drafts left out, in the invoice currency.
Harvest outstandingSum of due_amount, where state = 'open'issue_dateAmount still due on open invoices, by issue date.
Harvest overdueSum of due_amount, where days_overdue > 0issue_dateAmount still due on open invoices past their due date (as of the last refresh), by issue date.

[Harvest] Expenses

MetricHow it is calculatedDated byNotes
Harvest expensesSum of total_costdateExpenses logged in Harvest, in the client currency.

Works with other connectors

Questions to ask

Ask Harvest in plain words

Try the questions on sample data with no signup, then connect Harvest read-only and ask your own.

Try Quiriz free →

Frequently asked questions

Does Quiriz change anything in Harvest?
No. The Harvest connector is read-only. Quiriz reads the data into datasets and never writes back to Harvest.
How often does the Harvest data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Harvest with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.