Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

PROJECTS COST CODES COST TYPES

erp-orange-arrows.png

erp-green-arrows.png

JOBS COST CODES COST TYPES

SUB JOBS

erp-green-arrows.png

PHASES 1

COMPANIES 8

erp-orange-arrows.png

erp-green-arrows.png

AP VENDORS

BUDGET 2, 7

erp-orange-arrows.png

erp-green-arrows.png

BUDGET

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs) PO CHANGE ORDERS (CCOs)

erp-orange-arrows.png

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS SUBCONTRACT CHANGES APPENDED TO ORIGINAL PURCHASE ORDER

JOB COSTS COMMITTED COSTS (ACTUAL) 3 JTD COST DIRECT COSTS

erp-green-arrows.png

COSTS COMMITTED COSTS (INVOICED) 3 JTD COST JOB COST TRANSACTIONS

SUBCONTRACTOR INVOICES 4,6

erp-orange-arrows.png

AP INVOICES

1 If your company is using Sage 100 Contractor® Phases, project budgets must be created in Sage 100 Contractor® and then synced to Procore.
2 Includes budget changes exports.3 Committed costs (invoiced) includes purchase orders and subcontracts tied to an accounts payable invoice.
4 Not supported for Canada at this time due to tax restrictions.
5 Includes Job Costs entered in Sage 100 Contractor® in Menu 1-3 Journal Transaction, 4-2 AP invoice, and 5-2 Payroll (project and budget must be synced).
6 Retainage is supported. Once exported to Sage 100 Contractor® the retainage can be found in the Retainage Held field on the Menu 4-2 AP Invoice.7 Budgets containing line items with $0 values can be exported from Procore to Sage Intacct®. However, budgets exported to Sage Intacct® will not include line items with $0 values.8 Import companies by type, including those without a specified company type from Sage Intacct® to Procore.

Note: Custom WBS Segments are NOT supported.

Projects/Jobs

Job information in Sage 100 Contractor® can be found in 3-5 Jobs. Procore job info is found in the project admin tab.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Project Number

erp-orange-arrows.png

erp-green-arrows.png

Job ID1

Project Name

erp-orange-arrows.png

erp-green-arrows.png

Job Name

Address

erp-orange-arrows.png

erp-green-arrows.png

Job Address

City

erp-orange-arrows.png

erp-green-arrows.png

Job City

State

erp-orange-arrows.png

erp-green-arrows.png

Job State

ZIP

erp-orange-arrows.png

erp-green-arrows.png

Job Zip

Cost Codes & Types3

erp-orange-arrows.png

erp-green-arrows.png

Cost Codes & Types2

1 Export note: The Sage Job ID is entered manually by an accounting approver when a project is exported from Procore to Sage 100 Contractor®. 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) and is then used on other project related exports such as Budgets, commitments etc... Import note: If the job is imported from Sage 100 Contractor®, the job ID will automatically populate in the project number field.

2Export notes: When a project is exported from Procore to Sage 100 Contractor® a shell budget will be created in Sage 100 Contractor® with the cost codes and types that were added to the project in Procore before syncing. To add cost codes to a previously synced ERP project in Procore , click 'Refresh Cost Codes 'in the Project Level Admin tool or export the budget.

3Custom WBS Segments are NOT supported.

Sub Jobs/Phases

Import from Sage 100 Contractor® only. Sub job information is entered in Sage 100 Contractor® via the budget. In Procore, you can find the Sub Job info in the Sub Jobs portion of the project-level Admin - Work Breakdown Structure tool.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Sub Job Number

erp-green-arrows.png

Phase Number

Sub Job Name

erp-green-arrows.png

Phase Name

Vendors

The vendor setup in Sage 100 Contractor® can be found at 4-4 Vendors (Accounts Payable). Procore companies can be found in the Directory.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

ERP Vendor ID1

erp-orange-arrows.png

erp-green-arrows.png

Vendor Record Number

Name

erp-orange-arrows.png

erp-green-arrows.png

Name

Address

erp-orange-arrows.png

erp-green-arrows.png

Address

City

erp-orange-arrows.png

erp-green-arrows.png

City

State

erp-orange-arrows.png

erp-green-arrows.png

State

ZIP

erp-orange-arrows.png

erp-green-arrows.png

Zip

1 Export note: The ERP Vendor ID is entered manually by an accounting approver when a company is exported from Procore to Sage 100 Contractor®. 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, Commitment CO’s).

Budgets

In Sage 100 Contractor®, budgets are accessed from 6-2 Budgets. In Procore, budgets are accessed from project-level Budget tool. Budget modifications export from Procore only. In Procore, budget modifications are accessed from the Budget Modifications column in the project-level Budget tool. They are used to move money from one budget line item to another, most commonly with a zero net effect. In Sage 100 Contractor®, the change(s) will appear as a negative amount to the “From” Cost Code entered in Procore and a positive amount to the “To” Cost Code in Procore in 6-4-1 Change Orders > Budget and Sub Change Details tab.

Detailed Data Mapping Content Reuse for ERP Budget Changes

Beta icon 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 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Original Budget Amount

erp-orange-arrows.png

erp-green-arrows.png

Budget Amount

Cost Code

erp-orange-arrows.png

erp-green-arrows.png

Cost Code

Cost Type

erp-orange-arrows.png

erp-green-arrows.png

Cost Type

Budget Modifications Cost Code Cost Type

erp-orange-arrows.png

Budget Amount Cost Code Cost Type

Commitments

Export from Procore only. When a Subcontract is exported from Procore, a Subcontract is created in Sage 100 Contractor® (6-7-1 Subcontracts ). When a Purchase Order is exported from Procore, a Purchase Order is created in Sage 100 Contractor® (6-6-1 Purchase Orders). In Procore, Commitments are accessed from the project-level Commitments tool.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Subcontracts

Subcontracts

Commitment #

erp-orange-arrows.png

Subcontract #

Contract Amount

erp-orange-arrows.png

Original Subcontract

Contract Company

erp-orange-arrows.png

Vendor

Cost Code

erp-orange-arrows.png

Cost Code

Cost Type

erp-orange-arrows.png

Cost Type

Project Name

erp-orange-arrows.png

Job

Qty (if applicable)

erp-orange-arrows.png

Qty

System Date at Time of Commitment Creation

erp-orange-arrows.png

Subcontract Date

Title

erp-orange-arrows.png

Description

Purchase Orders

Purchase Orders

Commitment #

erp-orange-arrows.png

Order #

Subtotal

erp-orange-arrows.png

Total

Contract Company

erp-orange-arrows.png

Vendor

Cost Code

erp-orange-arrows.png

Cost Code

Description

erp-orange-arrows.png

Description (on detail grid)

Project Name

erp-orange-arrows.png

Job

Qty (if applicable)

erp-orange-arrows.png

Qty

Unit Cost

erp-orange-arrows.png

Price

System Date at Time of Commitment Creation

erp-orange-arrows.png

Subcontract Date

Title

erp-orange-arrows.png

Description

Commitment Change Orders

Export from Procore only.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Subcontract Change Order1

Subcontract Change Order

Project Name

erp-orange-arrows.png

Job

Title

erp-orange-arrows.png

Description

Change Order #

erp-orange-arrows.png

Change #

System Date at Time of Export

erp-orange-arrows.png

Order Date

Contract Amount

erp-orange-arrows.png

Budget Amount1

Company

erp-orange-arrows.png

Vendor

Cost Code

erp-orange-arrows.png

Cost Code

Cost Type

erp-orange-arrows.png

Cost Type

Purchase Order Change Order2

Purchase Order Change Order

Title

erp-orange-arrows.png

Description (first row below pre-existing line items)

Cost Code

erp-orange-arrows.png

Cost Code

Description

erp-orange-arrows.png

Description

Qty

erp-orange-arrows.png

Qty

Unit Cost

erp-orange-arrows.png

Price

Project Name

erp-orange-arrows.png

Job

Contract Amount

erp-orange-arrows.png

Total

1 When a Subcontract Change Order is exported to Sage 100 Contractor®, the export will also update the Budget Amount in Sage 100 Contractor® (6-4-1 Change Orders > Budget and Sub Change Details tab)

2When Purchase Order Change Orders are exported from Procore, new line items are created and added to the corresponding Purchase Order in Sage 100 Contractor®, below pre-existing line items. In Procore, Purchase Order Change Orders are accessed from the Commitment Record in the project-level Commitments tool.

Job Costs

Import from Sage 100 Contractor® only.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Direct Costs

erp-green-arrows.png

Costs entered directly into 6-3 in Sage 1001

ERP Commitment Invoiced Amount

erp-green-arrows.png

Costs entered on an invoice that has been tied to a synced commitment

1 Includes Job Costs entered in Sage 100 Contractor® in Menu 1-3 Journal Transaction, 4-2 AP Invoice, and 5-2 Payroll (project and budget must be synced).

Job Cost Transaction Details

Import from Sage 100 Contractor® only. If this feature is enabled, all posted cost transaction details from Sage 100 Contractor® are imported into the Direct Costs tool for each project. This provides transaction detail for the costs displayed in Procore, and if the budget view is configured properly the values of those transactions can be viewed into the Direct Costs or JTD Cost columns for a budget line item.

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Direct Cost Type

Cost Type

Invoice

erp-green-arrows.png

AP Cost

Subcontractor Invoice

erp-green-arrows.png

AP Cost (with Commitment)

Payroll

erp-green-arrows.png

PR Cost

Expense

erp-green-arrows.png

JC Cost

Direct Cost

Item Date

erp-green-arrows.png

Transaction Date

Status

erp-green-arrows.png

Automatically set to Approved

Description

erp-green-arrows.png

Description

Vendor

erp-green-arrows.png

Vendor (Only for transactions that originate from Accounts Payable)

Invoice #

erp-green-arrows.png

Invoice (Only for transactions that originate from Accounts Payable)

Amount

erp-green-arrows.png

Amount

Subcontractor Invoices

PROCORE

Exports data from Procore to

Sage 100 Contractor®

Imports data from

Sage 100 Contractor®

to Procore

Sage 100 Contractor®

Summary

Header

Billing Period

erp-orange-arrows.png

Posting Period

Invoice #

erp-orange-arrows.png

Invoice #

Billing Date

erp-orange-arrows.png

Invoice Date

Status

erp-orange-arrows.png

Status

Contractor Company

erp-orange-arrows.png

Vendor

Line Items

Distributions

Commitment #

erp-orange-arrows.png

Commitment

Project #

erp-orange-arrows.png

Job

Sub Job #

erp-orange-arrows.png

Phase

Cost Code

erp-orange-arrows.png

Cost Code

Cost Type

erp-orange-arrows.png

Cost Type

Description of Work

erp-orange-arrows.png

Description

Work Completed (This Period) + newly entered Materials Presently Stored1

erp-orange-arrows.png

Amount

1 Retainage is supported. Once exported to Sage 100 Contractor® the retainage can be found in the Retainage Held field on the Menu 4-2 AP Invoice.