ACCOUNTTURNOVER function

Created by Harry Lewis, Modified on Fri, 09 Feb 2024 at 05:06 PM by Harry Lewis

Applies to

Velixo Classic
Velixo NX
Acumatica, MYOB Advanced, 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.

TABLE OF CONTENTS

Syntax
Parameters
Examples

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.
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	Beginning of the financial period, in MM-YYYY format or the beginning date in a valid Excel date format
EndPeriodOrDate	Required	End of the financial period, in MM-YYYY format. or 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: Transactions with a status of "On Hold" are excluded. When Unposted transactions are included, the following two statuses are included: Balanced, Unposted If a document is still in the AR module (e.g., Invoice), the corresponding GL batch has not yet been created, thus the balance for that document will not be reflected). 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: True False (default)

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

This feature cannot be used with the Net Income account
Drilldown will show transactions for the entire financial period (you will then need to manually filter on the date column)
Balances are calculated based on the total from the nearest financial period, and then adjusted based on the filtered transaction date
Balances will not reflect transactions within the specified date range but which have been posted to a different financial period.