20b. QuickBooks Integration – Pulling [9:59]

Description: This video provides an overview of how to pull lists, items, contacts, invoices, and payments from Intuit® QuickBooks into the Core4 CRM.

Let’s take a closer look at Intuit QuickBooks Integration in the Core4. In this video we’ll review how to pull records from QuickBooks into the Core. QuickBooks integration requires purchasing, installing, and registering the FM Books Connector plug-in. As a general rule when you first set up the Core4 you’ll want to pull all of your existing QuickBooks data into the Core. This can be accomplished by navigating to Core > Preferences > Global Settings > Plug-ins > FM Books Connector tab.

0:55 Select this button to open the QuickBooks Import Wizard. Here it’s crucial to import from top to bottom. So you should complete part 1 before you move to part 2 and so forth. First we can import List Items from QuickBooks. Please note that whenever you import data from QuickBooks only the active items will be imported. Let’s start with Accounts. 114 accounts were successfully imported from QuickBooks. Then let’s import Payment Methods. 8 payment methods were imported. Next is Payment Terms. 6 payment terms were successfully imported. Then Shipping Methods. 5 shipping methods were pulled in. Next we have Customer Messages. 8 customer messages were brought in. Then we have Items. 47 items were successfully imported. Then we have Taxes and Classes. Let’s go ahead and close the Import Wizard.

2:52 If we navigate to the Lists tab we can see the records that were just imported from QuickBooks. All active Accounts, Payment Methods, Terms, Shipping Methods, Customer Messages, Taxes, and Classes have been brought in. If the “Exists in QB” box is checked, then it indicates that the item does exist in QuickBooks. You could even assign a Default. Here you could add new Classes with this button. However, keep in mind that they will not exist in QuickBooks. If you would like new classes added in the Core to exist in QuickBooks, then you must manually add them in QuickBooks and then re-import them into the Core. Lists should be managed and maintained in QuickBooks, and then pulled into the Core4 as they change.

4:05 Let’s navigate to the Items tab. I’ll scroll to the last couple items in the set. Here we can see the items that have been pulled in from QuickBooks. On the More Info tab we can see all of the QuickBooks related information has been populated. This checkbox indicates that the item needs to be refreshed in QuickBooks if any information was updated.

4:45 Moving forward through the Import Wizard, next we have Contacts. Before we import customers from QuickBooks, make sure you specify on the FM Books Connector tab whether you’d like to create both Company and Individual records for the Customer import. When this checkbox is not marked then only one record is created for every one record from QuickBooks. I’ll go ahead and leave the box unchecked. Now let’s import the active Customers from QuickBooks. The Customer import from QuickBooks to FileMaker is intended to be a one time setup feature. Re-importing customers will ignore customers that have already been added to the Core, and it will only import new customers. Any customer edits or modifications should be managed in the Core4.

5:47 Let’s navigate to the Contacts tab for a moment. For this record, “QuickBooks Import” with a date/time stamp is populated in the Source field. I’ll perform a find for all contacts imported from QuickBooks. I have 64 contact records in the found set that were imported from QuickBooks.

6:34 Next on the Import Wizard we have Sales Reps. When a Sales Rep is imported from QuickBooks a new contact record is created in the Core4. Let’s perform a find for any QuickBooks import that is a Sales Rep. 2 records are in the found set. The Sales Rep checkbox is marked and the QB Initials are populated.

7:26 Next let’s Import Invoices. We’ll have additional filter options such as Beginning & Ending Invoice numbers, or the date range. I’ll leave the filters blank and import every active invoice. Subsequent pulls will refresh matching Core4 records with invoices in QuickBooks. New invoices will also be imported. However, invoices that don’t have a matching customer in the Core will not be imported. Kits or grouped invoice line items in QuickBooks also will not be imported.

8:10 Lastly let’s import Payments. The date range filter is also available for Payments. I’ll go ahead and pull in all of active Payments. Payments that don’t have a matching customer and invoice in the Core will not be imported. 106 payments were brought in. Let’s navigate to the Invoices tab. I’ll perform a find for records that have a QB Invoice #. 113 records were found. These invoices have been imported from QuickBooks, and have a List ID as well as a QB Invoice #. This checkbox indicates that the invoice needs to be refreshed in QuickBooks if any information was updated in the Core.

9:20 This is just a brief overview of the many features and possibilities of the Core4. For more information on what the Core can do for you please visit http://www.Core4CRM.com, review the videos and documentation, and try a demo. Please contact us via email, phone, or browse our forum if you have any additional questions.

Contact Us:
Email: support@productivecomputing.com
Phone: (760) 510-1200
Forum: http://www.productivecomputing.com/forum