The Excel formula `I_EOL_CUT_CCE_BAL_YEAR_OPEN` retrieves the financial year opening balance in company currency matching the parameters from Exact Online.
Parameters:
- `divisionCode`: division code.
- `costUnitCode`: cost unit code or a range of cost units. See [[Cost Unit Range]].
- `costCentreCode`: cost centre code or a range of cost centres. See [[Cost Centre Range]].
- `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.
- `afterEntry`: after entry (`true`, default) or only closed periods (`false`).
Returns: financial year opening balance in company currency matching the parameters.