BC.OPENINGBALANCE

Overview

The BC.OPENINGBALANCE function returns the opening (beginning) balance of a GL account (at the beginning of the specified reporting period or date).

This function requires the AL Language extension for Microsoft Dynamics 365 Business Central

To return the closing balance of a GL account, use the BC.CLOSINGBALANCE function.

Syntax

CODE

=BC.OPENINGBALANCE(
    ConnectionName,
    Account,
    AccountCategory,
    AccountSubcategory,
    AsOf,
    Dimensions
)

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Account`	Optional if `AccountCategory` or `AccountSubcategory` is specified	The code of the general ledger account, a spill range, or a cell range containing account codes. For example, `10100`, `A1:A10` or `A1#`
`AccountCategory`	Optional if `Account` or `AccountSubcategory` is specified	One or more account category names, visible in the Business Central Chart of Accounts. The following values are accepted: `Assets`, `Liabilities`, `Equity`, `Income`, `Cost of Goods Sold`, `Expense`
`AccountSubcategory`	Optional if `Account` or `AccountCategory` is specified	One or more account subcategory names
`AsOf`	Required	Balances will be calculated as of this date
`Dimensions`	Optional	A two-column Excel range where the first column contains the name of a dimension and the second column contains a semicolon-separated list of values for that dimension You can specify dimension values using ranges, wildcards, and other techniques.

Examples

Opening balance for a single account

CODE

=BC.OPENINGBALANCE(
    "BC",
    "11110",
    ,
    ,
    "2025-1-1"
)

Description: Returns the opening balance of the account “11110” at the beginning of January 2025.

Result: