Report locations when using Excel Integrated Reporting
Description

EIR lets you run your Sage 50 Accounts reports directly in Microsoft Excel. Follow the steps to locate and copy them, if needed.

Cause
Resolution

Report locations

When you upgrade from a previous version of Sage 50 Accounts, copy your EIR reports to the correct directory.


v29 and above

The EIR reports are held in the reports folder in the Data Directory of each company, for example C:\ProgramData\Sage\Accounts\XXXX\Company.000\REPORTS\Excel

 NOTE: Replace XXXX with your program year, for example, 2025.

  1. In Sage 50 Accounts, go to Help then About.
  2. Note the Data Directory, in the Program Details section.
  3. Press and hold down the Windows key  and press E.
  4. Browse to the original Excel reports folder.
  5. Right-click the required reports, then click Copy.
  6. Browse to the new Excel reports folder.
  7. Right-click the Excel folder, then click Paste.

 NOTE: Paste any custom reports for EIR and multiple companies into each Excel folder in the data directory. Repeat this for all companies.


v28 and below

The EIR reports are held in the Settings Directory: C:\ProgramData\Sage\Accounts\XXXX\Company.000\Reports\Excel

 NOTE: Replace XXXX with your program year, for example, 2021.

  1. In Sage 50 Accounts, go to Help then About.
  2. Note the Settings Directory, in the Program Details section.
  3. Press and hold down the Windows key  and press E.
  4. Browse to the original Excel reports folder.
  5. Right-click the required reports, then click Copy.
  6. Browse to the new Excel reports folder.
  7. Right-click the Excel folder, then click Paste.

 

[BCB:19:UK - Sales message :ECB]






 

Steps to duplicate
Related Solutions