PAY: Check Processing Wizard

Overview

You can use the Paycheck Wizard to complete various tasks pertaining to pay check processing. There are five options available using the Wizard:

Use the Create a New Batch option to process automatic checks, single entry checks, handwritten checks, to void checks and make adjustments.
Use the Edit an Existing Batch option to edit existing batches.
Use the Delete an Existing Batch option to delete an unposted batch. To unpost a posted payroll batch, use the Journal Update Log.
Use the Show All Batches option to display detailed batch information for all processed batches.
Once you select a batch, you may drill down to the Supplemental Information screen for the batch by clicking the Detail button. When a Payroll batch has been updated to the General Ledger, it will be annotated in the Payroll Check Batch's Status History area.
Use the Labor Accrual option to expense labor into the fiscal period in which hours were worked. For detailed information see Accruing Labor.

Within each process there are several ways of completing the wizard. Based upon the information entered, the Paycheck Wizard prompts you through the process.

Note: When processing Compensation-Only paychecks: To determine proper withholding taxes, WinTeam looks at the Payroll Tax Codes on and Employee's Primary Job site, which it considers as the employee's work site, if only Other Compensations Payment(s) and no Wages are being paid on a check.

Note on Hourly Labor $ and Avg Labor Rate on Labor Distribution Report:

If a user believes the Hourly Labor $ and or Avg Labor Rate on the labor accrual distribution journal are over-stated, this could be a result of salary hours included in the Hourly figure. The Labor figure will always be correct. Salary hours included on a line with hours and hourly labor could throw off the Hourly Labor $ and subsequently the Average Labor Rate. "Backing out" salary dollars from the Hourly Labor $ figure is not permitted as this information must be retained for the Labor Distribution report.

Labor can be accrued based on Timekeeping, Budgets or posted Payroll Batches.

Custom Settings

Section

Item

Value

Purpose

ADP

Export401KInfo

Yes

This setting was created for a particular client who runs the ADP Windows outsource payroll option. Added new fields to the Employees Only export. The new fields are: 401K amt, 401k code, and 401k factor.

ADP

IncludeRehireDate

Yes

This setting adds a Rehire Date column to the end of the ADP - Windows, Employee Export file.

ADP

IncludeWorkState

Yes

This setting adds a Temp Recip State (State Worked) column to the ADP - Windows, Timekeeping Export file.

ADP

SpecialFileName

True

This setting reverses the ADP outsource Name from being PR<compCode>EMP or PR<compcode>EPI to being EMP<compcode>PR and EPI<compcode>PR. Client will save the file, overwriting the PR at the end of the file to the location number that they are submitting.

ADP

UsePayExpert

Yes

Use this setting if you are using ADP's new Pay Export. It changes the following column headings to come through properly when the export file is created within WinTeam. The column heading changes are as follows:

Old Heading	New Heading
Federal Tax Modification Amount	Federal Extra Tax $
Hire Status	Employee Status

This setting was created for client for ADP Pay Employees Window data export. This looks at employee master file custom field #20 which is numeric and custom setting: ADP, UsePayExpert, Yes.

ADP

UseTempCost

Yes

This setting was created to change a column heading within the export file for the hours export. The column header will change from being the normal column heading of “Temp Dept” to “Temp Cost Number”. This is necessary only when there are multiple cost centers that an employee’s wages are being charged to.

CPWIZ

ADPExport

Yes

This setting is used to add special codes for the exporting of timekeeping to ADP using the ADP Windows outsource option for Training and Worked Holiday. The following Hours Type description must start with:

Hours Description must start with	ADP Code Exported
Training	T
Worked Hol	W
Adjustment	A (this one already existed)

Change made to the Ceridian Outsource Payroll option so that if the employee number is less than 5-digits, 0's will precede the employee number.

Also changed so that the following special pay types will be brought through if "Training" is the beginning of the Hours Type description.

Hours Type starts with	Pay Type in file will be
Training	1T for regular training
5T for OT training
6T for double-time training

CPWIZ

CombineHours

True

This setting combines regular, overtime, and double-time hours in the export file, rather than sending each hours type separately.

CPWIZ

DoyonExport

Yes

This setting changes the ADP Code Exported for Sick Hours. In order to have Sick Hours come through as a Code E (this is not "normal" since most ADP export formats call for Sick hours to have a Code S), you will need to add this setting.

Hours Description must start with	ADP Code Exported
Sick	E

CPWIZ

ExportCode

Yes

This setting will have each Timekeeping Hours Type export with its own export code in the file. With this setting, the system will append an "e" and the first 2 characters from the Notes field of the Hours Type as the export code for the file.

CPWIZ

ExportWorkDate

True

This setting splits out by date. (Normally, there are no dates in the export file.)

CPWIZ

ExportWorkDate

This setting will output the actual Work Date for each timekeeping record into a specific outsource payroll file. Prior to this release, their outsource payroll option was grouping all hours by rate and by Month End Date so there was no daily breakdown. This setting will show the daily breakdown for employees that belong to Company #1 (value in setting represents Company #) and continue to the month end date for the other companies employees. If you need to enter more than one company number, separate the values with commas, not spaces.

CPWIZ

IncludePayRate

Yes

This setting includes Pay Rate when using the Outsource PR for the RapidPC payroll option (PAYCHEX/RapidPC).

CPWIZ

UseDiffNumber

Yes

Check Processing Wizard - RapidPC/Paychex Outsource Export file
Custom Field #20 from the Employee Master File (Custom Field tab) will be used as the Employee Number.

CPWIZ

UseJobLocation

Yes

This setting makes sure Division comes through in the file. WinTeam pulls the first 3 letters of the Job's Location Description to be used for Division.

CPWIZ

UseNonStandardFormat

True

This setting will create the Ceridian Payroll Export file to be in a special format, not the standard Ceridian format. The Job number (old department number) was moved to the end of the record into the Charge Acct field. And in it’s place we are now using the Numeric Custom Field #1 in the Employee Master File as the Department Number as well as putting this same number into the Charge Department # field.

CPWIZ

UsePayPeriodDates

Yes

This setting limits the Employee records that are exported when using the Outsource Payroll option - ADP Windows, and exporting Employee records (employees Only check box).

The employee record will export if:
the Date Changed of the record is not more than 90 days old from the Pay Period Ending Date;
If the record has a Date Hired within the per period beginning and ending being exported (the Pay Period dates entered when creating the ADP outsource file);
OR if the Status Info record or Pay Info record has an effective date within the pay period beginning and ending date range (Pay Period dates selected when creating the ADP Outsource file).

Payroll

AutoBatchLockCompany

Yes

Check Processing Wizard
This setting prevents a User from changing the Company # of a check in an Auto Batch. Unless this setting is in place, a User can change the Company Number of a pay check record provided they have the proper security to do so.