Unbilled Detail and Aging 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.

These columns are available on the Unbilled Detail and Aging Columns tab. Additional columns display if you select the Show Project/Phase/Task Info option on the Options tab.

Contents

Field Description
Billing Status This column displays the status of the transaction. The following are the possible values:
  • B — Released and available for billing to the client.

  • B* — Billed, but billed in an accounting period that is later than the accounting period for which you are running the report.

  • L — Labor adjustment posting not included.

  • H — Transaction is held to temporarily prevent billing to the client.

  • W — Transaction is written off, but the invoice has not been posted.

  • X — Transaction is written off, and the invoice has been posted.

Print the report at cost rates to view the non-billable transactions for a project and their associated amounts.

  • Non-billable transactions at billing rates display with a status of B and no amount.

  • Non-billable transactions at cost rates display with a status of B and the transaction amount.

You can also choose to include or exclude individual billing statuses.

Transaction Date This column displays the date entered for the labor or expense transaction.
Labor Code/Account This column displays the labor code to which the labor transaction was posted or the account to which the expense transaction was posted.
Employee/Reference This column displays the employee number of the employee to which the labor transaction applies or the reference number to which the expense transaction applies.
Description This column displays the description entered for the labor or expense transaction. If an additional description was entered, it displays to the right of the first description. (Journal entries can have two descriptions, for example.) Also, if you select Show Timesheet Comments on the Options tab, the report shows timesheet comments in this column.
Hours/Units This column displays the hours for the labor transaction or the units for the expense transaction.
Billing Rate This column displays the employee’s billing table rate or the employee’s job cost rate multiplied by as many as three multipliers.
Billing Amount This column displays the billing amount for the transaction. If your report includes this column, look for B as the indicator for the billing rate on the report (for example, B:5.0 Copies @1.00).

If you use the Multicurrency feature, the report displays this amount in the project's billing currency.

Labor Category This column displays the employee's labor category, such as Architect, Project Manager, or Engineer. (You assign employees to labor categories on the Accounting tab of the Employee Info Center.)
Cost Rate This column displays the employee’s job cost rate for the labor transaction.
Cost Amount This column displays the extended cost amount of the labor or expense transaction. Expense amounts do not include tax amounts.

Vision calculates the cost amount for an expense by multiplying the amount in the Cost field on the Expenses tab of Interactive Billing by any multiplier defined in the expense billing terms for the project.

Vision calculates the cost amount for a labor transaction by multiplying the value in the Rate field on the Labor tab of Interactive Billing by the number of hours in the Hours field.

If your report includes the Cost Amount column, look for C as the indicator for the cost rate on the report. Example: C:5.0 Copies @.50

Age 01 - Age 10 If you select aging columns, the report distributes the transaction amounts into those columns by age based on the aging date you specified.