Loading...
HomeMy WebLinkAbout20213533.tiffRESOLUTION RE: CANCELLATION OF 2021 OUTSTANDING ACCOUNTS RECEIVABLE FOR 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 the 2021 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 uncollectable in accordance with guidelines adopted by the 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,419.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 $15,419.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 27th day of December, A.D., 2021. BOARD OF COUNTY COMMISSIONERS WELD COUNTY, COLORADO ATTEST vo Weld County Clerk to the Board BY Deputy Clerk to the Board APPROVED AS T. - •RM: Y Date of signature: zal Mo eno, Chair Mike Freeman Lori Saine CC: HL(TG), AGT(cb), F2(cP) 11/3o/2k 2021-3533 HL0053 Esther Gesick Subject: Attachments: FW: 2021 Centricity/Banner Old Balance Write -Off REDACTED WCDPHE 2021 Proposed Centricity Patient Balance Write-Offs.pdf From: Tanya Geiser <tgeiser@weldgov.com> Sent: Monday, December 20, 2021 11:11 AM To: Chris D'Ovidio <cdovidio@weldgov.com> Cc: Mark Lawley <mlawley@weldgov.com> Subject: 2021 Centricity/Banner Old Balance Write -Off Hello, Chris, 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 April 1, 2021. 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 patients' names have been redacted from the report in accordance with HIPAA guidelines. The total amount requested to be written off as of December 20, 2021, is $15,419.60, which is consistent with last year's write-off of $15,720.49. Once you have received formal approval from the Board to write-off these balances, please let me know and I will take the final necessary steps in Centricity to complete the write-offs before the end of this year. Please let me know if you have any questions or if I can provide further information in this regard. Thanks! Tanya Tanya Geiser Public Health Finance Director Weld County Department of Public Health & Environment 1555 North 17th Avenue, Greeley, CO 80631 IN Direct 970-400-2122 Iiir Main Switchboard 970-304-6410 Fax: 970-304-6412 tgeiser@co.weld.co.us www.weldhealth.org A, Please think green before printing this email. Public Health 1 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: Create these write-off transactions as conveyances for the payor: Create these write-off transactions in the batch: Create these write-off transactions as adjustments of type: Company: Weld County Dept of Public Health and Environment - Last Payment Date before: 04/01/2021 Patient Name Last Payment 09/17/2020 04/24/2020 03/08/2021 08/04/2020 08/17/2020 08/19/2020 10/02/2020 08/17/2020 01/06/2021 10/30/2020 01/26/2021 Las( Payment Ticket Number FPN076607 $15.00 FPN076631 FPN077322 IZN0 11440 FPN075838 FPN076669 IZN004424 $56.44 FPN074595 $411.50 MDN003945 FPN076089 FPN075953 STDN003162 STDN003019 FPN076261 $40.00 IZN003797 IZN003813 $13.00 FPN076380 $41.50 FPN076401 $28.00 FPN076749 STDN003127 STDN003134 IZN004286 TBN035889 FPN077280 STDN003287 FPN 075906 FPN075930 $400.00 MDN003977 FPN077160 STDN003182 FPN077251 STDN003249 FPN077448 $101.25 FPN077285 STDN003286 FPN077002 STDN003229 $29.00 FPN076918 STDN003242 FPN076503 FPN076656 FPN076746 $20.00 FPN077412 04/01/2021 Old Balance Write -Off tgeiser 20211220 Write Off Patient Balance $45.40 $37.25 $35.09 $51.00 $137.00 $16.00 $52.00 $80.00 $150.50 $153.39 $21.00 $44.16 $117.00 $373.00 $315.00 $355.00 $69.00 $30.10 $40.00 $122.78 $52.00 $46.90 $105.00 $106.69 $21.57 $83.00 $51.00 $44.00 $29.00 $123.67 $48.00 $46.57 $29.19 $71.25 $266.00 $94.50 $289.65 $140.50 $50.00 $137.00 $108.00 $192.00 $85.00 2021-3533 IZ/Z1 1+l,0OS3 Last Payment 07/15/2020 09/10/2020 09/01/2020 08/21/2020 09/28/2020 04/16/2020 12/23/2020 06/26/2020 09/14/2020 01/18/2021 11/05/2020 09/03/2020 09/14/2020 09/04/2020 03/24/2021 08/06/2020 05/01/2020 07/23/2020 04/07/2020 08/03/2020 01/04/2021 03/30/2021 02/11/2021 02/11/2021 03/31/2021 Las Payment Ticket Number Patient Balance FPN077512 FPN076484 FPN077694 FPN075926 FPN076491 FPN076897 $40.00 STDN002742 FPN076146 FPN076318 STDN003159 FPN077132 $20.00 FPN076587 FPN076684 FPN077501 FPN077539 $20.00 FPN076517 FPN076578 $22.00 FPN076426 $37.50 FPN076709 FPN076070 FPN077585 FPN076628 FPN075813 FPN076413 $100.00 FPN074405 FPN076983 $10.00 FPN077236 $10.00 FPN076034 FPN076732 $39.00 FPN076608 $30.00 FPN077364 MDN003968 $53.00 FPN076026 FPN076899 FPN077273 $11.00 FPN076536 FPN075892 FPN077566 FPN077367 FPN077540 $10.00 FPN076611 FPN076816 $11.00 FPN076559 $40.00 FPN077728 $30.00 FPN076313 $13.25 FPN075707 FPN075782 $50.00 FPN076196 $5.00 FPN075617 STDN003316 FPN076854 $73.00 FPN076219 $80.00 FPN076150 FPN076959 FPN077061 $23.00 FPN077764 $0.00 FPN076750 $0.00 MDN003981 FPN077394 FPN076110 $40.00 FPN077771 STDN003283 $52.00 $47.75 $34.00 $90.01 $160.91 $57.88 $151.51 $20.06 $4.01 $40.13 $39.35 $121.50 $115.50 $25.25 $20.00 $83.00 $51.00 $103.00 $29.00 $486.00 $6.59 $29.00 $5.18 $44.50 $218.00 $171.00 $39.87 $29.00 $172.00 $82.50 $35.50 $11.00 $30.00 $59.50 $41.00 $12.00 $31.00 $7.00 $176.12 $41.00 $73.00 $51.00 $12.00 $14.00 $83.00 $24.79 $8.67 $33.00 $40.00 $190.00 $27.50 $10.00 $53.00 $83.00 $40.00 $25.00 $21.06 $38.40 $111.00 $51.00 $45.00 $108.00 Last Payment 03/25/2021 06/29/2020 12/18/2020 03131/2021 03/01/2021 12/11/2020 03/04/2021 07/23/2020 10/22/2020 02/25/2021 07129/2020 12102/2020 12/07/2020 11125/2020 01/28/2021 10/08/2020 081'27/2020 07/16/2020 02/22/2021 09'16/2020 06/08/2020 07/09/2020 03/04/2021 09/22/2020 12/14/2020 06/25/2020 Last Payment Ticket Number Patient Balance FPN076433 FPN076892 $27.75 FPN077740 FPN076590 FPN076978 FPN076225 FPN076857 FPN076441 $40.25 FPN075700 FPN076040 FPN075761 TRVN004677 FPN077376 $40.00 FPN077007 $50.00 FPN077714 FPN077782 MDN003969 $27.75 FPN077614 FPN075684 $29.00 FPN076957 $10.00 FPN077640 FPN075855 STDN003115 $11.00 FPN076199 $11.00 FPN076878 $20.00 FPN077599 $23.00 FPN076134A FPN076239 $52.00 FPN077111 $100.00 FPN077136 FPN077198 $10.00 FPN077081 $20.00 FPN077431 FPN077456 $27.00 FPN076792 $40.00 FPN076446 FPN076472 STDN003000 $10.00 FPN076147 STDN003128 $34.50 STDN003294 $67.00 STDN003090 FPN076015 $20.00 FPN074535 $20.00 FPN076096 FPN075880 FPN076195 FPN077406 $11.00 FPN077639 FPN075793 FPN077574 FPN077581 MDN003999 FPN077260 FPN076562 FPN077485 MDN003997 $40.00 FPN076247 FPN076622 $75.00 FPN075307 FPN077525 $54.00 FPN076018 $65.51 $190.00 $12.75 $52.00 $40.00 $121.00 $5.17 $82.04 $247.00 $17.00 $18.75 $81.00 $30.00 $49.75 $55.00 $30.00 $1,008.00 $12.75 $944.25 $71.00 $87.00 $3.49 $324.00 $30.02 $12.00 $116.50 $4.50 $29.00 $9.75 $26.25 $52.00 $43.75 $71.75 $48.75 $27.50 $7.00 $237.25 $17.00 $51.56 $440.00 $17.50 $38.00 $164.04 $43.00 $175.75 $5.18 $41.00 $30.00 $23.00 $17.00 $38.50 $38.50 $118.00 $112.00 $5.18 $89.00 $196.71 $3.00 $256.00 $63.25 $42.50 $25.00 Last Payment 03/08/2021 06/05/2020 02/09/2021 Last Payment Ticket Number $22.00 FPN077668 $50.00 FPN075874 $20.00 FPN077517 Patient Balance $45.00 $237.25 $242.00 $15,419.60 Hello