Payroll File Formats
Below is a list of payroll file formats currently available in FullCount.
Information about what is included in each payroll format is located at J:\FullCount\Documentation\Vendors\Payroll File Format Contents.xlsx.
Unless otherwise specified, when company is required, data can be loaded in as Company-Resident Billing Id on the employee level or Company can be loaded at the community level.
Employee charge accounts have no effect on payroll reporting and can be set as monthly or bi-weekly, depending on desired reporting for receipts and the charge account detail report.
|
Payroll System |
Level of Summarization |
Company Required |
Sales Tax Separate Applicable |
Notes |
|
ADP |
Summary |
Y |
N |
Item billing data should be loaded in as Bill Code-Description. If description is not needed, billing data should be loaded as Bill Code- (the hyphen is needed for the bill code to show in the correct column). |
|
AOD |
Summary |
N |
N |
This can be run in fixed width text format or CSV format. Also referenced as "MatrixCare" |
|
Ceridian |
Summary |
N |
Y |
Ceridian payroll format has two different options. One from their legacy system and one for Dayforce. Check with customer to know which file to use. |
|
Engage PEO |
Summary |
N |
N |
|
|
Excel |
Summary |
N |
N |
This file format can be used when the community's payroll system does not accept an import |
|
Inova |
Summary |
N |
Y |
This company is referred to as Inova and Evolution. |
|
Kronos Dimensions |
Summary |
N |
N |
The file format requires additional fields in the parameter form (Payroll Name, Payroll Batch Name, and Payroll Pay Date). |
|
Kronos |
Summary |
N |
N |
Employee billing id is referred to as Employee ID. Employee bill code is referred to as deduction code. |
|
Kronos Workforce Ready |
Summary |
N |
Y |
|
|
Kronos Workforce Ready (Multiple EIN) |
Summary |
Y |
Y |
For this file format, company code and employee billing id need to be separated by a tilde (~). This format should be used when a community has multiple EINs within Kronos. Otherwise, the other Kronos Workforce Ready payroll file should continue to be used. |
|
Oasis |
Summary |
N |
N |
This is the same file format as Singlepoint |
|
Oracle |
Summary |
N |
N |
This file format does not import into Oracle Payroll, but is frequently used by communities who have this payroll system. |
|
Oracle HSDL |
Summary |
N |
N |
This file format will probably be exclusively used by Life Care Services to import into Oracle HCM. |
|
Paychex |
Summary |
N |
Y |
|
|
Paycom |
Summary |
N |
N |
This file format has two options, CSV and Excel. The Excel version is likely more in line with Paycom standards and should be tried first. |
|
Paycor |
Summary |
Y |
Y |
|
|
Paylocity |
Summary |
N |
Y |
|
|
PayNorthwest |
Summary |
N |
N |
|
|
PeopleGuru |
Summary |
N |
Y |
|
|
Prestige |
Summary |
Y |
N |
|
|
Pro ID |
Summary |
Y |
Y |
For this file format, company code and employee billing id need to be separated by a tilde (~) since their company ids contain a dash (-) |
|
Singlepoint |
Summary |
N |
N |
|
|
UKG Pro |
Summary |
Y |
N |
|
|
UltiPro |
Summary |
N |
N |
|
|
Viventium |
Summary |
N |
N |
|