Standard Functions

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.

Fun[x]

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.

YTD[x]

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.

(gross)

Returns gross pay for the current pay period. Adjust the sample value for testing purposes using the Gross Pay box in the upper left.

(pp)

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.



tags: payroll formulas, withholding formulas, general withholding, payroll formula builder, payroll editor, edit withholding formulas