Project Detail 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. The columns you select on the Columns tab are for the labor and expense detail rows.

Additional Data

In addition to the columns you select on the Columns tab, you can use the options on the Options tab to display other information:

  • Options in the Information Section group box If you select Print Project Info in the Information Section group box on the Options tab, the report displays selected information from the Project Info Center (principal, project manager, client, and so on) for each work breakdown structure (WBS) level. You can also print user-defined fields and the contents of Memo from the General tab of the Project Info Center.
  • Print Financial Analysis — If you select Print Financial Analysis on the Options tab, the report displays a Financial Analysis section for each WBS level. Those sections display amounts in the following columns for the current period, the current year, and the project to date:
    • Fee Billed
    • Consult. Billed
    • Reimb Billed
    • Other Billed
    • Total Billed
    • Revenue
    • Spent
    • Profit (at cost rates) or Variance (at billing rates)
    • Profit Pct (at cost rates) or Variance Pct (at billing rates)

Contents

Field Description
Regular Hours This column displays the number of regular hours.
Total Overtime Hours This column displays the number of overtime hours. This includes standard overtime hours and secondary overtime hours.
Total Hours This column displays the total number of hours: Regular Hours + Total Overtime Hours.
Total Amount For the labor detail lines, this column displays the total amount for regular and overtime labor: Regular Amount + Overtime Amount.

For the expense detail lines, this column displays the total expense amount.

Billing This column displays the total labor amount or expense amount at billing rates.

This column is only available if your firm is using Vision Billing.

Multicurrency

If you select Project's Functional Currency in Report in on the General tab, Vision does not display the Billing column on the report, and it is not available for selection on the Columns tab.

Overtime Hours This column displays the number of standard overtime hours.
Secondary Overtime Hours This column displays the number of secondary overtime hours.

Secondary overtime is overtime that is paid at a different rate than standard overtime. If you pay separately for secondary overtime, you must record those hours separately on the timesheet. You set secondary overtime on the Accounting tab of the Employee Info Center.

Regular Amount This column displays the amount for regular hours. Vision calculates Regular Amount as follows:

Regular Hours * Labor cost rate

Overtime Amount This column displays the amount for standard overtime hours.

Vision calculates overtime costs for hourly employees differently than it does for salaried employees:

  • For hourly employees, Vision calculates Overtime Amount as follows:

    Overtime Hours * Hourly labor cost rate * Overtime percentage

  • For salaried employees, Vision calculates Overtime Amount as follows:

    Overtime Hours * Annualized hourly rate * Overtime percentage

Vision calculates the annualized hourly rate as follows: Annual salary / (Hours per week * 52)

Secondary Overtime Amount This column displays the amount for secondary overtime hours.
Total Overtime Amount This column displays the total amount for all overtime hours: Overtime Amount + Secondary Overtime 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.
Labor Category This column displays the employee's labor category (for example, Principal, Project Manager. or Engineer).