Install and Configure the QuickBooks (QB) Desktop Sync Interface

This topic provides information on how to install and / or configure the various components required to use the QB Sync Interface and assumes that the appropriate QuickBooks (QB) product is already installed on the computer used to complete the sync process.

In order to work, the QuickBooks interface requires the following:

  • The use of QuickBooks Pro or higher.
    • This includes Enterprise Silver.
    • JobBOSS2 does not interface with the "Standard" version of QuickBooks.
  • The version of QuickBooks being used must be within the current two years to be supported.
    • Older versions may work, but there is no guarantee and they may stop working if there are changes to newer versions of the QB product.
  • Only one version of QuickBooks can be installed on the computer being used to synchronize information with JobBOSS2.

The interface CANNOT be used via a VPN or Terminal Services.

This example uses QuickBooks Pro for reference information; it is possible some option locations may vary between products.

For more information see Using the QB Sync Interface.

ClosedInstall the QB Sync Interface

The QB Sync Interface is an application provided by Shoptech that is used to indicate what information should be synchronized with the selected QuickBooks company. Once installed, the QB Sync can be used for any of the following:

  • Create AR Invoices in QuickBooks
  • Create AP Invoices in QuickBooks
  • Provide payroll related information to QuickBooks
    • If the JobBOSS2 Accounting Application is being used, payroll information can be imported back from QuickBooks in the form of a Journal Entry.

***

  1. Click the 'Help' option in the Quick Access Toolbar (located at the top-right of the screen.)
  2. Click 'Client Downloads.'
  3. Click 'Quickbooks Sync.'

    QuickBooks Sync

  4. Run the 'JobBOSS2 QB Sync.exe' file downloaded by the system.
    • Files are saved in the Downloads directory by default.
    • Answer 'Yes' to the prompt to allow the program to make changes (if one is provided.)
  5. Click 'Next' on the Welcome screen of the installer to continue.

    Welcome Screen

  6. Click the check box to indicate acceptance of the license agreement.
  7. Click 'Next' to continue.

    License Agreement

  8. Verify the destination folder for the installer file and click 'Next' to continue.
    • Select a different folder before continuing to save to another location.

    Destination Folder

  9. Enter the name of the server where JobBOSS2 is running.
    • This can easily be populated by copying the url from the browser window running JobBOSS2 and pasting it into the installer window.
    • When pasting the path, remove any extensions at the end such as 'Dashboard', 'Navigator', etc.
  10. (OPTIONAL) Click the check box to use an existing User ID (within Computer Management) for the purpose of accessing the QB Sync Windows Service.
    • If this option is selected, a Service Username and Password must be provided.
      • The User MUST have Administrator and 'Sign on as a Service' privileges.
      • If a User is entered that has a password that changes or expires, the credentials for the QB Sync Windows Service will have to be updated to match.
    • If this option is left blank, the installer will create a User ID and configure it accordingly.
      • The default User will be QBSYNC.
      • The default Password will be QbSync#1.
    • Unless there is an overriding reason not to do so, it is recommended to allow the installer to create the User and Password automatically to avoid conflicts with existing users logging on to the network.
  11. Click 'Next' to continue.

    Server Name

  12. Click 'Next' to confirm the selections and install the QB Sync.
    • The 'Back' button can be used to review previous screens and make changes.

  13. The installer indicates the QB Sync is being installed and provides a progress indicator.

     

    If a 1057 Error appears at the completion of Processing, please see How to Fix a 1057 Error when Installing QuickBooks.

  14. Click 'Finish' to close the installer.
    • By default the option to 'Run Shoptech JobBOSS2 QB Sync now' is checked, meaning the interface will launch automatically upon closing the window.
    • Remove the check to prevent the Sync Interface from opening.

    Finsih Install

  15. Assuming the option to launch the Sync was left checked, the QB Sync Login window appears.

    Login Screen

    • If the API Key does not automatically populate, copy and paste the value located in Company Maintenance in the API Key field.
      • The API Key is located specifically under System > Company Maintenance > Edit.
    • If the User Name and / or Password are edited at this time, make sure to use the values entered here when configuring the QB Connector and the default QB User in JobBOSS2.
    • If the QB Connector file has been installed and configured, clicking 'Log in' will open the Sync Interface; otherwise the system will provide a prompt to 'run the QB Connector tool.'
      1. By default the installer creates a shortcut titled JobBOSS2 Desktop that can be used to open the QuickBooks Sync Login screen in the future.

      Default Shortcut

      If desired, right clicking on the shortcut / icon provides the ability to rename it to something else, such as 'QB Sync'.

ClosedInstall the QB Connector

The QB Connector is a third party application that allows JobBOSS2 to communicate with QuickBooks and pass information back and forth.

  1. On the PC that will be used to run the QB Sync Interface, navigate to C:\Program Files (x86)\JobBOSS2 QB Sync\QBConnector.
  2. Right click on 'QBConnector.exe.'
  3. Click 'Run as administrator.'

    Run As Admin

    1. The QB Connector must always be 'run as administrator' due to access privilege requirements.
  4. Answer 'Yes' to the prompt to allow the program to make changes (if one is provided.)
  5. On the QB Connector window that opens, click the 'Users' tab.
  6. Click 'Add.'
  7. Enter the name used during the installation of the QB Sync Interface.
  8. Enter the password used during the installation of the QB Sync Interface.
    • The values for Name and Password MUST match the values entered in the QB Sync Interface and the JobBOSS2 User.
  9. Click 'Browse' located next to the 'Company File' field.
    • By default this opens the 'Company Files' directory that holds the QuickBooks company files used.
  10. Select the appropriate .qbw file and click 'Open.'
  11. Leave the Connection Mode and Authentication Mode fields set to their default values.
  12. Click 'OK.'

    User Setup

  13. Click 'Start.'
    • If prompted, save changes.
  14. Minimize the QB Connector to the system tray.

The QB Connector must remain open and running as a service on the computer used to synchronize information between JobBOSS2 and QuickBooks in order for the interface to function.

ClosedCreate User JobBOSS2 (IF NEEDED)

If the installer was allowed to create the QB Sync User, this information needs to be added to JobBOSS2 as a User ID as well. If an existing User was entered during installation of the Sync Interface, that information must exist as an JobBOSS2 User as well as a network User.

This example assumes the installer was allowed to create the user and password automatically.

  1. In JobBOSS2, go to System > User Maintenance.
  2. Click 'New.'
  3. Enter the following:
    • User ID = E2QBSYNC
    • Name = E2QBSYNC
    • New Password = E2QbSync#1
    • Confirm Password = E2QbSync#1
    • If the User Name and / or Password were edited during installation of the QB Sync interface, make sure the information entered here matches the values used there and in the QB Connector.
  4. Enter an Email Address for the user.
    • This does not have to be a valid email address, but a value must be entered since it is a required field.
  5. Verify the 'View Only User' check box is selected.
    • This will prevent a JobBOSS2 license from being taken up when this User is selected.
  6. Allow access to the JobBOSS2 Company that is going to connect to the .qbw file selected when installing and setting up the QB Connector.
  7. Click 'OK' to save any changes made to the User Code.

For more information see User Maintenance.

ClosedAuthorize the Sync Function

Once the various components of have been installed and configured, including QuickBooks, the following steps need to be taken to complete the process and to finalize the sync functionality between JobBOSS2 and QuickBooks.

  1. Open QuickBooks using the 'Run as administrator' option.
    • This can be done by right clicking on the QuickBooks icon or the appropriate .exe file and selecting 'Run as administrator.'
    • Answer 'Yes' to the prompt to allow the program to make changes (if one is provided.)
  2. Open the QuickBooks Sync Login screen using the 'Run as administrator' option.
    • This can be done by right clicking on the 'JobBOSS2 Desktop' (or otherwise renamed) icon or the E2SSShop.Desktop.exe file (located under 'C:\Program Files (x86)\JobBOSS2 QB Sync' by default) and selecting 'Run as administrator.'
    • Answer 'Yes' to the prompt to allow the program to make changes (if one is provided.)
    • Values should already be entered as a result of the QB Syn Interface installation process, but they can be edited if needed.
  3. In the QuickBooks Sync Login screen, click 'Log in.'
  4. The QuickBooks Application Certificate page should appear (see image below.) Select the following:
    • 'Yes, always; allow access even if QuickBooks is not running.' (Radio button)
    • 'Allow this application to access personal data such as Social Security Numbers and customer credit card information.' (Check box)
  5. Select 'Admin' as the user to 'Login as' from the dropdown menu provided.
  6. Click 'Continue.'

    QB Certificate

  7. Click 'Done' to accept the selections made.

    Certificate confirmation

  8. Verify that the QB Connector is an authorized application in QuickBooks.
    1. In QuickBooks, go to Edit > Preferences > Integrated Applications.
    2. Click the 'Company Preferences' tab.
    3. Verify QB Connector is listed as an authorized application.

    Authorized Applications

  9. Once configured and authorized as an application, the QB Sync Interface will automatically connect to the selected QuickBooks company and allow the user to perform the following functions:
    • Create AR Invoices in QB by syncing selected information from JobBOSS2.
    • Create AP Invoices in QB by syncing selected information from JobBOSS2.
    • Send Time and Attendance information to QB for payroll purposes.

ClosedVerify Settings In JobBOSS2 And QuickBooks

Before using the interface, verify the following settings in each program to ensure information will synchronize correctly.

Spaces and "special characters" such as dashes, dots, etc., must be included in the count when considering character limits for fields in both JobBOSS2 and QuickBooks.

ClosedRequired For All Items

These settings and preferences need to be confirmed before using the QB Sync Interface regardless of which options are used.

ClosedRequired For Synchronizing AR and AP Invoices

In addition to the settings "Required For All Items", these settings and preferences need to be confirmed if the QB Sync Interface will be used to create AR and AP Invoices in QuickBooks using information pulled from JobBOSS2.

ClosedRequired For Payroll Interface

In addition to the settings "Required For All Items", these settings and preferences need to be confirmed if the QB Sync Interface will be used to create payroll records in QuickBooks using information pulled from JobBOSS2. If JobBOSS2 Accounting is being used (as opposed to QuickBooks,) these settings are also necessary to allow payroll information to be imported back in to JobBOSS2 for the purpose of creating journal entries.