Features:
- S.No.
- Invoice Date
- Due Date
- Customer / Party
- Invoice No.
- Invoice Amount
- Paid Amount
- Outstanding Amount
- Days Overdue
- Payment Status
- Due Status
- Priority
- Last Payment Date
- Remarks
Formulas :
S.No.
=IF(D5=””,””,ROW()-4)
Outstanding Amount
=IF(F5=””,””,MAX(F5-G5,0))
Days Overdue
=IF(OR(C5=””,H5<=0),””,MAX(TODAY()-C5,0))
Payment Status
=IF(H5<=0,”Paid”,IF(G5>0,”Partially Paid”,”Unpaid”))
Due Status
=IF(H5<=0,”Closed”,IF(C5<TODAY(),”Overdue”,IF(C5=TODAY(),”Due Today”,”Not Due”)))
Invoice Count
=COUNTIF(‘Outstanding Payments’!J5:J998,D4)
Outstanding Amount
=SUMIF(‘Outstanding Payments’!J5:J998,D4,’Outstanding Payments’!H5:H998)
