Sage Intacct 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 | ||
COMPANIES | AP VENDORS | ||
BUDGET | 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 COSTS | GENERAL LEDGER PC COST TYPES (CUSTOM) PC ACCOUNT TYPE (CUSTOM) |
||
BILLS |
|||
COMMITMENT PAYMENTS ISSUED 2 | BILL PAYMENTS |
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.
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 |
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 | 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 |
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 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 |
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, 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.
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 |
Commitments
PROCORE |
Exports data from Procore to Sage Intacct® | Imports data from Sage Intacct® to Procore | Sage Intacct® |
---|---|---|---|
Commitment Header | Commitment Header | ||
External ID | Document Number | ||
Commitment Type1 | Transaction Type | ||
Contract Company2 | Vendor | ||
Date Created | Date | ||
Title | Message | ||
Default Retainage | Default Retainage Percentage | ||
Commitment Item (Purchase Orders) | Commitment Item | ||
Item ID3 | |||
Qty | Quantity | ||
UOM | Unit | ||
Unit Cost | Price | ||
Contract Amount or Subtotal | Amount | ||
Commitment Item (Subcontracts) | Commitment Item | ||
Item ID3 | |||
Sage Job ID | Project | ||
Cost Code | Tasks | ||
Type | Cost Type | ||
UOM4 | Unit | ||
Unit Cost4 | Price | ||
Contract Amount or Subtotal | Amount |
1 When a commitment is created in Procore you must select a type, Purchase Order or Subcontract. This is used as the commitment type for Sage Intacct®.
2 The ERP Vendor ID associated with the Contract Company is used on the import file for Sage Intacct®. You cannot export a commitment for a Contract Company that does not have an ERP Vendor ID.
3 This field gets pulled from the Cost Type.
4 Subcontracts that are using the Accounting Method of "Unit/Quantity Based" will have these on the Schedule Of Values.
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 | Message | ||
System Date at Time of Export | Date | ||
Change Order Number | External Reference No | ||
Commitment Change Order Item (Purchase Order or Unit/Quantity Based Subcontract) |
Commitment Change Order Item | ||
Item ID1 | |||
Qty | Unit | ||
Contract Amount or Subtotal | 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 | Item ID | ||
Qty2 | Quantity | ||
Unit Cost2 | Unit Cost | ||
UOM2 | Unit | ||
Contract Amount or Subtotal3 | Extended Price |
1 This field gets pulled from the Cost Type.
2Typically Quantity, Units and Unit Cost are only used on Purchase Orders.
3The 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 # | Project Contract ID | ||
Title | Project Contract Name | ||
Contract # | Project | ||
Description | Description | ||
Retainage Percent | Retainage Percent | ||
Status | Status | ||
Date Created | Assigned based on the date imported | ||
Schedule of Values | Project Contract Lines | ||
Description | Line ID + Line Name | ||
Project ID | Project ID | ||
Amount | 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 # |
Project Change Order ID |
||
Project # |
Project |
||
Status = ‘Approved’ |
Change Request Status Name |
||
Transaction Date |
Project Change Order Date |
||
Default Item ID |
Item ID |
||
PCCO General | Project Change Request | ||
Status = ‘Approved’ |
Change Request Status Name |
||
Project # |
Project |
||
Transaction Date |
Change Request Date |
||
‘CR’ + Project ID + PCCO # |
Change Request ID |
||
Contract # |
Project Contract ID1 |
||
Contract SOV Origin Code* |
Project Contract Line ID1 |
||
Description |
Scope |
||
Title |
Description |
||
PCCO Schedule of Values | Project Change Request Entries | ||
Project # |
Project |
||
Cost Code |
Task ID |
||
Cost Type |
Cost Type ID |
||
Amount |
Cost |
||
Amount |
Price |
||
Quantity |
Quantity |
||
UOM |
Unit |
||
Contract # |
Project Contract ID |
||
Line ID + Description |
Memo |
||
Revenue Markup Amount |
Price Markup Amount |
||
Prime Contract Schedule of Values | Project Contract Line | ||
Contract # |
Project Contract ID |
||
Contract SOV Origin Code |
Project Contract Line ID |
||
Transaction Date |
Contract Line Date |
||
Default Account Number |
Account Number |
||
Project # |
Project |
||
Default Item ID |
Item ID |
||
Contract SOV Line ID |
Scope |
||
System date assigned at time of export |
Price Effective Date |
1 Project Contract Line ID will only display if all Project Contract IDs are the same.
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 | JTD Cost | ||
Direct Costs | JTD Cost - Commitment Invoiced1 | ||
Job Costs Report | |||
Cost Code | Cost Code | ||
Cost Type | Cost Type | ||
Commitment Invoiced | Commitment Invoiced | ||
Job to Date Cost | JTD Cost | ||
Job to Date Dollars Paid | JTD Dollars Paid | ||
Month to Date Cost | MTD Cost | ||
Month to Date Dollars Paid | MTD Dollars Paid |
1This 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 | Non-Commitment Invoices | ||
Subcontractor Invoice | Commitment Invoices | ||
Payroll | Payroll Expense | ||
Expense | Misc Expense | ||
Direct Cost General Information | |||
Vendor | Vendor Record Number | ||
Terms | Term Name for Commitment and Non-Commitment Invoices | ||
Received Date | When Paid for Commitment and Non-Commitment Invoices | ||
Status | Status (only transactions with a status of 'Approved' are imported) | ||
Invoice # | Record ID | ||
Description | Description for Commitment and Non-Commitment Invoices, Batch Title for Payroll, and Misc Expenses | ||
Detailed Line Information | |||
Budget Code | Track Record Number | ||
Description | Description for Commitment and Non-Commitment Invoices, Back Title for Payroll, and Misc Expenses | ||
Amount | 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 | Vendor | ||
ERP ID1 | Bill Number | ||
Description2 | Description | ||
Billing Date | Invoice Date | ||
Total Completed and Stored to Date | Original Amount | ||
Total Retainage | Amount Retained | ||
Accounting Date3 | Acct Date | ||
Distributions | |||
Project # | Job | ||
Cost Code | Cost Code | ||
Budget Code | Cost Type | ||
Work Completed this Period | Amount | ||
Work Retainage | 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 under 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. 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 |
Check Number |
||
Invoice Number | Invoice Number | ||
Payment Method | Payment Method | ||
Amount | Amount | ||
Date | Date |