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:
  • B: Billable: The transaction is released and available for billing to the client.
  • D: To Be Deleted: The transaction is marked for deletion.
  • F: Final Billed: The transaction has been billed to the client.
  • H: Held: The transaction is being held temporarily to prevent billing to the client.
  • M: Modified: The transaction has been modified in some way from its original form.
  • N: Not Billable: The transaction is not billable.
  • O: Deleted: The transaction was marked for deletion, included in a billing run, and deleted.
  • R: Partial Hold/Released: Part of the transaction has been held or released.
  • T: Transferred: The transaction was moved from one project, phase, or task to another.
  • W: To Be Written Off: The transaction has been written off, but the invoice has not been posted.
  • X: Written Off: The transaction has been written off, and the invoice has been posted.
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 (Settings > Accounting > Time Analysis) and Absence Accrual form (Settings > Accounting > Absence Accrual). 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 Transaction Center > Posting Review 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 (Settings > Time > Timesheet Audit).
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 (Settings > Time > Timesheet Audit).
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 Settings > Accounting > Labor Options.
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 Settings > Accounting > Labor Options.
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 (Settings > Time > Timesheet Audit).

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 (Settings > Time > Timesheet Audit).