Project Labor Export

Use the Project Labor Export report to download project labor data to a Microsoft Excel spreadsheet file or other file format. This report only includes project labor.

Contents

Column Description
Project This column displays the project identifier.
Phase This column displays the phase identifier.
Task This column displays the task identifier.
Project Name This column displays the project name.
Phase Name This column displays the phase name.
Task Name This column displays the task name.
Labor Code This column displays the labor code for which the employee entered hours.
Employee Number This column displays the employee ID number.
Employee Full Name This column displays the employee's last name, first name, and middle initial.
Transaction Date This column displays the date on which the transaction was posted. If the detail is from History Loading, the column displays the accounting period.
Comment This column displays timesheet comments.
Fiscal Period This column displays the accounting period in which the transaction was posted.
Posting Sequence This column displays the posting sequence number of the transaction. Vision 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 generate a numbered list of all of the postings for the current accounting period, click Transaction Center > Posting Review Report from the Vision Navigation menu.

Regular Hours This column displays the number of regular hours the employee entered for the task, phase, or project.
Overtime Hours This column displays the number of overtime hours the employee entered for the task, phase, or project.
Special Overtime Hours This column displays the number of special overtime hours the employee entered for the task, phase, or project.
Labor Bill Rate This column displays the billing rate that Vision applies to the employee's hours to calculate the billing amount.
Labor Cost Rate This column displays the cost rate that Vision applies to the employee's hours to calculate the cost amount.
Labor Cost Overtime Rate This column displays the cost rate that Vision applies to the employee's overtime hours to calculate the cost amount.
Labor Cost Special Overtime Rate This column displays the cost rate that Vision applies to the employee's special overtime hours to calculate the cost amount. Vision calculates the special overtime rate as follows: Employee's hourly rate x Employee's secondary overtime percentage.
Labor Bill Amount This column displays the billing amount for the employee's hours.
Labor Cost Amount This column displays the cost amount for regular hours for the task, phase, or project. Vision calculates this amount as follows: the regular hours worked multiplied by the labor cost rate.
Labor Cost Overtime Amount This column displays the cost amount for overtime hours for the task, phase, or project.

Vision calculates overtime costs as follows:

  • For hourly employees: Overtime hours x Hourly labor cost rate x Overtime percentage.

  • For salaried employees: Overtime hours x Annualized hourly rate x Overtime percentage. (Annualized hourly rate = Annual salary / Estimated annual regular hours. Estimated annual regular hours = Hours per week x 52.)

Labor Cost Special Overtime Amount This column displays the cost amount for special overtime hours for the task, phase, or project.
Labor Overtime Percent This column displays the percentage of the employee's hourly wage that is used to calculate overtime cost amounts.
Labor Special Overtime Percent This column displays the percentage of the employee's hourly wage that is used to calculate special overtime cost amounts.
Employee Organization If your firm uses organizations in Vision, this column displays the organization to which the employee is assigned.
Employee Type This column displays the employee type (for example, Principal, Manager, or Employee).
Labor Category This column displays the employee's labor category.
Transaction Type This column displays the two-letter abbreviation for the type of transaction.
Transfer Project If the transaction is a labor adjustment, this column displays the project from which the labor adjustment transaction was transferred.
Transfer Phase If the transaction is a labor adjustment, this column displays the phase from which the labor adjustment transaction was transferred.
Transfer Task If the transaction is a labor adjustment, this column displays the task from which the labor adjustment transaction was transferred.
Transfer Labor Code If the transaction is a labor adjustment, this column displays the labor code from which the labor adjustment transaction was transferred.
Billing Status This column displays the billing status of the labor hours. The following are the possible statuses:
  • 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 the charge type of the project.

The following are the available charge types:

  • Regular — Regular projects are projects that produce revenue. Costs charged to regular projects include direct labor, direct expense, and reimbursable expense. Detail is retained for the life of the project.
  • Overhead — Overhead projects do not produce revenue. Costs charged to overhead projects include indirect labor and indirect expense. The total cost of these projects is distributed to regular projects during overhead allocation. The following are typical overhead projects: General Overhead, Vacation, Sick Leave, Holiday, or Civic Duty. Costs for overhead projects are reset to zero when you initialize for a new fiscal year.

  • Promotional — Promotional projects track the cost of acquiring contracts. If you obtain the contract, you can create a regular project and transfer the detail to it to be billed or tracked. A promotional project is the same as an overhead project, except that Vision does not reset project costs to zero at the start of each fiscal year as it does for overhead projects.

SubLevel This column contains Y or N (Yes or No) to indicate whether or not the project, phase, or task is associated with sub-level billing terms.
Principal Name This column displays the name of the principal who is associated with the project.
Proj Manager Name This column displays the name of the project manager who is associated with the project.
Supervisor Name This column displays the name of the supervisor who is associated with the project.
Client Name This column displays the name of the client associated with the project.
Client Address If the client has more than one address, this column indicates which address is associated with the project. This column shows a description of the address, not the actual address.

<Default> indicates that the client's default address is associated with the project.

If you want to the report to include clients' full addresses, select the Client Address (concatenated) column.

Compensation This column displays the expected total compensation amount (direct labor + direct expense) for the task, phase, or project.
Fee Direct Labor This column displays the expected fee for direct labor for the task, phase, or project.
Fee Direct Expense This column displays the expected fee for direct expenses for the task, phase, or project.
Fee Direct Consultant This column displays the expected fee for direct consultant services for the task, phase, or project. This amount includes any markups on consultant professional services.
Reimbursable Allowance This column displays the expected total reimbursable allowance (reimbursable expenses + reimbursable consultant charges) for the task, phase, or project.
Fee Reimbursable Expense This column displays the expected reimbursable expenses for the task, phase, or project.
Fee Reimbursable Consultant This column displays the expected reimbursable consultant charges for the task, phase, or project.
Budgeted OH Rate This column displays the budgeted overhead rate for the project, phase, or task. Budgeted overhead rates are only used for regular projects (projects that produce revenue).

If you use the assignment method for overhead allocation, Vision uses the budgeted overhead rate for both budgeting and allocation. If you use another overhead allocation method, Vision only uses the budgeted overhead rate to calculate the overhead amount for the project budget.

Status This column displays the status of the project (for example, Active, Inactive, or Dormant).
Revenue Type This column displays the revenue type code for the task, phase, or project.

The revenue type code indicates the method Vision uses to calculate revenue:

  • B — Job-to-date billing

  • M — (Job-to-date direct Labor x 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 ( WIP) @ billing rates

Revenue Description This column displays the description of the revenue source (for example, JTD Billings, JTD Billings + WIP @ Billing, or (Pct Comp*Fee) + JTD Reimb Exp).
Multiplier/Amount This column displays the multiplier, percentage, or amount used to calculate revenue for this task, phase, or project.
Organization Code This column displays the code for the organization with which the project is associated.
Organization Name This column displays the name of the organization with which the project is associated.
Unit Table This column displays the default unit table used to bill unit charges for the project.
Start Date This column displays the start date of the project, phase, or task.
End Date This column displays the completion date for the project, phase, or task.
Overall Pct Complete This column displays the weighted average percent complete. This value is calculated as (All percents complete x Their budgets) divided by Total project budget.
Labor Pct Complete This column displays the estimated percent complete for labor on the project, phase, or task, based on the labor budget.
Expense Pct Complete This column displays the estimated percent complete for expenses other than labor on the project, phase, or task, based on the expense budget.
Bill by Default This column indicates whether or not Vision bills the client for certain expenses. Possible values are the following:
  • Yes — Vision always bills expenses to the client, whether or not Bill by default is selected for the associated category in Expense Category Configuration.

  • No — Vision never bills expenses to the client, whether or not Bill by default is selected for the associated category in Expense Category Configuration.

  • Category — Vision only bills expenses to the client if Bill by default is selected for the associated category in Expense Category Configuration.

Billable Message

This column indicates whether or not Vision displays an error message when a user charges an expense to this project in an expense report, and the category bill by default method and the project bill by default method are different. The following are the possible values:

  • No Message — Vision does not display a message.

  • Warning — Vision displays a warning message. However, the user can choose to continue with the transaction without resolving the difference.

  • Error — Vision displays an error message. The user cannot enter the expense for the project until the difference is resolved.

Budgeted Labor Code Validation This column displays the level of access users are allowed when they enter labor codes on their timesheets: None, Warning, or Error.
Budgeted Levels This column displays the labor code levels employees can use when they charge time to the project.
Cross Charge Method Cross charges enable you to transfer revenue and overhead charges from one organization to another when an employee from one organization in your company works on a project for another organization in your company.

This column displays the cross charge method for the project. The following are the available methods:

  • Global — Vision uses the cross charge method specified on the Cross Charge tab of Individual Organization setup.

  • Project — Vision uses the cross charge method specified for the project in Cross Charge Rate on the Accounting tab of Project Info Center.

  • None — Vision does not generate cross charges for the project.

Cross Charge Rate This column displays the markup rate used when transferring revenue back to an employee's organization or when transferring an employee's overhead charges to the organization associated with the project.
Description This column displays a description of the project.
Contact ID This column displays the identifier of the contact at the client.
Contact Name This column displays the name of the contact at the client.
Long Name This column displays the project's long name.

If no long name was entered for the project, this column displays the project's short name.

Client Address (concatenated)

This column displays the client's street address, city, state, and ZIP code, in a single column on the report.

Address 1

Address 2

Address 3

These columns display the client's street address information (street name and number, suite number, postal box number, and so on).
City This column displays the city from the client's address.
State This column displays the two-character abbreviation for the state from the client's address.
ZIP This column displays the ZIP code from the client's address.
Country This column displays the country from the client's address.
County This column displays the county in which the client is located.
Federal Project This column contains Y or N (Yes or No) to indicate whether or not the project is for the federal government.
Project Type This column displays the type of project (for example, Educational, Commercial, or Medical).
Responsibility This column displays the level of responsibility your firm has for the project (for example, Prime, Joint Venture, or Consultant).
Referable This column contains Y or N (Yes or No) to indicate whether or not the project can be used as a reference when talking with potential clients.
Estimated Completion This column displays the date on which the project is or was scheduled to be completed.
Actual Completion For a completed project, this column displays the date on which the project was finished.
Contract Date This column displays the date on which the contract was awarded to your firm.
Bid Date This column displays the date on which your firm first bid on the project.
Completion Comment This column displays comments about the project's completion.
Firm Cost This column displays the portion of the project cost for which your firm is responsible.
Firm Cost Comment This column displays comments related to the portion of the project cost for which your firm is responsible.
Total Project Cost This column displays the total cost of the project.

This field is also used in the SF255 Item 8e, which asks for "total construction cost of completed projected (or, where no construction was involved, the approximate cost of your work)."

Total Project Cost Comment This column displays comments related to the total cost of the project.
Opportunity If the project record was created from an existing opportunity record, this column displays the number of the opportunity record.
Client Confidential This column contains Y or N (Yes or No) to indicate whether or not the client's name is confidential.

If the client firm's name is confidential, it is excluded from all proposals. When you include the project in a proposal, an alias that you specify is substituted for the client name.

Client Alias If the client's name is confidential, this column displays the alternate name that is used to refer to that client in proposals.
Available to CRM Users This column contains Y or N (Yes or No) to indicate whether or not Vision Customer Relationship Management (CRM) users can open and review the project record.
Available to Accounting Users This column contains Y or N (Yes or No) to indicate whether or not Vision Accounting users can open and review the project record.
Available for use in accounting applications This column contains Y or N (Yes or No) to indicate whether or not the project record is approved for use when processing accounting transactions.
Billing Client This column displays the client to be billed for the project.
Billing Contact This column displays the billing contact at the client.
Billing Address (concatenated) This column displays the complete billing address for the client firm (street address, city, state, and ZIP code), in a single column on the report.
Client Billing Address If the client has more than one address, this column indicates the address to which invoices for project are sent. This column shows a description of the address, not the actual address.

<Default> indicates that the client's default address is the billing address.

Phone This column displays the phone number for the project location.
Fax This column displays the fax number at the project location.
EMail This column displays the contact's email address.
Proposal Project This column displays the promotional project linked to the project record.
Cost Rate Method If you are using Vision Payroll and selected Enable cost rate tables in Accounting Configuration, this column displays the cost rate method.
Cost Rate Table If you are using Vision Payroll and selected Enable cost rate tables in Accounting Configuration, this column displays the cost rate table. This column is blank if Cost Rate Method contains From Employee Cost Rate.
Pay Rate Method If you are using Vision Payroll and selected Enable payrate tables for overriding payrate from Employee Info Center in Payroll Configuration, this column displays the pay rate method for the project.
Pay Rate Table If you are using Vision Payroll and selected Enable payrate tables for overriding payrate from Employee Info Center in Payroll Configuration, this column displays the pay rate table. This column is blank if Pay Rate Method contains From Employee Pay Rate.
Locale If your firm is using Vision Payroll, this column displays the state for payroll taxes. This locale is specified in Payroll Tax Locale in the Projects Info Center.