The Excel formula `I_EOL_CCE_BAL_PDE_CLOSE` retrieves the total period balance in company currency of transaction lines matching the parameters from Exact Online, including opening balance. Parameters: - `divisionCode`: division code. - `costCentreCode`: cost centre code or a range of cost centres. See [[Cost Centre Range]]. - `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** included. Returns: total period balance in company currency of transaction lines matching the parameters.