Detailed Data Mapping
Overview
PROCORE | Exports data from Procore to QuickBooks® Desktop | Imports data from QuickBooks® Desktop to Procore | QuickBooks® Desktop |
|---|---|---|---|
COST CODES 1 |
| ITEMS | |
PROJECTS |
|
| JOBS |
COMPANIES 5 |
|
| VENDORS 2 |
BUDGET/BUDGET MODIFICATIONS |
| ESTIMATES | |
COMMITMENTS |
| PURCHASE ORDERS | |
COMMITMENT CHANGE ORDERS |
| NEW PURCHASE ORDER LINE ITEM(S) | |
COSTS |
| COSTS | |
SUBCONTRACTOR INVOICES 3 |
| BILLS | |
COMMITMENT PAYMENTS ISSUED 3,4 |
|
| BILL PAYMENTS |
1 Custom WBS segments are not supported by the integration at this time.
2 Procore does not export 'Customers' data to QuickBooks® Desktop.
3 Subcontractor invoices with negative values do not sync between systems
4 Import of subcontractor payment records from QuickBooks® Desktop is only supported in US Editions. Export of payment records from Procore to QuickBooks® Desktop is only available to companies that license Procore Pay.
5 Import companies by type, including those without a specified company type from QuickBooks® Desktop to Procore.
Cost Codes
When a Cost Code is exported from Procore to QuickBooks® Desktop and the QuickBooks® Desktop Web Connector runs, Items records are automatically created in QuickBooks® Desktop. In Procore, the Cost Codes can be found in the Work Breakdown Structure section in the Admin Tool under QuickBooks® Desktop Standard Cost Codes. Custom WBS segments are not supported by the integration at this time.
PROCORE | Exports data from Procore to QuickBooks® Desktop | Imports data from QuickBooks® Desktop to Procore | QuickBooks® Desktop |
|---|---|---|---|
Code |
| Item Name/Number | |
Description |
| Description on Purchase Transactions Description on Sales Transactions |
Export Note: At the time of export, an expense account and an income account are assigned and used to populate the corresponding fields in the QuickBooks® Desktop Item record. The Procore cost code records do not include these fields.
Projects/Jobs
When a Project is exported from Procore to QuickBooks® Desktop and the QuickBooks® Desktop Web Connector runs, Job records are automatically created in QuickBooks.Job information in QuickBooks® Desktop can be found in the Customer Center under Customers & Jobs. Procore job info is found in the project Admin tab. If customers are set up as jobs, then the Procore project ties to the Customer record in QuickBooks® Desktop. If jobs are set up as sub records under customer records, the Procore project ties to the Job record in QuickBooks® Desktop.
PROCORE | Exports data from Procore to QuickBooks® Desktop | Imports data from QuickBooks® Desktop to Procore | QuickBooks® Desktop |
|---|---|---|---|
Project Name |
|
| Job Name/Customer Name |
Address City State Zip |
|
| Ship To1 |
1Import Note: If Ship To is not populated, the Invoice/Bill To address will be used to populate the Address fields in Procore.
Vendors
When a Company is exported from Procore to QuickBooks® Desktop and the QuickBooks® Desktop Web Connector runs, a new Vendor record is automatically created in QuickBooks® Desktop. In QuickBooks® Desktop, the Vendor setup can be found under Vendors. Procore Companies can be found in the Directory.
PROCORE | Exports data from Procore to QuickBooks® Desktop | Imports data from QuickBooks® Desktop to Procore | QuickBooks® Desktop |
|---|---|---|---|
Name |
|
| Vendor Name |
Address City State ZIP |
|
| Billed From |
Business Phone |
|
| Main Phone |
Business Fax |
|
| Fax |
Budgets/Budget Modifications
Budgets and Budget modifications export from Procore only. When a Budget is exported from Procore, an Estimate is created automatically in QuickBooks® Desktop. In QuickBooks® Desktop, Estimates are accessed from Transactions in the Customer Center within Customer or Customer:Job. In Procore, budgets are accessed from project-level Budget tool.
When Budget Modifications are exported from Procore, new line items are created and added to the Estimate in QuickBooks® Desktop, below pre-existing line items. In Procore, budget modifications are accessed from the Budget Modifications column in the project-level Budget tool. They are used to move money from one budget line item to another, most commonly with a zero net effect. In QuickBooks® Desktop, the change(s) will appear as a negative amount to the “From” Cost Code entered in Procore and a positive amount to the “To” Cost Code in Procore in the Create Budget Modification window.
Phased Release: Budget Changes
Some ERP integrated clients may have already transitioned from Budget Modifications (Legacy) to the new Budget Changes experience. The legacy experience will continue to be available until November 2024. To learn more about the timeline for migration, see Common Questions.
Choosing to use the new Budget Changes experience will not impact the function of your ERP integration. You should still thoroughly review the available documentation before migrating to the new experience. We recommend you also discuss any concerns or questions about migrating your Budget Modifications to Budget Changes with your Procore point of contact.
To learn more about the new Budget Changes experience, see About Budget Changes.
PROCORE | Exports data from Procore to QuickBooks® Desktop | Imports data from QuickBooks® Desktop to Procore | QuickBooks® Desktop |
|---|---|---|---|
Project Name |
| Customer:Job | |
Cost Code |
| Item | |
Cost Code Description |
| Description | |
Original Budget Amount |
| Rate | |
Original Budget Amount |
| Amount |

