Detailed Data Mapping

Overview

The Procore + QuickBooks® Online connector is available in all regions.

PROCORE

Exports data from Procore to QuickBooks® Online

Imports data from QuickBooks® Online to Procore

QuickBooks® Online

PROJECT WBS CODES1

Erp Orange Arrows

ITEMS (SERVICES)

PROJECTS

Erp Green Arrows

PROJECTS

COMPANIES

Erp Orange Arrows

Erp Green Arrows

VENDORS 2

DIRECT COSTS

Erp Green Arrows

BILLS / EXPENSES / VENDOR CREDITS / CREDIT CARD CREDITS

SUBCONTRACTOR INVOICES 3

Erp Orange Arrows

BILLS

COMMITMENT PAYMENTS ISSUED 4

Erp Orange Arrows

Erp Green Arrows

BILL PAYMENTS

OWNER INVOICES

Erp Orange Arrows

CUSTOMER INVOICES

1 Custom WBS Segments ARE supported with the QuickBooks® Online connector.

2 Procore does not export 'Customers' data to QuickBooks® Online.

3 Subcontractor invoices with negative values do not sync between systems.

4 Import of subcontractor payment records from QuickBooks® Online is only supported in US Editions. Export of payment records from Procore to QuickBooks® Online is only available to companies that license Procore Pay.

Project WBS Codes

The QuickBooks® Online integration will create a new Company level cost code list in Procore for use with the integration. In Procore, the Cost Codes can be found in the Work Breakdown Structure → Cost Codes section in the Company Admin Tool under QuickBooks® Online ERP Integration Standard Cost Codes.

When WBS Codes are used on a QuickBooks® Online integrated project in Procore, the integration will create a corresponding Service Item in the QuickBooks® Online Products & Services list. The Service item/s created in QuickBooks® Online will be in the following format*: [project number]-[cost code].[cost type]

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

WBS Code

Erp Orange Arrows

Service Item Name

Cost Code/Cost Type Description

Erp Orange Arrows

Description on Purchase Transactions

*Note that if the project number field is blank in the Procore project Admin Tool, the value from QuickBooks Online ID field will be used instead

Projects

Project information in QuickBooks® Online can be found in the Projects menu section.

 Note

QuickBooks® Online Customers and Sub-Customers cannot be imported to Procore.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Project Name

Erp Green Arrows

Project Name

Project Number

Erp Green Arrows

Project Name

Vendors

When a Company is exported from Procore to QuickBooks® Online, a new Vendor record is automatically created in QuickBooks® Online.

In QuickBooks® Online, the Vendor setup can be found under Vendors. Procore Companies can be found in the Directory.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Name

Erp Orange Arrows

Erp Green Arrows

Vendor Company Name

Address City State ZIP Country

Erp Orange Arrows

Erp Green Arrows

Address City State ZIP Country

Business Phone

Erp Orange Arrows

Erp Green Arrows

Phone Number

Business Fax

Erp Orange Arrows

Erp Green Arrows

Fax

Email Address

Erp Orange Arrows

Erp Green Arrows

Email

Website

Erp Orange Arrows

Erp Green Arrows

Website

Entity Type: EIN

Erp Orange Arrows

Business ID No.

Job Costs

Job costs import from QuickBooks® Online only. Cost information is retrieved from QuickBooks® Online for each synced WBS Code for use in 2 locations in Procore: the Direct Costs tool, and the Budget tool.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Direct Costs1

Erp Green Arrows

Bills, Expenses, and Vendor Credits

1QuickBooks® Online Vendor Bills that were created by the integration (synced Subcontractor Invoices) are excluded from the Direct Costs import.

Job Cost Transaction Details

Import from QuickBooks® Online 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 into the Direct Costs or JTD Cost columns for a budget line item.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Direct Cost Type

Cost Type

Invoice

Erp Green Arrows

Vendor Bill

Expense

Erp Green Arrows

Expense

Expense

Erp Green Arrows

Vendor Credit

Expense

Erp Green Arrows

Credit Card Credit

Direct Cost

Received Date

Erp Green Arrows

Transaction Date

Status

Erp Green Arrows

Automatically set to Approved

Description (Header)

Erp Green Arrows

Description (Bill No. or Expense Ref no.)

Vendor

Erp Green Arrows

Vendor

Invoice #

Erp Green Arrows

Bill No. (Vendor Bills Only)

Amount

Erp Green Arrows

Amount

Budget Code (Line Item)

Erp Green Arrows

Project Specific Service Item

Description (Line Item)

Erp Green Arrows

Description (Item Details)

Qty., Unit Cost, Amount (Line Item)

Erp Green Arrows

Qty., Rate, Amount

Subcontractor Invoices

When a subcontractor invoice is exported from Procore to QuickBooks® Online, a Vendor Bill is automatically created in QuickBooks® Online. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool & Subcontractor Invoices in the project Invoicing tool.

In QuickBooks® Online, Vendor Bills are accessed from the Bills section in the Expenses menu.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Billing Date

Erp Orange Arrows

Bill Date

Contractor Company

Erp Orange Arrows

Vendor

Invoice #

Erp Orange Arrows

Bill No.

Payment Date

Erp Orange Arrows

Due Date

Current Payment Due

Erp Orange Arrows

Amount Due

Cost Code (Detail Tab)

Erp Orange Arrows

Service Item

QTY (Detail Tab), if applicable

Erp Orange Arrows

QTY

Unit Price (Detail Tab), if applicable

Erp Orange Arrows

Rate

Value or This Period (Detail Tab)

Erp Orange Arrows

Amount

Project Name

Erp Orange Arrows

Project Name

Total Retainage This Period, if applicable1

Erp Orange Arrows

Amount (on separate line item for retainage)

1If used in Procore, retainage is coded to an Item record in QuickBooks® Online that is assigned in the integration settings during configuration. Retainage is not coded to a synced cost code Item.

Commitment Payments Issued

Commitment Payments Issued imported from QuickBooks® Online only. When a subcontractor invoice is exported from Procore to QuickBooks® Online, a Vendor Bill is automatically created in QuickBooks® Online. When the Vendor Bill is paid the payment information can be retrieved from QuickBooks® Online for display in Procore.

In Procore, Subcontractor Invoices Payments are accessed from Payments Issued in the project Commitments tool. In QuickBooks® Online, Bill Payments are accessed from the Expenses menu.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Payment Method

Erp Green Arrows

Bill Payment Method

Date

Erp Green Arrows

Bill Payment Date

Payment #

Erp Green Arrows

Ref no.

Check / Ref #

Erp Green Arrows

Ref no.

Notes

Erp Green Arrows

Memo

Amount

Erp Green Arrows

Payment Amount

Owner Invoices

When an owner invoice is exported from Procore to QuickBooks® Online, a Customer Invoice is automatically created in QuickBooks® Online. In Procore, Owner Invoices are accessed from the Invoices tab in the project's Prime Contracts tool, or from the Owner Invoices tab in the project Invoicing tool.

In QuickBooks® Online, Customer Invoices are accessed from the Invoices section in the Sales menu.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Project

Erp Orange Arrows

Customer: Project

Invoice No.

Erp Orange Arrows

Invoice No.

Billing Date 1

Erp Orange Arrows

Invoice Date

Invoice Subtotal Amount

Erp Orange Arrows

Line 1 "Current Payment Due" on the

QuickBooks® Online

Service Item for Summary AR

Retainage

Erp Orange Arrows

Line 2 "Current Retainage" on the

QuickBooks® Online

Service Item for AR Retainage

1If blank, then Billing Period End Date is used.

Procore Pay Payments

 General Availability in Select Markets (United States)

Flag Us Procore Pay is available in the United States. It is designed for General Contractors and Owner-Builders who act as their own General Contractors on a job. Procore Pay extends the Invoice Management functionality in the Procore web application to handle the payment process between general and specialty contractors.

PROCORE

Exports data from Procore to

QuickBooks® Online

Imports data from

QuickBooks® Online

to Procore

QuickBooks® Online

Paid Amount

Erp Orange Arrows

Erp Green Arrows

Amount Paid

Date Payment Funded

Erp Orange Arrows

Erp Green Arrows

Payment Date

ACH

Erp Orange Arrows

Check 1

Bank ID

Erp Orange Arrows

Appears in 'Bank Register' URL string in

QuickBooks® Online

Check Number

Erp Orange Arrows

Erp Green Arrows

Ref No.

1 When importing a payment record with a payment method of 'Check' from QuickBooks® Online, the payment record in Procore will be marked as 'Check'.