Loading...
HomeMy WebLinkAbout20123505.tiff 1 RESOLUTION RE: CANCELLATION OF 2012 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 2012 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$14,407.60. 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 $14,407.60, 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 12th day of December, A.D., 2012. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO\II\ATTEST: 0"Mti1� m , ; Sean P Co it Weld County Clerk to the Board Wi �m F`G ia, Pro-TernBY: Deputy Clerl the Bo �,, I y/^. �. 186! C; ara Kikkme er i /t.tAPPROVED AS TO FOR ' n?„�c '�,.,; s. 71 'J cM. ` ' David E. Long County Attorney c�( a wa G�n_ ougla Radernache Date of signature: [ l3l J63 CC. t,,b C 1c I, C-, . 1i-1 3 2012-3505 HL0019 a DEPARTMENT OF PUBLIC HEALTH AND ENVIRONMENT relit 1555 N. 17`"Avenue Greeley, CO 80631 PubllcHealth IWeb: http://www.co.weld.co.us/departments/healthenvironment/Healh Administration Public Health& inical ental 11 Emergency Vital Records ervices Services Education S.Planning & esponse Tele 970 304 6470 970 304 6420 T641120 le 21 30C. FOerf9 0304 vision tether with tse xro9]0u30o4�nities 6le serve wee elawroiking omeke'WeltlC 3 51 onty9he h70 ealthiest Placet 452 Fax 970304 live,learn, efi469rk tl Payth Communication, COLORADO TO: Sean Conway, Chair Board of County Commissioners FROM: Mark E. Wallace, MD, MPH, Executive Director Department of Public Health & Environment DATE: November 19, 2012 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, 2012. 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 $14,407.60. Enclosure cc: Barb Connolly, Controller 2012-3505 WARNING This report can make data changes in your system. Please read these instructions carefully. This report gives you the opportunity to write-off 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 write-offs 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/2012 Create these write-off transactions as conveyances for the payor: Old Balance Write-Off Create these write-off transactions in the batch: tgeiser_20121119 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/2012 Last Patient Name Last Payment Payment Ticket Number Patient Balance 11/04/2011 $24.00 IZCN016786 $49.50 IZCN016926 $44.10 MIZC003188 $29.40 MIZC003190 $29.40 FPN035986 $18.00 01/13/2012 $206.00 MDN001796 $78.00 IZCN017102 $29.40 IZCN016767 $44.10 FPN040621 $37.00 04/19/2012 $7.00 FPN039791 $57.00 IZCN016640 $44.10 03/28/2012 $10.00 FPN039425 $27.00 05/09/2012 $37.00 FPN040051 $64.00 FPN035377 $9.25 ZCN016209 $14.70 ZCN016435 $29.40 ZCN017109 $44.10 ZCN017163 $44.10 09/01/2011 $2000 ZCN016275 $9.40 ZCN016339 $14.70 ZCN016344 $73.50 08/18/2011 $35.00 ZCS001552 $38.50 ZCN016352 $44.10 ZCN016453 $73.50 ZCS001589 $14.70 ZCS001596 $102.90 ZCS001663 $29.40 ZCN016532 $14.70 09/26/2011 $37.50 FPN036523 $36.00 ZCN016571 $14.70 FPS002356 $9.25 ZCN016709 $14.70 12/12/2011 $20.00 ZCN016958 $24.10 FPN036981 $48.00 10/27/2011 $43.00 ZCS001651 $30.50 10/21/2011 $4.00 ZCN016703 $69.50 ZCS001664 $88.20 ZCN016889 $14.70 02/02/2012 $2.00 ZCN017112 $27.40 ZCN016784 $14.70 01/11/2012 $0.00 ZCS001703 $29.40 01/11/2012 $0.00 ZCS001704 $29.40 ZCN016887 $73.50 Last Patient Name Last Payment Payment Ticket Number Patient Balance IZCN016903 $29.40 IZCN016865 $14.70 MIZC003183 $29.40 MIZC003186 $14.70 FPS002346 $11.75 IZCN016888 $88.20 IZCN016982 $29.40 IZCN016983 $14.70 IZCN016990 $73.50 12/16/2011 $20.00 FPN037825 $92.50 IZCS001710 $73.50 IZCN017029 $88.20 IZCN017054 $73.50 01/10/2012 $40.00 IZCN017053 $18.80 IZCN017065 $58.80 FPN038349 $35.00 MIZC003324 $44.10 MIZC003323 $44.10 FPN039024 $29.00 FPN038745 $13.00 MIZA001243 $29.40 IZCN017322 $44.10 MIZC003322 $14.70 MIZC003301 $44.10 MIZC003411 $29.40 MIZC003326 $14.70 MIZC003319 $11.55 MIZC003414 $44.10 MIZC003317 $44.10 MIZC003415 $29.40 MIZC003313 $58.80 MIZC003413 $14.70 MIZC003304 $44.10 MIZC003400 $29.40 MIZC003309 $14.70 MIZC003344 $73.50 MDN002362 $8.00 FPN040429 $21.00 04/02/2012 $25.00 ZCN017234 $48.50 ZCS001809 $58.80 ZCS001821 $73.50 ZCS001827 $73.50 ZCS001829 $73.50 ZCS001830 $29.40 ZCS001831 $29.40 ZCS001828 $29.40 ZNA004443 $14.70 05/10/2012 $20.00 ZCN017293 $38.80 MIZA001281 $73.50 05/21/2012 $30.00 ZCN017318 $43.50 ZCS001846 $88.20 MIZC003438 $14.70 MIZC003430 $29.40 IZAS000279 $14.70 06/18/2012 $15.00 FPS002474 $6.00 SNHVH001828 $10.00 SNHVH001841 $10.00 NNHVH010068 $36.00 NNHVH010138 $12.00 FPN040209 $86.25 IZCN016362 $44.10 Last Patient Name Last Payment Payment Ticket Number Patient Balance IZCN017225 $29.40 IZCN017055 $29.40 12/08/2011 $40.00 IZCN016714 $33.50 02/06/2012 $84.75 FPN033952 $87.00 FPN036299 $46.00 11/04/2011 $23.00 IZCN016778 $6.40 IZCN016777 $14.70 IZCN016776 $58.80 IZCN016775 $14.70 06/26/2012 $25.00 MDN002400 $70.75 FPN036319 $122.00 10/28/2011 $5.00 IZCN016731 $9.70 08/22/2011 $20.00 IZCN016369 $24.10 IZCN016954 $44.10 12/01/2011 $15.00 IZCN016922 $58.50 08/04/2011 $20.00 IZCN016248 $24.10 08/15/2011 $20.00 IZCN016332 $24.10 FPN035858 $51.00 IZCN017329 $14.70 09/02/2011 $5.00 MIZC003151 $9.70 IZCN017285 $44.10 MIZC003154 $14.70 06/07/2012 $20.00 FPN035922 $5.00 MIZC003248 $58.80 MIZC003141 $88.20 IZCN017208 $14.70 IZCN017210 $44.10 IZCN016380 $29.40 IZCN016225 $58.80 IZCN016413 $58.80 IZCN016282 $44.10 IZCN016470 $44.10 IZCN017051 $14.70 FPN038388 $75.00 FPN038872 $64.00 04/24/2012 $16.00 FPN039837 $4.75 FPN035561 $47.50 04/10/2012 $57.00 STDN000146 $11.00 10/20/2011 $14.70 IZCN016682 $44.10 FPN035973 $48.00 06/11/2012 $5.00 FPN040443 $37.00 05/02/2012 $3.00 FPN039983 $10.00 03/01/2012 $45.00 FPN029678 $27.25 MDN002307 $2.00 07/27/2011 $10.00 FPN035677 $10.00 04/10/2012 $40.00 FPN039190 $29.50 FPN036685 $20.25 06/12/2012 $5.00 MDN002370 $3.00 FPN040364 $21.00 FPN036157 $9.00 08/11/2011 $20.00 MDN001857 $8.00 04/03/2012 $20.00 FPN039495 $51.00 FPN040112 $37.50 FPN040181 $24.50 FPN040104 $21.00 FPN037556 $30.75 11/14/2011 $20.00 FPN034194 $17.50 05/29/2012 $10.00 FPN040283 $47.50 FPN035828 $10.00 IZNA004322 $29.40 FPN037047 $9.00 Last Patient Name Last Payment Payment Ticket Number Patient Balance STDS000035 $66.00 01/04/2012 $20.00 FPN038050 $15.00 04/02/2012 $28.00 FPN035415 $3.25 11/10/2011 $70.00 MDN001311 $185.00 05/30/2012 $10.00 FPN040259 $160.00 04/19/2012 $10.00 FPN037644 $52.00 FPN039785 $37.00 FPN037926 $15.50 IZCN016378 $58.80 09/14/2011 $94.00 IZCN016484 $8.90 01/05/2012 537.00 FPN038085 $6.00 12/19/2011 $36.00 FPN036019 $13.50 FPN039017 $8.00 FPN041154 $64.00 MDN002399 $2.00 03/15/2012 $20.00 FPN039237 $22.00 07/15/2011 $10.00 FPN035158 $10.00 FPN039474 $64.00 03/21/2012 $20.00 FPN039317 $14.50 FPN039780 $64.00 FPN011916 $10.00 12/27/2011 $75.00 MDN001485 $11.25 01/31/2012 $20.00 FPN038507 $64.00 01/18/2012 $138.00 FPN038288 $169.00 04/27/2012 $226.00 MDN001724 $38.00 FPN039648 $8.00 06/01/2012 $66.00 STDN000184 $112.00 10/03/2011 $10.00 FPN036657 $10.00 05/14/2012 $20.00 FPS002455 $17.00 FPN040461 $64.00 12/09/2011 $22.00 FPN034995 $40.00 FPN039134 $11.00 FPN038594 $14.00 01/24/2012 $20.00 MDN002125 $1.00 10/28/2011 $20.00 FPN037052 $15.00 12/30/2011 $186.00 MDN002065 $78.00 10/27/2011 $7.00 FPN037032 $58.50 FPN037642 $62.00 06/25/2012 $37.00 FPN040612 $32.00 01/10/2012 $99.00 MDN001818 $165.00 MDN002021 $9.00 09/15/2011 $25.00 FPN032743 $27.50 07/07/2011 $15.00 FPN031887 $5.00 05/02/2012 $15.00 FPN039973 $91.50 12/16/2011 $5.00 FPN037831 $5.00 FPN040544 $37.00 FPN039629 $13.00 10/14/2011 $10.00 FPN036852 $1.75 03/06/2012 $29.25 MDN002218 $19.50 FPN036035 $32.25 FPN035802 $33.50 FPN037189 $28.75 FPN036606 $37.50 04/18/2012 $10.00 FPN032641 $26.00 FPN039747 $30.00 MDN002317 $88.00 FPN039938 $80.00 MDN002488 $182.00 02/08/2012 $5.00 FPN038629 $21.00 FPN037405 $26.50 FPN036553 $17.25 Last Patient Name Last Payment Payment Ticket Number Patient Balance IZCN016755 $44.10 IZCN016781 $88.20 11/14/2011 $14.70 IZCN016853 $44.10 IZCN016271 $44.10 11/16/2011 $20.00 FPN037336 $8.00 IZCN016782 $29.40 06/19/2012 $10.00 FPN039381 $32.00 12/08/2011 $14.70 IZCS001720 $58.80 09/26/2011 $30.10 IZCN016559 $14.00 09/09/2011 $15.00 FPN036279 $26.00 IZCN016398 $29.40 IZCN016452 $29.40 FPS002352 $5.00 10/19/2011 $20.00 FPS002318 $5.00 03/02/2012 $236.00 MDN002207 $169.00 07/06/2011 $20.00 FPS002227 $8.00 FPN038038 $307.00 MDN002160 $64.00 08/30/2011 $0.00 IZCS001542 $88.20 IZCS001744 $58.80 07/08/2011 $40.00 IZCS001289 $48.20 IZCS001506 $14.70 01/30/2012 $20.00 FPS002393 $1.00 IZCN016445 $14.70 MIZC003153 $44.10 MIZC003152 $58.80 IZCN016446 $58.80 12/29/2011 $2.00 FPN029702 $15.25 02/02/2012 $21.00 FPN038547 $14.00 03/01/2012 $10.00 FPN039011 $20.00 MDN002419 $2.00 05/15/2012 $28.50 FPN040143 $18.50 12/28/2011 $11.00 FPN037965 $22.00 FPN036947 $10.00 10/21/2011 $20.00 FPN033788 $6.00 FPN039704 $57.50 04/25/2012 $20.75 FPN039859 $9.25 STDN000157 $136.00 FPN035634 $81.00 03/14/2012 $4.00 FPN039205 $17.75 FPN040219 $56.25 06/21/2012 $10.00 FPN040595 $27.00 FPN036156 $21.25 FPN036871 $11.75 FPN039645 $8.00 FPN036547 $34.75 FPN039879 $47.00 07/18/2011 $20.25 FPN035498 $9.00 09/09/2011 $2.00 FPN034081 $33.00 FPN036298 $9.00 02/29/2012 $191.00 FPN038958 $79.00 MDN002288 $180.00 04/05/2012 $9.00 FPN039214 $55.00 04/13/2012 $20.00 FPN037510 $7.00 01/18/2012 $191.00 MDN002109 $79.00 FPN036949 $62.00 05/25/2012 $2.00 FPN040261 $21.00 FPN039090 $195.00 10/19/2011 $221.00 MDN001795 $43.00 01/19/2012 $25.00 FPN038324 $26.00 02/08/2012 $191.00 MDN002164 $79.00 Last Patient Name Last Payment Payment Ticket Number Patient Balance 01/06/2012 $38.00 FPN038099 $9.25 IZCN016981 $44.10 FPN037445 $20.00 FPN040570 $21.00 12/09/2011 $6.00 FPN037714 $3.00 IZCN016174 $14.70 FPN038486 $37.00 01/31/2012 $9.00 FPN038501 $7.00 07/07/2011 $1.00 FPN035315 $9.00 09/22/2011 $215.00 MDN001262 $40.00 12/28/2011 $10.00 FPN037956 $18.00 IZCN016156 $14.70 IZCN017192 $14.70 11/03/2011 $20.00 FPN037157 $29.25 03/02/2012 $3.00 FPN039029 $15.00 08/17/2011 $20.00 FPN035417 $38.00 04/23/2012 $57.00 STDN000154 $109.00 05/14/2012 $67.00 STDN000171 $62.00 05/17/2012 $30.75 FPN040171 $9.25 FPN036415 $28.00 MDN002390 $10.00 11/18/2011 $20.00 FPN037430 $8.00 FPN036197 $20.00 FPN037751 $23.00 09/28/2011 $20.00 FPN036562 $66.50 08/16/2011 $20.00 MDN001871 $135.00 FPN035838 $44.50 FPN036228 $25.50 04/24/2012 $5.00 FPN039847 $32.00 05/11/2012 $57.00 FPN040108 $20.00 06/04/2012 $30.00 FPN040359 $30.00 FPN041153 $64.00 04/17/2012 $121.50 FPN039370 $7.75 FPN039864 $54.75 IZCN016929 $14.70 04/18/2012 $61.00 FPN035866 $27.00 02/17/2012 $20.00 FPN038815 $19.00 10/10/2011 $22.00 IZCN016639 $22.10 06/15/2012 $9.00 FPN040524 $21.00 M1ZC003347 $73.50 01/27/2012 $57.00 FPN034398 $55.00 FPN037807 $99.00 FPN038003 $18.50 FPN036974 $12.50 06/20/2012 $62.00 STDN000195 $4.00 06/04/2012 $15.00 IZCN017348 $29.10 08/26/2011 $30.00 IZCN016405 $14.10 09/12/2011 $10.00 IZCN016465 $78.20 09/12/2011 $10.00 IZCN016466 $78.20 IZCN016266 $44.10 04/19/2012 $8.25 FPN039779 $37.50 MDN002420 $36.00 FPN039111 $62.75 11/01/2011 $20.00 FPN037109 $96.00 FPN037483 $64.25 08/17/2011 $11.00 FPN035960 $0.50 IZCN016860 $58.80 MIZC003274 $73.50 MIZC003187 $58.80 IZCN016416 $44.10 FPN037438 $11.00 Last Patient Name Last Payment Payment Ticket Number Patient Balance 03/23/2012 $57.00 STDN000129 $20.00 10/05/2011 $186.00 MDN001922 $78.00 04/11/2012 $37.00 FPN039637 $37.00 FPN039128 $19.00 IZCN016444 $58.80 IZCN016984 $44.10 IZCN017186 $58.80 06/07/2012 $5.00 FPN040399 $45.00 IZNA004347 $14.70 MIZC003192 $73.50 IZCN017014 $58.80 NNHVH009201 $36.00 06/15/2012 $21.00 FPN040529 $2.75 09/22/2011 $20.00 FPN036146 $9.25 01/11/2012 $10.00 FPN038165 $6.00 07/21/2011 $23.00 FPN035584 $5.00 $14,407.60 Esther Gesick From: Barb Connolly Sent: Monday, December 10, 2012 10:35 AM To: Esther Gesick Subject: FW: Centricity Write-Offs for 2012 Attachments: 2012-11-19 Write-Off Memo.docx; 2012 Write-Off Redacted 11-19-12.pdf Esther, Please put on the agenda for the BOCC hearing. If Wednesday is a long agenda we can go on Monday the 17`°. Just let me know. Fad &toothy. ePi4 Barbara Connolly, CPA Weld County Government Controller 1150 O Street Greeley, CO 80631 (970)356-4000 ext 4445 Confidentiality Notice: This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure, copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. From: Tanya Geiser Sent: Tuesday, November 20, 2012 7:34 AM To: Barb Connolly Subject: Centricity Write-Offs for 2012 Hi Barb, Attached are the memo and Centricity report requesting the permission of the Commissioners to write-off old balances in Centricity. Please let me know if you need anything further or if you have any questions.Thanks! With best regards, Tanya Tanya Geiser Public Health Administrative Services Coordinator Weld County Department of Public Health & Environment 1 1555 North 17th Avenue, Greeley, CO 80631 Phone: 970-304-6410, ext 2122 Fax: 970-304-6412 Email: tgeiser@co.weld.co.us I88 L ? II w Co` u Confidentiality Notice:This electronic transmission and any attached documents or other writings are intended only for the person or entity to which it is addressed and may contain information that is privileged,confidential or otherwise protected from disclosure. If you have received this communication in error, please immediately notify sender by return e-mail and destroy the communication. Any disclosure,copying, distribution or the taking of any action concerning the contents of this communication or any attachments by anyone other than the named recipient is strictly prohibited. 2 Hello