The Excel formula `I_EOL_BAL_YEAR_CLOSE` retrieves the financial year closing balance in company currency 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`). Returns: financial year closing balance in company currency matching the parameters.