Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to fill in the cash entry chart using this information Heartland Mutual Bank May 1 to May 31 Deposits & Credit Memos Checks

I need to fill in the cash entry chart using this informationimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Heartland Mutual Bank May 1 to May 31 Deposits & Credit Memos Checks and Debit Memos 2,345.00 1467 4,850.00 1460 1464 1466 1458 1463 1465 1468 1459 224.25 8,645.00 350.00 1,622.53 153.00 1,165.40 254.43 785.00 1,010.05 255.00 6,875.00 555.00 1470 3,640.00 CM 1469 1,681.00 2,508.00 DM Beginning Balance 1-May 2-May 3-May 4-May 7-May 8-May 9-May 11-May 14-May 15-May 16-May 17-May 18-May 21-May 22-May 23-May 28-May 29-May 30-May 31-May 31-May Balance 8,645.15 10,640.15 4,167.62 4,014.62 11,269.97 11,015.54 17,105.54 13,010.49 12,755.49 14,436.49 16,382.26 5,552.26 3,782.60 2,924.85 7,312.50 14,056.50 4.381.35 10,296.35 18,746.35 12,035.10 9,952.25 9,651.09 1477 562.23 1,080.00 534.66 857.75 369.50 1476 1478 1474 1471 9,750.00 1,235.00 1475 662.85 5,420.00 6,744.00 1479 3,425.15 1480 480.00 NSF FEE 6,250.00 40.00 NSF 6,435.00 8,450.00 1485 1481 1484 1,065.25 1486 1,657.85 1482 2 94.22 Serv Chg 5,646.00 425.00 9.50 Interest 2.56 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. Credit Amount 1463 1464 1465 1466 1467 254.43 1,622.53 785.00 153.00 4,850.00 1468 1469 1470 1,010.05 255.00 3,640.00 Cash Ledger account Debit Date # Amount 1-May 1-May 1-May 1-May 1-May 1-May 3-May 51 8,645.00 7-May 52 6,875.00 8-May 8-May 8-May 11-May 53 1,681.00 14-May 54 2,508.00 15-May 15-May 15-May 15-May 15-May 15-May 15-May 15-May 18-May 55 5,420.00 21-May 56 6,744.00 22-May 22-May 25-May 57 6,435.00 28-May 58 8,450.00 29-May 29-May 29-May 29-May 29-May 1471 1472 1473 1474 1475 1476 1477 1478 369.50 1,235.00 354.00 857.75 626.85 1,080.00 9,750.00 534.66 Balance Amount 8,187.50 7,933.07 6,310.54 5,525.54 5,372.54 522.54 9,167.54 16,042.54 15,032.49 14.777.49 11,137.49 12.818.49 15,326.49 14,956.99 13,721.99 13,367.99 12,510.24 11,883.39 10,803.39 1,053.39 518.73 5,938.73 12.682.73 9,257.58 3,007.58 9,442.58 17,892.58 16,234.73 15,809.73 14,946.73 14,652.51 13,587.26 7,941.26 9,527.51 1479 1480 3,425.15 6,250.00 1481 1482 1483 1484 1485 1486 1,657.85 425.00 863.00 294.22 1,065.25 5,646.00 29-May 31-May 59 1,586.25 Bank Reconciliation Worksheet May Bank Statement Balance Cash Book Balance 9527.51 Add: Deposit in transit 1586.25 555.00 Add: AR collection Void ck# 1326 Interest 2.56 557.56 10085.07 Deduct: Outstanding Checks 1326 438.00 1453 625.00 1473 354.00 1483863 Deduct: DM utility bill Ck#1475 error NSF & Fee Service Charge 562.23 36 520 9.50 2280 Adjusted cash balance 8957.34 Adjusted cash balance L 8957.34 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. Prepare the necessary entries from the bank reconciliation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Democratic Audit Of Poland 2014

Authors: Radoslaw Markowski, Michal Kotnarowski, Michal Wenzel, Marta Zerkowska-Balas

1st Edition

3631656912, 978-3631656914

More Books

Students also viewed these Accounting questions