AccountLinx is an application we offer that bridges the gap between Sage 50 and ExakTime Connect. With AccountLinx, you can:

• Data map between corresponding entities of ExakTime and Sage 50.
• Enable various settings to help tailor your time data for Sage 50.
• Export time data from ExakTime Connect into Sage 50 for reporting, payroll, and more.

SyncLinx is the other half of AccountLinx and allows you to import your Sage 50 entities into ExakTime to limit duplication of effort. If you would like steps on setting up SyncLinx and importing your Sage 50 entities, refer to our article that covers connecting the applications and the importer settings.

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

As Sage 50 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.

Using Credentials for Sage 50 Canadian Edition (API)

To connect SyncLinx and AccountLinx to Sage 50 Canadian Edition (API), we must utilize a Sage 50 user credential every time you try to use SyncLinx or AccountLinx. As Sage 50 only allows a user to be logged in one at a time, you cannot be logged in to Sage 50 and use SyncLinx or AccountLinx at the same time.

Make sure that Sage 50 is also in single-user mode.

Connecting AccountLinx to Sage 50 Canadian Edition (API)

• Go to Tools and click Choose Exporter.... Click Select Exporter.

  
  

• Select "Sage 50 - Canadian Edition [Simply and Quantum Accounting] - API. [Requires import via SyncLinx]" and click OK.

  

• Click Configure... and the following window should appear.

  

  • Browse for the Sage 50 database, enter your Sage 50 username and password, and then click Test. 
• Click OK on the Configuration window when finished or adjust the exporter settings from the 'Other' tab.

Exporter Settings for Sage 50

The Sage 50 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 Sage 50 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. Click the Other tab.
   • Other
     • Map Customer to - Specify the entity the customer should be associated with. The related mapping screen will have additional fields for you to complete. This is generally "Location", but you can change it to "Cost Code" if it applies to your setup. To export the time data with AccountLinx, a customer is REQUIRED for mapping purposes. 
       • If you do not have any customers set up for your Sage 50, you will need to create a dummy customer for us to use. You may also need to generate an invoice for the dummy customer in Sage 50 as they do not recognize the dummy customer as an official customer until at least one invoice is generated. 
   • Default Payroll Income Codes
     • Regular Code - Enter the regular income code as used in Sage 50.
     • Overtime 1 Code - Enter the Overtime 1 income code as used in Sage 50.
     • Overtime 2 Code - Enter the Overtime 2 income code as used in Sage 50.
   • Use Alternative Payroll Income Codes
     • Map Codes to - Specify if alternate hours income codes should be associated with specific employees, locations, or cost codes. This allows particular employees, locations, or cost codes to have an alternate set of income codes when exported. The related mapping screen will show fields to enter the income codes that should be associated with exported time records. If an entity does not have alternate income codes, it will use the default income codes instead. 
4. Click OK on the Configuration window and click OK on the Exporter Settings window to return to the main page of AccountLinx.

Data Mapping

Data mapping is a required process that allows you to specify what an entity in ExakTime relates to in Sage 50 to help create your Sage 50 reporting and paychecks. 

For information about mapping your data in AccountLinx, refer to the following dedicated article.

Exporting Time Data with AccountLinx

Now that AccountLinx has been connected to your Sage 50 company file and you have mapped your data, you should be ready to export your ExakTime time data into Sage 50.

For information about the basic use of AccountLinx, refer to the following dedicated article.