Skip to main content

Paycor csv Export for Payroll

Important information for agencies using Paycor as their payroll processor

K
Written by Kate Lewis
Updated this week

A "Paycor CSV Export" option is available on the View Finalized Payroll screen.

In your Office Settings, under the Payroll tab, scroll down to PayCor Settings and enter your PayCor Client ID in the field. Click Save.

Once you have reviewed and finalized your payroll, select the items you would like to export. Then, you will see the option to download the correct csv file from download icon in the top right corner. Please ensure that you scroll down the list, as your screen resolution or magnification may hide the complete list.

Depending on your browser preferences and security, you may have to grant permission to download the file(s).

Each shift/schedule generates two rows: one "IN" and one "OUT". No overtime (OT) information is to be sent — Paycor handles OT calculations. Holiday multipliers are applied by Paycor, not included in the export.

There may be two exports, one for the payroll, and a second one for expenses and mileage. The payroll will be called Paycor_date, the mileage and expenses will be called PaycorPayItem_date. In both cases the date of the download is reflected in the file name.

The following fields are included in the Payroll file:

Field

Details

Action

Static value: "A"

ClientId

Paycor ID of the agency (added in Office Settings → Payroll Tab)

EmployeeNumber

Mapped to Caregiver’s Payroll File Number from caregiver's HR Tab

LastName

Caregiver's Last Name

PunchDate

Date of punch (format: yyyy:mm:dd)

PunchTime

- "8a" for 08:00 AM
- "8p" for 08:00 PM
- "8:45p" for 08:45 PM

Status

Static value: "WORK"

Activity

"IN" for clock-in, "OUT" for clock-out

DepartmentCode

Based on Employee Type:
2001 - Caregiver Employee
2002 - Caregiver Contractor
3001 - Registered Nurse Employee
4001 - Business Operations Employee

LaborCategory1LaborCode

Mapped to ClientID from client's profile

LaborCategory2LaborCode

Caregiver’s Service Rate (e.g., 25.00)

LaborCategory3LaborCode - LaborCategory6LaborCode

Optional (blank)

PunchNotes

Optional (blank)

An additional CSV will be generated for travel time, mileage, and expense reimbursements.

Exported file will be named: PaycorPayItem_yymmdd.csv

The following fields are included:

Field

Details

Action

Static value: "A"

ClientId

Paycor ID of the agency (from Office Settings → Payroll Tab)

EmployeeNumber

Mapped to Payroll File Number from caregiver’s HR Tab

LastName

Caregiver’s Last Name

Date

Date of service (format: yyyy:mm:dd)

Amount

Amount for each reimbursement (each reimbursement is sent separately, not accumulated)

Earning Code

Static value: "REIMB"

DepartmentCode

Mapped based on Employee Type (same as Paycor CSV)

LaborCategory1LaborCode

Mapped to ClientID from client profile

LaborCategory2LaborCode - LaborCategory6LaborCode

Optional (blank)

Notes

Optional (blank)


Did this answer your question?