Outstanding Payment Excel Sheet Template

Features: 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)