Original Contract

The amount of the original contract plus the executed and approved change order amounts (through the specified period end date) displays.

Executed Changes

The dollar amount for all executed change orders displays from Jobs .

Approved Changes

The dollar amount for all approved change orders displays from Jobs .

Revised Contract

The revised contract amount is calculated as the sum of the original contract amount plus the Change order amount.

Proposed Change Orders

The dollar amount for all Proposed change orders displays from Accounts Receivable Change Request Log/Entry.

% Complete

For active and inactive jobs, the percent complete is calculated as actual divided by projected cost, multiplied by 100. When the percent complete exceeds 100%, it is automatically set to 100%.

If the earned calculation is Billed or Cost, then the following codes display depending on the price type of the job:

• TM displays if the job price is Time + Material.

• C displays if the job price is Cost Plus.

• U displays if the job price is Unit Price.

Billed To Date

The actual amount billed to date among all contracts for the job through the year and period displays.

Earned To Date

The job-to-date earned amount among all contracts for the job is calculated as the product of the revised contract amount multiplied by the percent complete.

This is the standard percent calculation. The calculation in this field is computed differently if a Method of Calculation is entered the JobsPrice window for the master job:

If Percent is entered in Jobs, then the Job-to-Date Earned amount will be calculated as follows:

Actual cost-to-date

Projected Cost

X Contract Amount

If Cost is entered in Jobs, then the Job-to-Date Earned amount will be calculated as follows:

Actual Cost-to-date + cost markup %

If Billed is entered in Jobs, then the Job-to-Date Earned amount will be calculated as follows:

Actual Billed-to-date + Unbilled amount.

Over/Under

Over/under-billing is calculated as the difference between the billed amount and the amount earned. When earned revenue exceeds the billed amount, under-billing has occurred; when the billed amount exceeds earned revenue, over-billing has occurred.

Paid

The amount paid by the customer displays among all contracts for the job from the Accounts Receivable Contracts.

Balance

The balance due is calculated as the difference between the amount billed and the amount paid.

Retention Balance

The retention balance displays from the Accounts Receivable Contracts.

Current Due

The current amount due is calculated as the difference between balance less the retention balance.

Job To Date

Actual job-to-date hours through the year and period display.

Estimate

Estimated hours for the job display from Job Phases

Variance

Variance is calculated as the difference between the actual job-to-date hours less estimated hours.

% Complete

The percent complete is calculated as actual hours divided by estimated hours, multiplied by 100.

Job To Date

Actual job-to-date costs through the year and period display.

Projected

The total cost at completion displays from Job Phases.

Estimate

The total estimated costs for the job display from Job Phases.

Variance

Variance is calculated as the difference between the Projected cost less the estimated cost.

% Complete

Percent complete is calculated as the actual job-to-date cost divided by the estimated cost, multiplied by 100.

Open Commitments

Open commitments display from open purchase orders in the Purchase Order module.

Gross Profit

Gross profit displays for all cost-to-date columns. These figures are calculated as follows:

Job-to-date gross profit equals earned-to-date less actual job-to-date.

Projected gross profit equals the revised contract amount less the projected amount.

Estimated gross profit equals the revised contract amount less the estimated amount.

Variance gross profit equals the difference between projected and estimated gross profits.

GP%

The gross profit percent displays for actual, projected, and estimated job costs, and is calculated as follows:

Job-to-date gross profit percent equals job-to-date gross profit divided by earned to date, multiplied by 100.

Projected gross profit percent equals the projected gross profit divided by the revised contract amount, multiplied by 100.

Estimated gross profit percent equals the estimated gross profit divided by the revised contract amount, multiplied by 100.