# SI.EXPANDACCOUNTSINGROUP  return child account groupings by account group

**URL:** <https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58>\
**Category:** Ideas & Feature Requests\
**Tags:** Sage-Intacct\
**Created:** [May 13, 2024, 3:27pm UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58 "2024-05-13T15:27:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tom\_Roberts](https://community.velixo.com/letter_avatar_proxy/v4/letter/t/ce73a5/32.png) [@Tom\_Roberts](https://community.velixo.com/u/Tom_Roberts)\
**Post date:** [May 13, 2024, 3:27pm UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58/1 "2024-05-13T15:27:01Z")

</div>

We have a number of nested account groups it would be useful to have SI.EXPANDACCOUNTSINGROUP or a similar function return an array which shows the nested names and account numbers.

Example:

Lets say we have an account group Revenue, it is comprised of two account groups Contributions and Registration.  
Revenue: Contributions , Registration  
Contributions: 40000,40010,40020,40030  
Registration: 40060,4007

Current function of SI.EXPANDACCOUNTSINGROUP(connection,“Revenue”) would return all of the account numbers:

| 40000 |
| --- |
| 40010 |
| 40020 |
| 40030 |
| 40060 |
| 40070 |

What would be helpful to get is an array like the below:

| Revenue | Contributions | Registration |
| --- | --- | --- |
| 40000 | 40000 | 40060 |
| 40010 | 40010 | 40070 |
| 40020 | 40020 | |
| 40030 | 40030 | |
| 40060 | | |
| 40070 | | |

This could be done with SI.EXPANDACCOUNTSINGROUP with a parameter flag like [expand child groups] or as a separate function

=== Please type above and preserve the below information ===

Name: Roberts, Tom

Excel version: PC 16.0.17328.20282

Connection: MADD

_This idea had 2 votes on the previous Velixo community._

---

<div class="post-metadata">

**Author:** ![Damien](https://community.velixo.com/user_avatar/community.velixo.com/damien/32/196_2.png) [@Damien](https://community.velixo.com/u/Damien)\
**Post date:** [May 22, 2024, 2:45am UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58/2 "2024-05-22T02:45:36Z")

</div>

Thanks Tom!

I have moved your Topic to the Sage Intacct forum.

That is an interesting idea. We have had similar requests for expanding one Account group to its descendants (groups and/or accounts), but this idea is new. We will consider it!

---

<div class="post-metadata">

**Author:** ![Allison](https://community.velixo.com/letter_avatar_proxy/v4/letter/a/90db22/32.png) [@Allison](https://community.velixo.com/u/Allison)\
**Post date:** [November 18, 2024, 5:44am UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58/3 "2024-11-18T05:44:22Z")

</div>

This would be really helpful!

---

<div class="post-metadata">

**Author:** ![Damien](https://community.velixo.com/user_avatar/community.velixo.com/damien/32/196_2.png) [@Damien](https://community.velixo.com/u/Damien)\
**Post date:** [March 31, 2025, 11:45pm UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58/4 "2025-03-31T23:45:38Z")

</div>

Hi Tom. Coming back to this one. How would you use such array in a report? How would you reference these cells?

Would it make more sense to expand those account groups and accounts into a single column instead but indent them to give clues about their hierachical level? (and we could look at parsing the indentations and truncating the spaces when these values are referenced in other functions such as Turnover)

The same requirement exists for hierarchical dimensions.

---

<div class="post-metadata">

**Author:** ![Tom\_Roberts](https://community.velixo.com/letter_avatar_proxy/v4/letter/t/ce73a5/32.png) [@Tom\_Roberts](https://community.velixo.com/u/Tom_Roberts)\
**Post date:** [April 1, 2025, 12:23am UTC](https://community.velixo.com/t/si-expandaccountsingroup-return-child-account-groupings-by-account-group/58/5 "2025-04-01T00:23:51Z")

</div>

Use case as presented would let us change account groups within Sage Intacct and have those changes be reflected in Velixo reports under the correct sub account groups automatically. We also have a large number of nested account groups and being able to quickly identify what roll up levels exists would be very helpful as it would let us build reports knowing each roll up level. without having to constantly cross check account groups within Sage Intacct to see what rolls into what. This adds additional dynamic options to our report creation capabilities.

As for indenting, it would hurt more than it would help in my specific case. My current solution for this is a massive list of each account group expanded one by one and a lot of index matching. For some reporting needs we may have one account appear in multiple different account groups. Indenting would make this problematic as it would likely result in duplicative info.