Ravi Sir's Cards › Excel
Small Business Accounts Receivable System in Excel (card 2 of 2)
Revision card 2 for Small Business Accounts Receivable System in Excel: Balance: =G5-I5 gives ₹12,700; Received: =SUMIFS(Receipts!$D$5:$D$5000,Receipts!$C$5:$C$5000,A5) gives ₹5,000; Days overdue: =IF(J5<=0,0,MAX(0,Setup!$B$3-H5)) gives 114. Includes an example data table.
Read card text
What this card says
2 for Small Business Accounts Receivable System in Excel: Balance: =G5-I5 gives ₹12,700
Received: =SUMIFS(Receipts!$D$5:$D$5000,Receipts!$C$5:$C$5000,A5) gives ₹5,000
Days overdue: =IF(J5<=0,0,MAX(0,Setup!$B$3-H5)) gives 114. Includes an
Example
data table
Learn this in the lesson: Small Business Accounts Receivable System in Excel: Invoices, Part Payments, Due Dates, Ageing Buckets, Credit Limits and Statement