How to use Alteryx to prepare a Current Transactions calculator ? (like an Amortization)

[Mackenzie_1]

The calculator should calculate the closing balance of each account using the interest rate, transactions, accrued amount and monthly capitalised interest. The date period for transactions is between 23 Jan 2022 to 31 March 2022. This current workflow exports the interest accrual and imports it to use to calculate the Cumulative interest per day (Test Cumulative). The Test cumulative is used to calculated the monthly capitalised interest which is used to calculated the final opening balance. Is this calculation accurate in calculating the opening balance? And if not, what tools can be used to improve this?

I've linked the workflow below.

[oly]

Hi @Mackenzie_1 ,

could you please provide Interest Accrual file that you are using as an input? 

Thank you,

Oly