Skip to content
logo Knowledgebase

Excel Integrated Reporting (EIR)

Created on  | Last modified on 

Summary

How to set up and use Excel Integrated Reporting (EIR) for Sage 50 Accounts.

Description

EIR is a great way to access your Sage 50 Accounts data in Microsoft Excel. You can run most reports directly into Excel, manipulate the data from Sage using Excel functions and refresh your data, keeping it up to date at the click of a button. Let's set this up now.

 TIP: If you're using Sage 50 Accounts v27 or above and want to use EIR functions in your formulas, please download and install the Sage 50 Accounts EIR Functions Add-in. 

Resolution

For help with EIR, select the relevant options below:




Image

Simple, automated and all in one place
Manage your employees’ taxable benefits easily and accurately, with online submissions to HMRC. The deadline for P11D submission is 6 July 2024. Want to know more?

Leave your details and we'll be in touch