QuickBooks Desktop Integration
Learn how to connect Clixon to your
QuickBooks Desktop application to easily "Export" Reconciled Orders (Invoices) from Clixon into your QuickBooks application.
Each order in Clixon can be exported over to your QuickBooks account and set up as an invoice with every product line item listed (including Tax and Shipping if populated).
We allow you to set up your Ledger Accounts, Classes
(Cost Centers in Clixon),
with Sub Accounts for both if needed, and to assign them to each individual Product that you have in your Clixon catalog. You will also need to make sure the spelling of your Vendor Names and Vendor Terms all match between Clixon and QuickBooks. You can also assign a default Ledger Account and/or Cost Center for the Tax and Shipping if needed. Everything you need to know about this is covered in the following help article:
Getting started
- If you are a group and wish to Export Orders from every office from one place, the Corporate level is where you want be to being the process.
- If you are a 'Stand A Lone' office, or if you need to Export each office individually to different QuickBooks accounts/applications then you will go to each office or location in Clixon individually and set up each one individually.
Step 1: Select QuickBooks Desktop as your Accounting Software & enter a Password
- From the Corporate level in Clixon choose Setting (the sprocket or gear icon in the upper right corner of the application)
- Select Corporate Profile from the Setup Information page.
- Select Settings tab from the Corporate Profile page.
- Now scroll down to the Accounting Integration section.
- From the Accounting Integration section:
- Select Quickbooks Desktop from the Accounting Software field drop down menu.
- Then enter a Password in the corresponding field.
- The same Password will also be used in the Password field within the QuickBooks Web Connector.
- Click the Save button
Step 2: Download QWC File
- From the same page look for the QuickBooks Web Connector field
- You can skip "Step 1. Permorm Setup - Download and install the QuickBooks Connector", if you would like, as your QuickBooks desktop application now already has the QB's Web Connector built in.
- To find the QB's Web Connector in QuickBooks:
- Choose File
- App Management
- Select Update Web Services
- Select the link "Step 2. Download the .qwc file required to complete Setup."
- This will ask you to Save the file to your computer, most likely the Downloads folder.
Step 3: Open QuickBooks and Add Application (QWC File) to the QuickBooks Web Connector
- Make sure to Sign into QuickBooks as the Administrator and in Single User mode.
- From QuickBooks choose the File menu in the top left of the application.
- Select App Management from the File menu.
- Then choose Update Web Services.
- Select the Add an Application button from the QuickBooks Web Connector window that just opened.
- Now locate and select the QWC file you downloaded from Clixon, most likely in your Downloads folder.
- Once you locate the QWC file select Open.
- From the Authorize New Web Service window that opens click the OK button.
- The QuickBooks - Application Certificate window will now open.
- Select - Yes, whenever this QuickBooks company file is open
- Then click the Continue button.
- Now the Access Confirmation window will open.
- Click the Done button.
The
QuickBooks Web Connector will now open and you will see that your new application has been added.
Step 4: Finish QuickBooks Web Connector setup
- From the QuickBooks Web Connecter
- Check the Box on the far left for the Application (QWC file) you just added.
- The Password Required window will pop up.
- Enter the same Password you entered back in Clixon in the Accounting Integration section.
- It will ask if you want to Save the Password, select the Yes button.
- Now click the Updated Selected button to run the Web Connector.
- Once the Update session finishes running successfully without any errors you are done with the Integration process.
- You can now Exit the Web Connector.
Trouble Shooting - QB's Web Connector Setup Errors
- Sometimes users will see a QBWebConnector - Error, specifically a QBWC1039 Error.
- If this occurs just click this link below and follow the steps to fix the issue.
- https://quickbooks.intuit.com/learn-support/en-us/your-books-or-my-company/fix-error-qbwc1039/00/294400
- You will notice there are multiple QBWC1039 errors, so just look for the exact error message you are seeing
- The most common one we see is: QBWC1039: Unique OwnerID/FileID pair value required
- Make sure you are Signed into QuickBooks as an Administrator.
- If you see 'Invalid Password' after clicking the Update Selected button
- First re-enter the Password for the application and then Save.
- If that still does not work, you may need to try re-entering the Password back in Clixon.
- Again this is found in either the Setting > Company or Corporate Profile page > Setting tab > Accounting Integration section.
Review QuickBooks and Export to Accounting page in Clixon
After you run the QB Web Connector (Update Selected process) from the Web Connector to import Orders from Clixon into QuickBooks:
- You will want to check your QuickBooks account to make sure that everything was added properly.
- Clixon also has an Errored tab or page back on the Export to Accounting page in Clixon.
- Simply go into Clixon and select Export to Accounting from the left menu.
- If any Orders (bills) did not Export over they will be found on the Errored tab.
- Each order will have an Error message explaining why the Order did not import into your QuickBooks.
- Correct the issue and then Re-Queue the Order(s) & then run the Web Connector again.
Related Articles
Company Profile
The Company Profile and Corporate Profile pages contain the basic information of each company or group. Locate these pages from the Company or Corporate levels by going to: To locate the Company Profile page go to: Setup Information > Company > ...
Opticon 2004 - Batch Scanner Information & Setup Guide
Setup for Opticon 2004 - Batch Scanner Please check out the Opticon 2004 Knowledge Base article - Opticon 2004 - Information and Setup Guide - for all product information. Initial Setup for a PC You will only need to do this part once per computer. ...
Motorola CS3000 series - Batch Scanner Information & Setup Guide
Setup for Motorola CS3000 / CS3070 Batch Scanner Clixon only supports the Motorola CS3000 Batch Scanner series of scanners. Access the CS3070 Batch Scanner - Product Reference Guide for setup & trouble shooting. Setting up your Date and Time is not ...
Mobile Device Scanning
Use any mobile device to scan product barcode labels printed from Clixon The following options are available after scanning a product label, printed from Clixon, with your mobile device: Issue from Stock Inventory Count Edit Product Getting Started ...
Vendors Overview
Vendors are required and are associated with each Product you buy, and therefor each product you add to your Clixon product Catalog(s). Again, vendors are who you buy products from and submit order to when using Clixon. We offer a small list of ...