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 |
|
| JOBS COST CODES COST TYPES |
SUB JOBS |
| PHASES 1 | |
COMPANIES 8 |
|
| AP VENDORS |
BUDGET 2, 7 |
|
| BUDGET |
COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs) PO CHANGE ORDERS (CCOs) |
| COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS SUBCONTRACT CHANGES APPENDED TO ORIGINAL PURCHASE ORDER | |
JOB COSTS COMMITTED COSTS (ACTUAL) 3 JTD COST DIRECT COSTS |
| COSTS COMMITTED COSTS (INVOICED) 3 JTD COST JOB COST TRANSACTIONS | |
SUBCONTRACTOR INVOICES 4,6 |
| 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 |
|
| Job ID1 |
Project Name |
|
| Job Name |
Address |
|
| Job Address |
City |
|
| Job City |
State |
|
| Job State |
ZIP |
|
| Job Zip |
Cost Codes & Types3 |
|
| 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 |
| Phase Number | |
Sub Job Name |
| 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 |
|
| Vendor Record Number |
Name |
|
| Name |
Address |
|
| Address |
City |
|
| City |
State |
|
| State |
ZIP |
|
| 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.
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 |
|
| Budget Amount |
Cost Code |
|
| Cost Code |
Cost Type |
|
| Cost Type |
Budget Modifications Cost Code Cost Type |
| Budget Amount Cost Code Cost Type |

