On May 31st, 2015, Rubber Company had a balance in its cash book of Rs. 678,150. Its bank book
showed a balance of Rs. 640,460. A comparison revealed the following facts:
a. The statement included a debit memo of Rs. 4,000 for the printing of additional company cheques.
b. Cash sales of Rs. 83,615 on May 12 were deposited in the bank. The cash receipts journal entry and
the deposit slip were incorrectly made for Rs. 88,615. The bank credited Rubber Company for the
correct amount.
c. Unpresented cheques at May 31st totaled Rs. 57,625. Deposits in transit were Rs. 241,615.
d. On May 18th
, the company issued cheque no. 1181 for Rs. 68,500 to Ms. Laila on account. The cheque,
which cleared the bank in May, was incorrectly journalized and posted by Rubber Company for Rs.
65,800.
e. A Rs. 300,000 note receivable was collected by the bank for Rubber Company on May 31 plus
Rs. 8,000 interest. The bank charged a collection fee of Rs. 2,000. No interest has been accrued on the
note.
f. Included with the canceled cheques was a cheque issued by Straight Company to Red Cross for Rs.
80,000 that was incorrectly charged to Rubber Company by the bank.
g. On May 31st
, the bank book showed an NSF charge of Rs. 68,000 for a cheque issued by Mr. Ali, a
customer, to Rubber Company on account.
Instructions
i. Prepare the bank reconciliation at May 31, 2015. (answer: Rs. 904,450)
ii. Prepare the necessary adjusting entries for Rubber Company at May 31st, 2015.
Solution i:
Rubber Company | |||||
Bank Reconciliation | |||||
May 31,2015 | |||||
Bank Statement Balance | $6,40,460 | Cash Balance per Company's Records | $6,78,150 | ||
Add: | Add: | ||||
Deposit in transit | $2,41,615 | Note Collected | $3,00,000 | ||
Bank Error in posting another company's Check | $80,000 | $3,21,615 | Interest on Note | $8,000 | $3,08,000 |
Subtotal | $9,62,075 | Subtotal | $9,86,150 | ||
Deduct: | Deduct: | ||||
Outstanding Checks | $57,625 | Bank Service Charges (For Printing Checks) | $4,000 | ||
$57,625 | Cash deposit slips incorrectly recorded ($88615-$83615) | $5,000 | |||
Incorrect recording of Check 1181 ($68500-$65800) | $2,700 | ||||
Collection Fee on Note | $2,000 | ||||
NSF Check | $68,000 | $81,700 | |||
Adjusted Bank Balance | $9,04,450 | Adjusted Cash Balance | $9,04,450 |
Solution ii:
Journal Entries | |||
S.No | Particulars | Debit | Credit |
a. | Bank Service Charges Dr | $4,000 | |
To Cash | $4,000 | ||
(To record Service charges for printing Cheques) | |||
b. | Sales Dr ($88615-$83615) | $5,000 | |
To Cash | $5,000 | ||
(To correct the Cash sales deposits) | |||
c. | No entry required | ||
d. | Accounts Payable Dr | $2,700 | |
To Cash | $2,700 | ||
(To correct payment on account of check 1181) | |||
e. | Cash Dr | $3,06,000 | |
Bank Service Charges Dr (Collection Fee) | $2,000 | ||
To Note Receivable | $3,00,000 | ||
To Interest Revenue | $8,000 | ||
(To record Note collected by bank and collection fee charged on it) | |||
f. | No Entry required | ||
g. | Accounts Receivable Dr | $68,000 | |
To Cash | $68,000 | ||
(To record NSF Check from customer) | |||
On May 31st, 2015, Rubber Company had a balance in its cash book of Rs. 678,150....
MODULE 10-ACCOUNTING INFORMATION SYSTEM AND INTERNAL CONTROL TUTORIAL SOLUTIONS Question 22 On 31 May 2015 Computec Ltd had a cash balance as per company records of $5,681.50 debit. The bank statement from Community Bank on that date showed a credit balance of $7,784.60. A comparison of the statement with the cash account revealed the following facts: 1. The statement included a debit entry of $60 for the printing of additional company cheques. 2. Cash sales of $836.15 on 12 May...
Problem 7-3A On May 31, 2015, Reber Company had a cash balance per books of $7,104.50. The bank statement from New York State Bank on that date showed a balance of $6,727.60. A comparison of the statement with the Cash account revealed the following facts. 1. The statement included a debit memo of $49.00 for the printing of additional company checks. 2. Cash sales of $832.00 on May 12 were deposited in the bank. The cash receipts journal entry and...
4) The following information was available for Anderson Company for the monthended May 31, 2015. (a) The book balance at May 31, 2015 was $3,890.22. (b) The bank balance at May 31, 2015 was $5,660.22. (c) Outstanding cheques amounted to $6,310. (d) The May 31st cash receipts of $5,600 were deposited but have not yet appeared on the bank statement. A $50 debit memorandum for cheques printed by the bank was included with the cancel cheques. (D A customer's note...
Problem 7-3A (Part Level Submission) On May 31, 2015, Reber Company had a cash balance per books of $7,095.50. The bank statement from New York State Bank on that date showed a balance of $6,718.60. A comparison of the statement with the Cash account revealed the following facts. 1. The statement included a debit memo of $48.00 for the printing of additional company checks. 2. Cash sales of $734.00 on May 12 were deposited in the bank. The cash receipts...
P7-3A On May 31, 2017, Rebe On May 31, 2017, Reber Company had a cash balance per books of $6,781.50. The P k statement from New York State Bank on that date showed a balance of $6,404.60. A a omparison of the statement with the Cash account revealed the following facts. The statement included a debit memo of $40 for the printing of additional company checks. 2. Cash sales of $836.15 on May 12 were deposited in the bank. The...
P7-3A On May 31, 2017, Reber Company had a cash balance per books of $6,781.50. The bank statement from New York State Bank on that date showed a balance of $6,404.60. A comparison of the statement with the Cash account revealed the following facts. 1. The statement included a debit memo of $40 for the printing of additional company F a ( checks. 2. Cash sales of $836.15 on May 12 were deposited in the bank. The cash receipts journal...
On 30 June 2019, Parson Limited had a cash balance in its general ledger of $13,034.30 debit. The bank statement from ASB on that date showed a credit balance of $19,495.00. A comparison of the statement with the cash ledger account and the bank reconciliation for May 2019 revealed the following facts: (i) Two cheques, totalling $1,770.10, from the May 2019 bank reconciliation had still not been presented to the bank. (ii) Cash sales of $2,945 on 20 June were...
The bank reconciliation for Julia's company showed an adjusted cash balance of $6214 as the correct May 31st 20x4 balance. During May 20x4, the bank statement was received and included the following: Bank service charges $233 Interest on bank loan $225 In addition, during May 20x4 $3668 of outstanding cheques had not yet cleared the bank. What is the unadjusted (i.e. before receiving the bank statement) cash balance at May 31st, 20x4? Select one: a. $10340 Ob. $2088 c. $5756...
Question 6 The following information was available for Anderson Company for the month ended May 31, 2020. (a) On May 31, 2020, the book balance was $3,890.22 and the bank balance was $5,760.22. (b) Outstanding cheques amounted to $6,310. (c) The May 31st cash receipts of $5,600 were deposited but have not yet appeared on the bank statement. (d) A $50 debit memorandum for cheques printed by the bank was included in the bank statement. (e) A customer’s note for...
Exercise 78 On May 31, 2011. James Logan Company had a cash balance per books of 66,781.50. The bank statement from Farmers Community Bank on that date showed a balance of 6.40460A comparison of the statement with the cash account revealed the following facts. 1. The statement included a debit memo of 40 for the printing of additional company checks 2. Cash sales of 836.15 on May 12 were deposited in the bank. The cash recipes journal entry and the...