If the first month calculation is correct and subsequent months are wrong, are you saying that you want a compound interest formula? (i.e. in month 2 you calculate interest on principle + previous months’ interest)
toal = deposit_amount * (rate_of_interest*30/365)**month_number
1
solved How to do recurring deposit calculations accurately [closed]