BC.TURNOVER

Overview

The BC.TURNOVER function returns the balance turnover of one or more GL accounts between two dates.

CODE

=BC.TURNOVER(
    ConnectionName,
    Account,
    AccountCategory,
    AccountSubCategory,
    FromDate,
    ToDate,
    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` Supports Velixo range expressions for specifying values.
`AccountSubcategory`	Optional if `Account` or `AccountCategory` is specified	One or more account subcategory names Use the BC.EXPANDACCOUNTSUBCATEGORYRANGE function to retrieve available subaccount names. Supports Velixo range expressions for specifying values.
`FromDate`	Required	The inclusive start date in YYYY-MM-DD format or a cell reference to a date
`ToDate`	Required	The inclusive end date in YYYY-MM-DD format or a cell reference to a 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 The dimension values can be specified using ranges, wildcards, and other techniques.

CODE

=BC.TURNOVER(
    "BC",
    "11110",
    ,
    ,
    ,
    ,
    "2024-1-1",
    "2024-3-31"
)

Description: Returns the turnover for the account “11110” in Q1 2024.

Result:

CODE

=BC.TURNOVER(
    "BC",
    D1:D10,
    ,
    ,
    ,
    ,
    "2024-1-1",
    "2024-3-31"
)

Description: Returns the turnover for the account numbers in cells in the range from D1 to D10 in Q1 2024.

Result:

CODE

=BC.TURNOVER(
    "BC",
    D1#,
    ,
    ,
    "2024-1-1",
    "2024-3-31"
)

Description: Returns the turnover for accounts listed in the spill range beginning with cell D1 in Q1 2024.

Result: