KB Category: Sage Payroll Updates

Payroll Year End 2022

Payroll Year End 2022: 

Another Year over in the world of Payroll.   As payroll operators and support teams we have still been playing an important link between the government and employees, bringing us to our third Payroll Year End in the payroll modernisation era. Once again we have put together this PYE article, as a one stop hub to get you through your Payroll Year End. Everything you need to know is here!

The information below will refresh your memory with some important tips, handy downloads and links to other articles which may be relevant to your payroll.

Things to Remember:
Because you have been making submissions to Revenue every time you pay your employees, payroll year-end is like any other pay period with a few preparation tasks and additional steps. This should make it more smooth running. Below is an insight into what you can expect.

  • ‘Employment Detail Summary’ Report
    Like last year, the system contains a report which summarises the employees employment details. It’s called the ‘Employment Detail Summary Report’. You are not required to hand this out to employees, but you can print or PDF it for your own reference. If an employee asks you for a summary of their employment, this will be the report to give them. It’s predecessor was the P60 document (Pre 2019).
  • Get PYE Ready by Reviewing Revenue Submissions
    You can check submissions you’ve made to Revenue, using the View Payroll Submission Log option. This shows you summaries of submissions, which you can filter by period date. You can also export a detailed report of each submission contained in the log for more information about what was submitted. To get ready for the year end, we recommend that you review these and compare them to those in your ROS account.

Useful Resources:
We have some useful resources listed below which can assist you to complete your year end:

  • Booklet & Checklist
    To help you along the way, here are links to our Payroll Year End Booklet 2022 and our Year End Checklist 2022. Feel free to download them and use them to guide you through your Year End Process.
  • Your Payroll Year End Software Update
    If you haven’t already been prompted to install your payroll year end update, then you can expect to be very shortly. The update includes the option to complete the 2021 tax year and get started in the 2022 tax year. You don’t need to wait until you receive the prompt, you can get ahead and download from here or from the downloads section below. The update will update your 2021 payroll software to Version 25.3 It will also install the 2022 Payroll Software which is version 26.0

 

All Downloads:

2022 Year End Update: You can Download the 2022 Year End Update (V25.3 & V26.0 )by Clicking Here. (Size: 306 MB)

2022 Year End Booklet: You can Download the 2022 Year End Booklet by Clicking Here.

2022 Year End Checklist: You can Download the 2022 Year End Checklist by Clicking Here.

 

Helpful Information:
We have also put together some other articles which you find helpful as you work through the payroll year end.
Click on the links below to view each one.

 

Download and install Sage Payroll v24.2

Download and install Sage Payroll v24.2

 

Sage Payroll v24.2 is available to download and install. This article details how to download and install this version.

 

Before you install

Check the version you’re currently using and make a note of where the software is installed.

  1. Login to your computer as system administrator.
  2. Open Sage Payroll 2021, click Help then click System Information.
  3. Confirm your version number is v24.0 or above.
  4. Make a note of the Program Directory and Data Directory.
  5. Back up your data.

If your data is held on this computer, continue to the next section. If your data is held on a network the steps are different.

 

Download and install

  1. Close Sage Payroll 2021 and all other software.
  2. Click the link: Download Sage Payroll v24.2
  3. Double-click the file that downloads – Sage_Payroll_v24.2.exe
  4. Select the I accept the terms of the licence check box, then click Next.
  5. Select This Computer, then click Next.
  6. Select Custom, then click Next.
  7. Check the program and data directories are the same as you noted earlier.  If not, click Browse, enter the correct directories, then click OK.
  8. Click Next, then select the Add shortcuts to my desktop check box.
  9. Click Install, then click Finish.

 

What’s new in Sage Payroll 24.2?

 

  • Click F1 at any time in your software to bring up our world class knowledgebase articles.  Find out more >
  • A pay date field has been added to the Timesheet entry screen when processing leavers.  Find out more >
  • New supplementary CSO types. Find out more >
  • The employer liability report now includes an optional Employer and Employee PRSI breakdowns.  Find out more >

Sage Payroll Software Update – Version 23.4

Sage Payroll update version 23.4 is now available.

**Important Note: If you are using the CWPS Feature in Sage Payroll, you should refrain from installing this update until on or before Monday 28th September! This update contains the new rates which pertain to the new CWPS year (CWPS New year starts on 1st October. Monday 28th Sept is the start of Week 1 of the new CWPS year.)

What’s New:

  1. New CWPS rates, (come into effect on the 28th of Sept). Link to full article here –> CWPS New Calendar
  2. Timesheet warnings with regard to EWSS, when the Gross Pay/Insurance weeks are outside of the allowed range. Link to full details here –> EWSS TImesheet Warnings.
  3. Timesheet EWSS information flag, to indicate when an EE is marked for EWSS.

 

Installing the Update:
You may be prompted to install the update from your Sage Payroll software, if not you can download and install it from the Pimbrook download area. The procedure for this is the same as with any prior payroll update – see notes below:

  1. Ensure you have the correct version of software for the update. To see the version, open Sage Payroll 2020, click Help then click System Information. The current version should be V23.3
  2. In the System Information Screen, make a note of the Program Directory and Data Directory.
  3. Check that all of your payrolls have a status of End of Period (EOP) or Start of Period (SOP).
  4. Back up your payroll data.
  5. Close Sage Payroll 2020 and all other software.
  6. Log in to the computer as administrator (or as a user with administrator rights) and turn off any anti-virus and “User Account Control”.
  7. Download the update from the Pimbrook Download area by clicking here.
  8. Execute the downloaded file and follow the install steps, ensure the program and data directories are the same as noted in 2 above, for more information see our article on Sage Payroll Update Instructions and Preparation.

 

Important Note:

Please ensure that you install the update correctly, particularly if you are using a network installation and the data location is not on the same computer. If you find that some employees are on PRSI class A1 regardless of their PRSI eligible pay then you probably have not applied the update to your data location (i.e. the server). If this occurs please reinstall the update correctly to all required locations (i.e. client and server computers).

Moving Sage Payroll (Micropay) to a new computer

Moving your Sage Payroll (Micropay) from an old computer to a new computer involves an number of steps to install the software on the new machine and to copy over any local data.

The correct procedure is outlined below:

1. Take note of the “Program and Data Directories” from your current payroll installation on the old computer. This is shown under “Help –  System Information” in your Sage Payroll software.

2. If your Sage Payroll is installed on a “Standalone Computer”, copy these “Program and Data Directory” folders to the same locations on the new computer, if it is a Client/Server installation, copy just the “Program Directory” to the same location on the new computer. These folders are by year so you should copy all folders for the years that you require to the new computer, if you want them all, then copy the parent folder (e.g. “C:\ProgramData\Micropay Professional”
(Note: If the Sage Payroll Data Directory will be different on the new computer you will need to change the dataloc.ini file before you run the latest software. To do this go to the Sage Payroll “Program Directory” (as per 1 above) and browse to the dataloc.ini file. Copy this file out to the Desktop. Double click and open with Notepad. Change the path for the data, save the file and then copy into each year in the “C:\Program Files (x86)\Micropay Professional” or “C:\Program Files (x86)\Sage Payroll Irl” folder, if you are prompted that the file already exists, overwrite it).

3. If you have ROS certificates on the computer for payroll submissions then these may need to be copied to the new computer. You should find out where the certificates are on the old computer and copy these to the new computer, this is done as follows:

  • On the old computer, open Sage Payroll
  • Select “Retrieve RPNs”.
  • This will show you the folder path and file name of the ROS certificates (e.g. something like “C:\ROS\DigiitalROSCert.p12.bac”)
  • In Windows take a copy the ROS certificate file.
  • Move this copied certificate file to an ROS folder on the new computer (e.g. “C:\ROS”, you may need to create this folder).
  • After Sage Payroll is installed on the new computer (see step 4 below) you will need to set the ROS Digital Certificate when you first “Retrieve RPNs”. This is done by browsing to the new folder where the ROS certificate was copied to (see above) and selecting the certificate file. You will most likely have to enter your ROS password and save this.

4. Run the latest update of Sage Payroll (see Installing Sage Payroll) and check the Program Directory and Data Directory match the directories copied in 2 above during the installation.

 

 

 

 

Sage Payroll Software Update – Version 23.1

Sage Payroll update version 23.1 is now available.

What’s New:
  1. The primary change in this update relates to an increase in the national minimum wage by 30c to €10.10 and consequently the Class ‘A’ employer PRSI threshold will increase from €386 to €395. The two are not effective until 1st Feb 2020, but the update can be installed anytime before this date, as the software will only apply the new legislation changes to any payrolls dated February 2020 onwards.
  2. Update Timesheet “Over 65” Warning to “Over 66” (as 65 was the incorrect age.)
  3. “Set Period” will generate an error if the pay date is not within the current tax year.
  4. Employees who were not paid in the period, are now excluded from the Control Summary ‘Employee count’.
  5. In line with number 4 above, Employees with ‘no pay due’ will now be excluded from the Bank Transfer, Cash Dissection, Cheque Register & Credit Transfer Reports.
  6. Fix to Payments Report (Export to Excel) to include decimal places.

 

Installing the Update:

You may be prompted to install the update from your Sage Payroll software, if not you can download and install it from the Pimbrook download area. The procedure for this is the same as with any prior payroll update – see notes below:

  1. Ensure you have the correct version of software for the update. To see the version, open Sage Payroll 2020, click Help then click System Information. The version should begin with v23, if it does not, please install the payroll year end update, v23 – see here Sage Payroll Year End 2019 Update .
  2. Make a note of the Program Directory and Data Directory.
  3. Check that all of your payrolls have a status of End of Period (EOP) or Start of Period (SOP).
  4. Back up your payroll data.
  5. Close Sage Payroll 2020 and all other software.
  6. Log in to the computer as administrator (or as a user with administrator rights) and turn off any anti-virus and “User Account Control”.
  7. Download the update from the Pimbrook Download area by clicking here.
  8. Execute the downloaded file and follow the install steps, ensure the program and data directories are the same as noted in 2 above, for more information see our article on Sage Payroll Update Instructions and Preparation.

 

Important Note:

Please ensure that you install the update correctly, particularly if you are using a network installation and the data location is not on the same computer. If you find that some employees are on PRSI class A1 regardsless of their PRSI eligible pay then you probabaly have not applied the update to your data location (i.e. the server). If this occurs please reinstall the update correctly to all required locations (i.e. client and server computers).

 

 

 

CWPS Report Issues after CWPS Update (1st Oct 2019)

Scenario:

After the customer has run their Sage Payroll V22.4 Update and entered their new CWPS ‘Week 1’ payroll (CWPS Week Dated 30/09/2019 – 04/10/2019), they encounter issues with the data that shows in the CWPS Contributions Report.

Symptoms:

The report either shows no data for ‘Pay Week’ 1 (Run Report Week1 – Week1)
Or it shows data at old rates, and for ‘Pay Week’ 39 or 40 (or whichever might be  applicable to that payroll) (Run Report Week1 – Week52)

Cause:

This happens because the new CWPS Calendar was setup after setting the period in question. When you click Set Period – in the background the software grabs the appropriate ‘CWPS’ week number from the CWPS Calendar, based on the ‘Period Date’ field for the period and saves the CWPS data (per timesheet) against the chosen CWPS week number in the CWPS history table. If the new CWPS Calendar is not setup before Set Period, the set period screen will grab the CWPS week number from the ‘Old’ calendar (that being maybe 39 or 40). Some users will notice this in the Set Period screen and will change it themselves. Some wont:

Solution:

As the CWPS week number on the Set Period screen can only be changed at status SOP, the only solution is to:

(Carry out the steps in the order shown below)

  1. Restore back to the previous period EOP (EG: EOP 38)
  2. Check the CWPS Rates are still the new ones. (If they are not – run the update again or change them manually).
  3. Set up the New CWPS Calendar (Start Date 30/09/2019)
  4. Set the period in question (EG: Period 39) making sure that the CWPS Section of the Set Period Screen says ‘Week From: 1’ and ‘Week To: 1’ (If weekly payroll). This may say ‘Week From: 1’ and ‘Week To: 4’ if it’s a monthly payroll.
  5. Clear the CWPS Balances: Click Year End at the top of the screen and then click New Construction Pension Year. Click yes to the message when prompted.
  6. Check CWPS Report (Week 1 – Week 52) to confirm it is blank.
  7. Run Timesheets again.
  8. Run EOP.
  9. Check CWPS Report Again (Week 1 – Week 1) – It should be ok now.

CWPS – New Calendar Year 2020/2021 and Rate Changes (From 1st Oct 2020 – Version 23.4)

The Calendar year for the Construction Workers Pension Scheme changed back in 2019. In previous years it has been a ‘Jan – Dec’ year. From 1st October 2019, it changed to an ‘Oct – Sept’ year. Due to the new CWPS calendar year, the CWPS Rates will be changing annually on the 1st of October.

V23.4 supports those increases to the Construction Workers Pensions Scheme (CWPS) which come in to effect from 1st of October 2020. When installed, the update will immediately apply changes to the necessary rates. If this applies to your payroll, then this update will help you to remain compliant. Please note though, that this update will need to be installed on a particular period so as not to apply the increases too soon.

You will need to carry out the following steps to complete the update:

  1. Choose the Appropriate Period to Run the Update
  2. Backup Your Payroll
  3. Download & Install The Update prior to setting your ‘Applicable Period’
  4. Set up the new CWPS Calendar prior to setting your ‘Applicable Period’
  5. Set your Applicable Period (‘Period Date’ must be on or after 28/09/2020)
  6. Browse The New Rates & Check Categories
  7. Clear the CWPS Balance History
  8. Run your CWPS Report (1-52) to confirm it is blank.
  9. Process Timesheets
  10. Check CWPS Report to confirm rates used are correct.

 

Steps 1-8 are detailed below:

1. Choose the Appropriate Period to Run the Update:

If the change in CWPS rates effect your payroll, then it is imperative that you install the update at the appropriate time. At the moment you install the update, the CWPS Rates will change in your payroll software. As the rate increase is only applicable from 1st of October 2020, ideally you should wait to install the update, until ‘End Of Period’ of your last September payroll. That is, the last September payroll where ‘Pay Date’ is a September 2020 Date (See ‘Pay Date’ in Image Below).

You can check this in advance, by clicking the ‘Company/Payroll’ menu at the top of the screen, and choosing ‘Calendar’. In the example below, as the applicable period is Period 40, it would be appropriate to run the update and set up the new CWPS Calendar at End of Period 39. This way the new rates and new CWPS Calendar will exist before setting the first CWPS Period (CWPS Week1).

Your payroll(s) may differ to this example, so check the calendar in each of your payrolls, before processing timesheets.

 

2. Backup Your Payroll
  • We recommend to take a backup of your payroll data, in your usual manner, before running an update.
  • It may also be advisable to print off your CWPS Report for CWPS Weeks 1-52, prior to making the necessary changes to CWPS, as this report will be cleared later in the process.

 

3. Download & Install The 23.4 Update prior to setting your ‘Applicable Period’:

As per step 1 above, make sure you have chosen the correct moment to install the 23.4 update, as the CWPS Rate changes must not be used until your appropriate period. Once you have identified the moment you need to run the update in, you can click the link below to download the update. Run the update in the usual manner.

Click Here to Download the Sage Payroll Software Update 23.4 (225mb)

 

 

4. Set up the new CWPS Calendar:

In order to comply with the new CWPS calendar year format, you will need to set up a new CWPS calendar. To do this:

  • Click on ‘Company/Payroll’ menu.
  • Choose the ‘Construction Workers Pension’ option.
  • In the window that is presented click on the ‘Calendar’ tab.
  • In here click on the ‘Create New Calendar’ button.
  • Enter the start date of 28/09/2020 (This is the Monday of the first week of the new CWPS calendar).
  • Click ‘Create’
  • Click ‘OK’

 

 

The new Calendar should look like this:

5. Set your Applicable Period:

Set you applicable period number. ensure that your ‘Period Date’ is on or after 28/09/2020. This date (28th Sept) is the start date for the new CWPS Calendar. If your period date is prior to this, your CWPS contributions may not report into the correct period. In the example above, this is period 40. Your applicable period may differ to this.

Note On ‘Set Period’: When you click ‘Set Period’ make sure that the ‘Week To’ and ‘Week From’ fields in the ‘CWPS’ area of the screen are: both equal to ‘1’ if running a weekly payroll, or show From ‘1’ To ‘5’ if running a monthly payroll. If this is not correct, then your CWPS data may report to the incorrect CWPS ‘Pay Week’.

 

 

6. Browse The New Rates & Check Categories:

After you have set the period, browse the CWPS categories & new rates under the ‘Company/Payroll’ menu – ‘Construction Workers Pension’ option. The new rates are listed here.

There are only three Active Categories: POC (Pension Only no DIS), SPB (Pension/Sick Pay) and SPI (Standard Contrib + Industry Additions). Other earlier categories are no longer in use:

It is also advisable to browse your employees, and ensure that they are assigned to the correct category. To do this:

Choose the relevant employee in ‘Employee Details’, Click ‘Deductions’ Tab, Under ‘Construction Worker’s Pension Scheme’ select the correct category from the drop down list. Click Save.

 

7. Clear the CWPS Balance History:
  • From the menu bar at the top of your window, click Year End then click New Construction Pension Year.
  • When you receive the prompt to clear the balances and history, to continue, click Yes.

 

8. Run your CWPS Report (New Year 1-52) to confirm it is blank:
  • Click ‘Other Reports’
  • Choose ‘Construction Pension’ on the left hand side.
  • Click ‘Preview’
  • There should be no data for any ‘Pay Weeks’ in the report.

 

9. Process Timesheets:
  • Once you have carried out steps 1-8 above, you can continue to process your timesheets & do End Of Period as normal.

 

10. Check CWPS Report to confirm rates used are correct:
  • Check your CWPS Report after EOP to view contributions at new rates for CWPS Week1. Ensure the rates are correct before completing CWPS Week1 in your payroll, as if they are not correct, you will need to re-process at the correct rates.