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

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.

Subscribe to new posts

Get notified when we publish new insights on AI-native finance.