How to set up and use Excel Add-in

Created by Dan Moore, Modified on Tue, 29 Apr at 12:20 PM by Rita Goncalves

Using the Excel Add-In options, enables you to extract various results from your iplicit environment so that bespoke Excel reports can be created.

The iplicit Excel add-in is available on the following platforms:

Office on Windows (version 1904 or later, connected to Office 365 subscription)
Office on Mac (version 16.24 or later, connected to Office 365 subscription)
Office on web browser

Note: Excel custom functions are currently not supported on iPad or in one-time purchase versions of Office 2019 or earlier.

Important: All Excel Custom Functions require permissions for the User to run them from the Excel Add-in. Users must have the User role "Excel Functions All".

Open image-20250429-110723.png

Existing User roles GL: Financial Statements and Financial Statement: Fiscal will inherit settings from the Excel Functions All role.

How to setup Excel Add-In

Setting up Excel Add-In

Setting the Excel Add-In for the first time -

Open a session of Excel.
On the Home menu bar, select the Add In icon.

Open image-20250429-110738.png

On the Popular Add-ins popup, select the + More Add-ins button that shows at the bottom of the popup.

On the Office Add-ins popup, enter iplicit in the search box, then select Add against the iplicit option.
Open image-20250429-110802.png

Agree to the Terms and Conditions, then you will get a notification that the iplicit Add-in has loaded successfully.
There will now be an iplicit logo on the Home menu bar.

Selecting this iplicit logo will now enable you to log into your iplicit environment.

Open image-20250429-110820.png

How to use Excel Add-In

Once the iplicit Excel Add-In has been added to your Excel session, various options are displayed in a new column displayed on the right of your spreadsheet.

Open image-20250429-110828.png

Each option, when selected with your requirements e.g. Legal entity, will pull the appropriate data from your iplicit environment, and display the results in the spreadsheet.

For example:

Select Legal Entities option.
Enter Legal entity in resulting popup.

Open image-20250429-110834.png

The resulting data will show in the spreadsheet.

Open image-20250429-110841.png

To create your own bespoke report, there are Custom functions that can be used directly in a spreadsheet report.

To add one of these functions to your spreadsheet, e.g. IP.GLBaseAmount.

Open a spreadsheet (or a report that you wish to add a Custom function)
In the cell where the result is to go, select the fx option.
Open image-20250429-110855.png

Select the iplicit category, then the select the Custom function required. Then press OK.
Open image-20250429-110903.png

Enter the appropriate arguments for the function, then press OK.
Open image-20250429-110911.png

The resulting value will then show in your selected cell.

Warning: If the User does not have the correct permissions to use Excel Add-ins then a warning message saying You do not have permission to use iplicit Excel functions will appear instead.