Others

How to Fix Incorrect Epic Resource Hours and Cost in MS Project with Jira Integration

Steven ParkerSteven Parker Nov 2, 2026 870 views

Question details

Users need to resolve a calculation error in Microsoft Project where assigning a resource name to an epic via Jira integration causes inaccurate hours and costs.

How to Fix Incorrect Epic Resource Hours and Cost in MS Project with Jira Integration
Product
Microsoft Project, CeptahBridge
Device & OS
not provided
Scenario
Synchronizing project epics from Jira to Microsoft Project using the CeptahBridge integration plugin.
Observed behavior
When an epic is mapped and assigned a resource name through CeptahBridge, Microsoft Project calculates the resource hours and cost incorrectly, often due to duplicated values.
Before you start

Ensure you are using the latest version of the CeptahBridge plugin and back up your current MS Project file before making any changes to your synchronization settings.

Solution 1Recommended

Review CeptahBridge Mapping and Resource Assignments

Verify and adjust the integration mapping settings to prevent Microsoft Project from duplicating the work and cost values assigned to Jira epics.

In many Jira-to-MS Project integrations, calculation errors occur when both the parent epic and its child tasks push their estimated work hours into MS Project. This causes MS Project's built-in rollup features to double-count the hours and costs.

1
Open CeptahBridge settings

Launch Microsoft Project and open the CeptahBridge integration configuration menu.

2
Check resource assignments

Navigate to the resource mapping section and verify that the Jira epic fields are mapped to the correct MS Project resource fields.

3
Prevent duplicate rollups

Check your synchronization rules to ensure that work and cost values are not being applied to both the epic level and the sub-task level simultaneously.

4
Test the synchronization

Run a test sync on a sample project to confirm that the hours and costs align perfectly with your original Jira data.

Review CeptahBridge Mapping and Resource Assignments
Contact CeptahBridge Support: If you have verified that the mappings are correct and the calculation is still wrong, contact CeptahBridge support. Provide them with an example project file and your synchronization logs for further assistance.
Free Microsoft Office alternative

Looking for a Lightweight Alternative to Microsoft Office?

While resolving complex integration issues in MS Project, you may find that everyday documentation, spreadsheet tracking, and presentations are easier with a more streamlined suite. WPS Office offers a completely free, highly compatible alternative for managing your standard office tasks.

  1. 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the lightweight office suite on your device.
  3. 3. Open existing files: Double-click your existing Microsoft Office documents to seamlessly open and edit them in WPS Office.
Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight software that installs quickly and uses minimal system resources.Built-in free PDF editing, conversion, and annotation tools.Access to a rich library of free project management and tracking spreadsheet templates.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Jira integration cause duplicate resource hours in MS Project?

Duplicate hours typically occur when both a parent epic and its underlying child tasks sync their estimated work to MS Project. MS Project automatically rolls up sub-task hours to the parent task, effectively counting the work twice if the parent also imports a static value.

How can I prevent cost miscalculations when syncing Jira with MS Project?

You can prevent this by configuring your CeptahBridge mapping to explicitly define how cost fields are handled. You may need to disable automatic MS Project cost roll-ups for epics if Jira is already supplying the total calculated cost.

Can I manually adjust the epic hours in MS Project after a Jira sync?

Yes, you can manually override the calculated hours in MS Project. However, the next time you synchronize with CeptahBridge, your manual changes may be overwritten unless you configure the sync to be strictly one-way or exclude specific fields.