Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

COST CODES 1

COST TYPES

Tri Left Arrow Green

COST CODES (TASKS) CATEGORIES

PROJECTS

Erp Orange Arrows

Erp Green Arrows

JOBS

SUB JOBS

Erp Orange Arrows

Erp Green Arrows

SUB JOBS

COMPANIES 5

Erp Orange Arrows

Erp Green Arrows

AP VENDORS

BUDGET 4

Erp Orange Arrows

Erp Green Arrows

JOB ESTIMATE

BUDGET MODIFICATIONS

Erp Orange Arrows

REVISION

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS

Erp Orange Arrows

PURCHASING SUBCONTRACTS & PURCHASE ORDERS

COMMITMENT CHANGE ORDERS (CCOs)

Erp Orange Arrows

COMMITMENT CHANGE ORDERS

PRIME CONTRACT

Erp Green Arrows

PROJECT CONTRACT

PRIME CONTRACT CHANGE ORDERS (PCCOs)

Erp Orange Arrows

PROJECT CHANGE ORDER

DIRECT COSTS 6

Erp Green Arrows

GENERAL LEDGER
PC COST TYPES (CUSTOM)
PC ACCOUNT TYPE (CUSTOM)

SUBCONTRACTOR INVOICES

Erp Orange Arrows

BILLS

COMMITMENT PAYMENTS ISSUED 2

Erp Orange Arrows

Erp Green Arrows

BILL PAYMENTS 3

1 Project level cost codes must be added to the project from the Company level ERP Standard Cost Code List. New cost codes must be created in your ERP system, and cannot be created in Procore. Custom WBS Segments are NOT supported.

2 Export of payment records from Procore to Sage Intacct® is only supported for customers in the United States who license Procore Pay.

3 Import of payment records from Procore to Sage Intacct® is only supported for customers in the United States.

4 Budgets containing line items with $0 values can be exported from Procore to Sage Intacct®.

5 Import companies by type, including those without a specified company type from Sage Intacct® to Procore.

6 Import direct cost transactions for payroll and expense up to the end of the current month.

Projects/Jobs

When a Project is exported from Procore to Sage Intacct®, an import file is created for the Job Cost module. This import file is then run on the Sage Intacct® server automatically to create the Job record in Sage Intacct®. This import file contains 3 types of records.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Sage Job ID

Erp Orange Arrows

Erp Green Arrows

Job 1

Project Name

Erp Orange Arrows

Erp Green Arrows

Job Name

Cost Code 2

Code
Description

Erp Orange Arrows

Erp Green Arrows

Cost Code
Tasks
Description

Cost Type
Cost Code
Cost Type ID

Erp Orange Arrows

Erp Green Arrows

Cost Type
Cost Code
Cost Types

Start Date

Erp Orange Arrows

Erp Green Arrows

Begin Date

Completion Date

Erp Orange Arrows

Erp Green Arrows

End Date

1 Export note: The Sage Job ID is entered manually by an accounting approver when a project is exported from Procore to Sage Intacct®. This may or may not, depending on what the accounting approver has entered, match the Job Number found in Procore under the project-level Admin tool. This is stored as the Sage Job ID (you can view it in the company-level ERP Integrations tool under the Synced section of Jobs) and is then used on other project-related exports such as Budgets, commitments, etc. Import note: If the job is imported from Sage Intacct®, the job ID will automatically populate in the project number field.

2 Both Standard and Project-specific cost codes, which can be created in Sage Intacct®, are synced up to the Project Cost Code list in Procore. Project-specific codes are displayed in blue. Custom WBS Segments are NOT supported.

Sub Jobs

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Code

Erp Orange Arrows

Erp Green Arrows

Sub Job

Sub Job

Erp Orange Arrows

Erp Green Arrows

Description

Cost Code 1, 2
Code
Description

Erp Orange Arrows

Erp Green Arrows

Cost Code
Task
Description

Cost Type
Cost Code
Cost Type ID

Erp Orange Arrows

Erp Green Arrows

Cost Type
Task
Cost Types

1 Both Standard and Project-specific cost codes (which can be created in Sage Intacct® manually under Setup in Cost Codes) are synced up to the Project Cost Code list in Procore. Project-specific codes are displayed in blue.

2 Project level cost codes must be added to the project from the Company level ERP Standard Cost Code List. New cost codes must be created in your ERP system, and cannot be created in Procore.

Vendors

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

ERP Vendor ID 1

Erp Orange Arrows

Erp Green Arrows

Vendor ID

Name

Erp Orange Arrows

Erp Green Arrows

Name

Address

Erp Orange Arrows

Erp Green Arrows

Address

City

Erp Orange Arrows

Erp Green Arrows

City

State

Erp Orange Arrows

Erp Green Arrows

State

ZIP

Erp Orange Arrows

Erp Green Arrows

Zip Code/Post Code

Business Phone

Erp Orange Arrows

Erp Green Arrows

Primary Phone

Business Fax

Erp Orange Arrows

Erp Green Arrows

Fax

Email Address

Erp Orange Arrows

Erp Green Arrows

Email Address

Website

Erp Orange Arrows

Erp Green Arrows

URL

1 Export note: The ERP Vendor ID is entered manually by an accounting approver when a company is exported from Procore to Sage Intacct®. This is stored as the ERP Vendor ID (you can view it in the company-level ERP Integrations tool under Vendors or in the company-level Directory tool) and is then used on other vendor-related exports (Commitments, CCOs).

Budgets

A Budget is exported from Procore to Sage Intacct® as the Workflow type Original.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Original Budget

Erp Orange Arrows

Erp Green Arrows

Original Estimate

Cost Code

Erp Orange Arrows

Erp Green Arrows

Cost Code

Cost Type

Erp Orange Arrows

Erp Green Arrows

Cost Type

Budget Modifications

When a Budget Modification is exported from Procore to Sage Intacct® as the Workflow type Revision.

 Phased Release: Budget Changes

Some ERP integrated clients may have already transitioned from Budget Modifications (Legacy) to the new Budget Changes experience. The legacy experience will continue to be available until November 2024. To learn more about the timeline for migration, see Common Questions.


Choosing to use the new Budget Changes experience will not impact the function of your ERP integration.
You should still thoroughly review the available documentation before migrating to the new experience. We recommend you also discuss any concerns or questions about migrating your Budget Modifications to Budget Changes with your Procore point of contact .


To learn more about the new Budget Changes experience, see About Budget Changes.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Project

Erp Orange Arrows

Job

Project Name

Erp Orange Arrows

Job Name

From/To

Erp Orange Arrows

Cost Code ID

From/To

Erp Orange Arrows

Cost Code Name

From/To

Erp Orange Arrows

Cost Type ID

From/To

Erp Orange Arrows

Cost Type Name

Amount

Erp Orange Arrows

Transfer Amount

Commitments

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Commitment Header

Commitment Header

Contract #

Erp Orange Arrows

Document Number

Commitment Type 1

Erp Orange Arrows

Transaction Type

Contract Company 2

Erp Orange Arrows

Vendor

Export Date

Erp Orange Arrows

Date

Title

Erp Orange Arrows

Message

Commitment Item (Purchase Orders)

Commitment Item

Sage Job ID

Erp Orange Arrows

Project

Cost Code

Erp Orange Arrows

Task/Cost Code

Cost Type

Erp Orange Arrows

Cost Type 3

Description

Erp Orange Arrows

Memo

Qty

Erp Orange Arrows

Quantity

Unit is populated from the base UOM on the Sage Intacct® Item ID.

Unit

Unit Cost

Erp Orange Arrows

Price

Amount

Erp Orange Arrows

Extended Price

Default Retainage 4

Erp Orange Arrows

Retainage Percentage

Commitment Item (Subcontracts)

Commitment Item

Sage Job ID

Erp Orange Arrows

Project

Cost Code

Erp Orange Arrows

Task/Cost Code

Cost Type

Erp Orange Arrows

Cost Type 3

Description

Erp Orange Arrows

Memo

Amount

Erp Orange Arrows

Extended Price

Default Retainage 4

Erp Orange Arrows

Default Retainage Percentage

1 When a commitment is created in Procore, you must select a type: Purchase Order or Subcontract. This is used as the purchasing transaction for Sage Intacct®.

2 The Contract Company must be ERP synced.

3 The Item ID is populated from the Sage Intacct® Cost Type’s default item.

4 Default Retainage (Header) populates the Sage Intacct® Retainage Percentage on the line entry.

Commitment Change Orders

When entering the SOV for a Commitment Change Order in Procore, you have the option of selecting an existing line item or entering a new line item.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Commitment Change Order Header

Commitment Change Order Header

Title

Erp Orange Arrows

Message

System Date at Time of Export

Erp Orange Arrows

Date

Change Order Number

Erp Orange Arrows

External Reference No

Commitment Change Order Item (Purchase Order or Unit/Quantity Based Subcontract)

Commitment Change Order Item

Item ID 1

Qty

Erp Orange Arrows

Unit

Contract Amount or Subtotal

Erp Orange Arrows

Extended Price

Commitment Change Order Item (When New Line Item is Selected Entering the SOV on the CCO)

Commitment Change Order Item

Sage Intacct®

ID

Erp Orange Arrows

Item ID

Qty 2

Erp Orange Arrows

Quantity

Unit Cost 2

Erp Orange Arrows

Unit Cost

UOM 2

Erp Orange Arrows

Unit

Contract Amount or Subtotal 3

Erp Orange Arrows

Extended Price

1 This field gets pulled from the Cost Type.

2 Typically, Quantity, Units, and Unit Cost are only used on Purchase Orders.

3 The field is titled Contract Amount when working in a Subcontract, and it is titled Subtotal when working in a Purchase Order.

Prime Contract

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

General

Project Contract Information

Contract #

Erp Green Arrows

Project Contract ID

Title

Erp Green Arrows

Project Contract Name

Contract #

Erp Green Arrows

Project

Description

Erp Green Arrows

Description

Status

Erp Green Arrows

Status

Date Created

Erp Green Arrows

Assigned based on the date imported

Schedule of Values

Project Contract Lines

Description

Erp Green Arrows

Line ID + Line Name

Project ID

Erp Green Arrows

Project ID

Amount

Erp Green Arrows

Original Price

Prime Contract Change Orders

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

PCCO General

Project Change Order

Project # + PCCO #

Erp Orange Arrows

Project Change Order ID

Project #

Erp Orange Arrows

Project

Status = ‘Approved’

Erp Orange Arrows

Change Request Status Name

Transaction Date

Erp Orange Arrows

Project Change Order Date

Default Item ID

Erp Orange Arrows

Item ID

PCCO General

Project Change Request

Status = ‘Approved’

Erp Orange Arrows

Change Request Status Name

Project #

Erp Orange Arrows

Project

Transaction Date

Erp Orange Arrows

Change Request Date

‘CR’ + Project ID + PCCO #

Erp Orange Arrows

Change Request ID

Contract #

Erp Orange Arrows

Project Contract ID 1

Contract SOV Origin Code*

Erp Orange Arrows

Project Contract Line ID 1

Description

Erp Orange Arrows

Scope

Title

Erp Orange Arrows

Description

PCCO Schedule of Values

Project Change Request Entries

Project #

Erp Orange Arrows

Project

Cost Code

Erp Orange Arrows

Task ID

Cost Type

Erp Orange Arrows

Cost Type ID

Amount

Erp Orange Arrows

Cost

Amount

Erp Orange Arrows

Price

Quantity

Erp Orange Arrows

Quantity

UOM

Erp Orange Arrows

Unit

Contract Item Code 2

Erp Orange Arrows

Project Contract ID

Line ID + Description

Erp Orange Arrows

Memo

Revenue Markup Amount

Erp Orange Arrows

Price Markup Amount

Prime Contract Schedule of Values

Project Contract Line

Contract #

Erp Orange Arrows

Project Contract ID

Contract SOV Origin Code

Erp Orange Arrows

Project Contract Line ID

Transaction Date

Erp Orange Arrows

Contract Line Date

Default Account Number

Erp Orange Arrows

Account Number

Project #

Erp Orange Arrows

Project

Default Item ID

Erp Orange Arrows

Item ID

Contract SOV Line ID

Erp Orange Arrows

Scope

System date assigned at time of export

Erp Orange Arrows

Price Effective Date

1 Project Contract Line ID will only display if all Project Contract IDs are the same.

2 If the option to create a new line item on the prime contract was selected during the entry of the PCO in Procore, the accounting approver will be prompted to assign the new Contract item ID number at the time of export. The following special characters are not accepted by Sage Intacct®: ~`!@#$%^&*()-+={[}]|:;"'<,>? The following special characters are accepted by Sage Intacct®: _ . /

Job Costs

Import from Sage Intacct® only. Cost information is retrieved from Sage Intacct® for each Cost Code/Type on Synced projects for use in 2 locations in Procore, the Budget and the Job Costs report.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Budget

JTD Cost

Erp Green Arrows

JTD Cost

Direct Costs

Erp Green Arrows

JTD Cost - Commitment Invoiced 1

Job Costs Report

Cost Code

Erp Green Arrows

Cost Code

Cost Type

Erp Green Arrows

Cost Type

Commitment Invoiced

Erp Green Arrows

Commitment Invoiced

Job to Date Cost

Erp Green Arrows

JTD Cost

Job to Date Dollars Paid

Erp Green Arrows

JTD Dollars Paid

Month to Date Cost

Erp Green Arrows

MTD Cost

Month to Date Dollars Paid

Erp Green Arrows

MTD Dollars Paid

1 This is a calculated column that displays the difference between the two database fields in Sage Intacct®.

Job Cost Transaction Details

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Direct Cost Type

Cost Type

Invoice

Erp Green Arrows

Non-Commitment Invoices

Subcontractor Invoice

Erp Green Arrows

Commitment Invoices

Payroll

Erp Green Arrows

Payroll Expense

Expense

Erp Green Arrows

Misc Expense

Direct Cost General Information

Vendor

Erp Green Arrows

Vendor Record Number

Terms

Erp Green Arrows

Term Name for Commitment and Non-Commitment Invoices

Date

Erp Green Arrows

Posting Date
(Payroll & Expenses)


Transaction Date
(Invoices & Subcontractor Invoices)

Received Date

Erp Green Arrows

Posting Date
(Payroll & Expenses)


Transaction Date
(Invoices)

Status

Erp Green Arrows

Status (only transactions with a status of 'Approved' are imported)

Invoice #

Erp Green Arrows

Record ID

Description

Erp Green Arrows

Description

Detailed Line Information

Budget Code

Erp Green Arrows

Track Record Number

Amount

Erp Green Arrows

Amount

Subcontractor Invoices

Line items on subcontractor invoices are automatically marked as 'Billable' in Sage Intacct® upon export if the invoice is linked to a customer in Sage Intacct®.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Header

Contract Company

Erp Orange Arrows

Vendor

ERP ID 1

Erp Orange Arrows

Bill Number

Description 2

Erp Orange Arrows

Description

Billing Date

Erp Orange Arrows

Invoice Date

Total Completed and Stored to Date

Erp Orange Arrows

Original Amount

Total Retainage

Erp Orange Arrows

Amount Retained

Accounting Date 3

Erp Orange Arrows

Acct Date

Distributions

Project #

Erp Orange Arrows

Job

Cost Code

Erp Orange Arrows

Cost Code

Budget Code

Erp Orange Arrows

Cost Type

Work Completed this Period

Erp Orange Arrows

Amount

Work Retainage

Erp Orange Arrows

Amount Retained

1 The Invoice Number from the Subcontractor Invoice entered in Procore will prefill into the ERP ID field on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices; however, the accounting approver can modify this before the Invoice is exported from Procore to Sage Intacct®. The value that was entered in the ERP ID field at the time of export is stored as the Sage Intacct® ID (you can view it in the Synced section in the ERP Integrations tool under Subcontractor Invoices).

2 The description for an invoice that will be created in Sage Intacct® can be entered into the Description field by an accounting approver on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices. If no description is entered at the time of export, the Description field will be blank on the invoice created in Sage Intacct®.

3 This is filled automatically based on the Billing Date of the Invoice in Procore, but can be overridden at the time of export on the Ready to Export screen in the ERP Integrations tool under Subcontractor Invoices.

Commitment Payments Issued

Commitment Payments Issued imported from Sage Intacct® only for synced subcontractor invoices. To sync a payment from Sage Intacct® to Procore, you must record a Document Number for the payment in Sage Intacct®. Payments without a Document Number will not sync. Not available in Canada or APAC at this time.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Check Number

Erp Green Arrows

Check Number

Invoice Number

Erp Green Arrows

Invoice Number

Payment Method

Erp Green Arrows

Payment Method

Amount

Erp Green Arrows

Amount

Date

Erp Green Arrows

Date

Procore Pay Payments

 General Availability in Select Markets (United States)

Flag Us Procore Pay is available in the United States. It is designed for General Contractors and Owner-Builders who act as their own General Contractors on a job. Procore Pay extends the Invoice Management functionality in the Procore web application to handle the payment process between general and specialty contractors.

PROCORE

Exports data from Procore to Sage Intacct®

Imports data from Sage Intacct® to Procore

Sage Intacct®

Payment Status

Erp Orange Arrows

Payment Status 1

Amount

Erp Orange Arrows

Erp Green Arrows

Payment Txn Amount

Date Payment Funded

Erp Orange Arrows

Erp Green Arrows

Payment Date

Payment Method

Erp Orange Arrows

Erp Green Arrows

Payment Method

Bank ID

Erp Orange Arrows

Checking Account ID

Check Number

Erp Orange Arrows

Erp Green Arrows

Document or Check No.

Vendor ID

Erp Orange Arrows

Erp Green Arrows

Vendor ID

Invoice No.

Erp Green Arrows

Invoice No.

1 Payments in Sage Intacct® must be in an 'Approved' status before they can be imported into Procore.