Medical office HW
amaay2
pt_day_sheet_ledger_template.xlsxDay Sheet Ledger
| Patient Daysheet/Ledger | ||||||||
| Blackburn Primary Care Associates | ||||||||
| 1990 Turquoise Drive | ||||||||
| Blackburn, WI 12345 | ||||||||
| (123) 456-7890 / (123) 456-7898 | ||||||||
| Patient Name: | ||||||||
| Patient Address: | ||||||||
| City | State | Zip Code | ||||||
| Home Phone | Cell Phone: | |||||||
| MR# | ||||||||
| Entry | Date | Reference | Service | Charge | Payment | Adjustment | Previous Balance | Current Balance |
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 |
Ledgers and Computing Patient Balances Work through the following information, and record it on the ledger card. Meagan Joy Reynolds 5534 Joe Pool Lake Road #233 Cedar Hill, Texas 75884 972-334-0423 (home) 972-331-0934 (cell) [email protected] MR# REYM3341 Entry # Transaction 1. Meagan comes to the Blackburn Primary Care Clinic on April 12 as a new patient. Her initial charge is $375 because she had a series of x-ray examinations, which were used to diagnose a blockage in her small intestine. Dr. Lupez recommends that she have surgery to correct the blockage as soon as possible. Meagan pays her bill in full with check #7110, although she has insurance coverage through her own policy with Prudential and her husband’s policy through Southwest United Healthcare. 2. Meagan checks into Mercy Hospital and has surgery on April 21. Dr. Lupez charges $7500 for the surgery and aftercare, which will take approximately 6 weeks. This charge will be filed with Meagan’s insurances. 3. Meagan returns to the clinic on April 30 for a follow-up office visit. The charge is $150, which she pays in full with check #7261. Dr. Lupez says that she is doing very well since her surgery and asks her to return in mid May for another checkup. 4. On May 2 the clinic receives an insurance payment from Prudential in the amount of $6200. This money is applied to Meagan’s account. The check number is 617761. 5. On May 3 the clinic receives check #7313 in the mail from Meagan for $300, which is applied to her account. 6. Meagan returns to the clinic on May 14 for an office visit. The charge is $75, and she pays $50 with check #7512. 7. Southwest United sends a check to the clinic for $800 on May 27, which is applied to her account. The check number is 8710. 8. Meagan sends a check for $125 to be put toward her account. The check, #7915, is posted on June 2. 9. Meagan returns to the clinic for an office visit and laboratory work on June 17. Her charges total $352, and she pays $150 with check #8116. 10. On June 20 the clinic receives Meagan’s check toward her account for $100. Her check number is 8411. 11. Meagan visits the clinic for treatment of a migraine headache on June 26. Her charge is $85, and she pays $50 with check #8626. She schedules a follow-up visit with Dr. Lupez for June 30. 12. When Meagan returns for her follow-up visit on June 30, her office visit is $85, but she is unable to make a payment. 13. On July 5 the clinic receives a payment from Prudential on behalf of Meagan for $276. The Prudential check number is 721146. 14. On July 22 check number #7915 for Megan totaling $125.00 was returned by the bank for non sufficient funds . 15. On October 22 , in accordance with the clinic policy of reporting accounts to a collection agency after 3 months of nonpayment, the office manager reluctantly reports Megan’s account to Smith Collections. The full balance is written off. 16. On December 12 , a payment of $141 check number 5469 is received from Smith Collections for Megan's account. Since the account was previously written off, the initial write off balance must be reversed before the payment is applied. 17. A credit adjustment of $30.00 must also be posted to Megan's account for Smith Collections fee.
