Paid vs Unpaid Invoices Job Cost Analysis

This report differentiates between material costs which have been billed and material costs for which the invoices have been paid.

This report is accessible through Job Costing Analysis Reports.

To print this report, check the Paid vs. Unpaid Invoices radio button under the Report Formatting tab.

There are two possible reports available.

Report Description - Paid vs. Invoiced Job Cost Analysis Report (Detail)

Cost Code

The number and description of the cost code are listed here.

Budgets

The original budget and the current (revised) budget for the cost code are listed here.

Invoiced -- Cost to-Date

This column shows the total of all costs assigned to this cost code through Accounts Payable Invoice Entry.

Invoiced -- Percentage

This is the percentage of the budget which has been invoiced. The percentage is derived by dividing the cost to-date figure by the current budget figure.

Invoiced -- Remaining

This is the amount of the budget which has yet to be invoiced. The figure is derived by subtracting the cost to-date figure from the current budget figure.

Paid -- To-Date

This column shows the total of all payments made for invoiced costs assigned to this cost code.

Paid -- Percentage

This is the percentage of the budget which has been paid. The percentage is derived by dividing the paid to-date figure by the current budget figure.

Paid-- Remaining

This is the amount of the budget which has yet to be paid. The figure is derived by subtracting the paid to-date figure from the current budget figure.

Balance to Pay

This is the dollar amount remaining to be paid on the budget item. It is derived by subtracting the amount paid to-date from the current budget. The report prints totals for all columns with the ‘percentage’ column totals being averages for all the codes included in the report.

Report Description - Paid vs. Invoiced Job Cost Analysis (Summary)

The Summary Format is identical to the Detail format except for three exceptions. The cost codes are not itemized, there are no cost code descriptions 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: Paid vs. Invoiced Job Cost Analysis Report (Detail)

Report Sample: Paid vs. Invoiced Job Cost Analysis Report (Summary)