Resolve Original or Revised Estimate Discrepancies in Sage 300 CRE®

When comparing budget totals between Procore and Sage 300 CRE, you may notice a discrepancy between Procore's Revised Budget total and Sage 300 CRE's Total Estimate.

Common Causes

Discrepancies typically occur due to:

• Unsynced PCCOs: Approved PCCOs in Procore reflect on the Procore Budget immediately, but will not appear in Sage 300 CRE until synced via the ERP Integrations tool.

• Direct Sage Entries: Approved Estimate Changes entered directly into Sage 300 CRE do not sync back to Procore.

• Column Aggregation Differences: Sage 300 CRE combines Budget Changes and PCCOs into a single Approved Estimate Changes column, whereas Procore displays them separately.

Before troubleshooting line items, confirm the following preliminary checks:

• Budget Status: Ensure the Procore budget is fully synced and there are no pending Job Updates waiting to be exported.

• Posted Batches: Verify that all budget batches sent from Procore have been posted in Sage Job Cost.

• PCCO Sync Status: Confirm that all Prime Contract Change Orders (PCCOs) have synced and been posted in Sage.

• Report Filter Settings in Sage: Ensure you are using the correct Sage Job Cost report view.

  Important!

  Remove the condition Activity Condition EQ X when printing/viewing the report. Default Sage Job Cost reports will drop budget lines that have a $0 revised balance, which can cause artificial discrepancies.

Use the steps below to identify and troubleshoot estimate discrepancies between Procore and Sage 300 CRE®.

• Export the Cost Estimate Entries Report from Sage 300 CRE

• Compare Cost Code / Cost Type Lines

• Resolutions

• Escalation / Contact Support

To perform a line-by-line comparison, pull the detailed transaction report from Sage:

1. Open Sage 300 CRE and navigate to Job Cost > Inquiries > Entries > Cost / Estimate Entries.

2. Select the relevant Job, then choose Estimate Entries from the drop-down list.

3. Click a column header, then click Add on the right menu to add the following columns:

   • Chg Mgmt Ref 1

   • Transaction Date

   • Date Stamp

   • Batch

4. Click the Excel icon to export the report.

1. Compare the Sage report against your Procore Budget view line-by-line.

2. Check Original Budget First: Compare the Original Budget Amount column between both systems before looking at changes.
   Note: If the Original Budget does not match between systems, the Revised Budget totals will never balance.

3. Check Approved Changes: Compare the combined total of Procore's Budget Modifications and PCCOs against Sage's Approved Estimate Changes.

Once you have identified the specific cost codes out of alignment, choose one of the following methods to reconcile the amounts:

Option 1: Post Manual Adjustments in Sage 300 CRE

Enter a manual estimate adjustment entry directly in Sage Job Cost or Project Management to bring the out-of-balance cost codes into alignment with Procore.

Option 2: Reverse Duplicated Batches in Sage

If the discrepancy was caused by an accidental double-export or duplicate batch posting in Sage, use Sage 300 CRE's Reverse Estimate Batch Report tool to remove the duplicated batch.

Option 3: Reconcile via Procore Budget Changes

If changes were entered directly into Sage and need to be aligned without double-posting in Sage:

1. Create a Budget Change in Procore to match the amounts recorded in Sage.

2. Export the Budget Change batch to the ERP Integrations tool.

3. Do not post the batch in Sage. Instead, move or discard the batch file in Sage so the values in Procore balance without altering Sage's posted totals.

If you have completed the troubleshooting steps above and are still unable to resolve the budget discrepancy, please Contact Support with the following information ready to expedite your request:

1. Project Name and Job Number in Sage 300 CRE.

2. Exported Sage Report: Attach the exported Excel file from the Cost / Estimate Entries inquiry in Sage 300 CRE (including the Chg Mgmt Ref 1, Transaction Date, Date Stamp, and Batch columns).

3. Procore Budget Details: Identify the specific cost codes/cost types (categories) that are out of balance between the systems.

4. Prerequisites Status: Confirmation that all batches in Sage are fully posted and no pending job updates or unsynced PCCOs remain.