Office Earnings 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.

If you enabled revenue generation and you track unbilled revenue for multiple revenue categories, you can select additional report columns related to those revenue categories. If you track all five revenue categories, five sets of these columns are available for the report.

Contents

Field Description
Revenue Amount This column displays the amount of revenue.
Billed Amount This column displays the total amount billed. The amount in this column does not includes taxes, but the AR Amount and Received Amount columns do.
Unbilled Amount

This column displays the amount of revenue that has not yet billed, calculated as follows:

Revenue Amount - Billed Amount

Received Amount This column displays the amount received in payments. This includes taxes paid.
AR Amount This column displays the amount that is billed but not yet received in payment. This includes taxes billed.
Spent Amount

This column displays the total spent (Labor + Overhead + Direct expenses + Reimbursable expenses).

If you generate the report at billing rates, the spent amount equals the following at billing value:

Labor + Direct expenses + Reimbursable expenses

To include overhead in the spent amount, select the Overhead check box in the Print group box on the General tab.

Profit/Variance

This column displays the profit or variance amount., calculated as follows:

Revenue Amount - Spent Amount

  • If you generate the report at cost rates, the result is called Profit.
  • If you generate the report at billing rates, the result is called Variance.
Profit/Variance Percent

This column displays the profit or variance as a percentage, calculated as follows:

  • If you generate the report at cost rates: Profit / Revenue Amount
  • If you generate the report at billing rates: Variance / Revenue Amount

By comparing the profit percentage for the current period to the year-to-date and job-to-date profit percentages, you can see the effect of the recent performance on the overall profitability.

You can only generate this report at billing rates if the Reporting at billing rates option is selected on the Reporting tab of the Accounting System Settings form.

Labor Billed This column displays the amount billed for labor.
Consultant Billed This column displays the amount billed for reimbursable consultant expense.
Expense Billed This column displays the amount billed for all expenses.
Fee Billed This column displays the amount billed for fees.
Unit Billed This column displays the amount billed for units.
Add On Billed This column displays the amount billed for add-ons. Add-ons are markups applied to labor, expenses, consultants, reimbursables, fees, units, or to add-ons themselves. You establish add-ons for a project in Billing Terms.
Taxes Billed This column displays the amount billed for taxes.
Interest Billed This column displays the amount billed for interest.
Other Billed

This column displays the amount billed for charges that are not assigned to a specific category.

DPS decides what to include in this column based on how you set up your revenue accounts in these locations:

Do you use Interactive Billing? Revenue accounts in this location are checked:
Yes The Accounts tab of the Billing Setup form (Settings > Billing > General)
No The Invoice Mapping Accounts tab of the Accounts Receivable Configuration form (Settings > Accounting > Accounts Receivable)

Unbilled Gain/Loss This column displays the gain/loss entries to unbilled services due to rate fluctuations.
Adjusted Unbilled This column displays the Adjusted Unbilled amount that includes the Unbilled Gain/Loss entries. The calculation for this column is Revenue - Billed + Unbilled Gain/Loss = Adjusted Unbilled. When this column is displayed in functional currency, it will match the Unbilled Services account in the general ledger, and will also match the Unbilled Services line in the File Reconciliation Report.
Hours This column displays the total hours worked (regular, standard overtime, and secondary overtime).
Budgeted Hours This column displays the total hours budgeted. Your selection in Budget Source on the Budget tab determines whether budget hours and amounts come from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
ETC Hours This column displays the estimate to complete (ETC) hours. The estimate to complete hours are the estimated additional labor hours required to complete the work.
EAC Hours This column displays the estimate at completion (EAC) hours. The estimate at completion hours are the estimated total number of hours that will have been worked at the completion of the project: Actual hours + Estimate to complete hours.
Balance Hours

This column displays the labor hours remaining to complete the work, calculated as follows:

Budgeted Hours - Job-to-date hours

Labor Amount This column displays the labor amount spent.
Overhead Amount

This column displays the overhead amount. To display overhead in this column and include it in the Spent Amount column, you must select the Overhead option in the Print group box on the General tab.

If you want to include overhead but you have not yet allocated overhead for the current period, select the Estimate Overhead check box on the General tab to use estimated overhead amounts.

Total Reimbursable This column displays the amount spent for reimbursable consultant expenses and other reimbursable expenses.
Reimbursable Consultant This column displays the amount spent for reimbursable consultant expenses.
Reimbursable Other This column displays the amount spent for reimbursable expenses other than consultant reimbursable expenses.
Total Direct This column displays the amount spent for direct consultant expenses and other direct expenses.
Direct Consultant This column displays the amount spent for direct consultant expenses.
Direct Other This column displays the amount spent for direct expenses other than direct consultant expenses.
Total Consultant This column displays the total spent for all direct consultant expenses and reimbursable consultant expenses.
Total Other Expenses This column displays the total spent for all direct expenses and reimbursable expenses other than consultant expenses.
Total Expenses This column displays the total spent for all direct expenses, direct consultant expenses, reimbursable expenses, and reimbursable consultant expenses.
ETC Amount This column displays the estimate to complete (ETC) amount. The estimate to complete amount is the estimated additional monetary amount that is required to complete the work.
EAC Amount This column displays the estimate at completion (EAC) amount. The estimate at completion amount is the estimated total monetary amount that will have been expended at the completion of the project.
Budgeted Amount This column displays the budgeted monetary amount. Your selection in Budget Source on the Budget tab determines whether budget hours and amounts come from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
Balance Amount This column displays the monetary amount remaining to be spent to complete the work, calculated as follows:

Budgeted Amount - Job-to-date spent amount.

Project Currency Code This column displays the three-character code for the project currency.
Billing Currency Code This column displays the three-character code for the billing currency.
Functional Currency Code This column displays the three-character code for the functional currency.
Revenue Type

This column displays the revenue type. The revenue type is a code to identify how DPS calculates revenue for the task, phase, or project. There are six standard revenue types:

  • B: Job-to-date billing
  • M: (Job-to-date direct labor * Multiplier) + Job-to-date reimbursable expenses @ cost rates
  • N: No revenue generation
  • P: Percent complete + Job-to-date reimbursable expenses @ cost rates
  • R: Job-to-date receipts
  • W: Job-to-date billing + Work-in-progress @ billing rates
Rev. Multiplier/Amount This column displays the multiplier, percentage, or amount for the revenue method.

The report only displays a value in this column for the lowest work breakdown structure levels.

Rev. Multiplier/Amount (Sum) This column displays the multiplier, percentage, or amount for the revenue method. The difference between this column and the Rev. Multiplier/Amount column is that DPS treats this column as an amount column and displays group totals for it. This can be useful if you use calculated fields and want the revenue multiplier to be treated as an amount rather than as a multiplier.
Compensation

This column displays the total monetary amount you expect to receive for direct labor and direct expenses. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form (Settings > Advanced Accounting > System), these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Fee Direct Labor

This column displays the monetary amount you expect to receive for direct labor. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Fee Direct Expense

This column displays the total monetary amount you expect to receive for direct expenses. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Fee Direct Consultant

This column displays the monetary amount you expect to receive for direct consultant fees. This amount includes any markups on consultant professional services. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Reimbursable Allowance

This column displays the expected amount of reimbursable expenses and reimbursable consultant fees. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Fee Reimbursable Expense

This column displays the expected amount of reimbursable expenses. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Fee Reimbursable Consultant

This column displays the expected amount of reimbursable consultant fees. This amount includes any markups on consultant professional services. These amounts come from the Projects hub.

If At all levels of the WBS is selected under Project Fee Entering Method on the Accounting System Settings form, these amounts are only displayed for the work breakdown structure level at which they were entered. If you use grouping options that are not part of the work breakdown structure, this column will be blank for those groups.

Total Compensation

This column displays the total compensation that you expect to receive, calculated as follows:

Compensation + Fee Direct Consultant + Reimbursable Allowance

Backlog

This column displays the unearned monetary amount for work that is under contract, calculated as follows:

Total Compensation - Job-to-date Revenue Amount

Backlog is used as an indicator of a firm's business volume, which is usually expressed as the number of months of backlog.

Percent Budget Expended

This column displays the percentage of the budget expended as of the current date, calculated as follows:

Job-to-date Spent Amount / Budgeted Amount

Percent Complete Reported This column displays the overall percent complete. The percentage is based on cost or billing amounts, depending on your selection in Report At. DPS calculates this percentage based on your selection of budget source on the Budget tab of the Options dialog box and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
% Labor Comp. Rpt This column displays the percent complete for labor. The percentage is based on cost or billing amounts, depending on your selection in Report At. DPS calculates this percentage based on your selection of budget source on the Budget tab of the Options dialog box and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans. Overhead is not included in these calculations.
% Expense Comp. Rpt This column displays the percent complete for expenses. The percentage is based on cost or billing amounts, depending on your selection in Report At. DPS calculates this percentage based on your selection of budget source on the Budget tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
Percent ETC Expended

This column displays the estimate to complete amount expressed as a percentage of the budgeted amount, calculated as follows:

ETC Amount / Budgeted Amount

Net Revenue

This column displays the net revenue amount, calculated as follows:

Revenue Amount - (Direct expenses + Reimbursable expenses)

Gross Margin

This column displays the gross margin amount, calculated as follows:

Revenue Amount - (Labor + Direct expenses + Reimbursable expenses)

Firms that do not allocate overhead show project results on a gross margin basis.

Real. Ratio/ Eff. Multiplier

This column displays the realization ratio or the effective multiplier.

  • If you generate the report at billing rates, it displays the realization ratio. The realization ratio is the net revenue earned for each labor dollar billed. DPS calculates the realization ratio as follows:

    Net Revenue / Direct labor at billing rates

  • If you generate the report at cost rates, it displays the effective multiplier. The effective multiplier is the net revenue earned for each labor dollar expended. DPS calculates the effective multiplier as follows:

    Net Revenue / Direct labor at cost rates

Spent Less Overhead This column displays the amount spent, excluding overhead. If you select Overhead in the Print group box on the General tab, the Spent Amount column includes overhead in the spent amounts. If you also want to see spent amounts excluding overhead on the same report, select this column for the report.
Project This column displays the project number.
Phase This column displays the phase number.
Task This column displays the task number.
Committed Purchase Order Expense This column displays the expense amount committed to approved purchase orders. To display data in this column, you must also select Committed Purchase Order Expenses on the General tab.
Contract Compensation This column displays the monetary amount you expect to receive for direct labor and direct expenses related to the contract.
Contract Direct Labor This column displays the monetary amount you expect to receive for direct labor related to the contract.
Contract Direct Expense This column displays the monetary amount you expect to receive for direct expenses related to the contract.
Contract Direct Consultant This column displays the monetary amount you expect to receive for direct consultant fees related to the contract.
Contract Reimbursable Allowance This column displays the reimbursable allowance amount related to the contract.
Contract Reimbursable Expense This column displays the expected amount of reimbursable expenses related to the contract.
Contract Reimbursable Consultant This column displays the expected amount of reimbursable consultant fees related to the contract. This amount includes any markups on consultant professional services.
Contract Total Compensation This column displays the sum of Contract Compensation, Contract Direct Consultant, and Contract Reimbursable Allowance amounts.
Contract Backlog This column displays the total of Contract Total Compensation - JTD Revenue.
<revenue category> Unbilled These columns display the unbilled revenue amount for the revenue category. For example, the Labor Unbilled column would display the amount of unbilled labor revenue.
<revenue category> Revenue

These columns display the revenue amount for the revenue category. For example, the Labor Revenue column would display the amount of revenue for labor.

DPS calculates the revenue as follows:

Billed revenue for the revenue category + Unbilled revenue for the revenue category

<revenue category> Revenue Type These columns display the revenue type for the revenue category. For example, the Labor Revenue Type column displays the revenue type for labor revenue.