The cash data of Eddy Automotive for October 2018 follow:
CashDateOctober 13131ItemBalanceJrnl. Ref.CR6CP11Debit9,330Credit10,122Account No. 101Balance7,95017,2807,158
Cash Receipts (CR) Cash Payments (CP)
DateOctober 281016222930TotalCash Debit$2,8285971,6528373609042,152$9,330Check No.3113311431153116311731183119312031213122TotalCash Credit$1,5421,7291,830477821694781,0232342,288$10,122
Eddy Automotive received the following bank statement on October 31, 2018:
Bank Statement for October 2018
Beginning balanceDeposits and other additions:October 1October 4October 9October 12October 17October 22October 23Checks and other deductions:October 7October 13October 14October 15October 18October 21October 26October 30October 30Ending balance$6002,8285971,6528373601,500$1,5421,3804191,7294744178216910EFTBCUSEFTSC$7,9508,374(6,519)$9,805
Explanation: BC—bank collection of note receivable from customer, EFT—electronic funds transfer, US—unauthorized signature, SC—service charge
Additional data for the bank reconciliation include the following:
a. The EFT deposit was a receipt of monthly rent. The EFT debit was a monthly insurance payment.
b. The unauthorized signature check was received from a customer and returned by the bank unpaid.
c. The correct amount of check number 3115, a payment on account, is $1,380. (Eddy Automotive’s accountant mistakenly recorded the check as$1,830.)
d. The bank collected a note receivable for Eddy Automotive.
Requirements
-
Prepare Eddy Automotive’s bank reconciliation at October 31, 2018.
-
Prepare the journal entries required at October 31, 2018.
-
Describe how a bank account and the bank reconciliation help the general manager control Eddy Automotive’s cash.