QuickBooks Desktop Complete Guide
Table of Contents
- Get Connected - actually link up the integration
- Explanation of COGS (Cost of Goods Sold) Tracking
- Converting from QuickBooks Online to QuickBooks Desktop
- General Troubleshooting
Recap of What is Supported
|Sends Customer records to QB when an invoice was updated||Yes|
|Sends Customer records to QB when a customer is updated||No|
|Sends Invoice records to QB when an invoice was updated||Yes|
|Sends Payment records to QB when a payment is made||Yes|
|Sends Purchase Orders to QB||No|
|Sends Products to QB (as items) when a product is updated||No|
|Live Updates - updates are sent immediately||No*|
|Able to send your entire Customer list to QB at initial setup||Yes|
|Able to import your customers from QB at initial setup||Yes|
|Invoices with $0 totals sync||Yes ***|
|Tax Groups support for complex tax configurations||No|
|Overpayments (a payment that is made for
more than the invoice)
|Split Payments (multiple payments to complete an invoice)||Yes|
|One-Time export all Customers to QB||Yes|
|One-Time export all Products to QB||Yes|
|Void/Delete in QB for Invoices when deleted in SYN||Yes|
|Automatically syncs your customer databases both ways
QB <-> SYN
|Imports payments made on the QB side||No|
|Works with Intuit Merchant Services||No|
|Refund Invoices sync||No|
|* They sync when you run the QBWC tool on your desktop|
|** They map as real customer in the software, not sub customers|
|*** They sync after they are marked paid|
What is Not Supported
The Quickbooks integration does not support use of "Discount" type items in inventory due to Intuit's irregular treatment of these items in their integration.
Products do not sync automatically between the apps. You will need to push to sync from QB to Syncro, or create the item on both sides, and map them together on the product in Syncro.
Please note that for Quickbooks Desktop invoices with the following will not sync:
1. Invoice with $0 (e.g. empty invoices, and invoices where the line item is discounted 100 %)
2. Refund invoices, or other invoices where the balance is a negative amount
3. Split payments (i.e. one large payment split among several invoices)
|Desktop Edition Support (Windows Only)||Supported|
|QuickBooks Enterprise Solutions||Yes|
|QuickBooks Premier (2002 or later)||Yes|
|QuickBooks Pro (2002 or later)||Yes|
|QuickBooks Simple Start (2006 or later)||Yes|
|Canadian editions of QuickBooks Pro, Premier or Enterprise
(2003 or later)
|UK and Australia editions of QuickBooks Pro or Accountant Edition
(2003 or later, TAX NOT SUPPORTED)
|Yes, NO TAX|
|Canadian Accountant’s Edition of Quickbooks Desktop||NO|
It is best to start this process from the Syncro wizard located within Admin > App Center > QuickBooks > QuickBooks desktop set up
Quickbooks Desktop uses the Quickbooks Web Connector (QBWC) to connect to us. The QBWC runs only on Windows machines. Mac is not supported at this time due to an Intuit limitation.
Please let us know if you have a Canadian version of QuickBooks Desktop so that we can make appropriate internal adjustments for tax rates.
1. Start up the wizard and it'll tell you if you are ready to go
1B. Now you can probably just click "Configuration" to grab the .qbwc file that will setup the link between your QuickBooks company file and the program. Save it, and double-click it to run it. You'll need to copy the password we provide into your QuickBooks Web Connector to the password area shown in the next screenshot.
2. Now it's going to want to do an "Initial Import" - this won't add anything to your QuickBooks file, it just grabs the chart of accounts and such so we can do the mapping in the application. This is safe to do.
Click the select all and "Update Selected" to make it run right away so you can go to the next step
3. Step 3 is just warning you that if you move the company file you have to contact support, and confirming which company file you have connected to.
4. Here you need to "map" your tax rates to QuickBooks "ItemTaxCodes". Map them all to continue.
5. Now setup your "fallback product" that we'll use when you sync an invoice that doesn't have mapped products. This is sort of a safety net to get things to sync if you use a manual item somewhere randomly in your account.
6. Specify the deposit account, 99.99% of the time it's "Undeposited Funds"
7. Map your payment methods to some payment methods in QuickBooks. Payments will not sync if these aren't mapped.
8. Almost there! If you want all your QuickBooks Customers to be brought into your account, you can do that here. Once you click Import an "import job" will be queued up, the next time the QuickBooks WebConnector runs it will do that import job. It can take a couple hours to do a few thousand customers.
9. Same thing for Vendors...
10. Done! Now you can choose to have sync enabled or disabled. If it's disabled, the integration is turned off. If you enable it, Invoices will begin syncing after they are modified (in the future) - we don't sync historical.
How to map Tax Rates to QuickBooks Desktop?
The software can map to three different types of QuickBooks Desktop entities, depending on how it is used.
An ItemSalesTax, which can apply to a full Invoice.
An ItemSalesTaxGroup, which can apply to a full Invoice, but not individual Lines.
A SalesTaxCode, which can only apply to individual Lines on an Invoice.
E.g. If you get this error:
This TaxRate is mapped to a SalesTaxCode but used on customers
It means that you are using a Tax rate that is mapped to a "SalesTaxCode" on a customer, which gets used on a full invoice. A SalesTaxCode can only be applied to individual line items or the tax rate field within the product detail page.
COGS (Cost of Goods Sold) Tracking Explanation
2. Go to /quickbooks/settings in the program
NOTE ABOUT ITEM/PRODUCT IMPORTS:
The Product/Item imports includes "Service, Non-Inventory Part, and Inventory Part” and excludes "Other Charge, Group, Subtotal, Discount, Payment, Sales Tax and Sales Tax Group" and requires a Name and Description for all items being imported.
5. The invoice will sync to QBD
10. Your Profit and Loss Report will look something like this:
For this to work, you'll need a Quickbooks Desktop Pro account.
Converting from QuickBooks Online to QuickBooks Desktop
You should use Intuit's method of going from QBO -> QBD, which is to use the 'Export data' and must be done in IE 8 or above. A google search will reveal multiple tutorials and screencasts on all the steps involved. Here is a screenshot of where to start in Quickbooks Online:
2. Disconnect Quickbooks Online in your account settings.
3. We'll do some backend changes on our end (please contact us at email@example.com).
4. Go through the standard Quickbooks Desktop integration steps.
Software resource/entity sync
If an Invoice/payment fails, you should see a red error appear on the Invoice or payment page with a message. This will often describe the error and give you first steps on what to look for. We have a glossary of Quickbooks API errors here.
If you have a failed sync, you'll find a Re-Sync to Quickbooks button. Use this button and wait a minute to see if the Invoice/payment goes through.
QuickBooks Web Connector
Intuit's QuickBooks Web Connector (QBWC) is a somewhat fragile product in that it is not actively maintained and often surfaces vague error messages. We recommend using QBWC version 184.108.40.206 found here.
Reinstalls, Host migration, switching or renaming company file
QBWC was built by Intuit with expectations that the host, file path, and file name of your company file would never change. If at all possible, don't change these things. Unfortunately, a Windows System Restore or an OS re-install can look like a host change to QBWC because of how it and QuickBooks manage data (across files and Windows Registry).
Things to note when trying to deal with OS/File System issues
- QBWC depends on the first company file opened for an integration/application and the path to that company file in order to "Remove" that application. That first company file must be open in QuickBooks from the same location to "Remove" and application from QBWC
- QBWC requires an application to supply an OwnerID and FileID which must be unique in QBWC, so the software row in QBWC must be Removed before syncro.qwc can be re-added. Contact Technical Support for an alternate syncro.qwc if you run multiple accounts that need to connect to QuickBooks on the same host.
- To protect the data of users who run multiple company files on the same host, Our software takes note of the file path of the first connected company file and asks QBWC to only use that file path. Contact Technical Support if you need to move your company file.
Here are some QBWC errors that may require a reinstall:
- QBWC1039: There was a problem adding the application. Unique OwnerID/FileID pair value required
- QBWC1050: An application is already loaded with the same FileID. No need to add an application that is already loaded to the Web Connector
Here is the process for reinstalling QBWC
- Try normal usage and resolution (eg check logs, file paths, QuickBooks Edit->Preferences->Integrated Applications->Company Preferences, which user is logged in) because this requries editing Registry keys. You might also be able to skip most of these steps by hacking your registry keys under HKEY_CURRENT_USER\Software\Intuit\QBWebConnector\SOAPWebServices
- Close QuickBooks Web Connector
- Remove QBWC entries from your QuickBooks company file(s) (Edit->Preferences->Integrated Applications->Company Preferences)
- Close QuickBooks (you may need to kill the QBWC32.EXE*32 process if you have 'Edit->Preferences->General->My Preferences->Keep QuickBooks running for quick startups' enabled)
- Uninstall QuickBooks Web Connector
- Remove QBWebConnector folder from: '"C:\Program Files (x86)\Common Files\Intuit\QuickBooks\"
- Remove the registry folder: HKEY_CURRENT_USER\Software\Intuit\QBWebConnector
- Install QBWC (currently we recommend version 220.127.116.11 found here)
- Open your company file in Quickbooks
- double-click your syncro.qwc file from your quickbooks/sdk settings page in the account.