Loading...
HomeMy WebLinkAbout20053708.tiff RESOLUTION RE: CANCELLATION OF 2005 OUTSTANDING ACCOUNTS RECEIVABLE FOR THE WELD COUNTY DEPARTMENT OF PUBLIC HEALTH AND ENVIRONMENT WHEREAS,the Board of County Commissioners of Weld County, Colorado, pursuant to Colorado statute and the Weld County Home Rule Charter, is vested with the authority of administering the affairs of Weld County, Colorado, and WHEREAS,a list of 2005 Department of Public Health and Environment accounts has been submitted to the Accounting Department of Weld County, Colorado, and WHEREAS,said accounts have been deemed uncollectible in accordance with guidelines adopted by the City of Greeley and County of Weld, a copy of said list being attached hereto and incorporated herein by reference, and WHEREAS,the Accounting Department has recommended the cancellation of said list of uncollectible debts due and owing the Department of Public Health and Environment in the amount of$20,627.75. NOW,THEREFORE,BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the aforementioned list of 2004 uncollectible accounts in the amount of $20,627.75, be, and hereby is, approved for cancellation. The above and foregoing Resolution was,on motion duly made and seconded,adopted by the following vote on the 28th day of December, A.D., 2005. E 'a BOARD OF COUNTY COMMISSIONERS >/ WELD COUNTY, COLORADO ATTEST: ILA 1 �O +a �� illiam H. rke, Chairman Weld County Clerk to the t`?� ���� (? a..►� ile, Pro-Tem V L BY: I puty Clerk to the Bo d - (i` c Davy E. Long APP DAST • n 'O4 Robe D. Masd n oun AU' ey 14.4 � ,� Glenn Vaa UU _J Date of signature: I I Z /0(2 2005-3708 HL0019 ,fC`nt of i3 O� Memorandum TO: William H. Jerke, Chair Board of County Commissioners II P I FROM: Mark E. Wallace, MD, MPH, Director ODepartment of Public Health and Q�Environment 1/v\ COLORADO DATE: December 21,2005 71 SUBJECT: Cancellation of 2005 Outstanding Accounts Receivable The Department of Public Health and Environment is requesting the Board of County Commissioners' approval to write off balances of individual client accounts which have had no payment activity since before July 1, 2005. These accounts are recorded in the Centricity patient management system and have been billed monthly. The enclosed report lists the ticket number, date and amount of last payment, and the outstanding balance of each ticket. The total amount requested to be written off is $20,627.75. Enclosure Cc: Barb Eurich, Controller 2005-3708 , WARNING This report can make data changes in your system. Please read these instructions carefully. This report gives you the opportunity to writeoff old patient balances in your database When you close this window you will be prompted by the system to update your database If you select Yes the balance write-offs will occur. If you are not sure you want to proceed with the writeoffs then select No. Criteria used for the write-off: Write off the patient balance for all visits where the visit date is before 07/01/2005 Create these write-off transactions as conveyances for the payor. Old Balance Write-Off Create these write-off transactions in the batch: jnero_20051221 Create these write-off transactions as adjustments of type Write Off Company: Weld County Dept of Public Health and Environment-Last Payment Date before: 07/01/2005 Last Last Payment Pa meet Ticket Number Patient Balance 000484 $31.50 04/25/2005 $30.00 000029 $5.10 FPN000715 $31.50 FPN001749 $31.50 FPN000061 $31.50 06/06/2005 $2.00 FPN003132 $1.00 FPN002094 $79.40 FPN001406 $17.10 FPN001131 $31.50 FPN003351 $140.80 03/07/2005 $20.00 FPN000138 $11.50 FPN002137 $19.80 FPN002692 $25.50 09/24/2004 $4.00 000138 $25.00 FPN003098 $15.90 09/17/2004 $20.00 000106 $40.00 000108 $15.00 000107 $30.00 IZCN00D458 $62.00 FPN001818 $19.00 000878 $9.35 01/03/2005 $5.00 FPN001292 $14.00 FPN001467 $68.00. 04/18/2005 $13.00 FPN001628 $18.50 FPN002596 $31.50 000625 $35.70 FPS000095 $14.70 000478 $14.70 FPS000091 $16.20 03/15/2005 $15.00 FPN000259 $14.00 09/03/2004 $10.00 FPN000029 $19.00 FPN002134 $19.00 10/18/2004 $10.00 FPN000409 $19.00 11/10/2004 $7.00 FPN000657 $43.40 11/19/2004 $20.00 FPN000739 $37.75 000052 $168.85 02/04/2005 $10.00 FPN001788 $21.50 000559 $31.50 09/08/2004 $5.00 FPN000057 $36.25 05/23/2005 $67.00 FPN000092 02/25/2005 $14.00 $25.00 FPN002031 $37.20 FPN003002 $37.20 FPN000089 $28.95 Last Last Payment Payment Ticket Number Patient Balance FPN001630 $42.90 000086 $29.00 10/04/2004 $20.00 000165 $9.00 06/21/2005 $5.00 MDN000081 01/31/2005 $50.00 FPN000405 $23.00 $70.00 FPN001722 09/10/2004 $4.00 FPN000062 $134.40 $15.00 FPN002529 $45.90 09/29/2004 $10.00 FPN000210 $9.00 FPN000316 $67.00 FP N005525 $10.80 11/17/2004 $32.00 FPN000708 $19.00 000479 $10.00 05/12/2005 $5.00 000614 $39.00 10/11/2004 $2.00 FPN000330 $17.00 FPN002965 $19.00 06/29/2005 $112.00 FPN003402 $19.00 FPN002096 $31:50 06/22/2005 $50.00 FPN003309 $4.00 FPN002164 $15.30 FPN002537 $37.40 000051 $34.00 000097 $92.00 FPN000098 $57.75 03/14/2005 $10.00 FPN000232 $12.80 10/22/2004 $5.00 FPN000457 $25.90 FP N000998 $123.00 IZCN000062 $15.00 05/18/2005 $50.00 FPN002963 $4.00 ' FPN005048 $54.00 05/24/2005 $17.90 FPN000225 $1.10 FPN000005 $19.00 11/15/2004 $5.00 FPN000684 $14.00 FPN000894 $57.75 FPN000124 $69.85 09/10/2004 $10.00 FPN000077 $89.00 09/01/2004 $19.00 IZCN000011 $26.00 IZCN000012 $15.00 09/14/2004 $15.00 MDN000002 $204.00 09/16/2004 $90.00 FPN000119 $1.50 FPN000011 $46.00 FPN000014 $16.20 IZCN000027 $47.00 05/12/2005 $10.00 FPN000818 $9.00 02/09/2005 $5.00 FPN001843 $14.00 FPN000903 $29.00 IZCN000844 $45.00 FPN000184 $19.00 FPN000352 $29.00 03/16/2005 $19.00 FPN001648 $53.80 FPN002075 $55.50 IZCN001518 $47.00 IZCN000780 $77.00 IZCN000033 $90.00 05/09/2005 $5.10 FPN002844 $9.60 IZCN000043 $45.00 02/16/2005 $15.00 FPS000071 $4.00 FPS000048 $19.80 000543 $30.00 10/19/2004 $15.00 IZCN000339 $30.00 FPS000004 $33.60 IZCN000054 $15.00 • Last Last Payment Payment Ticket Number Patient Balance IZCN000038 $15.00 IZCN000039 $30.00 IZCN000065 $45.00 000243 $77.00 FPN003380 $6.40 000195 $80.00 IZCN000635 $77.00 02/04/2005 IZCN001472 $60.00 $20.00 FPN001799 $61.90 FPN001460 $327.00 IZCN000078 $92.00 09/16/2004 $15.00 TRVN000009 $15.00 FPN001690 $19.00 FPN003219 $29.00 02/04/2005 $10.00 FPN001782 03/21/2005 $81.00 FPN001654 $9.00 $27.00 IZCN000107 $139.00 04/04/2005 01/04/2005 $10.00 FPN002461 $97.00 $5.00 FPN000584 $24.00 11/05/2004 $20.00 FPN000585 $12.00 05/18/2005 $27.00 FPN002959 $24.00 IZCN000074 $30.00 FPN003230 $19.80 FPN002381 $24.90 11/19/2004 $50.00 FPN000742 $55.30 11/22/2004 $10.00 FPN000758 $68.30 06/21/2005 $25.00 FPN002357 $10.00 FP N001548 $17.40 01/07/2005 $20.00 FPN001416 $66.40 IZCN000114 $60.00 FPN001619 $76.30 FPN001357 $15.30 FP N002026 002026 $16.20 FPN001100 $60.00 FPN000568 $10.00 FPN001573 $19.00 IZCN001228 $35.00 IZCN000163 $107.00 IZCN000134 $77.00 FPN001044 $19.00 000327 $20.40 IZCN000152 $30.00 06/13/2005 $125.00 FPS000070 $82.00 03/01/2005 $125.00 FPN002077 $136.60 06/20/2005 $5.00 FPN003269 $155.40 000626 $19.00 FPN005034 $10.80 12/13/2004 $5.00 FPN001014 $14.00 12/20/2004 $12.00 FPN000638 $7.80 11/10/2004 $40.00 FPN000335 $42.90 FPN000307 $31.50 FPS000075 $31.50 05/17/2005 $20.00 FPN002943 $11.50 02/18/2005 $90.00 FPS000008 $14.80 FPS000065 $20.40 01/28/2005 $2.00 FPN001710 $17.00 FPN001931 $19.00 IZCN000131 $47.00 03/30/2005 $10.00 FPN002413 $72.80 IZC N000119 $15.00 FPN003242 $16.20 04/13/2005 $30.00 FPN002533 $76.15 Last Last Payment Payment Ticket Number Patient Balance 09/14/2004 $10.00 FPN000103 $22.00 01/06/2005 $10.00 FPN001380 $5.30 12/07/2004 $27.00 MDN000009 $15.30 02/25/2005 $15.00 FPN002018 $40.50 09/13/2004 $5.00 IZCN000056 $42.00 IZCN000164 $77.00 01/31/2005 $15.00 FPN001721 $4.00 IZCN000129 $107.00 09/30/2004 FPN001603 $29.00 $7.00 FPN000228 $12.00 FPN003167 $19.00 02/09/2005 $5.00 FPN001849 $54.40 IZCN000177 $45.00 10/04/2004 $20.00 IZCN000208 $25.00 05/18/2005 $11.00 FPN000391 $13.00 12/16/2004 $5.00 FPN001083 $14.00 05/09/2005 $10.00 FPN002840 $21.50 IZCN000364 $77.00 IZCN001922 $50.00 TBN000043 $10.00 FPN003067 $16.20 IZCN000146 $45.00 IZCN000149 $15.00 IZCN000111 $15.00 12/20/2004 $10.00 FPN001148 $25.10 11/12/2004 $20.00 IZCN000621 $10.00 000230 $92.00 IZC N000769 $10.00 FPN000230 $19.80 IZCN000260 $45.00 05/18/2005 $0.20 FPN000942 $73.30 FPN002953 $121.80 03/22/2005 $5.00 000360 $24.00 FPN000166 $5.00 FPN001511 $28.50 IZCN000314 $45.00 IZCN000457 $62.00 IZCN000155 $77.00 04/14/2005 $20.00 FPN002538 $8.20 IZCN001288 $75.00 FPN000189 $29.70 IZCN000336 $62.00 IZCN000298 $15.00 FPN000738 $28.50 IZCN000207 $60.00 10/18/2004 $2.00 FPS000015 $8.00 10/07/2004 $1.00 FPS000011 $9.00 FPS000019 $10.00 IZCN000267 $45.00 IZCN000881 $45.00 IZCN001504 $60.00 FPN005042 $16.20 FPN000473 $58.00 05/10/2005 $72.00 FPN000691 $8.00 000596 $46.80 FPN000350 $19.00 10/01/2004 $5.00 FPN000234 $30.10 FPN000257 $38.10 FPN002095 $21.00 FPN 001171 $16.20 01/10/2005 $20.00 FPN001426 $19.00 10/15/2004 $20.00 FPN000398 $25.30 Last Last Payment Pa ment Ticket Number Patient Balance 11/15/2004 $5.00 FPN000685 $24.00 IZCN000346 $45.00 FPN003185 $75.40 FPN003104 $10.00 10/08/2004 $10.00 FPN000297 $37.85 IZCN001500 $15.00 05/23/2005 IZCN001977 $15.00 $30.00 IZCN000530 $47.00 000955 $192.00 IZCN000608 $77.00 IZCN000391 $30.00 12/20/2004 $20.00 FPN001140 02/28/2005 $10.00 FPN002040 $9.70 $9.00 I 03/08/2005 $10.00 FPN002152 $9.00 IZCN000463 $45.00 IZCN001303 $77.00 FPN001544 $72.00 FPN003216 $16.20 10/20/2004 $15.00 FPS000017 $4.00 11/02/2004 $15.00 IZC N000540 $15.00 10/29/2004 $20.00 IZCN000509 $40.00 FPN000423 $16.20 11/03/2004 $40.00 IZCN000554 $67.00 02/22/2005 $15.00 FPN001966 $4.00 IZCN000323 1 $107.00 IZCN001085 $62.00 05/05/2005 $5.00 000567 $28.00 10/19/2004 $10.00 IZCN000338 $20.00 IZCN000549 $77.00 06/13/2005 $0.00 TBN000505 $32.00 MDN000003 $75.00 000901 $10.00 FPN001237 $24.00 FPN003405 $31.50 FPN000471 $84.90 11/04/2004 $25.00 FPN000570 $33.00 FPS000021 $45.65 IZCN000563 $107.00 12/09/2004 $10.00 FPN000925 $23.90 10/25/2004 $10.00 FPN000470 $28.10 12/08/2004 $10.00 000223 $43.70 IZCN000649 $60.00 11/04/2004 $10.00 IZCN000560 $80.00 IZCN001402 $47.00 FPN004823 $10.00 01/31/2005 $10.00 FPN001729 $15.00 FPN001123 $11.70 FPN003004 $15.30 11/09/2004 $85.00 FPN000634 $172.00 IZCN001142 $125.00 IZC N001143 $110.00 TBN000300 $20.00 FP N000548 $16.20 FPN001557 $19.00 12/17/2004 $86.00 IZNA000151 $10.00 03/10/2005 $20.00 FPN002189 $48.50 11/04/2004 IZCN001374 $77.00 $3.00 FPN000580 $28.50 01/21/2005 $5.00 FPN001583 $24.00 FPN000574 $58.00 IZCN000668 $62.00 IZCN000667 $62.00 . Last Last Payment Payment Ticket Number Patient Balance 02/02/2005 $7.50 IZCN001256 $39.50 IZCN000770 $15.00 IZNA000294 $15.00 IZCN000657 $77.00 IZCN000658 $77.00 FPN001167 12/01/2004 $15.00 IZCN000704 07.00 1$9.20 11/12/2004 $7.00 FPN000667 $1 02/18/2005 $35.00 FPN000675 $9.20 45. 01/17/2005 $25.00 FPN001522 000914 $45.20 0 $45.00 FPN000716 $43.20 01/21/2005 $15.00 FPN001612 $4.00 01/05/2005 IZCN000627 $77.00 $10.00 FPN001375 $38.90 FPN000757 $16.20 TBN001060 $32.00 IZCN001127 $95.00 IZCN000788 $45.00 FPN001461 $29.00 FPN001172 $46.20 IZCN000781 $122.00 NHVN000129 $29.00 TBN001018 $10.00 04/25/2005 $11.00 FPN002628 $43.30 12/10/2004 $10.00 IZCN000774 $35.00 05/25/2005 $15.00 FPN001772 $4.80 FPN002324 $19.80 FPN003026 $58.50 FPN000808 $25.00 04/19/2005 $10.00 FPN002579 $6.20 IZCN001192 $45.00 IZCN001622 $77.00 IZCN001426 $92.00 IZCN000904 $107.00 IZCN001425 $62.00 IZCN000906 $122.00 000927 $10.00 MIZC000051 $15.00 • MIZC000052 $15.00 M IZC000053 $15.00 MIZO000566 $15.00 M IZC000055 $15.00 01/19/2005 MIZC000056 $15.00 $20.00 FPN001578 $101.20 IZCN001075 $80.00 FPS000049 $19.80 FPN002734 $6.60 IZCN001627 $45.00 02/28/2005 $20.00 FPN001196 $11.50 FPN001210 $14.70 FPN002102 $16.20 03/04/2005 $31.40 STDN000018 $40.50 FPN001862 $85.10 IZCN001111 $10.00 01/28/2005 $20.00 FPN001714 $4.30 IZCN000992 $77.00 IZCN001268 $62.00 IZCN001013 $80.00 05/16/2005 $15.00 IZCN001942 $47.00 000264 $45.00 IZCN000967 $45.00 • Last Last Payment Payment Ticket Number Patient Balance IZCN003299 $76.00 IZCN000960 $62.00 IZCN001049 $45.00 IZCN001048 $15.00 02/25/2005 $5.00 IZCN001451 02/11/2005 $15.00 IZCN001337 $10.00 $15.00 IZCN001910 01/11/2005 $132.00 000298 $54.00 01/07/2005 $40.00 000271 $54.00 $35.00 000270 $75.00 IZCN000993 $62.00 IZCN001710 $62.00 IZCN001032 $30.00 FPN002568 $71.00 05/02/2005 $25.00 FPN002757 $71.00 FPN002304 $86.30 01/10/2005 $20.00 000289 $10.00 IZCN001908 $15.00 000288 $45.00 01/06/2005 $5.00 FPN001387 $56.00 01/12/2005 $50.00 IZNA000163 $22.00 FPN001452 $17.10 FP N001664 $16.20 000315 $110.00 03/21/2005 $20.00 IZCN001119 $25.00 IZCN001184 $77.00 IZCN001185 $77.00 IZCN001307 $80.00 01/20/2005 $20.00 IZCN001148 $72.00 IZCN001126 $75.00 IZCN001138 $50.00 04/18/2005 $15.00 IZCN001738 $62.00 FPN001565 $16.20 02/07/2005 $15.00 FPN001808 $39.30 IZCN001175 $30.00 01/21/2005 $10.00 FPN001594 $6.20 04/27/2005 $50.00 FPN002678 $38.40 IZCN001267 $60.00 03/28/2005 $10.00 FPS000089 $87.50 FPN002401 $317.00 02/16/2005 $10.00 FPN001916 $15.00 02/23/2005 $10.00 FPN001996 $9.00 000342 $38.10 02/28/2005 $6.00 FPN002042 $70.20 IZCN001731 $62.00 02/14/2005 $13.00 IZCN001354 $97.00 02/07/2005 $20.00 FPS000069 $5.00 IZCN001460 $80.00 IZCN001375 $92.00 02/11/2005 $10.00 FPN001883 $9.80 IZCN001390 $50.00 02/16/2005 $10.00 FPS000072 $9.00 IZCN001401 $50.00 IZCN001408 $80.00 IZCN001403 $50.00 FPN001932 $39.05 FPN002149 $25.60 03/07/2005 $20.00 FPN002136 $30.00 FPN002181 $29.00 04/15/2005 $6.00 FPN002558 $23.00 FPN001999 $17.10 TB N 000944 $10.00 . Last Last Payment Payment Ticket Number Patient Balance FPN002468 $29.00 IZCN001528 $95.00 05/02/2005 $5.00 FPN002748 $24.00 IZCN001546 $65.00 FPN002177 $16.20 03/24/2005 $50.00 000369 $112.00 03/11/2005 $15.00 IZCN001542 $30.00 FPN002443 $93.60 000896 $10.00 IZCN001667 $65.00 IZCN000830 $92.00 05/27/2005 $50.00 000462 $14.00 IZCN001797 $80.00 IZCN002040 $80.00 IZCN001762 $77.00 IZCN001768 $118.00 IZCN001767 $95.00 IZCN001723 $15.00 TBN001503 $45.00 04/22/2005 $40.00 FPN002622 $31.50 IZCN003297 $30.00 06/14/2005 $121.00 TRVN000270 $121.00 IZCN001782 $65.00 IZCN001800 $62.00 IZCN001769 $50.00 FPN003570 $9.50 000527 $14.70 06/29/2005 $5.00 FPN003394 $5.00 FPN003316 $19.00 IZCN001874 $45.00 05/02/2005 $15.00 IZCN001854 $65.00 000542 $26.40 FPN003053 $43.20 IZCN001867 $80.00 05/12/2005 $15.00 000607 $10.00 IZCN001893 $20.00 IZCN001895 $95.00 IZCN002138 $10.00 000613 $16.20 MIZC000228 $30.00 MIZC000173 $15.00 MIZC000178 $30.00 MIZC000225 $30.00 IZCN001968 $110.00 TRVN000261 $62.00 IZCN002011 $15.00 FPN003374 $78.05 FPN003170 $91.30 06/29/2005 $20.70 FPN003398 $25.50 06/01/2005 $10.00 FPN003078 $7.10 FPN003079 $5.00 IZCN002031 $45.00 IZCN002067 $80.00 IZCN002154 $110.00 FPN003154 $16.20 FPN003258 $16.20 IZCN002137 $10.00 IZCN002157 $45.00 FP N 003386 $105.90 06/27/2005 $10.00 FPN003358 $9.80 IZCN002187 $80.00 06/29/2005 $10.00 FPN003408 $7.10 1 Last Last Payment Payment Ticket Number Patient Balance MIZC000572 $153.00 $20,627.75 Hello