Reference no: EM13709157

Question 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.
BANK DEPOSIT DETAIL
PAYMENT

D. An insurance payment for Alejandro Sanchez arrived in the amount of $1374.32. The payment was from Aetna and was check # 309.

 

Question 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?