Whitepass

Overview

Whitepass had a non-standard setup with a non-importable payroll report in the Timekeeping report file link prior to February 2025.

Jan 2025 - Whitepass requested a new custom payroll export report that would allow them to upload the file to their accounting system Sage

Feb 2025 - flaik delivered the new export file under the Timekeeping report link and moved the previous Payroll report to the Wages report link on the Timekeeping page in flaik.

Unique Requirements

• Whitepass required a different business structure for incentive pay than for the paid activity, the workaround is to pull both the Paycode and Business Structure from the Paycode table for the incentive

• If there is not an overriding Cost Center on the Incentive it will revert to using the Business Structure from the Paid Activity as is standard behavior.

Summary

Payroll System	Sage 100
Files Required	Timekeeping report	Sage 100 export - Combined incentive and wage paylines
	Wages report	Legacy export file in use prior to feb 2025
Header Row	Yes
FTP Available?	No
Number of Days to include	14

Payroll Export Fields

Type	vendor name	flaik field name
Wage Pay	Earning Code	Pay Code
Wage Pay	Dept Code	Business Structure
Incentive Pay	Earning Code	Pay Code -> Paycode Type
Incentive Pay	Dept Code	Pay Code -> Cost Center

File Format - Timekeeping report

Wage and Inventive paylines will be combined into the Timekeeping report file.

WAGE PAY LINE
Vendor Name	flaik field/comments	SAMPLE
Emp#	Payroll ID	12345678
Earning Code	Pay Code	1
Dept Code	Business Structure	60
Reg Hours	Total Hours Worked	103.5
OT Hours
Tips Earned
Flat Rates

INCENTIVE PAY LINE
Vendor Name	flaik field/comments	SAMPLE
Emp#	Payroll ID	12345678
Earning Code	Pay CodPay Code -> Paycode Type	IR
Dept Code	Pay Code -> Cost Center	63
Reg Hours
OT Hours
Tips Earned
Flat Rates	Total Incentive Pay	20