How to: Process Payroll from Connect to Payworks
Important Note
- Keep Connect, Payworks and the Payroll Summary spreadsheet open as you navigate through this payroll process.
Connect
Add Payroll Modifiers
- Click the Scheduling icon in the navigation menu
- Click the Post tab
- Select a department in the calendar day
- Add the applicable Payroll Modifiers
Note: Make sure to add a Vacation Payout modifier before terminating an employee if your company accrues vacation.
Send Employee Records to Payworks
- Click the Human Resources icon in the navigation menu
- Click the Employee List tab
- Send the Employee Records to Payworks for New, Updated and Terminated Employees
Payworks
Reviewing Employee Imports
- Click the Payroll link in the side navigation
- Click the Employee Setup tab
- Click the Auto Imports link under the Employee Imports list
- Review the Import Files dropdown for the Employee Records to make sure all the imports were successful
Connect
Send Payroll to Payworks
- Click the Scheduling icon in the navigation menu
- Click the Post tab
- Click the Payworks (PPWW) (Ready to Send) on the last day of the payroll pay period when payroll is ready to be processed
Note: If the button does not say (Ready to Send) review Definition: Payworks Status
- Click the Continue & Send button
- Click the Ok button
Note: Once the payroll file has been sent to Payworks, the pay period will be grayed out. The shifts and payroll modifiers will no longer be editable.
- Click the Scheduling icon in the navigation menu
- Click the Post tab
- Click the Report (Payworks Payroll Cheat Sheet) button in the ribbon
- Select the pay period that is being processed from the Pay Period dropdown
- Click the Launch in New Window button
Note: Keep this report open in a separate window for the next steps in the Payroll Summary spreadsheet and Payworks system.
- The bottom of this sheet will indicate new hires in the pay period under "First Posted Shift", send these employees profile to Payworks individually by clicking into the employee's profile
Payworks
Review Connect Payroll Import
- Click the Pay Grid View link from the bookmarks in the side navigation or follow the path shown below
- Click the Load Employees button to populate the payroll file imported from Connect
- Match the Amounts in the Totals row of the Pay Grid View to each $ amount in the Amounts columns of the Report (Payworks Payroll Cheat Sheet) from Connect
Note: The Regular Salary will not show on the Pay Grid view. You will see the salaries after you run the Preview in the Review Payroll section.
- Scroll to the right within the Pay Grid to the Vacation Payout column and make sure that all employees that need their vacation paid out have $99,999.99 placeholders in their rows.
Note: Make sure the Vacation Payout has been added for all terminated employees if your company accrues vacation.
- If it is missing, enter P and hit Tab key on your keyboard and the word Payout will appear in the cell
Review Payroll [Step 1: Preview & Step 2: Review Reports]
- Click the Generate Payroll link from the bookmarks the side navigation or follow the path shown below
- Review the Processing Date to make sure you are in the correct pay period
- Click the Preview section [Step 1: Preview]
- Click the Run Preview button
- Click the View Reports button [Step 2: Review Reports]
Note: These reports are pop-ups; ensure your browser setting allows for Payworks always.
- Review each of the following Payworks Payroll Reports:
- Audit Trail
- Violations - displays an entry that may stop the pay from being produced
Confirm the entry is correct.
- Warnings - highlights potential setup errors
ie. a birthdate indicating the employee should/should not have CPP deducted (can be corrected from the Employee Information).
These should be investigated and corrected before proceeding.
- Information - captures employee profile changes. These should be reviewed for accuracy and become your Audit Trail report.
- Payroll Register
- The Register Totals at the bottom of the report should match the Pay Grid View & Connect balancing exercise done earlier.
- You should also confirm the Total Earnings in the Register Totals section is in line with their typical payroll total from other pay periods.
- Funds Summary
- Cheques – means no banking has been entered. You can identify these employees by clicking the Missing Primary Banking notification you set on the Home screen
Payroll Summary Spreadsheet
Balancing Payroll
- Enter the Total Amounts minus Regular Salary from the Connect Report (Payworks Payroll Cheat Sheet) in the green cell next to label [PB 3] Connect: Payroll Draft Review Total in the Payroll Summary spreadsheet
- Enter the Vac $ Pd, Vac Each Pay or Bonus $ and Total Earnings from the Payworks Payroll Register in the corresponding cells in the Payroll Summary spreadsheet
- Once you have entered the totals from the Payworks Payroll Register report, ensure the Payroll Summary balances.
The variance should be within +/- 0.25.
Payworks
Submit Payroll [Step 3: Final]
- Ensure there is a green check mark in the first 2 steps (Preview & Reports and Violations)
- Finish by clicking the Run Final button
Payworks Help Centre:
- For more specific how to walkthroughs of the Payworks system, click the ? button in the top navigation
- Enter the topic of the "how to" in the search field or click the Visit Help Centre link
- If you are looking for Payworks support you can find the contact for your CSR below the search field
Related Payworks links:
Note: Make you are logged into Payworks before clicking on the below links.
Your Payroll Processing is Complete!