LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

Exchange On-Premises GAL Contacts syncs one-way to QuickBooks Customers

Sync Exchange On-Premises GAL and Quickbooks Contacts

Learn how to sync your Exchange On-Premises GAL and Quickbooks contacts using the SyncPenguin platform


Free 14-day trial with full support, no credit card required

Many organizations keep their official directory in Exchange Server. This can include employees, affiliates, subsidiaries and external client contacts stored in custom address lists. When those people need to be invoiced or billed, someone has to retype their names, companies and email addresses into QuickBooks Online by hand. That manual entry is slow and causes typos and duplicate customers. Records also drift out of date when people change companies, email addresses or leave the organization, so finance teams end up billing from information that no longer matches the company directory.

How SyncPenguin helps

SyncPenguin automatically copies contacts from your Exchange On-Premises Global Address List, or any custom address list, into QuickBooks Online as customers. New entries become customers that are ready to invoice, and changes made in Exchange flow into QuickBooks on every sync. No-code filters let you choose exactly who becomes a customer, such as one company, one address list or only people with an email address. Custom rules let you control how records appear, for example by building unique display names or adding job titles and departments to customer notes. Your Exchange directory stays the single source of truth, and your accounting team never has to retype a contact again.

Best suited for: Accountants and bookkeepers in organizations running Exchange Server. Finance teams handling intercompany or departmental billing. IT administrators managing Exchange directories. Professional services firms storing client contacts in Exchange.

Real-world use cases

  • Sync a custom Exchange address list of external client mail contacts into QuickBooks Online, so every new client added in Exchange is instantly ready to be invoiced.
  • Create QuickBooks customers for contacts at subsidiaries and affiliate companies listed in the GAL, filtered by company name, to simplify intercompany billing.
  • Add employees from the Global Address List as QuickBooks customers to bill employee purchase programs, company store orders, training fees or equipment charges.
  • Support departmental chargebacks by syncing department heads from Exchange into QuickBooks, with a custom rule that writes their job title and department into the customer notes.
  • Keep former employees and contacts in QuickBooks history by turning off deletion syncing in the general rules. You can also use deletion rules so that people removed from the address list are simply marked inactive.
  • In a hybrid environment, combine the Exchange On-Premises GAL and the Microsoft 365 GAL into one QuickBooks customer list during a cloud migration.
  • After a merger, bring together directories from Exchange On-Premises and Google Workspace into a single QuickBooks Online customer list for consistent billing.
  • Feed the same filtered Exchange address list into both QuickBooks and Xero when different entities or regions use different accounting systems.
  • Sync client contacts from Exchange into QuickBooks, then keep QuickBooks customers in two-way sync with HubSpot so sales and finance share the same client details.

Key features

Invoice-Ready Customers

Turn Exchange address list entries into QuickBooks customers with names, company and email filled in, ready for invoices and estimates.

Automatic Updates

New entries and changed names, companies or email addresses in Exchange are picked up automatically and applied to QuickBooks.

Smart Filters

Sync only the contacts you bill, for example a specific company, department or address list, using simple no-code filters.

No-Code Mapping

Map fields your way, add job title and department to customer notes, or build unique display names with custom rules.

No Duplicates

SyncPenguin matches existing QuickBooks customers during the initial merge and tracks every record, so your customer list stays clean.

Affordable & Scalable

With SyncPenguin you only pay for changes to your data, regardless of how many contacts you have now or will have in the future.

Things to note

  • The Exchange On-Premises GAL connector is read-only, so this is a one-way sync from Exchange to QuickBooks. Your company directory stays protected, and you make edits in Exchange as usual.
  • The connector syncs names, display name, company, job title, department and the primary email address. Phone numbers and postal addresses are not read from the GAL, so you can add billing details in QuickBooks when needed.
  • QuickBooks has no dedicated job title or department fields. You can easily place these values in customer notes or other fields using SyncPenguin custom rules.
  • QuickBooks requires unique customer display names. If two people share a name, a simple custom rule can make each one unique, for example by appending the company or department.
  • The connector works with QuickBooks Online only, and each connection links to one QuickBooks company.
  • Your Exchange Server must be version 2013 or newer with Exchange Web Services (EWS) reachable from the internet. You will also need the ID of the address list you want to sync.
  • QuickBooks does not permanently delete customers. If deletions are synced, removed contacts are marked as inactive, which keeps your invoices and accounting history intact.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose Exchange On-Premises GAL Contacts for the first app.
  • Then choose QuickBooks Customers for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Exchange On-Premises GAL and Quickbooks

Now that your sync is created, the next important step is to grant SyncPenguin access to your contact data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Exchange On-Premises GAL?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Exchange On-Premises GAL Contacts account connection section will look like this:

Account for Exchange On-Premises GAL Contacts (Example)
Exchange On-Premises GAL Contacts

How to connect Quickbooks?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The QuickBooks Customers account connection section will look like this:

Account for QuickBooks Customers (Example)
QuickBooks Customers

Please make sure both apps are properly connected before starting the contact sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Additionally, in Field mappings & rules you can customize how contact data is mapped between the apps, or add filters and custom rules to the sync. This is done using our simple no-code visual interface, which lets you make simple adjustments as well as implement complex custom scenarios.

Supported Exchange On-Premises GAL fields: First name Last name Display name Job title Department Company Email address
Supported Quickbooks fields: First name Last name Middle name Display name Title Suffix Notes Company name Website Email Work phone Mobile phone Other phone Fax Billing address Shipping address

Virtually any syncing behavior based on supported fields is possible using the customizations interface.

Learn more about our customization interface.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Only sync new data, meaning anything added or updated from now on.
  2. Merge Exchange On-Premises GAL Contacts into QuickBooks Customers: take all Exchange On-Premises GAL Contacts and add/merge them into QuickBooks Customers.
Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing contacts?

Once you've made your choice, click Start syncing. If you choose an initial merge, it'll be queued immediately. Once it's done, we'll check for contact changes at the sync interval you've set and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

Can I sync my Exchange On-Premises Global Address List to QuickBooks Online customers?

Is the sync one-way or two-way?

Can I sync only certain contacts, like external clients or one company?

Does this work with QuickBooks Desktop?

Will the sync create duplicate customers in QuickBooks?

What happens when someone is removed from the Exchange address list?

How do I find my Exchange address list ID?