QUICKBOOKS DESKTOP INTEGRATION VIA WEB CONNECTOR
This guide outlines the process for integrating your Craftable store with QuickBooks Desktop (QBD) using the QuickBooks Web Connector.
What is Required:
- A QuickBooks Desktop admin account
- QuickBooks Desktop must be in Single User Mode
- The QuickBooks Web Connector installed on the QuickBooks machine (see the article titled Downloading QuickBooks Web Connector if you have not done this previously)
- An account with access to Books
Integration Setup:
- Open QBD and access the company file that should be connected to your Craftable store.
- Log in to your Books account and click on Bills & Credits > Bills/Credits Sync
- Click Download Configuration File.
.png?width=629&height=210&name=image%20(54).png)
- Locate the downloaded file and open it. The file extension will have ".qwc"
- Click "OK" to Authorize New Web Service for "Bevager"
.png?width=347&height=353&name=image%20(52).png)
- You will be prompted to confirm authorization again with four different
options of permission. For the sync to work correctly, select “Yes, always allow access, even if QuickBooks is not running” then click "Continue" - In the Web Connector, you will see the application that we just allowed in the previous step. To begin pulling your Accounts and Vendors into Craftable, tick the application within the Web Connector. **Do not enable Auto-Run**
- After, you will be prompted to enter a password. The password is the Craftable password of the user who downloaded the Configuration File in Step 3. Make sure to save the password when prompted.
- At the top of the Web Connector, click Update Selected - this will initiate the sync between Craftable and QBD.
Important: Before syncing, always verify two things:
- You are operating in Single User Mode within QuickBooks Desktop.
- You have the correct Company File open for the application you have ticked in the Web Connector. This ensures the data we are pulling from QBD maps to the right Craftable store.
Troubleshooting:
- If you receive the error that states "Error QBWC1039: There was a problem adding the application. Check the QBWCLog.txt for details.", please see the article titled Resolving "Error QBWC1039"
Books Setup:
- The integration will have brought in your Chart of Accounts and Payee Codes, to complete your setup of Books you still need to complete some setup. Watch the Books Training Video below for a quick 10-minute walkthrough of how to do this.
The steps outlined in the training video include:
- Entering Payees against Your Vendors
- Mapping General Ledger (GL) Accounts
Using the Web Connector:
- Once a Bill is Approved it will show up in the “Bills/Credits Sync” menu from
the “Bills & Credits” tab on the navigation menu. - Open QuickBooks Desktop and Web Connector if they are not already open.
- IMPORTANT: Ensure you do not have any other company files open, and do not click the Download Configuration File button again - this is only needed during the initial integration.
- In the QuickBooks Web Connector, click the checkbox next to the company you would like to upload the Bill(s) to
- Click the Update Selected button