Question

In: Accounting

Roper Electronics received its bank statement for the month of August with an ending balance of...

Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for the collection service. The bank statement reveals a bank service charge of $20. A customer check for $68 was returned with the bank statement marked “NSF.” The ending balance of the Roper cash account is $12,938. ?

Prepare a bank/account reconciliation and any necessary journal entries for the reconciliation.

Roper Electronics

Bank Reconciliation

August 30

Date

General Journal

Debit

Credit

Solutions

Expert Solution

Solution:

Roper Electronics
Bank Reconciliation Statement
Aug-30
Balance as Per Bank Statement $11,740
Add: Deposits in transit $6,900
Less: Outstanding Checks (155+420) $575
Adjusted Bank Balance $18,065
Balance as per books $12,938
Add:
Collection of Note and Interest ($5000+$250) $5,250
$5,250
Subtotal $18,188
Less:
Collection charges $35
Bank Service charges $20
NSF Check $68
$123
Adjusted Balance per books $18,065
Journal Entries
S. No. Particulars Debit Credit
1 Cash Dr $5,215
Collection Fee Dr $35
       To Note Receivable $5,000
       To Interest revenue $250
(To record collection of Note and charges)
2 Miscellaneous expenses Dr $20
        To Cash $20
(To record Bank service charges)
3 Accounts Receivable Dr $68
        To Cash $68
(To record NSF Check)

Related Solutions

Roper Electronics received its bank statement for the month of August with an ending balance of...
Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with a balance of $11,740.00 as of August 31. Northern Regional Bank also collected a $5,000.00 notes receivable from Roper Electronic's customer on August 1. The customer owed interest on the receivable for the period March 1 to August 1 at 12% annual interest. Northern Regional Bank charged a $35.00 fee for the collection service.The bank statement reveals a bank service charge of $20.00. A...
prepare a classified balance sheet and a statement of cash flows for the month ending August...
prepare a classified balance sheet and a statement of cash flows for the month ending August On the 1st of August, “Brothers haircut” had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On August 4, Incurred $380 of advertising costs due in 20 days On August 5, Purchased salon equipment for $120 On August 7, Paid for supplies (shampoos, creams, and gels) $350 On August 8, received $280 for selling gels On August...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance of $4,188.30 as at 31 January 2020. The cash balance on the company’s books at 1 January 2020 was $176.00 (debit). The progressive totals of the Cash Receipts Journal and the Cash Payments Journal before considering items 1 to 5 below were $21,475.40 and $17,622.10 respectively. The following reconciling items were identified: (1) Un-presented cheques amounted to $501.25. (2) Debits included in the bank...
Bank statement for the month ending 30 April 2020. Bank statement Date Details Debit Credit Balance...
Bank statement for the month ending 30 April 2020. Bank statement Date Details Debit Credit Balance 01 Apr Balance 19 200,00 Cr 02 Apr Cheque No. 674 2 250,00 16 950,00 Cr Deposit 4 800,00 21 750,00Cr 03 Apr Deposit 1 500,00 23 250,00 Cr 05 Apr Cheque No. 675 1 800,00 21 450,00 Cr Bank charges      195,00 21 255,00 Cr 08 Apr Deposit 9 000,00 30 255,00 Cr Cheque No. 678      900,00 29 355,00 Cr 14 Apr...
prepare a classified balance sheet for the month ending August On the 1st of August, “Brothers...
prepare a classified balance sheet for the month ending August On the 1st of August, “Brothers haircut” had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On August 4, Incurred $380 of advertising costs due in 20 days On August 5, Purchased salon equipment for $120 On August 7, Paid for supplies (shampoos, creams, and gels) $350 On August 8, received $280 for selling gels On August 12, paid $180 water bill On...
10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The...
10. Mooner Sooner has received their bank statement for the month ending April 30, 2020. The balance on the bank statement is $8,000. At the end of April, the balance per the books is $5,020. There are checks outstanding of $5,800 and a deposit in transit of $4,000. On the bank statement there is a EFT received of $1,500. There is an NSF check from Steve Mayberry for $300 and a bank service fee of $20. What is the reconciled...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a balance of $10,102.87. The company’s general ledger showed a balance of $8,656.11. The following items were discovered when comparing the bank statement to the books of the company: The bank charged check processing fees of $25.00. There was a $1,825.52 automatic withdrawal to pay the mortgage. Of the $1,825.52, $1,572.86 was for interest which had been accrued. The bank charged Friends, Inc. account $250.00...
  ​Mary's last bank statement showed an ending balance of ​$102.87. This​ month, she deposited $385.41 in...
  ​Mary's last bank statement showed an ending balance of ​$102.87. This​ month, she deposited $385.41 in her account and withdrew a total of ​$143.37. ​Furthermore, Mary wrote a total of five​ checks, two of which have cleared. The two checks that have cleared total ​$90.38. The three remaining checks total ​$69.54. Mary pays no fees at her bank. What is the balance shown this month on​ Mary's bank​ statement? What is the adjusted bank​ balance? The balance shown this month...
When Pharoah Holdings Ltd. received its bank statement for the month of October, it showed that...
When Pharoah Holdings Ltd. received its bank statement for the month of October, it showed that the company had a cash balance of $14,849 as at October 31. Pharoah’s general ledger showed a cash balance of $17,390 at that date. A comparison of the bank statement and the accounting records revealed the following information: 1. Bank service and credit card charges for the month were $7. 2. A cheque, in the amount of $520, from one of Pharoah’s customers that...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT