You can use this data in any analytics/reporting program that accepts a MySQL database connection.  Typical examples include PowerBI, Tableau, Crystal reports, Klipfolio and more.

What sort of reports can be created with the data?

Payroll reports, Project costings, leave reports, forward planning, a Map view of timesheets, User lists based reporting, historical user lists, Overtime reports and more.

Here are some screenshots of Dashboards built with QuickBooks Workforce Data:

We also extract Geo-Location and Job Location data, so you can also project the data and overlay it on maps.

Can data be directly linked to the Database or is an intermediary server required? 

As a part of the service, we provide instructions for a secure connection to our Database, Most analytics programs can connect to a SQL database which makes it simpler to connect and build reports.

Can Geolocations be pulled from Quickbooks Workforce?

Yes, Geolocations (Location-based timestamps from Timesheets) can be pulled from QuickBooks Workforce and saved in the database.  Note that QuickBooks Workforce collects a lot of Geolocation points so this data table can be enormous. You need to be able to manage the data to build reports.

Can SyncEzy build the reports / Dashboards based on Quickbooks Workforce ?

Yes, you can opt into our additional report-building service, and we can create the reports for you. Please contact us at support@syncezy.com for a quote.

Can additional tables be added to the Database?

If you need a specific dataset that is not currently available, please contact us. We can add additional tables to the database as part of an additional paid service.

Accounts and Pricing

Do you offer a free trial?

Unfortunately, due to the amount of work involved in the initial setup, we are unable to offer a free trial.  We can however get together on a call and give you a live demo in as much detail as you need. If you have any specific questions feel free to reach out.

Are there any lock-in contracts?

No contracts, we do not have long-term or annual contracts. We earn our keep every month by providing integration as a service.

What is your pricing?

Please contact us to get pricing. Pricing is dependent on the size of the QuickBooks Workforce Database.

Our pricing is made up of two components: 

1. The initial one-time setup.

2. An ongoing monthly fees depends on your sub type

Other questions

Have a support question?

Have you done this before and what about the security of data?

Yes, we have, we have been building integrations for the last eight years. With over 50 integrations built across various systems. All our communication between systems is fully encrypted.  We do not store your actual data in our systems, we only store the ids of the records and some minimum information for logging and troubleshooting.  We do not store tenant private data like contact details and property details in our system.

Where is the data stored? 

The data that’s transferred to Power BI is stored in their servers that are protected.  SyncEzy stores a minimum amount of log and record ID data to manage the sync, this is stored on SyncEzy’s AWS cloud servers in Sydney.  AWS is the same backend technology used by PropertyME. 

All data stored by SyncEzy is accessible to the user from the integration logs data view from their SyncEzy account.

What security measures are in place to ensure the security of information?

All three applications Power BI, SyncEzy and QuickBooks Workforce offer the same two-factor authentication as a means to prevent access by a stolen password.  This can be enabled by the users after logging in.

SyncEzy offers an end to end encrypted service so all communications to our site are controlled, Power BI and Quickbooks Workforce both offer oAuth 2.0 which follows industry best practice for creating API tokens.