LOOKING FOR PARTNERS 🤝

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

Notion Contacts syncs with QuickBooks Customers

Sync Notion and Quickbooks Contacts

Learn how to sync your Notion and Quickbooks contacts using the SyncPenguin platform


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

Many businesses manage clients in a Notion database while invoicing those same clients in QuickBooks Online. The two apps don't talk to each other, so every new client has to be entered twice, and changed emails, phone numbers, or company names have to be updated by hand in both places. Over time, the project team and the accounting team end up working from different client lists. That leads to invoices with outdated details and wasted time copying data.

How SyncPenguin helps

SyncPenguin connects your Notion contacts database with your QuickBooks Online customer list and keeps them in sync automatically. You can sync both ways or in one direction only. Clients added in Notion become QuickBooks customers ready for invoicing, and customer updates made in QuickBooks flow back into your Notion workspace. You can use your existing Notion database as it is and choose which columns hold names, emails, and phones. No-code filters, field mapping, and custom rules let you decide exactly which clients are synced and how their details appear in each app.

Best suited for: Freelancers and consultants. Agencies and service businesses. Small business owners. Bookkeepers and operations managers.

Real-world use cases

  • Sync QuickBooks customers into a Notion client database one way, so project and account teams always have current client contact details without access to accounting.
  • Two-way sync your Notion client database with QuickBooks, so clients added by account managers in Notion are ready for invoicing in QuickBooks, and updates made by accounting flow back to Notion.
  • Push only Notion contacts with a 'Billable' checkbox checked or a 'Client' value in a select column to QuickBooks, so leads and partners stay out of your accounting.
  • Use a custom rule to build unique QuickBooks display names by combining the Notion name and company columns, which avoids rejected records for clients with the same name.
  • Automatically check an 'Onboarding needed' checkbox in Notion whenever a brand-new QuickBooks customer is synced, using record metadata in a no-code custom rule.
  • Sync Shopify customers into QuickBooks for invoicing, and then sync QuickBooks customers into a Notion database so your team has a single client overview.
  • Keep Notion, QuickBooks, and Google Contacts aligned, so client details are available in your workspace, your accounting, and on your phone.
  • Sync QuickBooks customers to a Notion database and distribute them from Notion to team members' Microsoft 365 Contacts, so everyone recognizes clients when they call or email.
  • Sync only QuickBooks customers that have an email address into Notion, and map company, website, and notes to Notion text and URL columns.

Key features

Two-Way Sync

Changes made in Notion or QuickBooks are synced automatically in both directions, or you can choose a one-way sync.

Any Notion Database

Use your existing client database without templates. Just pick the columns that hold names, emails, and phone numbers.

Smart Filters

Send only billable or active clients to QuickBooks, based on Notion selects, checkboxes, or any other synced field.

Custom Rules

Transform values with no-code rules, such as building unique QuickBooks display names from name and company columns.

Safe Deletions

Removed customers are made inactive in QuickBooks, and deleted Notion pages go to the trash, so nothing is lost for good.

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 integration works with QuickBooks Online. QuickBooks Desktop is not supported.
  • Your Notion database needs a 'Last edited time' column so changes can be detected. You can add one in Notion in a few clicks.
  • QuickBooks stores one primary email per customer. If a Notion contact has several emails, the work email (or the first one) is used.
  • QuickBooks requires unique customer display names. You can use custom rules to build unique names, for example by adding the company name.
  • Notion formula, relation, person, files & media, and status columns can't currently be synced, and QuickBooks custom fields aren't available for syncing.
  • QuickBooks customers can't be permanently deleted, so they are marked inactive instead. Only top-level customers are synced, and sub-customers (jobs) are skipped.
  • Changes are picked up on regular sync intervals rather than instantly.

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

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

Account for Notion Contacts (Example)
Notion 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 Notion fields: First name Last name Full name Emails (work, home, other) Phones (work, mobile, other) Title columns Text columns Number columns Date columns Checkbox columns Select columns Multi-select columns URL columns Email columns Phone number columns Rollup columns (read-only, as text)
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 all historic data two-way: take all Notion Contacts and QuickBooks Customers and merge them together. Any data that already exists in both apps is merged instead of being duplicated.
  3. Merge Notion Contacts into QuickBooks Customers: take all Notion Contacts and add/merge them into QuickBooks Customers.
  4. Merge QuickBooks Customers into Notion Contacts: 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 my Notion contacts database with QuickBooks Online customers?

Do I need a special Notion template?

Will syncing create duplicate customers in QuickBooks or Notion?

Can I send only some Notion contacts to QuickBooks?

My Notion database uses a single 'Name' column. Will it work with QuickBooks first and last names?

What happens when a client is deleted?

Does this integration work with QuickBooks Desktop?