Job Profitability Comparison Report

This section describes the fields and descriptions on the Job Profitability Comparison report.

The Job Profitability Comparison report provides various comparisons of central job cost figures: invoiced, up/down, open, entered cost, and so on, for the current year and the previous year. The data is grouped by company currency.

• You can drill down on the No & Name column to the Customer level and Job level.

Invoiced Tab

Column	Description
No & Name	This column displays the number and name of the current drill-down level. The drill-down levels are: Company Customer Job
Invoiced, Period	This column displays the invoiced amount in the selected period.
Invoiced, Prev. Year	This column displays the invoiced amount within the selected period last year.
Up/Down, Period	This column displays the up/down writing in the selected period.
Up/Down, Prev. Year	This column displays the up/down writing in the selected period last year.
Open Time, Period	This column displays the open number of hours in the selected period.
Open Time, Prev. Year	This column displays the open number of hours in the selected period last year.
Open Amount, Period	This column displays the open quantity in time activities in the selected period.
Open Time, Prev. Year	This column displays the open quantity in time activities in the selected period last year.
Cost Reg., Period	This column displays the entered cost in the selected period
Cost Reg., Prev. Year	This column displays the entered cost in the selected period last year.
GM, Period	This column displays the gross margin of the selected period.
GM, Prev. Year	This column displays the gross margin of the selected period last year.
GM %, Period	This column displays the percentage contributed by the GM to the total GM for the jobs displayed (or other dimension, depending on the drill level).
GM %, Prev. Year	This column displays the percentage contributed by the GM last year to the total GM in the previous year for the jobs displayed (or other dimension, depending on the drill level).

Budget Tab

Column	Description
No & Name	This column displays the number and name of the current drill-down level. The drill-down levels are: Company Customer Job
Invoiced	This column displays the invoiced billing price. Only invoices with an invoice date within the From Date - To Date interval are included.
Up/Down	This column displays the up/down writing for the period selected.
Open Time, Actuals	This column displays the open number of hours based on entries of the selected period.
Open Time, Budget	This column displays the open number of hours based on the budgeted figures.
Open Amount, Actuals	This column displays the open quantity for amount activities based on entries of the selected period.
Open Amount, Budget	This column displays the open quantity for amount activities based on the budget.
Cost Reg., Actuals	This column displays the cost entered within the selected period.
Cost Reg., Budget	This column displays the budgeted cost.
GM % YTD, Period	This column displays the percentage contributed by the GM year-to-date to the total GM for the jobs displayed (or other dimension, depending on the drill level). Year-to-date is defined as above. GM is calculated as invoiced billing price minus the invoiced cost price. Only entries with an entry date and invoices with an invoice date equal or before the end of the corresponding interval are included.
GM % YTD, Prev. Year	This column displays the percentage contributed by the GM year-to-date to the total GM in the previous year for the jobs displayed (or other dimension depending on the drill level). Year-to-date is defined as above. GM is calculated as invoiced billing price minus the invoiced cost price. Only entries with an entry date and invoices with an invoice date equal or before the end of the corresponding interval one year back are included.
Budgeted GM %, Period	This column displays the percentage contributed by the Budgeted GM to the total GM for the jobs displayed (or other dimension, depending on the drill level). The budget is the one assigned to the year prior to the year of the corresponding interval. Only entries with an entry date and invoices with an invoice date equal or before the end of the corresponding interval are included.
Budgeted GM %, Prev. Year	This column displays the percentage contributed by the Budgeted GM to the total GM in the previous year for the jobs displayed (or other dimension, depending on the drill level). The budget is the one assigned to the year prior to the year of the corresponding interval. Only entries with an entry date and invoices with an invoice date equal or before the end of the corresponding interval are included.