Complete the excel assignment based on medical payment.
Follow the directions "Patient data for day sheets" to complete the "DaySheets" document that is also attached.
Day 1 - JULY 1
Patient account 25145 - Charge was $85, insurance adjusted $15 and patient paid her $20.00 co-pay.
The charge, adjustment, and patient payment have been entered for you on this account. You are now to enter in the amount the insurance paid (-40.00).
Enter the charges/adjustments/patient payments/insurance payments below for the accounts to complete the day sheet for the rest of the account numbers:
Acct 24315 Charge $189.00
dj 63.00
Pt Pay 35.00
Ins Pay 82.00
Acct 35870 Charge $245.00
Adj 95.35
Pt Pay 45.00
Ins Pay 79.43
Acct 15879 Charge $98.00
Adj 28.67
Pt Pay 25.00
Ins Pay 40.25
Acct 25879 Charge $1,789.00
Adj 213.78
Pt Pay 0.00
Ins Pay 1,089.00
Acct 98653 Charge $798.00
Adj 245.98
Pt Pay 100.00
Ins Pay 0.00 (No Prior authorization was done)
They would have paid $435 if one had been done.
*****You will need to enter the expense for Electricity of $276.25.
Add the patient payments and insurance payments to the balance forward for day 1. Subtract the expense to get the Total Balance for July 1st. Enter the total balance on day two in the Balance Forward area.
Day 2 - JULY 2
Enter the charges/adjustments/patient payments/insurance payments below for the accounts to complete the day sheet.
Acct 58963 Charge $45.00
Adj 3.45
Pt Pay 12.88
Ins Pay 28.67
Acct 14789 Charge $98.00
Adj 25.87
Pt Pay 20.00
Ins pay 49.47
Acct 36987 Charge $4899.00
Adj 789.00
Pt Pay 150.00
Ins Pay 3725.23
Acct 45678 Charge $243.00
Adj 78.98
Pt Pay 45.00
Ins Pay 119.02
Acct 32165 Charge $545.00
Adj 99.45
Pt Pay 100.00
Ins Pay 300.23
need to enter the expense for Rent of $4,500.00
Add the patient payments and insurance payments to the balance forward for day 2. Subtract the expense to get the Total Balance for July 2nd. Enter the total balance on day three in the Balance Forward area.
Day 3 - JULY 3
Enter the charges/adjustments/patient payments/insurance payments below for the accounts to complete the day sheet.
Acct 25879 - First put the balance in the Patient Balance Forward column from day 1. Then enter Patient Payment of $386.22
Acct 36987 - First put the balance in the Patient Balance Column from Day 2. Then enter Patient Payment of $234.77
Acct 35870 - First put the balance in the Patient Balance column from Day 1. The Patient had to come back and have more lab work done.
The claim has not ran through the Insurance yet so there is no Adjustments or Insurance Payments yet so you enter $0.00 in those columns.
Enter the following:
Charge $87.00
Charge 43.00
Charge 28.00
NOTE: You will need to add up the charges and enter the total in the Charge Column.
Adj 0.00
Pt Pay 0.00
Ins Pay 0.00
Acct 22269 Charge $163.00
Adj 55.00
Pt Pay 25.00
Ins Pay 72.00
Enter the expense for office supplies of $247.50
Acct 98653 - The Insurance company re-processed the claim after accepting a pre-authorization that was able to be back dated. First enter the Patient Balance from day 1. Then enter in the insurance payment of $435.00
Add the patient payments and insurance payments to the balance forward for day 3. Subtract the expense to get the Total Balance for July 3rd.
Attachment:- Daysheet.rar