Extras

Clockify Help Center Extras QuickBooks integration

QuickBooks integration

Connect Clockify to your QuickBooks Online account and send time entries.

QuickBooks integration is an extra feature, which you can enable by upgrading your workspace to Standard, Pro, or Enterprise plan.

Integration supports QuickBooks Online (Essentials or Plus plan). Doesn’t work with QuickBooks Desktop or QuickBooks Online Simple Start plan.

If you have Payroll feature enabled in QuickBooks, Clockify integration won’t work due to system’s capabilities.

Connecting QuickBooks Online #

  1. Log in to your Clockify account
  2. Go to Settings in the Sidebar, and then to Integrations tab
  3. Expand QuickBooks section and click Connect to QuickBooks
  4. Authorize Clockify to access QuickBooks (you’ll need to be logged in to QuickBooks)
  5. Sync Clockify with QuickBooks
  6. Create missing users from Clockify and missing customers from QuickBooks

Before connecting to QuickBooks, make sure you have invited all users in Clockify, they have accepted the invite, and their names in Clockify (in Profile settings) and QuickBooks (their display name) are the same.

If you don’t have any projects in Clockify, everything will be pulled from QuickBooks so you don’t have to create anything manually.

If you add new user in Clockify, or new customer in QuickBooks, you’ll have to perform the sync again manually in the Integrations tabs before trying to send time to QuickBooks (Clockify won’t make any changes to your QuickBooks account unless you do it explicitly).

If you want to connect just one or several specific projects (e.g. to test the integration):

  1. Create a project with the same name as the customer (or project) in QuickBooks
  2. Create user(s) in QuickBooks with same name as they have in Clockify
  3. Connect Clockify with QuickBooks
  4. After you’ve connected, DON’T create missing users and project (at this point, users and projects between Clockify and QuickBooks with the same name are connected to each other)
  5. Go to Detailed report, filter the report by the project/user you need, and send to QuickBooks

Setting up Clockify for the first time #

  1. Invite team members to track time
  2. Make sure their names in Clockify and QuickBooks are the same
  3. Connect QuickBooks with Clockify
  4. Sync users and customers (this will create a project in Clockify for each QuickBooks project/customer)
  5. Track time on projects in Clockify
  6. Send tracked time to QuickBooks using Detailed report

Data mapping #

  • User Name in Clockify and Employee Display Name in QuickBooks have to be identical in order to sync
  • If user doesn’t exist in QuickBooks as an employee, you’ll perform sync in Settings > Integrations > QuickBooks
  • Project Name in Clockify and Customer (or Project) Name in QuickBooks have to be identical in order to sync
  • If you have parent customers in QuickBooks, Sub-customer in QuickBooks will be treated as Project in Clockify and its Parent in QuickBooks will be treated as Client in Clockify
  • If a project doesn’t exist in QuickBooks as a customer (or project), you’ll first have to create it manually in QuickBooks using the exact same name as in Clockify, and perform sync in Settings > Integrations > QuickBooks
Employee name in QuickBooks and user name in Clockify (editable in Profile settings) must match
Customer name in QuickBooks and project name in Clockify must match
(or Customer>Sub-Customer in QuickBooks with Client>Project in Clockify)

Sending time to QuickBooks #

Once you’ve connected Clockify and QuickBooks, and synced users and customers/projects, you’ll see the QuickBooks button in the Detailed report.

  1. Go to the Detailed report
  2. Click QuickBooks button to see all time entries that haven’t been sent to QuickBooks
  3. Review if you wish to send all the data you see and apply filters if necessary
  4. Click Send to QuickBooks

Clockify sends following information to QuickBooks: user, description, project, date, duration, billable status, and billable rate.

Once all the entries have been sent successfully, the system will mark them as sent. To see time entries that have been sent, click on the QuickBooks dropdown (next to Showing not sent entries), and choose Show sent entries.

Once an entry has been sent, it can’t be sent again. If you make changes to an entry, the change won’t be reflected in QuickBooks (meaning you’ll have to manually update time in QuickBooks too). To avoid this, it’s best to send only approved time to QuickBooks.

Notes

  • It’s not possible to send billable entry without a project to QuickBooks
  • If you turn rounding ON, Clockify will send rounded values
  • Only Admins can send time to QuickBooks
  • Individual time entries longer than 23h55m won’t be sent
  • Clockify sends following data: user’s name, date, project (i.e. customer in QB), billable status, hourly rate (if billable), duration, description
Time sent from Clockify will be available as time data in QuickBooks, so you can run reports and invoice

Disconnecting QuickBooks Online #

To disconnect your QuickBooks account:

  1. Log in to your Clockify account
  2. Go to Settings in the Sidebar, and then to the Integrations tab
  3. Expand QuickBooks section and click Disconnect
  4. Confirm the action

Once you’ve disconnected QuickBooks, you’ll no longer see the QuickBooks button in Detailed report and Clockify won’t have access to your QuickBooks account.

You can reconnect to QuickBooks on the same page by clicking Connect to QuickBooks.