The Excel formula `I_EOL_CCE_BAL_PDE` retrieves the total period balance in company currency of transaction lines matching the parameters from Exact Online. Parameters: - `divisionCode`: division code. - `costCentreCode`: cost centre code or a range of cost centres. See [[Cost Centre Range]]. - `reportingYear`: financial year. - `reportingPeriod`: financial period. - `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 period balance in company currency of transaction lines matching the parameters.