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 |
| COST CODES (TASKS) CATEGORIES | |
PROJECTS |
|
| JOBS |
SUB JOBS |
|
| SUB JOBS |
COMPANIES5 |
|
| AP VENDORS |
BUDGET 4 |
|
| JOB ESTIMATE |
BUDGET MODIFICATIONS |
| REVISION | |
COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS |
| PURCHASING SUBCONTRACTS & PURCHASE ORDERS | |
COMMITMENT CHANGE ORDERS (CCOs) |
| COMMITMENT CHANGE ORDERS | |
PRIME CONTRACT |
| PROJECT CONTRACT | |
PRIME CONTRACT CHANGE ORDERS (PCCOs) |
| PROJECT CHANGE ORDER | |
DIRECT COSTS6 |
| GENERAL LEDGER PC COST TYPES (CUSTOM) PC ACCOUNT TYPE (CUSTOM) | |
SUBCONTRACTOR INVOICES |
| BILLS | |
COMMITMENT PAYMENTS ISSUED2 |
|
| BILL PAYMENTS3 |
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 |
|
| Job1 |
Project Name |
|
| Job Name |
Cost Code2 Code Description |
|
| Cost Code Tasks Description |
Cost Type Cost Code Cost Type ID |
|
| Cost Type Cost Code Cost Types |
Start Date |
|
| Begin Date |
Completion Date |
|
| End Date |
1Export 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.
2Both 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 |
|
| Sub Job |
Sub Job |
|
| Description |
Cost Code1,2 Code Description |
|
| Cost Code Task Description |
Cost Type Cost Code Cost Type ID |
|
| Cost Type Task Cost Types |
1Both 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.
2Project 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 ID1 |
|
| Vendor ID |
Name |
|
| Name |
Address |
|
| Address |
City |
|
| City |
State |
|
| State |
ZIP |
|
| Zip Code/ Post Code |
Business Phone |
|
| Primary Phone |
Business Fax |
|
| Fax |
Email Address |
|
| Email Address |
Website |
|
| URL |
1Export 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, Commitment CO’s).
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 |
|
| Original Estimate |
Cost Code |
|
| Cost Code |
Cost Type |
|
| 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 |
| Job | |
Project Name |
| Job Name | |
From/To |
| Cost Code ID | |
From/To |
| Cost Code Name | |
From/To |
| Cost Type ID | |
From/To |
| Cost Type Name | |
Amount |
| Transfer Amount |


