Expense Detail Options Tab

Use detail options to choose which expense items appear on the report. Use time frame options to specify the contracts that have a time period for the report. Use reporting amounts to specify the currency for the report. Use rollup options to summarize all projects in the report based on part of the project, phase, or task number.

Reporting Amounts

Field Description
Report At

Select one of the following options:

  • Billing: Select this option to display monetary amounts at billing rates. This option is only available if the Enable Reporting at the Billing Rates option is set to Yes in Settings > Accounting > Labor Options.
  • Cost: Select this option to display monetary amounts at cost rates. This option is only available if the Reporting at Burdened Rates option is set to No in Settings > Accounting > Labor Options.

Report In If Report At is set to Cost, select the types of currency in which to display amounts in the Financial Analysis sections:
  • Project Currency: Select this setting to use the currency specified in Project Currency on the Overview tab of the Projects form in the Projects hub.
  • Billing Currency: Select this setting to use the currency specified in Billing Currency on the Overview tab of the Projects form in the Projects hub.
  • Project's Functional Currency: Select this setting to display amounts on the report in the functional currency of the project.

If Report At is set to Billing, you cannot select this option. In that case, the currency is based on the Use Billing Currency not Project Currency option in Settings > Accounting > Labor Options:

  • When that option is set to Yes, the report displays monetary amounts in the project's billing currency.
  • When that option is set to No, the report displays monetary amounts in the project currency.

Detail Options

Field Description
Display Reimbursable Expenses Select this check box to display reimbursable expenses.
Include Committed PO Expenses

Select this option to include as expenses any amounts committed to approved purchase orders. If you include committed expenses, you can see major upcoming costs that affect a project’s bottom line.

Display Direct Expenses Select this check box to display direct expenses.
Display Indirect Expenses Select this check box to display indirect expenses.
Display Reimbursable Consultant Expenses Select this check box to display reimbursable consultant expenses.
Display Direct Consultant Expenses Select this check box to display direct consultant expenses.
Consultant Breakout

Select this check box to display consultant expenses separately from other expenses:

  • If you select this option, the report displays the consultant expenses as a separate group with a separate total under direct and reimbursable expenses.
  • If you do not select this option, direct consultant accounts are included in the Direct Expense category, and reimbursable consultants are included in the Reimbursable Expense category.

Time Frame Options

Field Description
Time Frame
Use these options to specify the time frame for data included on the report.
  • Current Period: The report shows data for the active accounting period.
  • Year-to-Date: The report shows data for the current fiscal year through the active accounting period.
  • Job-to-Date: The report shows data from the beginning of the project through the active accounting period.
  • Date Range: The report shows data for a date range that you specify. Vantagepoint examines transactions within the specified date range, regardless of the period in which the transactions were posted or the dates of the current active period. Enter the start and end dates, or click the calendar icons to select the dates.
  • Period Range: The report shows data for a range of accounting periods that you specify.

Activity Basis

Field Description
Report Records with Activity in the Following Area Use this option to the areas in which you want to report activity. Depending on your security role, you may have access to one or more of the following WBS levels:
  • Project
  • Phase
  • Task
Define Activity Select the type of activity that you want to include on the report:
  • Labor, Expense, Cash Receipts, and Invoices
  • Labor and Expense Transactions Only
Find Activity in this Time Frame Select the time frame for which you want to include activity:
  • Current
  • Year-to-date
  • Job-to-date
  • Period Range

If you select Period Range, the report uses the range of accounting periods that you specified under Time Frame Options.

Rollup Options

Field Description
Project Number Rollup Options

Use this option to summarize report information for projects that use a standard numbering system. For example, if the first five characters of your project number represent a master contract, you can summarize (roll up) information for all projects that have a common master contract number.

The Project Number Rollup slider box displays the number of characters in your (firm's) project numbers. For example, if you use a 10-digit project number, the slider box displays 123456790. A project number can also include up to two delimiters (such as, 12-345.67890).
  • A phase total is the total of all occurrences of that phase across the base project.
  • A task total is the total of all occurrences of that task across the base project.

To roll up, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.

Display Data As If you set a project number rollup, use this option to select how you want to display the project data:
  • Subtotal on Base Number: Select this option to display a group header at the beginning of each group of projects that matches the base rollup and then list each project in full detail. After the last project in the group, the report displays a group total.
  • Summary on Base Number: Select this option to display totals for each group, but no project detail.
Phase Number Rollup Options

Use this option to summarize report information at the phase level for phases that use a standard numbering system. This option is only available if you use phases.

The Phase Number Rollup slider box displays the number of characters in your firm's phase numbers. For example, if you use a 7-digit phase number, the slider box displays 1234567. A phase number can also include one delimiter (such as 12345.12).

You can roll up the phase number and still display information by task. When you do, a task total is the total of all occurrences of that task across the base project. For example, the total for Task 00001 is the total of all Task 00001s in the base project.

To display only phases (and tasks), use the Project Number Rollup slider (box) to cover the project number completely.

To roll up, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.

Task Number Rollup Options

Use this option to summarize report information at the task level for tasks that use a standard numbering system. This option is only available if you use tasks.

The Task Base Rollup slider box displays the number of characters in your firm's task numbers. For example, if you use a 3-digit task number, the slider box displays 123.

This option works in the same way as the project and phase number rollup options. For example, if the first two characters of your task number represent a department, you can roll up information for all tasks that have the same department number.

To display only tasks, use the Project Number Rollup and Phase Number Rollup sliders to cover the project number and phase number completely.

To roll up, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.