What should we do initially with already existing contacts?
- Connectors
- Exchange On-Premises GAL Contacts
- QuickBooks Customers
- Exchange On-Premises GAL Contacts and QuickBooks Customers Sync
LOOKING FOR PARTNERS 🤝
We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.
Sync Exchange On-Premises GAL and Quickbooks Contacts
Learn how to sync your Exchange On-Premises GAL and Quickbooks contacts using the SyncPenguin platform
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.



