I have looked at your file and have no idea what you hope to achieve. Suggest you explain in the forum thread exactly what you want. Step by step if you were to do this manually. We are here to help, but we need to understand you issues. All details of each loan needs to be explained as it is not obvious as shown.
With same vendor I procure material multiple times and payment terms is 5 days from each supplies date. But I pay him as per available cash balance to me. So I want to know how much is due to vendor on a particular date
@Rahulshwale1: Hi, payment gets due(N+1) from the date of supplies i.e If a material is delivered on 2nd then it will get due on 7th but not on 2nd @AlanSidman : Hi, format would remain the same, could you please accodingly