Loading...
HomeMy WebLinkAbout20063478.tiff 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$17,853.70. 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 $17,853.70, 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 20th day of December, A.D., 2006. �` BOARD OF COUNTY COMMISSIONERS WELD COUNTY LORADO ATTEST: Unay r t� 4,2 . Geile, Chairman Weld County Clerk to the B rd �v,==-�y► t"Y �J.CUSED 471 % /riavid E. Long, Pro-Tem BY: - it-If' Defy ty Cler o the Board "LT i�L ✓ ( Wi iam H. Jerke APPROVED AS TO-F MS ;kJ _ Robert D. / ' County Attorney ___ ___psi/_fr Glenn Vaa Date of signature: I I`i IL 2006-3478 HL0019 (7; ;//c , 4G O/ -D S -O-12 Memorandum TO: M.J. Geile, Chair Board of County Commissioners FROM: Mark E. Wallace, MD, MPH, Director ODepartment of Public Health and �� Environment 'UnCUx r itopta"t. COLORADO• DATE: December 15, 2006 j 4 r 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 July 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 $17,853.70. Enclosure Cc: Barb Connolly, Controller 2006-3478 - 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/2006 Create these write-off transactions as conveyances for the payor. Old Balance Write-Off Create these write-off transactions in the batch: jnero_20061215 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/2006 Last Patient Name Last Payment Payment Ticket Number Patient Balance FPN007881 $84.50 05/22/2006 $30.00 FPN007541 $134.45 06/08/2006 $10.00 FPN007756 $9.00 06/21/2006 $5.00 FPN007922 $101.50 05/08/2006 $10.00 FPN007363 $17.60 03/28/2006 $10.00 FPN006863 $17.60 06/22/2006 $28.00 FPN007943 $28.50 05/24/2006 $15.00 FPN007565 $31.80 FPN006183 $27.60 03/03/2006 $20.00 FPN006547 $7.60 02/01/2006 $18.00 FPN005476 $13.50 FPN007511 $61.50 04/03/2006 $20.00 FPN006780 $20.00 FPN006935 $29.00 04/12/2006 $10.00 FPN007061 $6.50 03/01/2006 $20.00 FPN006504 $40.60 FPN006109 $29.00 02/03/2006 $10.00 FPN006128 $5.90 FPN005676 $24.00 FPN006434 $16.50 FPN007150 $16.50 FPN006898 $20.10 FPN006213 $29.00 02/15/2006 $13.00 FPN006307 $42.80 04/14/2006 $16.00 FPS000369 $4.10 FPS000417 $20.10 FPS000469 $30.00 01/16/2006 $10.00 FPN005855 $26.30 05/01/2006 $10.00 FPN007285 $96.50 01/10/2006 $19.00 FPN005786 $10.00 FPN007407 $5.00 06/08/2006 $5.00 FPN007771 $14.00 01/16/2006 $5.00 FPN005858 $14.00 05/22/2006 $25.00 FPN007549 $7.00 06/02/2006 $10.00 FPN007685 $20.00 05/08/2006 $40.00 FPN006149 $47.50 02/10/2006 $10.00 FPN006207 $113.90 FPN006688 $30.00 FPN007148 $19.00 06/05/2006 $52.80 FPN006088 $63.20 02/23/2006 $10.00 FPN006411 $19.00 06/05/2006 $10.00 FPN007708 $30.80 02/09/2006 $50.00 IZNA001159 $23.00 Last Patient Name Last Payment Pavment Ticket Number Patient Balance 02/09/2006 $30.00 FPN006052 $30.90 05/17/2006 $10.00 FPN007491 $17.60 02/16/2006 $15.00 FPN006323 $33.70 FPS000355 $355.00 02/17/2006 $10.00 FPN006329 $9.00 01/26/2006 $10.00 FPN005987 $106.80 05/24/2006 $20.00 FPN007586 $20.50 02/10/2006 $10.00 FPN006241 $84.50 01/25/2006 $5.00 FPN005999 $15.10 03/17/2006 $5.00 FPN006735 $45.70 FPN007474 $43.80 FPN007506 $27.60 06/30/2006 $6.00 FPN008055 $13.00 FPN005912 $75.60 03/06/2006 $15.00 FPN006564 $4.00 FPN006534 $19.00 FPN006303 $29.00 FPN006866 $34.00 FPN006172 $36.85 FPN006185 $98.75 03/13/2006 $10.00 FPN006664 $9.00 FPN006850 $29.00 FPN007224 $39.00 05/08/2006 $45.00 FPN005005 $12.75 02/10/2006 $5.00 FPN006216 $57.70 FPN007377 $57.90 FPN007630 $19.00 02/27/2006 $15.00 FPN006463 $66.00 03/08/2006 $10.00 FPN006586 $50.00 FPN006937 $33.00 05/16/2006 $10.00 FPN007468 $52.50 01/03/2006 $112.00 FPN005984 $226.00 MDN000153 $10.00 FPN005687 $19.00 MDN000170 $196.00 06/14/2006 $20.00 FPN007837 $30.00 06/07/2006 $25.00 FPN007648 $46.00 FPN008035 $16.50 FPN005969 $19.00 IZCN004970 $30.00 FPN007995 $62.10 05/11/2006 $2.00 FPN007412 $27.00 FPN007124 $29.00 05/12/2006 $10.00 FPN007159 $9.00 FPN007442 $24.00 04/06/2006 $30.00 FPN006995 $44.25 FPN006561 $29.00 05/15/2006 $20.00 FPN007454 $63.00 IZCN004246 $43.00 IZCN004245 $43.00 05/26/2006 $5.00 FPN007617 $5.00 IZCN005484 $21.60 04/12/2006 $10.00 FPN007067 $5.90 FPN005954 $46.50 FPN007975 $108.60 05/11/2006 $30.00 FPN007430 $24.00 FPN007729 $19.00 04/12/2006 $12.00 FPN007050 $15.60 01/12/2006 $10.00 FPN005819 $17.60 05/03/2006 $20.00 FPN007296 $114.10 IZCN004356 $111.00 01/23/2006 $20.00 FPN005962 $86.50 Last Patient Name Last Payment Payment Ticket Number Patient Balance FPN007848 $5.00 FPN006462 $16.50 FPS000403 $26.00 06/16/2006 $20.00 FPS000046 $40.00 MDN000201 $80.00 FPN006190 $21.00 FPN006872 $104.00 06/05/2006 $25.00 FPN005098 $78.00 01/27/2006 $5.00 FPN006046 $24.00 FPN006267 $46.50 05/22/2006 $2.00 FPN007557 $17.00 IZCN005375 $111.00 01/31/2006 $15.00 FPN006077 $51.00 02/10/2006 $27.00 FPN004729 $32.40 FPN009189 $19.00 FPN007449 $27.60 FPN007599 $36.00 04/12/2006 $80.00 FPN007066 $295.20 IZCN005467 $63.00 TBN004178 $10.00 05/05/2006 $5.00 FPN007337 $14.00 FPN007030 $19.00 02/03/2006 $10.00 FPN006136 $25.00 02/27/2006 $30.00 FPN006461 $30.90 IZCN003959 $15.00 06/23/2006 $30.00 FPN007961 $100.35 04/12/2006 $20.00 FPN007070 $214.15 05/08/2006 $25.00 FPN004903 $3.50 FPN007762 $62.50 FPN007882 $17.40 FPN007970 $26.10 01/10/2006 $10.00 FPN005779 $19.00 000998 $61.80 IZCN004103 $100.00 05/10/2006 $30.00 FPN007397 $76.50 04/21/2006 $34.20 FPN001805 $79.40 06/15/2006 $20.00 FPN007853 $51.70 01/23/2006 $4.00 FPN005916 $19.00 FPN006557 $16.50 IZCN004021 $111.00 FPN005748 $66.55 04/03/2006 $5.00 IZCN004551 $58.00 FPN006565 $15.00 FPN005735 $19.00 FPN008030 $29.00 FPN007811 $19.00 FPN006184 $30.00 06/16/2006 $10.00 FPN007876 $9.00 06/19/2006 $11.00 FPN007894 $53.50 03/27/2006 $1.50 FPN006847 $57.40 FPN005993 $27.50 FPN005756 $132.60 IZCN004089 $50.00 03/08/2006 $15.00 FPN006591 $10.00 04/06/2006 $20.00 FPN006981 $9.00 MDN000214 $80.00 01/05/2006 $10.00 FPN005728 $14.00 IZCN004389 $74.00 01/06/2006 $5.00 FPN005730 $14.00 FPN005771 $24.00 FPN005867 $24.00 FPN007328 $19.00 Last Patient Name Last Payment Payment Ticket Number Patient Balance FPN005921 $123.90 06/06/2006 $103.00 FPS000441 $37.00 FPN006759 $25.00 05/19/2006 $10.00 FPN006552 $9.00 FPN007566 $33.00 05/22/2006 $15.00 FPN006723 $4.00 06/20/2006 $10.00 FPN007899 $6.50 03/24/2006 $20.00 FPN006839 $20.20 02/17/2006 $20.00 FPN006336 $7.60 03/13/2006 $50.00 FPN006658 $10.90 05/08/2006 $5.00 IZCN004900 $10.00 03/06/2006 $25.00 IZCN004349 $50.00 FPN006112 $121.00 IZNA001196 $62.00 TBN003605 $9.90 TBN003653 $21.60 FPN007571 $33.60 FPN007165 $6.90 FPN007443 $9.00 TBN003604 $9.90 06/19/2006 $40.00 FPN007890 $27.80 FPN006703 $31.20 FPN006151 $31.80 FPN007981 $35.40 FPN007781 $10.00 FPN007662 $19.00 FPN007022 $30.00 FPN007948 $19.00 FPN006824 $19.00 FPS000314 $40.20 FPN006856 $127.30 06/08/2006 $1.50 FPN007763 $49.10 05/03/2006 $44.00 FPN005808 $59.90 06/13/2006 $8.00 FPN007826 $11.00 FPN008018 $19.00 FPN007926 $19.00 TBN003143 $33.00 FPN007316 $19.00 FPN007698 $27.60 05/26/2006 $17.75 FPN005259 $77.40 04/13/2006 $15.00 IZCN004623 $33.00 FPS000334 $4.00 12/21/2005 $50.00 000971 $113.00 02/01/2006 $15.00 FPN006106 $1.50 FPN006576 $19.00 FPN005677 $52.80 03/03/2006 $50.00 FPN006550 $14.70 FPN007318 $86.10 03/17/2006 $30.00 FPN006724 $20.60 05/15/2006 $30.00 FPN007452 $76.50 05/23/2006 $4.00 FPN007427 $12.00 03/21/2006 $3.00 FPN006730 $60.00 FPN007900 $48.95 FPN005872 $53.10 FPN007902 $29.00 FPN005686 $65.60 06/29/2006 $5.00 FPN008036 $36.00 03/20/2006 $30.00 FPN006750 $36.00 FPN006965 $30.00 01/18/2006 $5.00 FPN005891 $5.00 FPN005998 $26.00 FPN006356 $17.40 Last Patient Name Last Payment Payment Ticket Number Patient Balance FPN005707 $16.50 FPN006527 $10.80 06/28/2006 $10.00 FPN008020 $17.60 FPN006560 $91.90 FPN006304 $35.40 02/14/2006 $3.00 FPN006275 $26.00 FPN007621 $16.50 FPN007643 $16.50 FPN007840 $22.50 FPN005861 $16.50 02/27/2006 $9.60 000768 $113.40 01/23/2006 $10.00 IZCN004042 $71.00 FPN008008 $24.30 03/22/2006 $3.50 FPN006790 $45.10 FPS000414 $19.00 FPS000398 $29.00 05/23/2006 $20.00 FPN007579 $130.00 FPN007681 $117.00 FPN007944 $24.00 IZNA001221 $10.00 TBN003436 $33.00 IZCN004436 $90.00 IZCN004918 $60.00 FPN007605 $27.60 FPN007254 $19.00 FPN007813 $19.00 04/10/2006 $30.00 FPN007039 $9.90 05/11/2006 $10.00 FPN005371 $11.90 FPN007820 $5.10 03/15/2006 $20.00 IZCN004429 $40.00 FPN008067 $10.00 FPN007458 $19.00 04/24/2006 $10.00 FPN005521 $34.70 02/17/2006 $5.00 FPN006340 $14.00 04/06/2006 $10.00 FPN006991 $7.40 05/10/2006 $15.00 IZCN004905 $45.00 IZCN003881 $15.00 IZCN003946 $30.00 IZCN003874 $60.00 IZCN004824 $30.00 IZCN004451 $45.00 MDN000200 $80.00 IZCN004423 $30.00 06/01/2006 $1.00 FPN007606 $18.00 FPN006870 $92.00 FPN007829 $92.00 04/12/2006 $5.00 FPN007065 $11.50 FPN006051 $111.65 02/17/2006 $20.00 FPN006330 $154.65 FPN007390 $83.00 FPN007234 $38.40 01/10/2006 $30.00 000968 $1.20 01/26/2006 $15.00 FPN006012 $25.50 MDN000225 $80.00 01/18/2006 $7.60 FPN005895 $7.40 FPN006392 $15.00 FPN007921 $67.80 03/15/2006 $56.00 MIZC000575 $55.00 06/30/2006 $10.00 FPN008057 $44.00 FPN007856 $50.60 06/15/2006 $9.75 FPS000397 $52.95 FP N006253 $19.20 Last Patient Name Last Payment Payment Ticket Number Patient Balance 02/10/2006 $10.00 FPS000278 $77.00 IZCN003905 $15.00 01/09/2006 $60.00 IZCN003625 $45.00 FPN007456 $34.00 IZCN003916 $45.00 IZCN004148 $14.80 IZCN003933 $90.00 02/21/2006 $30.00 IZCN003804 $15.00 FPN007021 $113.30 IZCN003866 $45.00 02/15/2006 $10.00 FPN006300 $19.00 FPN006545 $19.00 FPN007634 $10.00 04/26/2006 $20.00 FPS000304 $41.00 FPN005789 $10.00 FPN005741 $24.00 01/17/2006 $25.00 FPN005882 $34.00 05/22/2006 $5.00 FPN007548 $24.00 03/01/2006 $5.00 FPN006456 $25.00 FPN005835 $258.00 FPN005763 $17.40 FPN007792 $102.30 01/13/2006 $10.00 FPN005825 $180.30 06/14/2006 $65.00 IZCN004250 $10.00 IZCN003974 $45.00 IZCN003973 $45.00 01/27/2006 $10.00 FPN006044 $22.00 IZCN004003 $45.00 IZCN004566 $48.00 IZCN004125 $131.00 IZCN004126 $96.00 FPN006683 $27.50 FPN005905 $70.90 FPN005901 $6.60 FPN006828 $15.90 FPN007616 $16.50 FPN006770 $10.00 01/25/2006 $25.00 IZCN004052 $20.00 FPN005947 $17.40 FPN006027 $160.60 FPN006037 $16.50 IZCN004113 $90.00 FPN007333 $14.80 IZNA001144 $77.00 01/30/2006 $20.00 IZCN004099 $10.00 IZCN004124 $56.00 02/06/2006 $5.00 IZCN004150 $40.00 FPN006245 $17.40 FPN006459 $29.00 MDN000197 $32.00 FPN006332 $173.25 MDN000210 $70.00 FPN006269 $31.90 02/15/2006 $30.00 FPN006299 $33.90 FPN007001 $27.00 FPN006305 $29.00 IZNA001174 $46.00 IZCN004272 $63.00 IZCN004381 $60.00 IZCN004383 $45.00 IZCN004384 $45.00 FPN006589 $15.90 Last Patient Name Last Payment Payment Ticket Number Patient Balance FPN006479 $74.40 IZCN004344 $45.00 FPN006622 $16.00 FPN006623 $35.00 03/13/2006 $15.00 IZCN004414 $45.00 03/14/2006 $86.95 FPN006675 $6.60 FPN006679 $49.00 IZCN004440 $15.00 IZCN004441 $45.00 IZCN004479 $75.00 FPN006708 $104.80 IZCN004485 $30.00 IZCN004494 $45.00 04/10/2006 $30.00 FPN006892 $66.00 06/28/2006 $25.00 FPN008009 $13.00 FPN007477 $15.00 FPN007056 $201.85 FPN006983 $16.50 IZCN004906 $14.80 IZNA001226 $15.40 FPN007080 $19.00 IZNA001229 $77.00 FPN007275 $27.60 FPN007141 $63.90 04/26/2006 $15.00 IZCN004799 $30.00 FPN007806 $45.00 FPS000425 $17.40 FPN007387 $53.00 05/11/2006 $10.00 FPN007396 $66.00 FPN007438 $66.90 05/22/2006 $20.00 IZCN004986 $40.00 05/15/2006 $140.00 IZNA001265 $33.00 05/22/2006 $20.00 FPN007546 $64.90 06/12/2006 $10.00 FPN007787 $67.70 IZCN004975 $45.00 FPN007567 $63.10 IZCN005051 $60.00 IZCN005069 $90.00 FPN007770 $17.40 06/12/2006 $20.00 FPN007800 $36.70 FPN007892 $17.40 TBN003814 $69.00 TBN003789 $69.00 TBN003772 $69.00 TBN003784 $69.00 FPN007946 $16.50 FPS000505 $5.00 FPN007980 $16.50 FPN007987 $29.10 FPN008050 $79.20 NHVN003216 $192.00 $17,853.70 Hello