Project Top-Bottom Performers Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Contents

Field	Description
AR - Current	This column displays the total outstanding amount for billed invoices that are 0-30 days old.
AR - JTD	This column displays the total outstanding amount for invoices billed since the beginning of the job.
AR - YTD	This column displays the total outstanding amount for invoices billed since the beginning of the fiscal year.
Backlog or Backlog - Project Currency	This column displays the monetary value of work that is under contract but that has not yet been earned. Backlog is an indicator of business volume. DPS calculates backlog as follows: Total Compensation - Job-to-date revenue. (Total compensation = Compensation + Consultant fee + Reimbursable allowance) If you use multiple currencies, the column name is Backlog-Project Currency. For this backlog column, DPS converts project currency amounts into presentation currency amounts.
Backlog - Billing Currency	This column is only available if you use multiple currencies. It displays the monetary value of work that is under contract but that has not yet been earned. Backlog is an indicator of a firm's business volume. DPS calculates backlog as follows: Total Compensation - Job-to-date revenue. (Total compensation = Compensation + Consultant fee + Reimbursable allowance). For this backlog column, DPS converts billing currency amounts into presentation currency amounts.
Backlog - Functional Currency	This column is only available if you use multiple currencies. It displays the monetary value of work that is under contract but that has not yet been earned. Backlog is an indicator of a firm's business volume. DPS calculates backlog as follows: Total Compensation - Job-to-date revenue. (Total compensation = Compensation + Consultant fee + Reimbursable allowance). For this backlog column, DPS converts functional currency amounts into presentation currency amounts.
Billed - Current	This column displays the amount billed for the current accounting period.
Billed - JTD	This column displays the amount billed for the job to date.
Billed - YTD	This column displays the amount billed for the fiscal year to date.
Unbilled - Current	This column displays the unbilled amount for the current accounting period: Revenue - Billed amount.
Unbilled - JTD	This column displays the unbilled amount for the job to date: Revenue - Billed amount.
Unbilled - YTD	This column displays the unbilled amount for the fiscal year to date: Revenue - Billed amount.
Effective Multiplier - Current	The column displays the effective multiplier for the current period. The effective multiplier is a productivity measure. It represents the amount of net revenue earned for each labor dollar spent. DPS calculates net revenue as follows: Earned Revenue - (Direct and reimbursable expenses) DPS then calculates the effective multiplier as follows: Net revenue / Direct labor at cost rates
Effective Multiplier - JTD	The column displays the effective multiplier for the job to date. The effective multiplier is a productivity measure; it represents the amount of net revenue earned for each labor dollar spent. DPS calculates net revenue as follows: Earned Revenue - (Direct and reimbursable expenses) DPS then calculates the effective multiplier as follows: Net revenue / Direct labor at cost rates
Effective Multiplier - YTD	The column displays the effective multiplier for the fiscal year to date. DPS calculates net revenue as follows: Earned Revenue - (Direct and reimbursable expenses) DPS then calculates the effective multiplier as follows: Net revenue / Direct labor at cost rates
Gross Margin - Current	This column displays the gross margin for the current accounting period. DPS calculates the gross margin is calculated as follows: Total revenue - (Labor + Direct and reimbursable expenses) If you do not allocate overhead, you show project results on a gross margin basis.
Gross Margin - JTD	This column displays the gross margin for the job to date. DPS calculates the gross margin is calculated as follows: Total revenue - (Labor + Direct and reimbursable expenses) If you do not allocate overhead, you show project results on a gross margin basis.
Gross Margin - YTD	This column displays the gross margin for the fiscal year to date. DPS calculates the gross margin is calculated as follows: Total revenue - (Labor + Direct and reimbursable expenses) If you do not allocate overhead, you show project results on a gross margin basis.
Labor Direct Billing - Current	This column displays the direct labor amount at billing rates for the current accounting period.
Labor Direct Billing - JTD	This column displays the direct labor amount at billing rates for the job to date.
Labor Direct Billing - YTD	This column displays the direct labor amount at billing rates for the fiscal year to date.
Labor Direct Cost - Current	This column displays the direct labor amount at cost rates for the current accounting period
Labor Direct Cost - JTD	This column displays the direct labor amount at cost rates for the job to date.
Labor Direct Cost - YTD	This column displays the direct labor amount at cost rates for the fiscal year to date.
Net Revenue @ Billing - Current	This column displays the net revenue at billing rates for the current accounting period.
Net Revenue @ Billing - JTD	This column displays the net revenue at billing rates for the job to date.
Net Revenue @ Billing - YTD	This column displays the net revenue at billing rates for the fiscal year to date.
Net Revenue @ Cost - Current	This column displays the net revenue at cost rates for the current accounting period.
Net Revenue @ Cost - JTD	This column displays the net revenue at cost rates for the job to date.
Net Revenue @ Cost - YTD	This column displays the net revenue at cost rates for the fiscal year to date.
Profit - Current	This column displays the profit for the current accounting period: Revenue - Expenses. Overhead is not considered in this calculation.
Profit - JTD	This column displays the job-to-date profit: Revenue - Expenses. Overhead is not considered in this calculation.
Profit - YTD	This column displays the fiscal year-to-date profit: Revenue - Expenses. Overhead is not considered in this calculation.
Profit Less OH - Current	This column displays the profit for the current accounting period, less overhead: Revenue - (Expenses + Overhead).
Profit Less OH - JTD	This column displays the job-to-date profit, less overhead: Revenue - (Expenses + Overhead).
Profit Less OH - YTD	This column displays the fiscal year-to-date profit, less overhead: Revenue - (Expenses + Overhead).
Profit Percent - Current	This column displays the profit percentage for the current accounting period: Profit / Revenue. Overhead is not considered in this calculation.
Profit Percent - JTD	This column displays the job-to-date profit percentage: Profit / Revenue. Overhead is not considered in this calculation.
Profit Percent -YTD	This column displays the fiscal year-to-date profit percentage: Profit / Revenue. Overhead is not considered in this calculation.
Profit Percent Less OH - Current	This column displays the profit percentage for the current accounting period, less overhead: (Profit - Overhead) / Revenue.
Profit Percent Less OH - JTD	This column displays the job-to-date profit percentage, less overhead: (Profit - Overhead) / Revenue.
Profit Percent Less OH - YTD	This column displays the fiscal year-to-date profit percentage, less overhead: (Profit - Overhead) / Revenue.
Realization Ratio - Current	This column displays the realization ratio for the current accounting period. The realization ratio compares net revenue earned to labor at billing rates: Net revenue / Direct labor at billing rates.
Realization Ratio - JTD	This column displays the job-to-date realization ratio. The realization ratio compares net revenue earned to labor at billing rates: Net revenue / Direct labor at billing rates.
Realization Ratio - YTD	This column displays the fiscal year-to-date realization ratio for the current accounting period. The realization ratio compares net revenue earned to labor at billing rates: Net revenue / Direct labor at billing rates.
Revenue-Current	This column displays the revenue for the current accounting period.
Revenue - JTD	This column displays the job-to-date revenue.
Revenue - YTD	This column displays the year-to-date revenue.
Spent @ Billing - Current	This column shows the amount spent at billing rates for the current accounting period. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Billing - JTD	This column shows the amount spent at billing rates for the job to date. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Billing - YTD	This column shows the amount spent at billing rates for the fiscal year to date. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Cost - Current	This column shows the amount spent at cost rates for the current accounting period. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Cost - JTD	This column shows the amount spent at cost rates for the job to date. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Cost - YTD	This column shows the amount spent at cost rates for the fiscal year. DPS calculates the amount spent as follows: Labor + Overhead + Direct expense + Reimbursable expenses.
Spent @ Cost Less OH - Current	This column displays the spent amount (with no overhead included), at cost rates, for the current accounting period.
Spent @ Cost Less OH - JTD	This column displays the spent amount (with no overhead included), at cost rates, for the job (project) to date.
Spent @ Cost Less OH - YTD	This column displays the spent amount (with no overhead included), at cost rates, for the year to date.
Total Compensation/ Total Compensation - Project Currency	This column displays the total contract value for the project. Compensation is the total monetary amount your company expects to receive. This amount should include all labor and expenses. If you use multiple currencies, the column name is Total Compensation-Project Currency. For this total compensation column, DPS converts project currency amounts into presentation currency amounts.
Total Compensation - Billing Currency	This column is available only if you use multiple currencies. It displays the total contract value for the project. Compensation is the total monetary amount your company expects to receive. This amount should include all labor and expenses. For this total compensation column, DPS converts billing currency amounts into presentation currency amounts.
Total Compensation - Functional Currency	This column is available only if you use multiple currencies. It displays the total contract value for the project. Compensation is the total monetary amount your company expects to receive. This amount should include all labor and expenses. For this total compensation column, DPS converts functional currency amounts into presentation currency amounts.
Variance - Current	This column displays the variance amount between revenue and the amount spent for the current accounting period: Revenue at billing rates - Spent amount at billing rates.
Variance - JTD	This column displays the job-to-date variance amount between revenue and the amount spent: Revenue at billing rates - Spent amount at billing rates.
Variance - YTD	This column displays the fiscal year-to-date variance amount between revenue and the amount spent: Revenue at billing rates - Spent amount at billing rates.
Variance Percentage - Current	This column displays the variance as a percentage of revenue for the current accounting period: Variance amount / Revenue at billing rates.
Variance Percentage - JTD	This column displays the job-to-date variance as a percentage of revenue: Variance amount / Revenue at billing rates.
Variance Percentage - YTD	This column displays the fiscal year-to-date variance as a percentage of revenue: Variance amount / Revenue at billing rates.