Connecting QuickBooks Online: Getting Started

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

QuickBooks Online FAQs


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

Screen_Shot_2019-03-06_at_9.06.17_AM.png

 Next, click Connect and then Connect again.

Screen_Shot_2018-06-07_at_9.35.38_AM.png

Screen_Shot_2019-03-06_at_9.07.32_AM.png 


QuickBooks Online’s login page will appear in a new window. Sign in with your credentials.

Screen_Shot_2019-03-06_at_9.09.38_AM.png


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.

Screen_Shot_2019-03-06_at_9.15.33_AM.png


Syncing QuickBooks

QuickBooks will not begin syncing until you configure the settings for the integration; choose Sync Data with QuickBooks.

Screen_Shot_2019-03-06_at_9.15.33_AM.png

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.”

Screen_Shot_2021-01-19_at_10.23.09_AM.png

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”.

kindful-sync-statuses.png

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.

Screen_Shot_2021-01-19_at_10.12.48_AM.png

Screen_Shot_2021-01-19_at_10.12.57_AM.pngScreen_Shot_2021-01-19_at_10.13.03_AM.pngScreen_Shot_2021-01-19_at_10.13.40_AM.png

We also display the last sync date and time, and you can use this reference any potential data questions.

Screen_Shot_2021-01-19_at_10.14.43_AM.png


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.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments