HomeMy WebLinkAboutFIN-2024-043 - Uncollectable Miscellaneous Receivable Accounts Write-Off
REPORT TO: Planning and Strategic Initiatives Committee
DATE OF MEETING: February 26, 2024
SUBMITTED BY: Saleh Saleh, Director, Revenue, 519-741-2200 ext. 7346
PREPARED BY: Marcy Ignor, Manager Utility Billing and Customer Service, 519-741-
2200 ext. 7460
WARD(S) INVOLVED: ALL
DATE OF REPORT: January 5, 2024
REPORT NO.: FIN-2024-043
SUBJECT: Uncollectable Miscellaneous Receivable Accounts Write-Off
RECOMMENDATION:
That uncollectable Miscellaneous Receivable Accounts amounting to $6,946 be
written off against the Allowance for Doubtful Receivables.
REPORT HIGHLIGHTS:
As per council policy, approval from Council is required for accounts to be written-off
and sent to an outside collection agency for third party collection efforts.
Staff have worked diligently in attempting to collect on these accounts but have not been
successful in the process.
This report recommends that accounts totalling $6,946 be written off and forwarded to
an outside collection agency.
BACKGROUND:
As per council policy FIN-FEE-517 Utility and Miscellaneous Receivable policy, approval
from Council is required for accounts to be written-off and sent to an outside collection
agency for third party collection efforts.
This report represents Miscellaneous Receivables accounts that are deemed to be
uncollectable by collections staff. Miscellaneous Receivables represent services that are
receivables include Direct Detect for alarm monitoring, Parking and Cemetery sales.
Property tax and utility accounts are not included in miscellaneous receivables.
*** This information is available in accessible formats upon request. ***
Please call 519-741-2345 or TTY 1-866-969-9994 for assistance.
REPORT:
Staff are recommending that accounts totalling $6,946 be written off and forwarded to a
collection agency. Staff have worked diligently in attempting to collect on these accounts
but have not been successful in the process.
The collection procedures staff have undertaken include:
Sending customers statements and demand letters.
Verbal request by telephone or in person.
Negotiating revised payment terms.
Applying any deposits held to the outstanding amounts.
permitted by the Municipal Act.
The current amount being recommended to be written off relates to 18 customer accounts
for services provided in the following areas:
Cemeteries1,796
Parking4,841
Operations129
Fire23
Utilties157
Total6,946
The cumulative amount of write-offs identified in this report equal $6,946 and relate to the
years 2022 and 2023. The cumulative write-offs are shown in the table below and the
average is well below the targeted upper limit for write-offs set at 0.3% previously approved
by Council.
CumulativeTotal $ InvoicedWrite-offs as a
Write-offs for the YearYear to Date% of Sales
2023$ 8,914$ 37,174,640 0.0240%
2022$ 30,307 $ 30,280,755 0.1001%
2021$ 38,573 $ 27,380,864 0.1409%
2020$ 55,769 $ 23,088,516 0.2415%
2019$ 44,077 $ 26,057,7400.1692%
Total$ 177,640$ 143,982,5150.1234%
STRATEGIC PLAN ALIGNMENT:
The recommendation of this report
through the delivery of core service.
FINANCIAL IMPLICATIONS:
The uncollectable accounts will be written off against the Allowance for Doubtful
Receivables account.
COMMUNITY ENGAGEMENT:
INFORM
the council / committee meeting.
PREVIOUS REPORTS/AUTHORITIES:
FIN-FEE-517 Collections- Utility and Miscellaneous Receivable
APPROVED BY: Jonathan Lautenbach, Chief Financial Officer, Financial Services