Question

8-28 You have been asked to help the Rancher Company prepare its bank reconciliation. You examine the company's accounting records and its bank statement at May 31, and find the following information: (a) The Cash account has a balance of $7,753.24. (b) The bank statement shows a bank balance of $3,783.04. (c) The May 31 cash receipts of $4,926.18 were deposited in the bank at the end of that day but were not recorded by the bank until June 1. (d) Checks issued and mailed in May but not included among the checks listed as paid on the bank statement were as follows: Check No. 949 Check No. 957 $518.65 699.95 (e) A bank service charge of $27 for May was deducted on the bank statement. (f) A check received from a customer for $241 in payment of her account and deposited by the Rancher Company was returned marked “NSF” with the bank statement. (8) Interest of $25.18 earned on the company's checking account was added on the bank statement. (h) The Rancher Company discovered that Check No. 941, which was correctly written as $647.21 for the May utility bill, was recorded as $627.41 in the company's accounts. Required: (1) Prepare a bank reconciliation on May 31. (2) Record the appropriate adjustments in the company's accounts. Compute the ending balance in the Cash account.

Answer 1

SOLUTION

1. Bank reconciliation statement

Particulars	Amount ($)
Balance as per bank statement	3,783.04
Add : Deposits in transit	4,926.18
	8,709.22
Less : Outstanding checks (518.65+699.95)	(1,218.60)
Corrected Bank balance	7,490.62
Balance per books	7,753.24
Add : Interest Earned	25.18
	7,778.42
Less: Check incorrectly recorded (647.21-627.41)	(19.80)
Bank service charges	(27.00)
NSF check	(241.00)
Corrected Book balance	7,490.62

2. Journal entries

S.No.	Accounts titles and Explanation	Debit ($)	Credit ($)
1.	Cash	25.18
	Interest Income		25.18
2.	Utility Expenses	19.80
	Cash		19.80
3.	Service Charges	27.00
	Cash		27.00
4.	Accounts Receivable (NSF checks)	241.00
	Cash		241.00

Ending balance in the Cash account = 7,490.62