Project Management migration
Field-level mapping, validation, and rollback between Deltek WorkBook and Trello. We move data and schema; workflows are rebuilt natively in Trello.
Deltek WorkBook
Source
Trello
Destination
Compatibility
6 of 14
objects map 1:1 between Deltek WorkBook and Trello.
Complexity
BStandard
Timeline
3-5 weeks
Overview
Deltek WorkBook is a project-based ERP for agencies integrating project management, CRM, resource planning, and full financial accounting. Trello is a card-based visual work management tool with Boards, Lists, and Cards organised around kanban and custom fields. The architectural gap between an agency ERP and a task-card tool is the central challenge in this migration: Projects map to Boards, Tasks map to Cards, and Pipeline Stages map to Lists, but Invoices, Purchase Orders, Expenses, and the Chart of Accounts have no Trello equivalent and must be exported as JSON snapshots for manual re-entry. We sequence the migration to preserve task hierarchy, assignee assignments, and custom field fidelity, while flagging Board Workspace structure decisions upfront so teams can reorganise before migration begins.
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 Trello, 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
Trello
Board
1:1WorkBook Projects map to Trello Boards. Each WorkBook Project (with its name, status, dates, budget, and description) becomes a Board. We use the Project name as the Board title and the WorkBook project ID stored in a Board custom field as a cross-reference for reconciliation. If the customer uses Project templates in WorkBook, we document the template structure as a Board copy guide for their admin to replicate in Trello.
Deltek WorkBook
Task
Trello
Card
1:1WorkBook Tasks map to Trello Cards within the appropriate Board. Task name becomes Card title, description maps to Card description, due date maps to the due date field, and assignee resolves to a Board Member. Parent-child Task relationships in WorkBook have no native equivalent in Trello — we represent sub-tasks as Cards with a checklist named 'Sub-tasks' on the parent Card, preserving the hierarchy as a checklist structure rather than a native parent-child record relationship.
Deltek WorkBook
Pipeline Stage
Trello
List
1:1WorkBook Pipeline Stages become Trello Lists within a Board. Stage name, order, and win/loss probability percentage migrate to List name, Card position, and a custom field (Probability %) on Cards in that List. Pipeline stages used for CRM opportunities map to a dedicated CRM Board; project task stages map to a separate PM Board. The customer defines the Board-List structure during scoping so we can route the correct stage data to the correct Board.
Deltek WorkBook
CRM Contact
Trello
Card Member / Custom Field
1:1WorkBook CRM Contacts migrate as Trello Board Members invited to Cards where they are a stakeholder, and as a Contact custom field on Cards storing the contact name, email, and phone. Contact-Company associations are preserved by linking Cards to the Board representing the associated Company, or via a Company custom field on each Card. Multi-address and multi-phone contact records are stored in Card description for reference.
Deltek WorkBook
CRM Company
Trello
Card / Custom Field / Label
lossyWorkBook Companies map to Trello Cards on a dedicated Company Board, with each Company record as a Card containing company name, industry, address, and size in Card description and custom fields. Alternatively, the Company name becomes a Card Label (with a consistent colour mapping) on Cards linked to that company, and a Company custom field holds the full company name reference. The customer chooses the strategy during scoping.
Deltek WorkBook
Time Entry
Trello
Card Attachment (JSON)
lossyWorkBook Time Entries (linked to Projects and Tasks with hourly rates, billing status, and date) have no native Trello equivalent. We export time entries as a structured JSON file per Card (referencing the parent WorkBook Task Card) and attach the JSON file to the corresponding Trello Card as a file attachment. Billable vs non-billable flags and approved/pending status are included in the JSON. Customers needing visible time tracking in Trello use a time-tracking Power-Up post-migration.
Deltek WorkBook
Expense
Trello
Card Attachment (JSON)
lossyWorkBook Expense records (with mileage, material, and personal expense categories, receipt attachments, project linkage, and reimbursement status) export as a JSON snapshot attached to the relevant Trello Card. Receipt binary files from WorkBook's file storage are re-attached to the corresponding Card as Card attachments. Trello has no native expense management; customers needing expense tracking post-migration configure a finance Power-Up or use a separate expense tool.
Deltek WorkBook
Worker / Resource
Trello
Board Member
1:1WorkBook Workers (team members with skills, availability calendars, and utilisation data) map to Trello Board Members. We resolve Workers by email address to Trello member accounts. Skill tags, capacity settings, and booking assignments from WorkBook export as a JSON resource profile attached to a Board-level 'Resources' Card or as custom fields on individual Cards. Active vs archived worker status is preserved by Board membership scope.
Deltek WorkBook
Custom Fields / Dimensions
Trello
Custom Fields
lossyWorkBook's 21 built-in Dimensions and up to 10 custom Dimensions per organisation require explicit type-mapping to Trello native custom field types. Text dimensions map to Trello text fields; numeric dimensions map to number fields; date dimensions map to Trello date fields; picklist-based dimensions map to dropdown or label fields. A dimension-mapping matrix is presented to the customer during scoping. Free-tier Trello workspaces have limited native custom field support; Standard tier or above is recommended when migration scope includes more than three custom field types.
Deltek WorkBook
Attachment / Document
Trello
Card Attachment
1:1Files saved to WorkBook Projects, Tasks, or Companies extract via WorkBook's file storage and re-attach to the corresponding Trello Card. We preserve file name, binary content, and original upload date. Large file volumes may require chunking or a file-size pre-check against Trello's per-Board attachment limits. Documents that are not directly task-linked (e.g. org-level policy documents) are attached to a Board-level 'Documents' Card as a reference archive.
Deltek WorkBook
Invoice / Accounts Receivable
Trello
Not migratable (document separately)
lossyWorkBook Invoices (generated from time, expenses, and fixed fees against a Project) have no Trello equivalent. Trello has no native invoice management, billing, or AR tracking. We export invoice records as a structured JSON snapshot including line items, payment status, and age, and deliver this as a written invoice inventory document for the customer's finance team to re-enter manually or migrate to a dedicated accounting tool post-migration.
Deltek WorkBook
Purchase Order
Trello
Not migratable (document separately)
lossyWorkBook Purchase Orders (tied to Projects with vendor commitments, line items, amounts, and status) have no Trello equivalent. We export open and historical PO records as a JSON snapshot and deliver it as a written PO inventory document. Closed POs migrate as read-only historical records in the document. The customer re-enters active PO data manually or uses a separate procurement tool.
Deltek WorkBook
Chart of Accounts
Trello
Not migratable (document separately)
lossyWorkBook's Chart of Accounts with 21 built-in Dimensions and up to 10 custom Dimensions cannot map to Trello, which has no financial accounting schema. We export the full Chart of Accounts and dimension definitions as a structured JSON settings bundle. This bundle is delivered to the customer's finance team for reference if they adopt a dedicated accounting tool alongside Trello. The bundle includes any variables that reference deprecated or migrated IDs, flagged for manual review.
Deltek WorkBook
System and Company Variables
Trello
Not migratable (document separately)
lossyWorkBook System Variables and Company Variables (numbering sequences, workflow flags, and integration settings) export as a structured JSON settings bundle separate from the primary data migration. We flag any variables that reference IDs no longer present post-migration. The bundle is handed to the customer for manual import review; Trello has no native equivalent for system configuration variables.
| Deltek WorkBook | Trello | Compatibility | |
|---|---|---|---|
| Project | Board1:1 | Fully supported | |
| Task | Card1:1 | Fully supported | |
| Pipeline Stage | List1:1 | Fully supported | |
| CRM Contact | Card Member / Custom Field1:1 | Fully supported | |
| CRM Company | Card / Custom Field / Labellossy | Fully supported | |
| Time Entry | Card Attachment (JSON)lossy | Fully supported | |
| Expense | Card Attachment (JSON)lossy | Fully supported | |
| Worker / Resource | Board Member1:1 | Fully supported | |
| Custom Fields / Dimensions | Custom Fieldslossy | Mapping required | |
| Attachment / Document | Card Attachment1:1 | Fully supported | |
| Invoice / Accounts Receivable | Not migratable (document separately)lossy | Fully supported | |
| Purchase Order | Not migratable (document separately)lossy | Fully supported | |
| Chart of Accounts | Not migratable (document separately)lossy | Mapping required | |
| System and Company Variables | Not migratable (document separately)lossy | 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
Trello gotchas
Billing model uses maximum seat quantity at term midpoint
Custom Field data historically stored in pluginData
API rate limits are token-gated and can block bulk migration
Guest-to-paid seat conversion triggers on multi-board membership
Automation command runs are capped per plan and overage triggers upgrade pressure
Pair-specific challenges
Migration approach
Discovery and Board structure design
We audit the source WorkBook portal across Projects, Tasks, Pipeline Stages, Contacts, Companies, custom Dimensions, and attachment volume. We pair this with a Trello workspace audit to confirm the current tier (free, Standard, or Premium) and existing Board count. The discovery output includes a Board-structure proposal: one Board per WorkBook Project or a consolidated Board-per-team approach, with Lists mapped to WorkBook Pipeline Stages. We also identify which financial objects (Invoices, POs, Expenses) require JSON snapshot export versus Trello-native import and confirm whether any archived Cards exist that require pre-export restoration.
Schema design and custom field mapping
We design the destination Trello schema: Board names, List names per Board, custom field names and types per Board, and member invite list per Board. The dimension-mapping matrix from WorkBook's 31-dimension model to Trello custom field types is confirmed with the customer and documented. If the customer requires sub-tasks as native sub-task records (rather than checklist items), we confirm whether Trello Premium is being adopted and configure the Subtasks feature accordingly.
Sandbox migration and reconciliation
We run a full migration into a test Trello workspace using production-like data volume. The customer's project lead reconciles record counts (Boards in, Lists per Board in, Cards in, custom fields populated, members invited) and spot-checks 25-50 random Cards against the WorkBook source. Owner and member assignments are validated. Any mapping corrections — wrong List, missing custom field data, incorrect member resolution — are identified here before production migration begins.
Worker and member reconciliation
We extract every distinct WorkBook Worker referenced on Tasks and Resources and resolve by email against the destination Trello workspace member list. Any Workers without matching Trello accounts go to a reconciliation queue for the customer's admin to provision. Migration cannot complete member assignment without resolved accounts because Trello Cards require valid member references.
Production migration in dependency order
We run production migration in record-dependency order: Board creation (Projects as Boards), List creation (Pipeline Stages as Lists), Card migration (Tasks as Cards with checklist-based sub-tasks), custom field population per Card, Board member invitations resolved from Worker reconciliation, and attachment re-upload from WorkBook file storage. Financial objects (Invoices, POs, Expenses, Chart of Accounts) are exported as structured JSON snapshots and attached to the relevant Cards as file attachments. Each phase emits a row-count reconciliation report before the next phase begins.
Cutover, validation, and automation rebuild handoff
We freeze WorkBook writes during cutover and run a final delta migration of any Cards modified during the migration window. We enable Trello as the system of record and deliver the financial JSON snapshot inventory and the dimension-mapping matrix to the customer's finance and admin teams. We do not migrate WorkBook workflows or automations as Trello Butler rules or Power-Up automations inside migration scope; that is documented separately as a Butler rebuild guide for the customer's admin. We support a one-week hypercare window for reconciliation issues raised by the project team.
Platform deep dives
Deltek WorkBook
Source
Strengths
Weaknesses
Trello
Destination
Strengths
Weaknesses
Complexity grading
Standard Project Management migration. 2 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 Trello.
Object compatibility
2 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 Trello migration scoping. Not seeing yours? Book a call.
Walk through your Deltek WorkBook to Trello 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 Trello
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.