The SI.BUDGETTURNOVER function returns the budgeted balance turnover of a GL account (within the specified reporting period or between two dates).

Syntax

SI.BUDGETTURNOVER(
Connection,
AccountGroup,
AccountCode,
BudgetId,
ReportingPeriodName,
StartDate,
EndDate,
LocationId,
ReportingBook,
Dimensions,
UserDefinedDimensions)

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

ReportingPeriodName

Optional if both StartDate and EndDate are specified

The reporting period name.

⚠️ Attention: the "dynamic" reporting period names like "Today" or "Last Month" are not supported due to limitations in Sage Intacct's API.

StartDate

Optional if ReportingPeriodName is specified

The start date (inclusive)

EndDate

Optional if ReportingPeriodName is specified

The end date (inclusive)

LocationId

Optional unless the company has multiple base currencies

The ID of the entity or location

ReportingBook

Required

The reporting book ID ("ACCRUAL", "CASH", or a user-defined book)

Dimensions

Optional

A two-column Excel range, where the first column contains the name of a predefined analytical dimension (e.g. department, customer, project etc.), and the second column contains the respective value / Velixo range expression for that dimension. For user-defined dimensions, use the UserDefinedDimensions argument.

UserDefinedDimensions

Optional

A two-column Excel range, where the first column contains the name of a user-defined analytical dimension, and the second column contains the respective value (or a semicolon-separated list of values) for that dimension. For predefined analytical dimensions like customer, project etc., use the Dimensions argument.

Example

=SI.BUDGETTURNOVER(
"Demo",
,
"40000",
"MASTER",
"Month Ended May 2022",
"300",
,
,
"ACCRUAL",
$C$6:$D$8)

Description

Returns the budgeted turnover of the account "40000 - Revenue" during May 2022, for entity "300" and budget "MASTER", for specific dimension values defined by the C6:D8 range (for example, Department and Employee).

Result

$250 000

Applies to

  • ⚠️ Velixo NX only

  • ERP: Sage Intacct

Did this answer your question?