Registry Compute Payroll (sys-compute-payroll)


This registry entry controls how various items are handled in the Compute Payroll function.

Testing Your Registry Entries
The system does not verify the validity of registry entries. Be sure to test your registry entries after completing them to verify that they are functioning correctly.

Setting Values are Uppercase-Lowercase Sensitive:
The Setting Value is case-sensitive: be sure that you enter the value exactly as specified in the documentation. If the documentation specifies a value of true, do NOT enter True or TRUE.

Additional Registries:

See Compute Overtime - No Checks Printed or Posted for details/additional registries for computing overtime when checks will not be generated.

Important Fields

Id: sys-compute-payroll

See the Standard Registry section in Registry Viewer for additional Registry Id formats to allow entries for specific Users, Branches, Security, or User Groups to override the main entry.

Taxable Fringes

This registry option should be implemented to enable taxable fringe benefits to be included as wages for the purpose of computing wage-based deductions.

Setting Key: PercentDeductionsIncludeTaxableFringes Setting Value: true

Registry to Specify Exceptions to Taxable Fringes

This release implements registry-controlled refinements for the Earnings record's Taxable flag. This lets you specify that tax for certain specified Authorities or Groups should NOT be assessed for a Taxable fringe. The User1 and User2 fields of the Earnings Record are used to specify which taxes to exclude. The following registries are required to enable this functionality.

Id: sys-compute-payroll

Setting Key:  FringeTaxExceptionUser1  Setting Value: TaxAuthorityId  

Setting Key:  FringeTaxExceptionUser2  Setting Value: TaxTableId

(Note: the Setting Values of TaxTableId or TaxAuthorityId can be used with either of the above setting keys.)

If either or both of these registries are enabled, Compute Payroll checks the User 1 and/or User 2 fields of the Earnings Record to see if there are any Taxable Fringes should NOT be taxed by the listed Tax Authorities or Tax Tables. Note that this ONLY works for Tax Tables specified as 'Always Withhold' on the Employee's taxes tab.

Earnings Record:  Earnings User1 - Earnings User2
These fields may be used to specify a list of Tax Groups or Tax Authorities for which tax should NOT be assessed if enabled via the above registry setting:

If the Earning Record is of Type Fringe, with the Taxable box checked AND  
The FringeTaxExceptionsUser1 or FringeTaxExceptionsUser2 registries are set AND
The Tax Table is specified as 'Always Withhold' on the Employee's taxes tab.

Section 125 Deduction / 401(k) Handling

When implemented, this registry option results in the employee's gross wages being reduced by the amount of any Section 125 deductions before applying the 401k deduction percentage. This registry entry is recommended for firms using the Report PR 401(k) Reporting for John Hancock; see Registry Entry PR 401(k) for additional registry settings.

Setting Key: 401KGrossLess125Deductions Setting Value: true

This logic is also applied to the calculation of the Match column on the 401(k) Report.

Employee and Group Pay Rate Handling

In versions prior to 6.1, the employee pay rate was replaced by the earnings group rate when an earnings group was designated.  A change was made to accommodate the situation where an employee could have a base rate and the earnings group could be used to add a premium ON TOP of that base employee rate.  This registry option should be implemented in order to implement this ‘premium’ where the earnings group is added to the base rate. By default, the earnings group, if present, will override the base rate.

Setting Key: CombineEmployeeAndGroupPayRates Setting Value: true

NOTE:  the combined rates concept applies to the hourly job cost rate as well as the pay rate.

Wage Expenses from Cost Category

This entry implements the optional use of the Job Cost Category GL Expense Account as a Wage Expense Account for Payroll purposes.

Setting Key: WageExpenseAccountFromCostCategory Setting Value: true

Ignore GL Entity for PR Tax Liabilities

If this option is implemented, the GL Entity (typically specified in the Tax Authority record) will be ignored for PR Tax liabilities written when the Compute Payroll function is run. Note that the GL Entity will still be written to the PR Tax Expense entry when payroll is computed.

Setting Key: PRTaxLiabilityNoEntity Setting Value: true

JCH Descriptions

This release supports is an enhancement to the concept of posting allocated P/R taxes, fringes, etc. at the time check posting with the addition to the JobCostPR Checks box to the Earnings viewer.  Prior to this change, the resulting JCH entries had no description.  This change allows specification of descriptions for the different types allocated P/R expenses.

Setting Key: AllocatedFringesDescription   Setting Value: description for JCH
Setting Key: AllocatedTaxesDescription   Setting Value: description for JC
Setting Key: AllocatedWorkersCompDescription  Setting Value: description for JCH
Setting Key: AllocatedLiabilityInsuranceDescription Setting Value: description for JCH

The AllocatedTaxesDescription also supports a replacement token that can include the Tax Table Id in the description.  An example is ... PR Taxes ^TableId^

Note that the ^TableId^ token is case-sensitive.

Specify a Payroll Expense Account Override

This option allows the allocated PR expenses to be associated with original JCH cost categories but using a different GL Expense Debit account. This overrides the Cost Category G/L Expense Account found in the Job Cost Category. This registry entry should be used with caution as it lumps all PR Expenses into one GL Account.

Setting Key: PRExpenseAccount Setting Value: Gl Account Id


Controlling Negative Accrual of PTO 

Setting Key: PTOAccruedHoursExceeded  Setting Value: option  (default is warning)
Setting Key:
PTOAccruedEarningsExceeded  Setting Value: option (default is ignore)

These options enable you to control how that system will handle it when Compute Payroll encounters a negative PTO situation either in terms of Hours or Dollars Exceeded.

The error option will result in an error being written to payroll history; you will not be able to print a pay check (or direct deposit advice) for that employee until the problem is corrected and Compute Payroll rerun.

The warning option will result in a warning being written to payroll history that will appear on the Payroll Worksheet, but will not prevent the employee from being paid.

The ignore option enables the payroll to be paid, and does not record any message of this situation to payroll history.

Related Registry Option - Paid Time Off in Dollars rather than Hours

Id: sys-report-rprchck
Setting Key: ShowPTOAvailableAs Setting Value: hours or dollars  (default = hours)

This registry setting changes the ‘PTO Available’ that appears on the Recap portion of the check stub from hours to a dollar amount for PTO Pay Types whose Check Label field includes a dollar sign. 

Setting Up the Pay Type to work with the above registry option

Pay Type:

New Functionality: Check Label
If the sys-report-rprchck registry ShowPTOAvailableAs=dollars is implemented, the Check Label field MUST include a dollar sign ($) to define which PTO Pay Types will be displayed as a dollar amount on the ‘PTO Available’ section of the Recap portion of the check stub.  


Suppose that you want your employee’s available sick time to appear as dollars, management sick time to appear as hours, and all vacation time to appear as hours.

Emp. Sick Time Pay Type Check Label: Sick $

Mgr. Sick Time Pay Type Check Label: Sick Hours

Vacation Time Pay Type Check Label: Vac. Hours

GL Interface for Accrued Vacation / Holiday / Sick / Other Pay

The option to compute accrued vacation as a percentage of wages was implemented version 7.3. the Employee Paid Time Off tab is used to define the applicable Pay Types/Percent to be accrued. This release extends that work to include a registry-enabled GL interface for accrued pay (typically Vacation in Canada). The following options may be enabled to generate the appropriate GL entries when Compute Payroll is run.

Registry Id: sys-compute-payroll

Note: The GL account in the pay type record(s) for Vacation pay should be set to debit the Accrual Liability account when Vacation hours are used.

Setting Key: PostVacationEarningsAccruedToGL Setting Value: true

Setting Key: AccruedVacationExpenseAccount Setting Value: glaccountid

Setting Key: AccruedVacationAccrualAccount  Setting Value: glaccountid

The functionality for accrued vacation pay is also available for Sick, Holiday and Other Pay Types should it be needed.

Note: The GL account in the pay type records for Sick,Holiday & Other should be set to debit the Accrual Liability accounts when Sick,Holiday & Other hours are used.

Setting Key: PostSickEarningsAccruedToGL Setting Value: true

Setting Key: AccruedSickExpenseAccount Setting Value: glaccountid

Setting Key: AccruedSickAccrualAccount   Setting Value: glaccountid


Setting Key: PostHolidayEarningsAccruedToGL Setting Value: true

Setting Key: AccruedHolidayExpenseAccount Setting Value: glaccountid

Setting Key: AccruedHolidayAccrualAccount  Setting Value: glaccountid

Setting Key: PostOtherEarningsAccruedToGL Setting Value: true

Setting Key: AccruedOtherExpenseAccount Setting Value: glaccountid

Setting Key: AccruedOtherAccrualAccount  Setting Value: glaccountid

Registry Entries for Compute Payroll to Support Compute Overtime

See Registry Start Compute Overtime  for additional required registry settings.

Id: sys-compute-payroll

Setting Key:  AllocateOTPremium    Setting Value: true  

This entry is required to enable distribution of the OT Premium to the various non-overhead jobs when Compute Payroll is run.

Setting Key: AllocatedOTPremiumDescription  Setting Value: Allocated OT Premium

This registry specifies the description used by the system when the overhead premium is distributed by Compute Payroll.