Job Profit Report

Print Friendly, PDF & Email

The Job Profit report provides an analysis of profit for finalized and non-finalized Jobs, as follows:

  • When you generate the report on finalized Jobs, the system samples all Jobs which Finalized Data falls within the selected reporting period. The generated report allows to evaluate the profit which you planned to make (Forecast Profit) and the profit which you actually made (Gross Profit).
  • When you generate the report on non-finalized Jobs, the system samples all non-finalized Jobs. It allows you to examine the profit which you planned to make (Forecast Profit) and the profit which can be allocated to date based on the completion percentage.
  1. Open the library with reports.
  2. Select Job Profit.
  3. Define criteria for generating the report, as follows:
Criteria
  • Jobs Type Select the Job type which you want to generate the report on, as follows:
    • Finalized Jobs
    • Not Finalized Jobs
      With finalized date from … to … Select the date range for including the Finalized Jobs with the Finalize Date within this range. This criterion is not available if you generate the report on non-finalized Jobs.
      Include Not Proceeding Jobs Check the box to include Jobs in the Not Proceeding state into the report.

3. When complete, click Apply. The report is generated, as follows:

The report shows the following information about finalized Jobs:

Report Information – Finalized Jobs
JobJob number including the Office’s number as prefix.
SiteSite where the Job is performed.
Contract AmountContract amount of the Job.
BudgetEstimated cost of the Job.
Forecast ProfitForecast profit of the Job. It is calculated as subtraction of the Job budget from the contract amount.

The forecast profit is placed into square brackets when the budget is less than the contract amount.

%Forecast Profit percentage. It is calculated as the ratio of the forecast profit to contract amount. The value can be negative.
Draws ReceivedDraw amounts received for the Job.
Invoices PaidInvoice amounts that were paid for the Job.
Gross ProfitGross profit of the Job. It is calculated as subtraction of the Invoice Paid amount from the Draw Received amount.
%Gross profit percentage for the Job. It is calculated as ratio of Invoices Paid amount to the Job Budget.

The report shows the following information about non-finalized Jobs:

Report Information- Non-Finalized Jobs
JobJob number including the Office’s number as prefix.
SiteSite where the Job is performed.
Contract AmountContract amount of the Job.
BudgetEstimated cost of the Job.
Forecast ProfitForecast profit of the Job. It is calculated as subtraction of the Job budget from the contract amount.

The forecast profit is placed into square brackets when the budget is less than the contract amount.

%Forecast Profit percentage. It is calculated as the ratio of the forecast profit to contract amount. The value can be negative.
Invoices PaidInvoice amounts that were paid for the Job.
$ Budget CompleteBudget completion percentage for the Job. It is calculated as ratio of Invoices Paid amount to the Job Budget.
Profit AllocatedProfit allocated for the non-finalized Job. It is calculated as ratio of multiplied Forecast Profit and Invoiced Paid amounts to the Job Budget.
Updated on November 5, 2021

Was this article helpful?

Related Articles