If you want to have Debit & Credit as separate columns, then you can use the following table. It uses a temporary column (hidden) to get Debit & Credit in one column:
@SK209 I think this solution is awesome! The only thing that is remaining is the ability to make a RowId based on Payment Date. This is because I want to be able to have the Rows ordered by Payment Date, and have all the balance logic around that.