If you need to build reports that aren’t available in Sage 50 Payroll Ireland, you can use the Advanced Report Writer (ARW) that comes with your software. Use this tool to design, format, and save your own payroll reports.

NOTE: Need us to create or design a report for you? Contact our technical support team to discuss your requirements in more detail. 

Log in to ARW

1. From Windows, open the relevant tax year version of ARW.
2. Enter the same credentials you use for Sage 50 Payroll Ireland, then select OK.

Login fields

• User Name: Your payroll username
• Password: Your payroll user password
• Company: Your payroll ID
• Password: Your payroll password

 NOTE: If you see 'Data Source Error Filling Lattice' or 'Cannot Read User File', you need to install an ODBC driver before you continue. 

Create a new report

1. In the main ARW window, select Create Report.
2. Select the Sage Payroll master data file that contains the data you need.
3. Double-click New.
4. Select the fields to include, then select OK.
5. To reorder a field, select it, then select Up or Down.
6. To remove a field, select it, then select Remove.
7. To add more fields, double-click New, then select additional fields.
8. To format a field, select it, then select Format.
9. Make changes, then select OK.
10. Select Printer Setup, then select Printer and choose Landscape orientation.
11. Confirm the other settings, then select OK.
12. In Report Name, enter a name; this appears in the ARW menu.
13. Select Save, choose a location, enter a file name, up to eight characters, then select Save.

Finish the task

• Select Preview to view the report
• Select Print to print the report
• Select Excel to export to Microsoft Excel
• Select File Output to save as CSV or TXT, choose a location and file type, then select Save
• Select Exit to close ARW

Open or edit an existing report

1. Log in to ARW.
2. Under Menu, select the report, then select Edit.
3. To add fields, scroll to the end of the list and double-click New.
4. Choose fields, then select OK.
5. Make any other edits you need, then select Save.
6. When prompted, select Yes, then Yes.

Finish the task

• Preview to view
• Print to print
• Excel to export
• File Output to save as CSV or TXT

Related content

• How do I add filters to a report?
• How do I add a sort to a report?
• Add payment and deduction values to a report
• What areas of Sage Payroll can I report on?
• How do I add formulas to a report?
• What field attributes are available?
• ARW Report Options