If you see this arrow, click to expand for more information!

We will add optional information and images under these arrows.

Terminology / Breakdowns

Terms	Description
Product.types	Product types are the industry buckets all these when looking at profitability. They include: Material Equipment Expense Subcontractor Labour Other
Invoice.Types	Invoices from projects that are: Deposits Retention Progress claims

Profit & Margin

Quoted Profit

Calculation:
Quoted sell - Quoted Cost

Quoted Margin

Calculation:
[ (Quoted sell - Quoted cost) / Absolute value of (quoted sell) ] x 100

Actual Profit

Calculation:
Net Invoiced - Actual Cost

Actual Margin

Calculation:
[ (Net Invoiced - Actual Cost) / Absolute value of (Quoted Sell) ] x 100

Revised Profit

Calculation:

Revised Sell - Revised Cost

Revised Margin

Calculation:

[ (Revised Sell - Revised Cost) / Absolute value of (Revised Sell) ] x 100

Field Definitions

Quoted Cost

Costs that are derived from a quote

Calculation:

From a service quote, this would be the Cost Price x Quantity

Quoted Sell

Quoted Profit

The additional value you expect to make

Calculation:
Quoted Sell - Quoted Cost

Quoted Margin

The percentage you expect to make against your quoted cost

Estimated Cost

This represents the potential expenses before any actual work or purchases are finalised. If the task has been created from a quote, these costs will be the same.

Calculation:

From Purchase Orders: If a purchase order is in a 'DRAFT' or 'PENDING APPROVAL' status, this will be calculated by United Price x Quantity.
From Service Tasks: If a service task has not been performed, this will be calculated by Cost Price x Quantity.
From Service Tasks (For Labour): If a service task is for labour, and the labour is from stock, and the timesheet task session is in 'DRAFT', 'SUBMITTED' or 'APPROVED', it will be included in the estimated cost.

Committed Cost

Any committed costs on this task that have progressed from an estimate

Calculation

From Purchase Orders: If a purchase order is in a 'SUBMITTED', 'APPROVED' or 'PARTIALLY COLLECTED' status.
- Purchase Order Line Item Unit Price * Purchase Order Line Item quantity
From timesheet task sessions: If a task session is in 'DRAFT' or 'SUBMITTED' status
From stock: If a reservation is collected
This feature will only work if you have the correct Stock Transaction Feature Flag turned on in your workspace. Check with [email protected] if you are unsure.

Actual Cost

These costs have progressed from an estimated or committed cost. These are costs that have actually been incurred to the business.

Calculation:

From Purchase Orders: If a purchase order is in a 'PAID' 'FULLY BILLED' status.
- Unit Price x Quantity
From timesheet task sessions: If a task session is approved
- cost
From stock: Products that are assigned from stock which are PERFORMED.

Paid cost

Any cost that has actually been paid for, i.e. money has left the bank.

Calculation:

From Purchase Orders: If a purchase order, or its bill, is in a 'PAID' status
From timesheet task sessions: If a task session is 'APPROVED'

Variance

The value difference between your quoted cost compared to your other costs. This can be seen in the breakdown view within the project financials.

Calculations:

Quoted Cost - (Estimated + Committed + Actual + Paid Cost)

Received

Money that has been received

Calculations:

From invoices: If an invoice is in a ‘PAID’ status

Cash position

This represents how much debt the company has gone into carrying out tasks.

Calculations:

Recieved - Paid cost

Tables

Term	Calculations
Quoted profit	`quoted sell` - `quoted cost`
Quoted margin	`100.0` * `(quoted sell - quoted cost)` / `Absolute(quoted sell)`
Actual profit	`net invoiced` - `actual cost`
Actual margin	`100.0` * `(net invoiced - actual cost)` / `Absolute(net invoiced)`
Revised profit	`revised sell` - `revised cost`
Revised margin	`100.0` * `(revised sell - revised cost)` / `Absolute(revised sell)`

Account	Definition	Calculation
Quoted cost	Costs that are derived from a quote.	From service quote `cost_price` * `quantity`
Quoted profit	The additional value you expect to make	`quoted sell` - `quoted cost`
Quoted margin	The percentage you expect to make against your quoted cost
Estimated cost	Estimated costs represent the potential expenses before any actual work or purchases are finalised. If the task has been created from a quote these costs will be the same.	From Purchase Orders: If a purchase order is in a 'draft' or 'pending approval' status. `unit_price` * `quantity` From Service Tasks: If a service task hasn't been performed `cost_price` * `quantity` For Service Tasks (Labour):If a service task is labour, and the labour is from stock, and the task session is draft, submitted or approved, it will be included in the estimated cost.
Committed cost	Any committed costs on this task that have progressed from an estimate.	From Purchase Orders: If a purchase order is in a 'submitted', 'approved' 'partially collected' status. `poli.unit_price` * `poli.quantity` From task sessions: If a task session is in 'draft or submitted' From stock: If a reservation is collected (intelligence_taskstocktransaction_costs must be turned on)
Actual cost	These costs have progressed from an estimated or committed cost. These are costs that have actually been incurred to the business.	From Purchase Orders: If a purchase order is in a 'Paid' 'fully billed' status. `unit_price` * `quantity` From task sessions: If a task session are approved `cost` From stock: Products that are assigned from stock are performed.
Paid cost	Any cost that has actually been paid for, i.e. money has left the bank.	From Purchase Orders: If a purchase order, or its bill, is in a 'Paid' status From task sessions: If a task session is 'approved'
Variance	The value difference between your quoted cost compared to your other costs. This can be seen in the breakdown view within the project financials	`Quoted cost` - `estimated`, `committed`, `Actual` and `Paid cost`
Received	Money that has been received	From invoices If an invoice is in a ‘paid’ status
Cash position	This represents how much debt, so to speak, the company has gone in to carrying out tasks.	`Recieved` - `Paid cost`

Understanding the task profitability window

Everything about Projects

Profitability in Uptick

[Beta] Understanding your Projects Performance Dashboard

[Beta] Cost Breakdown & variance analysis for projects