Report column definitions

Budget ($)

Total from Sub projects

Fee ($)

Fees totals from sub projects - all statuses including proposals. In the case of Hourly rates this is the accumulated Value (hours * charge rate per unit + Invoice ($) to date) 

Agreed Fee ($)

Fee ($) for projects/sub projects with a status of Active/Hold/Inv pending only

Project Construction Value ($)

Total cost for the Construction from Sub projects

Project Construction Variations ($)

Total variation value entered on the Sub Project

Project Construction Total Value ($)

Project Construction Value ($) + Project Construction Variations ($)

Project Construction (%)

% from Sub project that will be used to calculate the Project Construction Fee ($)

Project Construction Fee ($)

Fee ($) for Project Construction is based on a % of the Project Construction value ($)

Invoiced + WIP ($)

Project Value Invoiced ($) + Project Chargeable WIP ($)

Invoiced ($)

Project Value Invoiced ($) - Project Invoiced Written Off ($) (finalised invoice (revenue recognised) value to date for the project

Invoiced (%)

Invoiced ($) / Agreed Fee ($) * 100

Invoiced Written Off ($)

Invoice write offs to date - i.e. non payments of presented invoices

Credits ($)

Credits issued to date

Residual Fee ($)

(fixed fee = Project Agreed Fee ($) - Project Value Invoiced ($) ) (hourly rate = Project Chargeable WIP ($))  

Chargeable Total ($)

All transactions calculated at their chargeable rate (i.e. . Chargeable value of project to date)

Chargeable Invoiced ($)

Invoiced transactions represented by a charge out rate value for the whole project. Transactions that have been absorbed into an invoice or written off 

Chargeable WIP ($)

non-invoiced transactions at chargeable value

Chargeable Written Off ($)

Transaction ($)

Transaction WIP = chargeable $ x units. Transaction Invoiced = Value of transaction at time of invoice x units

Transaction Units

Transaction WIP = chargeable units. Transaction Invoiced = unit amount invoiced

Transaction Per Unit ($)

Transaction ($) / Transaction units

Transaction Chargeable ($)

Standard Chargeable rate x timesheet units whether invoiced or not, based on timesheet entry

Transaction Chargeable Units

No of units entered on timesheet

Transaction Chargeable Per Unit ($)

Transaction Chargeable ($) / Transaction Chargeable units

Staff Chargeable Actual ($)

Staff charge rate, includes staff overhead cost and target profit x chargeable unit/s

Staff Chargeable Actual per unit ($)

Staff charge rate, includes staff overhead cost and target profit

Staff Overhead Cost ($)

Staff overhead cost x chargeable units

Staff Overhead Cost per unit ($)

Staff hourly overhead cost excluding profit as per staff record

Staff Cost ($)

Staff hourly cost excluding overhead and profit as per staff record

Cost Total ($)

Cost including invoiced and uninvoiced transactions**

Cost Invoiced ($)

Cost of invoiced transactions**

Cost WIP ($)

Cost of uninvoiced transactions**

Transaction Cost ($)

Total cost of the transaction**

Transaction Cost Per Unit ($)

Transaction Cost ($) / Transaction # units**

Profit Inv Cost ($)

Value Invoiced ($) - Invoiced Written Off ($) - Cost Invoiced Standard ($)

Profit Inv Cost (%)

Profit Inv Cost Standard ($) / Value Invoiced ($) x 100

Profit Total Cost ($)

Value Invoiced ($) - Invoiced Written Off ($) - Cost Total Standard ($)

Profit Total Cost (%)

Profit Total Cost Standard ($) / Value Invoiced ($) x 100

Profit Projected ($)

Value Invoiced ($) - Invoiced Written Off ($)+ Value WIP ($) - Total Cost Standard ($)

Profit Projected (%)

Profit Projected Standard ($) / (Value Invoiced ($) + Value WIP ($)) x 100