Harvest is a web-based time tracking and invoicing application used by many freelancers, small businesses, and professional teams.

eazyBI provides easy and fast Harvest timesheets and invoices reporting. You can quickly perform initial Harvest data import and regular daily refresh import will be scheduled automatically. You will get several predefined sample reports and charts as well as you can easily create custom reports, charts and dashboards for your specific needs.

Harvest authentication

During initial data import you will be redirected to Harvest application and you will need to authorize eazyBI to import your Harvest account data. It is recommend to create a special admin user, who can generally access all API resources, that can be used to authenticate eazyBI. Further manual as well as regular scheduled data imports will use the same authorized access.

Time (year / quarter / month / day hierarchy and year / week / day hierarchy)

Currency conversion

If you have projects and invoices in multiple currencies then for reporting total amounts you need to convert them to one currency. eazyBI downloads current currency rates from the European Central Bank (from http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml) and defines calculated measures that convert project or invoice amounts to EUR and USD. If you want to convert all amounts to different currency then define new calculated measures using USD calculated measures as example.

Please take into account that currency conversion is always done using current currency rates and not historical currency rates and therefore totals might not be the same as in your accounting. eazyBI reports totals in one currency are meant just to get approximate total amounts that should be good enough for management reporting.

Time rounding

Harvest allows to select Time Rounding option in company preferences which will affect total hours in reports as well as in invoices. If you would like to round hours using the same method also in eazyBI reports then during Harvest import you need to select the same time rounding option (round to nearest or round up to nearest 6, 15 or 30 minutes).

If you use time rounding option then Hours measure will show original hours without rounding but Rounded hours will show rounded hours according to selected rounding option. Billable hours, Invoiced hours, Billable amount and Invoiced amount will also be calculated using Rounded hours.

If you would like to change time rounding option then before Harvest import go to Analyze tab and click on Empty button for Timesheets cube. It will clear all imported data and force reloading of all data from Harvest.

Link from eazyBI reports to Harvest pages

If in eazyBI reports you click on client, project, person or invoice dimension member then in action list you will see Go to source link - when clicking on it new Harvest application page will be opened with corresponding data. It can be very useful to see summary overview in eazyBI and when necessary you can go to detailed Harvest page for selected item.