Based upon the information provided prepare a bank reconciliation for the month ended April 30, 2020 and the necessary journal entries relative to the reconciliation.

image text in transcribed

Cash Payments Journal all checks are payments on account April 2020 CASH RECEIPTS JOURNAL April 2020 DATE CHK PAYEE Amount Note: ALL cash receipts are collections on ACCOUNT AMOUNT DATE April 1 2 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 8 10 11 15 137 CashGrabber Realty 138 Makagood Key Corp. 139 Natarnicola's Commissary 140 Julia's Supplies & Amenities 141 Columbian Coffee Co. 142 Billy's Beans 143 Sister's of the Dreadful LAMS 144 Petty Cash 145 Verizon 146 Danielle's Donuts 147 The Daily Planet - key 148 Man Wa's Cuccina De' Casa 149 BP-AMOCO 150 AMEX 151 Maldarelli Brothers Trucking, Inc. 152 Rodriguez Rapid Transit 153 Philo kvetch 154 J. Pace 155 R. Weinstein 156 Frank's Yankee Paraphernalia 157 Verizon Wireless 158 Scrooge National Bank 159 L. Nguyen, CPA 160 NYS Income Tax 161 Squeegy Window Cleaning 1,080.00 7,700.00 462.00 1,309.00 5,621.00 515.90 0.99 436.00 953.80 95.38 183.80 231.00 394.54 1,087.54 1,395.54 1,703.54 424.45 3,127.00 5.03 1,350.00 463.34 2,650.00 550.00 725.00 65.00 1,620.00 3,726.00 2,719.00 1,814.40 6,156.00 4,374.00 1,944.00 3,790.80 2,235.60 5,141.88 33,521.68 18 21 22 30 Other Information 22 22 24 24 27 29 29 30 Book Balance 31-Mar-20 #REFI Total Checks Disbursed 32,529.85 Instructions: Based upon the information provided prepare: Checks Outstanding March 31st 85 251.00 92 122.13 122 99.60 124 153.00 128 224.00 129 998.00 130 337.00 131 642.85 132 1,100.25 133 941.17 134 521.20 135 357.00 136 65.50 5,812.70 A. A bank reconciliation for the month ended April 30, 2020 (assume errors, if any, are made by the company) B. The necessary journal entries relative to the reconciliation (all checks disbursed are payments on account) Deposit in Transit 31-Mar-20 $527.00 Scrooge National Bank 666 Crooked Hill Road Brentwood, N.Y. 11717 Tammy Tortellini LIE Exit 52 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening Balance as of 31-Mar-20 $12,375.12 Deposits and other credits: April 1 2 3 9 10 $527.00 1,620.00 3,726.00 2,791.00 158.50 WT 11 12 16 19 22 23 1,814.40 6,156.00 4,374.00 1,944.00 3,790.80 2,235.60 Total deposits and other credits. $29,137.30 Checks and other debits: 142 85 122 144 124 145 146 147 148 check # check # check # check # check #1 check # check # check # check # check # check # check # check # check # check. check # 128 129 130 132 133 134 135 136 137 138 139 140 141 251.00 99.60 153.00 224.00 998.00 337.00 1,100.25 941.17 521.20 357.00 65.50 1,080.00 7,700.00 462.00 1,309.00 5,621.00 check # check # check check # check # check check # check # check # check check # check # check # check # check check 149 150 151 152 153 154 156 157 158 159 515.90 463.00 953.80 95.38 183.80 231.00 394.54 1,087.54 1,395.54 1,703.54 424.45 3,127.00 1,350.00 463.34 2,650.00 550.00 Electronic Funds Transfer payment on account) Monthly service charge Dr. Kevorkian Health Management Insurance NSFcheck - deposite check returned for insufficient funds) 1,303.00 39.75 1,122.88 1,419.12 Total checks and other debits.. 40,693.30 Closing balance as of 30-Apr-20 $819.12 WT - wire transfer (collection on account) Cash Payments Journal all checks are payments on account April 2020 CASH RECEIPTS JOURNAL April 2020 DATE CHK PAYEE Amount Note: ALL cash receipts are collections on ACCOUNT AMOUNT DATE April 1 2 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 8 10 11 15 137 CashGrabber Realty 138 Makagood Key Corp. 139 Natarnicola's Commissary 140 Julia's Supplies & Amenities 141 Columbian Coffee Co. 142 Billy's Beans 143 Sister's of the Dreadful LAMS 144 Petty Cash 145 Verizon 146 Danielle's Donuts 147 The Daily Planet - key 148 Man Wa's Cuccina De' Casa 149 BP-AMOCO 150 AMEX 151 Maldarelli Brothers Trucking, Inc. 152 Rodriguez Rapid Transit 153 Philo kvetch 154 J. Pace 155 R. Weinstein 156 Frank's Yankee Paraphernalia 157 Verizon Wireless 158 Scrooge National Bank 159 L. Nguyen, CPA 160 NYS Income Tax 161 Squeegy Window Cleaning 1,080.00 7,700.00 462.00 1,309.00 5,621.00 515.90 0.99 436.00 953.80 95.38 183.80 231.00 394.54 1,087.54 1,395.54 1,703.54 424.45 3,127.00 5.03 1,350.00 463.34 2,650.00 550.00 725.00 65.00 1,620.00 3,726.00 2,719.00 1,814.40 6,156.00 4,374.00 1,944.00 3,790.80 2,235.60 5,141.88 33,521.68 18 21 22 30 Other Information 22 22 24 24 27 29 29 30 Book Balance 31-Mar-20 #REFI Total Checks Disbursed 32,529.85 Instructions: Based upon the information provided prepare: Checks Outstanding March 31st 85 251.00 92 122.13 122 99.60 124 153.00 128 224.00 129 998.00 130 337.00 131 642.85 132 1,100.25 133 941.17 134 521.20 135 357.00 136 65.50 5,812.70 A. A bank reconciliation for the month ended April 30, 2020 (assume errors, if any, are made by the company) B. The necessary journal entries relative to the reconciliation (all checks disbursed are payments on account) Deposit in Transit 31-Mar-20 $527.00 Scrooge National Bank 666 Crooked Hill Road Brentwood, N.Y. 11717 Tammy Tortellini LIE Exit 52 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening Balance as of 31-Mar-20 $12,375.12 Deposits and other credits: April 1 2 3 9 10 $527.00 1,620.00 3,726.00 2,791.00 158.50 WT 11 12 16 19 22 23 1,814.40 6,156.00 4,374.00 1,944.00 3,790.80 2,235.60 Total deposits and other credits. $29,137.30 Checks and other debits: 142 85 122 144 124 145 146 147 148 check # check # check # check # check #1 check # check # check # check # check # check # check # check # check # check. check # 128 129 130 132 133 134 135 136 137 138 139 140 141 251.00 99.60 153.00 224.00 998.00 337.00 1,100.25 941.17 521.20 357.00 65.50 1,080.00 7,700.00 462.00 1,309.00 5,621.00 check # check # check check # check # check check # check # check # check check # check # check # check # check check 149 150 151 152 153 154 156 157 158 159 515.90 463.00 953.80 95.38 183.80 231.00 394.54 1,087.54 1,395.54 1,703.54 424.45 3,127.00 1,350.00 463.34 2,650.00 550.00 Electronic Funds Transfer payment on account) Monthly service charge Dr. Kevorkian Health Management Insurance NSFcheck - deposite check returned for insufficient funds) 1,303.00 39.75 1,122.88 1,419.12 Total checks and other debits.. 40,693.30 Closing balance as of 30-Apr-20 $819.12 WT - wire transfer (collection on account)