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 B 1 Cash Ledger account 2 Debit 3 Date # Amount 1-May 5 1-May 6 1-May 7 1-May 1-May 9 1-May 10 3-May 51 11 7-May 52 ## 12 8-May 13 8-May 14 8-May 15 11-May 53 ##### 16 14-May 54 ##*****## 17 15-May 18 15-May 19 15-May 20 15-May 21 15-May 22 15-May 23 15-May 24 15-May 25 18-May 55 ####### 26 21-May 56 27 22-May 22-May 29 25-May 57 ## 30 28-May 58 31 29-May 32 29-May 33 29-May 34 29-May 35 29-May 36 29-May 37 31-May 59 38 Credit Balance # Amount Amount 8,187.50 1463 254.43 7,933.07 1464 1,622.53 6,310.54 1465 785.00 5,525.54 1466 153.00 5,372.54 1467 4,850.00 522.54 9,167.54 16,042.54 1468 1,010.05 15,032.49 1469 255.00 14.777.49 1470 3,640.00 11,137.49 12,818.49 15,326.49 1471 369.50 14,956.99 1472 1,235.00 13,721.99 1473 354.00 13,367.99 1474 857.75 12,510.24 1475 626.85 11,883.39 1476 1,080.00 10,803.39 1477 9,750.00 1,053.39 1478 534.66 518.73 5,938.73 12,682.73 1479 3,425.15 9,257.58 1480 6,250.00 3,007.58 9,442.58 17,892.58 1481 1,657.85 16,234.73 1482 425.00 15,809.73 1483 863.00 14,946.73 1484 294.22 14,652.51 1485 1,065.25 13,587.26 1486 5,646.00 7,941.26 9,527.51 28 B E F Bank Reconciliation Worksheet April Bank Statement Balance 8,645.15 Cash Book Balance 8,463.94 Add: Deposit in transit 2,345.00 Add: AR collection Interest 235.00 3.21 238.21 Deduct: Outstanding Checks 1326 438.00 1453 625.00 1458 1,165.40 1459 224.25 1460 350.00 Deduct: NSF & Fee DM utility bill Service Charge Check error check 1426 75.50 426.85 10.00 2.30 514.65 2,802.65 Adjusted cash balance 8,187.50 Adjusted cash balance 8,187.50 Bank Reconciliation Worksheet May Bank Statement Balance Cash Book Balance Add: Deposit in transit Add: AR collection Void ck# 1326 Interest Deduct: Outstanding Checks Deduct: DM utility bill Ck#1475 error NSF & Fee Service Charge Adjusted cash balance Adjusted cash balance Assume that all checks written are for accounts payable 2 Check 1326 is over six months old and the vendor has shown the account paid. It was originally for repairs. D A B C Prepare the necessary entries from the bank reconciliation