Do the Math 5 3 Reconciling a Checking Account Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university Illustrated below are his monthly statement and check register for the account Account Name Andrew Parker Period of Activity 11 2 18 12 01 18 Account 123 45678 Summary of Your Activity This Month Date Activity Amount Balance 11 02 $ 405 56 11 04 Debit Card POS Transaction $ 17 53 388 03 11 09 Check 237 33 03 355 00 11 12 Direct Deposit 860 00 1,215 00 11 13 Debit Card POS Transaction 679 47 535 53 11 13 EFT 82 12 453 41 11 15 Check 238 22 70 430 71 11 23 Debit Card POS Transaction 68 87 361 84 11 27 Debit Card POS Transaction 43 39 318 45 11 28 Deposit 200 00 518 45 11 30 Check 239 110 00 408 45 11 30 Service Charge 4 50 403 95 11 30 ATM Withdrawal 100 00 303 95 12 01 Check 240 43 00 260 95 Date Check Payee Payor For Amount Balance 11 01 $ 405 56 11 03 Debit Card CVS Cold Meds $ 17 53 388 03 11 05 237 Univ Book Store Of Mice and Men 33 03 355 00 11 12 Deposit PNC Bank Payday Yeah 860 00 1,215 00 11 12 238 ABC Property Mgmt Rent 679 47 535 53 11 13 Debit Card Kroger's Groceries 82 12 453 41 11 13 Electronic Payment Maysville Water Water Bill 22 70 430 71 11 23 Debit Card Kroger's Groceries 67 88 362 83 11 23 Debit Card Applebee's Dinner with Karen 43 39 319 44 11 27 Deposit Mom For Utilities 200 00 519 44 11 27 239 Duke Power Electric Heat Bill 110 00 409 44 11 27 240 Conoco Gas 43 00 366 44 11 30 Debit Card ATM Withdrawal Carry Around Money 100 00 266 44 12 01 241 Comcast Cable Bill 50 77 216 67 Reconcile the checking account and answer the following questions Leave no cells blank Enter zero wherever required What is the total of the outstanding checks Round your answer to the nearest cent $ What is the total of the outstanding deposits Round your answer to the nearest cent $ Why is there a difference between the uncorrected balance in the check register and the balance on the statement What is the updated and correct balance in the check register Round your answer to the nearest cent $

The Answer is in the image, click to view ...

Question: Do the Math 5-3 Reconciling a Checking Account Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his

Do the Math 5-3 Reconciling a Checking Account

Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his monthly statement and check register for the account.

Account Name	Andrew Parker	Period of Activity	11/2/18- 12/01/18
Account #	123-45678
Summary of Your Activity This Month
Date	Activity	Amount	Balance
11/02			$ 405.56
11/04	Debit Card POS Transaction	$ 17.53	388.03
11/09	Check #237	33.03	355.00
11/12	Direct Deposit	860.00	1,215.00
11/13	Debit Card POS Transaction	679.47	535.53
11/13	EFT	82.12	453.41
11/15	Check #238	22.70	430.71
11/23	Debit Card POS Transaction	68.87	361.84
11/27	Debit Card POS Transaction	43.39	318.45
11/28	Deposit	200.00	518.45
11/30	Check #239	110.00	408.45
11/30	Service Charge	4.50	403.95
11/30	ATM Withdrawal	100.00	303.95
12/01	Check #240	43.00	260.95

Date	Check #	Payee/Payor	For	Amount	Balance
11/01					$ 405.56
11/03	Debit Card	CVS	Cold Meds	$ 17.53	388.03
11/05	237	Univ. Book Store	Of Mice and Men	33.03	355.00
11/12	Deposit	PNC Bank	Payday-Yeah!	860.00	1,215.00
11/12	238	ABC Property Mgmt.	Rent	679.47	535.53
11/13	Debit Card	Kroger's	Groceries	82.12	453.41
11/13	Electronic Payment	Maysville Water	Water Bill	22.70	430.71
11/23	Debit Card	Kroger's	Groceries	67.88	362.83
11/23	Debit Card	Applebee's	Dinner with Karen	43.39	319.44
11/27	Deposit	Mom	For Utilities	200.00	519.44
11/27	239	Duke Power	Electric/Heat Bill	110.00	409.44
11/27	240	Conoco	Gas	43.00	366.44
11/30	Debit Card	ATM Withdrawal	Carry Around Money	100.00	266.44
12/01	241	Comcast	Cable Bill	50.77	216.67

Reconcile the checking account and answer the following questions. Leave no cells blank. Enter zero wherever required.

What is the total of the outstanding checks? Round your answer to the nearest cent.

What is the total of the outstanding deposits? Round your answer to the nearest cent.

Why is there a difference between the uncorrected balance in the check register and the balance on the statement?

What is the updated and correct balance in the check register? Round your answer to the nearest cent.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

A ski jumper has the takeoff conditions shown. Determine the inclined distance d from the takeoff point A to the location where the skier first touches down in the landing zone, and the total time t ...

eBook Do the Math 5 - 3 Reconciling a Checking Account Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his...

11/23 11/27 3. Reconciling a Checking Account. Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his monthly...

Reconciling a Checking Account. Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his monthly statement and check...

Reconciling a Checking Account Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Hlustrated below are his monthly statement and cheo...

Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his monthly statement and check register for the account....

Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his monthly statement and check register for the account Account...

Part I: Account Reconciliation Andrew Parker, of San Marcos, Texas, has a checking account at the credit union affiliated with his university. Illustrated below are his check register and bank...

2. Reconciling a Checking Account. Andrew Parker has a checking account at the credit union affi liated with his university. Illustrated below are his check register and monthly statement for the...

How does a septic system work? Discuss.

(a) Rank ethanol, methylamine, and acetic acid in decreasing order of acidity. (b) Rank ethanol, methylamine (pKb 3.36), and ethoxide ion (CH3CH2O-) in decreasing order of basicity. In each case,...

Sales cutoff procedures are critical to ensuring revenue is reported in the appropriate accounting period Question 4 Answer True False

A 5.010^4 kg space probe is travelling at a speed of 11000 m/s through deep space l. Retrorockets are fired along the line of motion to reduce the probe's speed. The rotrorockets generate a force of...

18. Which of the following compounds will exhibit geometrical isomerism? (a) 1-Phenyl-2-btene (c) 2-Phenyl-I-butene (b) 3-Phenyl-1-butene (d) 1, 1-Diphenyl- 1-propene

In the figure shown S,O-S,0=S,0-S,0 =: 4 $5. Intensity at O due to any one of the slits is Io. What is the intensity due to all the three coherent sources S1, S2 and S3? S3 Io 9 Io (1) 3 I, (2) (3) 5...

A nucleus with mass number 220 initially at rest emits an a-particle. If the Q value of the reaction is 5.5 MeV, calculate the kinetic energy of the a-particle (A) 4.4 MeV (B) 5.4 MeV (C) 5.6 Me (D)...

3 pumps , working 8 hours a day, can empty a tank in 2days. how many hours a days must 4pumps work to empty the tank in 1day

please try to give correct answer 1 3 0 3 .

OUTCOME 1 Explain the political, economic, sociocultural, and technological factors in different countries that HR managers need to consider.

OUTCOME 4 Differentiate the forms of bargaining power that a union and an employer may utilize to enforce their bargaining demands.

3. Graduate students in many Canadian universities are members of unions, such as CUPE Local 3903. These students help conduct tutorials, grade student examinations, etc. Do you think university...