Project Financials + Sage Intacct® Connector

• Sage Intacct® subscriptions
  • In order to use Procore's integration with  Sage Intacct®, the following subscriptions will need to be enabled in Sage Intacct®:
    • Web Services
    • Construction
    • To enable these, go to Company → Admin → Subscriptions
    • Find ‘Web Services’ and click on it to Subscribe.
    • Repeat the process for "Construction Subscription". Sage Intacct® will have an additional charge for this.  Please consult your Sage reseller about this.
    • Click Done when finished.

• Within Procore:   Your Integration Implementation Specialist will ask you to add the required DMSA Apps to your account.
• Data exports instantly; imports can be requested by Admins.

• Exports happen instantly upon approval by your organization’s Accounting User(s). Imports happen upon requests which can be made by your Project and Accounting Teams directly within Procore. 
• Within Procore, any exports to Sage Intacct® must be approved by your company's designated accounting approver(s).

• If you will be integrating one (1) or more projects with Sage Intacct®, you should always enable the 'Available for use on new projects' option.
• If a cost code has been deactivated, you cannot add it to a project unless you reactivate it first.

• To add Sage Intacct® standard cost codes to a project, the ERP Integrations tool must be enabled on the project. 
• The Sage Intacct® job must be added as a Procore project

• If a user adds new Project level cost codes to the Sage Intacct® Standard Cost Code List, those updates must be sent to the ERP Integrations tool so the changes can be reviewed by an accounting approver.
• Any project level cost codes that are not synced will automatically sync with your ERP when exporting your budget.

• If a new cost code that already has a different cost type assignment in Procore is approved/updated, both cost type assignments will be tied to the cost code.
• Existing cost code descriptions in Sage Intacct® will not be overwritten. For example, if the cost code already has a description in Sage Intacct® that's different from the cost code's description that appears in Procore, the cost code's description in Sage Intacct® will stay the same.

• After a company record from Sage Intacct® is linked to a company record in Procore, any 'Address' changes are not synced between the two systems. This is because the 'Address' in Sage Intacct® pertains to the company's billing address, which may be different from the mailing address that your project management team needs to use for job related correspondence.
• Companies must be created at the top level in Sage Intacct® for the integration to properly pick up Job Costs across projects.
• Companies created at the entity level are neither seen nor supported by the integration. 
• Company records created in Procore by importing a vendor from Sage Intacct® do not automatically sync vendor insurance details. You must manually manage and update vendor insurance information in Procore and Sage Intacct®.

• It's strongly recommended that you first try to link any Sage Intacct® companies that already exist in your Procore Company level Directory before adding new companies to avoid duplication.

• 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 are available for an additional fee.
• All cost codes must have at least one (1) cost type  assignment before the Procore project can be exported to create a new Job in Sage Intacct®.
• If your cost codes already have cost type assignments, your company has already configured the cost type assignments for your cost codes. 
• When entering your project data, be aware of the following requirements:
  • Project Name. Sage Intacct® imposes a maximum of 200 characters limit. If your project name exceeds this limit, your project name will be truncated in Sage Intacct®.
  • Active Project. Sage Intacct® requires you to set your new project as 'Active' in Procore. 

• Before you can sync data project data between the two (2) systems, your Procore point of contact must enable the 'Can Push to Accounting' privilege for your company's accounting approvers. This gives users with 'Standard' level permissions to the ERP Integrations tool permission to accept or reject the data that is synced between Procore and Sage Intacct®. 

• If you have created an 'Sub Job' in Sage Intacct®, you can import it into your Procore project. Before the synchronization process add the 'Sub Job' to your Procore project, the information will appear in the 'Sub Jobs' tab of the company's ERP Integrations tool.

Synchronized data will include the following:

• Sub Job Cost Codes
• Sub Job Categories
• Original Estimate

• You cannot delete a Sub Job if there are cost codes tied to that Sub Job.
• When editing a sub job description, the new description entry must exactly match the change you made to the sub job in your ERP system.

• Add the Sage Intacct® Job to Procore. 
• Create or update the project budget:
• The budget must be locked before the export.
• Ensure the project's cost codes are updated with the synced job in Sage Intacct®.

• The ability to unlock the Procore budget, resend data to Sage Intacct®, add budget line items, and create budget modifications will be disabled until the export from Procore to Sage Intacct® is complete.

• The Procore + Sage Intacct® integration does NOT sync 'Unit of Measure (UOM)' and 'Unit Qty' values between systems. Currently, the Budget sync is amount-based only. 
• The Procore + Sage Intacct® integration does NOT sync Prime Contract Change Orders to Sage Intacct® as Budget Revisions, even though these impact the budget as such in Procore. In order to sync budget revisions to Sage Intacct®, those revisions must be entered into Procore as budget changes or revised budget estimates. In other words, the revisions must be entered via the Budgets Tool, not the Prime Contract Tool. 

• Any custom budget views that you create for Sage Intacct® must contain all of the required ERP data columns. This ensures that Procore can send the required budget data to the company's ERP Integrations tool for acceptance for export to the integrated ERP system by an accounting approver. 

• ID Number. Must be fewer characters that the limitation set in Sage Intacct®.
  Note: Your Procore integration implementation specialist can set this limitation within Procore itself, so that your users are restricted from surpassing it. If this has not been configured, then there will be no length limitation in Procore, only that in Sage Intacct®. 
• Title. For Sage Intacct®, the title must be 35 characters or less.
  Note: You cannot save a commitment that does not meet this criteria.
• Start Date. For Sage Intacct®, you must enter a Start Date for the commitment.
  Note: You cannot save a commitment that does not meet this criteria.
• Contract Company. Must be linked to a synced Sage Intacct® vendor. See Link a Sage Intacct® Vendor to a Procore Company.
• Status. For subcontracts, the status must be set to 'Approved' or 'Complete.'
• Schedule of Values (SOV). Must include at least one (1) line item, and all line items must contain Sage Intacct® cost codes.

• If desired, you can configure your default settings to use your Procore Contract Number for an exported commitment's Sage Intacct® ID field. If enabled, the Sage Intacct® ID will auto-populate with the Procore Contract Number, however, the value can still be edited (Note: Enabling this setting requires 'Admin' level permission on the ERP Integrations tool.) 

• 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.
• Commitments synced to Sage Intacct® will NOT contain details regarding tax codes. 

• After the commitments on a project have been synced with a company's Sage Intacct® system, Procore automatically restricts your ability to edit synced fields on a commitment. This is to ensure that the data remains in sync on both systems. The fields that cannot be edited after a sync include:

  • Contract Company
  • Status
  • Schedule of Values (SOV) sub tab (all fields)
• If you need to delete a commitment after its been synced with your Sage Intacct®, you must first disconnect the link that exists between the two records in each system.
• Once deleted, the commitment's data is permanently removed from Procore and cannot be retrieved.

• Title: Must be 35 characters or less.
  Note: You cannot save a CCO that does not meet this requirement.
• Due Date: The due date field must be entered. This corresponds to the 'Date' in Sage Intacct®.
  Note: You cannot save a CCO that does not meet this requirement.
• Contract Company. Must be linked to a Sage Intacct® vendor. 
• Status. Must be 'Approved.' 
• Schedule of Values (SOV). Must include at least one (1) line item with a Sage Intacct® Cost Code.
  Notes:
  - You can only add a line item to the commitment's SOV if its linked to an existing cost code and category.
  - Line item description can't be longer than 400 characters.

• If desired, you can configure your default settings to use your Procore Change Order Number for an exported commitment's Sage Intacct® ID field. If enabled, the Sage Intacct® ID will auto-populate with the Procore Change Order Number. However, the value can still be edited. (Enabling this account-wide configuration setting requires 'Admin' level access on the ERP Integrations tool.)

• If a line item on a CCO creates a new line item on the original contract, that new line item will not be reflected on the Sage Intacct® contract. However, the CCO's line item will still be sent to Sage Intacct®. 
• To add a Schedule of Values (SOV) line item to a CCO, it must be tied to an existing cost code and category.
• If a line item on a CCO creates a new line item on the original contract, that new line item will not be reflected on the Sage Intacct® contract. However, the CCO's line item will still be sent to Sage Intacct®. 
• Procore does not permit users to delete synced commitments, so you must first unlink the records in the two systems to allow for deletion.
• You cannot delete an 'Approved' change order. The status must be adjusted prior to deletion.
• After a synced CCO is unlinked and deleted, the data is permanently removed from the system and cannot be restored.

• Billing Date. This date in Procore is transferred to Sage Intacct® as the Date on a bill. 
• Invoices whose total amount equals zero dollars cannot be sent to Sage Intacct®. These invoices will not be synced when exported. 
• Materials Presently Stored and Materials Retainage are not supported with the Sage Intacct® integration. These values will be ignored when sending invoices to Sage Intacct®. 
• After invoices are sent, users will NOT be able to edit the invoice in the Commitments tool (with the exception of editing the invoice's attachments). 
• If you mark a vendor as a 1099 vendor in Sage Intacct®, the invoice exported from Procore will not be flagged as 1099 reportable. 

• Before you can send an invoice from the Commitments tool to the ERP Integrations tool, the invoice must be in the Approved, Approved as Noted, or Pending Owner Approval status. 

• Prime contracts can only be imported to Procore from Sage Intacct®.
• 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. 
• If you choose to update the prime contract in Sage Intacct® , you will need to manually sync and re-import your changes to Procore.
• While updates made to the Prime Contract in Intacct can be reimported into Procore, deletion of SOV line items is not detected. Contact ERP support for assistance in removing the deleted items.
• After the prime contract has been imported, budget codes and descriptions can be added to individual line items from the Prime Contracts tool under Schedule of Values.
• Multiple prime contracts set up against a job in Sage Intacct® can be imported into a synced Procore project.

• On the 'Ready to Import' and 'Synced' filters with the Prime Contract ERP Integrations tool, a refresh will check for the follwing:
  • Prime contract line items are updated
  • Prime contact header items are updated
  • After this, then users will be able to re-import
• The 'Re-Import' button is grayed out and unavailable in the following situations:
  • The prime contract is unapproved.
  • The prime contract does not belong to a synced job.
  • The prime contract has unintentionally been added to two projects in your company's Procore account.
  • The prime contact has already been synced and there are no new un-synced line items.

• Users who are granted only 'Standard' level permission to the ERP Integrations tool can view information, but do not have sufficient permission to accept/reject PCCOs for export.

• Create or update the PCCO in Procore.
• The PCCO must be sent to the ERP Integrations tool.
• If any changes have been made to the prime contract in Sage Intacct®, make sure those changes are synced to Procore.
• Before you can send a PCCO to the ERP Integrations tool, it must be in the Approved status. 
  Note: Users with 'Admin' level permission on the project can change the status of a PCCO manually within the PCCO; Accounting Approvers can change the status of a PCCO by approving it for export through the ERP integrations tool. 
• To export a PCCO from the ERP Integrations tool to Sage Intacct®, you must first sync the project’s budget.

• If you delete a direct cost in Sage Intacct®, Procore will delete the corresponding direct cost.
• If you do not want Procore to delete the direct cost, you should turn on the 'Enable reversal of unpaid bills' setting in Sage Intacct® to have the reversed transaction brought into Procore as a negative amount.
• When you add a new line item to an invoice, the invoice gets updated in Procore. If you add a new line item on a payroll/expense, then the line item is brought over as a new Direct Cost transaction in Procore.
• Procore does not detect updates to existing line items, however you can make updates manually in Procore with the Edit Direct Cost feature.

• A user with 'Admin' permission on the project's Admin tool must enable the job cost transaction detail syncing capability. 
• Your Procore Administrator must update your project's budget view(s) to complete these steps:
  1. If you have previously added columns to your budget view for job cost summary information, you will need to remove both the existing 'ERP Direct Costs' calculated column and the 'ERP Job to Date Costs' source column. 
  2. After removing these columns, you will need to add the recommended columns for job cost transaction detail syncing to your budget view(s). 

• 'Units'
• 'Received Date'