Module Navigation

Guide to Using SyncLinx with QuickBooks (Local)

SyncLinx is a complementary software to assist with bridging the gap between your accounting software and ExakTime Connect. With SyncLinx, you can import your QuickBooks employees/vendors, customers/jobs, service items, and non-inventory parts into ExakTime as your employees, locations, cost codes, and expenses.

If you have any questions or concerns during setup and/or use, you can contact us with the "Request Support" link at the top of the page and we will try to assist as best as possible. Keep in mind, however, that we are not QuickBooks support. We will try to assist you as much as we are able, but there are aspects of QuickBooks that are out of our area of expertise and your questions may be better served by QuickBooks support or your trusted contact to answer/assist.

As QuickBooks allows flexibility to fit various needs, we cannot take every unique setup into account. It is advised to read through this article before setting up SyncLinx to understand what is needed ahead of time.

Table of Contents

Prerequisites

This article assumes that you have installed SyncLinx/AccountLinx and have connected them with your QuickBooks company file. If you need assistance with either, you can refer to the articles below:

Importing Data from QuickBooks into ExakTime Connect

If you are unfamiliar with using SyncLinx to import employee data, you can refer to the following article.

When importing data from QuickBooks to ExakTime, the entity equivalents are:

  • QuickBooks Employees import as ExakTime Connect Employees
  • QuickBooks Customers & jobs import as ExakTime Connect Locations
  • QuickBooks Service Items import as ExakTime Connect Cost Codes

Additional Consideration When Importing Entities

Importing Employees

SyncLinx populates Employees for ExakTime Connect using Employees entered in QuickBooks.

In addition to importing QuickBooks employees, you can also import QuickBooks vendors as employees. If you need to import vendors as employees, expand the section below for steps:

Import QuickBooks Vendors as Employees
  • To enable this, go to Tools and click QuickBooks Settings.

    SLX_-_QuickBooks_-_Menu_-_02.png

  • Enable the option for "Include vendors in employee list".

    SLX_-_Vendors_as_Employees_-_00.png

  • When you click "Get Employees", it should now include vendors as well.

Importing Locations

SyncLinx populates Locations for ExakTime Connect using Customers & Jobs entered in QuickBooks via the Customer Center. The Customer Name field determines the name of the Location after the Customer/Job is imported. In the event you have one customer with multiple jobs in QuickBooks, each job will import as an individual Location. The customers and jobs will be listed as:

  • Customer Name
  • Customer Name: Job 1
  • Customer Name: Job 2
  • Customer Name: Job 3

An additional option in SyncLinx allows you to specify which address should be imported for customer/job as a customer can have a location based on the billing or shipping address.

  • To enable this, go to Tools and click QuickBooks Settings.

    SLX_-_QuickBooks_-_Menu_-_02.png

  • Use the drop-down menu for the address type to select Shipping or Billing.

    SLX_-_Addresses_-_00.png

  • When you import the customer/jobs into ExakTime, it will use the address specified to help derive the Geofence.

Importing Cost Codes

Cost Code (also known as activities or tasks) can be imported via SyncLinx by using the Service Items from QuickBooks. Service items are typically entered under Lists > Item List in QuickBooks. The Item Name/Number field determines the Cost Codes's name upon import.

Importing Expenses

Non-Inventory Parts in QuickBooks can be imported into ExakTime as expenses. Non-inventory parts are typically entered under Lists > Item List in QuickBooks

Additional Settings & Options

In SyncLinx, under Tools > Options there are additional settings to manipulate SyncLinx behavior when running certain functions. Settings found here are not unique to a SyncLinx/QuickBooks connection, thus all settings are not recommended or used.

General

Under the General tab, there are two options.

SLX_General.png

  • Logging Level - Used by Product Support for troubleshooting. Regardless of export method, you will not need to adjust this setting.
  • Show last screen on start-up - Enabling sets SyncLinx to open and show the last used screen

Update

Options here define what elements of ExakTime Connect Employees, Locations, and Cost Codes can be updated when choosing the update option for any entity in the "Already in ExakTime" section.

SLX_-_Options_-_Updates_-_00.png

For all three sections, names cannot be updated in this manner. Changing the name (either in Connect or in QuickBooks) breaks the matching, thus forces them to appear as two different unmatched entities.

Employee

  • Address - Updates the employee's address using the QuickBooks "Home Address" field under Address & Contact
  • Hourly Wage - Not available for import from QuickBooks
  • Number/ID - Not available for import from QuickBooks
  • Email - Fills in the employee's email address using the "Main Email" field in QuickBooks under Address & Contact

Location

  • Number/ID - Not available for import from QuickBooks
  • Contact/Customer - Not available for import from QuickBooks
  • Address - Populated by "Address Details" in QuickBooks
  • Description/Notes - Not available for import from QuickBooks
  • Phone - Not available for import from QuickBooks
  • Certified - Not available for import from QuickBooks

Cost Code

  • Number/ID - Not available for import from QuickBooks
  • Description - Not available for import from QuickBooks

Employee

The Employee tab changes the imported employees' user access levels within ExakTime Connect.

SLX_-_Options_-_Employees_-_00.png

Security Role Options

  • Import Employee as ExakTime X User - On import, set the employee's ExakTime Connect Security Role to the chosen Role. For more information about ExakTime Connect security roles, you can refer to the following article.
  • Import Employee as Mobile X User -  On import, set the employee's ExakTime Mobile Security Role to the chosen Role. For more information about ExakTime Mobile security roles, you can refer to the following article.

PIN

  • Import Employee ID/Number as PIN# - Pulls the employees's QuickBooks ID and imports it as their ExakTime Mobile pin. It is not recommended to use this option as the ID field pulled cannot be edited within QuickBooks and returns a value not compatible with the ExakTime Mobile Pin restrictions
Was this article helpful?
0 out of 0 found this helpful