Project Actual Costs Report

This report displays the actual costs posted on a project. It is available for sites integrated with Microsoft Dynamics SL only.

Project Actual Costs

Note: although the image above does not show the Output drop-down, you can select an output method (PDF/Excel/CSV) for this report.

Filters

  • Project – the Project ID.  You can look up or type a specific project ID, or use the % mask for multiple projects.
  • Period – the date range indicating the period during which actual costs should be included. You can select the checkbox to enter specific start and end dates.
  • Labor Detail – whether or not to include detail rows for Account Categories designated as Labor class.
  • Burden Detail – whether or not to include detail rows for Account Categories designated as Labor Burden class.

Columns

  • WBS – a)the Cost Code number and description and b) the Account Category
  • ID – reference information from the accounting transaction.
  • Posted – the date the actual cost was posted.
  • Prior Costs: Units – the prior units for the Account Category.
  • Prior Costs: Amount – the prior amount for the Account Category.
  • Current Period: Units – the units in the current period for the Account Category
  • Current Period: Amount – the amount in the current period for the Account Category
  • PTD: Units – the units in the Project To Date for the Account Category.
  • PTD: Amount – the amounts in the Project To Date for the Account Category.
  • Average Per Day: Units – the average of units per day (within the date range) for the Account Category.
  • Average Per Day: Amount – the average of amounts per day (within the date range)for the Account Category.
  • Average Week: Units – the average of units per week (within the date range) for the Account Category.
  • Average Week: Amount – the average of amounts per week (within the date range) for the Account Category.
  • Average Month: Units – the average of units per month (within the date range) for the Account Category.
  • Average Month: Amount – the average of amounts per month (within the date range) for the Account Category.

Note: The Account Categories and Cost Codes are subtotaled and all numeric columns are totaled at the end of the report.


Last updated: October 18, 2016 at 13:09 pm;