Keep your systems in sync, reduce data entry mistakes, and streamline your operations in the field and the office with Arcoro modules and Sage Intacct. Integrations between both platforms make it easy to manage employee data with features like:
- Full round-trip synchronization between systems (Importing/Exporting employee and company information)
- Push employee and time data to Sage Intacct, on demand, to complete payroll.
- Keep Benefit Deductions, Direct Deposit, Taxes, and more in sync.
Table of Contents
- Requirements
- Enabling the Integration
- Data Mapping
- Sage Intacct to Arcoro
- Arcoro to Sage Intacct
- What the Integration Does Not Do
- FAQs
Requirements
- Sage Intacct (Construction) with a Web Services user, Company ID, and Entity ID
- The Arcoro Integrations customization package installed in Sage Intacct. It adds an "Arcoro Identifier" field on timesheets and timesheet lines, and the optional "Certified" field on projects.
- Sage Intacct general ledger journal, accounts, locations, projects, and tasks already set up
- An Arcoro Payroll company, business unit, and pay schedule
- A Time Type Mapping from Arcoro pay types to Sage Intacct time types (required)
Enabling the Integration
In Arcoro Integrations, set up two connections:
- Sage Intacct (Sage Intacct For Arcoro Payroll Configuration): Company ID, Web Services User ID, Entity ID, Arcoro Location source, General Ledger Journal ID, Time Type Mapping, timesheet status, general ledger entry state, plus the optional Standard Cost Types and union settings.
- Arcoro Payroll (Payroll For Sage Intacct): Payroll company ID and business unit, plus the optional pay schedule and pay date.
Each time information is sent, the administrator chooses the pay schedule and pay date, enters the GL Reference Number, and can include or exclude specific employees.
Data Mapping
Sage Intacct to Arcoro
Employee Information
Employee information starts in Sage Intacct and lands in Arcoro each time information is brought over.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Employee ID | Sage Intacct employee ID |
Arcoro employee identifier |
Used to match the person on later runs. |
| First, middle, and last name, prefix | Employee's primary contact | Arcoro employee name | |
| Social Security number | Sage Intacct employee | Arcoro employee | Protected and hidden in logs. |
| Date of birth | Sage Intacct employee | Arcoro employee | Protected. |
| Gender | Sage Intacct employee | Arcoro employee | Male and Female come across. Anything else is left blank. |
| Hire date and termination date | Sage Intacct start date and end date | Arcoro hire and termination dates | |
| Job title | Sage Intacct job title | Arcoro title | |
| Termination reason | Sage Intacct termination type | Arcoro termination reason | One of five fixed values: deceased, disability, involuntary, retired, voluntary. |
| Active or inactive | Sage Intacct status | Arcoro active flag | Active only when Sage Intacct shows "active". |
| Employment status | Worked out from Sage Intacct data | Arcoro employee status | Retired termination type becomes Retired. Any end date becomes Terminated. An employee type containing "Full" becomes Full Time; containing "Part" becomes Part Time. Anything else is Undefined. |
| Work and personal email | Contact email 1 and email 2 | Arcoro work and home email | Personal email is protected. |
| Work, home, mobile, pager, and fax phone | Contact phone numbers | Arcoro phone numbers | |
| Home address | Contact mailing address | Arcoro home address | Marked as the preferred address. |
Organization Assignment
Assignments start in Sage Intacct and land on the person in Arcoro each time information is brought over.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Business unit | Sage Intacct Location dimension on the employee | Arcoro business unit | Always brought over, regardless of other settings. |
| Work location | Location dimension, or the project Ship To contact | Arcoro primary work location | Depends on the "ArcoroLocation" setting. With Location Dimension (the default), an employee with no location is skipped and an error is shown. With Project Contact Ship To, a location is not required. |
| Department | Sage Intacct department | Arcoro department | Can be turned off. |
| Employee type | Sage Intacct employee type | Arcoro employee type | Can be turned off. |
| Position | Sage Intacct position | Arcoro current position | Can be turned off. |
| Labor classification | Sage Intacct Class dimension | Arcoro labor classification | Set as the primary labor class. Can be turned off. |
Pay Rates
Pay information starts on the Sage Intacct employee and lands in Arcoro each time information is brought over.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Pay type | Employee's earning type | Arcoro primary compensation type | An earning type calculated hourly becomes Hourly. Anything else becomes Salary. |
| Hourly rate | First employee rate that has not expired | Arcoro cost of labor per hour | |
| Annual salary | First employee rate that has not expired | Arcoro annual salary |
Contractors
Contractors are Sage Intacct employees whose employee type is "Contractor". They follow the same rules as employees for name, SSN, date of birth, phone numbers, address, department, business unit, labor class, and hourly rate, plus the items below.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Tax ID (EIN) | Sage Intacct employee tax ID | Arcoro contractor | Protected. |
| Start and termination dates | Sage Intacct start date and end date | Arcoro contractor start and termination dates |
Not included in this group: prefix, personal email, gender, title, position, annual salary.
Jobs, Cost Codes, and Company Lists
Company lists start in Sage Intacct and land in the matching Arcoro lists each time information is brought over.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Jobs | Sage Intacct projects, including parent and child projects | Arcoro jobs | Up to 10 levels of child projects. A job is active when its project status allows time entry. Certified comes across only if the Arcoro "Certified" field is installed on Sage Intacct projects. |
| Cost codes | Sage Intacct tasks | Arcoro cost codes | In progress and On hold are active. Not started, Planned, and Completed are inactive. A task shared across projects comes in once. The "Standard Cost Types" setting can limit which tasks come in. |
| Cost types | Sage Intacct cost types | Arcoro cost types | Each comes in once even when used on many tasks. When a task has exactly one matching cost type, it is attached to the cost code. When it has several, none is attached and a warning is shown. |
| Departments, employee types, labor classes, business units, work locations | Sage Intacct lists | Matching Arcoro lists | Records with no ID or name, or with duplicate names, are skipped. A work location without a complete street, city, state, and ZIP is skipped. |
| Unions, union locals, union classes | The Sage Intacct list the administrator chooses (Labor Union, Labor Shift, or Labor Class) |
Arcoro union lists | Off by default ("Not Supported"). |
Arcoro to Sage Intacct
Employees and Contractors
People start in Arcoro Payroll and land in Sage Intacct as a contact plus an employee record each time information is sent. A person is matched first by employee ID, then by contact name; with no match, a new record is created.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Employee ID | Arcoro | Sage Intacct employee ID |
Set only when the person is created. Cannot contain apostrophes, underscores, or spaces. |
| Contact name | Arcoro ID and name | Sage Intacct contact ID | Built as "ID - First Middle Last Suffix". Set only when the person is created. |
| Print-as name | Arcoro name | Sage Intacct "Print As" | First name, middle initial, last name, suffix. |
| First, middle, and last name | Arcoro | Sage Intacct contact | First and last name are required or the person is skipped. |
| Social Security number | Arcoro | Sage Intacct employee | Required for employees and individual contractors. Numbers only. |
| Tax ID (EIN) | Arcoro | Sage Intacct contact tax ID | Business contractors only, where it is required. |
| Date of birth, hire date, termination date | Arcoro | Sage Intacct employee | A hire date on or before the birth date is rejected. A termination reason with no termination date is rejected. |
| Gender | Arcoro | Sage Intacct employee | Male and Female only. Nonbinary is left blank. |
| Job title | Arcoro title | Sage Intacct job title | Employees only. |
| Active or inactive | Arcoro | Sage Intacct contact and employee status | |
| Phone, email, home address | Arcoro | Sage Intacct contact | Clearing a value in Arcoro clears it in Sage Intacct. Contractor email is shortened to 254 characters. |
| Business unit | Arcoro business unit | Sage Intacct location | Matched by location ID first, then by name. Required for employees. With no match, the person is skipped. |
| Department | Arcoro department | Sage Intacct department | Matched by name. With no match, a warning is shown and the person is still sent. |
| Labor classification | Arcoro primary labor class | Sage Intacct class | Same matching and warning as department. |
| Contractor flag | Arcoro contractor record | Sage Intacct employee type | Contractors are always set to the "Contractor" employee type. |
| Contractor work location | Arcoro primary work location | Checked against Sage Intacct locations |
Required for contractors and must match a Sage Intacct location name. |
Not included in this group: employee type for employees, position, termination reason (checked, not sent), pay rates, pay schedule, workers' compensation code.
Time Cards
Time cards from the selected pay run start in Arcoro Payroll and land as Sage Intacct timesheets each time information is sent.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Timesheet period | Pay period start and end | Timesheet begin date and posting date | Both are required. |
| Employee | Arcoro employee ID | Timesheet employee | Must already exist in Sage Intacct. |
| Timesheet status | Connection setting | Timesheet state | Draft (default) or Submitted. Anything else falls back to Draft. |
| Hours | Time card hours | Timesheet line quantity | Lines with the same day, project, task, location, and time type are added together. |
| Work date | Time card work date | Line date | Salaried time with no date uses the first day of the period. |
| Project | Arcoro job code | Line project | Must be an active Sage Intacct project. |
| Task | Arcoro cost code | Line task | Must be active and assigned to that project. |
| Location | Arcoro business unit | Line location | Same matching as employees. |
| Time type | Arcoro pay type | Line time type | Converted using the "Time Type Mapping" setting. Only Hourly, Overtime, Double Overtime, Salaried, Paid Holiday, Paid Time Off, and Sick are sent; other pay types are skipped without an error. |
| Billable | Not taken from Arcoro | Line billable flag | Always No. |
Good to know: each time, timesheet lines Arcoro created earlier that are no longer in the pay run are removed. Lines someone entered by hand in Sage Intacct are never merged or removed; a conflict with one is reported as an error on that entry.
General Ledger
After the pay run, the payroll general ledger starts in Arcoro Payroll and lands as one new journal entry in Sage Intacct each time it is sent.
| Field | Field Source | Field Destination | Notes |
|---|---|---|---|
| Journal | "General Ledger Journal ID" setting |
Journal entry journal | Required and must exist. |
| Reference number | "GL Reference Number" entered when sending | Journal entry reference number | Required. If an entry with that number already exists, nothing is sent. |
| Posting date | Pay date | Posting date | |
| Description | Pay schedule and pay date | Entry description | For example, "Payroll: Weekly - 2026-10-16". |
| Entity | "Entity ID" setting | Base location | |
| Entry status | "General Ledger Entry State" setting |
Entry and line state | Draft (default) or Posted. |
| Amount and debit or credit | General ledger line | Line amount and type | Rounded to the cent. Each entry needs at least two lines. |
| GL account | GL mapping account number | Line account | Must exist in Sage Intacct. |
| Line description | Line type and name | Line memo | |
| Employee | Line's employee | Employee dimension | Must be active in Sage Intacct and employed as of today. |
| Location | Business unit name in Arcoro at the time of sending | Location dimension | Required. Matched by name, so a renamed business unit must still match the Sage Intacct name. |
| Department | Department name | Department dimension | Optional. |
| Project, task, cost type | Job, cost code, cost type | Project, task, and cost type dimensions | Optional. The task must belong to the project, and the cost type must be linked to the task. |
| Currency | Not taken from Arcoro | Currency | Always USD at an exchange rate of 1. |
What the Integration Does Not Do
- Does not update or replace a general ledger entry. Each send creates a new entry. Resending a pay run needs a new GL Reference Number, and the earlier entry must be corrected in Sage Intacct by hand.
- Does not post in any currency other than USD.
- Does not send timesheets as Approved. Draft or Submitted only.
- Does not send time with pay types outside the seven listed in 6g. Those lines are skipped quietly.
- Does not bring in people terminated more than a year ago.
- Does not send pay rates, pay schedules, positions, termination reasons, or workers' compensation codes to Sage Intacct.
- Does not send non-binary gender in either direction.
- Does not bring in union lists unless an administrator turns them on.
- Does not create projects, tasks, accounts, journals, locations, or departments in Sage Intacct. They must already exist.
FAQs
- Can I re-send a pay run's general ledger?
Yes, with a new GL Reference Number. The first entry stays in Sage Intacct.
- Will it overwrite timesheet lines my team entered in Sage Intacct?
No. Only lines Arcoro created are changed or removed.
- Do contractors need special setup in Sage Intacct?
Yes. Give them the "Contractor" employee type.
- Can timesheets arrive approved?
No. Draft or Submitted only.
- Can journal entries post automatically?
Yes. Set "General Ledger Entry State" to Posted. The default is Draft.