Job Cost Analysis Report : Cost & Revenue by Billing Phase

This report shows all Costs and Revenue charged to a job, ordered by Billing Phase.

This report is accessible through Job Costing Analysis Reports.

To print this report, check the Cost & Revenue by Billing Phase radio button under the Report Formatting tab.

Report Description (Detail Format)

Report Layout

This report is separated first into the Base Contract and Change Order sections, with subtotals for each. The next level is the Billing Phase level, with a heading and subtotal for each billing phase. The next level is the Cost Code level, with one line of detail for each Cost Code attached to the current Billing Phase.

Columns Descriptions

Code & Description columns

These columns contain the number and description of the cost code. In the Change Order section of the report, these columns contain the number and description of the current Change Order.

Contract

For Billing Phase Heading and Totaling lines, this column will be filled with the contract amount of the billing phase.

Billed to Date

For Billing Phase Heading and Totaling lines, this column will be filled with the amount billed to date for the billing phase.

% Billed

For Billing Phase Heading and Totaling lines, this column will contain the percent billed calculated using the Contract and Billed to Date figures.

Budget

For Cost Code line items, this column will contain the cost code budget amount.

Cost to-Date

For Cost Code line items, this column will contain the Cost to Date for the cost code.

% Comp

For Cost Code line items, this column will contain the percent complete calculated using the Budget and Cost to Date fields.

Est Profit

For Billing Phase Totaling lines, this column will contain the Estimated Profit amount calcuated using the Contract Amount and the total Cost to Date.

% Profit

For Billing Phase Totaling lines, this column will contain the Percent Profit calcuated using the Contract Amount and the total Cost to Date.

Report Sample