How to Fix Incorrect Epic Resource Hours and Cost in MS Project with Jira Integration
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.

- 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.
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.
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.
Launch Microsoft Project and open the CeptahBridge integration configuration menu.
Navigate to the resource mapping section and verify that the Jira epic fields are mapped to the correct MS Project resource fields.
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.
Run a test sync on a sample project to confirm that the hours and costs align perfectly with your original Jira data.

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. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the lightweight office suite on your device.
- 3. Open existing files: Double-click your existing Microsoft Office documents to seamlessly open and edit them in 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.




