QuickBooks Desktop Setup and Help

QuickBooks Desktop Complete Guide



Table of Contents
  1. Get Connected - actually link up the integration
  2. Setup Class Tracking for Multi-Location accounts
  3. Explanation of COGS (Cost of Goods Sold) Tracking
  4. Converting from QuickBooks Online to QuickBooks Desktop
  5. General Troubleshooting

Recap of What is Supported



FunctionalityQuickBooks Desktop
Sends Customer records to QB when an invoice was updatedYes
Sends Customer records to QB when a customer is updatedNo
Sends Invoice records to QB when an invoice was updatedYes
Sends Payment records to QB when a payment is madeYes
Sends Purchase Orders to QBNo
Sends Products to QB (as items) when a product is updatedNo
Live Updates - updates are sent immediatelyNo*
Syncs "RepairShopr Location" to QB "class"No
Able to send your entire Customer list to QB at initial setupYes
Able to import your customers from QB at initial setupYes
Sub-Customer SupportYes**
Invoices with $0 totals syncYes ***
Tax Groups support for complex tax configurationsNo
Overpayments (a payment that is made for more than the invoice)Yes
Split Payments (multiple payments to complete an invoice)Yes
One-Time export all Customers to QBYes
One-Time export all Products to QBYes
Void/Delete in QB for Invoices when deleted in RSYes
Automatically syncs your customer databases both ways QB <-> RSNo
Imports payments made on the QB sideNo
Works with Intuit Merchant ServicesNo
Refund Invoices syncNo
* They sync when you run the QBWC tool on your desktop
** They map as real customer in RepairShopr, not sub customers
*** They sync after they are marked paid

What is Not Supported


The RepairShopr Quickbooks integration does not support use of "Discount" type items in inventory due to Intuit's irregular treatment of these items in their integration.

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)

Editions Supported



Desktop Edition Support (Windows Only)Supported
QuickBooks Enterprise SolutionsYes
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) (TAX NOT SUPPORTED)Yes, NO TAX
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 DesktopNO

Get Started


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.

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 RepairShopr. 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 RepairShopr. 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 RepairShopr 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 RepairShopr.



6. Specify the deposit account, 99.99% of the time it's "Undeposited Funds"



7. Map your RepairShopr 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 in to RepairShopr, 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 do RepairShopr Tax Rates map to QuickBooks Desktop?


RepairShopr 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 or individual Lines

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

 

QuickBooks "Class" Tracking for Big-Chain


We apologize, but at this time Class tracking is only supported on QuickBooks Online with RepairShopr.

COGS (Cost of Goods Sold) Tracking Explanation


1. Start by creating a new Product in Quickbooks Online or in RepairShopr

In RepairShopr:
Make sure you enter a "Price - retail" and a "Price Cost"



In QuickBooks Desktop:

Make sure that you check "I track quantity on hand for this product"
Income account should be "Sales of Product Income"
Expense account should be "Cost of Goods Sold"



2. Go to /quickbooks/settings in RepairShopr
click "Import Products from QuickBooks" at the bottom of the page

NOTE ABOUT ITEM/PRODUCT IMPORTS:

The Product/Item imports include "Service NonInventory OtherCharge Inventory InventoryAssembly Group” and exclude "FixedAsset Subtotal Discount Payment SalesTax SalesTaxGroup"




4. Add the item to an invoice in RepairShopr.

5. The invoice will sync to QBD

6. Accept payment on the invoice in RepairShopr

7. To view the Cost of Goods Sold report in QBD, navigate to Chart of Accounts and search for Cost of Goods Sold.


8. Click "Run Report" to see the Cost of Goods Sold report


9. To see your overall Profit and Loss Report, navigate to Reports > Profit and Loss



10. If COGS isn't showing up by default on your Profit and Loss Report, click "Customize" to make sure that the Accounting Method is set to "accrual"



11. Your Profit and Loss Report will look something like this:

Note:
For this to work, you'll need a Quickbooks Online "Plus" account, which includes inventory tracking.
http://quickbooks.intuit.com/online/compare/

Converting from QuickBooks Online to QuickBooks Desktop


1. Migrate your data 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 RepairShopr.

3. We'll do some backend changes on our end (please contact us at help@repairshopr.com).

4. Go through the standard Quickbooks Desktop integration steps.

General Troubleshooting

RepairShopr 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: http://feedback.repairshopr.com/knowledgebase/articles/303472-glossary-of-quickbooks-api-errors



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. RepairShopr recommends using QBWC version 2.1.0.30 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 (eg RepairShopr) to supply an OwnerID and FileID which must be unique in QBWC, so the RepairShopr row in QBWC must be "Remove"d before repairshopr.qwc can be re-added. Contact Technical Support for an alternate repairshopr.qwc if you run multiple RepairShopr 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, RepairShopr 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
  1. 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
  2. Close QuickBooks Web Connector
  3. Remove QBWC entries from your QuickBooks company file(s) (Edit->Preferences->Integrated Applications->Company Preferences)
  4. 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)
  5. Uninstall QuickBooks Web Connector
  6. Remove QBWebConnector folder from: '"C:\Program Files (x86)\Common Files\Intuit\QuickBooks\"
  7. Remove the registry folder: HKEY_CURRENT_USER\Software\Intuit\QBWebConnector
  8. Reboot
  9. Install QBWC (currently we recommend version 2.1.0.30 found here)
  10. Open your company file in Quickbooks
  11. double-click your repairshopr.qwc file from your RepairShopr quickbooks/sdk page

Feedback and Knowledge Base