Skip to main content

Payroll - Standard Export Files

Understand the standard exports offered in Caresmartz360

K
Written by Kate Lewis
Updated today

CareSmartz360 provides a set of standard payroll export files designed to support commonly used payroll providers. These exports allow agencies to generate payroll-ready data from CareSmartz360 and upload it directly into their payroll system.

n.b. this is for export files only. Direct API Integrations, such as QuickBooks, Paychex Flex, and Viventium remain separate integrations.

This article outlines:

  • The payroll providers we support with existing standard export files

  • What to expect from these exports

  • How to handle agency-specific payroll requirements


Supported Payroll Providers

CareSmartz360 currently provides standard payroll export files compatible with the following payroll systems:

Each export file follows the general formatting and data requirements expected by the corresponding payroll provider.

⚠️ These are the standard files we provide out of the box. They are not custom-built per agency.


How Payroll Exports Work in CareSmartz360

Payroll export files are generated from approved and finalized time data in CareSmartz360. Depending on your configuration, exports may include:

  • Caregiver identification details

  • Client or cost center information

  • Pay period dates

  • Regular and overtime hours

  • Pay codes and earning types

  • Gross pay–related values (where applicable)

The exported file can then be uploaded into your payroll provider’s system for final processing.


Payroll Provider File Details

Below you’ll find a section for each supported payroll provider. Each section should include a screenshot of the export file format and a detailed list of fields.


Fields Included:

  • Co Code

  • Batch ID

  • File #

  • Reg Hours

  • O/T Hours

  • Temp Dept

  • Temp Rate

  • Earnings 3 Code

  • Earnings 3 Amount

  • Hours 3 Code

  • Hours 3 Amount


Fields Included:

  • Employee Name

  • Employee_Number

  • Department

  • RegHr

  • TrainHr

  • PTOHr

  • MISChr


Fields Included
This export is formatted without headers

  • Caregiver Id

  • Caregiver Name

  • Client Name

  • Service Start Time

  • Service End Time

  • Service Type

  • Regular Hours

  • Regular Amount ($)

  • OT Hours

  • OT Amount ($)

  • Holiday Hours

  • Holiday Amount ($)

  • Total Expense Amount ($)

  • Travel Time Hours

  • Travel Time Rate

  • Travel Time Amount ($)

  • Travel Mileage (Kms)

  • Travel Mileage Rate

  • Travel Mileage Amount ($)

  • Total Payable Amount ($)


Paychex

Fields Included:

  • EENumber

  • Date

  • Type

  • Hours


Viventium

Fields Included:

  • EmployeeNumber

  • CaregiverName

  • DepartmentCode

  • ServiceStartTime

  • ServiceEndTime

  • Service

  • PayUnits

  • PayRate

  • PayableUnits

  • OTRate

  • OTUnits

  • RateSource

  • PayDate

  • OfficeName

  • TotalHours

  • OTAmount

  • RegularPayAmount

  • RegularPayUnits

  • TimeTrackingId

  • ClassCode


Paycom

This export is formatted without headers

Fields Included:

  • (Column A) Employee ID: Payroll File number available in the HR Tab of the Caregiver’s profile.

  • (Column B) Department Code: Optional field and is left blank.

  • (Column C) Date: Actual Service Start Date, Format is MM/DD/YYYY

  • (Column D) Punch Time: (i) Optional field and is left blank.

  • (Column E) Punch Type : (i) Optional field and is left blank.

  • (Column F) Earning Code: Labor Allocation Code in Column I, blank

  • (Column G) Tax Profile Code: This field is optional, not mapped

  • (Column H) Comments: This field is optional, not mapped

  • (Column I) Labor Allocation Code: “Department Code” configured with service type in settings. 6-digit code

  • (Column J) Hours: Sum total of all the Hours i.e inclusive of Regular Hours, OT Hours and Holiday hours.

  • (Column K) Dollars: Total Amount (inclusive of OT, Holiday, Regular, Mileage, Expenses, PTO etc)

  • (Column L) Temporary Rate: This field is optional, not mapped

  • (Column M) DST Flag: This field is optional, not mapped

  • (Column N) Units: This field is optional, not mapped

  • (Column O) Make-Up Time: This field is optional, not mapped


Fields Included:

  • last_name

  • first_name

  • ssn

  • title

  • gusto_employee_id

  • regular_hours

  • overtime_hours

  • double_overtime_hours

  • bonus

  • commission

  • paychex_tips

  • cash_tips

  • gross_earnings

  • custom_earning_draw

  • reimbursement

  • personal_note


Fields Included:

  • action

  • clientId

  • employeeNumber

  • lastName

  • date

  • amount

  • earningcode

  • DepartmentCode

  • laborCategory1LaborCode

  • laborCategory2LaborCode

  • laborCategory3LaborCode

  • laborCategory4LaborCode

  • laborCategory5LaborCode

  • laborCategory6LaborCode

  • notes


Built-In Default Payroll Exports

In addition to payroll-provider–specific exports, CareSmartz360 includes built-in default export options that are available to all agencies. These exports are commonly used for internal payroll review, manual processing, or for upload into payroll systems that accept generic file formats.


Print & Export

The Print & Export option generates a human-readable payroll summary designed for review and validation. This export is often used for:

  • Internal payroll audits

  • Manual payroll entry

  • Sharing payroll summaries with accounting teams

Fields Included:

  • Client

  • Service Type

  • Pay Unit Type

  • Total Pay Units

  • Reg. Pay Units

  • Reg. Pay Rate ($)

  • Reg. Pay Amount ($)

  • Holiday Name

  • Holiday Pay Units

  • Holiday Pay Rate ($)

  • Holiday Amount ($)

  • OT Pay Rates($)

  • OT Units

  • OT Amount ($)

  • Level of Rate

  • Actual Pay Amount ($)


CSV Export

The CSV export generates a raw, comma-separated data file that can be opened in Excel or imported into third-party systems that support generic CSV uploads.

This option provides maximum flexibility for agencies that:

  • Perform their own payroll calculations

  • Use smaller or custom payroll providers

  • Need to manipulate or map data manually

Fields Included:

  • PayrollFile

  • CaregiverName

  • ClientName

  • ClientId

  • ServiceStartTime

  • ServiceEndTime

  • Service

  • PayUnits

  • PayRate

  • RateUnits

  • OTRate

  • OTUnits

  • RateSource

  • PayDate

  • OfficeName

  • TotalHours

  • OTAmount

  • RegularPayAmount

  • RegularPayUnits

  • TimeTrackingId


Important Notes About File Customization

The payroll export files listed above are provided as standard offerings within CareSmartz360.

Please note:

  • Changes to formatting,

  • Reordering columns, or

  • Removing data elements that your agency does not need

    are the responsibility of the individual agency.

Agencies may:

  • Adjust the files after export, or

  • Work directly with their payroll provider to accept the standard CareSmartz360 file format.


Custom Payroll Requirements

If your agency requires:

  • Additional fields

  • A different file structure

  • Custom logic or calculations

  • A payroll format not listed above

Please contact CareSmartz360 Support.

Custom payroll exports, reporting, or integrations are delivered through our Professional Services process and require planning, scoping, and development time; turnaround timelines are measured in months, not days.


Need Help?

If you have questions about:

  • Which payroll export to use

  • How to generate a payroll file

  • Whether your requirements can be supported through standard exports

Reach out to CareSmartz360 Support for assistance.

Did this answer your question?