BC.CLOSINGBALANCE

Overview

The BC.CLOSINGBALANCE function returns the closing (ending) balance of a GL account (at the end of the specified reporting period or date).

To return the opening balance of a GL account, use the BC.OPENINGBALANCE function.

CODE

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

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.

CODE

=BC.CLOSINGBALANCE(
    "BC",
    "11110",
    ,
    ,
    "2025-1-31"
)

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

Result: