Project Management migration

Migrate from Deltek WorkBook to Microsoft Project

Field-level mapping, validation, and rollback between Deltek WorkBook and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.

Deltek WorkBook logo

Deltek WorkBook

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

75%

9 of 12

objects map 1:1 between Deltek WorkBook and Microsoft Project.

Complexity

BStandard

Timeline

2-4 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Deltek WorkBook to Microsoft Project is a scoped extraction, not a full platform migration. Deltek WorkBook is a project-based agency ERP that ties projects, tasks, resources, time entries, financial records, and CRM data into a single relational model. Microsoft Project is a scheduling and work-management tool with no built-in financial accounting, no CRM module, and no equivalent to WorkBook's 31-dimension tagging system. We migrate the project-management layer — Projects, Tasks with WBS hierarchy, Resources, and Time entries — and we flag every other WorkBook module (Finance, CRM, Pipelines, Purchase Orders, Invoices, Dimensions, Automations) as having no destination. We sequence the migration to preserve task hierarchy and predecessor relationships from WorkBook's WBS into Project's outline structure, and we handle the MPP-file versus Project Online API extraction path depending on the customer's destination version. Automations and reporting templates do not migrate; we deliver a written inventory of both for the admin to rebuild.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Deltek WorkBook logo

Deltek WorkBook

What's pushing teams away

  • Non-intuitive interface and steep learning curve create adoption friction, especially for non-technical team members unfamiliar with dense project-based ERP systems.
  • Limited custom reporting, particularly in the finance module, frustrates finance leads who need tailored financial statements and profitability views.
  • Regular users experience information overload due to the breadth of the platform — multiple modules, dashboards, and configuration options without guided workflows.
  • Occasional Danish words appearing in the English interface signal localisation inconsistencies that erode confidence in multi-language deployments.
  • Dashboards and the mobile expense app have been described as not production-ready by reviewers, leading teams to use workarounds for reporting and field expenses.

Choosing

Microsoft Project logo

Microsoft Project

What's pulling them in

  • Organizations already running Microsoft 365 and Azure AD adopt Microsoft PPM because it slots into existing identity, Teams, and SharePoint infrastructure without requiring a separate identity provider or SSO vendor.
  • Enterprise PMOs choose it for critical-path scheduling, baseline comparison, cross-project dependencies, and resource utilization reporting that standalone PM tools cannot replicate at this depth.
  • Project Online's integration with Power BI gives portfolio-level dashboards and cost-rollup reporting that satisfies executive governance requirements without third-party BI tooling.
  • Government, financial services, and healthcare organizations select it because FedRAMP, ISO 27001, and SOC 2 compliance certifications meet enterprise procurement requirements out of the box.
  • Large IT departments default to it as the market-leader in project portfolio management software, often driven by corporate licensing agreements that bundle it with other Microsoft 365 seats.

Object mapping

How Deltek WorkBook objects map to Microsoft Project

Each row shows how a Deltek WorkBook object lands in Microsoft Project, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Deltek WorkBook

Project

maps to

Microsoft Project

Project (MPP or Project Online Project)

1:1
Fully supported

Deltek WorkBook Projects map directly to Microsoft Project as the top-level container. Project name, start date, finish date, status, and budget total migrate. WorkBook project templates map to Project's template format (.mpt for desktop, Project Online template library). Multi-company WorkBook configurations that reference separate legal entities require separate Project Online sites or separate MPP files per entity. Project-level custom fields migrate to Project-level custom fields in Project Online or outline codes in desktop MPP.

Deltek WorkBook

Task

maps to

Microsoft Project

Task

1:1
Fully supported

WorkBook Tasks map to Microsoft Project Tasks with the WBS hierarchy preserved as parent-child outline levels. Task name, start and finish dates, duration, % complete, priority, and notes migrate. WorkBook's Kanban-status (To Do, In Progress, Done) maps to a custom text field or Task Status picklist in Project since Project uses % complete and duration-based scheduling rather than Kanban states. Predecessor relationships from WorkBook's task dependencies map to Project predecessor fields. Subtasks with independent scheduling in WorkBook map as summary tasks or as separate tasks with a parent reference.

Deltek WorkBook

Resource / Worker

maps to

Microsoft Project

Resource

1:1
Fully supported

WorkBook Workers (team members with skills, availability, and utilisation data) map to Microsoft Project resources. Max Units and Standard Rate migrate from WorkBook's hourly cost and capacity. WorkBook skills and certifications have no direct Project equivalent — we map skill tags to a Resource custom field (text, multi-value) so that the information is preserved. WorkBook's availability calendars migrate as Project resource calendars, with calendar exceptions for holidays and planned time off carried forward. Generic resources in WorkBook map to generic resources in Project.

Deltek WorkBook

Task Assignment

maps to

Microsoft Project

Assignment

1:1
Fully supported

WorkBook's resource assignments against tasks (which worker is assigned to which task with what hourly rate) map to Project Assignments. WorkBook's assigned hours migrate as Assignment Work (hours), WorkBook's task budget hours migrate as Assignment Units. The Work (hours) field drives Project's scheduling calculation against the resource's calendar and Max Units.

Deltek WorkBook

Time Entry

maps to

Microsoft Project

Task Actual Work or Timesheet (via Assignment)

1:many
Fully supported

WorkBook time entries against Projects and Tasks aggregate into Project Assignment Actual Work. Since Project does not have a dedicated timesheet ledger, we summarise WorkBook's submitted and approved hours by task-assignment pair and write them as Assignment Actual Work values. Historical time-entry timestamps and billable/non-billable flags migrate as custom fields on the Assignment. Time-entry approval status does not migrate — Project does not have an approval workflow engine for timesheets. Unapproved time entries migrate as Actual Work with a note that they require re-approval post-migration.

Deltek WorkBook

CRM Contact

maps to

Microsoft Project

Contact (Project Online SharePoint list or custom field)

lossy
Fully supported

WorkBook CRM Contacts have no native Microsoft Project equivalent — Project stores resources (people), not contact records. We offer two migration strategies: (1) map contacts to a SharePoint Contacts list in the associated Project Online site, preserving name, email, and company; or (2) add a Contact custom field on tasks that references the WorkBook contact name for audit. The customer chooses the strategy at scoping. WorkBook contact-to-project relationships migrate as a Contact custom field on the Project.

Deltek WorkBook

CRM Company

maps to

Microsoft Project

Account (SharePoint list or Project custom field)

lossy
Fully supported

WorkBook CRM Companies map to a SharePoint list in Project Online or to a Company custom field on Projects, depending on the customer's choice made at scoping. Microsoft Project does not have an Account or Company object, so this is a configuration migration rather than a native object migration. Company billing rates and industry tags from WorkBook do not have Project equivalents and are documented in the handoff inventory.

Deltek WorkBook

Pipeline / Opportunity

maps to

Microsoft Project

Not migratable

1:1
Fully supported

WorkBook pipeline stages and opportunity data are CRM objects that have no Microsoft Project equivalent. Project has no pipeline, deal stage, win/loss, or probability model. We flag this as a scope boundary: pipeline and opportunity data do not migrate. We extract the data as a structured CSV and deliver it to the customer as a reference document for manual re-entry or for import into a separate CRM if they adopt one post-migration.

Deltek WorkBook

Finance: Invoice / AR / AP

maps to

Microsoft Project

Not migratable

1:1
Fully supported

WorkBook's financial module (invoices, accounts receivable, accounts payable, payment status, AR ageing, subscription billing) has no Microsoft Project equivalent. Project has no accounting ledger, no invoicing, no AR/AP, and no financial reconciliation model. We do not migrate financial records. We export a snapshot of outstanding AR, open invoices, and WIP as a structured CSV for the customer's finance team to reconcile in their chosen accounting system.

Deltek WorkBook

Chart of Accounts + Dimensions

maps to

Microsoft Project

Not migratable

1:1
Fully supported

WorkBook's Chart of Accounts with 21 built-in Dimensions and up to 10 custom Dimensions (31 total per transaction) cannot map to Microsoft Project. Project has no chart of accounts, no journal entries, no cost centres, and no multi-dimensional tagging model. WorkBook Dimensions tagged against Projects and Tasks require a customer-defined strategy for how to handle cost attribution in the absence of a dimensional accounting system. We deliver a Dimension-mapping matrix documenting each WorkBook dimension label and its current usage, leaving the mapping decision to the customer.

Deltek WorkBook

Purchase Order

maps to

Microsoft Project

Not migratable

1:1
Fully supported

WorkBook Purchase Orders tied to Projects and Vendors have no Microsoft Project equivalent. Project has no purchasing, vendor commitment, or PO lifecycle model. We export open PO data as a structured CSV for the customer's finance team.

Deltek WorkBook

System and Company Variables

maps to

Microsoft Project

Not migratable

1:1
Mapping required

WorkBook System Variables and Company Variables (numbering sequences, workflow flags, integration settings, configuration flags) are platform-specific configuration that cannot map to any Microsoft Project object. We extract these as a structured JSON bundle during the technical audit and hand them to the customer for manual review. Any variable that references a migrated record ID is flagged in the bundle.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Deltek WorkBook logo

Deltek WorkBook gotchas

High

WorkBook REST API is versioned with deprecation cycles

Medium

Data Export requires Finance & Administration access

Medium

System Variables and Company Variables are not migrated automatically

Low

21 built-in Dimensions plus 10 custom ones require explicit mapping

Microsoft Project logo

Microsoft Project gotchas

High

Project for the web is being retired and merged into Microsoft Planner

Medium

Planner-tier portfolio features are incomplete despite Plan 5 labeling

Medium

Web app constraint controls are weaker than the Windows desktop client

High

Project requires a separate license not bundled with standard Microsoft 365

Medium

Project Online API is edition-gated and inconsistently documented

Pair-specific challenges

  • Finance, CRM, and pipeline data have no Microsoft Project destination

    Microsoft Project is a scheduling and work-management tool. It has no accounting ledger, no AR/AP, no invoicing, no Chart of Accounts, no CRM module, no pipeline, and no opportunity management. Migrating from WorkBook's integrated ERP to Project means accepting a scope boundary: project plans, tasks, resources, and time data are the migratable layer. Invoices, POs, AR ageing, CRM contacts, CRM companies, pipeline stages, WorkBook Dimensions, and system variables do not migrate. We extract each of these as a structured CSV and deliver it to the customer's finance and CRM team as a manual re-entry reference. Teams that need both a PM tool and an ERP must plan a second implementation for the financial layer.

  • WorkBook Dimensions cannot map to any Project field

    WorkBook's dimensional accounting model allows every transaction up to 31 dimension tags (21 built-in plus 10 custom). Microsoft Project has no dimensional model — there is no chart of accounts, no cost-centre tagging, and no multi-tag transaction classification. Outline codes in desktop Project are the closest structural analog but they are not multi-select and they have no financial calculation role. We present a dimension-mapping matrix at scoping: for each WorkBook dimension in active use, the customer decides whether to map it to a Project custom field, a SharePoint column, a resource custom field, or to drop it from migration scope. Skipping this step means dimension-tagged transactions in WorkBook arrive in Project without their classification tags.

  • WorkBook API version deprecation can silently produce empty extracts

    WorkBook releases versioned API endpoints (currently 14.0) and deprecates prior versions (13.8, 13.6) on short notice. Deprecated endpoints produce empty result sets rather than error responses, which can silently corrupt a migration extract if the customer has not upgraded their API version. We pin migrations to the customer's current API version at scoping, verify endpoint availability with a pre-extraction probe, and re-test if the customer has not upgraded before extraction begins. Any integration the customer has built against deprecated endpoints also fails post-migration and requires a separate fix outside migration scope.

  • Data Export requires Finance & Administration access in WorkBook

    WorkBook's native Data Export function sits inside the Finance & Administration module under Export, Import & Maintenance and requires specific User Access Rights. If the migrating user's account lacks Finance & Administration access, the Data Export grid returns empty. We confirm access scope during the technical audit. If access is insufficient, we request elevated permissions or fall back to the WorkBook REST API for project, task, resource, and time data. Finance module data requires Finance & Administration access regardless of which extraction path is used.

  • MPP file format and Project Online API have different extraction paths

    Microsoft Project desktop (MPP) files and Project Online (the cloud product) use different data storage models. MPP files are binary and require a desktop installation or a third-party library to parse. Project Online exposes a REST API (ProjectData endpoint) that we can query directly. If the customer's destination is Microsoft Project for the Web (the newer cloud product), the migration uses the Microsoft Graph API with different field names and object hierarchies from Project Online. We determine the destination product version at scoping and use the corresponding extraction endpoint. MPP files from the legacy desktop product require a different import pipeline than cloud-native API writes.

Migration approach

Six steps for a successful Deltek WorkBook to Microsoft Project data migration

  1. Technical audit and API verification

    We audit the source WorkBook instance for API version, active modules (CRM, Finance, Project Management), user access rights, and record volumes across Projects, Tasks, Resources, and Time. We verify the API version endpoint availability with a pre-extraction probe to confirm no deprecated endpoints will silently produce empty results. We confirm whether the migrating user has Finance & Administration access for financial module extraction or whether a REST API fallback is required. We document the destination Microsoft Project product version (Project Plan 1, 3, or 5; desktop MPP or Project Online; Project for the Web) and confirm the extraction path. The audit output is a written migration scope document.

  2. Scope boundary definition and unmigratable-object inventory

    We define the migration boundary explicitly: Projects, Tasks with WBS hierarchy, Resources, Task Assignments, and Time Entries are migratable. CRM Contacts, CRM Companies, Pipelines, Invoices, AR/AP, Chart of Accounts, Dimensions, Purchase Orders, and System Variables are not migratable to Microsoft Project. We extract each unmigratable object as a structured CSV or JSON bundle and deliver it to the customer's team with a field-description key. We present the WorkBook Dimension-mapping matrix for the customer to assign each dimension to a Project custom field, SharePoint column, or drop-list. The customer signs off the scope boundary before extraction begins.

  3. Source data extraction and task hierarchy validation

    We extract Projects, Tasks, Resources, and Time Entries via the WorkBook REST API (or Data Export with Finance & Administration access if available). Task hierarchy is extracted as a flat list with parent_task_id references; we reconstruct the WBS outline structure from the parent-child relationships. Resource calendars and availability data extract from WorkBook's worker availability tables. We validate the extracted WBS depth, predecessor link count, and resource-assignment ratio against the WorkBook source before transformation begins. Any records that fail integrity checks (orphan tasks, circular predecessor loops, missing parent projects) are flagged in a pre-transform exception report for the customer to resolve.

  4. Schema setup and destination validation in sandbox

    We set up the destination Microsoft Project environment (Project Online site or desktop project file) with the correct license tier, resource pool structure, and custom fields defined from the WorkBook field-mapping matrix. If the destination is Project Online, we provision the SharePoint site and any required Microsoft 365 group. We validate the custom field schema by importing a single project with a representative task hierarchy, checking that outline levels, predecessors, and resource assignments render correctly. The customer validates the sandbox import against the WorkBook source and signs off before production extraction.

  5. Production extraction and staged import

    We run the production extraction from WorkBook with the verified API version and field-mapping matrix applied. The import runs in three phases: (1) Projects and top-level metadata; (2) Tasks with WBS hierarchy and predecessor links; (3) Resources, Assignments, and Actual Work from time entries. We write to the destination via the appropriate path (Project Online REST API for cloud, MPP file import for desktop). Each phase emits a row-count reconciliation report. Time-entry billable/non-billable flags and submission status are preserved as custom fields on Assignments since Project has no native timesheet approval model.

  6. Cutover, validation, and unmigratable-object handoff

    We freeze WorkBook writes during cutover and run a delta extraction of any records modified during the migration window. We validate the production import by spot-checking a random sample of 25-50 tasks and assignments against the WorkBook source. We deliver the unmigratable-object bundles (CRM CSV, financial CSV, Dimension matrix, System Variables JSON) to the customer's CRM, finance, and admin teams with field-description keys. We provide a written automation inventory listing any WorkBook workflows, approval chains, and notification rules that require rebuilding in Power Automate (a separate product from Microsoft Project) or as manual procedures. We support a one-week post-cutover reconciliation window.

Platform deep dives

Context on both ends of the pair

Deltek WorkBook logo

Deltek WorkBook

Source

Strengths

  • Integrated project management, resource planning, and full financial accounting in a single platform.
  • 300+ built-in reports and configurable dashboards for agency performance visibility.
  • Multi-company, multi-currency, and inter-company transaction support for complex agency structures.
  • Mobile apps for iOS and Android with Kanban task view and time/expense entry on mobile.
  • Resource scheduling with skills matching, availability, and utilisation tracking.

Weaknesses

  • Non-intuitive interface with steep learning curve and information overload for new users.
  • Limited custom reporting, especially in the finance module — finance leads frequently use external BI tools.
  • Dashboards and mobile expense app have been described as not production-ready by users.
  • API has versioned endpoints with deprecation cycles that require integration maintenance.
  • No public pricing — quotes are custom per organisation and require a sales call.
Microsoft Project logo

Microsoft Project

Destination

Strengths

  • Deep critical-path scheduling with baseline comparison and cross-project dependency tracking unmatched by lighter PM tools.
  • Native Azure AD authentication, Teams integration, and Power BI reporting sit on infrastructure enterprises already license and manage.
  • Enterprise governance controls including demand intake workflows, resource request approval, and portfolio-level capacity analysis.
  • Supports both Waterfall and Agile methodologies within the same project, accommodating hybrid delivery teams.
  • Scalable from Project Plan 1 for small teams to Project Server on-premises for regulated industries with strict data-sovereignty requirements.

Weaknesses

  • Ease-of-use scores trail the category average by a wide margin; onboarding friction frustrates new users consistently across G2 and Capterra reviews.
  • Pricing ranks 42nd of 49 tools in its category — the total cost of ownership including IT administration and training is rarely recovered for small or mid-market teams.
  • No built-in client portal, external stakeholder sharing, or proofing workflow, limiting use cases to internal PMO environments only.
  • The web interface (Project for the web / Planner Premium) has materially weaker constraint controls and resource auto-leveling than the Windows desktop client.
  • Project for the web is being consolidated into Microsoft Planner, creating uncertainty about which product tier will host project portfolio data long-term.

Complexity grading

How hard is this migration?

Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Deltek WorkBook and Microsoft Project.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Deltek WorkBook: Not publicly documented by Deltek for WorkBook.

  • Data volume sensitivity

    A

    Deltek WorkBook exposes a bulk API — large-volume migrations stream efficiently.

Estimator

Estimate your Deltek WorkBook to Microsoft Project migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Deltek WorkBook to Microsoft Project data migrations

Answers to the questions buyers ask most during Deltek WorkBook to Microsoft Project migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Deltek WorkBook to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most migrations land between two and four weeks for accounts under 500 active projects, 5,000 tasks, and 200 resources. Migrations with deep WBS hierarchies, cross-project dependencies, large time-entry histories (over 100,000 rows), or multiple WorkBook company entities that map to separate Project Online sites move to five to nine weeks because of hierarchy validation, resource calendar resolution, and delta reconciliation work. Finance module extraction and Dimension mapping for audit purposes add separate scoped work.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Deltek WorkBook.
Land in Microsoft Project, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day