How to export IRIS Bureau Payroll information and Import into IRIS OpenBooks

Introduction

This topic explains how to export IRIS Bureau Payroll information and how to import this information into IRIS OpenBooks.

IRIS Payroll/OpenBooks integration

IRIS Launched IRIS Payroll for Accountants, a suite of Payroll products that are now integrated with IRIS Accountancy Suite and IRIS OpenBooks. This allows our Accountancy customers that run their own Payroll or a Bureau for their clients to deliver maximum benefit from their IRIS solutions, and enable them to prepare for Real Time Information (RTI).

Step 1 - IRIS Payroll for Accountants export

1. From the Desktop, double-click on the icon to launch the Payroll suite.

The following displays:

2. Enter the Username Name and Password (optional).

3. Click OK.

4. The standard user name for the software is PAYROLL.

The following displays:

4. Highlight the employer and click open or double-click on the employer.

The following displays:

5. Select the Company tab located at the top of the menu bar. Click   icon.

6. Select the HMRC tab.

• Ensure that HMRC district and reference numbers are entered in IRIS Payroll. This information is used for the IRIS OpenBooks integration.

7. Select  located in the top left-hand side of the screen to return to the Bureau Dashboard.

8. Select the Employer | View Employees.

9. Ensure that ‘All’ National Insurance (NI) details for the employees are correct.

• Check and confirm that the required information in IRIS Payroll is correct.

10. Click Clients located in the top left-hand corner of the screen to return to the Payroll Dashboard.

11. Select the chosen employer and select the Pay tab.

12. Click the icon.

13. Select the required Pay period and pay frequency.

14. Click Create.

The OpenBooks Export screen displays confirming the export has been completed successfully:

15. Click OK and Close.

• The file is stored in a zip folder located at C:\IRIS Bureau Payroll\OpenBooks.zip

Step 2 – Importing IRIS Payroll data into IRIS OpenBooks

1. Log in to IRIS OpenBooks and select client.

• Ensure that the HMRC reference number and NI numbers information are entered in IRIS OpenBooks, for the business you want to import the data for, prior to attempting the import.

2. Select Settings | Users| double-click on the Employee – Confirm NI details.

3. Select Taxes | Self-Assessment | Select the Tax Return | Select Edit next to ‘Other Employment’ - Confirm UTR details.

• If required, employees will need to be set up as users in IRIS OpenBooks, with National Insurance (NI) data entered correctly. These details must be match what has been entered in IRIS Bureau Payroll to ensure a successful import is carried out.

4. Go to the Accountants dashboard.

5. Select the CSV imports tab.

• If the CSV Imports tab does not exist, users will need to contact Support to have this option activated.

6. Select the Payroll option.

7. Select Import the CSV template or your IRIS file.

8. Browse to your exported Payroll file – Default location is C:\IRIS Bureau Payroll\OpenBooks.zip.

9. Click Upload – a window displays confirming the report was uploaded successfully.

10. Browse to client, Select Taxes tab | PAYE and NI - the payroll postings will now be available (see below).