Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

PROJECT WBS CODES 1

COST CODES & COST TYPES

Erp Orange Arrows

PRODUCTS AND SERVICES

PROJECTS

Erp Orange Arrows

Erp Green Arrows

TRACKING CATEGORY OPTION

COMPANIES

Erp Orange Arrows

Erp Green Arrows

CONTACTS

COMMITMENTS (optional) SUBCONTRACTS & PURCHASE ORDERS

COMMITMENT CHANGE ORDERS (CCOs)

Erp Orange Arrows

PURCHASE ORDERS PURCHASE ORDERS APPENDED TO ORIGINAL PURCHASE ORDER

COSTS

Erp Green Arrows

COSTS

SUBCONTRACTOR INVOICES 2
FOR SUBCONTRACTS & PURCHASE ORDERS

Erp Orange Arrows

BILLS

COMMITMENT PAYMENTS ISSUED 3
FOR SYNCED SUBCONTRACTOR INVOICES

Erp Green Arrows

BILL PAYMENTS

1 Custom WBS segments are not supported at this time.

2 Subcontractor invoices with negative values do not export.

3Bill Payments will not reflect tax when pulled into Procore.

Cost Codes

When a Cost Code is exported from Procore to Xero™, Items records are automatically created in Xero™. In Procore, the Cost Codes can be found in the Work Breakdown Structure (WBS) section in the Admin Tool under Xero™ Standard Cost Codes. Custom WBS segments are not supported by the integration at this time.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Cost Code + Cost Type

Erp Orange Arrows

Item Code

Description

Erp Orange Arrows

Name

Export Note: After export, an expense account and an income account are assigned in the Xero™ Item record. The Procore cost code records do not include these fields.

Projects/Jobs

When a Project is exported from Procore to Xero™, the tracking category option is automatically created in Xero™.Job information in Xero™ can be found in the Tracking Categories list designated during implementation.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Project Name

Erp Orange Arrows

Erp Green Arrows

Tracking Category Option

Vendors

When a Company is exported from Procore to Xero™, a new Contacts record is automatically created in Xero™. In Xero™, the Contacts setup can be found under Contacts. Procore Companies can be found in the Directory.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Name

Erp Orange Arrows

Erp Green Arrows

Contact Name

Address

City

State

ZIP

Erp Orange Arrows

Erp Green Arrows

Billing Address

Business Phone

Erp Orange Arrows

Erp Green Arrows

Phone Number

Business Fax

Erp Orange Arrows

Erp Green Arrows

Fax Number

Commitments (Optional)

Commitments export from Procore only. When a Commitment (Subcontract or Purchase Order) is exported from Procore, a Purchase Order is automatically created in Xero™. In Xero™, Purchase Orders are accessed from the Business Tab. In Procore, Commitments are accessed from the project-level Commitments tool.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

System Date at Time of Commitment Creation

Erp Orange Arrows

Date

Commitment #

Erp Orange Arrows

Order Number

Contract Company

Erp Orange Arrows

Contact

Title (General tab)

Erp Orange Arrows

Reference

Cost Code + Cost Type (Schedule of Values tab)

Erp Orange Arrows

Item

Description (Schedule of Values tab)

Erp Orange Arrows

Description

Qty (Schedule of Values tab)

Erp Orange Arrows

Quantity

Unit Cost (Schedule of Values tab)

Erp Orange Arrows

Unit Price

Project Name

Erp Orange Arrows

(Tracking Category Option)

Ship Via

Erp Orange Arrows

Delivery Instructions

Commitment Change Orders

Commitment Change Orders export from Procore only. When Commitment Change Orders are exported from Procore, new line items are created and added to the corresponding Purchase Order in Xero™, below pre-existing line items. In Xero™, Purchase Orders are accessed from the Business Tab. In Procore, Commitment Change Orders are accessed from the project-level Commitments tool under Commitment Record. In Xero™, the change(s) will appear as additional line items on the Purchase Order originally created when the Commitment was exported from Procore to Xero™.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Commitment #

Erp Orange Arrows

Order Number

Contract Company

Erp Orange Arrows

Contact

Cost Code (Schedule of Values tab)

Erp Orange Arrows

Item

Description (Schedule of Values tab)

Erp Orange Arrows

Description

Qty (Schedule of Values tab)

Erp Orange Arrows

Quantity

Unit Cost (Schedule of Values tab)

Erp Orange Arrows

Unit Price

Project Name

Erp Orange Arrows

(Tracking Category Option)

Job Costs

Job costs import from Xero™ only. Cost information is retrieved from Xero™ reports for each synced Cost Code for use in 2 locations in Procore, the Xero™ Job Costs report and the Budget tool.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Job to Date Cost (

Xero™

Job Costs)

Erp Green Arrows

Total from Bills and Spend Money Transactions

Commitment Invoiced (

Xero™

Job Costs)

Erp Green Arrows

Total from Bills/Subcontractor Invoices Exported from Procore

Job to Date Cost
(Budget)

Erp Green Arrows

Total from Bills and Spend Money Transactions

Direct Costs
(Budget)

Erp Green Arrows

Total from Bills and Spend Money Transactions Minus Commitments Invoiced Costs

Commitment Invoiced
(Budget)

Erp Green Arrows

Total from Bills/Subcontractor Invoices Exported from Procore

Job Cost Transaction Details

Import from Xero™ only. This provides transaction detail for the costs displayed in Procore, and if the budget view is configured properly, the values of those transactions can be viewed in the Direct Costs or JTD Cost columns for a budget line item.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Direct Cost Type

Erp Green Arrows

Cost Type

Invoice

Erp Green Arrows

Bill

Subcontractor Invoice

Erp Green Arrows

Bill

Expense

Erp Green Arrows

Spend Money

Direct Cost

Date

Erp Green Arrows

Date

Status

Erp Green Arrows

Automatically set to Approved

Description1
(Header)

Erp Green Arrows

Reference

Vendor

Erp Green Arrows

From (Bill) / To (Spend Money)

Invoice #2

Erp Green Arrows

Reference

Received Date3

Erp Green Arrows

Amount

Amount

Erp Green Arrows

Amount

Budget Code (Line Item)

Erp Green Arrows

Item

Description (Line Item)

Erp Green Arrows

Description

Qty., Unit Cost, Amount (Line Item)

Erp Green Arrows

Qty., Unit Price, Amount

1 Description is populated when the reference field is filled out on a Spend Money transaction or a Bill that was first synced from Procore. This does not apply for Bill transaction types first entered in Xero™.

2 Invoice # is populated when the reference field is filled out on a Bill transaction. This does not apply for Spend Money transactions. Invoice # is a required field for Invoice direct cost types in Procore.

3 Received Date is populated from a Spend Money or Bill transaction type first entered in Xero™ only.

Subcontractor Invoices

When a subcontractor invoice is exported from Procore to Xero™, a Bill is automatically created in Xero™. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool. In Xero™, Bills to Pay are accessed from the Business tab.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Contractor Company

Erp Orange Arrows

From (contact)

Billing Date

Erp Orange Arrows

Date

Payment Date

Erp Orange Arrows

Due Date

Purchase Order Number/Invoice Number1

Erp Orange Arrows

Reference

Budget Code (Schedule of Values)

Erp Orange Arrows

Item Code

QTY (Schedule of Values)

Erp Orange Arrows

Quantity

Unit Price (Schedule of Values)

Erp Orange Arrows

Unit Price

Scheduled Value (Schedule of Values)

Erp Orange Arrows

Amount

Project Name

Erp Orange Arrows

(Tracking Category Option)

Total Retainage This Period, if applicable2

Erp Orange Arrows

(on separate line item for retainage)

1 If Commitment syncing is NOT enabled, the invoice Number will map to the Reference field in Xero™. If if Commitment syncing IS enabled, the PO Number will map to the Reference field in Xero™.

2 If used in Procore, retainage is coded to an Item record in Xero™ that is determined in the integration settings. Retainage is not coded to a synced cost code Item.

Commitment Payments Issued

Commitment Payments Issued imported from Xero™ only. When a subcontractor invoice is exported from Procore to Xero™, a Bill is automatically created in Xero™. When the Bill is paid, the payment information will flow back to Procore. In Procore, Subcontractor Invoices Payments are accessed from Payments Issued in the project Commitments tool. In Xero™, paid bills are accessed from the B usiness tab under the Paid tab in Bills to Pay.

PROCORE

Exports data from Procore to

Xero™

Imports data from

Xero™

to Procore

Xero™

Invoice

Erp Green Arrows

n/a

Payment Number

Erp Green Arrows

n/a

Payment Method

Erp Green Arrows

n/a

Amount

Erp Green Arrows

Amount Paid

Date

Erp Green Arrows

Date Paid

Invoice #

Erp Green Arrows

(Subcontractor Invoice number)

Check Number

Erp Green Arrows

n/a

Notes

Erp Green Arrows

Reference (Make a Payment Field)