Someone please be kind and help me please. I am confuse and do not understand it.

Complete the following 2 exercises 1. Prepare a bank deposit detail for a $2,138.00 deposit. Use the information in questions A-D. Record your answers to the deposit slip provided. NOTE: The bank deposit slip is setup for you to manually type the necessary information to successfully complete the assignment. A. Cash receipts total $646.68; $2.68 was in coins. B. Check payments were # 2387 for $67.00 from Sue Patrick and # 460 for $50.00 from Ronald Rodriguez. C. Credit card payments were $25.00 and $67.00. Pam Adkins paid the $25.00 payment, and Brad Wilson paid the $67.00 payment. D. An insurance payment for Alejandro Sanchez arrived in the amount of $1374.32. The payment was from Aetna and was check # 309. BANK DEPOSIT DETAIL PAYMENT BANK NUMBER BY CHECK OR PMO TOTALS CURRENCY COIN CHECKS CREDIT CARDS TOTAL RECEIPTS LESS CREDIT CARD $ TOTAL DEPOSITS DEPOSIT DATE: BY COIN OR CURRENCY FIRM:____________________ CREDIT CARD 2. Reconcile the bank statement using the facts below. Use the information in questions A-D. Record your answers to the worksheet provided. NOTE: The worksheet is setup for you to manually type the necessary information to successfully complete the assignment. A. The checkbook balance is $4619.89. B. The statement balance is $ 6792.79 (this amount includes the deposit of $2138.00 - do not add the amount in again). C. Three checks are outstanding: Check # 5648 for $356.00, check # 5649 for $46.90; and check # 5650 for $ 1770.00. D. Does the checkbook reconcile with the statement? Ans._____ _ THIS WORKSHEET IS PROVIDED TO HELP YOU BALANCE YOUR ACCOUNT NUMBER ITEMS OUTSTANDING AMOUNT ENTER The NEW BALANCE shown on this statement ___________$ ADD Any deposits listed in your register or transfer Into your account which are not shown on this Statement. CALCULATE THE SUBTOTAL________ TOTAL $ $ $ $ $ +$______ SUBTRACT The total outstanding checks and withdrawals from the chart at lef_______________$ CALCULATE THE ENDING BALANCE This amount should be the same as the current balance shown in your check register _____________________$ Complete the following 2 exercises 1. Write checks to pay the following bills. Be sure to keep track of your balance by also completing the check stubs. The beginning balance in the checkbook is $4562.79. NOTE: The checks are setup for you to manually type the necessary information to successfully complete the assignment. A. Write check #5648 to the American Medical Association for $356.00 for new coding books. 5648-check stub 2-13-16 American Medical Association 356.00 DATE TO B. Three hundred Fifty Six andthe Blackburn Utility Company for $46.90 to pay the water bill. Write Check #5649 to 0/00 FOR New Coding Books BALANCE 5649-check BROUGHT FORWARD DEPOSITS DATE stub BALANCE AMT THIS CK TO BALANCE CARRIED FOR FORWARD BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD C. Write a check for the office mortgage payment to First National Bank, in the amount of $1,770.00. Use check #5650. 5650-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE D. Write check #5651 to pay a pharmacy bill of $98.34. AMT THIS CK BALANCE CARRIED FORWARD 5651-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD E. Determine the balance of the account after the funds in questions A - D have been deducted. Answer: $2,291.55 2. Write checks to pay the following refunds. Use the ending balance from question E to determine the final balance in the checking account. Be sure to keep track of your balance by also completing the check stubs. NOTE: The checks are setup for you to manually type the necessary information to successfully complete the assignment. A. Ms. Patty Bailey should receive a refund in the amount of $34.55 for an overpayment. Use check #5652. 5652-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD B. Write a check for Julie Smithy for $224.12. Her insurance company paid more than expected so she is entitled to a refund. Use check #5653. 5653-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD C. Cindy Chan paid $10 more than she owed when she was seeing Dr. Hughes. Refund her money using check #5654. 5654-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD D. Carter Graves decided to postpone his knee surgery when his wife suddenly became ill. Use check #5655 to refund his $500 deposit. 5655-check stub DATE TO FOR BALANCE BROUGHT FORWARD DEPOSITS BALANCE AMT THIS CK BALANCE CARRIED FORWARD E. Determine the balance of the checking account after the funds in questions A - D have been deducted. Answer: ________________________