Freshbooks has a very simple API that can be used to pull invoice and client information. Our client had been running a number of companies seperately with each having its own Freshbooks account. It was easy enough for them to log in and grab the numbers and throw them into an Excel sheet for some simple reporting, but the goal was to have one interface. Sounds like an ETL problem right? Right. Data mining was done via a PHP script and was done straight through the Freshbooks API. Data was pulled into a common database and then of course PHP on the backend for a portal using Bootstrap/Jquery.