HomeMy WebLinkAbout14 Attachment 1 AR Aging Report 20210201 as of 1/1/2021 30 Days 60 Days 90 Days
#Customers 723 E +59 to last mth 313 E +40 to last mth 194 E +13
#Customers 495 W +11 to last mth 205 W +34 to last mth 133 W +13
Average $ Past Due per Past Due Customer 30 / 60 /90 : $273 / $220 / $804
~4.5% of customers are 30 Days Past Due, 1.9% 60 Days, and 1.2% 90+Days.
The $131,505 past due 90+days 2/1/2021 represents 0.4% of Mar. thru Dec. billings.
The $354,496 past due 30+days 2/1/2021 represents 1.1% of Mar. thru Dec. billings. (Jan. billings not pastdue asof 2/1)
Metric reference: $500,000 equates to 1.2% of 2020 Budget annual revenues of $41.2m.
90+Days balance split:
E 89,869 68%
W 41,636 32%
Total 131,505 100%
11% of 90+$ is Commercial
89% of 90+$ is Residential
Of Residential 90+days, Electric: %c / %$
Primary 68% / 79%
Secondary 32% / 21%
For Commerical 90+, it is essentially about
10 accounts (top 4 are restaurants)
$295 credit relief per relief customer average
<'Dec. includes 41 customer qualifying for 2yr
Payment Assist. Credit
354,496
166,004
56,986
131,505
46,741
29,976
4,876 11,889
111,025
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
TL Past Due 30Days 60 Days 90Days
Accounts Receivable - Past Due Totals (Electric & Water Total) - Comparative
2/1/2021 1/1/2021 12/1/2020 11/1/2020 10/1/2020 9/1/2020
8/1/2020 7/1/2020 6/1/2020 5/1/2020 2/1/2020
2/3/2021 10:49 AM
\\nasdataserver\users\michaels\My Documents\AR Aging Reports FEBRUARY