I have to fill in the cash entry chart using this information
Heartland Mutual Bank 1 2 May 1 to May 31 Deposits & 3 4 Checks and Debit Memos Credit Memos Balance Beginning Balance 1-May 2-May 8,645.15 10,640.15 4,167.62 5 6 350,00 2,345.00 1460 1464 1,622.53 4,850.00 7 1467 3-May 4-May 7-May 8-May 153.00 4,014.62 8 1466 1,165.40 254.43 224.25 8,645.00 11,269.97 1458 1459 1463 11,015.54 10 785.00 6,875.00 17,105.54 11 1465 9-May 11-May 14-May 15-May 16-May 17-May 18-May 21-May 12 1,010.05 255.00 3,640.00 CM 555.00 13,010.49 12,755.49 14,436.49 1468 1470 13 1469 1,681.00 2,508.00 14 562.23 DM 16,382.26 15 9,750.00 1,235.00 1476 1,080.00 5,552.26 16 1477 534.66 1472 3,782.60 2,924.85 7,312.50 17 1478 857.75 18 1474 369.50 1475 662.85 5,420.00 6,744.00 19 1471 22-May 23-ay 28-May 29-May 30-May 31-May 31-ay 20 14,056.50 4,381.35 21 3,425.15 480.00 NSF FEE 6,250.00 40.00 1479 1480 22 6,435.00 8,450.00 10,296.35 NSF 18,746.35 23 5,646.00 24 1,065.25 1,657.85 294.22 Serv Chg 12,035.10 1485 1486 25 425.00 9,952.25 1481 1482 9.50 Interest 26 2.56 9,651.09 1484 27 28 29 DM is for electric bill CM is for collection on account net of fee of $15. Customer owed 570. Bank collected the amount and charged us a fee 30 Cash Ledger account Debit Credit Balance Date # Amount # Amount Amount 8,187.50 7,933.07 1-May 1-May 1-May 1-May 1-May 1-May 3-May 7-May 8-May 8-May 8-May 11-May 14-May 15-May 15-May 15-May 15-May 15-May 15-May 15-May 15-May 18-May 21-May 22-May 22-May 25-May 28-May 29-May 29-May 29-May 29-May 29-May 29-May 31-May 254.43 1463 6,310.54 5,525.54 5,372.54 1,622.53 1464 1465 785.00 153.00 1466 1467 4,850.00 522.54 51 8,645.00 52 6,875.00 9,167.54 16,042.54 15,032.49 1,010.05 1468 255.00 14,777.49 1469 1470 3,640.00 11,137.49 53 1,681.00 54 2,508.00 12,818.49 15,326.49 14,956.99 1,235.00 13,721.99 13,367.99 369.50 1471 1472 354.00 1473 857.75 12,510.24 1474 11,883.39 1,080.00 10,803.39 626.85 1475 1476 1,053.39 518.73 5,938.73 1477 9,750.00 534.66 1478 55 5,420.00 56 6,744.00 12,682.73 9,257.58 3,425.15 6,250.00 1479 3,007.58 9,442.58 1480 57 6,435.00 58 8,450.00 17,892.58 1,657.85 16,234.73 1481 425.00 15,809.73 1482 14,946.73 14,652.51 1,065.25 13,587.26 863.00 1483 294.22 1484 1485 5,646.00 7,941.26 9,527.51 1486 59 1,586.25 Bank Reconciliation Worksheet April Bank Statement Balance 8,645.15 Cash Book Balance 8,463.94 Add: Deposit in transit Add: AR collection Interest 2,345.00 235.00 3.21 238.21 Deduct NSF & Fee DM utility bill Service Charge Deduct Outstanding Checks 75.50 426.85 438.00 1326 625.00 10.00 1453 1458 1,165.40 2.30 Check error check 1426 224.25 514.65 1459 350.00 1460 2,802.65 Adjusted cash balance Adjusted cash balance 8,187.50 8,187.50 1 2 3 4 5 6 7 Bank Reconciliation Worksheet 9 10 May 11 Bank Statement Balance Cash Book Balance 12 9651.09 9527.51 13 14 Add: Add: AR collection Void ck# 1326 Interest Deposit in transit 16 15 1586.25 555.00 17 2.56 557.56 18 10085.07 19 Deduct: Deduct: Outstanding Checks 21 22 DM utility bill Ck#1475 error NSF & Fee Service Charge 20 562.23 438.00 1326 36 625.00 1453 520 23 1473 354.00 9.50 24 2280 1483 863 25 26 27 28 Adjusted cash balance Adjusted cash balance 8957.34 8957.34 29 30 31 Assume that all checks written are for accounts payable. Check 1326 is over six months old and the vendor has shown the account paid. It was originally for repairs. 32 33 34 35 36 37 38 Prepare the necessary entries from the bank reconciliation Heartland Mutual Bank 1 2 May 1 to May 31 Deposits & 3 4 Checks and Debit Memos Credit Memos Balance Beginning Balance 1-May 2-May 8,645.15 10,640.15 4,167.62 5 6 350,00 2,345.00 1460 1464 1,622.53 4,850.00 7 1467 3-May 4-May 7-May 8-May 153.00 4,014.62 8 1466 1,165.40 254.43 224.25 8,645.00 11,269.97 1458 1459 1463 11,015.54 10 785.00 6,875.00 17,105.54 11 1465 9-May 11-May 14-May 15-May 16-May 17-May 18-May 21-May 12 1,010.05 255.00 3,640.00 CM 555.00 13,010.49 12,755.49 14,436.49 1468 1470 13 1469 1,681.00 2,508.00 14 562.23 DM 16,382.26 15 9,750.00 1,235.00 1476 1,080.00 5,552.26 16 1477 534.66 1472 3,782.60 2,924.85 7,312.50 17 1478 857.75 18 1474 369.50 1475 662.85 5,420.00 6,744.00 19 1471 22-May 23-ay 28-May 29-May 30-May 31-May 31-ay 20 14,056.50 4,381.35 21 3,425.15 480.00 NSF FEE 6,250.00 40.00 1479 1480 22 6,435.00 8,450.00 10,296.35 NSF 18,746.35 23 5,646.00 24 1,065.25 1,657.85 294.22 Serv Chg 12,035.10 1485 1486 25 425.00 9,952.25 1481 1482 9.50 Interest 26 2.56 9,651.09 1484 27 28 29 DM is for electric bill CM is for collection on account net of fee of $15. Customer owed 570. Bank collected the amount and charged us a fee 30 Cash Ledger account Debit Credit Balance Date # Amount # Amount Amount 8,187.50 7,933.07 1-May 1-May 1-May 1-May 1-May 1-May 3-May 7-May 8-May 8-May 8-May 11-May 14-May 15-May 15-May 15-May 15-May 15-May 15-May 15-May 15-May 18-May 21-May 22-May 22-May 25-May 28-May 29-May 29-May 29-May 29-May 29-May 29-May 31-May 254.43 1463 6,310.54 5,525.54 5,372.54 1,622.53 1464 1465 785.00 153.00 1466 1467 4,850.00 522.54 51 8,645.00 52 6,875.00 9,167.54 16,042.54 15,032.49 1,010.05 1468 255.00 14,777.49 1469 1470 3,640.00 11,137.49 53 1,681.00 54 2,508.00 12,818.49 15,326.49 14,956.99 1,235.00 13,721.99 13,367.99 369.50 1471 1472 354.00 1473 857.75 12,510.24 1474 11,883.39 1,080.00 10,803.39 626.85 1475 1476 1,053.39 518.73 5,938.73 1477 9,750.00 534.66 1478 55 5,420.00 56 6,744.00 12,682.73 9,257.58 3,425.15 6,250.00 1479 3,007.58 9,442.58 1480 57 6,435.00 58 8,450.00 17,892.58 1,657.85 16,234.73 1481 425.00 15,809.73 1482 14,946.73 14,652.51 1,065.25 13,587.26 863.00 1483 294.22 1484 1485 5,646.00 7,941.26 9,527.51 1486 59 1,586.25 Bank Reconciliation Worksheet April Bank Statement Balance 8,645.15 Cash Book Balance 8,463.94 Add: Deposit in transit Add: AR collection Interest 2,345.00 235.00 3.21 238.21 Deduct NSF & Fee DM utility bill Service Charge Deduct Outstanding Checks 75.50 426.85 438.00 1326 625.00 10.00 1453 1458 1,165.40 2.30 Check error check 1426 224.25 514.65 1459 350.00 1460 2,802.65 Adjusted cash balance Adjusted cash balance 8,187.50 8,187.50 1 2 3 4 5 6 7 Bank Reconciliation Worksheet 9 10 May 11 Bank Statement Balance Cash Book Balance 12 9651.09 9527.51 13 14 Add: Add: AR collection Void ck# 1326 Interest Deposit in transit 16 15 1586.25 555.00 17 2.56 557.56 18 10085.07 19 Deduct: Deduct: Outstanding Checks 21 22 DM utility bill Ck#1475 error NSF & Fee Service Charge 20 562.23 438.00 1326 36 625.00 1453 520 23 1473 354.00 9.50 24 2280 1483 863 25 26 27 28 Adjusted cash balance Adjusted cash balance 8957.34 8957.34 29 30 31 Assume that all checks written are for accounts payable. Check 1326 is over six months old and the vendor has shown the account paid. It was originally for repairs. 32 33 34 35 36 37 38 Prepare the necessary entries from the bank reconciliation
