Columns for Office Earnings Report

You can select the columns to display on your report.

Contents

Field	Description
% 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. This percentage is calculated based on your selection of budget source on the Budget & Expense tab 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. This percentage is calculated based on your selection of budget source on the Budget & Expense tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
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.
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.
AR Amount	This column displays the amount that is billed but not yet received in payment. This includes taxes billed.
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.
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.
Balance Hours	This column displays the labor hours remaining to complete the work, calculated as follows: Budgeted Hours - Job-to-date hours
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.
Billing Currency Code	This column displays the three-character code for the billing currency.
Budgeted Amount	This column displays the budgeted monetary amount. Your selection in Budget Source on the Options tab of the Project Earnings report determines whether budget hours and amounts come from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
Budgeted Hours	This column displays the total hours budgeted. Your selection in Budget Source on the Options tab of the Project Earnings report determines whether budget hours and amounts come from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
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 Include Committed Purchase Order Expenses on the Options tab.
Compensation	This column displays the total monetary amount you expect to receive for direct labor and direct expenses related to the project.
Consultant Billed	This column displays the amount billed for reimbursable consultant expense.
Contract Backlog	This column displays the total of Contract Total Compensation - JTD Revenue.
Contract Compensation	This column displays the monetary amount you expect to receive for direct labor and 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 Direct Expense	This column displays the monetary amount you expect to receive for 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 Reimbursable Allowance	This column displays the expected amount of reimbursable expenses and reimbursable consultant fees 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 Reimbursable Expense	This column displays the expected amount of reimbursable expenses related to the contract.
Contract Total Compensation	This column displays the sum of Contract Compensation, Contract Direct Consultant, and Contract Reimbursable Allowance amounts.
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.
EAC Amount	This column displays the estimate at completion (EAC) amount for the labor code or expense account for the project, phase, or task. This is the estimate of the total monetary amount that will have been charged to the labor code or expense account at the completion of the project.
EAC Hours	This column displays the estimate at completion (EAC) hours for the labor code for the project, phase, or task. This is the estimate of the total number of hours that will have been charged to the labor code at the completion of the project.
ETC Amount	This column displays the estimate to complete (ETC) amount. This is the estimate of the total additional monetary amount, beyond that already charged, that will be charged to the labor code or expense account during the completion of the project.
ETC Hours	This column displays the estimate-to-complete (ETC) hours. This is the estimate of the remaining labor hours needed to complete the work, as of the current date.
Expense Billed	This column displays the amount billed for all expenses.
Fee Billed	This column displays the amount billed for fees.
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.
Fee Direct Expense	This column displays the monetary amount you expect to receive for direct expenses related to the project.
Fee Direct Labor	This column displays the monetary amount you expect to receive for direct labor related to the project.
Fee Reimbursable Consultant	This column displays the expected amount of reimbursable consultant fees related to the project. This amount includes any markups on consultant professional services.
Fee Reimbursable Expense	This column displays the expected amount of reimbursable expenses related to the project.
Functional Currency Code	This column displays the three-character code for the functional currency.
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.
Hours	This column displays the job-to-date budgeted hours for work charged to the labor code for the project, phase, or task.
Interest Billed	This column displays the amount billed for interest.
Labor Amount	This column displays the labor amount spent.
Labor Billed	This column displays the amount billed for labor.
Net Revenue	This column displays the net revenue amount, calculated as follows: Revenue Amount - (Direct expenses + Reimbursable expenses)
Other Billed	This column displays the amount billed for charges that are not assigned to a specific category. Vantagepoint 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)
Other Revenue Amount	This column displays the revenue amount of the Other Charges account type for the current period.
Other Unbilled Amount	This column displays the unbilled amount of the Other Charges account type for the current period.
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.
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. Vantagepoint 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.
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
Phase	This column displays the phase number.
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 Yes is selected in the Enable Reporting at billing rates option in the Labor Options form (Settings > Accounting > Labor Options).
Project	This column displays the project number.
Project Currency Code	This column displays the three-character code for the project currency.
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. Vantagepoint 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. Vantagepoint calculates the effective multiplier as follows: Net Revenue / Direct labor at cost rates
Received Amount	This column displays the amount received in payments. This includes taxes paid.
Reimbursable Allowance	This column displays the expected total amount of reimbursable expenses: Reimbursable Allowance Expense Fee + Reimbursable Allowance Consultant Fee. The amount is in the project's cost currency. This amount is calculated from the fee entries on the Project Review form of the Projects hub.
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.
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 Vantagepoint 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.
Revenue Amount	This column displays the amount of revenue.
Revenue Type	This column displays the revenue type. The revenue type is a code to identify how Vantagepoint 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
Row Count	This column displays the row number of a line item.
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.
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.
Task	This column displays the task number.
Taxes Billed	This column displays the amount billed for taxes.
Total Compensation	This column displays the total compensation for the task, phase, or project, calculated as follows: Compensation + Fee Direct Consultant + Reimbursable Allowance
Total Consultant	This column displays the total spent for all direct consultant expenses and reimbursable consultant expenses.
Total Direct	This column displays the amount spent for direct consultant expenses and other direct expenses.
Total Expenses	This column displays the total spent for all direct expenses, direct consultant expenses, reimbursable 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 Reimbursable	This column displays the amount spent for reimbursable consultant expenses and other reimbursable expenses.
Traffic Live Project Name	If the project is linked to a job in TrafficLIVE, this column displays the name of the TrafficLIVE project to which the job belongs.
Unbilled Amount	This column displays the amount of revenue that has not yet billed, calculated as follows: Revenue Amount - Billed Amount
Unbilled Gain/Loss	This column displays the gain/loss entries to unbilled services due to rate fluctuations.
Unit Billed	This column displays the amount billed for units.