The Excel formula `I_EOL_BAL_YEAR` retrieves the total financial year balance in company currency of transaction lines matching the parameters from Exact Online. Parameters: - `divisionCode`: division code. - `reportingYear`: financial year. - `glAccountCode`: a general ledger account code or a range of general ledger accounts. See [[General Ledger Account Range]]. - `glAccountType`: general ledger account type. - `balanceType`: type of balance. - `afterEntry`: after entry (`true`, default) or only closed periods (`false`). Both balance sheet as P&L transaction lines will be selected by default. Opening balances are not included. Returns: total financial year balance in company currency of transaction lines matching the parameters.