Laserfiche WebLink
City of Ramsey, Minnesota <br />2018 CERTIFICATION <br />Utility Accounts <br />Accounts Receivable <br />Total <br />Original Letters Sent 9/5/18 <br />Number of UB Accts. <br />Number of Accounts Increased from 2017 <br />Percentage of Accounts Increased from 2017 <br />1041 <br />(49) <br />-471h <br />Amount <br />Delinquent <br />300,057 90 <br />3,331 25 <br />303,389.15 <br />Admin Fee <br />($301acct) <br />31,230 00 <br />120 00 <br />31,350.00 <br />Interest <br />(5.50%) <br />20,889 60 <br />231 90 <br />21,121.50 <br />Total Subject <br />to <br />Certification <br />352,177.50 <br />3,683 15 <br />355,860.65 <br />Public Hearing Update 9/25/18 <br />Number of UB Accts <br />Number of UB Account Brought Curre t Since Letters <br />Percentage of UB Account Brought Current Since Letters <br />Utility Accounts <br />Accounts Receivable <br />Total <br />889 <br />152 <br />14.60% <br />Amount <br />Delinquent <br />275,145 21 <br />1,218 75 <br />276,363.96 <br />Admin Fee <br />($30/acct) <br />26,520 00 <br />90 00 <br />26,610.00 <br />Interest <br />(5.50"/ ) <br />19,155 20 <br />84 84 <br />19,240.04 <br />Total Subject <br />to <br />Certification <br />320,820 41 <br />1,393 59 <br />322,214.00 <br />Final Certification - Post 11/16/18 <br />Number of UB Accts <br />Number of UB Account Brought Curre t Since Letters 1041 <br />Percentage of UB Accounts Brought Current Since Letters 100 00% <br />Utility Accounts <br />Accounts Receivable <br />0 <br />Amount <br />Delinquent <br />Admin Fee <br />($30/acct) <br />Interest <br />(5.50%) <br />Total Subject <br />to <br />Certification <br />Total <br />Increase/(decrease) <br />from prior year (191,203 15) (17,460.00) (13,253.93) (221,917.08) <br />Delinquent City Services <br />- As of September 25, 2018 - <br />2017 CERTIFICATION <br />Utility Accounts <br />Accounts Receivable <br />Original Letters Sent 9/6117 <br />Number of UB Accts <br />Number of Accounts Increased from 2016 <br />Percentage of Accounts Increased from 2016 <br />1090 <br />75 <br />688h <br />Amount <br />Delinquent <br />293,871 72 <br />3,446.25 <br />Admin Fee <br />($30lacct) <br />32,700 00 <br />60 00 <br />Interest <br />(5.50%) <br />20,413.95 <br />239 40 <br />Total Subject <br />to <br />Certification <br />346,985 67 <br />3,74565 <br />Total <br />297,317.97 <br />32,760.00 <br />20,653.35 <br />350,731.32 <br />Public Hearing Update 9/26/17 <br />Number ofUBAccts 902 <br />Number ofUB Account Brought Curre t Since Letters. 188 <br />Percentage ofUB Account Brought Current Since Letters. 17.25% <br />Utility Accounts <br />Accounts Receivable <br />Amount <br />Delinquent <br />262,335 15 <br />3,44625 <br />Admin Fee <br />($30/acct) <br />27,030.00 <br />60.00 <br />Interest <br />(5.50%) <br />18,223.16 <br />239 40 <br />Total Subject <br />to <br />Certification <br />307,588.31 <br />3,74565 <br />Total <br />265,781.40 <br />27,090.00 <br />18,462.56 <br />311,333.96 <br />Final Certification - Post 11/13/17 <br />Number ofUBAccts 585 <br />Number ofUB Account Brought Curre t Since Letters 505 <br />Percentage of UB Accounts Brought Current Since Letters 46.33% <br />Utility Accounts <br />Accounts Receivable <br />Amount <br />Delinquent <br />189,603 15 <br />1,60000 <br />Admin Fee <br />($30/acct) <br />17,430 00 <br />30 00 <br />Interest <br />(5.50%) <br />13,142 78 <br />11115 <br />Total Subject <br />to <br />Certification <br />220,175 93 <br />1,741 15 <br />Total <br />191,203.15 <br />17,460.00 <br />13,253.93 <br />221,917.08 <br />Increase/(decrease) <br />from prior year <br />38, 686.62 1,680 00 2,682 87 43, 049.49 <br />Prepared By Finance Dept <br />2016 CERTIFICATION <br />Utility Accounts <br />Accounts Receivable <br />Original Letters Sent 9/8/16 <br />Number of UB Accts. 1015 <br />Number of Accounts Increased from 2015 -176 <br />Percentage of Accounts Increased from 2015-17.34% <br />Amount <br />Delinquent <br />237,257 13 <br />2,812.50 <br />Admin Fee <br />($30/acct) <br />30,450 00 <br />30 00 <br />Interest <br />(5.50%) <br />16,444.68 <br />194.95 <br />Total Subject <br />to <br />Certification <br />284,151 81 <br />3,037 45 <br />Total <br />240,069.63 <br />30,480.00 <br />16,639.63 <br />287,189.26 <br />Public Hearing Update 9/27/16 <br />Number of UB Accts. 858 <br />Number of UB Account Brought Current Since Letters 157 <br />Percentage of UB Account Brought Current Since Letters 1547h <br />Utility Accounts <br />Accounts Receivable <br />Amount <br />Delinquent <br />218,210 70 <br />2,812 50 <br />Admin Fee <br />($30/acct) <br />25,710 00 <br />30 00 <br />Interest <br />(5.50%) <br />15,124 53 <br />194.95 <br />Total Subject <br />to <br />Certification <br />259,045 23 <br />3,037 45 <br />Total <br />221,023.20 <br />25,740.00 <br />15,319.48 <br />262,082.68 <br />Final Certification - Post 11/11/16 <br />Number of UB Accts. 529 <br />Number of UB Account Brought Current Since Letters 486 <br />Percentage of UB Accounts Brought Current Since Letters 47 88 h <br />Utility Accounts <br />Accounts Receivable <br />Amount <br />Delinquent <br />149,704.03 <br />2,812.50 <br />Admin Fee <br />($30/acct) <br />15,750 00 <br />30 00 <br />Interest <br />(5.50%) <br />10,376 11 <br />194.95 <br />Total Subject <br />to <br />Certification <br />175,830 14 <br />3,037 45 <br />Total <br />152516.53 <br />15,780.00 <br />10,571.06 <br />178,867.59 <br />Increase/(decrease) <br />from prior year (19,954.57) (1,980.00) (1,511.36) (23,445.93) <br />Note Deadline to pay "Delinquent Amount" is 11/16/2018 If unpaid by deadline, "Total Subject to Certification" will be assessed to 2019 property taxes <br />