Complete the excel assignment based on medical payment

Assignment Help Financial Accounting

Reference no: EM131178792

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

Reference no: EM131178792

Questions Cloud

What marketing strategies would you suggest : Choose two products from the list below. Answer the following questions in the response: 1. What marketing strategies would you suggest to each of the following companies with regard to the products indicated?

Discuss issues involved in developing successful spam filter : Discuss issues involved in developing successful spam filters and the current situation in the war between spammers and people trying to filter spam out.

Explain how the human resource department aligns : Identify at least three (3) factors that need to be considered in the formulation of this department. Include at least four (4) different disciplines that are in the structure of a Human Resources Department and a brief description of each.

Marketing communications planning : Managing and coordinating the complete communications practice calls for thorough marketing communications planning. It is important to identify the added value of an inclusive plan that assesses the tactical roles of an assortment of communicatio..

Complete the excel assignment based on medical payment : 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.

Explain the system that you will create to track each goal : Explain the system that you will create to track each goal. Demonstrate an understanding of your obligation to complete this goal within the given time frame.

Find a longest common substring shared among three input : Using suffx trees, give an algorithm to find a longest common substring shared among three input strings: s1 of length n1, s2 of length n2and s3 of length n3.

How branding has increased in the last few decades : Assess how branding has increased in the last few decades. Think of a brand; analyze how the organization developed its brand equity. Assess the influence of branding on an organization's IMC.

Use of equity financing over debt financing accurate : Christopher argues that the company should increase its use of equity financing because debt costs 25% while equity only costs 20% and thus, equity is cheaper. Is Christopher's analysis of the cost of equity, debt, and decision to increase the use..

User Account

All Pages