Adding or editing a single or first web connector

SECURITY  Admin access to the QuickBooks data file and security level with permission to configure the QuickBooks Extension. Refer to Admin security settings.

NAVIGATION   > Admin > Extensions & Integrations > QuickBooks Extension (New) > Web Connectors

1. Log into Autotask as an administrator.
2. To open the page, use the path(s) in the Security and navigation section above.
3. Click New. The QuickBooks: New Web Connector page will open.
4. Click Download Web Connector. You will be redirected to an Intuit site.
5. Click Download, unzip and install the QuickBooks Web Connector. A .zip file is downloaded.
6. Choose a location and extract all files.
7. Right-click on the QBWebConnectorInstaller file and select Run as Administrator.
8. Follow the steps in the InstallShield Wizard and accept the license agreement.
9. Click Finish and return to the QuickBooks: New Web Connector page.

In this step, you assign the name that will identify the web connector file.

IMPORTANT  The first web connector you create will be the default one. All Autotask organizations are automatically assigned to the default web connector. You cannot change the default to a web connector you create later, or delete a web connector, so please be deliberate when you create your first web connector.

If this is the first web connector you are creating and you will be adding additional ones, best practice is to name it the same as the QuickBooks organization Your Autotask instance may be configured to use one of the following terms instead: Account, Business Unit, Client Company, Customer, Site. file it will be associated with, and add (default) to the name you are assigning.

From the Communicate with QuickBooks As (Resource)* field, select the Autotask API account that QuickBooks will use to authenticate the web connector to Autotask. This user account must have an API User (API only) security level with a tracking identifier. We strongly recommend that you create a dedicated user account that is not used for any other purpose or integration.

• If you have previously set up an API user account for the QBWC integration, click the drop-down menu and select it from the list. The list will contain only resources with an API user security level.
• To learn how to set up an API user for an integration, refer to Create an API user account for the QB Web Connector integration.

In this step, you will download the AutotaskQBWC.qwc file that will connect your Autotask instance and the QuickBooks data file you want to transfer data to. The QWC file contains the information needed for QBWC to communicate with the Autotask web connector you just configured.

Each QWC file you download is unique. In a single user / single QuickBooks company file setup, you will only need to download this file once. You will need to download a new file if your local organization The database record of your own organization in Autotask. It has the organization ID "0", and is used as the sender address on quotes, invoices, etc. Previous versions of the help referred to this database record as: 0 Account, Zero Company, Your Own Company.'s file location changes, for example if you need to re-map the drive your QuickBooks file is located.

IMPORTANT  In most cases, you only download one QWC file. You will need to download multiple files if you would like to configure the integration for multiple users. Refer to Configuring the integration for multiple users.

1. Click Download .qwc File and select Save File.
   
2. Click OK. The file is now located in your Downloads (or another selected) folder.
   
   Do not open the web connector from the Downloads (or any other) folder. Instead, open QuickBooks as an administrator.
3. Open QuickBooks on the same physical or virtual machine where you are running Autotask and where the Web Connector application is installed. You must run QuickBooks as an Admin in single user mode to successfully complete the configuration.
   

IMPORTANT  If this is the first connector you are setting up, it must be the data file that will be your main QuickBooks file. During the first handshake sync, the web connector will transmit the QuickBooks financial accounts and classes to Autotask. Changing this later will create a lot of extra work, since all mapping settings will be cleared.

4. In QuickBooks, select File > App Management > Update Web Services.
   
   The QuickBooks Web Connector dialog box will appear. If this is the first web connector you are configuring, the list will be empty.

IMPORTANT  Customers who use a non-US version of QuickBooks Desktop will not see the File > Update Web Services path. They can add the downloaded QWC file to the web connector by either:
• Double-clicking the downloaded QWC file
• Searching for the QuickBooks Web Connector app on their local machine or server, clicking Launch > Add an application, then adding the QWC file.

5. In QuickBooks Web Connector, click Add an Application and browse to the AutotaskQBWX.qwc file in your Downloads (or other) folder.
   
6. If required, authorize the new web service and give permission to access the company file.
   
7. If you are planning to set up the integration to automatically transfer data to QuickBooks at predetermined intervals, instead of having a QuickBooks user initiate the data transfer, we recommend that you select Yes, always; allow access even if QuickBooks is not running. Then you don't have to have QuickBooks open for the web connector to pull data out of Autotask, and you would only need to access the web connector to disable or update auto-run, or access the logs. Your QuickBooks admin user account used to configure the integration and your Autotask API-only user account will be used for authentication.
   
   

8. Select Autotask QuickBooks Integration and click Update Selected. This will initiate a required test sync, and transmit the location of the QuickBooks company file to Autotask. Do not select Auto-Run for this test connection.
9. When prompted, enter the password for the API user account whose credentials are used to access Autotask, and save the password in the connector.
   
   Status bars will let you know when the process is complete.
   
   
10. Once the configuration is complete, return to this page and select Auto-Run. Enter a sync interval (in minutes). The minimum sync interval is 15 minutes.
    If you selected Auto-Run and something prevents a successful connection, Auto-Run is suspended for over 90,000 minutes (62 days or more). The number of minutes also serves as an error code:
    

11. Return to the QuickBooks: New Web Connector page or the QuickBooks: Edit Web Connector page in Autotask to complete the setup.
    

After you have configured and run the web connector in QuickBooks, return to the QuickBooks: New Web Connector page or the QuickBooks: Edit Web Connector page in Autotask and confirm that this web connector is linked to the correct QuickBooks data file.

If the file was open while you configured the web connector in QuickBooks, click Refresh at the top of the page. The QuickBooks Company File Location should now be displayed.

The QuickBooks financial accounts, classes, employees, vendors and payroll items have now been synced to Autotask and are available for mapping. Refer to Autotask to QuickBooks Mapping.

Any deletions in QuickBooks will be synced every 24 hours, or manually on demand.

Refer to the following table:

Field	Description
Company File Location	The Company File Location will initially be blank. Once you have completed step 4, configured the Autotask QuickBooks Integration in QuickBooks, and run the web connector for the first time, you can populate this field by clicking the Refresh icon at the top of the page. The location of the QuickBooks data file that is connected with your Autotask instance should now be correctly displayed.
Clear Company File Location	If you must move the QuickBooks file that is connected to this web connector, you must clear the old Company File Location from the web connector and run the web connector again to link up to the new file location. IMPORTANT  You cannot link a web connector to a different company file. Doing so will erase all billing code and line of business mappings in the new company file.
QuickBooks (Accounts | Classes | Employees | Vendors | Payroll Items) Last Full Sync	Once every 24 hours, Autotask will do a full sync. During a full sync, the mapping of Financial accounts Classes Employees Vendors Payroll Items that don't exist in QuickBooks anymore are deleted in Autotask. All other syncs are "last modified syncs" of items that were created or modified. This field displays the date and time of the last full account sync between Autotask and QuickBooks for each item type, either by the regularly scheduled full sync or the manually initiated one.
Clear (Account | Class | Employee | Vendor | Payroll Item) Sync	If you deleted (Accounts | Classes | Employees | Vendors | Payroll Items) in QuickBooks, you can use this button to refresh the mapping from QuickBooks without waiting for the full sync.
QuickBooks Accounts Last Full Sync	Once every 24 hours, Autotask will do a full sync. During a full sync, financial accounts and classes that don't exist in QuickBooks anymore are deleted in Autotask. All other syncs are "last modified syncs" of items that were created or modified. This field displays the date and time of the last full account sync between Autotask and QuickBooks, either by the regularly scheduled full sync or the manually initiated one.
Clear Account Sync	If you deleted accounts in QuickBooks, you can use this button to refresh your accounts from QuickBooks without waiting for the full sync.
QuickBooks Classes Last Full Sync	Once every 24 hours, Autotask will do a full sync. During a full sync, financial accounts and classes that don't exist in QuickBooks anymore are deleted in Autotask. All other syncs are "last modified syncs" of items that were created or modified. This field displays the date and time of the last full class sync between Autotask and QuickBooks, either by the regular full sync or the manually initiated one.
Clear Class Sync	If you deleted classes in QuickBooks, you can use this button to refresh your accounts from QuickBooks without waiting for the full sync.

Save and close this page.

IMPORTANT  STOP!

Synchronization is initially disabled to give you a chance to complete and review your mappings. Before you enable the transfer and synchronization of data from Autotask to QuickBooks, which will immediately initiate the transfer of all items flagged as Ready to Transfer, you must complete a number of data mapping tasks. The specific tasks will depend on the types of items (invoices, purchase orders, etc. ) that you are planning to transfer. Review the following topics:

• Managing Naming Conventions
• Autotask to QuickBooks Mapping
• Any referenced topics that apply to your transfer selection

After you have completed the final mapping steps, you must return to the QuickBooks: Edit Web Connector page in Autotask and selectively enable the transfer of items for this web connector.

You have the option to receive email notifications when transfer errors occur. To enable these emails, enter one or more email addresses into the Email(s) field, separated with a semi-colon.

The recipients can use the Transfer History pages to troubleshoot the error. Refer to Transfer history pages.

US QuickBooks users have the option to calculate taxes in Autotask and then transfer the tax amounts to QuickBooks.

IMPORTANT  For the record, we strongly advise new customers against doing this. We continue to make this feature available to support a number of legacy customers who depend on this workflow.

Refer to Calculating taxes in Autotask instead of QuickBooks? (US versions only).

When you select a transfer option, any items that were set to Ready to Transfer will be queued up and transferred as soon as the settings are selected and the web connector file is saved.

The following transfers can be individually selected:

NOTE  We recommend that for each transfer type, you set a small number of items as ready to transfer and do a test run.