chart of accounts and general ledger

I’m looking forward to achieve something like in the image attached.

I was thinking of using tree component and the hierarchical structures available in cuba platform.

Each child account should display it’s balance, also the parents accounts should sum the total of each child.

any suggestions for a best practice approach for this?
I was looking for an example but still haven’t seen any.

I’ve attached also the data model design.


Screenshot 2017-08-21 10.45.21

Have you seen the TreeTable component? It represents hierarchical structures exactly as you need.

Regarding balance value: you could store it in the Account entity and recalculate in entity listeners for the Entry entity.