The ACCOUNTTURNOVER function calculates the turnover of one or more general ledger account(s) as of a given period.
ACCOUNTTURNOVER(Connection, Ledger, AccountClass, Account,
Subaccount, Branch, From, To, IncludeUnposted)
The name of the connection, as specified in the Connection Manager
Ledger to use in the calculation.
Optional, though required if Account is empty
The account class to use for the calculation.
Optional, though required if AccountClass is empty
The general ledger account(s) to use for the calculation.
The general ledger subaccounts(s) to include.
The branch(es) to include.
Beginning of the financial period, in MM-YYYY format
Cell reference to the beginning date
End of the financial period, in MM-YYYY format.
Cell reference to the ending date
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)
Given this data:
=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).
=ACCOUNTTURNOVER("Demo", "ACTUAL",, "10600", , , $C$4, $D$4)
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).
Limitations to filtering by date instead of financial period: