HomeMy WebLinkAboutFIN-09-106 - Utility Write OffJ
F-mrncialServirts
REPORT
Report To: Mayor Carl Zehr and Members of Council
Date of Meeting: August 10, 2009
Submitted By: Dan Chapman, General Manager of Financial Services
Prepared By: Joyce V. Evans, Director of Revenue (Ext. 2895}
Ward(s) Involved: All
Date of Report: August 24, 2009
Report No.: FIN-09-106
Subject: Uncollectable Utility Accounts Write Off
RECOMMENDATION:
That Uncollectable Utility Accounts, amounting to $113,994.64 be
written off against the Allowance for Doubtful Sundry Receivables and
the Allowance for Doubtful Utility Receivables.
EXECUTIVE SUMMARY:
The last write off report for Uncollectable Utility Accounts approved by Council in February 2009
totalling $78,778.99 and covered the period up to the end of December 2009. The current
report reflects uncollectable utility accounts totalling $113,994.64 for the period from 2002 and
ending June 30, 2009.
BACKGROUND:
The current report represents write off of utility accounts which have been deemed to be
uncollectable up to the end of June 2009.
At this point in time we continue to manage accounts from 1999 forward. Council approved a
collection policy for utilities which recommended that the targeted upper limit for write-offs be set at
0.3%. Staff continue their efforts in reducing the level of delinquent accounts and to maintain
write-offs at below the targeted upper limit as recommended by Council.
2-1
REPORT:
All reasonable efforts have been made by Revenue Division staff to collect these amounts.
These outstanding balances will be written off and will be forwarded to a collection agency.
The cumulative write-offs shown by year as a percentage of total invoices billed, are as follow:
2009 Uncollectable Utility Account Write-Off
Detailed summary
Cumulative Write-
offs Total $ invoiced
Year to date Write-offs as a
% of sales
2009 $ 59, 344.32 $ 99, 618, 000 0.0596%
2008 148, 831.12 161, 658, 000 0.0921
2007 151, 214.15 148, 670, 000 0.1017%
2006 159,001.94 136,419,000 0.1166%
2005 170, 358.03 131, 759, 000 0.1293%
2004 201, 939.86 121, 032, 000 0.1668%
2003 373, 069.26 114, 083, 000 0.3270%
2002 455, 011.22 106, 576, 000 0.4269%
2001 482, 373.65 107,481, 000 0.4489%
2000 445,975.45 88,188,000 0.5057%
1999 111, 958.98 84, 049, 000 0.1332%
Total $2,764,506.34 $1,299,533,000 0.2127%
If you have any questions or concerns regarding any of these amounts to be written off, we
would be happy to address your concerns.
z-z
FINANCIAL IMPLICATIONS:
The cumulative total write off of $2,764,506.34 represents approximately 0.2127% of the total
utility billings of $1,299,533,000 for the period covered in the report. This is in line with the
recommended targeted upper level for write-offs of 0.3% in the Utility Collection Policy as
approved by Council.
Collection staff has focused their efforts on bringing the level of write-offs down to an acceptable
level as reflected in the results provided in this report. Staff will continue their efforts in
managing delinquent accounts to ensure that the write-offs are at a minimum.
CONCLUSION:
It has been determined that $113,994.64 of utility accounts is uncollectable and staff
recommends that the accounts be written off in June 2009. The uncollectable accounts listing
will be forwarded to a collection agency, which will use their best efforts to collect these
accounts.
ACKNOWLEDGED BY: (must be a member of CMT)
2-3