The SI.CLOSINGBALANCE function returns the closing balance of a GL account (at the end of the specified reporting period or date).
The SI.CLOSINGBALANCE function uses the following parameters:
The name of the connection as configured in the Connection Manager
Optional if AccountCode is specified
The name of the account group for which to return the aggregated closing balance
Optional if AccountGroup is specified
The code of the general ledger account, or multiple account codes defined by a Velixo range expression
The start date (inclusive) in YYYY-MM-DD format or A cell reference to a date
The end date (inclusive) in YYYY-MM-DD format or
A cell reference to a date
Optional unless the company has multiple base currencies
The ID of the entity or location
The reporting book ID ("ACCRUAL", "CASH", or a user-defined book)
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 semicolon-separated list of values or that dimension. For user-defined dimensions, use the UserDefinedDimensions argument.
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.
Returns the closing balance of the account "40000 - Revenue" at the end of May 2022, for entity "300", filtered down by dimensions specified in the C6:D8 range (for example, by Department and Employee).
$124 025 522.12
⚠️ Velixo NX only
ERP: Sage Intacct