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.

Warning Message

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.

Filter

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.

Generate Entries
Generate Entries Display

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.

Employee ;and Employer Totals

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.

Field Filtering

The resulting report is then produced using the Code as defined.

RRSP ER Report

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.

GL Entries

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.

Navigate

Click on the “Show Related Entries” icon to see the source information.

Show Related Entries

The following information is then displayed.

Source Entries

Note: These reports can be exported to Excel.