Module Navigation

Guide to Using AccountLinx with QuickBooks (Local)

AccountLinx is a complementary software to assist with bridging the gap between your accounting software and ExakTime Connect. With AccountLinx, you can export your time data, and expenses if enabled, to your employees weekly timesheets in QuickBooks to help your payroll process.

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 AccountLinx 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:

Mapping Entities

Mapping_Button.png

Mapping entities tells AccountLinx who to give the imported to time, what customers/jobs get the accrued time, which Service Items are used, and more. While the Setup Wizard allows you to perform these mappings, we find it easier to access mapping from the AccountLinx home screen using the toolbar buttons found towards the top-left of AccountLinx as it also helps you get familiar with mapping in the future.

For more information about the overall mapping process, you can refer to the following article. The sections below provide QuickBooks specific mapping information. 

Mapping Considerations

Employee Mapping

When mapping employees, you are only able to map a single ExakTime employee to a single equivalent QuickBooks employee/vendor. 

Location Mapping

When mapping locations, it is possible for multiple ExakTime locations to be mapped to a singular QuickBooks customers/jobs. This allows you to track detailed locations in ExakTime, but have it all funnel to singular customers if the detail is not needed in QuickBooks.

For example, you may have a shopping complex entered as a QuickBooks customer, but do not have jobs for the customer. You can create multiple locations in ExakTime to track time intimately there, but have it all funnel into the shopping complex customer in QuickBooks. Please be aware that you cannot do the reverse of this with a single ExakTime location going into multiple QuickBooks customers.

Cost Code Mapping

Similar to locations, it is possible for multiple ExakTime cost codes to be mapped to a singular QuickBooks service item. This allows you to track detailed cost codes in ExakTime, but have it all funnel to singular service items if the detail is not needed in QuickBooks.

For example, you may have a simple "Labor" service item entered in QuickBooks. You can create multiple cost codes in ExakTime to track time intimately there, but have it all funnel into the "Labor" service item QuickBooks. Please be aware that you cannot do the reverse of this with a single ExakTime cost code going into multiple QuickBooks service items.

Additional Configuration

AccountLinx offers a few additional settings and options to further tune AccountLinx to suit your business needs.

Several of these were covered in the Setup Wizard, but you can find them all by navigating to going to Tools, clicking Exporter Settings, and clicking Configure....

ALX_-_QuickBooks_-_Exporter_Settings_-_05.png
ALX_-_QuickBooks_-_Exporter_Settings_-_06.png

Options

ALX_-_QuickBooks_-_Exporter_Settings_-_00.png

QuickBooks Connection

  • Connection Type - Describes the type of connection, typically a locally open company file
  • Company File Name - Displays the name of the QuickBooks company file currently connected
  • Export to multiple QuickBooks companies - Allows AccountLinx to connect to multiple company files and preserves the mappings between two separate QuickBooks company files, if possible.
    • AccountLinx can currently only map an ExakTime entity to a QuickBooks entity from one Company File at a time. For example, if employee Kevin Jones exists in two Company Files, you can only map the employee to one QuickBooks Company File at a time. If you need to export his time data to both QuickBooks Company Files, you will need to re-map the employee.
    • If the option is not enabled, AccountLinx will remove all mappings when it connects to a QuickBooks Company File it does not recognize.  
    • For this to work as intended, the company files can not have overlapping data, for example, employee John Doe should not exist in both company files. If there are any overlapping data/entities, you will need to remap the data before exporting.
    • If you would like more information on how this option can be utilized, please refer to the article: Switching to a Different QuickBooks Company File for SyncLinx/AccountLinx

Default Wage Items

These are the default QuickBooks Payroll Wage Items used for employees' regular, overtime, and doubletime pay. Clicking the drop-down menu will allow you to select from QuickBooks payroll wage items.

  • Regular Payroll Wage Item - Define which payroll wage item Regular time defaults to.
  • Overtime Payroll Wage Item - Define which payroll wage item Overtime defaults to.
  • Overtime 2 Payroll Wage Item - Define which payroll wage item Overtime 2 (Doubletime) defaults to. If employees do not accrue Doubletime or Overtime 2, it is common practice to set this to the same wage item as Overtime.

If you need to specify alternate payroll wage items for certain circumstances, you can refer to the "Map Payroll Wage Item to" option.

Mappings

  • Include vendors in employee list - Enabling will add vendors created within QuickBooks to the employee mapping list in AccountLinx
  • Map Payroll Wage Item to - Specify what the payroll wage item should be associated to when exporting. This will add a set of Regular/Overtime/Overtime2 columns to the respective entity mapping window. For more information about alternative payroll wage items, you can refer to the dedicated article.
    • If you pay based on an employee's hourly wage, choose "Employees".
    • If pay is based on which customer site employees work at, choose "Location".
    • If you pay based on what activities (service items) your employees are performing at any given time, choose "CostCode".
  • Map class to - Select the type of item you use classes (or subgroups) with.
    • Typically, classes are defined for Customers/Vendors, describing individual sub-jobs or sites for that customer or vendor. In that case, you would choose "Location". If you instead define classes based on activities (service items), choose "CostCode".
    • This will add a class column to the respective entity mapping window
  • Map billable to - If billable hours are associated with Customers, choose "Location". If billable hours are associated with Activities (service items), choose "CostCode".
    • This will add a billable column to the respective entity mapping window
  • Export as billable hours: Select which hours are considered to be billable to your customers by checking Regular, Overtime, and/or Overtime 2 boxes.

The most commonly used settings are mapping Wage item to Employee and mapping Class to Location.

Export Options

ALX_-_QuickBooks_-_Exporter_Settings_-_01.png

Auto-Map

  • Map as billable - Marks any Location or Cost Code as billable when mapped using the "Auto-Map" function
  • Map class as - Choose what class is used for mapping when using the "Auto-Map" function
  • Include QuickBooks Customer in Location Match - Automatically map customers that match ExakTime Connect Locations (in addition to jobs)

Comments/Notes Export

Select the type (Employee, Location, Cost Code, or Time Record) of notes or comments to include with each time record during exports.

For example:

  • If set to Location, the comment section for the location details will be exported to QuickBooks for any time record using the location.

    Export-Comments.png

  • Location comments as they appear in QuickBooks under Employee > Enter Time > Use Weekly TimeSheet

    QB_Comments_Notes.png

Error Export Options

  • Location mapping required - Enable to require all active Locations be mapped before an export can be successfully executed
  • Cost Code mapping required - Set to require all active Cost Code to be mapped before completing a successful export

If left disabled, any data not mapped will be absent from QuickBooks after exporting. Turning on these features is a good way to have AccountLinx notify you when an export is attempted containing locations or Cost Codes that are not mapped but in use.

Location and Cost Code Export

  • Export Location as Service items and Cost Code as Job/Customer - Switch Locations to map to QuickBooks Service Items and Cost Codes to map to QuickBooks Jobs/Customers

Expense Export Options

ALX_-_QuickBooks_-_Exporter_Settings_-_02.png

If enabled, allows you to export ExakTime expenses as adjustment register items in QuickBooks.

To enable expense exporting, you must:

  • Enable "Export ExakTime Expenses as Adjustment Register Items"
  • Select the Adjustment Register Account.
  • Select the "Pay to the Order"
  • Select the "Add Check Number As" format

To export your expenses, the employee must have time records and expenses. You will see them with an icon like below:

QuickBooksALXExpenseSelection_-_01.png

You will also need to map your expenses as well. The process for mapping expenses is similar to mapping employees/locations/cost codes.

ALX_-_QuickBooks_-_Expenses_-_01.png

ALX_-_QuickBooks_-_Expenses_-_03.png

Exporting Time Records

After configuring and mapping, you should now be able to export into QuickBooks. The process for exporting time records is covered in the following dedicated article.

Reviewing Exported Time Records in QuickBooks

Exported records can be found in QuickBooks under Employees>Enter Time>Use Weekly TimeSheets.

While you are able to manipulate the time data in QuickBooks, we recommend not adjusting them for data consistency.

use_weekly_timesheet.png

Was this article helpful?
1 out of 2 found this helpful