PREPARING YOUR QUICKBOOKS FOR WEBSITE INTEGRATION
Several preliminary things should be done in QuickBooks before you integrate your website:
- It is recommended that you go ahead and set up your products in QuickBooks before starting the integration. If you have too many products, or for whatever reason don’t want to enter your products into QuickBooks first, you can use the connector to pull products into QuickBooks for you. However, you should be aware that QuickBooks will only pull in your product name and SKU. All other information including price, inventory, vendor information and other relevant fields will have to be entered manually.
- Make sure you’ve set up your Chart of Accounts and thoroughly understand how your products should be recorded in QuickBooks. The following is a list of the required type of accounts you will need. If you don’t have at least one account from each category in your QuickBook chart of accounts, you should create one before starting the integration process:
- Income Account
- COGS Account
- Deposit Account
- Asset Account
- Accounts Receivable
- Expense Account
- To successfully post an order, you will need the following items set up in Quickbooks before integration:
- Payment Method
- Sales Tax
- Shipping Item
Now that you’ve set up your QuickBooks Chart of Accounts, entered your products into QuickBooks, and selected your options in QuickBooks for Payments, Sales Tax, and Shipping, you’re ready to install the web connector.
After you activate NP QuickBooks Connector for WooCommerce, go to the QuickBooks SetUp in WooCommerce to create a QuickBooks Web Connector file.
The WebConnector tab will walk you through this process. Just pick a username and password, and enter the url for the site that contains the products you want to integrate with QuickBooks. Then click the button “Create QWC File”, and a QWC File will be created. This needs to be saved on the same computer on which your QuickBooks is installed. Typically you might put it on your desktop for easy access since you will need to access it again when you sync your website to Quickbooks. Next, click the button “Download QuickBooks Web Connector” and follow the instructions to connect Quickbooks to your site.
Below is a screenshot of the QuickBooks Web Connector. You can see the option for Auto-Run is checked and the minutes indicate how often your site will update. For our purposes here, we’ve set the time for 10 minutes on the initial set up so we can test our other settings more easily. But you will want to set your time for much longer than 10 minutes, either now or after you set up, to avoid overwhelming your system (180 minutes would be a normal setting unless your volume is very high).
QuickBooks Setup Tab
Now you have prepared a connection between your site and QuickBooks, but your products are not yet integrated. Before you begin the integration process you’ll need to finish setting up the plugin and choosing your options. So go back to the NP QuickBooks Connector for WooCommerce to the QuickBooks SetUp tab.
Default Account Options
The QuickBooks SetUp tab is where you choose the accounts that will be linked. Check all accounts and click to refresh with the accounts you have made on QuickBooks.
In addition to the 6 required accounts, you also have the option to link accounts for Discount Account and Discount Item. Below is a screenshot of Default Account Options found in the QuickBooks Setup tab.
Order Posting Options
In the same tab, there are various options relating to orders. It is recommended that you come back to the Order Posting Options section after your website integration and syncing is completed. So we’ll scroll down to the next section and come back to this one after we sync the site to QuickBooks.
After the Order Posting Options are the Customer Options. In this section, you can decide whether or not you want to create individual customer accounts in QuickBooks . You also decide how customer names should be created by choosing the fields for the names and the order in which they will appear. The default customer account is also chosen here. Below is a screenshot of the Customer Options in the QuickBooks Setup tab.
Payment Method Mappings
Next on the page is Payment Method Mapping. This is where you match the payment methods installed on your site with the payment methods that you have set up in QuickBooks . Below is a screenshot of the Payment Method Mappings.
Sales Tax Mapping
The sales tax mapping section is where you map the sales tax rates and codes for your site to what you have in QuickBooks . Below is a screenshot of the sales tax mappings.
The Shipping Settings is the final section that needs to be completed before you leave the QuickBooks Setup tab. First you , choose which item to use for shipping charges and the sales tax code. You can decide how you want the shipping options and method to appear on the sales order or sales receipt. Below is a screenshot of the shipping settings .
Note: Make sure to save all changes before you leave the page, then continue on to the next section.
Product Sync Tab
Before a website product can be linked with a QuickBooks item, the website product’s SKU must match the Item Name / Number field for the corresponding product in QuickBooks. If you’re entering the SKUs by hand or individually, make sure that you don’t mistake zeros for the letter ‘O’.
After products are entered in QuickBooks , they can be validated in the Product Validation section . This helps ensure that orders will post successfully. Validation will not update the inventory and pricing on your website. It only updates the internal QuickBooks data used to programmatically interact with QuickBooks .
Before you run Product Validation, if you know that there are products listed on your site that have not yet been added to QuickBooks , you can still bring them in using this process. Just be aware that you will have to manually set the price and inventory. To include all products on your site, before you click Validate All Products, scroll down to the Product Sync Settings (pictured below).
Save your settings, then click the Validate All Products button.
After clicking the Validate All Products button, go to the QuickBooks web connector that you have saved on your desktop or in any easily accessible location. Check the box at your site name, then click Update Selected (pictured below). Once all products are validated, you can add new products at any time by clicking the Add Missing Products to Quick Books button in the Product Validation section.
IMPORTANT NOTE: When you are initially syncing your site to Quickbooks, DO NOT check the Sync Inventory On-Hand from Quickbooks or the Sync Price from Quickbooks options in the Product Sync Settings.
Now you’re ready for the next step.
Product Sync Settings
Once you’ve gone through the process above and initially synced your site to QuickBooks (including product pricing and inventory) you can enable options in the Product Sync Settings including the price and inventory syncing options. The next time the web connector runs, items will be picked up in the inventory Sync routine and depending on the extension’s settings, either the price, quantity or both will be updated on the website with the values from QuickBooks. After the link has been successfully established, whenever the web connector runs, the product’s price and / or stock on the website will be updated with the values from QuickBooks.
Remember to save all changes after making your settings choices.
Sending order’s shouldn’t even be attempted until all of your mappings, accounts and products are setup. The reason is that in order to programmatically create an order in QuickBooks, the extension needs to know specifics about what payment methods, tax rates, accounts and products exist in QuickBooks and how they relate to similar settings in your WooCommerce or Jigoshop website.
After you’ve gotten all of your settings mapped and have verified that all of your products can be found in QuickBooks by matching Item Name / Number with the website SKU for the product, you can enabled the “Post Orders To QuickBooks” option. You should also consider enabling the “Store Order XML”, which will store the XML request to QuickBooks for the order. This is particularly useful for debugging when an order doesn’t go through.
When to send the order to QuickBooks?
To specify when an order should be queued to be transfered to QuickBooks, you can select the status from the “Order Status Trigger to send order to QuickBooks?” dropdown. What this setting does is specify when the order should be queued. By default, you should use “Completed”. This means that an order has theoretically been processed, shipped and you’ve received your money. At this point if you’re using QuickBooks primarily for accounting purposes, this is the time to transfer the order and have it entered into the books.
If you use QuickBooks for order fulfillment, you can try queuing the order at a different status, such as processing. This means, when an order’s status changes to processing, the order will be queued to be transferred to QuickBooks. The order status of processing does not assure that the order has been completed and shipped though and, for some reason you don’t ship the order and cancel or refund it in the website, it would need to be removed from QuickBooks as well.
How Should Orders be Posted To Quickbooks?
QuickBooks Premier and Enterprise users can specify whether the order should be created in QuickBooks as either a Sales Receipt or Sales Order. QuickBooks Pro users need use Sales Receipts only. If you are using sales orders, you can also specify to have an Invoice and Payment auto-created for the Sales Order. This is done at the time that the order is transferred to QuickBooks and is primarily meant for people who set the order status trigger to completed.
Note: When enabled, an Invoice AND Payment are created. It’s not possible to specify one or the other.
Line Item Description for Variations
If you’re not tracking variations of variable products in QuickBooks, when the order’s created in QuickBooks, the parent product is used for the line item. If you’d like the line item description to reflect the value of the variation chosen, you can enable this option: “Should the attribute values for variable products be used as the Sales Receipt / Sales Order line item description?“. When enabled, the line item description will be a combination of the attribute and the chosen value. So if it a large size was selected, the description would be Size:Large
If an order doesn’t go through, it’s likely one of the following is happening:
1. An item on the order can’t be found in QuickBooks
2. The payment method for the order isn’t mapped
3. Sales tax rates are mapped incorrectly
4. There’s no shipping item setup in QuickBooks
Go through all of your settings and make sure that everything’s mapped correctly. You can also look at the History tab in the extension for more details from QuickBooks about why the order didn’t transfer. If there are error’s complaining that the ListID is empty or that a ListID is invalid, that means that your account mappings are out of sync. To resolve, you should refresh your account mappings and re-save.
Charge shipping to customers
You can charge your customers for shipping by creating a shipping charge item and adding it to an invoice or cash sale.
To create a shipping charge item:
- Select the Lists menu and select Item List.
- Click the Items drop-down menu and select New.
- Click the Type drop-down menu and select Other Charge.
- In the Item Name/Number field, enter the item name.
- In the Amount or % field, enter what you charge for shipping (use 0.00 if shipping charges change from one sale to the next.)
- In the Account field, enter the account you will use to track the shipping charge.
- Click OK.
You can now use the new item to enter shipping charges on invoices and cash sales.
Default Account Options
This is the Income Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.
This is the Cost-Of-Goods Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.
This is the deposit account in QuickBooks used for creating sales receipts and payments for sales orders.
This is the asset account in QuickBooks that should be used when new website products are automatically created in QuickBooks.
This is the receivables account in QuickBooks that’s used when creating Invoices. Invoices are only created when the order posting type is set to “Sales Order” and the option to auto create invoices and payments is turned on.
This is the expense account used in QuickBooks when new website products are automatically created in QuickBooks.
Order Posting Options
Post Orders to QuickBooks
Enable this option when you’d like to send orders to QuickBooks. This option should ONLY be enabled once you’re product mappings have been setup. The value in the “Item Name / Number” field in QuickBooks should match the value for the “SKU” field in the corresponding website product.
Store Order XML?
If you’re just setting up your integration, it’s probably best to enable this option. When enabled, the actual request that goes to QuickBooks to create the order will be stored with the order. This will help debug if for some reason the order doesn’t transfer properly or at all.
Should the attribute values for variable products be used as the Sales Receipt / Sales Order line item description?
When checked. the “Attribute Value” for variations will be used as the Line Item Description for the variation on Sales Receipts and/or Sales Orders. This is particularly useful if there’s no need to keep track of variations in QB. For instrance, if you sold t-shirts (item name in QB: t-shirt) in red, yellow and blue, but didn’t want to keep track of each variation in QuickBooks, if this options were enabled, when the sales receipt / sales order was created, the line item would look like this:
Name : t-shirt
Not having this option selected, would just leave the standard description of the parent item t-shirt as the line item description
Auto-create Invoices and Payments
This option is only applicable when the order posting type is Sales Order. When enabled, a new invoice AND payment will created to close out the sales order. This option does not do anything when the order posting type is Sales Receipt as sales receipts are self-closing.
Order Status Trigger to send order to QuickBooks?
You can choose to send the order to QuickBooks when the order status reaches either “Pending”, “Processing” or “Completed”. Please remember that all orders MUST hit whatever status you choose. For instance if you choose “Pending’, but your orders go straight to “Processing”, the orders will never be queued to go to QuickBooks.
Add prefixes to your sales receipts, sales orders, invoices and paymnets
These are prefixes that you can use to identify website orders.
Create Individual Customer Accounts in Quickbooks
When enabled, each website customer will be created in QuickBooks if they don’t already exist. Each order for that customer on the website will then be placed under that customer in QuickBooks, to determine if the customer already exists in QuickBooks, the format laid out in the “How Should Customer Names be created in QuickBooks” field is used to query QuickBooks
How Should Customer Names be created in QuickBooks
This is the format that customer names are created and queried in QuickBooks
Default Customer Account
This is a default, catch-all customer account. This option is only used if the “Create Individual Customer Account in QuickBooks” is disabled. Otherwise, this customer account is ignored.
Payment Method Mappings
Map Your WooCommerce Payment Methods to Your QuickBooks Payment Methods
These are the mappings for your QuickBooks to WooCommerce payment methods. These mappings tells QuickBooks what the payment method on the website equals in QuickBooks. So if you have “Paypal” as a website payment method and wanted that to go under “Credit Card” in QuickBooks, you’d map PayPal to Credit Card in this section.
Sales Tax Mappings
QuickBooks Sales Tax Vendor
This is the name of the Sales Tax Vendor exactly as it appears in QuickBooks. This is who you pay your sales tax to.
Default No Tax Account
The default “no tax” account is the sales tax item in QuickBooks that has a zero percent sales tax rate. This is used to create orders where no tax was collected.
Map Your WooCommerce Sales Tax Codes to Your QuickBooks Sales Tax Codes
Each sales tax code on the website must correspond to a sales tax code in QuickBooks.
Map Your Local WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.
Each “local” sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have “local” sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.
Map Your WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.
Each sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.
In order to transfer the shipping charges to your customers correctly as line items on the sales receipt / sales order, you need to have a “shipping item” setup in QuickBooks. If you’re unfamiliar with how this should look, here’s a link from Intuit on how to set this up:
Product Sync Settings
Sync Inventory On-Hand from QuickBooks
If checked, the on-hand quantity in the website will be updated with the on-hand quantity count from QuickBooks. Note: Stock management must be enabled on the website in order for this to have any effect.
Sync Price from QuickBooks
If checked, the price on the website will be updated with the price in QuickBooks.
Do you keep track of parent products for variations in QuickBooks?
If you don’t need to keep track of parent products of variable products, leave this item unchecked.
Do you keep track of variantions for variable products in QuickBooks?
If you don’t keep track of variations of variable products, you should leave this option unchecked. If you do track variations separately in QuickBooks, this item should be checked.
Unique Product Identifer Mapping for Quickbooks
You can choose to use either sku or product id. Sku is the recommended option and product id will be deprecated in future releases. You should use sku.
Change WooCommerce stock status when QuickBooks quantity goes above or below zero?
If this is enabled, then the extension will change the a product’s stock status to “In Stock” and “Out of Stock” and the quantity is greater then or less than zero. This options should only be used if your QuickBooks items are “Inventory” items.
Auto-create website products in QuickBooks if they can’t be found?
If this option is enabled, products that can’t be found in QuickBooks based on the website’s sku field, will be automatically created. This option is still in beta and should be used to “setup” your QuickBooks inventory. Auto-created options will still require a certain level of intervention from your end. You will still need to enter costs, manufacturers, etc. If you’d like to use this feature, make sure that either “Sync Price from QuickBooks”, “Sync Inventory On-Hand from QuickBooks” or both are enabled.
Are Variations Subitems of the Parent product in QB?
If you’re keeping track of variations in as separate items in QuickBooks, enabling this options means that the variations that you’ve setup in QuickBooks are sub items of the parent product in QuickBooks.
Default QuickBooks Item Type for auto-created products?
If you have “Auto-create website products in QuickBooks if they can’t be found?” enabled, this is the QuickBooks Item Type that they will be auto-created as. Current supported item types are “Inventory”, “Non-Inventory” and “Service”.
How Often Should the Inventory Sync run?
This is the time (in minutes) between inventory syncing. Setting this to a time other than what’s in the web connector auto-run interval, is particularly useful if your QuickBooks catalog has a lot of items. For instance, let’s say you want the web connector to run every 5 minutes to check for new orders, but sync inventory only needs to happen every 60 minutes. You can set the web connector auto-run interval to 5 min and then set this value to 60.
Common Errors & Fixes
QuickBooks 1012 Authentication Failed
After initiating Intuit’s Web Connector, the sync fails and your receive the error message QBWC102 Authentication Failed. When clicking the “Click for more information” in Intuit’s web connector, a dialog box appear on your desktop with the following information. :
Message: Authentication failed
Description: QBWC1012: Authentication failed due to the following error message. The remote name could not be resolved: ‘your domain.com’ See QWCLog for more details. Remember to turn logging on.
Why You’re receiving this message:
A DNS error on your PC is preventing Intuit’s Web Connector from connecting to your website.
How to correct this error:
You can correct this issue by rebooting the computer that is running Intuit’s Web Connector. This will clear the DNS error and allow Web Connector to connect to your website.
Common Problems & Fixes
QuickBooks 3140 Transaction Sales Tax is currently disabled by preferences.
If you receive the following message when trying to create a sales order / sales receipt in QB, then you have sales tax disabled in your company settings:
3140: There is an invalid reference to QuickBooks ItemSalesTax “No Sales Tax – Website” in the SalesReceipt. QuickBooks error message: Transaction Sales Tax is currently disabled by preferences
To correct this message, you’ll need to enable sales tax at the company level by following these steps.
- Open QuickBooks with the correct company file
- Click the Edit menu then Preferences
- From the left vertical tool bar, select Sales Tax
- Click the Company Preferences tab
- Select Yes in the ‘Do you charge sales tax’ field. (This is a temporary change)
- Make sure there is a ‘Most common sales tax’ entry
- Click OK.
- Uncheck both boxes in the ‘Update Sales Tax’ dialog box then click OK.
- You may need to click OK to a confirmation about closing windows.
QuickBooks 3270 Missing posting account
QuickBooks error code 3270: Missing posting account pertains to trying to create a sales order in a version of QuickBooks that doesn’t allow sales order creation. All versions of QuickBooks will let you view sales orders, but only certain versions of QuickBooks lets you create new sales orders.
If you’re using QuickBooks Pro, you will receive that message when trying to send website orders to QuickBooks as Sales Orders. You’ll need to change the order posting type to Sales Receipts.
Warning: mcrypt_encrypt(): Key of size 10 not supported by this algorithm.
If you receive the following warning while trying to generate a qwc file on your site, take the steps listed below to correct the issue:
Warning: mcrypt_encrypt(): Key of size 10 not supported by this algorithm.
- Install the latest version of the plugin
- Once the latest version of the WooCommerce QuickBooks Integration has been installed, click the Reset QWC Users button
- Re-enter the username, password and ssl path
- Click the Generate QWC File button
- Remove the old QWC file from Intuit’s webconnector
- Add the new QWC file from Intuit’s webconnector
After you do those steps, you shouldn’t have to take any further action.