Skip to main content

Accounting integrations - Quickbooks Online (Track)

Learn how to connect Lucen Track to QuickBooks to sync and manage your invoices and mark them as paid. Track connects to QuickBooks Online so you can send your invoices without having to enter them twice.

🌟 Available on Premium and up

Note: this integration supports QuickBooks Online Essentials, Plus and Advanced. QuickBooks Desktop isn't supported.

How to connect QuickBooks Online

Please note: you can connect only one accounting tool at a time. Use Xero instead of QuickBooks? Read this Xero setup guide.

  1. As an Owner or Admin, go to Integrations in the left sidebar.


2. Scroll to Accounting integrations and click Connect next to QuickBooks Online.


3. On the QuickBooks Online integration page, read the integration info, then click Link QuickBooks Online under Authorisation.


4. Sign in to QuickBooks, pick your company and approve access.


5. Track shows Connecting to QuickBooks Online
 while it reads your customer list, then opens the Import or match your clients window.

How to sync your QuickBooks clients to Track

Track lines up your QuickBooks customers with your Track clients by name. Invoices for a Track client go to the QuickBooks customer linked to it, so check each row before you save.

  • If the customer is only in QuickBooks, you can choose to import them as a new client, with or without billing details.

  • If a customer in QuickBooks has a name similar to a Track client’s, Track will suggest a match for you to double-check.

  • If a customer has the same name in QuickBooks and Track, Track will match them.

  • A Track client with no equivalent in QuickBooks will not be linked immediately. You get to decide if you want to match them to a Quickbooks client, or not link anything.

Track never creates new customers in QuickBooks Online

The selectors list names alphabetically, and you can type to filter them.

When you're done, click Save and sync. Track links the matched clients and imports the customers you chose, with their billing name, address, tax ID and email.

At this point, no existing Track invoices are sent to QuickBooks. Before sending an invoice, let’s check that the integration is set up correctly.

In the Clients section of Track, the synced Quickbooks online will show the logo next to them.

Check and review the integration’s settings

After the first sync, the QuickBooks Online integration page shows the connection and its settings.

Authorisation: who linked the integration, which QuickBooks company it's linked to, and Valid authorisation. If QuickBooks reports that access has expired or been revoked, the label reads Authorisation needed, and sending pauses until an admin clicks Refresh authorisation.

Configuration: Unlink QuickBooks Online, Sync now, and when the last update arrived. QuickBooks updates arrive in real time.

What is kept in sync: the Clients card shows how many QuickBooks customers are linked (for example 14/15 QuickBooks Online customers linked). Click Review links to reopen the matching window and change links at any time.

Synchronization settings: choose what happens to customers added to QuickBooks Online later, on every sync:

  • Link clients automatically (on by default): links a new customer to the Track client with the same name.

  • Import clients automatically (off by default): imports new customers with no match as Track clients.

Now, let’s send your first invoice to QuickBooks Online.

How to send your first invoice to QuickBooks

  1. Create a draft invoice as usual: New invoice, pick the client, choose tracked time, projects, hours and expenses, then Create draft.

  2. Save the draft. Instead of Issue invoice, the header now shows Send to QuickBooks Online. A banner explains what happens, and the invoice number field reads Assigned by QuickBooks Online when sent.

3. Click Send to QuickBooks Online. Track creates the invoice in QuickBooks, QuickBooks assigns its number (for example 1048), and the invoice becomes Open in Track.
​

4. A confirmation shows the QuickBooks number, and a caption under the title reads Last sent: [date, time] · 1048 in QuickBooks Online.

Where to find, manage and edit your QuickBooks invoices

When the client pays, QuickBooks syncs the payment to Track. The invoice is automatically marked as paid with the payment date, so no one has to update it manually.

In the Invoices section, every invoice updated through QuickBooks shows the QuickBooks icon and its QuickBooks number. The Activity section of the integration page logs every step: the link, client matching, each invoice sent or updated, and each status change.

To edit an invoice you’ve already sent:

You can keep editing an invoice in Track until it's paid or voided in QuickBooks.

  1. Open the invoice and click Edit invoice. You can change the issue date, due date, tax rate and line items.

  2. After your first change, an orange note reads Changes need saving.

  3. Click Update in QuickBooks Online. Track saves the invoice and replaces it in QuickBooks in one step, keeping the same number.

  4. A confirmation reads QuickBooks Online invoice updated, and the Last sent time refreshes.

How status updates work between QuickBooks and Track:

- If an invoice is edited in QuickBooks, it reverts to Open in Track.

- An invoice voided in QuickBooks is also voided in Track.

- A partially paid invoice in QuickBooks stays open in Track until it is fully paid.

Did this answer your question?