- How to Install the Integration
- How to Export PayClock Online Payroll Data
- How to Read the Output File
How to Install the Export for Summit Payroll
- In PayClock Online, go to Integrations > Manage Integrations.
- Click New, in the list find Summit Payroll.
- From Add New Payroll Export select Setup Payroll Export.
- Select the pay class(s) to include in the integration and click Next.
Note: For multiple pay classes the pay period start and end dates must be the same or the export will have to be done by Date Range.
- Enter a nickname and File Name.
- Enter the Client Number for Summit Payroll.
- Select Export Departments and Export Employee Badge Number if you require that employee data, click Next.
- Select the pay codes to map or include in the export and enter the Payroll Pay Type as provided by Summit Payroll, click Next.
- Verify the configuration and click Save to complete the integration.
- The Summit Payroll integration will show in the list.
How to Export PayClock Online Payroll Data to Summit Payroll
- In PayClock Online click on Integrations, select the export from the list.
- At the export window, select a pay period or date range.
- Click Export Data and save the file.
- Log into Summit Payroll and follow the steps outlined by your payroll provider.
Note: Please contact your payroll provider if there are any questions when processing your payroll.
How to Read the Output File for Summit Payroll
| Field # | Field Description | Start Position | Field Size | Format |
| 1 | Client Number | 1 | 4 | |
| 2 | Employee Number | 5 | 5 | Required |
| 3 | SSN | 10 | 9 | N/A |
| 4 | Regular Hours | 19 | 8 | xxxxx.xx |
| 5 | Regular Rate if Different | 27 | 8 | xxx.xxxx |
| 6 | Overtime Hours | 35 | 8 | xxxxx.xx |
| 7 | Overtime Rate if Different | 43 | 8 | xxx.xxxx |
| 8 | Other Hours | 51 | 8 | xxxxx.xx |
| 9 | Rate if Different | 59 | 8 | xxx.xxxx |
| 10 | Code for Other Hours | 67 | 3 | |
| 11 | Salary | 70 | 8 | xxxxx.xx |
| 12 | Other Earnings | 78 | 8 | xxxxx.xx |
| 13 | Code for Other Earnings | 86 | 3 | |
| 14 | Work Comp Code Override | 89 | 5 | N/A |
| 15 | Work State Override | 94 | 2 | N/A |
| 16 | Division | 96 | 3 | N/A |
| 17 | Job Cost Center | 99 | 20 | Department No. |
| 18 | Clock No. if Employee No. is unknown | 119 | 12 | Employee badge No. |
| 19 | Pay Frequency | 131 | 1 | N/A |
Sample Output File for Summit Payroll
Sample file output with Export Department & Export Employee Badge Number options turned off:
1234,118,,40.00,12.0000,,,,,,,,,,,,0,,
1234,118,,,,1.33,18.0000,,,,,,,,,,0,,
1234,118,,,,,,40.00,12.0000,20,,,,,,,0,,
Sample file output with Export Department option turned on:
1234,118,,40.00,12.0000,,,,,,,,,,,,1011,,
1234,118,,,,1.33,18.0000,,,,,,,,,,1011,,
1234,118,,,,,,40.00,12.0000,20,,,,,,,1011,,
Sample file output with Export Employee Badge Number option turned on:
1234,118,,40.00,12.0000,,,,,,,,,,,,0,4653263,
1234,118,,,,1.33,18.0000,,,,,,,,,,0,4653263,
1234,118,,,,,,40.00,12.0000,20,,,,,,,0,4653263,
Comments
0 comments
Article is closed for comments.