WIP report – data columns guide

This article provides an overview of the data columns available in the WIP report, what they mean, and how they're calculated.

Budget & actuals columns

WIP report data columns related to budget and actual data:

• Income – actual income to date (all invoices).

• Income (budget) – the budgeted income of the project.

• Cost – actual cost to date (labor cost + bills + expenses).

• Cost (budget) – the budgeted costs of the project.

• Internal income – actual internal income up to date that's based on all invoice lines with in-house services.

• Internal income (Budget) – calculated only when using the budget type "Quoted amounts".

• External income – actual external income to date, based on all invoice product and service lines with outsourced products/services.

• External income (Budget) – calculated only when using the budget type "Quoted amounts".

• Bills – Up to date actual bills.

• Bills (Budget) – the budgeted bills of the project.

• Expenses – actual expenses to date.

• Expenses (Budget) – calculated only when using the budget type "Simple budget".

• Internal cost – actual internal cost to date, based on labor cost and bills that include in-house products.

• Internal cost (Budget) – calculated only when using the budget type "Quoted amounts".

• External cost – actual external cost to date, based on expenses and bills that include outsourced products and services.

• External cost (Budget) – calculated only when using the budget type "Quoted amounts".

• Labor cost – actual labor cost to date.

• Labor cost (Budget) – calculated only when using the budget type 'Simple budget' and labor cost.

• Profit (budget) – the budgeted profit of the project.

Billing columns

WIP report data columns related to charging and billing:

• Chargeable – chargeable sum to the client based on the proportion of the project finished.

  • Formula: Income budget * % completed.

• Chargeable profit – up-to-date actual profit.

  • Formula: Chargeable - Cost.

• Chargeable to date – combined total of unbilled time value and uninvoiced costs.

• Unbilled time – value of uninvoiced time entries, calculated at the selling rate.

• Uninvoiced costs – value of project-related bills and expenses that are chargeable to the client but not yet invoiced.

• Over/under billings – sum charged over or under compared to the proportion of the project finished. 

  • Formula: Chargeable - Income.

• Planned chargeable – chargeable sum for planned tasks (except over/under billings).

• Prepayment invoices – sum of prepayment invoices.

• Open purchase orders – value of unsettled purchase orders.

Revenue, profit, and forecast columns

WIP report data columns related to revenue, profit, and forecasting:

• Project profit – invoice revenue - total cost.

• Forecasted profit – calculated by subtracting forecasted cost from the forecasted revenue. Here's how it's adjusted based on the project's revenue model:

  • Fixed fee and Time & Material capped: If your team logs or plans for excess hours, your costs will rise while your forecasted revenue remains capped, resulting in a drop in your forecasted profit.

  • Time & Material uncapped: Since every planned or logged hour increases both your costs and your billable revenue, your forecasted profit scales dynamically while preserving healthy margins.

• Forecasted cost – total forecasted cost at completion.

• Forecasted revenue – displays the following depending on the project's revenue model:

  • Fixed fee: The locked, flat-fee contract budget
  • Time & Material capped: Total of done and planned work, with the total automatically capped at the budget ceiling if your team has planned more hours than the contract allows
  • Time & Material uncapped: Total done and planned work, uncapped

• Earned revenue – revenue from the completed work so far. It's the same value as the Earned column under the Budget tab > Profit sub-tab of the project detailed view.

  • Formula: internally logged hours (including past scheduled time entries) × selling price (role price on role-priced projects) + outsourced services that are already invoiced.
  • For projects with a fixed fee and Time & Material capped revenue model, the earned revenue is capped at the quote/budget.

• Earned revenue (capped) – Revenue so far based on logged time and selling price, capped at the budget once reached. Outsourced services are included once invoiced to the client.

• Progress-based revenue – revenue calculated based on the efforts-expended method.

  • Formula: Budgeted income * Project progress %.

Progress and time columns

WIP report data columns related to progress and time:

• % Completed – proportion of the project finished based on actual cost.

  • Formula: Cost / Cost budget * 100.

• Estimated duration – project's estimated duration.

• Total planned – total planned duration of all project-related tasks.

• Duration – time spent on project-related completed activities.

• Project progress – percentage of time spent on project-related completed activities.

  • Formula: Duration / Project's estimated duration * 100.

• Total to do – remaining time left to do.

  • Formula: Total planned - Duration.

• % Completed activities – percentage of time spent on project-related completed activities. 

  • Formula: Duration / Total planned * 100.

• Days open – days from the project's start date until today (if the project is still ongoing) or until the project's completion date (if the project is completed).

• Deadline – project's due date or days overdue.