I need help completing my excel assignment based on medical payment. information is attatched.

MO111 Patient data for day sheets July 1st, 2nd, and 3rd. The second part of the Final Project is to use and follow the directions "Patient data for day sheets" document attached 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 Adj 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 1 st. 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 Adj Pt Pay Ins pay 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 $98.00 25.87 20.00 49.47 *****You will 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 2 nd. 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 Adj Pt Pay Ins Pay $163.00 55.00 25.00 72.00 *****You will need to 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 3 rd. HERZING U-CLINIC - DAY SHEET for July 1 Clinic Balance Forward Date 7/1/2015 7/1/2015 7/1/2015 7/1/2015 7/1/2015 7/1/2015 Totals Patient Payments Total Insurance Payments Patient Patient (+) Balance Account # Charge Forward 25145 24315 35870 15879 25879 98653 $85.00 (-) Adjustment -$15.00 (-) Patient Payment (-) Insurance Payment -$20.00 -$20.00 $0.00 Office Expense Electricity Total Balance for July 1 Note: Enter all payments with a (-) in front of the number. When you add patient payments and insurance payments to the tot EXAMPLE: -$25.00 payment would be added to the total as $25.00 + $100.00 without the (-) 1 $85,425.00 Patient Balance $50.00 $0.00 $0.00 $0.00 $0.00 $0.00 ance payments to the total you are not putting the (-) in front of the number. HERZING U-CLINIC - DAY SHEET for July 2 Clinic Balance Forward Date 7/2/2015 7/2/2015 7/2/2015 7/2/2015 7/2/2015 Totals Patient Payments Patient Account # (+) Charge Patient Balance Forward (-) Adjustment (-) Patient Payment 58963 14789 36987 45678 32165 $0.00 Total Insurance Payments Office Expense Rent Total Balance for July 2 Note: Enter all payments with a (-) in front of the number. When you add patient payments and insurance payments to the EXAMPLE: -$25.00 payment would be added to the total as $25.00 + $100.00 without the (-) EET for July 2 (-) Insurance Payment Patient Balance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ments and insurance payments to the total you are not putting the (-) in front of the number. ut the (-) HERZING U-CLINIC - DAY SHEET for July 3 Clinic Balance Forward Date 7/3/2016 7/3/2016 7/3/2016 7/3/2016 7/3/2016 Totals Patient Payments Patient Patient (+) Balance (-) Patient Account # Charge Forward (-) Adjustment Payment 25879 36987 35870 22269 98653 $0.00 Total Insurance Payments Office Expense Rent Total Balance for July 3 Note: Enter all payments with a (-) in front of the number. When you add patient payments and insurance payments to the EXAMPLE: -$25.00 payment would be added to the total as $25.00 + $100.00 without the (-) or July 3 (-) Insurance PatientB Payment alance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ments and insurance payments to the total you are not putting the (-) in front of the number. ut the (-)