HomeMy WebLinkAboutAR Aging Report 20220501Accounts Receivable - Past Due Totals (Electric & Water Total) - Comparative
$700,000
$600,000 583,065
$500,000
451,896
$400,000
$300,000
$200,000 193,
$100,000
$0 M■ ■
TL Past Due
■ 7/1/2020 0 10/1/2020 0 1/1/20,
■ 9/1/2021 10/1/2021 0 11/1/21
,252
230,914 226,572
212,991
r" 189,833
163,011
106,
75,894 67,8ji
0
42,956 43,6
_"n'
30 Days 60 Days 90+ Days
i1 ■ 2/1/2021 3/1/2021 ■ 4/1/2021 5/1/2021 ■ 6/1/2021 7/1/2021 8/1/2021
)21 12/1/2021 1/1/2022 2/1/2022 3/1/2022 ■ 4/1/2022 ■ 5/1/2022 0
is of 5/1/2022 30 Days 60 Days 90 Days
#Customers, E 713 E -15 to last mth 313 E -39 to last mth 245 E -29
#Customers, W 409 W -24 to last mth 177 W -28 to last mth 137 W -15
Average $ Past Due per Past Due Customer 30 / 60 /90 : $404 / $260 / $994
-4.1 % of customers are 30 Days Past Due, 1.8% 60 Days, and 1.4% 90+Days.
2022
DISTRICT Pandemic Relief: 2020 2021 YTD'Apr Total avg per
Amount $ 84,759 $ 34,675 $ 3,510 $122,944 $ 310
# Customers 286 97 13 396 some are repeats
FED ARPA Funds via California CSD CAPP (E ) and SWRCB (W):
credits applied in March/April 2022
$ 113,135 Electric $ 103,530 Water $ 216,665 Total ARPA
90+Days balance split:
E $ 140,721 74%
W $ 49,112 26%
Total $ 189,833 100%
—11% of 90+$ is Commercial
—89% of 90+$ is Residential
-- Residential 90+days, Electric: %c / %$
Primary 68%/79%
Secondary 32%/21%
-- Commerical 90+, most is approx.
10 accounts (top 4 are restaurants)
5/3/2022 11:15 AM
\\nasdatasewer\users\michaels\My Documents\AR Aging Reports May_2022