Skip to content
logo Knowledgebase

Reconciling values on the Control Summary report

Created on  | Last modified on 

Summary

How to check the values on your Control Summary report in Sage Payroll.

Description

Before you begin processing a new pay period, you should check the values on your Control Summary report are correct. This involves reconciling the carried forward values from the previous period's report with the brought forward values for the current period's report.

Generally, the year to date totals for gross pay, tax, universal social charge (USC) and pay related social insurance (PRSI) are the same on both. However, if they're different, you should always investigate the reasons why and reconcile the differences.

TIP: The RPN can alter previous employment year to date figures, this is expected behaviour.

Resolution

Print the Control Summary report

For the current period

  1. From the process map in the centre of Sage Payroll, click View Control Summary.
  2. Click Print. Then to close the Control Summary Report Settings window, click Cancel.

For the previous period

  1. From the menu bar at the top of the window, click Miscellaneous then click Period Archive.
  2. Under Period Archives, select the previous period.
  3. Click Revert.
  4. From the process map in the centre of Sage Payroll, click View Control Summary.
  5. Click Print. Then to close the Control Summary Report Settings window, click Cancel.
  6. To go back to the current period; from the menu bar, click Miscellaneous then click Period Archive.
  7. Under Period Archives, select Current Period then click Revert.

Reconcile the values

On the Control Summary, the year to date totals appear under the Cumulative Control Totals section. You should review this information and reconcile any differences between the carried forward (C/Forward) values from the previous period and the brought forward (B/Forward) values for the current period.

 TIP: The Gross Pay YTD value in the Cumulative Control Totals section is Taxable Gross Pay YTD. 


Reasons why the values may differ from one period to the next

There are a number of reasons why your Control Summary values may differ from one period to the next. These include:

  • If you make an amendment to a timesheet, after printing the Control Summary
  • If you manually adjust values on an employee's record, for example, if you're setting up an employee mid year and entered their year to date information
  • An employee was manually added, or deleted from the payroll
  • If you transferred an employee into the payroll
  • If you retrieve an RPN 

If the difference between the brought forward and carried forward values relates to a legitimate manual adjustment, there isn’t a problem. However, we recommend that you write a note on the printed Control Summary report to identify the reasons for any differences.

However, if the difference is not legitimate you should make the relevant corrections.

Gross pay and non-taxable payments

The Gross Pay value in the Control Summary only includes payments that are subject to Tax. 

 TIP: The Gross to Nett report and payslips also only include taxable payments in the Gross Pay value. 

This explains any cases where the gross pay on these reports is less than you expected, where the employee received a payment that isn't taxable.