In: Accounting
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 |
||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||
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) |