Loading...
HomeMy WebLinkAbout20061899 RESOLUTION RE: CANCELLATION OF 2006 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 2006 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 $15,330.90. NOW, THEREFORE, BE IT RESOLVED by the Board of County Commissioners of Weld County, Colorado, that the aforementioned list of uncollectible accounts in the amount of $15,330.90, 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 17th day of July, A.D., 2006. BOARD NTY COMMISSIONERS j ,, WELD COOF , COLORADO ATTEST: Ateil 1 at., , . a', Geile, Chairman Weld County Clerk to the ' r EXCUSED ' ' David E. Long, Pro-Tem BY: L. i1.G1-r�Q/� �i Dep Clerk the Board - kit,/ Willi H. Jerke APP AS .• Robert D. Mas n o y Attorney Glenn Vaad Date of signature: 7 10 2006-1899 HL0019 0(1: HL- , Acct- O.2--,23?-O6, Memorandum TO: M.J. f C Chair o Board of County Commissioners Il FROM: Mark E. Wallace, MD, MPH, Director WI O Department of Public Health and Environment COLORADO DATE: June 30, 2006 SUBJECT: Cancellation of 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 January 1, 2006. 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 $15,330.90 Enclosure Cc: Barb Connolly, Controller 2006-1899 • 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 01/01/2006 Create these write-off transactions as conveyances for the payor. Old Balance Write-Off Create these write-off transactions in the batch: jnero_20060630 Create these write-off transactions as adjustments of type Write Off Company: Weld County Dept of Public Health and Environment- Last Payment Date before 01/01/2006 Last Last Payment Payment Ticket Number Patient Balance 12/12/2005 $10.40 FPN003674 $76.60 FPN005150 $78.50 08/02/2005 $10.00 FPN001711 $19.00 10/18/2005 $0.40 FPN004737 $15.80 12/20/2005 $20.00 FPN005557 $11.50 10/04/2005 $10.00 FPN004562 $21.50 12/28/2005 $5.00 FPN005612 $5.00 09/23/2005 $10.00 FPN004446 $11.30 FPN004718 $31.50 10/07/2005 $19.60 FPN003403 $102.20 11/14/2005 $6.00 FPN005075 $18.00 09/12/2005 $25.00 000687 $65.60 FPN004062 $71.90 FPN003539 $131.40 12/09/2005 $10.00 FPN005380 $9.00 FPN005454 $9.60 12/20/2005 $32.00 FPN003700 $23.50 12/20/2005 $10.00 FPN005547 $51.30 FPN004617 $31.50 FPS000250 $30.00 11/04/2005 $26.30 FPS000064 $40.70 FPN005497 $10.00 09/28/2005 $27.00 FPN004489 $19.00 11/28/2005 $10.00 FPN005234 $6.20 FPN003858 $60.00 08/02/2005 $2.00 FPN002522 $14.20 FPN003632 $37.10 10/07/2005 $15.00 FPN002436 $18.30 10/06/2005 $61.50 FPN001634 $21.60 FPN004614 $31.50 FPN004321 $108.00 09/14/2005 $55.00 FPN000004 $10.50 FPN003484 $14.70 000953 $35.70 10/03/2005 $19.70 000817 $47.30 FPN005451 $50.10 FPN004748 $54.00 07/25/2005 $5.00 FPN003692 $33.10 10/24/2005 $20.00 FPN004513 $9.00 FPN004641 $19.00 FPN004802 $19.00 FPN003845 $24.00 FPN004202 $33.90 Last Last Payment Payment Ticket Number Patient Balance FPN005013 $42.60 000950 $23.40 000764 $40.20 09/15/2005 $50.90 FPN002192 $46.80 FPN004788 $19.00 09/01/2005 $35.00 FPN000033 $47.20 000790 $94.20 FPN005512 $13.20 FPN004461 $62.80 08/22/2005 $10.00 000758 $9.00 10/07/2005 $2.00 FPS000198 $25.00 11/10/2005 $68.50 FPN001050 $0.10 000948 $19.00 000772 $5.00 11/04/2005 $70.00 000750 $14.00 FPN004962 $57.75 FPN004005 $15.30 08/03/2005 $10.00 FPN003824 $19.00 FPN004689 $16.20 FPN004750 $25.20 000676 $11.00 11/28/2005 $10.00 FPN005232 $9.00 09/26/2005 $10.00 FPN004476 $7.70 IZCN003100 $30.00 FPN004324 $41.70 FPN005665 $60.60 STDN000097 $19.00 FPN003695 $10.00 10/14/2005 $10.00 FPN004708 $21.50 10/05/2005 $5.00 FPN004598 $41.20 FPN005528 $60.60 09/12/2005 $25.00 FPN000223 $10.00 FPN004282 $24.90 FPN004540 $124.60 000749 $19.00 IZCN002798 $10.00 IZCN002639 $30.00 IZCN002285 $62.00 000867 $5.00 FPN004477 $111.00 11/08/2005 $10.00 FPN004989 $30.00 10/25/2005 $15.00 FPN004819 $5.40 12/01/2005 $20.00 FPN005286 $32.80 10/24/2005 $12.10 FPN004809 $17.60 FPN004839 $57.20 11/18/2005 $10.00 IZCN003448 $5.00 FPN005443 $16.20 FPN004120 $54.50 FPN005381 $10.00 FPN004871 $99.20 TBN002517 $32.00 12/07/2005 $10.00 FPN005336 $12.20 FPN004174 $40.90 09/22/2005 $20.00 FPN004438 $10.60 12/05/2005 $20.00 FPN005320 $47.60 FPN003613 $21.00 FPN004741 $19.00 FPN005393 $14.70 FPN005134 $25.00 FPN004957 $5.00 000830 $19.00 000853 $47.40 Last Last Payment Payment Ticket Number Patient Balance FPN003901 $29.00 11/21/2005 $15.00 IZCN003466 $41.00 10/18/2005 $10.00 FPN004747 $9.80 10/18/2005 $10.30 FPN004599 $30.80 FPN004749 $44.70 10/19/2005 $6.00 FPN004755 $75.60 FPN004182 $29.00 10/06/2005 $5.00 FPN003626 $14.00 11/30/2005 $15.00 FPN005256 $69.00 FPS000293 $13.20 FPN005323 $19.00 12/16/2005 $10.00 FPN005506 $9.00 08/11/2005 $13.00 FPN003934 $25.10 FPN004876 $5.00 FPN005343 $25.00 11/03/2005 $21.90 FPN003753 $3.00 FPN004930 $37.50 11/18/2005 $15.00 FPN005148 $45.60 09/21/2005 $5.00 000860 $59.20 12/09/2005 $15.00 FPN005402 $1.20 FPN005428 $24.90 FPN005126 $25.00 FPN003967 $13.20 09/29/2005 $12.00 IZCN002760 $53.00 FPN005367 $24.00 11/15/2005 $50.00 FPN005099 $97.00 FPN003925 $19.00 12/20/2005 $14.00 FPN005550 $3.10 FPN004547 $19.00 10/27/2005 $5.00 FPN004851 $33.10 000717 $29.00 10/05/2005 $40.00 FPN004579 $63.80 FPN004947 $24.00 FPN005247 $29.00 FPN004760 $45.30 FPN003594 $14.70 FPN003773 $14.70 FPN004688 $19.00 12/02/2005 $20.00 FPN005295 $222.40 IZCN003685 $30.00 IZCN003539 $90.00 IZCN003538 $48.00 10/27/2005 $1.00 MDN000104 $96.00 08/18/2005 $15.00 FPN000686 $14.00 000724 $40.20 08/15/2005 $60.00 FPN001951 $54.40 FPN004695 $29.00 FPN004524 $39.00 FPN004456 $5.00 09/30/2005 $41.00 FPN000359 $20.00 000866 $29.00 08/25/2005 $10.00 000771 $9.00 10/11/2004 $54.45 000176 $6.00 IZCN003087 $15.00 FPS000209 $5.00 FPS000245 $5.00 IZCN002474 $47.00 11/15/2005 $5.00 FPN005095 $40.30 FPN004191 $38.80 FPN004573 $15.30 FPN005642 $19.80 11/10/2005 $31.00 FPN003209 $64.70 Last Last Payment Payment Ticket Number Patient Balance 11/16/2005 $1.00 FPN005113 $18.00 09/09/2005 $10.00 FPN002334 $9.00 FPN005355 $60.60 12/07/2005 $20.00 FPN005353 $67.00 FPN005439 $29.00 12/13/2005 $7.00 000386 $118.00 IZCN002345 $30.00 12/06/2005 $10.00 FPN005326 $35.60 IZCN002522 $45.00 FPN005283 $77.90 IZCN002405 $65.00 FPN003712 $15.90 07/27/2005 $18.00 000548 $16.80 08/12/2005 $20.00 000722 $98.60 FPN004560 $10.00 10/04/2005 $7.00 FPN002386 $17.00 08/12/2005 $25.00 FPN002527 $4.00 IZCN002338 $62.00 10/05/2005 $37.30 FPN001538 $68.90 FPN004613 $174.50 10/05/2005 $10.00 FPN004576 $74.00 TBN002490 $10.00 FPN005513 $19.00 MDN000087 $23.00 09/20/2005 $35.80 FPN003888 $6.50 FPN005209 $16.20 FPN005261 $56.20 IZCN003241 $30.00 12/09/2005 $15.00 FPN005399 $25.20 11/01/2005 $15.00 IZCN003075 $15.00 08/09/2005 $25.00 000703 $26.15 09/21/2005 $20.00 FPN004399 $17.40 12/05/2005 $10.00 FPN005304 $15.00 10/24/2005 $3.80 FPN004805 $76.60 10/31/2005 $16.00 FPN004867 $5.90 FPN003911 $10.80 FPN004558 $70.20 10/05/2005 $25.00 FPN004595 $5.00 11/01/2005 $10.00 IZCN003084 $5.00 IZCN002457 $50.00 IZCN002459 $50.00 IZCN003547 $60.00 FPN004659 $19.00 FPN004859 $24.00 FPN002503 $10.00 FPN005228 $19.80 FPN003472 $24.00 FPN004396 $19.00 FPN004541 $19.00 FPN005474 $19.00 06/28/2005 $0.00 FPN001981 $19.00 FPN003992 $10.00 11/01/2005 $15.00 IZCN003079 $45.00 11/01/2005 $10.00 IZCN003083 $5.00 09/26/2005 $10.00 MCDP000011 $35.00 000733 $10.00 08/15/2005 $27.00 000725 $29.00 FPN005347 $10.00 IZNA000590 $25.00 09/29/2005 $15.00 IZCN002758 $65.00 FPN003873 $16.20 FP N003810 003810 $17.10 Last Last Payment Payment Ticket Number Patient Balance 09/19/2005 $20.00 000847 $86.00 11/02/2005 $19.60 FPN004911 $40.50 FPS000157 $46.75 FPN005344 $15.30 FPN003512 $103.80 08/23/2005 $3.70 000763 $1.40 FPN004625 $9.60 FPN004861 $9.60 12/19/2005 $10.00 FPN005530 $58.20 11/07/2005 $15.00 IZCN003202 $15.00 10/12/2005 $15.00 IZCN001770 $35.00 11/30/2005 $5.00 FPN005276 $24.00 FPN004829 $10.00 FPN004761 $29.00 FPN005374 $81.95 IZCN002280 $80.00 IZCN002274 $80.00 FPN004842 $44.10 07/11/2005 $5.00 STDN000080 $14.00 11/18/2005 $5.00 FPN005147 $24.00 IZCN002531 $45.00 FPN004906 $22.80 11/02/2005 $3.80 FPN004498 $64.90 FPN003596 $50.00 FPN005278 $19.00 FPN004162 $10.00 IZCN002604 $77.00 IZCN002603 $77.00 08/22/2005 $20.00 FPN004065 $11.35 FPN005601 $16.20 12/07/2005 $10.00 FPN005334 $138.35 000663 $19.00 IZCN002313 $65.00 IZCN002314 $80.00 IZCN002312 $50.00 FPN005552 $14.60 FPN003683 $70.20 07/20/2005 $43.00 STDN000088 $10.00 000651 $80.00 IZCN003076 $50.00 IZCN002325 $65.00 IZCN002261 $80.00 IZCN002286 $80.00 IZCN002290 $110.00 08/01/2005 $2.00 FPN003781 $33.00 FPN003952 $19.60 08/17/2005 $60.00 000680 $37.80 FPN005273 $35.00 IZCN003749 $45.00 08/01/2005 $15.00 IZCN002327 $65.00 IZCN002328 $15.00 IZCN002343 $95.00 IZCN002342 $92.00 IZCN002341 $107.00 IZCN003077 $15.00 10/31/2005 $20.00 FPN004870 $20.50 IZCN002435 $15.00 08/12/2005 $20.00 IZCN002449 $25.00 08/18/2005 $5.00 IZCN002480 $40.00 IZCN003747 $15.00 11/18/2005 $30.00 IZCN003447 $30.00 FPN003768 $76.80 . Last Last Payment Payment Ticket Number Patient Balance FPN004017 $10.50 IZCN002446 $30.00 IZCN002507 $15.00 IZCN002512 $45.00 11/28/2005 $15.00 FPN005229 $65.40 FPN005509 $31.50 IZCN002516 $45.00 09/16/2005 $30.00 000836 $31.00 11/16/2005 $10.00 FPN005111 $30.00 08/15/2005 $15.00 IZCN002450 $30.00 08/16/2005 $10.00 TBN002104 $35.00 08/31/2005 $30.00 IZCN002561 $15.00 11/01/2005 $15.00 IZCN003092 $15.00 08/25/2005 $50.00 FPN004107 $109.00 08/24/2005 $20.00 FPN004101 $26.90 08/26/2005 $15.00 FPN004121 $2.10 10/03/2005 $10.00 FPN004555 $9.00 IZCN002819 $30.00 IZCN002885 $77.00 08/24/2005 $10.00 MCDP000006 $35.00 IZCN002610 $20.00 IZCN002611 $20.00 09/27/2005 $5.00 FPN004479 $12.10 000804 $29.00 FPN004448 $61.00 000781 $193.20 FPN004557 $16.20 FPN004388 $101.90 IZCN002651 $15.00 TBN002794 $10.00 IZCN002666 $45.00 IZCN002679 $65.00 12/28/2005 $30.00 FPN005621 $41.30 10/05/2005 $27.00 FPN004592 $15.30 FPN005495 $21.90 09/28/2005 $2.90 FPN004496 $28.60 FPN004428 $16.20 09/22/2005 $50.00 FPN004430 $20.00 IZCN002656 $75.00 IZCN003476 $15.00 FPN004439 $45.60 FPN004509 $224.00 FPN004527 $5.00 09/26/2005 $10.00 FPN004457 $6.20 11/30/2005 $5.00 FPN005254 $29.00 11/28/2005 $45.00 IZCN003543 $3.00 FPS000263 $26.95 FPS000273 $128.70 09/26/2005 $125.00 FPN004474 $96.00 TRVN000456 $104.00 IZCN003481 $15.00 IZCN003518 $80.00 IZCN002880 $45.00 IZCN003697 $45.00 10/05/2005 $20.00 IZCN002797 $40.00 FPS000199 $104.00 10/18/2005 $20.00 FPS000203 $34.10 IZCN003276 $15.00 10/24/2005 $15.00 IZCN002964 $15.00 IZCN002914 $30.00 11/18/2005 $7.00 IZCN003459 $53.00 IZCN002963 $15.00 Last Last Payment Payment Ticket Number Patient Balance IZCN002941 $75.00 10/25/2005 $15.00 IZCN002971 $95.00 FPN004767 $264.00 10/24/2005 $25.00 FPN004810 $7.00 11/04/2005 $50.00 FPN004967 $155.00 10/27/2005 $20.00 FPN004843 $66.00 11/01/2005 $40.00 FPN004881 $133.80 IZCN003078 $15.00 FPN004830 $25.00 IZCN003091 $15.00 11/03/2005 $15.00 IZCN003142 $5.00 10/31/2005 $20.00 FPN004873 $25.00 IZAS000027 $25.00 MIZA000070 $25.00 11/08/2005 $5.00 FPN004991 $14.00 FPN005020 $31.35 11/21/2005 $10.00 IZCN003467 $25.00 11/17/2005 $15.00 FPN005119 $8.70 FPN005342 $21.90 IZCN003342 $51.00 11/16/2005 $10.00 FPN005106 $7.10 FPN005387 $94.80 11/14/2005 $20.00 FPN005080 $25.30 11/14/2005 $16.00 FPN005079 $25.10 11/16/2005 $16.20 FPN005112 $5.10 FPN005362 $75.30 TBN002682 $10.00 TBN002681 $10.00 11/30/2005 $30.00 IZCN003562 $30.00 11/30/2005 $30.00 IZCN003563 $45.00 FPN005231 $68.20 12/09/2005 $10.00 FPN005401 $24.00 FPN005617 $10.00 TRVN000505 $99.00 FPN005544 $15.30 12/19/2005 $40.00 FPN005423 $44.10 FPN005339 $140.40 IZCN003803 $15.20 12/13/2005 $10.00 FPN005446 $9.00 FPN005458 $100.90 12/16/2005 $10.00 FPN005499 - $77.30 IZCN003780 $45.00 12/28/2005 $14.00 IZCN003840 $1.00 $15,330.90 Hello