Reconcile benefits in Payroll

Reconcile benefits in Payroll

To reconcile both cash and non-cash benefits, we recommend reviewing employees who receive benefits and how much they should have paid. 

1. Click Reports, then Custom Reports to access the custom reporting section.

2. Start from the report called Pay Runs.

3. Select the entire year as your date range, and then click Submit.


4. Click on Filter and enter the information as below, then click Add.

  1. Filter Column = Type
  2. Comparison = Contains
  3. Value = Benefit

5. Click on Aggregate and enter the information as below, then click Add.

  1. Data Column = Amount
  2. Aggregate Function = Sum

6. Click on Layout and pick which columns you need. We recommend; Name, Employee Code, Payroll Instruction, and Amount.


7. Click on Group and enter each grouping category below, clicking Add in between each selection. Ensure you have Exclude Detail Rows checked.

  1. Name
  2. Payroll instruction

8. You now have a report outlining the totals per employee for all benefits for the year. If you compare this against your benefit carriers data, you will be able to correct any potential discrepancies prior to closing the year.

Mileage

For Mileage reconciliation, you can run a report very similar to the one above. Instead of using the filter to show only benefits, you can use the Filter function to show only your mileage instructions.

    • Related Articles

    • Close the year

      Before you close the year, you must be absolutely sure that you are finished paying employees for the year. Once the year is closed, it cannot be opened. The year must be closed in order to process payroll for the new year. Please do not close the ...

    • Add payroll instructions

      Who can use this feature? Users with Payroll Organization Admin role Available on Start , Grow , and Optimize plans. Introduction Payroll instructions are fundamental building blocks in Rise Payroll. They calculate and track the amounts of earnings, ...

    • Send one-off finalized tax form to an employee

      Once you complete your year end in Rise Payroll, you can send employees' tax forms to their work email. Only previous year’s tax forms and current year’s finalized tax forms can be sent. 1. Navigate to Payroll and click the Employees tab. 2. Here ...

    • Employee payroll setup overview

      Please follow these steps in chronological order before attempting to process payroll. 1. If you created payroll profiles for your employees when you added them to the People Directory, you won’t need to add them again to payroll. However, if you ...

    • FAQ: Payroll setup

      Q: How does Rise calculate deductions for federal and provincial taxes? A: Rise uses cumulative averaging, meaning that our system uses the year-to-date options in the tax calculation as described in the Payroll Deductions Formulas for Computer ...