Project Profitability Report
The Project Profitability report compares actual project revenue and costs to show each project’s total profitability.
The Project Profitability report requires the Job Costing and Budgeting feature. For more information, see Job Costing and Project Budgeting.
The Project Profitability report is still supported but it is no longer enhanced. You are encouraged to start using Advanced Project Profitability. The default configuration for the project profitability report is copied as the standard configuration and you won't suffer any data loss. For more information, see Advanced Project Profitability.
The total report displays the following for each project:
-
Customer:Project/Category
-
Total Cost
The total costs incurred for each category. This figure is consistent with the actual amounts from the Project Cost Budget vs. Actual report.
-
Committed Cost
The committed costs for each category.
-
Total Income
Income is the net profit after costs for each category.
-
Income/Cost margin
Total Income / Total Cost * 100 – 100 = Margin
-
Committed Revenue
Revenue commitments for each category.
-
Recognized Revenue
Revenue that has been recognized for each category.
-
Revenue/Cost margin
Recognized Revenue / Total Cost * 100 – 100 = Margin
The Project Profitability Report shows the profitability of all active projects for the entire life of the project.
This report is available only if you use Project Management and Job Costing and Project Budgeting.
When you click Project Profitability, a message appears indicating that your report is loading. The status bar indicates the progress as your report loads. You can click Cancel Report to stop the report from loading.
If you use NetSuite OneWorld, you can choose the subsidiary data to be displayed in this report by selecting from the Subsidiary Context dropdown in the results page footer. See Subsidiary Context for Reports.
Project Profitability Category Matrix
The following table details the sources for each category included on the Project Profitability report.
|
Category |
Total Cost |
Committed Cost |
Total Income |
Committed Revenue |
Recognized Revenue |
|---|---|---|---|---|---|
|
Labor |
Journal entries created from posting time tracked towards projects |
N/A |
Invoice amounts created from employee time-based charges Invoice amounts created from fixed fee charge rules Billable time on customer invoices |
Revenue commitments created from service items Note: Journal entries created from revenue recognition schedules reduces the Committed amount |
Invoices with GL impact to revenue for service items and billable time Journal entries created from revenue recognition schedules for service items |
|
Expense |
Approved employee expense reports |
N/A |
Invoice amounts created from employee and vendor expense-based charges Billable expenses on customer invoices |
N/A |
Invoices with GL impact to revenue for expense items and billable expenses |
|
Supplier |
Approved vendor bills Item fulfillments from sales orders for inventory items |
Unfulfilled purchase orders for non-inventory items and service items Fulfilled purchase orders for non-inventory and service items Note: Partial Receipts will not display the PO in Committed Cost. Fulfilled purchase orders for inventory items Important: Committed purchase orders are removed when they have been fully billed. However, if a PO is only partially billed the full PO still shows in Committed Cost and the vendor bill for the partial amount shows in Total Cost overstating Cost + Committed. |
Invoice amounts created from vendor time-based charges Billable items on customer invoices Items on customer invoices; including service items, non-inventory items, inventory items. Items from sales orders to invoices will display here. |
Revenue commitments created from inventory items, non-inventory items, and other items Note: Journal entries created from revenue recognition schedules reduces the Committed amount |
Invoices with GL impact to revenue for non-inventory items, inventory items, and other items Journal entries created from revenue recognition schedules for non-inventory items, inventory items, and other items |
|
Other |
The debit side of manual journal entries |
N/A |
N/A |
N/A |
N/A |
This report does not support reporting by period even when the Report by Period preference is set to All Reports. The Report by Period preference can be configured at Home > Set Preferences, the Analytics subtab.
Related Reports
- Project Profitability by Month Report
- Project Cost Budget vs. Actual
- Project Billing Budget vs. Actual
- Project Task Cost Budget vs. Actual
- Project Task Billing Budget vs. Actual
- Time Entry Exceptions Report
- Time by Employee/Item/Customer Reports
- Current Backlog By Resource Report
- Estimated Profitability by Project Report