Project Cost Budget vs. Actual
The Project Cost Budget vs. Actual report requires the Job Costing and Budgeting feature. For more information, see Job Costing and Project Budgeting.
The information displayed on the Project Cost Budget vs. Actual report is a comparison of the budget and actual costs for each project. Budgets are entered on individual project records. This report is available in both summary or detail. To view the Project Cost Budget vs. Actual Summary report, go to Reports > Projects > Project Cost Budget vs. Actual. To view the Project Cost Budget vs. Actual Detail report, go to Reports > Projects > Project Cost Budget vs. Actual > Detail.
The summary report displays the following for each project by month:
-
Customer:Project/Category
-
Budget
Total amount budgeted for costs in each category.
-
Actual
Total actual costs for each category.
Labor costs are calculated from posted time.
Expense costs are calculated from expense reports.
Supplier costs are calculated from vendor bills with item lines tied to the project. Inventory items are not accounted for in supplier costs.
-
Committed Cost
Project costs that have been committed but have not yet been resolved.
-
Variance
The difference between the budgeted amount and the actual amount for each category.
The detail report is expanded to show the individual transactions that make up the totals for each category.
These reports are available only if you use Project Management and Job Costing and Project Budgeting.
When you click Project Cost Budget vs. Actual, 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.
These reports do not display partial budgets. When selecting a time frame to display, if a partial month is chosen the report will not show a budget for that month. For example, if you select July 15 through August 31, the report will not display a budget for July.
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.
When customizing this report, if you would like to add billing budget fields, you must remove the Is Cost=T filter from your custom report. If you do not remove the filter, the added billing budget fields will appear empty. Removing the filter will add empty lines to your report.
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.