Project Management
Track project costs, revenue, team allocation, milestones, and time entries across multiple legal entities
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#
- Global project database -- single source of truth across all entities
- Multi-entity assignments -- one project can span multiple legal entities
- Team collaboration -- track roles, time allocation, and billable rates
- Time and expense tracking -- link costs directly to projects
- Milestone billing -- invoice based on deliverables
- Dimension integration -- tag with departments, cost centers, campaigns
- 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)#
| Property | Required | Description | Example |
|---|---|---|---|
| Project name | Yes | Project name | Website Redesign |
| Project code | No | User-friendly code | WEB-2024-01 |
| Global project ID | Auto | System-generated unique ID | PROJ-000001 |
| Customer | No | Client for this project | Link to customer record |
| Budget amount | No | Total project budget | 50,000.00 |
| Currency | No | Budget currency | USD |
| Start/end dates | No | Project timeline | 2024-01-15 to 2024-06-30 |
| Project type | No | Category | consulting, development, implementation |
| Status | Auto | Current state | planning, active, completed |
| External reference | No | External system ID | JIRA-123, SF-456 |
Entity Assignment (Per-Entity)#
| Property | Description | Example |
|---|---|---|
| Project manager | Entity-specific PM | Employee ID |
| Status | Entity-specific status | active, on_hold |
| Priority | Project priority | high, medium, low |
| Budget amount | Entity budget allocation | 30,000.00 (of $50K total) |
| Currency | Entity currency | May differ from master |
| Billing model | How to bill | time_and_materials, fixed_price, milestone, retainer |
| Planned margin | Target margin | 25% |
Project Status Lifecycle#
| Status | Description | Can Bill? | Can Track Time? |
|---|---|---|---|
| planning | Pre-kickoff planning | No | No |
| active | Actively executing | Yes | Yes |
| on_hold | Temporarily paused | Maybe | Yes |
| completed | Successfully finished | Yes (final) | No |
| cancelled | Project cancelled | No | No |
| archived | Historical record | No | No |
Project Types#
| Type | Description | Common Use |
|---|---|---|
| consulting | Professional services | Advisory, strategy |
| development | Software development | Custom apps, integrations |
| implementation | System implementation | ERP rollout, migrations |
| maintenance | Ongoing support | Retainers, managed services |
| internal | Internal projects | IT infrastructure, R&D |
Billing Models#
| Model | Description | When to Use |
|---|---|---|
| time_and_materials | Bill by hours worked | Consulting, support |
| fixed_price | Single total price | Well-defined scope |
| milestone | Bill on deliverables | Phased projects |
| retainer | Monthly recurring | Ongoing services |
Team Management#
Track who is working on each project with roles, allocation percentages, and billable rates.
Team Member Properties#
| Property | Description | Example |
|---|---|---|
| Employee | Team member reference | Entity employee ID |
| Role | Team role | Developer, Designer, PM, QA |
| Billable rate | Hourly billing rate | $150.00 |
| Allocation % | Percentage of time on project | 75% |
| Start/end dates | Assignment period | Jan 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#
| Property | Description | Example |
|---|---|---|
| Name | Deliverable name | Phase 1: Design |
| Description | Details | Complete all UI mockups |
| Due date | Expected completion | 2024-02-28 |
| Amount | Billing amount | $10,000.00 |
| Sequence | Order | 1, 2, 3 |
| Status | Progress | pending, in_progress, completed, invoiced |
| Completion date | Actual completion | 2024-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:
| Phase | Due Date | Amount |
|---|---|---|
| Design | Feb 28 | $10,000 |
| Development | Apr 30 | $25,000 |
| Testing | May 31 | $5,000 |
| Deployment | Jun 15 | $5,000 |
| Training | Jun 30 | $5,000 |
Tasks & Time Tracking#
Project Tasks#
Simplified task tracking to organize project work:
| Property | Description | Example |
|---|---|---|
| Task name | Task title | Create login page |
| Assignee | Responsible person | Employee reference |
| Milestone | Parent milestone | Link to milestone |
| Due date | Expected completion | 2024-02-15 |
| Estimated hours | Time estimate | 16.0 |
| Actual hours | Time spent (auto-calculated) | 18.5 |
| Priority | Task priority | high, medium, low |
| Status | Progress | pending, in_progress, completed |
Time Tracking#
Track billable and non-billable time for project costing and client billing:
| Property | Description | Example |
|---|---|---|
| Employee | Who worked | Employee reference |
| Date | Date of work | 2024-02-10 |
| Hours | Hours worked | 8.0 |
| Description | What was done | Implemented login UI |
| Task | Related task | Link to task |
| Billable | Bill to client? | Yes/No |
| Billable rate | Rate 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:
- Employee creates entry in draft status
- Employee submits for approval
- Manager approves or rejects
- 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.