Budget Revision Worksheet

This report acts as a worksheet for reviewing and altering job budgets. The original budget estimate and the current budget are printed along with a column for filling in any budget revisions that may be deemed necessary. To assist in decision making, the actual cost-to-date and the costs incurred during the current month are also shown.

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

see Print Change Order Detail for Current Budget
 see New Page for Each New Job
 see Print Order
 see Detail Level
 see Orientation Level

There are two possible reports available.

Report Description (Detail format)

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 Description

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

Cost Code

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

Original Budgets

This is the original budget for the job phase.

Previous Month Budget

This is the budget for the job phase as of last month (actually the current budget).

Revised Budgets

This column is used as a worksheet to list revised budgets for the cost codes.

Actual Cost To-Date

This is the actual cost to-date as recorded through the accounting system. This includes 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 reports reflect all invoices posted, whether they are paid or not.

Costs This Month

The transaction file is scanned for all transactions for the current fiscal period. These are totaled and the result is printed in this column. The selected fiscal period may be changed through the Change Current Fiscal Period option in the General Ledger Main Menu.

Subcontractor Name and Number

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

Phase Subtotals

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

Job Totals

Each column is totaled for budgets and costs. 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 Format)