Skip to main content
Skip table of contents

BC.TURNOVER

Overview

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

Syntax

CODE
=BC.TURNOVER(
    ConnectionName,
    Account,
    AccountCategory,
    AccountSubCategory,
    FromDate,
    ToDate,
    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

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.

Examples

Turnover for a single account

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


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

Result:

image-20250625-065631.png


Turnover for a range of accounts

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:

image-20250625-150113.png


Turnover for a accounts in a spill range

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:

image-20250625-150307.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.