Calculate Revenue

Use this form to calculate the cumulative revenue for selected jobs from the job's start date up to the current job costing period.

You can use any of the filters displayed in the header of the form to search for jobs to be calculated. When entering search criteria:

To select more than one specific job (or other type), select the first one. It is copied to the field to the right of the Search field. As you select each subsequent job, it appends to the string on the right side, delimited by a comma.
To enter a range of search criteria, enter it into the field on the right side of the Search field, and use a colon to separate the lowest and highest value. For example, enter 400001:400005 to include all jobs from 400001 to 400005.
You can use wildcards to include a specific group of criteria. For example,
- 00* includes all codes with a string starting with 00
- 1* includes all codes with a string starting with 1
- *0 includes all codes ending in 0.

Only jobs that are open are selected.

You can filter jobs using the Start Date and Job Trees.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Default actual values from estimate

Select this option to update the revenue values with the estimated values when the process is complete.

Replace already calculated Jobs

Select this option to recalculate jobs that have previously been calculated for the period. You can select jobs that have already been calculated.

Exclude Retentions

Select this option to exclude the value of retentions from revenue calculations.

If you don't select this option, Greentree Desktop calculates the full value of the retentions, ignoring any percentage complete criteria that applies to the job.

Search Now

Click this button to display the jobs based on your selection. Jobs that have had their revenue calculated for the period, or whose settings preclude them from calculation, are shown in blue.

Selected

Click this option to select the job to include in the process. Each selected job is highlighted in yellow.

Calculate

Click this button to calculate revenue for selected jobs. This sets the Revenue Status for the period to Calculated. When the process finishes, Greentree Desktop prompts you to review the calculation. Click Yes to open the Review Revenue form, or click No to stay on this form.

Clear Calculations

Click this button to clear calculations for selected jobs. This resets the Revenue Status for the period to Not Calculated.

Revenue Calculations

Recognised revenue of a job is the % completed x revenue calculation.

% complete

The percentage complete calculation for a job can be based on one of these options:

Budget versus Actual - Cost
Total actual costs ÷ Estimate total cost
Budget versus Actual - Hours
Total actual hours ÷ Estimate total hours
Budget versus Actual - Sell
Total actual retail value ÷ Estimate total retail value
Elapsed Time
Number of days from job start date to end of current period ÷ Number of days from job start date to expected completion date.

If the job start date or expected completion date is not specified, the resulting percent complete is 0.00.

For the above methods, if the ratio exceeds 100%, the percent complete is set to 100%.
Revenue to Date
If you select this option, the percent complete is always set to 100%.

Revenue calculation

The revenue is calculated as the percent complete of one of the following options:

Estimated Sell

The Total Retail value in the current estimate.

Job Value
The Job Value entered on the Main tab on the JC Job Maintenance form.
Revenue to Date
Retail amount of all costs on a job, billed or unbilled.
Total Invoice
Total invoiced amount to date up to the current period end date). This does not include pro-formas.

Example

A job has % complete = Budget versus Actual - Cost, and revenue calculation = Job Value (12,000).

The estimated total cost of the job is 10,000.

In the first period of revenue recognition, the costs amount to 1,000.

The % complete = (Total actual costs ÷ Estimate total cost) = (1,000/10,000) = 10%

The revenue calculation = % complete x Job Value = 10% x 12,000 = 1,200.