Question

1 Approved Answer

Posted on Jul 09, 2024

Instructions: Based upon the information provided prepare: A. A bank reconciliation for the month ended April 30, 2020 (assume errors, if any, are made by

image text in transcribed

Instructions: Based upon the information provided prepare: 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) Cash Payments Journal all checks are payments on account April 2020 DATE CHK PAYEE Amount 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 22 22 24 24 27 29 29 30 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 Total Checks Disbursed 32,529.85 CASH RECEIPTS JOURNAL April 2020 Note: ALL cash receipts are collections on ACCOUNT AMOUNT DATE April 1 2 8 10 11 15 18 21 22 30 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 Other Information Book Balance 31-Mar-20 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 Deposit In Transit 31-Mar-20 $527.00 Problem #4 continued 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 N- 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: check # check # check # check # check # check # check # check # check # check # check # check # check # check # check # check # 85 122 124 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 # 142 144 145 146 147 148 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) Instructions: Based upon the information provided prepare: 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) Cash Payments Journal all checks are payments on account April 2020 DATE CHK PAYEE Amount 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 22 22 24 24 27 29 29 30 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 Total Checks Disbursed 32,529.85 CASH RECEIPTS JOURNAL April 2020 Note: ALL cash receipts are collections on ACCOUNT AMOUNT DATE April 1 2 8 10 11 15 18 21 22 30 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 Other Information Book Balance 31-Mar-20 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 Deposit In Transit 31-Mar-20 $527.00 Problem #4 continued 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 N- 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: check # check # check # check # check # check # check # check # check # check # check # check # check # check # check # check # 85 122 124 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 # 142 144 145 146 147 148 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)