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)
SUBCONTRACTOR INVOICES			BILLS
COMMITMENT PAYMENTS ISSUED 2			BILL PAYMENTS

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

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

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

² 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

¹ 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
Contract #			Document Number
Commitment Type1			Transaction Type
Contract Company2			Vendor
Export Date			Date
Title			Message
Commitment Item (Purchase Orders)			Commitment Item
Sage Job ID			Project
Cost Code			Task/Cost Code
Cost Type			Cost Type3
Description			Memo
Qty			Quantity
Unit is populated from the base UOM on the Sage Intacct® Item ID.			Unit
Unit Cost			Price
Amount			Extended Price
Default Retainage4			Retainage Percentage
Commitment Item (Subcontracts)			Commitment Item
Sage Job ID			Project
Cost Code			Task/Cost Code
Cost Type			Cost Type3
Description			Memo
Amount			Extended Price
Default Retainage4			Default Retainage Percentage

¹ When a commitment is created in Procore you must select a type, Purchase Order or Subcontract. This is used as the purchasing transaction for Sage Intacct®.

² The Contract Company must be ERP synced.

³ The Item ID is populated from the Sage Intacct® Cost Type’s  default item.

⁴ Default Retainage (Header) populates the Sage Intacct® Retainage Percentage on the line entry.

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.

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

¹ 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

¹This 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
Date			Batch Date (Payroll & Expenses) When Created Date (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
Detailed Line Information
Budget Code			Track Record Number
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

¹ 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®
• Things to Know about Sage Intacct®: Integration Details Reference Page