Odoo 19 for Construction:
Project Costing, Subcontractor Management & Progress Billing

Construction Companies Don’t Fail Because of Bad Builds—They Fail Because of Bad Numbers

A mid-size general contractor in Ontario completed 47 projects in 2024. Thirty-nine were profitable. Eight lost money. But they didn’t discover which eight until four months after project closeout—when the accountant finished reconciling subcontractor invoices against budgets in a spreadsheet that had grown to 14 tabs and 23,000 rows.

The root cause wasn’t incompetence. It was architecture. Their estimating tool didn’t talk to their accounting system. Purchase orders for materials lived in email threads. Subcontractor certificates of insurance were tracked in a shared drive folder that nobody maintained. Progress claims were calculated manually by the project manager, who used a different margin formula than finance.

Odoo 19 solves this by connecting Project, Accounting, Purchase, Inventory, and Timesheets into a single data model. Analytic accounts tie every dollar—labor, material, subcontractor, equipment—to the project and cost category that generated it. Progress billing creates invoices against milestones, not calendar dates. Subcontractor management tracks holdbacks, lien waivers, and payment certification in the same system that issues the purchase order.

This guide walks through the complete construction setup: project costing with analytic accounts, subcontractor lifecycle management, milestone-based progress billing, material requisitions, equipment cost allocation, change order workflows, WIP reporting, retention handling, and multi-project dashboards.

Subcontractor Lifecycle: From RFQ to Holdback Release

Subcontractors represent 40–60% of a typical construction project’s cost. Managing them means tracking more than invoices—you need certificates of insurance, WorkSafeBC/WSIB clearances, lien waivers, holdback retentions, and payment certifications. Odoo 19’s Purchase module, combined with custom fields and approval workflows, handles the full lifecycle.

Subcontract Purchase Orders with Holdback Terms

Create a purchase order type specifically for subcontract agreements. Use Odoo’s payment terms feature to encode holdback retention—typically 10% in most Canadian jurisdictions, held for 45–60 days after substantial completion. The holdback amount appears as a separate payable line, preventing accidental early release.

# Navigate to: Accounting > Configuration > Payment Terms
# Create: "Net 30 + 10% Holdback 60 Days"

Payment Term Lines:
  Line 1: 90% of balance, due 30 days after invoice date
  Line 2: 10% of balance, due 60 days after completion date

# Assign to subcontractor purchase orders:
# Purchase > Orders > Select subcontract PO
# Set Payment Terms = "Net 30 + 10% Holdback 60 Days"

# The resulting vendor bill splits into two due dates:
#   $45,000 due April 15 (90% of $50,000 progress claim)
#   $5,000  due June 14  (10% holdback)

Tracking Compliance Documents

Use Odoo Studio or custom fields on the res.partner model to track subcontractor compliance: insurance expiry dates, safety certifications, WSIB/WorkSafeBC clearance letters, and bonding capacity. Create an automated action that blocks purchase order confirmation if any required document is expired or missing.

Set up a scheduled action that runs weekly, scanning all active subcontractor partners for documents expiring within 30 days. The action sends an automated email to the subcontractor requesting renewal and flags the partner record with an internal note visible to procurement. This prevents the scenario where a sub’s insurance lapses mid-project and you discover it only when a worker is injured on site.

Material Requisitions & Equipment Cost Tracking

Material procurement on construction sites follows a different rhythm than manufacturing. A site foreman needs 200 bags of concrete mix tomorrow morning, not in two weeks when the MRP scheduler runs. Odoo 19’s Purchase module handles urgent procurement, but the key is ensuring every purchase order carries the correct analytic distribution so costs land on the right job.

Material Requisitions from Site

Create a simplified purchase request workflow where site supervisors submit material needs through Odoo’s Purchase Agreements or a custom requisition form. The procurement team reviews, sources from approved vendors (using blanket orders for commonly purchased materials like lumber, concrete, and steel), and issues purchase orders with the project analytic account pre-filled.

Equipment Cost Allocation

Construction equipment—excavators, cranes, scaffolding—gets allocated to projects either as external rentals (vendor bills with analytic accounts) or internal equipment charges (journal entries allocating ownership costs to projects based on utilization). For owned equipment, create a recurring journal entry template that distributes monthly depreciation plus operating costs across active projects based on equipment logs.

WIP Reporting, Retention Tracking & Multi-Project Dashboards

Work-in-Progress (WIP) reporting is the heartbeat of construction accounting. It tells you whether a project is overbilled (you’ve invoiced more than the work completed—a liability) or underbilled (you’ve completed more work than you’ve invoiced—an asset). Getting this wrong means your financial statements misrepresent your company’s actual financial position, which can trigger bonding problems, bank covenant violations, and audit findings.

WIP Calculation in Odoo

Odoo doesn’t have a native WIP report for construction, but all the data exists in the analytic accounts. The formula is straightforward:

# WIP Report Logic per Project
# ────────────────────────────
# Contract Value:        Total SO amount (original + change orders)
# Costs to Date:         Sum of all analytic lines (debit)
# Estimated Total Cost:  Budget amount (updated monthly)
# % Complete:            Costs to Date / Estimated Total Cost
# Earned Revenue:        Contract Value * % Complete
# Billed to Date:        Sum of posted invoices
# Over/Under Billing:    Billed to Date - Earned Revenue

projects = models.execute_kw(db, uid, password,
    'account.analytic.account', 'search_read',
    [[('plan_id', '=', project_plan_id)]],
    {'fields': ['name', 'debit', 'credit', 'balance']})

for proj in projects:
    costs_to_date = proj['debit']
    estimated_total = get_budget_amount(proj['id'])
    contract_value = get_so_total(proj['id'])

    if estimated_total > 0:
        pct_complete = costs_to_date / estimated_total
    else:
        pct_complete = 0

    earned_revenue = contract_value * pct_complete
    billed_to_date = get_invoiced_amount(proj['id'])
    wip_position = billed_to_date - earned_revenue

    # Positive = overbilled (liability)
    # Negative = underbilled (asset)
    print(f"{{proj['name']}}: {{pct_complete:.1%}} complete, "
          f"WIP: ${{wip_position:,.0f}}")

Retention Tracking

Both client-side holdbacks (money your client owes you after the lien period) and subcontractor-side holdbacks (money you owe your subs) need separate tracking. Create dedicated receivable and payable accounts for retention: “Holdback Receivable” and “Holdback Payable.” When progress invoices are posted with holdback payment terms, the retained portion lands in these accounts automatically. At lien expiry, reclassify to standard AR/AP with a journal entry.

Retention Journal Entries

When a progress invoice posts with holdback payment terms, Odoo creates two receivable lines: one for the net amount (due in 30 days) and one for the holdback (due after the lien period). Map the holdback line to a dedicated “Holdback Receivable” account (e.g., account 1152) rather than the standard trade receivable. This separation is critical for your balance sheet—auditors and bonding companies need to see holdbacks as a distinct asset class, not lumped into standard AR.

On the subcontractor side, mirror this with a “Holdback Payable” account (e.g., account 2152). When the lien period expires and you release the holdback, create a journal entry that reclassifies the amount from Holdback Payable to Accounts Payable, then process the payment normally. This creates a clean audit trail showing exactly when the holdback was released and why.

Multi-Project Dashboard

Build a custom dashboard using Odoo’s spreadsheet module (or a BI connector to your preferred tool) that shows all active projects on a single screen: budget vs. actual, % complete, WIP position, outstanding receivables, holdback balances, and next milestone due date. The project plan analytic report is your starting point—it already aggregates costs and revenues per analytic account.

3 Construction-Specific Mistakes That Wreck Your Job Costing in Odoo