Reference no: EM13581900

The following information was gathered from the books of ABC Company in order to prepare its bank reconciliation: Prepare a bank reconciliation as of June 30.

Balance per bank statement, June 30^th........................$11,800

Balance per ledger, June 30...........................................$13,160

Interest earned................................................................$40

Outstanding checks.........................................................$200

Returned check................................................................$300

Deposit in transit.............................................................$1200

1. ABC Company bookkeeper correctly recorded one of its deposits for $800, although the bank recorded only $700.
2. ABC Company has a petty cash fund of $500. Any withdrawals were replenished by June 30.
3. ABC Company had two certificates of deposit on June 30. The first was a $20,000, six month CD with a maturity date of October 15^th and the other was a $30,000, 90 day CD with a maturity date of August 15^th.
4. ABC Company had a $25 if stamps on hand.
5. Included in the cash ledger balance was $1,100 of cash deposits received from customers. ABC product had not yet delivered the goods to the customer as of June 30.
6. ABC Company had a $5,000 set aside in bond sinking fund. This amount was not included in the cash ledger balance.
7. On June 14^th, ABC Company paid a refundable cash deposit of $800 to the Rent-A-Truck Corp. The rental period was for 45 days. The Cash ledger properly reflected the payment on June 14^th.
8. ABC Company received a check from one of their customers dated 07/06/14 in the amount of $550. This amount was not included in the ledger balance.