HomeMy WebLinkAbout9 Delinquent Accounts Recievable Agenda Item # 9
Utility DisLricL
CONSENT
To: Board of Directors
From: Rosana Matlock
Date: February 17, 2010
Subject: Consideration of Write-Off of Delinquent Accounts Receivable
1. WHY THIS MATTER IS BEFORE THE BOARD
District Code, Title 3.12.020.1 authorizes the District Treasurer to write-off delinquent
account balances less than 1/6% of the annual amounts billed from the District's
accounts receivable balance. Write-off amounts in excess of 1/6% must be approved
by the Board. In total, the current write-off list causes the total write-offs for FY09 to
be greater than 1/6% of the FY09 billed accounts receivables.
2. HISTORY
Historically, the District's write-off of delinquent accounts has been very low. This is
due to the Board's credit and collection policies and staffs efforts to collect delinquent
account balances.
Write-Off History - Past 5 Years
2005 $17,949 .07%
2006 $231997 .08%
2007 $14,785 .05%
2008 $29,276 .09%
2009 $56,902 .17%
3. NEW INFORMATION
The current semi-annual write-off list totals $41,327.35. This list includes unpaid
accounts that closed prior to June 30, 2009 and are now at least six months old. The
total write-off amount for FY09 including the first write-off list in the amount of $16,137
less recoveries. of $562 totals $56,902. This total represents 0.17% of the annual
amounts billed for electric and water services. The primary factor of the increase is
due to the downturn in the economy.
The accounts that are written off are moved to the Uncollected Accounts file within our
billing system. These accounts have also been transferred to the credit bureau for
further collection. Should one of these customers come in to apply for service in the
future, their prior account will come up on our screen so we can collect the unpaid
balance.
Attached are the following reports and charts:
Attachment 1 - 2009 List of Uncollectible Accounts - current list of the
customers and amounts to be written off totaling $41,327.35
Attachment 2 - Write-Off Analysis 2000 to 2009 in Dollars and Percentages
chart
The budgeted write-off amount for FY10 is $38,000 and $38,665 for FY11. These
amounts are not expected to be sufficient to cover the write-offs for these two fiscal
years if the trend continues. Staff will identify savings within the FY10 and FY11
Budgets to cover any write-offs over these limits.
4. FISCAL IMPACT
Provision for the write-off of delinquent accounts receivable was budgeted at $34,000
for FY09. The actual amount was $56,902. There were sufficient savings in the
FY09 budget to make up for the cost increase.
5. RECOMMENDATION
Review this report and approve the write-off list in the amount of $41,327.35 for
uncollectible accounts that closed prior to June 30, 2009.
Mary Cha`R;a@ Michael D. Holley
Administrative Services Manager General Manager
Attachment 1
ACCOUNTS RECEIVABLE 2009 LIST OF UNCOLLECTIBLE ACCOUNTS
ACCOUNTS 6 MONTHS OLD AS OF 12/31/09
Account# Last Name First Name Middle Total Write-Off
Name Amount
6530720000 ANDERSON ERIC 177.16
9000012938 ANDERSON DANIELLE 174.54
9000014164 ANTHONY CLYDE 45.59
9000009878 ARMENTA CORINNA 808.17
9000011913 ASAM CYNTHIA 89.41
9000014739 BEARSTEARNS ARM TRUST 2005-6 69.12
6638540024 BEDELL JOHN 285.45
9000011351 BERGOT DONNA 150.61
9000006380 BRADSHAW JOHN 643.85
9000012490 BUCKS-REED ELLIOTT 188.94
9000012542 BURTON SHARON 117.02
4804570000 BUSHNELL TOM 199.83
9000013763 CHRISTENSON MICHAEL 254.81
9000011819 CONNER JACK C 260.59
9000006909 DILLE JUSTIN 194.84
9000012644 DISBROW TODD 1,162.62
9000005168 EASON TOM 157.34
9000007871 EIGER HOLDINGS LLC 652.31
6093230024 FARLEY Mimi 1,390.64
6554440025 FREEMAN JASON 551.52
9000008927 FROSLIE ROBERT 637.73
9000014440 FUENTES ROCIO 94.25
5842030029 GALLICHIO JOHN 733.38
9000008262 GOODRICH SANDRA 237.90
9000013087 HARRIS ALICIA 197.54
2061090025 HOGAN PAUL 659.34
9000012945 HORN KIRSTIN 178.44
9000012595 HOWARD LYNN 125.00
9000003943 HUDDLESTON JOHN 50.10
3101150001 HUSTAD ED 633.43
9000013054 KINNEY ALICIA 120.39
9000006953 KNOTTY BEAR DEVELOPMENT INC 136.18
9000007953 KONSTANTINOPOULOS GEORGE 775.08
9000013174 KURLAND PARRISH 576.85
9000013754 LAMBERT IVY RUTH 89.81
9000013525 LINSCOMB JEFFREY 22.12
7120790024 LIPCHIK LORI 69.49
5201800025 MARK MANAGEMENT, INC 6,390.57
9000014095 MARLEY JESSIE 520.29
9000013303 MARTINEZ-REYES JORGE 298.23
9000002310 MAYS MITCHELL B 587.33
2041370027 MCKAY ROBERT 561.39
9000008449 MEZA JESUS 689.70
9000005208 MFI, INC 267.32
9000013341 MITCHELL JULIE 13.53
9000010048 MORA JAVIER F 52.58
9000006766 MORTON JOHN 1,347.09
4804160027 MURPHY JAN 33.75
9000001027 NJB CLOTHING 350.09
500650024 O B'S BOARD 2,378.49
9000003490 OLMO RAYMOND 587.68
Account# Last Name First Name Middle Total Write-Off
Name Amount
2071480000 OROZCO VICTOR 584.38
2074260001 PAOLETTI ROBERT 782.03
9000013935 PARKINSON CHARLEE 70.46
9000012253 PERKINS CASSANDRA 19.87
9000008671 PETERS RICHARD 209.47
9000014364 RASKOVSKY GLORIA 89.31
9000008325 REDPATH HOLLY 894.22
9000013076 ROBINSON JASON 940.08
9000011783 RODRIGUEZ MARTIN 86.41
9000013793 ROMMEL SARA 1,123.67
5880510000 RUSSELL TORREY 1,085.01
5250100024 RWR ART-ARCHITECTURE 350.31
9000013685 SAGEMAN ALLISON 328.92
5401370025 SANCHEZ DAVID 505.25
6531710025 SCHMIERER DAVE 186.31
9000013562 SCOTT GAREN 310.85
9000013524 SILVER DON 694.25
9000013453 SMITH BRIAN 767.03
3122170028 SPRATFORD DARRELL 404.94
5270222001 SUMMIT CHIROPRACTIC 30.07
9000011,248 TIPTON HEIDI 75.81
9000012727 TORRES MARIA 80.10
6233360002 TULEY LEESA 377.34
9000011022 VALLES JAVIER 51.71
9000010878 VALOSEK ANTHONY 143.17
9000013065 VAN WORMER LINDA 679.11
9000013045 VOGT JACKIE 713.85
9000006746 WALKER JAIME 787.04
9000014140 WELLS FARGO BANK 22.08
9000009792 WHITHAM JOSH 1,462.49
5320520024 WILLIAMS STEVEN C 482.38
82 41,327.36
Attachment 2
Truckee Donner Public Utility District
Write Off Analysis 2000 to 2009
$60,000 0.17%
$St" o2
S. C
� .
$50,00042
t
4 aro'����+ �-` � "r. -� a- - -�s� s-.,&• "�`� apt L�,t
$ ,
40 000
f' #
3 30 000
o
c �2 Yy i t
IAoos s y
$e23 997:
., µ .y 'vi.,rt ,.-...�: " ..':..;,e .: ....' ..:. :,.n-`b ■}�) :�v�Yw .a"�.Yt;£,�9 r1'<�k�f t
v
$ ,
20 OOO }
c s s"`� i. Q.o896 �:.• e .3 :.� 't �r ,,t., w,�,. _ _ t
i
j
10 000
ZM
t .
,
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
Year of Write Off