SI.BUDGETTURNOVER
Modified on Tue, 19 Sep 2023 at 11:59 AM
Applies to:
- Velixo NX
- Sage Intacct
The SI.BUDGETTURNOVER function returns the budgeted balance turnover of a GL account (within the specified reporting period or between two dates).
TABLE OF CONTENTS
Syntax
SI.BUDGETTURNOVER(
Connection,
AccountGroup,
AccountCode,
BudgetId,
StartDate,
EndDate,
LocationId,
Books,
Dimensions,
UserDefinedDimensions, IncludeChildDimensionBalances)
Parameters
The SI. BUDGETTURNOVER function uses the following parameters:
Parameter | Required/ Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
AccountGroup | Optional if AccountCode is specified | The name of the account group for which to return the aggregated turnover |
AccountCode | Optional if AccountGroup is specified | The code of the general ledger account, or multiple account codes defined by a Velixo range expression |
BudgetId | Required | The budget ID |
StartDate | Required | The start date (inclusive) in YYYY-MM-DD format or A cell reference to a date |
EndDate | Required | The end date (inclusive) in YYYY-MM-DD format or A cell reference to a date |
LocationId | Optional unless the company has multiple base currencies | The ID of the entity or location |
Books | Optional | The reporting book or global consolidation book to be used for retrieving the balance. One or more user-defined adjustment book IDs may be included* |
Dimensions | Optional | Either:
For more in-depth information about filtering by Dimensions: see Using Dimensions
For user-defined dimensions, use the UserDefinedDimensions argument. |
UserDefined Dimensions | Optional | Either:
For predefined analytical dimensions like customer, project etc., use the Dimensions argument. |
IncludeChild Dimension Balances | Optional | True (Default) or False Determines if (for dimensions which have child dimensions) the balances of child dimensions are included in the calculation of the total balance. This parameter only affects balances if:
|
Books parameter:
If you leave the parameter blank, the default reporting book will be used (ACCRUAL or CASH depending on your company settings).
If you specify just one reporting or global consolidation ("GC") book, that's what will be used to retrieve balances.
If you specify more than one reporting / GC books (e.g. "ACCRUAL;GCBOOK") an error will be thrown - it is not allowed in Sage.
If you specify a reporting / GC book and one or more predefined/user-defined adjustment books (e.g. "ACCRUAL;TAX;GAAP") then you will retrieve balances from ACCRUAL plus any adjustments defined by each of the adjustment books.
Examples
Example 1
=SI.BUDGETTURNOVER(
"Sage",
,
"40000",
"MASTER",
"2022-05-01",
"2022-05-31",
"300",
"ACCRUAL",
$C$6:$D$8)
Description
Returns the budgeted turnover of the account "40000 - Revenue-Services" during May 2022, for entity "300" and budget "MASTER", in the Accrual book, for specific dimension values defined by the C6:D8 range (for example, Department and Employee).
Result
250 000

(this example uses cell references for some of the parameters)
Example 2 - Dimension Array
For examples of the use of a dimension array (available in version 2023.8 and higher), see : Example 2 - Dimension Array in the SI.OPENINGBALANCE function.
Example 3 - Empty Account Group
Assuming this configuration within Sage Intacct:
(note that no accounts are assigned to the Accumulated Depreciation account group)
=SI.BUDGETTURNOVER("Sage", "Accumulated Depreciation",,"2019-01-01","2019-12-31",
"100", "ACCRUAL")
Description
The various Velixo balance functions (SI.OpeningBalance, SI.Turnover, SI.ClosingBalance, and SI.BudgetTurnover) will return zero when there are no accounts assigned to the referenced account group.
Results
Example 4 - using Include Child Dimension Balances with Location
This function returns the Budget Turnover balance where the Dimensions and UserDefinedDimensions are not used, but where a Location is specified with the IncludeChildDimensionBalances parameter:
=SI.BUDGETTURNOVER("Sage", "Accumulated Depreciation",,"2019-01-01","2019-12-31", "100", "ACCRUAL",,TRUE)
e.g.,

Example 5 - Include Child Dimension Balances or not
Below are balances for a specific Location, where Dimensions and UserDefinedDimensions are not used.
Customer 10007 is defined as a child account of customer 10001.
In row 6, when excluding the balance for customer 10001, you can choose whether or not to also exclude the balance for child account 10007.
Note that rows 3 and 7 use two techniques (blank and "*") to achieve the same result.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article