Time clock systems by TimeIPS
Call Now! 316-264-1600
Knowledge Base Search:  
Main Menu
· Home

· Table of Contents
· Article Index

· Downloads
· New Features
· News
· Web Links

TimeIPS Knowledge Base

Table of Contents: Article IndexPrintable Version

Applies to versions: 2.4, 2.5

QuickBooks Pay Item Expressions

This article explains the ability to customize the payroll items sent to QuickBooks 

Purpose of Expressions

When TimeIPS exports payroll data to QuickBooks each piece of time is associated with a payroll item. This is often something like "Regular" for standard time. With expressions you can apply custom logic when determining the payroll item.

Defining Payroll Items With Expressions

To use custom logic you must define the expression in the "Pay Type" field for that payroll item. Expressions must start with an equals sign '='. They provide a single line of code that is evaluated and returns the payroll item. When using expressions, leave the Separator, Appended Field and Default Value blank.

Supported Functions

QuickBooks payroll item expressions utilize the same expression parser as Custom Reports. As such the same functions are available. The list of functions is available at this article.

Available Variables

The following information is available 

client_name_in The name of the clock where this employee clocked in, if it exists
client_name_out The name of the clock where the employee clocked out if it exists
clock_in_note The clock in note provided
clock_out_note The clock out note
code_name The code associated with the event, such as "standardtime" or "overtime"
payrollEventType The type of event such as "Standardtime" or "Overtime"
customer_name The name of any customer associated with a job
duration The duration of the payroll event in seconds
empNum The employee's alternate number
eventLogID The unique database ID of the clock event pair
isHourly 1 if the employee is hourly, 0 if they are not
job_altNum The alternate number on the job worked
job_category The name of the category on the job worked
job_code The code of the job worked
job_ctrlNum The control number of the job worked
job_glNum The G.L. number of the job worked
job_longname The full name of the job worked
job_rate The billing rate associated with the job worked
job_shortname The shortened display name of the job worked
job_subCode The subcode of the job worked
job_overrideHourlyRate The overriding hourly rate of the job worked
job_overrideDifferential The hourly differential of the job worked
job_overrideMultiplier The rate multiplier of the job worked
occurs A unix timestamp that marks the beginning of this payroll event
orgUnit The name of the employee's Organizational Unit
pay_per_hour The total pay per hour for the event including differentials and overtime
payRate The hourly rate for the event including differentials but no overtime
reg_hourly_rate The employee's normal hourly rate
base_rate The FLSA weekly base hourly rate
SSN The employee's social security number
lastFirstMid The employee's name in Last First Middle format.
firstMidLast The employee's name in First Middle Last format 
userName The employee's name in whatever format was selected in the QuickBooks preset
payroll_type_name The name of the employee's payroll type
usersID The unique database ID of the employee


  Example 1:  A pay type "Payroll Item for Unpaid OOTO:" should never be exported:

Set the expression to:  ="action_remove_this_row"

  Example 2: A pay type "Payroll Item for Holiday:" should be exported as "Holiday" on Monday-Friday, but "Weekend Holiday" on Saturday or Sunday:

Set the expression to: =if((utcdate("D",[adjTimeIn])="Sat" || utcdate("D",[adjTimeIn])="Sun"),"Weekend Holiday","Holiday")




Additional Available Variables For Piecework

The following additional information is available for piecework entries

piecework_name The name of the piecework
piecework_poNum The PO number of the piecework
piecework_glNum The GL number of the piecework
piecework_altNum The alternate number of the piecework
piecework_code The code of the piecework
piecework_subCode The subcode of the piecework
piecework_pieceworkCode The piecework code of the piecework
piecework_quantity The quantity of the piecework.  Note this is limited to 24 per Quickbooks.  If the quantity is larger, it will be split into multiple rows, with no more than 24 per row.
piecework_field-<your name>
The custom piecework field value. <your name> is the name of the piecework field.  If multiple fields are defined, all will be present.


  Example 1:  Piecework should be exported with the paycode "CustomerA" when the custom piecework field "Project" is set to "Project A".  If not, just use paycode "GeneralPiecework"

=if([piecework_field-Project]="Project A","CustomerA","GeneralPiecework")

©2004-2017 TimeIPS, Inc. All Rights Reserved - TimeIPS and the TimeIPS logo are registered trademarks of TimeIPS, Inc.
"Intelligent Personnel System" "Run your Business. We'll watch the clock." are trademarks of TimeIPS, Inc.
TimeIPS is protected by one or more patents. Patent No. US 7,114.684 B2.