1. Projects
  2. Project Management
  3. Project Management Reports
  4. Project Profitability Report

Project Profitability Report

The Project Profitability report compares actual project revenue and costs to show each project’s total profitability.

Important:

The Project Profitability report requires the Job Costing and Budgeting feature. For more information, see Job Costing and Project Budgeting.

Note:

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:

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
Note:

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

Related Topics

General Notices