Harvest connector: datasets and metric definitionsBeta
Bring in hours, billable and unbilled amounts, utilization, invoices, project budgets and expenses. Updates 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
| Dataset | What it holds |
|---|---|
| [Harvest] Time by day | Hours 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 month | One 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 month | One 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] Invoices | One 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 budgets | One 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] Expenses | One 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
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Harvest hours | Sum of hours | date | Hours tracked in Harvest (rounded hours, as Harvest reports and invoices them). |
| Harvest billable hours | Sum of billable_hours | date | Billable hours tracked in Harvest. |
| Harvest billable share | Harvest billable hours ÷ Harvest hours | date | Share of tracked hours that are billable, as a decimal (0.75 = 75%). |
| Harvest billable amount | Sum of billable_amount | date | Billable hours times their billable rates, in the client currency. Fixed-fee projects add no amount. |
| Harvest unbilled amount | Sum of unbilled_amount | date | Billable amount of time not yet invoiced, in the client currency. |
[Harvest] Utilization by month
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Harvest capacity hours | Sum of capacity_hours | month | Hours people could work: weekly capacity spread over the calendar month (no holidays or time off). Contractors are left out. |
| Harvest utilized hours | Sum of billable_hours | month | Billable hours of the people who have a capacity (employees, not contractors). |
| Harvest utilization | Harvest utilized hours ÷ Harvest capacity hours | month | Billable hours per hour of capacity, as a decimal (0.7 = 70%). |
[Harvest] Project costs by month
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Harvest cost amount | Sum of cost_amount | month | Hours times their cost rates (what the time cost the company), by client, project and month, in the client currency. |
| Harvest margin | Sum of margin_amount | month | Billable amount minus cost on billable time, by client, project and month, in the client currency. |
[Harvest] Invoices
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Harvest invoiced | Sum of amount, where state <> 'draft' | issue_date | Invoice totals by issue date, drafts left out, in the invoice currency. |
| Harvest outstanding | Sum of due_amount, where state = 'open' | issue_date | Amount still due on open invoices, by issue date. |
| Harvest overdue | Sum of due_amount, where days_overdue > 0 | issue_date | Amount still due on open invoices past their due date (as of the last refresh), by issue date. |
[Harvest] Expenses
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Harvest expenses | Sum of total_cost | date | Expenses logged in Harvest, in the client currency. |
Works with other connectors
- Harvest + QuickBooks: Client profitability. Fees from the books, hours from Harvest, margin per client. Read the guide.
Questions to ask
- Which clients and projects were most profitable last quarter?
- What was our utilization by month, and by person?
- Which projects are over or close to budget?
- How much billable work is not invoiced yet, by client?
- Which invoices are overdue, and how much is outstanding by client?
- How many hours went to each client this month versus last month?
- What are we spending on billable and non-billable expenses by client?
Related guides
- Utilization, Realization and Project Margin from Harvest
- Harvest Reporting: Time, Budgets and Invoices in One Place
- Harvest Project Profitability by Client
- Harvest Unbilled Time and Overdue Invoices
- Client Profitability Analysis: Find the Clients Costing You Money, From Harvest and QuickBooks
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?
How often does the Harvest data refresh?
Can I change how a metric is calculated?
Can I combine Harvest with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.