Inserting a name will hardcode the name into the spreadsheet whereas inserting opening and closing balance will insert the INFLO.BALANCE formula into the cell and calculate the result. For Word documents, the data will be inserted as text in the document based on the INFLO.BALANCE inputs.
The formula can either be inserted using the link icon, via a custom InfloLink modal which appears through the right-click menu or in the case of Excel by typing the formula into a cell as you would with a normal Excel formula (this includes using the insert formula function).
The InfloLink Add-In will also add custom Inflo formulas to be used in the Excel spreadsheet (or via the custom modal in Word), these are:
COMPANY NAME
This will pull the Company name from the engagement set up.
=INFLO.COMPANYNAME (Environment, EngagementId)
Environment – This will be an input of the environment that the engagement the user wishes to use is in. for example “EMEA”, “US”, “APAC”, etc. The environment can be found in the address bar when in Inflo and will be the letters after https:// and before the full stop.
EngagementId – This will be the engagement ID for the engagement the user wants to pull data from. This can be found in the address bar of Inflo when in the engagement and in brackets next to the engagement name in the drop down in the InfloLink panel.
YEAR START
This will pull the period start date of the financial year of the audit.
=INFLO.YEARSTART(Environment, EngagementId)
Environment – This will be an input of the environment that the engagement the user wishes to use is in. for example “EMEA”, “US”, “APAC”, etc. The environment can be found in the address bar when in Inflo and will be the letters after https:// and before the full stop.
EngagementId – This will be the engagement ID for the engagement the user wants to pull data from. This can be found in the address bar of Inflo when in the engagement and in brackets next to the engagement name in the drop down in the InfloLink panel.
YEAR END
This will pull the period end date of the financial year of the audit.
=INFLO.YEAREND(Environment, EngagementId)
Environment – This will be an input of the environment that the engagement the user wishes to use is in. for example “EMEA”, “US”, “APAC”, etc. The environment can be found in the address bar when in Inflo and will be the letters after https:// and before the full stop.
EngagementId – This will be the engagement ID for the engagement the user wants to pull data from. This can be found in the address bar of Inflo when in the engagement and in brackets next to the engagement name in the drop down in the InfloLink panel.
CURRENCY
This will pull the currency used by the engagement. For example GBP, USD, etc.
=INFLO.CURRENCY(Environment, EngagementId)
Environment – This will be an input of the environment that the engagement the user wishes to use is in. for example “EMEA”, “US”, “APAC”, etc. The environment can be found in the address bar when in Inflo and will be the letters after https:// and before the full stop.
EngagementId – This will be the engagement ID for the engagement the user wants to pull data from. This can be found in the address bar of Inflo when in the engagement and in brackets next to the engagement name in the drop down in the InfloLink panel.
BALANCE
This is the main formula which will be the result of each link and can be added on its own.
=INFLO.BALANCE(Environment, EngagementId, PhaseName, Period, BalanceType, Level, Name, [ParentName])
Environment – This will be an input of the environment that the engagement the user wishes to use is in. for example “EMEA”, “US”, “APAC”, etc. The environment can be found in the address bar when in Inflo and will be the letters after https:// and before the full stop.
EngagementId – This will be the engagement ID for the engagement the user wants to pull data from. This can be found in the address bar of Inflo when in the engagement and in brackets next to the engagement name in the drop down in the InfloLink panel.
PhaseName – This will be an input to determine which phase of ingested data the user requires. The options will be “Planning”, “Fieldwork” and “Completion”.
Period – This will determine the period that the user would like to pull the data from. The options will be “Prior” and “Current”. These will decide whether it is opening or closing balances that pull through.
BalanceType – This will determine if the amount is taken from the "Original" Trial Balance, the "Adjustments" or the "Adjusted" Trial Balance.
Level – This will determine at which level in the Chart of Accounts the user wants the data to pull from. The options would be “Classification”, “Category”, “Subcategory”, “Account”.
Name – This will determine which item the user would like to receive the information for. If there is more than one item with the same name the formula will add the total of all of these items. Account accepts either Account name or Account code.
[ParentName] – This is an optional input which allows the user to restrict the result to only those Level and Name fall under the defined parent. The use case for this will be when subcategories or accounts have duplicate names across the engagement, and therefore the user wants to decide to take them all, or just a single grouping under the defined parent.
