Title: Sample Job Summary Report (JSR)
This entry outlines one of many possible best practice configurations of the Job Summary Report to reflect direct costs (labor and expense), indirect costs, revenue, net margin, gross margin and more. These may be reported at the contract/project level or summed up across customers, internal entities, or an entire set of programs.
What’s covered in this document:
Cost Report Definition example
This report provides a summarized view of time charged to a project in a Job Summary Report (JSR) or Project Summary type report layout (which is defined on the Admin > Setup > Cost Reports screen). The Summary version of this report includes the links that allow you to display additional labor or ODC details for the project being viewed. The Periodic version of this report allows the user to select day, week, semi-month, month, quarter, or year periods showing costs for a project by cost element. Plans or budgets can be included for labor and expense.
This report is available for Project Administrators that also have one of the following roles: Cost Rate Manager, Billing Manager, or Billing Viewer. Project Administrators that do not have the Cost Rate Manager, Billing Manager, or Billing Viewer roles can have access to this report when the Allow Cost Reporting For Non-Cost Rate Managers property is enabled (Admin > Properties > Unanet > Access/Permissions).
Only those projects having a Cost Structure indicated will be included in the Project Costing reports. Actuals charged by users having a default Cost Structure/Cost Element either in their Person Rates tab or in the project level override Cost Structure/Cost Element definition will immediately appear on the Project Costing reports. These reports include time/expense in real time - any timesheet or expense report status.
Below is a sample configuration for a cost report in Unanet. This resides in Admin > Setup > Accounting > Cost Reports> Default JSR.
Contract specific report example
The following list describes each of the elements in the report image above.
- The Labor Details links can be used to drilldown and view various rate applications in more detail.
- The ODC Details links can be used to drilldown and view various cost/expenses in more detail.
- The Current Period for the report is a configurable setting. The default selection is prior month. This column displays cumulative burdened costs between the dates specified.
- The Fiscal Year-To-Date displays amounts starting with the current fiscal year to the end date specified in the selection criteria.
- Prior Fiscal Years totals amounts for full fiscal years prior to the start date included in the selection criteria.
- To-Date calculates the total amounts from program inception to the end date provided in the selection criteria. In this example the end date is 3/31/2013.
- The Budgeted column includes the total budget for the project/task combination, pulling budgets as you have them defined in the cost report definition.
- The % Budget Incurred represents the ratio of the To Date column to the Budgeted column.
- The Backlog is the difference between the Budgeted column and the To-Date column.
The Roll Up function provides program managers and executives an extremely powerful high level profit and loss analysis on groups of projects, such as by customer or by organization (e.g., practice area). You can actually see if your company is making a profit across all contracts, one customer, or a certain division or line of business.
The Reporting Options selection criteria for this report allows you to specify:
Roll up all selected projects into a single block. When checked, the report output will include a single entry that reflects amounts accumulated across all projects included in the report. When not checked, the report includes a separate section for each project included in the report.
When checking this option, several of the values included in the header section will reflect the term "multiple" rather than the specific values from any specific project.