Question

In: Accounting

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

Bank Reconciliation and Entries

The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,350. During May, the total cash deposited was $73,130 and checks written totaled $67,900. The bank statement indicated a balance of $24,790 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

  1. Checks outstanding totaled $11,040.
  2. A deposit of $8,990, representing receipts of May 31, had been made too late to appear on the bank statement.
  3. The bank had collected for Brentwood Bike Co. $4,750 on a note left for collection. The face of the note was $4,390.
  4. A check for $580 returned with the statement had been incorrectly charged by the bank as $850.
  5. A check for $970 returned with the statement had been recorded by Brentwood Bike Co. as $790. The check was for the payment of an obligation to Adkins Co. on account.
  6. Bank service charges for May amounted to $40.
  7. A check for $1,100 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
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
$
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

2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. For a compound transaction, if an amount box does not require an entry, leave it blank.

a. May 31 Cash
Notes Receivable   
Interest Revenue
b. May 31 Accounts Payable-Adkins Co.
Accounts Receivable-Jennings Co.
Miscellaneous Expense
Cash

3. If a balance sheet is prepared for Brentwood Bike Co. on May 31, what amount should be reported as cash?
$

Solutions

Expert Solution

1.

Brentwood Bike Co.
Bank Reconciliation
At May 31
Cash balance according to bank statement 24,790
Add deposit of May 31, not recorded by bank 8,990
Add bank error in charging check as $850 instead of $580 270 9,260
34,050
Deduct Outstanding checks -11040
Adjusted balance $23,010
Cash balance according to company's record 19,580
Add note and interest collected by bank 4,750
24,330
Deduct check returned because of insufficient funds 1,100
Deduct bank service charges 40
Deduct error in recording check 180 -1,320
Adjusted balance $23,010

2.

Date General Journal Debit Credit
a. May 31 Cash $4,750
Notes Receivable    $4,390
Interest Revenue $360
( To record interest and note collected by bank)
b. May 31 Accounts Payable-Adkins Co. $180
Accounts Receivable-Jennings Co. $1,100
Miscellaneous Expense $40
Cash $1,320
( To record error of recording check, NSF check and bank service charges)

3. If a balance sheet is prepared for Brentwood Bike Co. on May 31, the amount should be reported as cash is $23,010

Kindly comment if you need further assistance.

Thanks‼!


Related Solutions

Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,720. During May, the total cash deposited was $69,160 and checks written totaled $64,220. The bank statement indicated a balance of $23,450 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,440. A deposit of $8,510, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,660. During May, the total cash deposited was $68,400 and checks written totaled $63,510. The bank statement indicated a balance of $23,190 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,330. A deposit of $8,410, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $15,210. During May, the total cash deposited was $76,260 and checks written totaled $70,810. The bank statementindicated a balance of $25,850 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,520. A deposit of $9,380, representing receipts of May 31, had been made too late to...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,600. During May, the total cash deposited was $68,640 and checks written totaled $63,730. The bank statement indicated a balance of $23,270 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,360. A deposit of $8,440, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,990. During May, the total cash deposited was $69,790 and checks written totaled $64,800. The bank statement indicated a balance of $23,660 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,540. A deposit of $8,580, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,780. During May, the total cash deposited was $74,910 and checks written totaled $69,550. The bank statement indicated a balance of $25,390 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,310. A deposit of $9,210, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,950. During May, the total cash deposited was $74,930 and checks written totaled $69,570. The bank statement indicated a balance of $25,400 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,310. A deposit of $9,220, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $12,780. During May, the total cash deposited was $64,360 and checks written totaled $59,760. The bank statement indicated a balance of $21,820 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $9,720. A deposit of $7,920, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,890. During May, the total cash deposited was $75,330 and checks written totaled $69,940. The bank statement indicated a balance of $25,540 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,370. A deposit of $9,270, representing receipts of May 31, had been made too late...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,890. During May, the total cash deposited was $75,440 and checks written totaled $70,050. The bank statement indicated a balance of $25,570 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,390. A deposit of $9,280, representing receipts of May 31, had been made too late...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT