Sage Intacct Detailed Data Mapping

Overview

PROCORE	Exports data from Procore to Sage Intacct®	Imports data from Sage Intacct®  to Procore	Sage Intacct®
PROJECTS			JOBS
SUB JOBS			SUB JOBS
VENDORS			VENDORS
BUDGETS			ESTIMATE
BUDGET MODIFICATIONS			REVISION
COMMITMENTS			COMMITMENTS
COMMITMENT CHANGE ORDERS			COMMITMENT CHANGE ORDERS
COSTS			JOB COSTS
SUBCONTRACTOR INVOICES			BILLS
COMMITMENT PAYMENTS ISSUED 1			BILL PAYMENTS

¹ Not available in Canada or APAC at this time.

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

¹ 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.

² 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.

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 Code Description			Cost Code Task Description
Cost Type Cost Code Cost Type ID			Cost Type Task Cost Types

¹ 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.

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

¹ 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

When 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

¹ 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®.

² 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.

³ This field gets pulled from the Cost Type.

⁴ 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

¹ This field gets pulled from the Cost Type.

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

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

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

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

Subcontractor Invoices

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

¹ 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).

² 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®. 

³ 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

See Also 

• About Procore + Sage Intacct®