Contents

Introduction
Connecting Neon CRM to QuickBooks
Synchronizing Data from Neon CRM to QuickBooks
Using the QuickBooks Integration 
Frequently Asked Questions

Connecting Neon CRM to QuickBooks

Integration functionality and data types available in QuickBooks may be dependent on your QuickBooks service plan and features. Please consult QuickBooks to identify the package that would be the best fit for your needs.

Neon CRM is able to connect to the following versions of QuickBooks. 

QuickBooks Online

• Mac or PC
• US clients only

QuickBooks Desktop

• 2020 edition or later
• Installed on a PC (Mac is not supported)
• US clients only
• Not installed on a remote server
• Enterprise is not supported

Synchronizing Data from Neon CRM to QuickBooks

The synchronization between Neon CRM and QuickBooks is a one-way sync. Using the sync, transaction data that is entered into Neon CRM will be synchronized to QuickBooks. The sync does not allow you to send data from QuickBooks to Neon CRM. In the sync, Neon CRM passes up to six types of data:

• Customer Information
• Invoices & Payments -or- Sales Receipts
• Service Items, Classes, & Deposit-to Accounts

Customer Information

First, the sync will determine which QuickBooks Customers should receive the appropriate Neon CRM transactions.

In QuickBooks, Name is a single field called Customer. When you configure your Neon CRM/QuickBooks connection, you will have the ability to identify how you have tracked Customer names in QuickBooks.

Using this rule, Neon will combine the First Name and Last Name fields on the Neon CRM record to find a matching Customer in QuickBooks. If a match is found, Neon CRM will add the Neon CRM transaction information to the existing matching Customer in QuickBooks. If no match is found, a new Customer will be created in QuickBooks using the Neon CRM account name.

In either case, Neon will create a linking ID number to match the account in Neon with the customer in QuickBooks. This will be used in the future to send transaction records to the appropriate account.

Invoices and Payments

Next, the sync will create an invoice and a corresponding payment for each transaction that is pushed from Neon CRM on the appropriate Customer record(s). The invoice will be for the Amount of the transaction entered in Neon CRM and the Transaction Date will also be synced from Neon CRM.

For payments, the Tender Type data from your Neon CRM transaction can be synced to the Payment Method field in QuickBooks. Additionally, the contents of any populated Payment Note field on a Neon CRM transaction record will be synced to the Memo Field of the QuickBooks transaction.

If you are syncing pledges, the sync will create an open Invoice for the amount of the pledge. A corresponding Payment will be created when you sync the payment(s) for the pledge. More information on pledges and pledge payments in Neon CRM is available here.

Sales Receipts

Instead of invoices and payments, you can choose to use Sales Receipts during the setup process. If you do, the sync will create one Sales Receipt for each transaction that is pushed from Neon CRM on the appropriate Customer record(s). The Sales Receipt will include both the Payment and Receipt of the transaction entered in Neon CRM. The Transaction Date will also be synced from Neon CRM.

The Tender Type data from your Neon CRM transaction can be synced to the Payment Method field of the corresponding transaction record in QuickBooks. Additionally, the contents of any populated Payment Note field on a Neon CRM transaction record will be synced to the Memo Field of the QuickBooks transaction.

If you are syncing pledges, the sync will create an open Invoice for the amount of the pledge. A corresponding Payment will be created when you sync the payment(s) for the pledge. More information on pledges and pledge payments in Neon CRM is available here.

Service Items, Classes, & Deposit-to Accounts

Neon CRM will send more detailed information about each transaction to QuickBooks via Service Items, Classes, and/or Deposit-to Accounts. This information will then be displayed on the generated QuickBooks Invoice & Payment or Sales Receipt(s).

During the setup of the Neon CRM/QuickBooks integration, you will be asked which Service Items, Classes, and Deposit-to Accounts you would like to map as the default selection for the following Neon CRM tax, shipping, discounts, & transaction types; as well as how you would like to further sub-divide the mapping for each:

• More information about Service Items in QuickBooks is available in this Intuit guide.
• More information about Classes in QuickBooks is available in this Intuit guide.

Using the QuickBooks Integration

A full guide on how to use the QuickBooks integration is available here.

Frequently Asked Questions

Can Neon CRM help me decide how to set up my QuickBooks system?

While we can definitely help with troubleshooting the Neon CRM QuickBooks synchronization and better understanding how it works, we unfortunately cannot assist with questions about how to structure your QuickBooks system. For specific questions regarding QuickBooks structure and setup, we recommend working with our Neon One consultant partners at QuickBooks Made Easy.

Can I sync to Bank Accounts in QuickBooks?

No. Neon CRM's integration with QuickBooks does not allow for transactions to sync to a Bank Account in QuickBooks.

I'm receiving errors when I try to set up my QuickBooks integration.

You can view common sync errors and solutions here. Our Customer Support team can assist with troubleshooting specific error messages. You can learn how to contact Customer Support here. Note that if you are currently working with a Training & Implementation Consultant, you may not yet have access to support. You will be provided with access upon completion of your consultation services.

Can my Pro Services Consultant walk me through QuickBooks setup?

Our Professional Services Consultants are not accountants and cannot provide specific guidance on how to best configure your QuickBooks account. Our Consultants can conceptually discuss the different options your organization has for setting up your Neon CRM transaction structure and Neon field mapping to best sync with QuickBooks.

However, final decisions about how to configure your QuickBooks integration are at the discretion of your organization. Since every nonprofit organization has different accounting needs, there is no singular way to configure the integration.

I'm in the process of mapping my Service Items and Classes, and I'm not seeing all of them in Neon. Why is that?

There are two possibilities. One is that these items may have been added to your QuickBooks account recently and have not yet been downloaded to your Neon CRM. Try updating your downloaded list in your system to see if that helps.

If you are still not seeing all of your Service Items and Classes, it is more than likely that you have exceeded the cap for one or both of them. See below for the maximum amount allowed:

• Service Items: 999
• Classes: 100

I use QuickBooks, but the way that Neon CRM syncs data to QuickBooks does not match our QuickBooks structure. Do I have to use the QuickBooks sync?

You are not required to use the Neon CRM/QuickBooks synchronization. If you find that the synchronization does not do what you need it do, you may want to consider entering your transaction data in both QuickBooks and Neon CRM and then reconciling the two systems on a regular basis. To help with reconciliation, you can run reports in Neon CRM on transactions. More information on reporting is available here.

My QuickBooks Desktop is hosted on a remote server (e.g. Cloud 9). Can Neon CRM connect to my QuickBooks there?

No. QuickBooks Desktop must reside on a local PC's hard drive as well as Intuit's Web Connector and the Web Configuration File.

Why are duplicate customers being created in QuickBooks when I sync with Neon CRM?

When syncing transactions, Neon CRM first tries to find the linking ID that would have been created from a previous sync. If no linking ID is found, it then tries to find a name match between the Neon CRM account and your QuickBooks Customers.

Neon CRM sends the First Name, Last Name, and Company Name on Neon CRM records to identify matching QuickBooks Customers (Company Name only matters for Company accounts). Neon CRM's First and Last Name must be an exact match with QuickBooks' Customer name in order to avoid duplicates. For example, if the Neon CRM record is John P. Smith and the QuickBooks Customer is John Smith, a new QuickBooks Customer would be created because this is not an exact match.

Additionally, you should double-check that your Formatting Option in Neon CRM matches how you have customer names set to display in your QuickBooks Account.

How does the integration handle in-kind donations?

QuickBooks is not able to accept transactions with $0 value synced from Neon CRM, so only transactions with either a Donation Amount greater than 0 or a Fair Market Value greater than 0 can be synced. If your in-kind donation is not appearing on the Sync list, double check that it has a Fair Market Value applied by editing the donation record.

Recommended Related Articles

• How do I connect Neon CRM to my instance of QuickBooks?
• Using the QuickBooks Integration
• Neon CRM & QuickBooks: Sample Mapping Options