Question

Use the bank statement, general ledger account and prior month bank reconciliation on the first three pictures to prelare the current month bank reconiciliation. (pic 4)

Make all necessary journal entries from the bank reconicilation ( see pic 5)

Pictures included for the information needed and the templates for the answer

0 D A B C F G Н. Heartland Mutual Bank May 1 to May 31 Deposits & Checks and Debit Memos Credit Memos Balance Beginning Balance 8,645.15 1-May 1460 350.00 2,345.00 10,640.15 2-May 1464 1,622.53 1467 4,850.00 4,167.62 3-May 1466 153.00 4,014.62 4-May 1458 1,165.40 1459 224.25 8,645.00 11,269.97 7-May 1463 254.43 11,015.54 8-May 1465 785.00 6,875.00 17,105.54 9-May 1468 1,010.05 1470 3,640.00 CM 555.00 13,010.49 11-May 1469 255.00 12,755.49 14-May 1,681.00 14,436.49 15-May DM 562.23 2,508.00 16,382.26 16-May 1476 1,080.00 1477 9,750.00 5,552.26 17-May 1478 534.66 1472 1,235.00 3,782.60 18-May 1474 857.75 2,924.85 21-May 1471 369.50 1475 662.85 5,420.00 7,312.50 22-May 6,744.00 14,056.50 23-May 1479 3,425.15 1480 6,250.00 4,381.35 28-May NSF 480.00 NSF FEE 40.00 6,435.00 10,296.35 29-May 8,450.00 18,746.35 30-May 1485 1,065.25 1486 5,646.00 12,035.10 5 31-May 1481 1,657.85 1482 425.00 9,952.25 31-May 1484 294.22 Serv Chg 9.50 Interes 2.56 9,651.09 7 8 9 DM is for electric bill 0 CM is for collection on account net of fee of $15. Customer owed 570. Bank collected the amount and charged us a fee. 2 13 14

Answer 1

Date	General Journal	Debit	Credit
		$	$
April 30	Cash	235
	Accounts Receivable		235
	To record collection on account
April 30	Cash	3.21
	Interest Revenue		3.21
	To record interest earned from bank
April 30	Accounts Receivable	75.50
	Cash		75.50
	To record NSF check from customer
April 30	Utilities Expense	426.85
	Cash		426.85
	To record payment of utilities expense
April 30	Miscellaneous Expense	10
	Cash		10
	To record bank service charges
April 30	Accounts Payable	2.30
	Cash		2.30
	To rectify error in recording check