Project Management migration
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
Source
Microsoft Project
Destination
Compatibility
9 of 12
objects map 1:1 between Deltek WorkBook and Microsoft Project.
Complexity
BStandard
Timeline
2-4 weeks
Overview
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.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
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
Microsoft Project
Project (MPP or Project Online Project)
1:1Deltek 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
Microsoft Project
Task
1:1WorkBook 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
Microsoft Project
Resource
1:1WorkBook 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
Microsoft Project
Assignment
1:1WorkBook'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
Microsoft Project
Task Actual Work or Timesheet (via Assignment)
1:manyWorkBook 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
Microsoft Project
Contact (Project Online SharePoint list or custom field)
lossyWorkBook 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
Microsoft Project
Account (SharePoint list or Project custom field)
lossyWorkBook 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
Microsoft Project
Not migratable
1:1WorkBook 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
Microsoft Project
Not migratable
1:1WorkBook'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
Microsoft Project
Not migratable
1:1WorkBook'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
Microsoft Project
Not migratable
1:1WorkBook 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
Microsoft Project
Not migratable
1:1WorkBook 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.
| Deltek WorkBook | Microsoft Project | Compatibility | |
|---|---|---|---|
| Project | Project (MPP or Project Online Project)1:1 | Fully supported | |
| Task | Task1:1 | Fully supported | |
| Resource / Worker | Resource1:1 | Fully supported | |
| Task Assignment | Assignment1:1 | Fully supported | |
| Time Entry | Task Actual Work or Timesheet (via Assignment)1:many | Fully supported | |
| CRM Contact | Contact (Project Online SharePoint list or custom field)lossy | Fully supported | |
| CRM Company | Account (SharePoint list or Project custom field)lossy | Fully supported | |
| Pipeline / Opportunity | Not migratable1:1 | Fully supported | |
| Finance: Invoice / AR / AP | Not migratable1:1 | Fully supported | |
| Chart of Accounts + Dimensions | Not migratable1:1 | Fully supported | |
| Purchase Order | Not migratable1:1 | Fully supported | |
| System and Company Variables | Not migratable1:1 | Mapping required |
Gotchas + challenges
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 gotchas
WorkBook REST API is versioned with deprecation cycles
Data Export requires Finance & Administration access
System Variables and Company Variables are not migrated automatically
21 built-in Dimensions plus 10 custom ones require explicit mapping
Microsoft Project gotchas
Project for the web is being retired and merged into Microsoft Planner
Planner-tier portfolio features are incomplete despite Plan 5 labeling
Web app constraint controls are weaker than the Windows desktop client
Project requires a separate license not bundled with standard Microsoft 365
Project Online API is edition-gated and inconsistently documented
Pair-specific challenges
Migration approach
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.
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.
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.
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.
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.
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
Deltek WorkBook
Source
Strengths
Weaknesses
Microsoft Project
Destination
Strengths
Weaknesses
Complexity grading
Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Deltek WorkBook and Microsoft Project.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
Deltek WorkBook: Not publicly documented by Deltek for WorkBook.
Data volume sensitivity
Deltek WorkBook exposes a bulk API — large-volume migrations stream efficiently.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during Deltek WorkBook to Microsoft Project migration scoping. Not seeing yours? Book a call.
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 consultationAdjacent paths
Other ways to leave Deltek WorkBook
Other ways to arrive at Microsoft Project
Same-Project Management migrations
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.