Billing Item Analysis Report - Report Calculations (Standard, Proj. Cost = No)

The following tables describe how each column is calculated on this report.

Contract

Field

Description

Quantity

The original contract quantity for each billing item displays from the Accounts Receivable Contracts.

U/m

The unit-of-measure for each billing item displays from Contracts.

Unit Price

The unit price for each billing item displays from Contracts.

Amount

The dollar amount for each billing item displays from Contracts. This figure is calculated as the product of the quantity and unit price.

Current Period

Field

Description

Quantity

For each billing item, the quantity used during the current period displays.

Revenue

For each billing item, the revenue for the current period displays.

Cost

For each billing item, the cost for the current period displays.

Gain (Loss)

For each billing item, the gain or loss for the current period displays. This figure is calculated as the difference between the revenue less cost.

Job-To-Date

Field

Description

Quantity

For each billing item, the quantity used to-date on this job displays.

Revenue

For each billing item, the revenue to-date on this job displays.

Cost

For each billing item, the cost to-date on this job displays.

Gain (Loss)

For each billing item, the gain or loss to-date on this job displays. This figure is calculated as the difference between the two preceding columns, that is, revenue less cost.