Skip to main content

Configuring QuickBooks Desktop General Settings

Jean-Sébastien Goupil avatar
Written by Jean-Sébastien Goupil
Updated over a year ago

This article is specific to QuickBooks Desktop and does not cover configuring QuickBooks Online.

Configure your QuickBooks synchronization settings, class and tax mappings by navigating to the General Settings page under the QuickBooks heading of the 3C Connect settings menu.

mceclip3.png

Enabling Synchronization

If you plan to synchronize your customers and invoices between 3C Connect and QuickBooks, it's important to activate the appropriate settings in 3C Connect. We recommend activating synchronization for customers and invoices.

mceclip0.png

Account Mapping

Route data from 3C Connect to a specific QuickBooks account.

Most users create accounts in QuickBooks to serve as high-level categories for their transactions such as income and expenses accounts. 3C Connect doesn't support funneling transactions to different accounts based on departments (like maintenance, tune-ups or installs), but tracking these departments is available through classes. See the section on class mapping below for more details.

You'll want to choose which QuickBooks account you'd like to use.

mceclip0.png

To view and manage your accounts in QuickBooks, select Chart of Accounts from the Lists menu in QuickBooks Desktop.

mceclip1.png

Payment Mapping

Coordinate payment methods between 3C Connect and QuickBooks.

If payments aren't mapped in 3C Connect, they won't be synchronized to QuickBooks. To set them up, simply set which 3C Connect payment method corresponds to your QuickBooks payment methods in the dropdown.

mceclip2.png

Managing Your QuickBooks Payment Methods

To manage your payment methods in QuickBooks, select Lists > Customer & Vendor Profile Lists > Payment Method List.

mceclip0.png

You'll see a list of all of your current QuickBooks payment methods. Add payment methods by clicking he Payment Method button and adding a new method.

mceclip3.png

Payment Warnings

3C Connect will warn you when you synchronize invoices and payment methods have not been mapped. To disable these warnings, select "Do not warn about payment problems when synchronizing".

mceclip4.png

Tax Mapping

Coordinate taxes between 3C Connect and QuickBooks.

If taxes aren't mapped in 3C Connect, they won't be synchronized to QuickBooks and this is likely to cause errors in accounting. Each 3C Connect tax rate must be matched to its counterpart in QuickBooks. You can find more information about managing your 3C Connect tax rates in our related article.

Make sure that each QuickBooks tax rate percentage that you select in the dropdown matches its 3C Connect tax rate counterpart shown in the label.

mceclip5.png

Managing Your QuickBooks Tax Items

If you aren't seeing QuickBooks tax rates, or need to add QuickBooks tax rates, open the application and follow these steps:

  1. Select Edit > Preferences...

    mceclip7.png
  2. In the Preferences window, select Sales Tax in the left menu and the Company Preferences tab at the top.

    mceclip8.png
  3. Ensure that you've selected "Yes" for the question "Do you charge sales tax?" If you have any tax mappings in 3C Connect and "No" is selected, your taxes will not synchronize.

  4. Add any necessary tax rates by clicking "Add sales tax item..."

To view and manage the tax rates that are currently set up in QuickBooks, follow these steps:

  1. Select View > Item List.

    mceclip9.png
  2. In the list, you'll see your tax items listed as "Sales Tax Item" under the Type column.

    mceclip10.png
  3. You can right click items to edit or delete them.

    mceclip11.png
  4. You can add tax items here directly by clicking Item > New.

    mceclip12.png

Tax Warnings

3C Connect will warn you when you synchronize invoices and taxes have not been mapped. To disable these warnings, select "Do not warn about tax problems when synchronizing". Turning these warnings off can be useful if you're in a region that doesn't charge tax or if your business will be handling taxes in another way.

mceclip6.png

Tax Line Items

3C Connect will allow you to set preferences for whether or not line items on invoices will be set as taxable or non-taxable when sent to QuickBooks Desktop.

mceclip2.png

When using the setting to allow line items to be taxable or not based on the customer tax code, note that tax codes are attached to a customer in QuickBooks. This differs from 3C Connect, where taxes are based on the job site.

The taxable/non-taxable status is shown on each invoice line item in QuickBooks Desktop as displayed below.

mceclip1.png

Class Mapping

Coordinate how classes are designated between 3C Connect and QuickBooks for better QuickBooks reports.

Classes act as tags/flags that allow you to sort sales based on property type and department types that come from 3C Connect for more detailed reporting in QuickBooks.

You can set the property type on each 3C Connect site.

mceclip14.png

You can set the department type on each 3C Connect appointment and work order. Any department that is set on an appointment will be mirrored on the related work order and vice versa.

mceclip15.png

Turning On Classes in QuickBooks

In order to use classes in QuickBooks, you need to first turn them on by following these steps:

  1. Open the QuickBooks application and select Edit > Preferences...

    mceclip7.png
  2. In the Preferences window, select Accounting in the left menu and the Company Preferences tab at the top.

    mceclip16.png
  3. Make sure "Use class tracking for transactions" is checked on.

Mapping Classes in 3C Connect

The first option in the Class Mapping section of your 3C Connect General Settings allows you to choose between allowing different class mappings per service repair or not.

mceclip17.png


When alternate class mapping is allowed, you'll be able to set a different department for each service repair when editing work order line items.

mceclip18.png

Classes aren't in QuickBooks by default, so the default dropdown selection for each 3C Connect class is "Create a new Class". This will create the corresponding class in QuickBooks when synchronizing invoices.

mceclip19.png

If your classes are already set up in QuickBooks, you can choose the correct class in the dropdown.

mceclip20.png

Managing Classes in QuickBooks Desktop

To view and manage the classes that are used in QuickBooks, select "Class List" from the Lists menu. A window containing your class list will appear.

mceclip0.png

Synchronization Settings

Manage how synchronization and discrepancies are handled between 3C Connect and QuickBooks.

There are many important details to consider when synchronizing, and you'll want to make every effort to remain consistent in how data is managed between programs. Below, you'll find details and settings about how your data will be imported and exported.

mceclip2.png

Jobs in QuickBooks correspond to Sites in 3C Connect. These jobs/sites belong to a customer, and this relationship can be displayed more clearly in QuickBooks by selecting the hierarchical view. This will show indentations in your list of customers and jobs to account for this nestled relationship. Right click on your list and select "Hierarchical View" for this mode of display.

mceclip7.png

Import Site Address

When importing customers and invoices from QuickBooks into 3C Connect, the site address in 3C Connect can be configured to come from a certain field in each QuickBooks job.

mceclip5.png
  • Ship To

    mceclip2.png
  • Invoice/Bill To
    The address present in this field will be used only if a Ship To address is not present.

    mceclip3.png
  • Job Name

    mceclip4.png

Export Site Address

When exporting sites from 3C Connect into QuickBooks as jobs, you can select how your job names will be managed.

mceclip10.png

You can choose to override the job name with one provided by 3C Connect, or you can choose to use any name that already exists in QuickBooks. For sites that are newly created in QuickBooks, the job name provided by 3C Connect will be used.

The job name that comes from 3C Connect will depend on which setting you've selected for the job name format. You can choose to display the street address only, or the street address and the city as the job name.

mceclip11.png

When exporting a site from 3C Connect to QuickBooks, the QuickBooks job Ship To address will contain the 3C Connect site address and the QuickBooks job Bill To address will contain the 3C Connect customer address.

Export Customer Name

When exporting customers from 3C Connect into QuickBooks, you can select how your customer names will be managed.

mceclip8.png

You can either choose to use (in order) the company name, or last and first name that comes from the your 3C Connect customer information, or you can keep the customer name as it is in QuickBooks. When creating a new customer in QuickBooks for the first time, the company name or first and last name will be used.

mceclip9.png

Default State Code

If a customer or site address in QuickBooks is missing the state, it can cause complications for tax mapping and reporting. 3C Connect can be set to add a default state code whenever it is missing.

mceclip12.png

Notes

You can choose whether or not to synchronize notes on customers and sites in 3C Connect with their counterpart customers and jobs in QuickBooks.

mceclip13.png

Group Pricing

You have the option to group prices for part items and service repairs on invoices in QuickBooks. If you choose to group part items and service repairs, the prices will be merged onto a single line.

Client File

You can choose to set a specific path to a QuickBooks company file, or to use whichever one is currently opened in QuickBooks.

mceclip2.png

If you selected the option during initial setup to always synchronize QuickBooks, even when QuickBooks is not running, you need to set a specific path for your QuickBooks client file.

If you choose to always synchronize and do not set a specific file path in 3C Connect, you run the risk of synchronizing any file that is open in QuickBooks (this could be other company files, back up files, etc.). Synchronizing differing files would mean the data would conflict and your records will begin to show inaccuracies.

When duplicating company files (as in the case of creating backups), you'll need to make sure that the specific file path is updated to the most current version of the file. If an outdated file is used, the current data won't synchronize between 3C Connect and QuickBooks.

Did this answer your question?