Harvest

Harvest is a time tracking application that makes it easy to capture time, gain insights from past projects, and get paid for your work

Features

Data Schema

Setup Guide

Step 1 - Begin Configuration

1. In the connector setup form, enter the destination schema name of your choice.
2. Click Authorize to allow Weld to access your Harvest account using OAuth.

Step 2 - Approve and finalize

1. Approve Weld to access your Harvest account.
2. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 3 - Connection Settings

1. Select a single Harvest account that you would like to sync data from.

Step 4 - Data To Sync

1. Select the pre-built tables you wish to include in the sync.
   You can view the schema, remove columns or hash sensitive information.

Step 5 - Configure Sync

1. Select how often you would like the data to sync.
2. Check the Destination schema name, which is where the tables land in your warehouse, and click Start Initial Sync.

Weld will take over from here and commence syncing data from your Harvest account.

SQL Templates

View all →

Invoice aging

Every sent invoice with what is still owed, how late it is and how long it took to get paid. Harvest's Outstanding Invoices report plus payment speed.

grain: invoice · builds on 1 model

Project budget

Budget, spend and profitability per project, all time.

grain: project · builds on 7 models

Time report

Harvest's Time report: hours, billable hours, billable amount and cost.

grain: day x user x project x task · builds on 2 models

Weekly utilization

Hours against capacity per person per week: Harvest's Team report and utilization numbers.

grain: week x user · builds on 3 models