Scribd
Upload
32 views5 pages

44 - Customer Payment Track

The document is a customer payment tracker detailing outstanding and overdue invoices for various customers. It includes specific invoice information such as dates, amounts, payment status, and customer details. The total outstanding amount is -566715, while the total overdue amount is 960736.

Uploaded by

rajindere saini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
32 views5 pages

44 - Customer Payment Track

The document is a customer payment tracker detailing outstanding and overdue invoices for various customers. It includes specific invoice information such as dates, amounts, payment status, and customer details. The total outstanding amount is -566715, while the total overdue amount is 960736.

Uploaded by

rajindere saini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Customer Payment Tracker - Dynamic Track

Total Outstanding >> -566715 Total Overdue>>


960736

Invoice Invoice Date Customer Name Invoice Amount NOD


Num

101 10/1/2022 Customr AB 104000 861


102 10/3/2022 Customer JH 203147 859
103 10/5/2022 Customer EF 104500 857
104 10/5/2022 Customr AB 205147 857
105 10/6/2022 Customer IJ 50214 856
106 10/8/2022 Customer EF 147854 854
107 10/9/2022 Customer JH 145874 853
er - Dynamic Tracking of Invoice & Payments
Total Overdue>> -364214
398874 -566715 -4853
Payment Date of Paymnt Days Taken Due Amount CN/DN
Invoice Due Date Received Receipt Amt.
Amount
10/13/2022 -104000
11/2/2022 10/25/2022 22 -203147
11/4/2022 103000 -1500
10/17/2022 10/28/2022 23 -210000 -4853
10/27/2022 -50214
11/7/2022 150000 2146
11/8/2022 145874 0
0
0
0
0
0
nts -567361

Status of Invoice values logic

Overdue Paid due amount =0


Overdue Part. Paid pmt received>0,due amt<0
Part. Paid Excess Paid due amount>0
Overdue Due inv due date>current date
Overdue Overdue inv due date<current date
Excess Paid
Paid
Customer Master Record
Customer Name Address Credit Side Days
Customr AB Kathamandu 12
Customer CD Pokhara 35
Customer EF Nepalgunj 30
Customer JH Biratnagar 30
Customer IJ Damauli 21
Customer KL Bhaktapur 7
For Video Tutorial on This
Template click Youtube Logo

You might also like