Columns for Labor Detail Report

You can select the columns to display on your report.

Contents

Field	Description
Billing Currency Code	This column displays the three-character code for the billing currency.
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.
Charge Type	This column displays one of the following charge types for the project: R: Regular projects are revenue-producing. Costs charged to regular projects include direct labor, direct expense, and reimbursable expense. Vantagepoint retains the detail for a regular project for the life of the project. H: Overhead projects are not revenue-producing. Costs charged to overhead projects include indirect labor and indirect expense. Vantagepoint distributes the total cost of these projects to regular projects during overhead allocation. Typical overhead projects can include General Overhead, Vacation, Sick Leave, Holiday, and Civic Duty. Vantagepoint resets job-to-date costs to zero for overhead projects when you initialize for a new fiscal year. P: Promotional projects track the cost to acquire a job. If you obtain the contract, you can create a new regular project and transfer the detail to it to be billed or tracked. A promotional project is similar to an overhead project. However, Vantagepoint does not zero out job-to-date costs at the start of each fiscal year for promotional projects.
Employee Organization	This column displays the organization to which the employee is assigned. If your firm is not using organizations, this column is not available.
Fiscal Period	This column displays the accounting period for the transaction.
Functional Currency Code	This column displays the three-character code for the functional currency.
Labor Code	This column displays the labor code for the transaction.
Labor Type	This column displays the labor posting type (for example, Principal, Manager, or Employee). You use a labor posting type when you want to specify direct and indirect labor accounts. You define labor types in the Labor Types grid of the Labor Posting settings form in Settings > Accounting > Labor Posting.
Overtime Amount	This column displays the amount for standard overtime hours. Vantagepoint calculates overtime costs differently for hourly employees and salaried employees: For hourly employees, Vantagepoint calculates Overtime Amount as follows: Overtime Hours * Hourly labor cost rate * Overtime percentage For salaried employees, Vantagepoint calculates Overtime Amount as follows: Overtime Hours * Annualized hourly rate * Overtime percentage Vantagepoint calculates the annualized hourly rate as follows: Annual salary / (Hours per week * 52)
Overtime Hours	This column displays the number of standard overtime hours for which the employee was paid.
Overtime Percentage	This column displays the employee's overtime percentage that Vantagepoint uses to calculate the employee's overtime rate. Vantagepoint calculates the overtime rate as follows: Employee’s hourly rate * Employee's overtime percentage
Overtime Rate	This column displays the rate used to calculate the standard overtime amount. Vantagepoint calculates the overtime rate as follows: Employee’s hourly rate * Employee's overtime percentage
Phase	This column displays the phase number.
Posting Sequence	If you select Transaction Detail as a sorting/grouping option, 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. If you preview the report, you can click the link in this column for a transaction to drill down to the Posting Log report.
Project	This column displays the project number.
Project Currency Code	This column displays the three-character code for the project currency.
Rate	This column displays the employee's job cost rate. This is the rate at which Vantagepoint applies the employee’s hours as costs to a project.
Regular Amount	This column displays the amount for regular hours, calculated as follows: Regular hours x Labor cost rate
Regular Hours	This column displays the number of regular hours.
Revenue Type	This column displays the revenue type. The revenue type is a code to identify how Vantagepoint calculates revenue for the task, phase, or project. There are six standard revenue types: B: Job-to-date billing M: (Job-to-date direct labor * Multiplier) + Job-to-date reimbursable expenses @ cost rates N: No revenue generation P: Percent complete + Job-to-date reimbursable expenses @ cost rates R: Job-to-date receipts W: Job-to-date billing + Work-in-progress @ billing rates
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 overtime that is paid at a different rate than standard overtime. If you pay separately for secondary overtime, you must record those hours separately on the timesheet. This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Secondary Overtime Percentage	This column displays the secondary overtime percentage used to calculate the employee's secondary overtime rate, as follows: Employee’s hourly rate * Employee's secondary overtime percentage This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Secondary Overtime Rate	This column displays the rate used to calculate the secondary overtime amount, calculated as follows: Employee’s hourly rate * Employee's secondary overtime percentage This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Task	This column displays the task number.
Total Amount	For the labor detail lines, this column displays the total amount for regular and overtime labor: Regular Amount + Overtime Amount. For the expense detail lines, this column displays the total expense amount.
Total Hours	This column displays the total number of hours entered on the timesheet: Regular Hours + Total Overtime Hours.
Total Overtime Amount	This column displays the total amount for all overtime hours: Overtime Amount + Secondary Overtime Amount.
Total Overtime Hours	This column displays the number of overtime hours. This includes standard overtime hours and secondary overtime hours.
Traffic Live Project Name	If the project is linked to a job in TrafficLIVE, this column displays the name of the TrafficLIVE project to which the job belongs.
Transaction Date	This column displays the date on which the transaction was posted.
Transaction Type	This column displays one of the following types of transaction: TS: Timesheet transaction LA: Labor adjustment transaction
Transfer Category	For a labor adjustment, this column displays the labor category (such as Architect or Project Manager) from which the labor adjustment transaction was transferred.
Transfer Labor Code	For a labor adjustment, this column displays the labor code from which the labor adjustment transaction was transferred.
Transfer Phase	For a labor adjustment, this column displays the phase from which the labor adjustment transaction was transferred.
Transfer Project	If the transaction is a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred.
Transfer Task	For a labor adjustment, this column displays the task from which the labor adjustment transaction was transferred.