The Deductions Report was created to assist the Payroll Processor with obtaining information for a specific deduction for a specific time.
For example, if your employees contribute to an RRSP plan, you would need to know how much was deducted to issue a payment to the investor of these funds. You would also need a listing of those employees and the amounts contributed to supply to the investor.
Step 1: Navigate to Payroll
Navigate to Payroll > Periodic Activities > Deductions Report.
The following warning appears, to ensure that you are aware of problems when the Deduction Types are changed.
Step 2: Define Search Filters
Using the FIlters, enter the “Pay Date From” and “Pay Date To” fields that you require. In the following example, we are showing the enter 2018 year.
Navigate to the Home tab and click on “Generate Entries” and the following information is displayed for the filters previously defined. In this example, we are showing the entire 2018 year.
Scroll to the bottom of the page, and you will see the totals for the Employee and Employer amounts of the deductions for the time frame specified.
All fields in the Deductions Report can be filtered Ascending, Descending or by filtering for a specific Employee, Code etc.
In this example, just the information on the RRSP ER code is filtered.
The resulting report is then produced using the Code as defined.
Step 3: Lookup Functions
By clicking on “Lookup Expense Account” or “Lookup Liability Account” a new page is displayed with the requested information.
Note: In this example, we are using the “Lookup Expense Account” function, but the functions are the same with both the Expense and Liability accounts.
Highlight the line of the Deduction that you are wanting further information on. In this example, we will choose RRSP ER, then click on “Look up Expense Account”, and the following information is provided.
From this screen, you can then click on the “G/L Entries” icon to dive deeper into the source of the entries.
Step 4: G/L Entries
By clicking on the “Navigate” icon, the next screen shows that the entries are part of a General Ledger entry that has 33 lines.
Click on the “Show Related Entries” icon to see the source information.
The following information is then displayed.
Note: These reports can be exported to Excel.