Sage 50 Peachtree is an accounting software that AccountLinx is compatible with that can help expedite time data entry for Sage 50 payroll and reporting. AccountLinx is used to export your employee's time data into a Sage 50-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 Sage 50 Peachtree support. We will try to assist you as much as we are able, but there are aspects of the Sage 50 Peachtree that are out of our area of expertise and your questions may be better served by Sage 50 Peachtree support or your trusted contact to answer/assist.

As Sage 50 Peachtree 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 AccountLinx to understand what is needed ahead of time.

Table of Contents

• Selecting Sage 50 Peachtree as your Exporter
• Exporter Settings for Sage 50
• Data Mapping
• Exporting Time
• Importing Time into Sage 50

Selecting Sage 50 Peachtree 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 "Sage 50 - US Edition [Peachtree]" and click OK.

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. Enabling some of these options will add additional fields to your mapping screens. 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. You should see the following options:
   • Default Pay Levels Regular/Overtime/Overtime2 - The pay codes entered here will be used when exporting your time data to denote if an employee should receive regular, overtime, or overtime 2 (doubletime) pay for the time record. These pay codes should match your Sage 50 pay codes.
   • Map Pay Levels to - Associate an alternate pay level with an ExakTime employee, location, or cost code. The alternate earning codes entered should match your Sage 50 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.
   • Map Peachtree Phase to - Associate a phase with an ExakTime employee, location, or cost code. The phase should match the Sage 50 phase. 
     • If you are unsure how phases would be used with ExakTime, refer to the following section.
   • Map Peachtree Cost Code to - Associate a Sage 50 cost code with an ExakTime employee, location, or cost code. The cost code should match the Sage 50 cost code for a phase. This cost code may differ from your ExakTime cost codes. Despite having the same label, cost codes can differ between applications. 
   • Export vendors time and attendance - Enable this option if you need to import an ExakTime employee's time data for a Sage 50 vendor.
     
     • Vendor's billing type - Specify if the billing type for a vendor should be based on the activity rate, override rate, or flat rate.
   • Ticket Number - The ticket number will automatically increment with your exports for each exported time record, but you can also enter the ticket number to start with. The ticket number for each time record must be unique to be successfully imported into Sage 50.
   • Include headers for columns in export file - Enable this option to include a header row for the CSV export.
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.

Data Mapping

Data mapping allows you to specify the corresponding entities between ExakTime and Sage 50 and complete any fields/options enabled for the export. Refer to the following article if you are unfamiliar with mapping your data in AccountLinx.

Considerations for Mapping

Employee Mapping

When mapping your employees, you are required to enter the employee ID into the 'Recorded by ID' column.

Location Mapping

When mapping locations, you are required to:

• Enter the job code/ID for a job in Sage 50 into the 'Completed for ID' column for a location.
• Specify if an ExakTime location is a customer, job, or administrative with the provided drop-down menu.

Cost Code Mapping

When mapping cost codes, you are required to:

• Enter the activity item ID for a cost code in 'Activity Item ID' column.
• Specify if an ExakTime cost code should use the Employee Rate, Activity Rate, Override Rate, or Flat Rate with the provided drop-down menu for the 'Billing Type' column.
• Specify if an ExakTime cost code should be Billable, Non-billable, No Charge, or Hold with the provided drop-down menu for the 'Billing Status' column.

Exporting Time

After mapping your entities, you can export your time data to a compatible to import into Sage 50. Refer to the following article if you are unfamiliar with exporting time data from AccountLinx.

Example of AccountLinx Export

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

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.

Importing Time into Sage 50

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

Importing Time

1. In Sage 50, go to File and click Import/Export.
2. Select Time/Expense.
3. Select Time Ticket Register.
4. Select and open the AccountLinx CSV export.
5. You will be prompted if you want to back up the import file. Select whichever option you like.
6. Complete the import. 

Reviewing Your Imported Time

1. In Sage 50, go to Tasks.
2. Select Time/Expense.
3. Select Time Tickets.
4. Select the employee to review.
5. Review the employee's time records from the "Time Tickets" list.