Cost vs Budget Job Cost Analysis Report

The Costs vs. Budget Job Cost Analysis Report is very similar to the Complete Job Cost Analysis Report. This report also gives a detailed report of actual costs; however, no quantities are included. This is the only job cost report that includes the control account for each job phase.

This report is accessible through Job Costing Analysis Reports. To print this report, check the Cost vs Budget radio button under the Report Formatting tab.

see Print Change Order Detail for Current Budget (check box)
 see New Page for Each New Job (check box)
 see Print Order
 see Detail Level
 see Orientation Level

There are two possible reports

1.

Report Description: Costs vs. Budget Job Cost Analysis Report (Detail Format)

 

Report Sample: Costs vs. Budget Job Cost Analysis Report (Detail Format)

2.

Report Description: Costs vs. Budget Job Cost Analysis Report (Summary Format)

 

Report Sample: Costs vs. Budget Job Cost Analysis Report (Summary Format)

Report Description (Detail)

Heading

The report heading consists of the report title, date, page number and company name. The limits set at the time of printing are also included.

Cost Code

This is the cost code or job phase. Following the code number is the code type (Labor, Materials, Subcontracts, Equipment, Burden or General). If a grouping code is assigned, the code is printed behind the code type.

Cost Description

This column contains the name or description of the cost code for the job phase listed.

To-Date

This is the actual cost to-date as recorded through the accounting system. This would include amounts charged to the job through Accounts Payable, Payroll, General Ledger and/or other modules. Cost to-date figures are derived directly from the job cost file. In the case of costs accrued through Accounts Payable, this cost to-date field is updated every time an invoice is posted. For this reason, the cost to-date columns on this report reflect all invoices posted, whether they are paid or not.

Costs

Remaining

This field is the projected completion cost. If field reports total completion cost, that amount will be listed in the field. The projected cost is calculated if a percent complete or other method is used to report job progress.

Projected

This field is the projected completion cost. If field reports total completion cost, that amount will be listed in the field. The projected cost is calculated if a percent complete or other method is used to report job progress.

Budget

Original

This is the original budget for the job phase.

Current

This is the current budget for the job phase.

Percent

Over

This column shows the percent that each job phase is over or under budget using the projected cost versus the current budget. A negative amount means that the cost phase is at a lower cost than currently budgeted.

F. Rpt

This is the percent complete as reported on the last field report. If percent complete is not entered on the field report, this field will be empty.

Calc

This is the calculated percent complete. If percent complete is to be entered on the field report and the field report is not current, this field is calculated as explained above. If cost to complete or total completion cost is entered on the field report, this field is calculated for the latest information.

Subcontractor

If the cost code is subcontracted, the subcontractor’s name and vendor number are listed.

Account Number

This column shows the control account for the job phase. This is the only report that shows the assigned control account.

Subtotals

Each group of related job phases is subtotaled for budgets, variances, costs and overrun. The sub-totals are listed after the last related phase code.

Job Totals

Each column is totaled for budgets, variances, costs and overrun. The totals are listed at the bottom of the report.

Report Description: (Summary Format)

The Summary Format is identical to the Detail format except for three exceptions. The cost codes are not itemized, there is no cost code description and the Field Report field is empty.

Cost Code (Subtotal Titles)

The Subtotal titles for each group of cost codes are listed.

Field Report %

This field will be empty.

Report Sample (Detail Format)

Report Sample (Summary)