Description
The ACCOUNTTURNOVER function calculates the turnover of one or more general ledger account(s) as of a given period.
This is particularly useful for creating YTD, MTD, or QTD reports.
Syntax
ACCOUNTTURNOVER(Connection, Ledger, AccountClass, Account,
Subaccount, Branch, From, To, IncludeUnposted)
Parameters
The ACCOUNTTURNOVER function uses the following parameters (see our articles on Filtering Velixo Functions and using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Ledger | Required | Ledger to use in the calculation. |
AccountClass | Optional, though required if Account is empty | The account class to use for the calculation. |
Account | Optional, though required if AccountClass is empty | The general ledger account(s) to use for the calculation. |
Subaccount | Optional | The general ledger subaccounts(s) to include. |
Branch | Optional | The branch(es) to include. |
From | Required | Beginning of the financial period, in MM-YYYY format or Cell reference to the beginning date |
To | Required | End of the financial period, in MM-YYYY format. or Cell reference to the ending date |
IncludeUnposted | Optional | 1 - Include posted transactions only (default) 2 - Include Unposted transactions only 3 - Include Posted and Unposted transactions* (note: Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted). Excel for Windows allows the use of quotation marks around this parameter. Excel for Mac and Excel Online require that it be unquoted. |
Examples
Given this data:
Example #1
=ACCOUNTTURNOVER("Demo", "ACTUAL",, "10700", , , "01-2019", "01-2019")
Description: Calculates the turnover of all posted transactions to General Ledger account #10700 (as noted in cell B8) during the first financial period of year 2019 (as noted in cell G1).
Result: 54,873
Example #2
=ACCOUNTTURNOVER("Demo", "ACTUAL",, "10600", , , $C$4, $D$4, 3)
Description: Calculates the turnover of all posted and unposted transactions to General Ledger account #10600 (as noted in cell B7) between January 1, 2019 (as noted in cell C4) and January 15, 2019 (as noted in cell D4).
Result: 3,325
Limitations to filtering by date instead of financial period:
|
Applies to
GL Module