Complete the following 2 exercises

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__ _

currency 296.00

coin
check 117.00
credit cards 350.00
less credit cards 350.00

did u ever find the answer to question #2

1. To prepare a bank deposit detail for a $2230.00 deposit, we need to gather the necessary information from questions A-D. Let's record the answers on the provided deposit slip.

A. Cash receipts total $646.68; $2.68 was in coins.
- We will write $646.68 in the "Cash" section of the deposit slip.
- We will write $2.68 in the "Coins" section of the deposit slip.

B. Check payments were #2387 for $67.00 from Sue Patrick and #460 for $50.00 from Ronald Rodriguez.
- We will write the check details in the "Checks" section of the deposit slip.
- Check #2387, Sue Patrick, Amount: $67.00
- Check #460, Ronald Rodriguez, Amount: $50.00

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.
- We will write the credit card payments in the "Credit Card" section of the deposit slip.
- Pam Adkins' payment: $25.00
- Brad Wilson's payment: $67.00

D. An insurance payment for Alejandro Sanchez arrived in the amount of $1374.32. The payment was from Aetna and was check #309.
- We will write the insurance payment details in the "Checks" section of the deposit slip.
- Check #309, Aetna, Alejandro Sanchez, Amount: $1374.32

Once we have recorded all the information on the deposit slip, we can complete the bank deposit detail for the $2230.00 deposit.

2. To reconcile the bank statement, we need to use the facts below and record the answers on the provided worksheet.

A. The checkbook balance is $4619.89.
- We will write this amount in the appropriate section of the worksheet.

B. The statement balance is $6792.79 (this amount includes the deposit of $2230.00 – do not add the amount in again).
- We will write this amount in the appropriate section of the worksheet.

C. Three checks are outstanding: Check #5648 for $356.00, check #5649 for $46.90, and check #5650 for $1770.00.
- We will list the outstanding checks and their amounts in the appropriate section of the worksheet.

D. Does the checkbook reconcile with the statement?
- Answer this question based on whether the checkbook balance and the statement balance match.

Once we have recorded all the necessary information on the worksheet, we can determine whether the checkbook reconciles with the statement.