Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1

Question

Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $12,830. During May, the total cash deposited was $64,440 and checks written totaled $59,830. The bank statement indicated a balance of $21,850 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $9,730 b. A deposit of $7,930, representing receipts of May 31, had been made too late to appear on the bank statement. C. The bank had collected for Brentwood Bike Co. $4,190 on a note left for collection. The face of the note was $3,870. d. A check for $580 returned with the statement had been incorrectly charged by the bank as $850 e. A check for $520 returned with the statement had been recorded by Brentwood Bike Co. as $250. The check was for the payment of an obligation to Adkins Co. on account. f. Bank service charges for May amounted to $70. g. A check for $970 from Jennings Co. was returned by the bank because of insufficient funds Instructions: 1. Prepare a bank reconciliation as of May 31 Brentwood Bike Co Bank Reconciliation May 31 21,85 Cash balance according to bank statement Add deposit of May 31, not recorded by bank Add bank error in charging check as $850 instead of $580 7,930 8,200 30,05 9,730 20,32 17,44 4,190 21,63 270 Deduct outstanding checks Adjusted balance Cash balance according to company's records Add note and interest collected by bank Deduct check returned because of insufficient funds Deduct bank service charges Deduct error in recording check Adjusted balance 970 70 270 1,310 20,32

Explanation / Answer

Bank Reconcilation ;-

Working Note :- Cash Balance according to company's records

2) Journal Entries :-

3) Amount of Cash is reported in Balance Sheet = $20320

Particulars Amount($) Cash Balance According to Bank Statement 21850 Add ; Deposit of May 31, not recorded by bank 7930 Add : Bank error in charging check as 850 instead of 580 270 Ded. : Outstanding Checks (9730) Adjusted Balance 20320 Cash Balance According to Company's Records (Working Note) 17440 Add : Proceeds of note collected by bank, including interest 4190 Ded : Error in recording check (520-250) (270) Ded : Bank Service charges (70) Ded : NSF Check (970) Adjusted Balance 20320

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.