Fast access to the previous month's time report in Harvest

This article shows you how to use Keyboard Maestro to automatically access your Harvest timesheet report for the previous month. Enjoy!

At the beginning of each month, I invoice Makalu’s clients for the work we did in the previous month. We track our time at Harvest, and in order to see how many hours need to be invoiced I go to their website and click on “Report”→”Month”→”Left Arrow”. All in all, four steps.

Being lazy, I’d like to reduce this to one step.

With the help of our system administrator and unix wizard, Niall O Broin, I created a Keyboard Maestro macro that executes the following shell script, resulting in Safari opening the right URL to access the full report for the previous month. (Niall complained that OS X’s date function was trickier to deal with than the GNU function. Whatever.)

open -a /Applications/Safari.app https://makalu.harvestapp.com/reports?from=$(date -v -1m -v -$(date +%d)d -v +1d +%Y%m%d)&till=$(date -v -$(date +%d)d +%Y%m%d)&kind=month

If you use this script, you’ll want to replace the “makalu” in the URL with your own company’s unique identifier at Harvest.

Agree? Disagree? What do you think?