The Excel formula `I_EOL_BAL_PDER` retrieves the total multi-period balance in company currency of transaction lines matching the parameters from Exact Online. Parameters: - `divisionCode`: division code. - `reportingYear`: financial year. - `reportingPeriodFrom`: financial period from. - `reportingPeriodTo`: financial period to. - `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 multi-period balance in company currency of transaction lines matching the parameters.