Home > CiraHub Support > How to Two-Way Sync Contacts Between QuickBooks and a Global Address List

Are you in need of a synchronization service that can sync your Global Address List contacts with other platforms, such as QuickBooks? If so, you’ve come to the right place! CiraHub allows users to two-way sync their contacts across QuickBooks and a Global Address List (GAL). 

For example, a two-way solution allows organizations to sync contacts between multiple Global Address Lists, then changes made to one GAL are reflected to any connected GAL. But in this article, we will show you how to two-way sync contacts between a Global Address List and QuickBooks. 

Thanks to this Two-way sync feature, you can

  • Sync Global Address List contacts directly into QuickBooks. 
  • Have access to a clean and intuitive dashboard.  
  • Sync from QuickBooks, Salesforce, HubSpot, ActiveCampaign, and more.   

  This article will show you how to enable a two-way sync for QuickBooks and a Global Address List. 

Set Up Two-Way Contact Sync Between QuickBooks and a Global Address List 

Create a Spoke for QuickBooks

1. Log into CiraHub. You will be taken to the onboarding wizard.

Log in to CiraHub and select contacts as the object to sync

2. Next, you’ll need to choose the type of object you want to sync. Select “Contacts.”

Select the Contacts object

3. To start your Hub and Spoke setup, click “CRM” as the source type of your contact spoke, then select “Quickbooks” from the list of CRMs and click NEXT.

Select Crms as the source type of your contact spoke

4. Click “Sign in with QuickBooks” and enter your company’s name, then click “Create Company” to connect with the CiraHub Connector.

Connect CiraHub to QuickBooks

5. Enter a name for your current spoke and click “CREATE.”

Name your spoke

 7. Type in a Spoke name and click NEXT.

Type in spoke name and click next

8. Type in a Hub name and Click CREATE.

Type in Hub name and Click Create

Create Global Address List Spoke

9. First, Log in to CiraHub. You will be taken to the onboarding wizard. (See figure below.) Next, select the object you want to sync. In this example, the contacts object has been selected.

Prior to setting up the Hub and Spokes in CiraHub, you will need to set up a Microsoft 365 account with the Global Admin role. You will need this to set up and grant access permissions, as requested by Microsoft.  

Hub and Spoke Setup

10. Next, start the Hub and Spoke setup. Click on “Microsoft 365 in my tenant”, then Select Global Address List as the source type for your contact spoke. Users will need to have an Office 365 account with the following Exchange Online roles granted via PowerShell: Address Lists, Mail Recipient Creation, and Mail Recipients permissions which will act as a Service Account to run the GAL sync.

This account does not need to have a Microsoft 365 license. However, an Microsoft 365 license will be required for each tenant added to the Hub.

Select Global Address List

11. There are two authentication methods – Credentials and Certificate based. Select Credentials and sign in with your Microsoft Admin Account’s Login and Password Information for the GAL Connection.

“Select” Credentials and Re-Enter your Microsoft Account

12. Next, the Microsoft Sign-in page will appear. Provide the Email and Password to your account.

Sign in with Microsoft

 

13. Click Accept to give CiraHub access to your Microsoft Account. You should always leave the “Consent on behalf of your organization” box unchecked when you sign in for the first time. This option lets other users under the same domain access this Hub if they log in using their company email address.

A user would not have access to this Hub, but they would be able to log in and create their own hub.

Give CiraHub Permission to Microsoft

14. Select Credentials and re-enter your Microsoft Account Login and Password Information for the GAL Connection.

Validate GAL

15. Wait for CiraHub to validate the connection to the Global Address List after entering the Login and Password.Select Authentication Method

[/tab]

16. With the Certificate Authentication method, you will be prompted to either “Automatically Generate a Certificate,” or you can choose to Import a PFX Certificate File and enter your password.Certificate Authentication

17. Enter your Microsoft Global Admin email address. CiraHub will then store your account information in the Microsoft Azure Vault when it is synced from Powershell.Enter Microsoft 365 Email

18. Lastly, you will need to wait for CiraHub to Install Certificate-Based Authentication for the GAL connection and then click Next to two-way sync GAL contacts. Install Certificate

19. Type in a Spoke Name and click Next.

Add Gal spoke name

20. Type in a Hub Name and click CREATE. 

exchange server hub name

21. Next, right click your spoke, and select “Sync Options”. From there  click the box “Allow Hub to create and sync items in this spoke.” This will enable 2-way synchronization between the Hub and your spoke.Right click your spoke and select sync options

22. Click on “Allow Hub” to create and sync items in this spoke. This will enable two-way synchronization from the endpoint to the Hub database and back.Click allow hub to create and sync items from this spoke

23. Click on “Sync now” in order to enable a 2-way sync for the current spoke to two-way sync between an Exchange Server Mailbox and a Microsoft 365 Public Folder. You can also edit any synchronization options for each of your spokes down below.

Click sync now to two-way sync items

Why Two-Way Sync QuickBooks with Your Global Address List

With CiraHub users can sync contacts between QuickBooks and the Global Address List (Gal). Companies can sync data from the GAL to QuickBooks from the GAL to the QuickBooks , or back-and-forth with CiraHub’s sync configurations. CiraHub keeps contacts in perfect sync between the Global Address List (GAL) and QuickBooks, so users wont have to manage contacts in two different locations.