Follow

QBD: How the Sync Works with QuickBooks Desktop

The purpose of this article is to describe very simply how InvoiceASAP syncs to QuickBooks Desktop.

 

Initial One-Way or Two-way Sync

The one-way initial sync pulls the following from QuickBooks into InvoiceASAP:

  • Customer List

  • Products & Services (Item List)

  • Tax Rates

The two-way initial sync pulls the following from QuickBooks into InvoiceASAP: 

  • Invoice History

  • Customer List

  • Products & Services (Item List)

  • Tax Rates

  • Payments from QuickBooks (optional)

These items are not pulled with the two-way sync:

  • Historical estimates from QuickBooks into InvoiceASAP

  • Classes

The sync from InvoiceASAP to QuickBooks sends the following information:

  • Invoices & Estimates

  • Payments (optional)

  • If a new customer is created in InvoiceASAP AND it's assigned to an estimate or invoices, it will be created in QuickBooks

  • If a new item is created in InvoiceASAP AND it's assigned to an estimate or invoices, you will see a pop-up to allow you to define the item type and GL account info, then it is created in QBD.

 

Click here for instructions on how to turn on/off Auto-Sync

 

Subsequent Syncs

Once you create estimates & invoices in InvoiceASAP, the sync transfers this data:

 - New estimates & invoices from InvoiceASAP into QuickBooks.

 - Updated estimates & invoices from InvoiceASAP into QuickBooks (based on Sync Preferences, discussed below).

 - Payments to invoices from InvoiceASAP into QuickBooks (based on Sync Preferences, discussed below).

 - Payments to invoice from Quickbooks into InvoiceASAP (based on Sync Preferences, discussed below).

 - New customers created in InvoiceASAP if the customer is attached to an estimate or invoice.

 - New items created in InvoiceASAP if the item is attached to an estimate or invoice.

 - Items updated in InvoiceASAP are NEVER updated in your QuickBooks.  QuickBooks is the "book of record" for items.

 - Updated customers from QuickBooks to InvoiceASAP (always).

 - Updated items from QuickBooks to InvoiceASAP (always).

 - Updated customers from InvoiceASAP to QuickBooks (based on Sync Preferences, discussed below).

 - New Tax Rates from InvoiceASAP to QuickBooks, if we cannot find a matching tax rate or tax group.

 

Sales Reps

InvoiceASAP does not have a separate field for Sales Rep Initials. 

Rather, we take the first initial of the first name and the first initial of the last name to create the Sales Rep Initials.

These initials must match the initials that you have setup in your QuickBooks (under Lists > Customer & Vendor Profile Lists > Sales Rep List)

 

Invoice Classes

Invoice Classes are not synced from QuickBooks to InvoiceASAP or vice versa.

Classes must be created in InvoiceASAP to match the Class Name that you use in your QuickBooks.

To create Classes in InvoiceASAP:

 - Login to our Manage Account Website (http://invoiceasap.com > Login)

 - Click on Settings in the upper right corner

 - Click on the Invoice Classification button

 

Sync Preferences

InvoiceASAP offers several sync preferences, also under Settings on our Manage Account Dashboard.

These are all Yes/No options:

 - Sync Payments to QuickBooks (this is self-explanatory)

 - Sync Payments from QuickBooks (also self-explanatory)

 - Sync Customer Info to QuickBooks.  Select Yes if you want updates made to your customer records in InvoiceASAP to update your customer record in QuickBooks.  Select No if you do not want InvoiceASAP customer updates to sync into your QuickBooks.  Please note that if you create a new customer in InvoiceASAP and assign that customer to an estimate or invoice, the sync will always create a new record in your QuickBooks.  This option refers to any subsequent updates.

 - Sync Customer Name as First Last.  When you create a customer in InvoiceASAP and it syncs to QuickBooks, do you want the customer name to appear as First Name Last Name?  If so, leave this as Yes.  If you want the customer name in your QuickBooks to appear as Last Name, First Name then set this to No.

 - Sync Sales Rep.  Set this to Yes if you want to sync Sales Reps from InvoiceASAP to QuickBooks.  Please note the comment about Sales Rep initials above.

 - Sync Updated Invoices to QuickBooks.  If you want any updates to estimates and invoices to sync from InvoiceASAP to QuickBooks, leave this as Yes.  If you only want InvoiceASAP to create the invoice the first time it syncs, then to not update it after that, then set this option to no.

 

Here are some other useful links:

Download and Install the InvoiceASAP Connector for QuickBooks

How to Connect to QuickBooks Desktop and Sync

 

If you have any questions, please log in to our Manage Account Website (http://invoiceasap.com > Login), then click on Support in the upper right corner.

 

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk