Skip to main content

Excel Add-in with Sage 200 UK

The Excel Add-in allows you to access, analyze, and refresh Sage 200 UK data directly from within Excel using the Nectari reporting platform. Configuring the add-in with the Sage 200 UK template lets you connect to the correct data models, environments, and workbooks, enabling smooth reporting and interactive data analysis within Excel.

Prerequisites​

Prerequisites

Before you start, ensure you have:

  • Nectari Excel Add-in: A supported version installed.

Benefits of Nectari Excel Add-in​

  • Performing ad-hoc analysis: Create or modify financial reports and dashboards directly in Excel using live data.
  • Refreshing data instantly: Update Excel with the latest Sage 200 UK data from Nectari without manual export or import steps.

Log in to Nectari Excel Add-in​

  1. Go to Packages\Templates\Templates - Official\20XX Release X\Sage 200UK\Excel Add-In.
  2. Open the Sage 200 UK - SEI Financials V1 Excel file. The Login dialog appears.
  3. (Optional) Enter your domain name if required.
  4. Select your Language using the dropdown list in the top corner.
  5. Enter your username for a valid Nectari profile.
  6. Enter your password.
  7. (Optional) Select Keep me signed in to remain connected after closing Excel.
  8. Click Login.

Map environments in Excel​

Map a data model from one Central Point to a data model in another Central Point environment.

  1. Click the Add-ins tab and select Environment Configurations.
  2. In the Workbook's Configuration section (left), select the environment you want to map.
  3. In the Available environments section (right), select the environment to map to.
  4. Click Save and confirm when prompted.
  5. Click Close when done.
note

Select Sync if you use DataSync as your source; use Live if you do not.

Map data models​

Map a data model from one Central Point to a data model in another Central Point environment.

  1. In the Add-ins tab, click Environment Configurations.
  2. In the Workbook's Configuration section (left), select the data model you want to map such as Nominal Ledger Financial Reports.
  3. In the Available data models section (right), select the matching data model to link such as Nominal Ledger.
    Data models already mapped display as selected.
  4. Click Save and confirm when prompted.
  5. Click Close when done.

Fill in the input fields​

  1. In the Main Menu sheet, enter the required data in each field of the table.
  2. In the Add-ins tab and click Refresh Formulas to update your workbook with the latest data and calculations.