ProjectProfitability

Object

projectId

The project the row rolls up, or the sentinel finance_unattributed_project on the one row carrying billing and cost whose documents name no project — imported books, where an invoice arrives with a client and no Hive project. Rows that state no money at all are not returned: a null name, a null client and seven zeros is a published project id and nothing else.

projectName

The project's name, so the report's identity column reads what every other project surface reads. Null for a project this workspace cannot resolve, and on the unattributed row, which names no project to resolve.

clientAccountId

The project's own client (Project.clientAccountId). Null when the project names none, and on the unattributed row.

baselineTotal

What was promised: the project's budget baseline, as the accepted proposal cut it.

costTotal

What the project cost to deliver, on actuals: its posted vendor-bill lines and realized expense reports (all net of tax), and its approved hours at their cost rates. Labour is part of cost — a project staffed from the agency's own team and buying nothing costs its people's time, and reporting that project as costless reported its whole fee as profit.

laborCost

The approved hours at their cost rates — the labour part of costTotal.

passThroughCost

Posted vendor bills charged to the project (standalone, and those raised against a purchase order once the order is posted) plus realized expense reports, all net of tax — the pass-through part of costTotal. costTotal = laborCost + passThroughCost.

committedCost

Open purchase-order amount no posted vendor bill has taken (order total less its posted vendor bills), net of tax. A commitment, not cost: it is not in costTotal.

agi

Agency gross income: billedTotal − creditTotal − passThroughCost. Labour is not deducted.

billedTotal

Realized invoices net of the sales tax they collect, which is the agency's liability rather than its income.

receivedTotal

creditTotal

Realized credit memos net of tax.

wipTotal

arBalanceTotal

Current unpaid balance of posted invoices, excluding unapplied credits, payments, and other AR ledger entries. Not a period flow or the AR control balance.

profit