ACCOUNTTURNOVER function
Applies to
Velixo Classic
Velixo NX
Acumatica, MYOB Acumatica, Cegid XRP Flex
GL Module
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, StartPeriodOrDate, EndPeriodOrDate, IncludeUnposted, UseMasterFinancialCalendar)
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. Note: when used with Budget ledgers, the ACCOUNTTURNOVER function returns only released budget data |
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. |
StartPeriodOrDate | Required | The beginning financial period, in MM-YYYY format or a reference to a cell containing the beginning date in a valid Excel date format |
EndPeriodOrDate | Required | The ending financial period, in MM-YYYY format. or a reference to a cell containing the ending date in a valid Excel date format |
IncludeUnposted | Optional | 1 - Include posted transactions only (default) 2 - Include Unposted transactions only 3 - Include Posted and Unposted transactions (notes:
Excel for Windows allows the use of quotation marks around this parameter. Excel for Mac and Excel Online require that it be unquoted. |
| Use Master Financial Calendar | Optional | Use Acumatica's Master Financial Calendar instead of the financial calendar defined within the specific tenant associated with the connection being accessed (this can be useful for consolidation reports). Possible values:
|
Examples
Given this data:
Example - Posted transactions for an account
=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 - Posted and Unposted transactions
=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
 |
Example - Released budget values
=ACCOUNTTURNOVER("Demo", "BUDGET",, "10600", , "*", "12-2019", "12-2019")
Description: Retrieves the released value in the Budget ledger for General Ledger account #10600 for all branches for period 12-2019 Result: 493,710 Cell references were used for parameters in this example Note: Any UN-released budget values (as shown on the ERP's Release Budgets screen) will *NOT* be reflected in the balance. Only released budget values can be retrieved. |
Limitations to filtering by date instead of financial period
|
