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
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
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
    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
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
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
image-20250429-110834.png

  • The resulting data will show in the spreadsheet.



Open image-20250429-110841.png
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
    image-20250429-110855.png

 


  • Select the iplicit category, then the select the Custom function required. Then press OK.

    Open image-20250429-110903.png
    image-20250429-110903.png

 


  • Enter the appropriate arguments for the function, then press OK.

    Open image-20250429-110911.png
    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.