Method 1 :
Use PivotTable operation.
Method 2 :
1. Make a copy of the data entry sheet.
2. Sort the data based on column Accounts, then by column Date.
3. Do Subtotalling operation.
4. You can collapse/ expand the subtotal tree.
5. You can delete the sheet because you can rebuild easily.