Columns for Payroll Export Report

You can select the columns to display on your report.

Contents

Field	Description
Address1-4	These columns display record's address information (street name and number, suite number, postal box number, and so on).
Allow Charge Labor Code	This Yes/No column indicates whether or not the employee can charge time to a labor code other than the default labor code.
Approved for Use in Accounting Applications	This Yes/No column indicates whether or not Vantagepoint Accounting users can open and review the employee record.
Available to CRM Users	This Yes/No column indicates whether or not the record is available for review by Customer Relationship Management (CRM) users.
Available to Accounting Users	This Yes/No column indicates whether or not the record is available for review by Accounting users.
Bank Code	This column displays the code/identifier for the bank involved in the transaction.
Check Date	This column displays the date on which the paycheck was processed.
Check Hours	This Yes/No column indicates whether or not Vantagepoint automatically checks the hours entered on the employee's timesheet and compares them to the expected hours per day.
Check Number	This column displays the number on the paycheck.
City	This column displays the city from the record's address.
Contribution Amount	This column displays the contribution amounts.
Country	This column displays the country from the record's address.
Default Labor Codes Level 1-5	These columns display the default values specified for the employee for labor code levels in the Employees hub. The column names depend on the structure of your labor codes. For example, if one level of your labor codes is Department, the column available for this report is Default Department.
Direct Deposit	This Yes/No column indicates whether or not the employee has a direct deposit account set up for paychecks.
Email	This column displays the record's email address.
Employee Number	This column displays the employee's identification number.
Expense Report Admin Edit	This Yes/No column indicates whether or not the employee can edit expense reports to which they have access.
Expense Report Admin Level	This column displays the expense report administrative level for the employee. Level What the Employee Can Do Staff The employee has access to expense reports, but cannot modify system-level settings, group-level settings, or options in Expense Report Settings. Group The employee has access to expense report settings that are related to their group. The employee can: View expense report administrator settings. Review and change the status of expense reports for employees in their group. Change the passwords of employees in their group. System The employee has access to all options in Expense Report Settings. The employee can do the following: Define expense report categories. Establish employee expense report groups. Set employee access to expense reports. Enable passwords for expense reports. Set expense report options. Monitor and change the status of expense reports. At least one employee in your enterprise must have system-level access.
Expense Report Group	This column displays the expense report group for which this employee has access to expense reports.
Fax	This column displays the fax number for the record.
First Name	This column displays the record's first name.
Fiscal Period	This column displays the accounting period in which the transaction was posted.
Full Name	This column displays the record's full name: Prefix, First Name, Middle Name, Last Name, Suffix.
Gross Amount	This column displays the employee's gross pay amount.
Hire Amount	This column displays the amount for which the employee was hired.
Home Phone	This column displays the record's home telephone number.
Hours Per Day	This column displays the number of hours per day that the employee is generally expected to work.
Is Vendor	This Yes/No column indicates whether or not the firm record is classified as a vendor in terms of projects. Firms are classified as vendors based on selections in the Firms hub.
Job Cost Ovt Pct	This column displays the percentage of the employee's hourly wage that is applied as costs to projects when the employee works standard overtime hours.
Job Cost Ovt-2 Pct	This column displays the percentage of the employee's hourly wage that is applied as costs to projects when the employee works special overtime hours. This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Job Cost Rate	This column displays the rate at which Vantagepoint applies the employee's hours as costs to projects. You specify the employee job cost rate on the Accounting tab of the Employees hub.
Job Cost Type	This column displays the employee's job cost type: Hourly or Salary. Vantagepoint uses the job cost type when it calculates the employee’s job cost rate for hours charged to a project.
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.
Last Name	This column displays the record's last name.
Memo	This column displays the text entered in the Notes field in the hub. You can see the contents of this column only if you have the proper security access.
Middle Name	This column displays the record's middle name or initial.
Mobile Phone	This column displays the record's cellular phone number.
Net Amount	This column displays the employee's net pay amount: Gross Amount - Withholding Amount.
Organization	If your enterprise uses organizations, this column displays the code for the organization that is associated with the record.
Other Pay	This column displays the amount of other pay the employee received. "Other pay" supplements the base pay with an amount that does not vary from period to period. For example, other pay may be a living allowance or hazardous duty pay. You can report on as many as 5 types of "other" pay.
Overtime Hours	This column displays the number of standard overtime hours for which the employee was paid.
Overtime Hours Override	If you overrode the employee's overtime hours during payroll processing, this column displays the override hours.
Overtime Pay	This column displays the amount that the employee was paid for overtime hours, calculated 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.)
Pay OVT Pct	This column displays the percentage applied to the employee's payroll rate to calculate standard overtime wages.
Pay OVT - 2 Pct	This column displays the percentage to apply to the employee's payroll rate to calculate special overtime wages. This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Pay Rate	For salaried employees, this column displays the employee's actual pay amount for each payroll period. For hourly employees, it displays their hourly pay rate.
Pay Type	This column displays the employee's pay type: Hourly or Salary.
Payroll Type	This column displays the payroll type: Regular, Adjustments, or Bonus.
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.
Prefix	This column displays the prefix or salutation used with the individual's name (for example, Mr., Mrs., or Ms.).
Provisional Bill Ovt Pct	This column displays the percentage used to calculate labor charges at billing rates for unposted overtime hours for the employee.
Provisional Bill Ovt-2 Pct	This column displays the percentage used to calculate labor charges at billing rates for unposted special overtime hours for the employee. This column is available only if you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Provisional Billing Rate	This column displays the billing rate used to calculate labor charges at billing for unposted timesheet entries for the employee.
Provisional Cost Ovt Pct	This column displays the percentage used to calculate labor charges at cost rates for unposted overtime hours for the employee. This column is only available if your security role has access to employee cost rates.
Provisional Cost Ovt-2 Pct	This column displays the percentage used to calculate labor charges at cost rates for unposted special overtime hours for the employee. This column is available only if your security role has access to employee cost rates and you set Enable Secondary Overtime to Yes in Settings > Accounting > Labor Options.
Provisional Cost Rate	This column displays the cost rate used to calculate labor charges at cost for unposted timesheet entries for the employee. This column is only available if your security role has access to employee cost rates.
Raise Date	This column displays the date of the employee's last pay increase.
Regular Hours	This column displays the number of regular hours.
Regular Hours Override	If you overrode the employee's regular hours during payroll processing, this column displays the override hours.
Regular Pay	This column displays the amount that the employee was paid for regular hours.
Social Security Number	This column displays the person's Social Security number.
Special Overtime Hours	This column displays the number of secondary overtime hours. Secondary overtime is overtime for which the cost amount is calculated at a different rate than standard overtime.
Special Overtime Hours Override	If you overrode the employee's special overtime hours during payroll processing, this column displays the override hours.
Special Ovt Pay	This column displays the amount the employee was paid for special overtime hours.
State	This column displays the two-character abbreviation for the state from the record's address.
Status	This column displays the status of the employee: Active, Inactive, or Terminated.
Suffix	This column displays the suffix used with the individual's name (for example, Jr., Sr., or Esq.)
Supervisor	This column displays the name of the supervisor for the record.
Supervisor Number	This column displays the employee number of the employee's supervisor.
Target Ratio	This column displays the percentage of the employee's time that you expect to be charged to regular projects (projects that produce revenue).
Termination Date	If the employee is terminated, this column displays the date on which the employee last worked for your firm.
Timesheet Admin Edit	This Yes/No column indicates whether or not the employee can edit timesheets to which they have access.
Timesheet Admin Level	This column displays the timesheet administrative level for the employee. The following are the available levels: Staff: The employee has access to timesheets for all employees at the staff level. Group: The employee has access to timesheets for all employees within a specific group. System: The employee has access to timesheets for all groups and employees. At least one employee in your firm must have system-level access.
Timesheet Group	This column displays the timesheet group for which this employee has access to timesheets.
Title	This column displays the person's job title or job function.
Total Pay Hours	This column displays the total hours for which the employee was paid. Total Pay Hours includes regular hours, overtime, hours, and special overtime hours.
Use Total Hrs as Std	This Yes/No column indicates how Vantagepoint calculates and displays standard hours or amounts for employee on the Time Analysis report: Y: Yes indicates that Vantagepoint uses the total hours worked to determine the standard current, month-to-date (MTD), and year-to-date (YTD) hours or amounts. N: No indicates that Vantagepoint calculates the standard hours or amounts using a formula specified in the employee record.
Vendor Name	If the employee is a vendor or consultant, this column displays the vendor name.
Vendor Number	If the employee is a vendor or consultant, this column displays the vendor number assigned to the employee.
W2 Quarter	This column displays the W2 quarter during which the payroll run was posted.
W2 Year	This column displays the W2 year during which the payroll run was posted.
Withholding Amount	This column displays the total amount of withholding for the employee.
Withholding Code Method	This column displays the method used to calculate withholding for this employee: Amount: Vantagepoint withheld a fixed amount. That amount is displayed in the Amount/Percent column. System: Vantagepoint calculated the withholding using the default method specified in Settings. Percentage: Vantagepoint withheld a specified percentage of the employee's pay. That percentage is displayed in the Amount/Percent column.
Work Phone	This column displays the record's work or office related phone number.
Years With Other Firms	This column displays the number of years that the employee worked for other firms.
Zip	This columns displays the ZIP code from the record's address.