Skip to main content
Procore

Project Financials + Jobpac™ Connector

Overview

Procore's Accounting Integrations connect Procore with your ERP or Accounting system, uniting the office and field teams with one source of financial project data.

  • Save time and labor by streamlining the approval process of time-sensitive tasks such as commitments and variations.
  • Reduce human error by eliminating the need for manual, double-entry when transferring data from Procore to Jobpac™.
  • More efficient communication between Accounting and Project Management teams.
  • Easy and instant access to Jobpac™ Job Cost report by the Project Management team.

Prerequisites

  • Subscriptions and Licensing 
    • Jobpac™ API Module
    • Jobpac™ API Version 1.00
    • Jobpac Connect API access. If you don’t already have this access, open a case with your Jobpac™ Customer Support contact requesting Jobpac™ Connect API access and include the following information.
      • The name of the application that will integrate with your Jobpac™ account using the Jobpac Connect API: “AGAVE”.
      • Written approval that you agree to pay the fee charged by Jobpac™ for provisioning the Jobpac Connect API.
  • Procore Requirements
    • Company Administrator permissions to the Procore web application
    • Procore Project Financials
    • Sectioned Cost Codes must be enabled in Jobpac
acumatica-logo.jpg

Availability of ERP connectors is dependent on several factors, including the country or region in which your business operates. To learn whether or not an integration is available in your area, contact your Procore point of contact.

Tutorials

There are no items that match your search query.

Prerequisites

Subscriptions and Licensing

  • Jobpac Connect API access. If you don’t already have this access, open a case with your Jobpac Customer Support contact requesting Jobpac Connect API access and include the following information.

    • The name of the application that will integrate with your Jobpac account using the Jobpac Connect API: “AGAVE”.

    • Written approval that you agree to pay the fee charged by Jobpac for provisioning the Jobpac Connect API.

Permissions

Learn which user permissions are required to take the described actions in this tool.

 Important

Some actions that impact this tool are done in other Procore tools. See the User Permissions Matrix for the full list of actions taken in all other tools.

   The action is available on Procore's Web, iOS, and/or Android application. Click to view the tutorial.

icon-mindtouch-table-check.png Users can take the action with this permission level.

icon-mindtouch-table-check.png Users can take this action with this permission level AND one or more additional requirements, like granular permissions.

 Important

Several available actions in the ERP Integrations tool also require Accounting Approver permissions. An Accounting Approver is a user with either 'Standard' or 'Admin' level permissions to the ERP Integrations tool who has been granted the 'Can Push to Accounting' privilege. 

Not all ERP connectors support every action described below. To learn more about your connector's supported functions, see Things to Know About your ERP Integration

Action None Read Only Standard Admin Notes

Accept or Reject Cost Codes for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject Owner Invoices for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject Subcontractor Invoices for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a Budget for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a CCO for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a Commitment for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a Company for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a PCCO for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a Project for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Accept or Reject a Sub Job for Export to ERP

 Web

     

icon-mindtouch-table-check.png

 

Add a Procore Project to your ERP System

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Add an ERP Company to the Procore Company Directory

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Add an ERP Job to Procore

 Web

      icon-mindtouch-table-check.png  

Archive an ERP Company in Procore

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Assign Default Cost Types To ERP Standard Cost Codes

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Configure Advanced Settings: ERP Integrations

 Web

      icon-mindtouch-table-check.png  

Configure the Sync Schedule for your ERP Integration

 Web

      icon-mindtouch-table-check.png  

Enable or Disable ERP Direct Exports

 Web

      icon-mindtouch-table-check.png  

Import a Budget from ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Import a Prime Contract from an Integrated ERP System into Procore

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Import an ERP Sub Job to a Procore Project

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Link ERP Companies to Procore Companies

 Web

      icon-mindtouch-table-check.png  

Refresh the Companies List for ERP

 Web

      icon-mindtouch-table-check.png  

Refresh the Cost Codes on an ERP Integrated Project

 Web

      icon-mindtouch-table-check.png  

Send, Retrieve, or Resend Items to ERP Integrations for Accounting Acceptance

 Web

       
  • These actions do NOT require permissions to the ERP Integrations tool.
  • Sending items to ERP for accounting acceptance requires 'Admin' level permissions on the tool where the item is located. 

Sync Job Cost Transactions from an Integrated ERP into Procore

 Web

      icon-mindtouch-table-check.png  

Sync Paid Invoice Notifications from ERP into Procore

 Web

      icon-mindtouch-table-check.png  

Unlink CCOs Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Unlink Commitments Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Unlink Owner Invoices Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Unlink PCCOs Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Unlink Subcontractor Invoices Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

Unlink a Company Synced with ERP

 Web

    icon-mindtouch-table-check.png icon-mindtouch-table-check.png  

View a List of Synced Sub Jobs

 Web

   

icon-mindtouch-table-check.png

  • Requires additional tool permissions 

icon-mindtouch-table-check.png

  • Requires additional tool permissions 

Also requires 'Admin' level permissions to the Company level Directory tool, or 'Standard' level permissions with the 'Create New Project' granular permission.

View an Accountant Report for ERP

 Web

      icon-mindtouch-table-check.png  

View an ERP Job Costs Report

 Web

     

icon-mindtouch-table-check.png

  • Requires additional tool permissions to view at the project level

'Admin' level permissions to the ERP Integrations tool allows users to view this report at the Company level. 

To view at the Project level, users also require:

  • 'Read-only' level permission or above on the project's Reports tool.
    AND
    • 'Admin' level permission on the project's Budgets tool.
      OR
    • 'Admin' level permission on the project's Prime Contract tool.

View an ERP Unsyncable Direct Costs Report

 Web

       

Users do NOT require permissions to the ERP Integrations tool to view this report. They do require:

  • 'Read-only' level permission and above on the project's Reports tool
    AND
    • 'Admin' level permission on the project's Budgets tool
      OR
    • 'Admin' level permission on the project's Prime Contract tool.

View the Archived Companies List for ERP

 Web

   

icon-mindtouch-table-check.png

icon-mindtouch-table-check.png

 

 

 

Release Notes

Below are the notable changes to the Procore + Jobpac™ integration.

Recent Changes

Things to Know

Background

Each of Procore's available ERP connectors perform the basic function of syncing data between the ERP system and Procore, usually in the same way as other connectors. However, each connector has a unique set of items it can sync, and the way those items are synced will vary based on how that ERP system and its corresponding integration are built to function. 

Jobpac™, like all ERP integrations, has some key considerations, limitations, and things to know about how each Procore object is synced. Those considerations, limitations, and things to know are outlined in the table below according to tool or item being synced.

Things to know about the Jobpac™ Connector

Procore Item or Setting

Considerations, Limitations, and Requirements

configuration settings & sync schedule

  • In order to connect Procore and Jobpac, you must have the following information:
    • The server  you are hosted on, environment, application, encryption key, Jobpac User ID and Password and Work ID.

work breakdown structure (wbs)

  • The WBS codes are created in Jobpac and imported to Procore.
  • Project specific cost codes are not supported and must exist on the standard cost code list.

Cost Codes

  • A Jobpac™ cost code cannot be both a header and a cost centre.
  • Project-specific cost codes are NOT supported with the Procore + Jobpac™ integration. Your company will have one (1) cost code list for use with all Jobpac™ integrated projects.
  • 'Cost Centre' in Jobpac™ refers to 'Cost Code + Cost Type' in Procore.

Sub Jobs

  • The sub job feature is NOT supported with the Procore + Jobpac™ integration. Sub jobs are disabled in Procore for Jobpac™ integrated projects.

projects

  • This integration was designed for use only on new construction jobs/projects. Projects that are in-progress or created before connection of the integration cannot be synced. Professional Services for assistance with integrating in-progress/pre-existing project records may be available for an additional fee.
  • A separate Jobpac™ organization for each project is NOT supported. For each Procore company account, the integration is designed to support one (1) Jobpac™ organization per connector.
  • Project must be created in Jobpac and imported to Procore.
  • Projects that are in-progress or created before connection of the integration cannot be synced. Professional Services may be available for assistance with integrating in-progress/pre-existing project records for an additional fee.
  • 'Job' in Jobpac™ refers to 'Project' in Procore.

companies

  • Creditors are created in Jobpac and imported to Procore. For those that already exist in Procore, you can link the existing record.
  • 'Creditor' in Jobpac™ refer to 'Company' in Procore.

BUDGET

  • Budgets are created in Jobpac and imported to Procore, but is limited to a two tier level.

commitments

  • Commitments are created in Procore and exported to Jobpac.
  • To sync a commitment, all a Schedule of Values (SOV) line items must be tied to a cost codes and categories from your ERP-synced lists of Standard Cost Codes and Cost Types.

commitment change orders (cco)

  • You must nominate a 1 type variation as mapped in Jobpac when exporting a Commitment Change Order.
  • The company account must be integrated with Jobpac. 
  • The Change Orders and Commitments tool must be an active tab on the project. 

subcontractor invoices

  • The Subcontractor Invoices are created in Procore and exported to Jobpac.

direct costs

  • Any expenses, labour will come from Jobpac and automatically update Procore to the associated cost code and cost type.

prime contracts

  • Head Contracts are created in Procore and exported to Jobpac. Claims are exported from Procore into Jobpac; however, receipt of payment must be manually done in both systems.
  • Within your ERP Integration settings, ERP Admins can enable the ability to designate your prime contract as either Unit-based or Amount-based before importing to Procore. 

prime contract change orders (Pcco)

  • You must nominate a 2 type variation as mapped in Jobpac when exporting a Head Contract Variation.

Timecards, Timesheets, Head Contract Invoices, and Payments

  • Data from these Procore tools and items do NOT sync with Jobpac™
   

 

Data Mapping

Overview


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
PROJECTS   erp-green-arrows.png JOBS
COMPANIES   erp-green-arrows.png CREDITORS
PROJECT WBS CODES 1
COST CODES + COST TYPES
  erp-green-arrows.png PROJECT COST CENTRE
PROJECT COST TYPES
BUDGET LINE ITEMS   erp-green-arrows.png PROJECT COST CENTRES
COMMITMENTS
SUBCONTRACTS & PURCHASE ORDERS
COMMITMENT CHANGE ORDERS (CCOs)
erp-orange-arrows.png   SUBCONTRACTS
PURCHASE ORDERS
VARIATIONS
COSTS   erp-green-arrows.png COSTS
SUBCONTRACTOR INVOICES 2
FOR SUBCONTRACTS & PURCHASE ORDERS
erp-orange-arrows.png   SUBCONTRACTOR INVOICES
SUBCONTRACT CLAIMS
AP INVOICES
PRIME CONTRACTS   erp-green-arrows.png HEAD CONTRACTS
 
PRIME CONTRACT CHANGE ORDERS erp-orange-arrows.png   HEAD CONTRACT VARIATIONS

1 Custom WBS segments are not supported at this time.

2  Subcontractor invoices with negative values do not export.

Cost Codes


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Cost Code + Cost Type   erp-green-arrows.png Cost Code
Description   erp-green-arrows.png Description

Projects/Jobs


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Project Name   erp-green-arrows.png

Job

Companies


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Name   erp-green-arrows.png Creditor
Address
City
State
ZIP
  erp-green-arrows.png

 Address
City
State
Postal Code

Business Phone   erp-green-arrows.png Telephone
Business Fax   erp-green-arrows.png Fax No.

 

Budget Line Items


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Original Budget   erp-green-arrows.png Budget

Cost Code/Cost Type

  erp-green-arrows.png Cost Centre

Commitments


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Commitment Header     Commitment Header
Project erp-orange-arrows.png   Job
Title (General tab) erp-orange-arrows.png   Description
Date Created erp-orange-arrows.png   Date
Default Retainage erp-orange-arrows.png   Retention
Commitment Item (Subcontracts)     Commitment Item
Commitment # erp-orange-arrows.png   Agreement
Contract Company erp-orange-arrows.png   Subcontractor
Cost Code \ Code Type erp-orange-arrows.png   Cost Centre
Qty (Schedule of Values tab) erp-orange-arrows.png   Quantity
UOM erp-orange-arrows.png   UOM
Contract Amount or Subtotal erp-orange-arrows.png   Nett Contract Sum
Commitment Item (Purchase Orders)     Commitment Item
Commitment # erp-orange-arrows.png   Order Number
Contract Company erp-orange-arrows.png   Supplier
Cost Code \ Cost Type erp-orange-arrows.png   Cost Centre
Qty erp-orange-arrows.png   Quantity
UOM erp-orange-arrows.png   Unit
Contract Amount or Subtotal erp-orange-arrows.png    Order Amount

Commitment Change Orders


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Commitment Change Order Header     Variation Header (Group Code 1)
Change Order Number erp-orange-arrows.png   Variation
Title erp-orange-arrows.png   Description
Date Created erp-orange-arrows.png   Date
Commitment Change Order Item
( Subcontract)
    Commitment Change Order Item
Cost Code (Schedule of Values tab) erp-orange-arrows.png   Cost Centre
UOM erp-orange-arrows.png   UOM
Unit Cost erp-orange-arrows.png   Rate
Amount erp-orange-arrows.png   Value
Commitment Change Order Item
(Purchase Order)
    Commitment Change Order Item
Cost Code (Schedule of Values tab) erp-orange-arrows.png   Cost Centre
Qty erp-orange-arrows.png   Quantity
Unit Cost (Schedule of Values tab) erp-orange-arrows.png   Unit
Amount erp-orange-arrows.png   Value

Job Costs


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Original Budget   erp-green-arrows.png Original Costs
Approved Budget Changes   erp-green-arrows.png 'A' transferred Status
Commitment Invoiced   erp-green-arrows.png Subcontract Claims to Date
Job to Date Cost
 
  erp-green-arrows.png Cost

Subcontractor Invoices


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
      Header
Contractor Company erp-orange-arrows.png   Creditor
ERP ID1 erp-orange-arrows.png   Invoice #
Description erp-orange-arrows.png   Description
Billing Date erp-orange-arrows.png   Invoice Date
Total Completed and Stored to Date erp-orange-arrows.png   Nett Amount
      Distributions
Project # erp-orange-arrows.png   Job
WBS Code (Schedule of Values) erp-orange-arrows.png   Cost Centre
QTY (Schedule of Values) erp-orange-arrows.png   Quantity, Cost
Unit Price (Schedule of Values) erp-orange-arrows.png   Unit
Work Retainage erp-orange-arrows.png   Maximum Retention

 

Prime Contracts


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Prime Contract   erp-green-arrows.png Head Contract

Prime Contract Change Orders


PROCORE
Exports data from Procore to Jobpac™  Imports data from Jobpac™  to Procore
Jobpac™
Prime Contract Change Order erp-orange-arrows.png   Head Contract Variation