the following information is available to assist you in preparing a bank reconci
ID: 2387794 • Letter: T
Question
the following information is available to assist you in preparing a bank reconciliation for Cailico Corners on May 31,2010a. the balance on the may 31,2010, bank statement is $8,432.11
b. not included on the bank statement is a $1,250 deposit made by calico corners lat on may 31
c. a comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at may 31
no.123 $23.40
no.127 145.00
no.128 210.80
no.130 67.32
d. the cash account on the company's books shows a balance of 9,965.34
e. the bank acts as a collection agency for interest earned on some municipal bonds held by calico corners. the may bank statement indicates interest of 465.00 earned during the months
f. interest earned on the checking account and added to calico corners account during may was 54.60. miscellaneous bank service charges amounted to 50.00
g. a customer's NSF check in the amount of 166.00 was returned with the may bank statement
h. a comparison between the deposit listed on the bank statement and the company's books revealed that a customer's check in the amount of 123.45 was recorded on the books during may but was never added to the company's account. the bank erroneously added the check to the account to calico closet, which has an account at the same bank
i. the comparison of deposit per the bank statement with those per the books revealed that another customer's check in the amount of 101.10 was correctly added to the company's account. in recording the check on the company's books, however, the accountant erroneously increased the cash account by $1,011.00
Required
1. prepare a bank reconciliation in good form
2. record the necessary journal entries on the company's books resulting from the bank reconciliation prepared in part (1)
3. a friend says to you: "i don't know why companies bother to prepare bank reconciliations it seems a waste of time. why don't they just do like I do and adjust the cash accounts for any difference between what the bank shows as a balance and what shows up in the books? explain to your friend why a bank reconciliation should be prepared as soon as a bank statement is received
Explanation / Answer
1. Prepare a bank reconciliation in good form. Bank Reconciliation Statement Balance as per Bank Statement $8,432.11 Add: Deposit in transit $1,250.00 Companies check added to personal account $123.45 Less: Checks issued but not presented $ 446.52 Adjusted Bank Balance $9,359.04 ======= Balance as per Company’s cash Book $9,965.34 Add: Interest collected by bank $465.00 Interest credited $54.60 $ 519.60 Less: Bank Charges $50.00 $10,484.94 NSF Check returned $166.00 Customer’s check Wrongly entered $909.90 $1,125.90 Adjusted Cash Balance $9,359.04 ======= 2. Record the necessary journal entries on the company’s books resulting from the bank reconciliation prepared in part (1) above. Cash 519.60 Interest revenue 519.60 Miscellaneous expense 50.00 Accounts receivable 166.00 Accounts payable 909.90 Cash 1,125.90 3. A friend says to you: “I don’t know why companies bother to prepare bank reconciliations it seems a waste of time. Why don’t they just do like I do and adjust the Cash account for any difference between what the bank shows as a balance and what shows up in the books?" Explain to your friend why a bank reconciliation should be prepared as soon as a bank statement is received. Bank reconciliation must be prepared, periodically, to know the reasons of differences and the same should be got corrected. It is not necessary that the error can be only in company’s cash book. There can be errors in bank statement also and the same should be get corrected from the bank.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.