VeriClock & Sage 100 Contractor Accounting Integration Setup Guide

This guide explains how to connect VeriClock with Sage 100 Contractor using the VeriClock Companion App. Once configured, approved time captured in VeriClock can be exported into Sage 100 Contractor for payroll processing and job costing.

This integration is commonly used by construction and field service organizations that rely on Sage 100 Contractor to manage payroll, labor costing, and project accounting.

Overview

The VeriClock + Sage 100 Contractor integration allows you to:

• Connect your Sage 100 Contractor company file to VeriClock
• Map (bind) employees and related records between both systems
• Preview payroll exports before posting
• Sync approved time entries into Sage 100 Contractor

The integration uses the VeriClock Companion App, which securely communicates between your Sage 100 Contractor environment and the VeriClock platform.

Step 1 – Enable Sage 100 Contractor Integration in VeriClock

1. Log in to the VeriClock web portal
2. Navigate to Integrations
3. Select Sage 100 Contractor

4. Click Save at the bottom left

   
   

Step 2 – Download and Install the Companion App

1. Download the latest VeriClock Companion App

2. Run the installer

If prompted by Windows (blue window):

• Click More Info, then
• Select Run Anyway

 

💡 After installation, the Companion App will launch automatically.
💡 In the future, you can launch it directly from VeriClock.

Step 3 – Connect to Sage 100 Contractor (SQL Setup)

Open Sage 100 Contractor and confirm the following when the connection screen appears:

• SQL Server Name
• Authentication Type
• Company Database

Important Notes:

• Do not leave default or blank selections—these must match your Sage environment.
• These fields are often missed—ensure all three dropdowns are reviewed and selected before proceeding

• Incorrect selections will prevent a successful connection to Sage
   

  Select SQL Server Name & Authentication Type:

              Select Company Database:

             Click Connect to secure connection to SQL Server.

Step 4 – Complete VeriClock + Sage Connection

1. Confirm Sage 100 shows Connected in the Companion App
2. In VeriClock, click Launch

3. Click Yes to approve the connection

Once complete, both systems should display as connected.

Step 5 – Sync Sage Data into VeriClock

Before exporting time, core records must be synchronized from Sage into VeriClock.

The following tabs are used:

• Employees
• Jobs
• Service Items (maps to Cost Codes)
• Payroll Items (maps to Pay Types)

For each tab:

1. Select the tab
2. Click Check All
3. Click Synchronize (or Synchronize Everything, depending on configuration)

Important Notes:

• Avoid syncing all records if your Sage environment contains historical or inactive data (e.g., hundreds of old jobs).
• Best practice is to sync only active records that will be used for time tracking in VeriClock.
• When binding records, use the Create option carefully to prevent duplicate entries if similar records already exist in VeriClock.
• If records were previously added manually in VeriClock, ensure names match or confirm before creating new ones.
   

⚠️ All records must be synced before time can be exported.

Step 6 – Preview and Sync Time

Once data has been synchronized, you are ready to export time.

1. Navigate to the Time Activities tab
2. Confirm the sync date range (this controls the exact range of time being exported)
3. (Optional) Adjust the Time Filter:

• All Time (default)
• Approved Time Only
• Unapproved Time Only

4. Click Dry Run to preview the export

If no errors are present:

5. Click Sync Time
 

Important Notes:

• The default filter is All Time. If you are using approvals in VeriClock and only want approved time exported, you must change the filter to Approved Time Only.
• The sync date range is fully configurable—only time within the selected range will be exported.

💡 Only approved time entries in VeriClock will be included in the export.

Step 7 – Verify Time in Sage 100 Contractor

To confirm the sync:

1. Open Sage 100 Contractor
2. Navigate to:
   5-Payroll → 5-Daily Payroll → 1-Daily Payroll Entry
3. Select one of the synced dates

This confirms that approved time from VeriClock has been successfully exported into Sage 100 Contractor

VeriClock → Sage 100 Contractor Field Sync

The integration currently syncs the following information.

Employee Information

• Employee ID (as mapped)
• Associated employee record

Time Data

• Work Date
• Regular Hours
• Overtime Hours
• Total Hours

Payroll Configuration

• Earnings / Pay Type (mapped to the appropriate Sage payroll code)

Job Cost Allocation

• Job Number
• Cost Code

Configuration Context

This integration setup was configured to meet the core payroll and job costing requirements for Sage 100 Contractor clients using VeriClock.

Only the fields shown above are currently configured to transfer.

If your organization requires additional fields to be transmitted (for example):

• Department tracking
• Certified payroll classifications
• Equipment cost allocation
• Memo fields

These requirements can be reviewed and evaluated as part of your integration configuration.

Please contact VeriClock Support to discuss additional field mapping options.

Troubleshooting

If time entries do not export successfully:

• Confirm the VeriClock Companion App is running
• Verify the correct Sage company file is selected
• Check that records are properly bound
• Ensure the selected time period contains approved entries

If issues persist, contact VeriClock Support for assistance.