Agency users can now download Gusto compatible payroll files from the finalized payroll batch screen. On a click of the Gusto icon, Gusto compatible payroll file would be made available to the users.
The following are the mapped fields in the CSV file:
Column A) Last_name
This is the last name of the caregiver.
Column B) First_name
This is the first name of the caregiver.
Column C) SSN
This denotes the last 4 digits of the caregiver’s SSN.
Column D) Title
The title field is mapped to the Role field in the Caregiver’s profile. In the case there is more than one role selected then only one role would be displayed in the file. The role would then be selected as the first option in alphabetical order.
Column E) Gusto_employee_id
The value updated in the field ‘Payroll File Number’ in the HR tab of the Caregiver’s profile is updated under this column in the CSV.
Column F) Regular_hours
The Regular hours serviced by the caregiver. (E.g. 4 Hours 30 Mins will be shown as 4.5)
Column G) Overtime_hours
The Overtime hours serviced by the caregiver.
Column H) Double_overtime_hours
These are the double overtime hours serviced by the caregiver.
In the file itself, you may see additional columns, they are not captured in Caresmartz360 and are simply part of the Gusto template. If you have questions about those fields, please refer to your contact at Gusto.
Column I) bonus : Not Captured
Column J) commission : Not Captured
Column K) paychex_tips: Not Captured
Column L) cash_tips: Not Captured
Column M) gross_earnings: Not Captured
Column N) custom_earning_draw: Not Captured
Column O) reimbursement : Not Captured
Column P) personal_note: Not Captured