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