Sync Contacts with QuickBooks
How contacts sync between JobsiteOn and QuickBooks Online, including matching logic, address changes, conflict resolution, and manual sync.
How contacts sync between JobsiteOn and QuickBooks Online, including matching logic, address changes, conflict resolution, and manual sync.
This guide explains how contact records sync between JobsiteOn and QuickBooks Online. You will learn how records are matched, what happens when conflicts occur, and how to trigger a manual sync.
JobsiteOn contacts map to QuickBooks customers. The sync is bi-directional: changes in either system reach the other, with the exceptions noted below.
| JobsiteOn field | QuickBooks field | Sync direction |
|---|---|---|
| First and last name | First and last name | Bi-directional |
| Bi-directional | ||
| Phone and mobile | Phone and mobile | Bi-directional |
| Address | Billing Address | Bi-directional (see below) |
| Company | Company name | JobsiteOn to QB |
JobsiteOn also sets the QuickBooks display name from the company and the person's name, such as "Acme Roofing (Dana Lee)". It changes that name in QuickBooks only when you change the contact's name or company in JobsiteOn, so a customer your bookkeeper renamed in QuickBooks keeps its QuickBooks name.
When you add a contact, or change its name, email, phone, mobile, company or address, JobsiteOn sends the change to QuickBooks within a few minutes. It sends only the fields you changed, so an edit made in QuickBooks to another field stays in place.
Two kinds of contacts are not sent to QuickBooks as customers on their own:
They are the people around your customer, not customers you bill. When you invoice one of them, QuickBooks gets them as a customer with that invoice, and from then on their changes sync like any other contact's.
QuickBooks tells JobsiteOn when a customer is added or edited, and the change usually shows up within a few minutes. JobsiteOn also checks QuickBooks once a day for anything it missed (once a week if nobody on your team has used JobsiteOn in the last 7 days). Sync now runs that check right away.
Active customers added in QuickBooks become new contacts in JobsiteOn, unless they match an existing contact (see Matching logic). Each one goes under a company with the customer's company name. A homeowner with no company name gets a company named after them, the same way a file import works.
Screenshot: A side-by-side view of a contact in JobsiteOn and the same customer in QuickBooks, with arrows showing the synced fields.
The address follows its own rules:
The exception: sometimes JobsiteOn doesn't know which address it last synced, mostly for contacts last synced by an older version of JobsiteOn. If such a contact was changed in JobsiteOn since its last sync, in any field, JobsiteOn keeps its own address:
To keep the JobsiteOn address, change the contact's name, email, phone, mobile or company, so JobsiteOn sends its address to QuickBooks.
Records are matched in both directions:
What happens when there's no single match:
When you first connect, your existing contacts are usually sent before the first import from QuickBooks runs, so most of them are matched by email or display name. See Connect QuickBooks Online for an example.
Each field is compared on its own: the name, the email, the phone, the mobile and the address.
If the same field is edited in both systems, the most recent change wins.
Edits to different fields are all kept. For example, if your bookkeeper changes a customer's phone in QuickBooks while you change its email in JobsiteOn, both systems end up with the new phone and the new email, whichever arrives first.
For a contact last synced by an older version of JobsiteOn, the whole contact follows the most recent change until JobsiteOn next sends it.
A field left blank in QuickBooks never erases what you have in JobsiteOn.
Deleting a customer or marking it inactive in QuickBooks doesn't delete the contact in JobsiteOn. Contacts you deleted in JobsiteOn don't come back from QuickBooks either.
Changing a customer's company name in QuickBooks doesn't move the contact to a different company in JobsiteOn. Move it in JobsiteOn if you need to.
Animation: A timeline showing a contact edited in JobsiteOn at 2:00 PM and in QuickBooks at 2:15 PM, with the QuickBooks version winning because it was more recent.
/settings > Marketplace > QuickBooks
Online > Manage integration.QuickBooks needs each customer, vendor and employee to have its own display name. When JobsiteOn sends a contact whose display name is taken by a QuickBooks customer that belongs to another contact, or that has a different email address, it adds the contact with a number after the name, such as "Pat Lee (2)", up to "(5)". Rename either one whenever you like. If all those names are taken too, you see the sync error "QuickBooks already has customers with this name that belong to other contacts." Rename the contact in JobsiteOn, then retry.
When two customers are merged in QuickBooks, the JobsiteOn contact linked to the customer that went away is linked to the one that remains, and picks up its details. If both customers were linked to different JobsiteOn contacts, nothing moves: you see the sync error "Two customers were merged in QuickBooks, but they are still two contacts in JobsiteOn." Merge the two contacts in JobsiteOn.
If saving this warning fails, JobsiteOn retries it. Repeat notifications do not add another warning for the same merge or reopen one you resolved.
When JobsiteOn moves the link, it keeps that change even if the surviving customer's updated details arrive later. Reload the contact page to see the new link.
Check that Customers sync is on, then check the sync log for a failure on that contact. A person made from an imported customer's emails, or added as a new related contact, waits for their first invoice (see above). For a contact last synced by an older version of JobsiteOn, a change to the address alone waits for the contact's next name, email, phone, mobile or company change. If the QuickBooks page shows Reconnect QuickBooks, your QuickBooks sign-in stopped working.
JobsiteOn keeps the display name your bookkeeper gives a customer in QuickBooks, such as "Lee Residence". It sends a new display name only when you change the contact's name or company in JobsiteOn.
Tip: Before connecting QuickBooks, clean up your contact records in both systems. Merge duplicates and standardize email addresses for the best matching results.
In the record's Details panel, choose View in QuickBooks to open its synced copy in a new tab. Sign in to the connected QuickBooks company if asked. The link appears once the record has synced and its connection is still present. It stays hidden in a JobsiteOn sandbox workspace.
Did this answer your question?