Sage 50 Excel Integration Guide

Updated On: June 25, 2026 10:38 am

Sage 50 is a widely used desktop accounting software that is equipped with multifunctional cloud features. It offers payroll and an Accountant Edition for CPAs and bookkeepers. In the U.S. Sage 50 is the updated version of Peachtree Accounting. The name applies to versions adapted for different regions globally.

Usually, to display and handle financial information, finance professionals use Excel. Prime uses comprise modelling, financial reporting, forecasting, budgeting, and data evaluation. These are done with tools like charts and pivot tables.

Sage 50 Accounts provides integrated reports and insights pages. Without accessing Sage 50 properly, users can utilize complete accounts data, thanks to Excel Integrated Reporting. Consequently, this prevents sudden data alterations.

Integrating Microsoft Excel with Sage 50 accounting software benefits Accountants, Small Businesses, and Financial Analysts. Here is an overview:

• Small Businesses: Monitor budgets, access real-time insights, evaluate inventory, and anticipate cash movement.
• Accountants: Minimize issues, automate reporting, fast-track reconciliation, and keep audit records.
• Financial Analysts: Evaluate multiple outcomes, create personalized dashboards, monitor trends, and implement enhanced forecasting.

With the help of such integration, workflow is streamlined, which improves financial decision-making for different roles.

Understanding Sage 50 and Microsoft Excel Integration

Sage 50 Accounts Excel Integrated Reporting has two primary components: Sage Data Ranges and Sage Functions.

Sage Functions uses Excel features to display particular account details on the worksheet. Like, for instance, use =GLBAL() to view the current balance of a chosen general ledger account.

Sage Reports work as information sources like Excel Queries. It is not mandatory to learn about Sage 50 data structure to utilize them. For instance, take a report like the Balance Sheet. Excel will help you add the data concerning the cell you choose.

Furthermore, integrating Excel with Sage 50 optimizes core functionalities that augment business financial management. Here is an overview of the core functionalities:

• Personalized Financial Reporting: In Excel, users can create financial statements like income statements, balance sheets, plus cash flow reports. Excel is used for calculations and formatting.
• Financial Planning Cash Flow predictions: Users transfer Sage 50 actual data into Excel. With the forecast feature of Excel, users distinguish actual figures from budgets and develop and estimate.
• Sales Evaluation and Inventory: Users transfer Sage 50 data to Excel to monitor inventory, classify customer patterns, and track sales.
• Combining data from multiple companies: In one Excel workbook, users mix data from several Sage 50 company files. This procedure makes business performance evaluation simple.
• Live data synchronization and export: Live data is sent into Excel from Sage 50 by users. Excel automatically updates the financial reports, thereby eliminating the need for manual data entry.
• Improved Data Evaluation using Pivot Tables: To simplify large Sage 50 datasets, users access the Pivot tables in Excel. This assists in evaluating expenses, expenses, sales, and customer information with accuracy and swiftness.
• Data Visualization: To showcase the key performance indicators, users access the Excel graphs and charts. These features are used to create dashboards to showcase financial data with charts.
• Automatic Report Update: Excel connects directly to Sage 50 data updating the reports automatically. This helps to display the latest financial information.

Also Read: Shopify Sage 50 Integration: Automate Your eCommerce Success

How to Do Sage 50 Excel Integration?

In order to access Excel Integrated Reporting, it is crucial to link Excel to the Sage 50 Account data. Here are the steps to do a Sage 50 Excel Integration:

• Launch Excel, then open either a blank workbook or your workbook.
• Make sure the Sage 50 Accounts tab is visible.
• Press the “Office” button present on the top-left side of the Excel.
• Choose the “Excel Options” button.
• In the screen for Excel Options, press the Add-Ins tab. Next, in the Add-ins page, choose the option, Sage EIR Add-in, and press the “Go” button.
• In the Add-Ins screen, make sure the Sage EIR Add-ins are ticked.
  • In case it is deactivated, select the “Manage” option present at the tab below. Now choose the “Disabled Items” option and then press the “Enable” option for Sage EIR. Press the “Close” button.
• Press the “OK” button to get back to the workbook.
• Head to the Add-Ins menu and choose the “My Company” option.
• The screen “Select Company” appears. Select a company and press the “OK” button. The login screen appears.
• Type the Login Name and Password and then press the “OK” button.

Also Read: Sage 50 ODBC Driver Setup

How to Set up and use Excel Integrated Reporting?

Before proceeding, verify your data directory since the upcoming steps will access your company’s data.

• Navigate to Help > About.
• In the Program Details section, find and note the Data Directory.

Verify that Sage options are available

• Open Excel.
• Open a workbook (existing or blank).
• Check for the Sage 50 Accounts tab.
• Go to File > Options.
• Click Add-ins.
• Click “Go” after selecting “COM Add-ins” from the Manage drop-down menu.
• Select any Sage add-ins, then click 

Connect to your company’s data

• Navigate to the Sage 50 Accounts tab in Excel.

• Open the Recent Companies drop-down and click Add Company.
• Select your company from the list and click OK.
  • If the drop-down flashes or closes, press Ctrl + F1 and choose Always show ribbon.
• Click OK after entering your password and login name.
  • In Sage 50 Accounts, use a logon with EIR access that isn’t already active.

Also Read: How to Fix Sage Integration Service Error 14101?

How to Run a report with excel integrated reporting?

• In Excel, go to the Sage 50 Accounts tab.
• Confirm that the correct company appears in the Recent Companies list.
• Click the Report drop-down.
• Choose a report and click Insert.
  • The report data appears in your current workbook.

Report locations when using Excel integrated reporting

After updating Sage 50 Accounts, move your Excel Integrated Reporting (EIR) files to the correct folder.

v29 and above

Within each company’s Data Directory, EIR reports are kept in the Reports folder. For ex:
C:\ProgramData\Sage\Accounts\XXXX\Company.000\REPORTS\Excel

Note: Enter your Sage program year (for example, 2025) in place of XXXX.

• Open Sage 50 Accounts.
• Go to Help > About.
• Take note of the Data Directory path in the Program Details section.
• Press Windows + E to open File Explorer.
• Browse to the original Excel reports folder (from your previous version).
• Right-click the required reports and select Copy.
• Go to the new Excel reports folder.
• Right-click the Excel folder and select Paste.

Note: For custom EIR reports or when using multiple companies, paste the reports into the Excel folder of each company’s Data Directory. Repeat this for all companies as needed.

v28 and below

EIR reports are stored in the Settings Directory, for example:
C:\ProgramData\Sage\Accounts\XXXX\Company.000\Reports\Excel

Replace XXXX with your Sage version year (e.g., 2021).

• Navigate to Help > About after opening Sage 50 Accounts.
• In the Program Details section, note the Settings Directory path.
• Press Windows + E to open File Explorer.
• Open the original Excel reports folder.
• Right-click the reports you need and select Copy.
• Go to the Excel reports folder in the updated version.
• Right-click inside the Excel folder and select Paste.

Also Read: Sage 50 Web Store Integration

How to add reports to Excel integrated reporting?

Add an existing report to EIR

A Sage 50 Accounts report that already exists can be edited and used in Excel Integrated Reporting.

• Open Sage 50 Accounts.
• Go to the module related to the report (e.g., Customers).
• Click Reports.
• Open the folder where the report is stored.
• To open the report in Sage Report Designer, select it and click Edit.
• Remove any unwanted fields or headings:
  
  • Select the fields or headings.
  • Press Delete on your keyboard.
• Click Edit on the top menu and select Select All.
• On the Format menu, choose Alignment, then click Left.
  • Click any blank area in the main window to clear the selection.
• Align individual report columns:
  • Click a column heading.
  • Hold Shift and select the other items in the column.
  • Click Format > Alignment > Left.
  • Repeat for each column that needs alignment.
• Click Report on the menu bar, then select Report Properties.
  • Click OK after entering a new report name and description.
• Go to File > Save As.
  • Navigate to the directory:
    C:\ProgramData\Sage\Accounts\[year]\Company.000\Reports\Excel
  • Enter a new file name and click Save.
• To finish, go to File, then select Exit.

Open the report in Excel

• Navigate to the Sage 50 Accounts tab in Excel.
• Choose your company from the Recent Companies list.
• Select the desired report from the Report drop-down menu.
• Click Insert to add the report to your Excel sheet.

Also Read: How to Fix Sage CRM and Outlook Plugin Integration Issue?

How to Troubleshooting Excel integrated reporting?

• Use a compatible 32-bit version of Microsoft Office.
  
• Install the latest version of Sage 50 Accounts from the Install your software hub.
  
• Log in to Sage 50 Accounts and select the correct company.
  
• Ensure your Sage 50 Accounts user has access rights for Excel Integrated Reporting.
  
• Log into Windows using an administrator account.
  
• Adjust antivirus settings to allow Sage 50 Accounts to run without issues.
  
• Verify that Compatibility Mode is not selected for the Excel file.
  
• Press Ctrl + F1 in Excel to keep the ribbon visible.
  
• Select Trust access to the VBA project object model in Excel by going to Trust Center > Macro Settings.

To fix connection issues or error messages related to EIR, follow these steps:

• Close all open programs before starting.
• For your Sage 50 Accounts version, download the appropriate Excel Integrated Reporting (EIR) installer.

• For v27 or later, reinstalling the full Sage software also reinstalls EIR.
• For v26, download the ExcelIntReportingInstaller.msi file directly.
• When prompted, save the installer file.
  • Tip: The file may go to your Downloads folder by default. Press Ctrl + J to check.

• Double-click ExcelIntReportingInstaller.msi to start the installation.
• The installer will close automatically when finished.
• If the issue continues:

• Uninstall Excel.
• Uninstall Sage 50 Accounts.
• Reinstall Excel.
• Reinstall Sage 50 Accounts.
• Test EIR again.
• If you see the error “Could not connect to data service”:
  • Check your Firewall settings.
  • Make sure the correct ports and HIPS settings are enabled to allow Sage data service access.
  • Set ESET to Interactive Mode to help reset the connection.
  • For help with ESET HIPS, contact ESET support.

Also Read: Sage 50 Pos Integration

How to Export Data from Sage 50 to Excel?

To export data and reports from the Sage 50 accounting software into Microsoft Excel, follow the steps shared below:

• Launch the Sage 50 Accounts software.
• Locate and click the report you need to export.
• Select any one of the output options shared below:
  • Press the “Export” option and choose a save location. Now add a file name and the file type and then press the “Save” button.
  • Press the option, “Report to Excel”.
  • Press the option, “Data to Excel”.
• In case a “Criteria” screen appears, add the needed norms and then press the “OK” button.

Also Read: Sage 50 ODBC Driver Setup

How to Import Data into Sage 50 from Excel?

Here are the steps to import data into Sage 50 from Excel:

• Select the File menu. Now choose the “Import/Excel” option.
• Select the “Program area” and the import template.
• Press the “Import” option. The import template screen opens in Sage 50 with the “Field” tab active.
• Tick the box for every field added in the import file.
  • Make sure the order and number of fields are the same as the imported file.
• To rearrange the fields, choose the field and press the “Move” button. 
• Change to the “Options” tab.
• Press the arrow button to fix or modify the file name and path.
• Save the template settings by pressing the “Save” button. Add a special name and then press the “Save” option.
• Press the “OK” button to begin the import procedure.

Also Read: Sage 50 Microsoft Office 365 Integration Guide

Final Words

In this guide, complete information about Sage 50 Excel Integration has been shared. Information regarding the significance of Excel in financial and accounting reporting has been shared in this guide. In addition, the steps to perform Sage 50 Excel integration are shared in this guide.

Still, if there are certain doubts or specific queries regarding the topic, feel free to reach out to us. Call our team of Sage experts at +1-800-964-3096 and resolve your query at the earliest.

Frequently Asked Questions: