Sage Intacct® Setup Guide

• Hierarchy (PARENTID):

  • Valid Parents: Every cost code must be mapped to a valid Parent ID.

  • Three-Tier Logic: For complex structures, the Child must have a Parent, and that Parent must have a Grandparent.

    • Example Structure:

      • Child: 01-04-ABC (where ABC is not all zeros)

      • Parent: 01-04-000

      • Grandparent: 01-00-000

• Cost Code Structure (STANDARDTASKID):

  • Delimiters: Every cost code must have at least one delimiter. "Flat" cost codes with no delimiter are not supported.

  • Consistency: Use the same type of delimiter throughout (e.g., all dashes or all dots).
    Note: Procore may accept a period if it is not being treated as a functional delimiter (e.g., 01-100.01).

  • Segments: Codes should have the same number of segments unless they are a Parent.
    Note: Segment length does not need to be consistent, and alphanumeric characters are allowed.

  • Parent Logic: Procore accepts 01-000 or 01 as a parent for 01-123. The ending dashes and zeros are implied.

• Naming & Status:

  • Unique Names: Both the NAME and PARENTNAME must be unique.

    Tip

    Use Conditional Formatting > Highlight Cell Rules > Duplicate Values in Excel to identify non-unique names before import.

    Note: Differences in capitalization (e.g., "Labor" vs "labor") do not make a name unique.

  • Status: The status must be set to Active for the code to be pulled into Procore.

Sage Intacct® refers to Standard Cost Codes as Standard Tasks. When setting up a Standard Cost Code in Sage Intacct®, the ID will need to include the Parent ID.

Steps to create a new Standard Cost Code (Tasks) in Sage Intacct®:

1. Navigate to Projects → Setup → Standard tasks catalog.
   Note: This may be renamed to Standard cost code catalog in your environment.

2. Click Add.

3. Complete the following fields:

   • ID: Enter the ID required for this task, including the Parent ID.

   • Name: Enter a unique name for the Cost Code.

   • Parent ID: Select the Parent ID from the dropdown menu.

   • Standard Cost Types: Select the standard cost types required for this specific task.
     Note: Other fields in this section are optional.

4. Click Save.

Sage Intacct® has the ability to have hierarchical cost types. Procore does not support hierarchical cost types. All cost types used in the Procore/Sage Intacct® integration will be the Parent Cost Types that are setup in Sage.

Steps to create a new Standard Cost Type in Sage Intacct®:

1. Navigate to Projects → Setup → Standard cost type catalog.

2. Click Add.

3. Complete the following fields:

   • ID: Enter the ID required for this cost type.

   • Name: Enter a unique name for the cost type.

   • GL Account: Select the appropriate GL account.

   • Item ID: Select the appriopriate Item ID.
     Note: Other fields in this section are optional.

4. Click Save.

Each Standard Cost Type requires an assigned Item. Repeat these steps for each Item ID (e.g., Materials, Labor, Equipment).

1. In Sage Intacct®, navigate to Purchasing → Setup → Items.

2. Click Add (if an appropriate Item does not already exist).

3. Complete the following fields:

   • Item type: Must be set to Non-Inventory.

   • Item ID: Enter a short identifier (e.g., M for Materials).

   • Name: Enter the full name for the Item (e.g., Materials).

   • Base unit: Select EA from the list.
     Note: This is required to successfully import commitments from Procore.

4. Click Save.