LOOKING FOR PARTNERS 🤝

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

QuickBooks Customers syncs with Exchange On-Premises Contacts

Sync Quickbooks and Exchange On-Premises Contacts

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

Supports company-wide rollout

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

Many businesses keep their customer list in QuickBooks Online but run their email and contacts on their own Exchange Server. Because the two systems don't talk to each other, office and accounting staff end up copying names, phone numbers and addresses by hand, or exporting CSV files that quickly go out of date. The result is unknown callers in Outlook, invoices sent to old addresses, and the same customer typed in twice with slightly different details.

How SyncPenguin helps

SyncPenguin connects QuickBooks Customers with Exchange On-Premises Contacts, so your customer list stays current in both places automatically. You can push QuickBooks customers into a personal, shared or public Exchange contact folder, so the whole team sees them in Outlook and on their phones. You can also run a two-way sync, so updates made in Outlook flow back to QuickBooks for invoicing. Names, company, emails, phone numbers, addresses, website and notes are mapped automatically. No-code filters and rules let you decide which customers sync and how their details appear. Nothing needs to be installed on your Exchange server.

Best suited for: Accountants and bookkeepers. Office managers and administrative staff. IT administrators running Exchange Server. Small and medium business owners.

Real-world use cases

  • Sync all QuickBooks customers one-way into an Exchange public folder named "Customers", so every employee sees customer names when they call or email.
  • Keep QuickBooks customers and an office manager's Exchange contacts in two-way sync, so phone and address updates made in Outlook are ready for the next invoice.
  • Create new QuickBooks customers automatically from Exchange contacts that are assigned the "Customer" category, using a filter on categories.
  • Add an "Accounting" category to every synced customer in Exchange with a custom rule, so QuickBooks customers are easy to find and group in Outlook.
  • Sync only QuickBooks customers with a sales rep's name in the notes into that rep's personal Exchange contact folder.
  • In a hybrid environment, sync QuickBooks customers to on-premises Exchange users and to Microsoft 365 mailboxes, so all staff share the same customer list.
  • Merge customers from QuickBooks and Xero into a single Exchange contact folder while running both accounting systems or migrating between them.
  • Sync Shopify customers into QuickBooks for invoicing, and then into Exchange, so online buyers are recognized when they call the office.
  • Turn HubSpot contacts that become customers into QuickBooks customers, and share them with the team through an Exchange shared contact folder.
  • Sync QuickBooks customers to Exchange for office staff and to Google Contacts for field staff who use Android phones.

Key features

One-Way or Two-Way

Send QuickBooks customers to Exchange only, or keep both sides updated in both directions.

Shared Customer Folders

Sync customers into a public folder or shared mailbox so everyone in the office can find them in Outlook.

Automatic Field Mapping

Names, company, emails, phones, addresses, website and notes are matched automatically and can be adjusted anytime.

Smart Filters

Sync only the customers you need, for example those with an email address or Exchange contacts tagged with a specific category.

Safe for Accounting

Customers removed through syncing are made inactive in QuickBooks, never erased, so invoices and history stay intact.

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 connection works with QuickBooks Online. QuickBooks Desktop is not supported.
  • QuickBooks stores one primary email per customer. When an Exchange contact has several emails, the work email (or the first one) is sent to QuickBooks.
  • QuickBooks supports one phone number of each type and two addresses (billing and shipping), so extra Exchange phone numbers or a third address are not transferred to QuickBooks.
  • QuickBooks customers can't be permanently deleted. Deletions synced from Exchange make the customer inactive, and inactive QuickBooks customers are treated as deleted on the Exchange side.
  • QuickBooks requires unique display names. You can use custom rules to build unique names automatically, for example by adding the company name.
  • Only top-level QuickBooks customers are synced. Sub-customers (jobs) are skipped, and Exchange contact groups (distribution lists) are not synced.
  • Your Exchange Web Services (EWS) endpoint must be reachable from the internet so SyncPenguin can connect to your server.

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 QuickBooks Customers for the first app.
  • Then choose Exchange On-Premises Contacts for the second app.
  • Then select the sync direction.
  • Then click the Create button.

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

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 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

How to connect Exchange On-Premises?

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 Contacts account connection section will look like this:

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

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 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
Supported Exchange On-Premises fields: First name Last name Middle name Display name Title Suffix Company Job title Department Emails Phones Addresses Birthday Website Business website Notes Categories Photo Spouse/partner File as File as format Created date

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 all historic data two-way: take all QuickBooks Customers and Exchange On-Premises Contacts and merge them together. Any data that already exists in both apps is merged instead of being duplicated.
  3. Merge QuickBooks Customers into Exchange On-Premises Contacts: take all QuickBooks Customers and add/merge them into Exchange On-Premises Contacts.
  4. Merge Exchange On-Premises Contacts into QuickBooks Customers: similar to the previous option but in the opposite direction.
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 QuickBooks Online customers with Exchange Server contacts?

Can I share QuickBooks customers with my whole team in Outlook?

Will syncing create duplicate customers or contacts?

Do I need to install anything on my Exchange server?

What happens when a customer or contact is deleted?

Can I sync only some of my QuickBooks customers?

Does this work with QuickBooks Desktop?