Columns for Unbilled Summary Report

You can select the columns to display on your report.

Field Description
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 that you specify.
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 multiple currencies, the report displays this amount in the project's billing currency.

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 Status

This column displays the status of the transaction:

  • B: The transaction is released and available for billing to the client.
  • B*: The transaction is billed, but in an accounting period that is later than the accounting period for which you are running the report.
  • L: The transaction is a labor adjustment posting, and is not included.
  • H: The transaction is held, to temporarily prevent billing to the client.
  • W: The transaction is written off, but the invoice has not been posted.
  • X: The 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 status settings.

Cost Amount

This column displays the extended cost amount of the labor or expense transaction. Expense amounts do not include tax amounts.

Vantagepoint 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.

Vantagepoint 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

Cost Rate This column displays the employee’s job cost rate for the labor transaction.
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.) If you select Show Timesheet Comments on the Options tab, the report shows timesheet comments in this column.
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.
Hours This column displays the job-to-date budgeted hours for work charged to the labor code for the project, phase, or task.
Labor Code/Account This column displays the labor code for labor budget items and the expense account for expense budget items.
Row Count This column displays the row number of a line item.
Transaction Date This column displays the date on which the transaction was posted.