Docs/Master Data/Project Management

Project Management

Track project costs, revenue, team allocation, milestones, and time entries across multiple legal entities

10 min read

Project management in the AI-Native ERP provides a centralized database of projects across all your legal entities. Track costs, revenue, team assignments, milestones, and time entries -- with full integration into your general ledger for accurate project profitability analysis.


Why Project Management Matters

Without project management:

  • An invoice comes in -- which project does it belong to? Who is paying? What budget?
  • An employee logs time -- which project? Is it billable? At what rate?

With project management:

  • PROJ-000001 -- Website Redesign: Customer ABC, Budget $50K, 3 team members
  • Expense tagging: "AWS hosting" is automatically linked to PROJ-000001, Department IT
  • Time tracking: 40 hours at $150/hr = $6,000 billable
  • Multi-entity: Billed by US entity, delivered by UK entity

Key Benefits

  1. Global project database -- single source of truth across all entities
  2. Multi-entity assignments -- one project can span multiple legal entities
  3. Team collaboration -- track roles, time allocation, and billable rates
  4. Time and expense tracking -- link costs directly to projects
  5. Milestone billing -- invoice based on deliverables
  6. Dimension integration -- tag with departments, cost centers, campaigns
  7. Complete audit trail -- full history of project changes and allocations

Multi-Entity Architecture

Projects follow the Master + Entity Assignment pattern:

Master Projects (Organization-wide)
  PROJ-000001 - Website Redesign
  Identity: name, customer, budget, dates
  One record per project
        |
        v
Entity Assignments (Per-entity execution)
  Entity 10: Website project (US billing, PM: John)
  Entity 11: Website project (UK delivery, PM: Jane)
  Each entity has own manager, status, budget
        |
        v
Effective View (What each entity sees)
  Entity 10: 15 active projects
  Entity 11: 8 active projects
  Resolved: Master + Entity details

Projects require explicit entity assignment -- they don't automatically appear in all entities. This gives you control over:

  • Which entities participate in each project
  • Separate billing and delivery entities
  • Independent budget allocation per entity
  • Different project managers per entity
  • Independent status tracking (active in one entity, on hold in another)

Project Properties

Master Project (Organization-Level)

PropertyRequiredDescriptionExample
Project nameYesProject nameWebsite Redesign
Project codeNoUser-friendly codeWEB-2024-01
Global project IDAutoSystem-generated unique IDPROJ-000001
CustomerNoClient for this projectLink to customer record
Budget amountNoTotal project budget50,000.00
CurrencyNoBudget currencyUSD
Start/end datesNoProject timeline2024-01-15 to 2024-06-30
Project typeNoCategoryconsulting, development, implementation
StatusAutoCurrent stateplanning, active, completed
External referenceNoExternal system IDJIRA-123, SF-456

Entity Assignment (Per-Entity)

PropertyDescriptionExample
Project managerEntity-specific PMEmployee ID
StatusEntity-specific statusactive, on_hold
PriorityProject priorityhigh, medium, low
Budget amountEntity budget allocation30,000.00 (of $50K total)
CurrencyEntity currencyMay differ from master
Billing modelHow to billtime_and_materials, fixed_price, milestone, retainer
Planned marginTarget margin25%

Project Status Lifecycle

StatusDescriptionCan Bill?Can Track Time?
planningPre-kickoff planningNoNo
activeActively executingYesYes
on_holdTemporarily pausedMaybeYes
completedSuccessfully finishedYes (final)No
cancelledProject cancelledNoNo
archivedHistorical recordNoNo

Project Types

TypeDescriptionCommon Use
consultingProfessional servicesAdvisory, strategy
developmentSoftware developmentCustom apps, integrations
implementationSystem implementationERP rollout, migrations
maintenanceOngoing supportRetainers, managed services
internalInternal projectsIT infrastructure, R&D

Billing Models

ModelDescriptionWhen to Use
time_and_materialsBill by hours workedConsulting, support
fixed_priceSingle total priceWell-defined scope
milestoneBill on deliverablesPhased projects
retainerMonthly recurringOngoing services

Team Management

Track who is working on each project with roles, allocation percentages, and billable rates.

Team Member Properties

PropertyDescriptionExample
EmployeeTeam member referenceEntity employee ID
RoleTeam roleDeveloper, Designer, PM, QA
Billable rateHourly billing rate$150.00
Allocation %Percentage of time on project75%
Start/end datesAssignment periodJan 15 - Jun 30

Team Operations

  • Add team members with role, rate, and allocation
  • Update allocation percentages or billable rates as needs change
  • Remove team members when their work is complete

Milestones & Deliverables

Track project deliverables and link them to billing.

Milestone Properties

PropertyDescriptionExample
NameDeliverable namePhase 1: Design
DescriptionDetailsComplete all UI mockups
Due dateExpected completion2024-02-28
AmountBilling amount$10,000.00
SequenceOrder1, 2, 3
StatusProgresspending, in_progress, completed, invoiced
Completion dateActual completion2024-02-25

Milestone Workflow

pending --> in_progress --> completed --> invoiced

When a milestone is completed, it can be linked to an invoice transaction for billing.

Example: Fixed-Price Project

A $50K fixed-price project with milestone-based billing:

PhaseDue DateAmount
DesignFeb 28$10,000
DevelopmentApr 30$25,000
TestingMay 31$5,000
DeploymentJun 15$5,000
TrainingJun 30$5,000

Tasks & Time Tracking

Project Tasks

Simplified task tracking to organize project work:

PropertyDescriptionExample
Task nameTask titleCreate login page
AssigneeResponsible personEmployee reference
MilestoneParent milestoneLink to milestone
Due dateExpected completion2024-02-15
Estimated hoursTime estimate16.0
Actual hoursTime spent (auto-calculated)18.5
PriorityTask priorityhigh, medium, low
StatusProgresspending, in_progress, completed

Time Tracking

Track billable and non-billable time for project costing and client billing:

PropertyDescriptionExample
EmployeeWho workedEmployee reference
DateDate of work2024-02-10
HoursHours worked8.0
DescriptionWhat was doneImplemented login UI
TaskRelated taskLink to task
BillableBill to client?Yes/No
Billable rateRate for this entry$150.00

Time Entry Approval Flow

draft --> submitted --> approved --> billed
                   \-> rejected --> draft (revise and resubmit)

Time entries follow a structured approval flow:

  1. Employee creates entry in draft status
  2. Employee submits for approval
  3. Manager approves or rejects
  4. Approved entries become available for billing

Expense & Revenue Allocation

Link financial transactions to projects for accurate profitability tracking.

Expense Allocation

Track project costs by linking expenses to projects:

  • AWS hosting costs linked to the software project
  • Contractor invoices split across multiple projects
  • Travel expenses tagged to specific project engagements
  • Retroactive allocation of existing expenses

Splitting Costs Across Projects

A single expense (e.g., a $10K contractor invoice) can be split across multiple projects:

  • 60% ($6,000) to Website Redesign project
  • 40% ($4,000) to Mobile App project

Revenue Allocation

Link revenue transactions to projects for profitability analysis:

  • Invoice payments linked to project milestones
  • Recurring revenue attributed to ongoing projects

Project Dimensions

Projects integrate with the dimension system for additional analytical tagging:

  • Assign department, cost center, or campaign dimensions to projects
  • Enable cross-dimensional reporting (e.g., "Project Alpha costs by department")
  • Dimensions are entity-specific, supporting different organizational structures

Fixed Asset Assignment

Link fixed assets to projects for capital expenditure tracking:

  • Track equipment assigned to specific projects
  • Monitor depreciation costs per project
  • Transfer assets between projects when needs change

Project History & Audit

Every project change is recorded in a complete audit trail:

  • Project creation and updates
  • Entity assignments and status changes
  • Team member additions and removals
  • Milestone completions
  • Time entry approvals
  • Expense and revenue allocations

This ensures full traceability for compliance and financial auditing.

← PREVIOUSDimensions & AnalyticsNEXT →Legal Entity Management