Columns for Expense Summary Report

You can select the columns to display on your report.

Contents

Field	Description
Account Name	This column displays the name used to identify the account.
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.
Billing Currency Code	This column displays the three-character code for the billing currency.
Budget Amount	This column displays the budgeted amount. If you use Planning, your selection in Budget Source on the Options tab determines whether budget information comes 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.
Current Amount	This column displays the amount of account activity during the current accounting period.
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.
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.
Functional Currency Code	This column displays the three-character code for the functional currency.
JTD Amount	This column displays the job-to-date labor, overhead, or expense amount spent.
Pct EAC Expended	This column displays the percent estimate at completion expended for the expense account. The percent estimate at completion expended is the percentage of the estimate at completion amount for the account that has been expended for the task, phase, or project as of the current date. This percentage is calculated as follows: Expenses spent / EAC Amount
Pct ETC Expended	This column displays the percent estimate to complete expended for the expense account. The percent estimate to complete expended is the percentage of the estimate to complete for the account that has been expended on the task, phase, or project as of the current date. This percentage is calculated as follows: Expenses spent / Expenses spent + ETC Amount.
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.
Phase	This column displays the phase number for the transaction.
Project	This column displays the project number for the transaction.
Project Currency Code	This column displays the three-character code for the project currency.
Row Count	This column displays the row number of a line item.
Task	This column displays the task number associated with the transaction.
YTD Amount	This column displays the year-to-date labor amount spent.