Follow

QuickBooks Integration Processing Details

Created:   |   Updated:

This article is a duplicate of https://support.shippingeasy.com/hc/en-us/articles/204574325

IMPORTANT: There are several different options for mapping data from ShippingEasy to QuickBooks.  Before using the ShippingEasy integration with QuickBooks, back up your QuickBooks company file.

This article provides more detailed information about the processing described in Syncing Data from ShippingEasy to QuickBooks.

Customer Searching and Creation
The integration relies on using a customer email address to find customers in QuickBooks. Upon receiving orders from ShippingEasy, the first email address used is the billing email address. If this is blank, the email address from the recipient will be used. First, QuickBooks is searched for this customer email address. If the customer is found, then the reference to that QuickBooks customer entity is used by the integration for any QuickBooks transactions it may create. If the customer is not found by email, and the integration is configured to automatically create customers, the customer will be created.

If the customer cannot be found or created, the order will be skipped.

Customer Creation and Taxes
When the integration creates customers automatically, it will attempt to setup the QuickBooks tax code and tax item, if you have configured the integration to handle taxes and an appropriate tax mapping can be found. The integration uses the ShippingEasy billing address for the tax mapping. In the event that a blank billing address is found, the integration will use shipping address as a fallback.

If a mapping is found for the state, then the corresponding tax item will be linked to the customer account during creation using the taxable code that was configured. If no mapping is found for the state, then the customer is created using whatever nontaxable code was configured.

If the integration is not configured to handle taxes, then no tax information will be sent to QuickBooks during customer creation, and the customer will be created using whatever defaults you have configured in QuickBooks.

Item Searching and Creation
The integration uses the item SKU to uniquely identify items in QuickBooks. When processing ShippingEasy orders, if any of the line items do not contain SKUs, the order will be skipped. If all line items contain SKUs, then the integration searches QuickBooks for each item. The search is done of both top level items and subitems in QuickBooks. Note that if there are duplicate items within QuickBooks, the integration will use the first item returned by the search of QuickBooks. If an item is not found, then it will be created using the income, cost-of-goods, and asset accounts specified.

Once created or found, the integration uses the QuickBooks list id for that entity for subsequent transactions it creates. If the item cannot be created or found, the order is skipped.

Transaction Creation and Taxes
The customer and item entities mentioned above are prerequisites for the integration’s real work – creating transactions in QuickBooks for ShippingEasy orders. When the customer is created, it is also assigned a tax code and a tax item as outlined above. When the integration inserts transactions into QuickBooks, the taxability of the transaction is determined based on the customer.

In other words – a sales receipt linked to a customer assigned a taxable tax code will be treated by QuickBooks as taxable, and the line items contained on the receipt will be taxed using the rate defined by the tax item for the customer. If the customer was assigned a nontaxable code, then the receipt/order/invoice would be non-taxable as well.

Cost and Charge Taxes
The integration can be configured to move the shipping, wrapping, and handling cost from ShippingEasy into QuickBooks. Each of these charges is entered using the QuickBooks item that was configured for that field. To determine whether or not the line item is marked as taxable/non-taxable, the following formula is used.

Check the cost "tax field" from ShippingEasy (for each of: shipping, wrapping, handling).

If the value of the "tax field" is greater than zero, the item will be entered into QuickBooks as a taxable item using the value from the corresponding ShippingEasy field that does not include tax. This is because QuickBooks requires values to be entered without tax included.

If the value is "tax field" is zero, then the item will be entered into QuickBooks as a non-taxable item, using the value from the corresponding ShippingEasy base cost field.

Comments

Please sign in to leave a comment.

Community browse

COMMUNITY FORUMS

Questions & Answers

Issues & Bugs

Beta Feedback

FEATURE REQUESTS

Productivity: Features, Interface & Settings

Partners: Integrations, Carriers & Stores

Shipping: Orders, Labels & Shipments

Inventory: Products, Purchase Orders & Suppliers