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 30th........................$11,800
Balance per ledger, June 30...........................................$13,160
Interest earned................................................................$40
Outstanding checks.........................................................$200
Returned check................................................................$300
Deposit in transit.............................................................$1200
- ABC Company bookkeeper correctly recorded one of its deposits for $800, although the bank recorded only $700.
- ABC Company has a petty cash fund of $500. Any withdrawals were replenished by June 30.
- 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 15th and the other was a $30,000, 90 day CD with a maturity date of August 15th.
- ABC Company had a $25 if stamps on hand.
- 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.
- ABC Company had a $5,000 set aside in bond sinking fund. This amount was not included in the cash ledger balance.
- On June 14th, 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 14th.
- 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.