Reports - Project Accounting - Project Margin

Overview

This report will provide details for the Current Period, Year to Date and Total to Date summary of project profitability with one line per Org, Project or Task (depending on selection criteria chosen).  The report will only run on posted data and can optionally include Indirect Costs.  Options for arranging the output by Project Manager, Owning or Project Org, Posted Org, and more can be configured.  This report has the potential to report on net margin as it not only gathers labor and expense bill and cost information, but also considers fixed price, fee and funding cap adjustments, write offs, direct and indirect costs, etc.

Roles

This report is available to users having any of the following roles:  Administrator, P&R Administrator, and Project Administrators (that also have the Cost Rate Manager role or the Allow Project Cost Reporting for Non-Cost Rate Managers (unanet.non_cost_mgr.allow_project_cost_reporting) property is enabled).

License

This report is available with the Project Tracking and Project Portfolio family of licenses.

Topics covered on this help page include:

• Selection Criteria   (options available to tailor report output)

• Example Report Output

Selection Criteria

Field Descriptions (click on a link below for additional information)

Example Report Output

Report / Field Description Notes

• All orgs
• • When shown as headers will be displayed with the org name, if it exists.
  • When shown as a column value, they will be limited to codes only.
• Projects
• • When shown as headers, will be displayed with project org code, project code, and project title, if it exists.
  • When shown as a column value, they will be limited to project org/project codes only.
• Periods
  • Current - date range specified in the search page
  • Year To Date - fiscal year that contains the end of the Current date range.
  • • If we could find a fiscal year for that date, the last fiscal year we could find. This is the same logic we use in all other versions of the JSR. The year will be truncated to the end of the Current period.
  • Total To Date - BOT to the end of the Current period.
• Revenue
  • All timesheet cells / expense report line items / financial expenses that went through the billing & revenue post, and resulted in transactions for the following Posting Group categories: Recognized Revenue, Revenue Write-Off, Fixed Fee Adjustment - Revenue, Funding Cap Adjustment - Revenue.
  • All items will be placed into a period based on the journal post date
• Labor / Hours
  • All timesheet cells that went through the Labor Cost Post and resulted in transactions for the following Posting Group categories: Labor Cost Post
  • All items will be placed into a period based on the journal post date
• ODC
  • All expense report line items that went through the Expense Report Cost post and resulted in transactions for the following Posting Group categories: Expense Report Cost Post. These items will be placed into a period based on the journal post date.
  • All financial document expenses associated with posted documents. These items will be placed into a period based on the document post date.
• Indirects
  • Shows up only if the user chose the Calculate Indirect Costs in the search page.
  • Contains the sum of ALL indirects defined in the cost structure associated with each timesheet cell / expense report line item allocation / financial document expense that was included in this report and was mapped to a cost element, regardless of the billing type of the project/task the items belong to.
• Margin
  • Revenue - [labor + ODC + indirects (if included)]
• Margin %
  • Profit / Revenue

See Revenue and Cost Reporting Calculations for more information about the values on this report.