Skip to main content

Pay whiz - Payroll CSV Export

K
Written by Kate Lewis

CareSmartz360 supports generation of Paywhiz-compatible payroll CSV export, allowing agencies to export payroll data in a format ready for direct upload into Paywhiz.

Following are the fields available in the file:

1. Key: This field is mapped the employee’s SSN.

2. PayItem: This field begins with E followed by earning code. Eg: EREG

The Earning Codes are as follows:

· Regular: REG

· Overtime: OT

· Holiday: HOL

· Expenses: EXP,

· Mileage: MIL

· Double OT: DOT

· Weekly OT:WOT

· Travel:TRV

3. Legal: This field mapping is not required.

4. PayGroup: This field mapping is not required.

5. Block: This field mapping is not required. As we are not to block payment for any employee.

6. Hours: This field displays the hourly units.

7. Dollars: We don't need to send values in Dollars if the hours are defined in column G (Hours) and vice- versa.

8. OverrideRate: This field displays the OT Rate (Incase of Overtime)/ Base rate (Reg)/Holiday Rate (incase of Holiday). (This would be inclusive of Multipliers when applicable)

9. LaborValue#: The field is mapped to the CS360 ClientId.

10. LaborDescription#: This field displays the Client’s Name (First Name Last Name)

11. OverridePremium: This field mapping is not required.

12. WeekNumber: This field mapping is not required.

13. OverrideBaseRate : This field mapping is not required.

14. ORWorkersCompCode : This field mapping is not required.

15. ORWorkersCompState : This field mapping is not required.

From your Finalized Payroll, make your selections for export. Click on the download button at the top right of the page. Scroll down to Paywhiz CSV Export.

Did this answer your question?