Use the Payroll Formula Builder to modify existing “general” withholdings or to create new ones from scratch for things like health insurance, employee child care, retirement plans or local taxes. Most often you’ll work with Procare Technical Support to determine the formulas most appropriate for your situation.
Payroll formulas are written using a set of code based functions. Learning to write formulas is comparable to learning a computer scripting language. Some functions are relatively simple to use while others can be complex. This article describes the “functions” used to create formulas and is intended for persons with strong computer and scripting skills.
Nearly all the functions used to create Billing Formulas (for Family Accounting) may also be used for Payroll Formulas. Those are not repeated here. See: Billing Formula Builder for the complete list.
Note: Billing functions that may not be used for payroll include : Attend, Sched, OTime, Loop and Print.
Payroll Specific Functions
Following is a list of additional functions only available for use with Payroll Formulas.
Amount withheld for the pay period where X is a payroll group name, like fedinctx (federal income tax), fedmc (federal – medicare), or gainctx (Georgia income tax). Returns the amount withheld for the current pay period. Example: Fun[fedinctx].
Click the Fun drop down menu for a complete list and use the Edit Fun button to change sample values for testing purposes.
Amount for the year where X is a payroll group name, like gross (gross pay), fedinctx (federal income tax), fedmc (federal – medicare), or gainctx (Georgia income tax). Returns the amount for the current year. Example: YTD[gross].
Click the YTD drop down menu for a complete list and use the Edit YTD button to change sample values for testing purposes.
Returns gross pay for the current pay period. Adjust the sample value for testing purposes using the Gross Pay box in the upper left.
Returns the number of pay periods in the year. Adjust the sample value for testing purposes using the Pay Periods box toward the upper left. Pay periods are set in Region & School Options.
(st) and (ot)
Returns the number of straight time (st) or overtime (ot) hours for the current pay period.
(futabase) and (futarate)
Returns the employee’s taxable wage base (futabase) and tax rate (futarate) for federal unemployment. At the time of publication employees do not pay FUTA so these numbers should typically return zero. See the article on FUTA and SUTA.
(sutabase) and (sutarate)
Returns the employee’s taxable wage base (sutabase) and tax rate (sutarate) for state unemployment. At the time of publication most states do not require employees to pay SUTA so these numbers should typically return zero. See the article on FUTA and SUTA.