Project Billing Budget vs. Actual
The Project Billing 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 Billing Budget vs. Actual report is a comparison of the budget and actual charges billed to customers for each project. Budgets are entered on individual project records. This report is available in both summary or detail. To view the Project Billing Budget vs. Actual Summary report, go to Reports > Projects > Project Billing Budget vs. Actual. To view the Project Cost Budget vs. Actual Detail report, go to Reports > Projects > Project Billing Budget vs. Actual > Detail.
The summary report displays the following for each project by month:
-
Customer:Project/Category
-
Budget
Total amount budgeted for customer charges in each category.
-
Actual
Total actual charges for each category.
Labor is calculated by invoiced billable time.
Expenses are calculated by invoiced billable expenses.
Supplier charges are calculated by invoiced billable items or expenses supplied by another vendor. Inventory items are not accounted for in supplier charges.
-
Committed Revenue
Project revenue that has been committed but not yet received.
-
Recognized Revenue
Cumulative dollar amount of the revenue recognized with either invoices or revenue commitments.
-
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 Billing 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 cost budget fields, you must remove the Is Cost=F filter from your custom report. If you do not remove the filter, the added cost 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.