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 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$ $ $420\mathrm{.}26$

$11/04$ Debit Card POS Transaction $ $19\mathrm{.}41400\mathrm{.}85$

$11/09$ Check #$23732\mathrm{.}80368\mathrm{.}05$

$11/12$ Direct Deposit $952\mathrm{.}641,320\mathrm{.}69$

$11/13$ Debit Card POS Transaction $666\mathrm{.}92653\mathrm{.}77$

$11/13$ EFT $83\mathrm{.}47570\mathrm{.}30$

$11/15$ Check #$23823\mathrm{.}80546\mathrm{.}50$

$11/23$ Debit Card POS Transaction $68\mathrm{.}87477\mathrm{.}63$

$11/27$ Debit Card POS Transaction $44\mathrm{.}96432\mathrm{.}67$

$11/28$ Deposit $200\mathrm{.}00632\mathrm{.}67$

$11/30$ Check #$239100\mathrm{.}00532\mathrm{.}67$

$11/30$ Service Charge $4\mathrm{.}50528\mathrm{.}17$

$11/30$ ATM Withdrawal $100\mathrm{.}00428\mathrm{.}17$

$12/01$ Check #$24050\mathrm{.}00378\mathrm{.}17$

Date Check # Payee$/$Payor For Amount Balance

$11/01$ $ $420\mathrm{.}26$

$11/03$ Debit Card CVS Cold Meds $ $19\mathrm{.}41400\mathrm{.}85$

$11/05237$ Univ. Book Store Of Mice and Men $32\mathrm{.}80368\mathrm{.}05$

$11/12$ Deposit PNC Bank Payday$-$Yeah! $952\mathrm{.}641,320\mathrm{.}69$

$11/12238$ ABC Property Mgmt$.$ Rent $666\mathrm{.}92653\mathrm{.}77$

$11/13$ Debit Card Kroger's Groceries $83\mathrm{.}47570\mathrm{.}30$

$11/13$ Electronic Payment Maysville Water Water Bill $23\mathrm{.}80546\mathrm{.}50$

$11/23$ Debit Card Kroger's Groceries $67\mathrm{.}88478\mathrm{.}62$

$11/23$ Debit Card Applebee's Dinner with Karen $44\mathrm{.}96433\mathrm{.}66$

$11/27$ Deposit Mom For Utilities $200\mathrm{.}00633\mathrm{.}66$

$11/27239$ Duke Power Electric$/$Heat Bill $100\mathrm{.}00533\mathrm{.}66$

$11/27240$ Conoco Gas $50\mathrm{.}00483\mathrm{.}66$

$11/30$ Debit Card ATM Withdrawal Carry Around Money $100\mathrm{.}00383\mathrm{.}66$

$12/01241$ Comcast Cable Bill $55\mathrm{.}93328\mathrm{.}73$

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?

The input in the box below will not be graded, but may be reviewed and considered by your instructor.

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

$