• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Payment due date wise based on payment terms

Hi,

I have attached the file, wherein, I want to reflect payment based on payment terms

Please refer the attached file

Regards
Neeraj Kumar Agarwal
 

Attachments

  • Book15.xlsx
    9.3 KB · Views: 6
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.
 
Thanks for your reply!!

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

Hope it clarifies
 
I would set up the worksheet as shown below.
vABCDEF
1Opening BalanceDateInvoiceDate DuePaymentBalance
21000004/1/20201000090000
34/2/2020200004/7/2020110000
44/3/20202000090000
54/4/2020400004/9/2020130000
64/8/202020000110000
74/10/20204000070000

vABCDEF
1Opening BalanceDateInvoiceDate DuePaymentBalance
210000043922=IF(C2<>"",B2 +5,"")10000=A2+C2-E2
34392320000=IF(C3<>"",B3 +5,"")=F2+C3-E3
44392420000=F3+C4-E4
54392540000=B5+5=F4+C5-E5
64392920000=F5+C6-E6
74393140000=F6+C7-E7
 
@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
 
Your data is not normalized and as such, I will not spend any more time on a spreadsheet that is not set up for easy analysis. Good Luck with finding a solution.
 
Back
Top