Complete the following 2 exercises

Question

1. Prepare a bank deposit detail for a $2230.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.

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 $2230.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.___Yes__ _

Answer 1

currency 296.00
coin
check 117.00
credit cards 350.00
less credit cards 350.00

Answer 2

did u ever find the answer to question #2