Cumulative Balances Function
Updated over a week ago


Fetch cumulative account balances from your Bkper book. Gives you cumulative account balance value related to a time range.

=BKPER_BALANCES_CUMULATIVE(bookId, cache, query, expanded, transposed, hideDates)

Sample usage

=BKPER_BALANCES_CUMULATIVE("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, “group:'Assets' after:01/2016 before:01/2017”, TRUE, TRUE, FALSE)

Explaining the syntax:

  • bookId: string - The universal Book Id.

  • cache: number - Cache-control. Increase to clean cache and force fetch update.

  • query: string - The query.

  • expanded: TRUE, FALSE or number - Expand group tree. True to expand itself, -1 to expand all subgroups. -2 to expand all accounts. Any number to expand up to a specific level

  • transposed: TRUE or FALSE - Transpose the result

  • hideDates: TRUE or FALSE - Hide dates row/column

- The result is ordered by account names.
- With Asset and Liability account types, the balance value of the previous period is considered.
- With Incoming and Outgoing account types the balance value starts at 0 and accumulate over the fetched period.
- Useful for Balance Sheets

Did this answer your question?