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:
-
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.) 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 multiple currencies, 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 Employees hub.)
|
| 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.
DPS 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.
DPS 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.
|
