If the Central Statistic Office (CSO) has selected your company for participation in their survey and you haven’t yet setup CSO reporting in Micropay, this document
will explain how to set this up. Once you have completed the setup you can generate the following CSO survey reports.
Earnings, hours and employee cost survey (NHECS)
This report monitors change in labour costs in Ireland and across the EU and must cover all payrolls belonging to the same tax registration and is
submitted quarterly to the CSO
National employment survey (NES)
The (NES) reports on statistical employment information from business that have more than three employees. This report must cover all payrolls
belonging to the current company and be submitted annually to the CSO at the end of the calendar year.
There are 3 steps to setting up CSO reporting in Sage Micropay, Activate the CSO reporting feature, Set up your payments for CSO reporting and Setup you
employees for CSO reporting.
Step 1 – How to activate the CSO feature in Sage Micropay
On the top menu bar click on Company/Payroll and select on ‘Company Details’.
On the ‘Company Details’ screen click on the tab ‘CSO’
On the ‘CSO’ tab enter in your company’s central business register (CBR) number into the ‘CSO CBR Number’ box and click ‘OK’. (If you are unsure of this
number please contact the Central Statistic Office)
This process must be completed on each of your payrolls in order to activate the CSO feature.
Step 2 – How to setup your payments for CSO reporting
Once you have activated the CSO feature in Step 1 you are now ready to start configuring your Payments for CSO reporting. You don’t need to
specify CSO settings for the following payment types: Redundancy, illness benefit, Benefit in Kind (BIK), maternity benefit and paternity benefit.
On the menu bar, click Company/Payroll then click Payments. This will list all the payments entered in Sage Micropay
Select a payment that’s subject to CSO reporting and click ‘Edit’.
Under ‘CSO Statistical Reporting, complete the following information:
EHECS Type Choose the relevant CSO type for this payment. If you are unsure please contact the Central Statistic Office for assistance
Hours Multiplier Enter the CSO hours multiplier value. This helps to ensure that the hours you record in the EHECS report is accurate
NES Type Select the NES type for the payment if applicable.
Click ‘Save’ to save your changes.
Repeat steps 2 to 4 for all relevant payments then click ‘Close’.
Repeat all the above steps in each of your payrolls.
Step 3 – How to setup your employees for CSO reporting
Once you have added the CSO details to your payments you will now need to add the CSO categories to each of your employees on your payrolls, to do this:
Open your employees record by clicking on the ‘Edit Employee’ icon on your process map or by clicking on ‘Processing’ on the top menu bar
and select ‘Edit Employee’.
Select the employee that you wish to add the CSO details to and click on the ‘CSO’ tab.
If your employee needs to be excluded from the CSO report, tick the ‘Exclude Employee from CSO Reports’ box and then click ‘Save’.
To include this employee in the CSO report, complete the following information:
* Occupation Status
* Type of Employment Contract
* CSO Occupation Category
* Hours per Working Day
* Contracted Hours
Click ‘Save’ to save your changes.
Repeat steps 2 to 5 for all employees on your payroll.
Repeat the steps above for all your payrolls.
Please note, if you are setting up the CSO feature mid year, you must delete all entries on the CSO History table and then repopulate it. This is because
the CSO History was populated before you made any amendments to the CSO details. Once you click on the button ‘Fil in Blank History’ Sage
Micropay will re populate the CSO history table with the new information that you have entered against the employee.
How to Delete the Existing CSO history
In the Employee Details on the CSO tab click onto the CSO entry line and press F5 on your keyboard to delete each of the lines.
Once you have cleared out the old CSO History click on the ‘Fill Blank History’, Sage Micropay will repopulate the CSO history with your amended
details.
ROS Password changed and RPN’s won’t download in Sage Payroll
in order for Sage Payroll (Micropay) to sync with ROS for the purpose of downloading live RPN’s and uploading payroll Submissions, Sage Payroll (Micropay) uses
a ROS digital cert which is download from your ROS site. Every now and again ROS requires users to change their online password,
When this happens the original ROS digital cert that Sage Micropay uses becomes invalid. This document will explain the
steps required to download a new ROS digital cert and load it into your Sage Micropay.
Step 1 Downloading your new ROS digital cert
Open up your ROS home page and click on ‘Manage My Certificates’
On the ‘Manage My Certificates’ screen click on the line that has your cert name and select the Save icon
Select ‘Yes’ on the save screen and ‘OK’ on the next screen. This will download you ROS digital cert with your new password to the Downloads folder on your PC.
Step 2 Locating your new ROS digital cert
By default your newly downloaded ROS cert is saved to the ‘Downloads’ folder on your PC. Open up your File Explorer and click on ‘Downloads’
on the left hand panel and locate your new ROS digital cert and copy it.
By default Micropay looks to the ROS digital cert in the ROS folder on your local C drive. If you are unsure, log into Sage Micropay and,
click on the ‘Retrieve RPN’s’ icon. The ‘Certificate’ location on this screen is the location of your original ROS cert. This is the location that you
will need to copy your newly downloaded cert to.
Step 3 Amending your ROS password in Sage Micropay
Once your new ROS digital cert has been copied to the ‘Certificate’ location you will need to add your new ROS password to Sage Micropay.
To do this open up your payroll and click on the icon ‘Retrieve RPNs’. Enter in your new ROS password and click ‘Next’. Sage Micropay
sould now be connecting with ROS.
Important Note: You will need to run this process on all PC’s that Sage Micropay is installed on.
If you have deducted too much pension from an employee, you may need to refund this back to them. You can do this in one of two ways:
1. Enter a negative pension contribution on the employee’s timesheet or reduce the usual contribution by the amount of the refund. Alternatively, if there is not an ongoing contribution then enter just the refund amount with a – in front of it in time and pay. For example if the standard weekly pension contribution is €25.00 and the amount to be refunded is €10.00 then edit the pension contribution deduction in time and pay to be €15.00 (€25-€10).
OR
2. Set up a new payment to be used in time and pay for the refunded amount. Then edit the ytd pension contributions in the deductions tab of employee record to take into account the refunded amount. See instructions below:
If the pension was originally deducted as a gross deduction ie it was deducted from gross pay before paye tax was calculated, then the refund must be subject to paye but not usc or prsi as these were already charged on the original income before the pension contribution was deducted.
Click Company/payroll then Payments and New. Enter details as shown below and save.
Click Edit Employees and select the relevant employee. Click the Deductions tab, Amend the Balance E’e and Total E’e to the correct year to date total for the pension. If required, to correct the employer amounts, you can edit the Balance E’r and Total E’r values.
In Enter Time and Pay enter the refund amount against the payment you set up earlier.
Note you may have to use method 2 in some cases where pension contributions are calculated using formula and cannot be manually edited in time and pay.
Set up ASC – Additional Superannuation Contribution in Sage Payroll (Micropay)
Additional Superannuation Contribution (ASC) calculations come into effect from 1 January 2019 and replace the Pension Related Deduction (PRD). Read more about ASC >
This article explains how to set up your payroll for ASC calculations in Sage Payroll 2019. If you have more than one payroll, you must complete the tasks below in each of them if ASC calculations are applicable.
Before you can proceed with the steps detailed below, you must install the 2018 year end update (v21.3/22.0) and transfer your 2018 payrolls into Sage Payroll 2019. The year end update will be available for you to download and install in early December.
Activate the ASC option within your payroll
On the menu bar, click Company/Payroll then click Additional Superannuation Contribution.
Select the Use Additional Superannuation Contribution (ASC) feature check box.
Click OK.
Mark payments as being subject to ASC
On the menu bar, click Company/Payroll then click Payments.
Click on a payment, then click Edit.
Select the Apply Additional Superannuation Contribution check box, then click Save.
Repeat steps 2 and 3 for all payments that are subject to ASC calculation, then click Close.
Apply ASC settings to your employees
On the menu bar, click Processing then click Employee Details.
Next to the Surname box, click browse and click the relevant employee.
Click the Deductions tab.
Under Public Sector – Additional Superannuation Contribution (ASC), click the ASC Status arrow then click the relevant option.
If the employee is in subsidiary employment and their main employment is elsewhere, select the Subsidiary check box.
If you select this check box, ASC calculates at the highest rate of the pension scheme the employee is a member of. The highest rate for a member of a standard or fast accrual pension scheme is 10.5%. For members of the single scheme, the highest rate is 7%.
6. Click the Pension Scheme arrow, then click the relevant scheme the employee is a member of.
7. Click Save.
8. Repeat steps 2 to 7 for each employee you want to enter ASC settings for, then click Cancel.
You’ve now assigned ASC settings to your employee(s). In each subsequent pay period, when you process your employees’ pay details, their ASC liability automatically calculates and appears on their payslip.
ASC calculates before tax is deducted from an employee’s pay. There is also employer PRSI relief in respect of ASC. Employee PRSI and universal social charge (USC) are deducted from an employee’s pay after ASC calculates so there is no relief on these.
and click the relevant employee.