Columns for Employee Labor Audit Report
You can select the columns to display on your report.
Contents
Field | Description |
---|---|
Billing Status | This column displays the billing status of the labor hours. The following are the possible status settings:
|
Debit Account | When you post employee timesheets, Vantagepoint automatically posts the labor charges to the general ledger. This column displays the debit account currently specified on the Time Analysis form ( | ) and Absence Accrual form ( ). If that account changes between the time at which the timesheet was posted and the time when you generate this report, the account in this column will not be the same account used to post the labor charges.
Employee | This column displays the employee's identification number. |
Employee Name | This column displays the employee's full name: first, middle, and last name, with prefix and suffix. |
Employee Status | This column displays an employee's status: Active, Inactive, Terminated, or Terminated (cannot reactivate). |
Labor Code/Unit | This column displays the labor code or unit associated with the labor transaction. |
Overtime Amount | This column displays the billing, cost, or burdened cost amount for the overtime hours. Your entries in Report at and Report Cost in on the Options tab of the report control which of these amounts displays. |
Overtime Hours | This column displays the number of overtime hours. |
Organization Name | If your enterprise uses organizations in Vantagepoint, this column displays the organization to which an employee is assigned. |
Period | This column displays the accounting period associated with the labor transaction. |
Phase | This column displays the phase associated with the labor transaction. |
Phase Name | This column displays the name of the phase that is associated with the transaction. |
Posting Sequence | This column displays the posting sequence number of the transaction.
Vantagepoint assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on.
To see a numbered list of all of the postings for the current accounting period, select in the Navigation pane. |
Project | This column displays the project associated with the labor transaction. |
Project Name | This column displays the name of the project associated with the labor transaction. |
Provisional Cost Rate | This column displays an employee's provisional cost rate from the Accounting tab of the Employees hub. |
Provisional Billing Rate | This column displays an employee's provisional billing rate from the Accounting tab of the Employees hub. |
Realization Amount |
If you use the Employee Realization Reporting feature, this column displays an employee's posted realization amount. The realization amounts that display on this report include the potential realization from posted timesheets, labor adjustments, and employee-specific units, as well as the true realization from posted invoices. Realization always displays as a billing value, regardless of what you select in the Report at field on the Options tab. Employees' time records that were posted before the Employee Realization Reporting feature was turned on have a 0 realization amount associated with them. These records are assigned a realization amount when you allocate realization in Interactive Billing, Batch Billing, or Employee Realization. If you use multiple currencies, the currency in which realization amounts display depends on the report options and configuration options selected. |
Regular Amount | This column displays the billing, cost, or burdened cost amount for regular hours. Your entries in Report at and Report Cost in on the Options tab of the report control which of these amounts displays. |
Regular Hours | This column displays the number of regular hours. |
Reviewed By | If the transaction is a billing labor transfer and if the employee has acknowledged being informed of the transfer, this column displays the employee's name. This column is only available if the Enable Billing Transfer Audit option is set to Yes on the Timesheet Audit form of Time Settings ( ). |
Reviewed Date | If the transaction is a billing labor transfer and the employee has acknowledged being informed about the transfer, this column displays the date on which the acknowledgment occurred. This column is only available if the Enable Billing Transfer Audit option is set to Yes on the Timesheet Audit form of Time Settings ( ). |
Row Count | This column displays the row number of a line item. |
Secondary Overtime Amount | This column displays the amount for secondary overtime hours, which are paid at a different rate than standard overtime hours. This column is available only if you set Enable Secondary Overtime to Yes in . |
Secondary Overtime Hours | This column displays the number of secondary overtime hours. Secondary overtime is paid at a different rate than standard overtime. This column is available only if you set Enable Secondary Overtime to Yes in . |
Timesheet Date | This column displays the labor transaction date. |
Task | This column displays the task associated with the labor transaction. |
Task Name | This column displays the name of the task associated with the labor transaction. |
Timesheet Comments | This column displays any timesheet comments associated with the labor transaction. |
Total Amount | This column displays the billing, cost, or burdened cost amount for all hours: Regular amount + Overtime amount + Secondary overtime amount. Your entries in Report at and Report Cost in on the Options tab of the report control which of these amounts displays. |
Total Overtime Amount | This column displays the billing, cost, or burdened cost amount for all overtime hours: Overtime amount + Secondary overtime amount. Your entries in Report at and Report Cost in on the Options tab of the report control which of these amounts displays. |
Total Overtime Hours |
This column displays the total overtime hours, calculated as follows: Overtime Hours + Special Overtime Hours |
Transaction Type | This column displays the type of transaction: timesheet, labor adjustment, or billing labor transfer. |
Transfer Details | If the transaction is a billing labor transfer, this column indicates where the transaction was transferred from (for example, "Transferred from project 2013002.00") or where it was transferred to, depending on whether the report row is for the origin or the destination of the transfer.
This column is only available if the Enable Billing Transfer Audit option is set to Yes on the Timesheet Audit form of Time Settings ( ). |
Transfer Project | If the transaction is a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred. |
Transfer Reason | If the transaction is a billing labor transfer, this column displays the reason for the transfer that was entered in Interactive Billing or Interactive Approvals. This column is only available if the Enable Billing Transfer Audit option is set to Yes on the Timesheet Audit form of Time Settings ( ). |