There are two version of QuickBooks: online and desktop.
Overview
This article explains how to connect Kindful to QuickBooks Online.
Linked Articles:
- Overview of the QuickBooks Integration
Connecting to QuickBooks Online
In Kindful, go to Apps on the left sidebar, then choose App Directory.
Locate the QuickBooks Online icon and click Learn More
Next, click Connect and then Connect again.
QuickBooks Online’s login page will appear in a new window. Sign in with your credentials.
When asked, choose Authorize to allow Kindful to access the data from QuickBooks Online.
You'll be redirected back to the Kindful Settings page, and if you see a green Sync Data with QuickBooks icon, you are ready to establish the connection.
Syncing QuickBooks
QuickBooks will not begin syncing until you configure the settings for the integration; choose Sync Data with QuickBooks.
Choose how you would like QuickBooks and Kindful to sync, then choose Ok, Start Sync.
Syncing Historical Data
When choosing to setup the integration and choose a date prior to “today” when syncing data to QuickBooks or Kindful, this warning will appear:
“Your integration settings are set to sync historical transactions. If the sync dates are not correct this can potentially cause duplicate transactions in either QuickBooks, Kindful or both accounts. If the sync dates are correct, click Ok to continue with the sync.”
This is also the case when selecting the “sync all data” option.
Sync Statuses
Kindful will display your QuickBooks connection in the current sync status. These statuses will be helpful if you find yourself in a spot where data is not syncing.
There are four statuses:
Connected - Your connection to QuickBooks has a valid token and working as expected
Paused - Your connection has a valid token, but an Admin user has selected to pause the integration. This is done by switching the Sync to “Pause Sync”.
Needs Attention - Your connection experienced an issue getting a valid token and the QuickBooks account needs to be disconnected and then subsequently reconnected
Disconnected - Your connection has disconnected and is no longer syncing
Of Note: These statuses are displayed as banners on the individual app card in the app directory as well as on the specific app page.
We also display the last sync date and time, and you can use this reference any potential data questions.
Paused vs. Needs Attention
When the integration is Paused, a message will appear on the app details page that says “The integration is paused. Please update the sync settings to resume.”
When the integration Needs Attention a message will appear on the app details page that says “There is an issue authenticating your account. Please disconnect and reconnect to resume syncing.”
A Note About Class-Campaign Syncing
Please note: if you don't want the QuickBooks-Kindful integration to keep your Classes and Campaigns "in sync", then we can turn that off for you. This can be turned off even if you are already using the QuickBooks-Kindful integration.
When the campaign class sync is turned off on an account, if a user enters sales receipts into QuickBooks, they'll sync to Kindful under the campaign name "Unassigned".
If you'd like to do this, Please contact support@kindful.com.
Additional resources |
How Transaction Types Map
When data syncs from QuickBooks to Kindful, Kindful currently supports 32 different Payment Methods from QuickBooks. We map QuickBooks "Payment Methods" into Kindful as "Transaction Types". The following Payment Methods are supported:
QuickBooks Payment Method |
Kindful Transaction Type |
cash |
Cash |
ca |
Cash |
check |
Check |
ck |
Check |
cheque |
Check |
check transaction |
Check |
check payment |
Check |
cheque transaction |
Check |
cheque payment |
Check |
paypal |
PayPal |
pp |
PayPal |
pay pal |
PayPal |
visa |
Credit |
mastercard |
Credit |
master card |
Credit |
diners club |
Credit |
american express |
Credit |
discover |
Credit |
mc |
Credit |
squarespace |
Credit |
credit |
Credit |
cc |
Credit |
credit card |
Credit |
wepay |
Credit |
electronic fund transfer |
EFT |
transfer |
EFT |
wire transfer |
EFT |
wt |
EFT |
achdebit |
EFT |
eft |
EFT |
e-check |
EFT |
payroll deduction |
Payroll Deduction |
direct deposit |
Automatic Withdrawal |
shopify |
Shopify |
stock |
Stock |
square |
Square |
If you use one of these Payment Methods in QuickBooks, it will automatically sync to the corresponding Kindful field. If these types are not used, it will sync over as “Cash”.
Once the integration is connected, the payment type mappings cannot be remapped. It is important to ensure that Payment Methods in QuickBooks are set correctly before connecting the integration.
When syncing data from Kindful to QuickBooks, if a corresponding Payment Method does not exist in QuickBooks, Kindful will create one for some of our Transaction Types.
Kindful Transaction Type |
QuickBooks Payment Method |
One Time Transaction |
Credit |
Recurring Transaction |
Credit |
Paypal |
Paypal |
Shopify |
Shopify |
Stock |
Stock |
Square |
Square |
Please note that some Transaction Types are not included on this list. These include:
- Automatic Withdrawal
- Payroll Deduction
- Artwork Purchase
- Auction Payment
- Stock
Of Note: Credit, Cash, and Check can will sync; however, they need to manually be created as payment methods in QuickBooks prior to connecting the integration.
With this set prior to connecting the integration, as long as the Payment Methods in QuickBooks are strictly the word “Credit”, “Cash”, or “Check”, it will sync without needing custom mappings.
Additional Notes about the QBO ongoing sync:
- The sync process runs once an hour.
- After a Customer (Contact) or Sales Receipt (Transaction) record has been synced the first time, updates will automatically be synchronized between systems.
- Classes and Campaigns will be synchronized.
- If you don't have any Classes (Campaigns) in QuickBooks, then we will create a General Class (Campaign) for your Sales Receipts (transactions) because Campaigns are required in Kindful.
- Kindful will never make changes to Income Accounts (Funds) and Items (Designations).
- Income Accounts and Items will need to be maintained in QuickBooks and will always be imported into Kindful as Funds and Designations.
- Kindful doesn't get deleted information from QuickBooks.
- If you delete a Sales Receipt in QuickBooks, you will need to manually delete the associated Transaction in Kindful.
- Some data types are not handled in the integration.
- Important Note: QuickBooks invoices, payments, accounts receivable and deposits are not imported into Kindful. This is because we built our QuickBooks integration according to QuickBooks' best practice recommendation for nonprofits.
Comments