Virtuous CRM+ enables you to track your donors' history, generate donation receipts, and manage donor relationships. But there is far more to your organization's financial picture than just donations received, which is why you'll need to maintain a separate accounting system. Organizations using Quickbooks Online can use the Virtuous Connect sync tool to sync data from Virtuous CRM+ to Quickbooks.
Table of Contents
- Important Sync Notes
- Creating a Sync User Profile
- Quickbooks Login
- Settings
- Features and Mapping
- Best Practice Mapping
- Failed Transactions
Important Sync Notes
- All data between the date the integration set up process is initiated and the date it is turned on will all attempt to sync when the integration is turned on. It's recommended to complete the integration setup process in one sitting.
- If the integration is set up and active, then later disabled, when the integration is turned back on, ALL data between the last sync and present day will attempt to sync. It is NOT recommended to regularly turn the sync on and off to manage the flow of records.
Creating a Sync User Profile
First thing you need to do is create a user that is not linked to any of your current users. To ensure data constantly flows regardless of staffing changes, password issues, and any other number of access hurdles that may arise when using an active staff member's Virtuous CRM+ profile, it's always best to create a new User Profile to act as the pathway between.
To create your new User you'll head to the navigation on the left of the screen then select Settings > Team Settings.
This User should have most privileges within Virtuous CRM+ AND NOT SSO or two factor authentication. Best practice:
- Should be an admin user, so the Quickbooks Online specific user has access to enter all data into Virtuous CRM+.
- OR if that makes you uncomfortable, you can create a unique permission group (Settings > All Settings > Permissions > Create Permission Groups) for the user... it must have the following full permissions:
- Contacts
- Projects
- Gifts
- Recurring Gifts
Configuring the Sync
Before beginning the sync configuration process be sure you are logged in to Virtuous CRM+ using the alternative user account previously established. Being logged in to this specific account while configuring the sync will tie the integration settings to said User profile.
To setup, review, or manage the details of this integration, select "Integrations" from the left-hand menu. Select "Virtuous Connect" from the available options. There, you can log in with the same username and password you use to log in to Virtuous CRM+.
If your team may need additional support implementing and/or managing the Quickbooks Online integrations, check out the Virtuous App Marketplace. To access the App Marketplace, select "App Marketplace" from the Integrations menu.
Note: Only Admin Users can access the App Marketplace within Virtuous CRM+. Also, it's recommended to consult with your organization's DBA regarding any modifications needed or errors occurring.
To learn more about the Virtuous App Marketplace, check out this Support Article.
In the Virtuous Connect App, you will see some options for various integrations, including Quickbooks.
Quickbooks Login
Settings
You will now be able to configure the settings for this integration. These settings can be changed at a later time, if needed. The first section of Settings dictates how data flows to QuickBooks Online overall.
The first selection of settings options include:
-
Sync Enabled- To enable this integration, check this box
- NOTE: All Gifts entered into Virtuous CRM+ from the moment you select this checkbox will be pushed to QBO.
- Rollup Gifts by Project/Fund- To sync projects instead of individual gifts, check this box
- Sync New Contacts - To sync new contacts, check this box. This feature will create new contacts in QuickBooks if an existing contact with a matching name is not found. If this feature is disabled it will only match with existing contacts.
Next, you'll need to map your Account and Field details from Virtuous CRM+ to Quickbooks.
The second selection of settings include:
-
Account Mapping
- Map to a Single Account- To connect both debit and credits to a single bank account, check this box
- Payment Method- Select the specific payment method to sync for the bank account. You are limited to one Payment Method.
- Bank Account- QuickBooks Login tab will need to be completed prior to bank account information being available; Select the bank account that your payments are debiting from
-
Field Mapping
- Virtuous Field- Select the desired gift/payment field to map to Virtuous CRM+ to QuickBooks
- QuickBooks Field- Select the field that will be the destination of the corresponding Virtuous CRM+ data
Features and Mapping
Standard Field Mapping
There are additional options for mapping both Virtuous CRM+ Standard Fields and Quickbooks Standards Fields.
When mapping data to Quickbooks fields, you must have a value mapped to A Revenue Account in order for the sync to work. The Revenue Account is actually the name of a Product/Service in Quickbooks that is linked to a specific revenue account. The Product/Service name is required for mapping purposes because transactions are added to Quickbooks as sales receipts. To manage Product/Service details in Quickbooks, check out this Support Article (QBO login required) provided by the Quickbooks team.
Best Practice Mapping
Below is a chart of the best practice mapping recommended to use when syncing Gifts between Virtuous CRM+ and QBO. This mapping will populate as the default formatting when initially setting up the integration.
Note: Contact and Individual Custom Fields are not available for mapping.
| Virtuous CRM+ Field | Quickbooks Online Field |
|---|---|
| Contact Name | Customer Name |
| Gift ID | Payment Reference |
| Gift Date | Sales Receipt Date |
| Gift Amount | Amount |
| Project Code | Class |
| External Accounting Code | Revenue Account |
To add another field to your mapping, simply select the grey plus sign available to the right of the last row of mapping.
Gift Type Mapping
All standard Virtuous CRM+ Gift Types are listed and a corresponding QuickBooks Bank account can be selected to where the data will credit to via the sync.
Payment Method Mapping
Failed Transactions
The sync will push through approximately every 3 hours if syncing single Gifts. If you select Rollup Gifts by Project/Fund, then it will sync overnight. If a Gift record attempts to sync to QuickBooks Online and does not successfully sync for any number of reasons, these transactions will be placed in a "Failed Transactions" log for review. When this happens, an email will be sent to the Notification Email address, prompting you to review the Failed Transaction.
If any transaction fails to sync to Quickbooks from CRM+, the integration will pause all transaction syncs until the error is resolved. No transactions will sync until the failure is addressed and corrected.
Troubleshooting “Duplicate Document Number” Errors
If you have a failed transaction related to a duplicate document number, that can be resolved by updating your settings in QuickBooks. The “DocNumber” or the “CheckNumber” may be the source of the error, but both issues can be fixed by configuring QuickBooks settings.
To resolve Document Number Errors based on “DocNumber”:
- Navigate to Account Settings > Sales in your Quickbooks account.
- Click the edit icon next to Sales form content
-
Toggle off Custom Transaction Numbers.
- Save your changes.
- Navigate back to the Virtuous Connect App, and retry the sync.
Note: Disabling this setting only impacts the QBO’s internal transaction ID. The ID shown in the QBO interface and included in exports from QBO will still align with the ID shown in the Connect App, so you will still be able to easily reconcile between the two applications.
To resolve Document Number Errors based on “CheckNumber”:
- Navigate to Account Settings > Advanced in QBO
- Click Edit in the Other Preferences Section
-
Toggle off Warn me if duplicate check number is used.
- Save your changes.
- Navigate back to the Virtuous Connect App, and retry the sync.
Other Errors
For all other error types, you may need to create the corresponding Accounts in Quickbooks or modify mapping in the Settings in Connect. While you are doing this, keep in mind that you are not able to re-sync a single transaction at a time. You will need to correct the underlying issues and then re-sync ALL failed transactions.
If there are some transactions that should not be synced to Virtuous CRM+ at all, select the trashcan icon available to the right of each transaction. This will delete the entry entirely and make it so that specific transaction will NOT re-sync when you retry.
When you have remedied the errors in Quickbooks, select Retry Sync to sync the transactions to the correct accounts.