Formula question

[Alteryx_1505]

I have a spreadsheet that looks like the input below. I would like to create a workflow that will create the output below. I having issues grasping how I would create a formula to condense identical accounts into a total and have it show both the debit, credit and the  balance column. Any help would be appreciated. 

[binuacs · Accepted solution]

@Alteryx_1505 one way of doing this