This brief guide will outline important year-end reconciliation processes you should conduct to ensure that everything is set up and ready to go to process T4s/T4As.
This applies to:
To reconcile both cash and non-cash benefits, we recommend reviewing employees who receive benefits and how much they should have paid. This only applies to customers who do not use Rise as their benefits broker.
Click "Reports" then "Custom Reports" to access the custom reporting section.
Start from the report called "Pay Runs".
Select the entire year as your date range, and then click "Submit".
Click on "Filter" and enter the information as below then click "Add".
Filter Column = Type
Comparison = Contains
Value = Benefit
Click on "Aggregate" and enter the information as below then click "Add".
Data Column = Amount
Aggregate Function = Sum
Click on "Layout" and pick which columns you need. We recommend; Name, Employee Code, Payroll Instruction, and Amount.
Click on "Group" and enter each grouping category below, clicking "Add" in between each selection. Ensure you have "Exclude Detail Rows" checked off.
Name [click add]
Payroll instruction [click add]
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.
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.