Module Navigation

Setting up and Using SyncLinx & AccountLinx With Spectrum Dexter & Chaney

Spectrum Dexter & Chaney is an accounting software that SyncLinx and AccountLinx are compatible with that can help expedite data entry and time data entry. SyncLinx allows you to import key equivalent entities such as employees, locations, and/or cost codes (activities) directly into your ExakTime Connect account. AccountLinx is used to export your employee's time data into a Spectrum-compatible format.

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 Spectrum support. We will try to assist you as much as we are able, but there are aspects of Spectrum that are out of our area of expertise and your questions may be better served by Spectrum support or your trusted contact to answer/assist.

As Spectrum 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/AccountLinx to understand what is needed ahead of time.

Table of Contents

Setting Up & Using SyncLinx

Connecting SyncLinx to Spectrum

  1. Open SyncLinx if not already open.
  2. Go to Tools at the top and click Select Data Source.... This should open a window with a list of available data source options.
  3. Select "Spectrum Dexter & Chaney" and click OK.
  4. A warning may appear saying that there is a connection error, this is expected if the SyncLinx connection to Spectrum has not been done on the computer. Click OK on the warning. 
  5. A window should open to set up the settings for the Spectrum data importer. Click Connection
  6. A Connection Setup window should open. In the Connection Setup window, set up/enter the following information. If you do not
    • If using the Spectrum web version. You may need to request read-only access from your Spectrum contact.
      • Server - Enter your Spectrum server name. It is generally "[company_name].dexterchaney.com".
      • Database - Enter your Spectrum database name directly. 
      • User - Enter your Spectrum username/user ID. 
      • Password - Enter your Spectrum password.
    • If hosting Spectrum on your own server/PC
      • Server - Enter the Spectrum server path.
      • Database - Enter your Spectrum database name directly.
      • User - Enter your Spectrum username/user ID.
      • Password - Enter your Spectrum password.
  7. Click Save then click Save again to return to the main page of SyncLinx.
  8. Click any of the "Get Employees/Locations/Cost Codes" options at the top of SyncLinx and double-check the entities that are queried. If the entities are not what you expect, then you may be pointing to the incorrect Spectrum database. 

SyncLinx Settings Unique to Spectrum

There are two different SyncLinx settings that may help when importing certain entities into ExakTime.

  1. Go to Tools at the top and click Spectrum Dexter & Chaney Software Settings....
  2. There are various options available:
    • Import from Company - Select the Spectrum company file that you will import from.
    • Include the ID for Location Names - You can add the location ID before or after the location name in addition to importing the location ID from Spectrum into the location ID field in ExakTime.
    • Field to import for Cost Code - Cost Type, Phase, or Both Cost Type & Phase.
    • Import Phases with Cost Types
    • Import Site Work Orders
    • Curtain Cost Codes per Location - If enabled, will help limit the available cost codes that a location can use when importing your entities.
      • It is generally best to import your cost codes, then the locations as the location will only allow certain cost codes that it can see. If there are no cost codes when locations are imported, it will not be able to specify what cost codes are available for the location.
    • Create Phase dropdown list for AccountLinx
    • Use Employee ID as ExakTime Mobile PIN - Be wary of employees that you are trying to import if they have the same ID as an ExakTime Connect PIN as it can result in import errors as no two employees. 

Using SyncLinx to Import Entities

For more information about the basic use of SyncLinx, you can refer to the following article.

Setting Up & Using AccountLinx

AccountLinx does not connect to Spectrum directly and will instead export your ExakTime time data into a file that you can import into Spectrum. 

Selecting Spectrum as your Exporter

  1. Go to Tools and click Exporter Settings...
  2. The Exporter Settings window should open. Click Select Exporter...
  3. A window with a list of available exporters should open. Select "Spectrum Dexter & Chaney" and click OK.

AccountLinx Settings Unique to Spectrum

The Spectrum exporter for AccountLinx offers a variety of settings when exporting your time data to help tailor the time data to your company's needs. These settings are unique to AccountLinx and will not affect ExakTime Connect or Mobile. If any of the settings offered do not sound familiar to you, then you may not be using the setting in Spectrum and leave it as <None>. 

  1. Go to Tools and click Exporter Settings...
  2. The Exporter Settings window should open. Click Configure....
  3. The Configuration window should open. You should see the following options and tabs.
    General
    • Regular Pay Type - This pay code will be used when exporting your time data for any overtime hours worked by an employee. This should match the overtime pay code from Spectrum.
    • Overtime 1 Pay Type - This pay code will be used when exporting your time data for any overtime hours worked by an employee. This should match the overtime pay code from Spectrum.
    • Overtime 2 Pay Type - This pay code will be used when exporting your time data for any doubletime/premium hours worked by an employee. This should match the doubletime/premium pay code from Spectrum.
    • Phase - Associate the phase with the Employee, Location, Cost Code, or <None>.
    • Department - Associate the department with the Employee, Location, or Cost Code.
    • Alternate Pay ID to - Associate an alternate earning code with an ExakTime employee, location, or cost code. The alternate earning codes entered should match your Spectrum earning code.
      • This is generally used to help differentiate if an employee should receive a different pay type depending on who it is, where they worked, or what they did.
      • For more information about alternate earning codes and how they should be used, you can refer to the following article.
    • Company Code - Associate the company code with the Employee, Location, Cost Code, or <None>.
    • Cost Center - Associate the cost center with the Employee, Location, Cost Code, or <None>.
    • Equipment Code - Associate the equipment code with the Employee, Location, Cost Code, Equipment, or <None>.
    • Equipment Cost - Associate the equipment cost with the Employee, Location, Cost Code, Equipment, or <None>.
    • Map Phase to - Associate a phase with an employee, location, or cost code. The phase should match the Spectrum phase.
    • Map Pay Rate to - Associate a pay rate/amount with an employee, location, or cost code. 
    • Phase mapping required - If the phase is not mapped for the entity, it will result in an export error.
    • Cost Type mapping required - If the cost type is not mapped for the entity, it will result in an export error.
    • Job mapping required - If the job is not mapped for the entity, it will result in an export error.
    • Department mapping required - If the department is not mapped for the entity, it will result in an export error.
    Comments/Notes
    Select the type of notes/comments that should be included with the time record when exported.
    • Employees
    • Location
    • Cost Codes
    • Time Record
    Export Version
    Select your Spectrum version to determine the export type.
    • Below 14.0
    • 14.0 or Above
    • 2021 or Above
  4. Click OK on the Configuration window and click OK on the Exporter Settings window to return to the main page of AccountLinx.
  5. Click the appropriate "Map Employee/Location/Cost Code/Equipment" option to see the columns from the options enabled in Step 3.

General Use of AccountLinx

  • For more information about mapping your entities in AccountLinx, you can refer to the following article.
  • For more information about exporting time data AccountLinx, you can refer to the following article.

Special Considerations when Exporting

When exporting time data from AccountLinx, the batch number will generally be the start or end date of the payroll cycle.

ALX_-_Export_-_Batch_Code_-_00.png

Example of AccountLinx Export

An example of an AccountLinx export opened in Excel has been provided below. The columns have been preformatted based on Spectrum's template. There are some blank columns as we are trying to best match the export file to Spectrum's template and not all fields are used by us.

ALX_-_Export_-_Example_-_00.png

While you can manipulate the exported data after it has been exported, it is highly discouraged as it can result in data discrepancies when double-checking any data.

How to Import Time Data into Spectrum

While the steps below may not cover all scenarios of importing into Spectrum, they should cover the basics of what to expect.

If you need assistance, please feel free to contact us, but keep in mind that we are not Spectrum support. We will try to assist you as much as we are able, but there are aspects of Spectrum that are out of our area of expertise and your questions may be better served by Spectrum support or your trusted contact to answer/assist.

  • Go to Payroll.
  • Go to Data Entry.
  • Go to Pretime Card.
  • Go to Import.
  • Click Continue.
  • Select the exported file.
Was this article helpful?
1 out of 1 found this helpful