Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I've posted this question a few times before but I didn't realize there was a missing number. Under Other Information / Book Balance, there should
I've posted this question a few times before but I didn't realize there was a missing number. Under Other Information / Book Balance, there should be an entry for 31-Mar-20 for &7,089.42.
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 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 137 CashGrabber Realty 138 Makagood Key Corp. 1.39 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 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 $15.90 0.99 436 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 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 21 21 22 22 24 24 27 29 29 30 Other Information Book Balance 31-Mar-20 Total Checks Disbursed 32.529.85 Instructions: Checks Outstanding March 31st 85 251.00 92 122.13 122 99.60 124 153.00 128 224.00 129 998.00 337.00 131 642.85 132 1.100.25 133 941.17 134 521.20 135 357.00 136 65.50 5,812.70 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 130 (all checks disbursed are payments on account) Deposit In Transit 31-Mar-20 $527.00 Problem 84 continued Scrooge National Bank 666 Crooked Hill Road Brentwood, NY 11717 Tummy Tortellini LIE Exit 2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening dance as of 31-Mar-20 $12.375.12 Deposits and other credits: April 1 2 3 9 10 $$27.00 1,620 3.726 2,791 158.5 WT 11 12 16 19 22 23 1.814.4 6.156 4374 1946 3.790 2.235.6 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.00 153.00 224.00 998.00 337.00 1.100.25 941.17 $21.20 357.00 65. SO 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 chock check check check 142 144 145 146 147 148 149 ISO 151 152 153 154 156 157 158 159 SIS.90 463.00 953 80 95 3 1830 231.00 394 54 1,08754 1.395 54 1.703 54 42445 3.127.00 1.350.00 2.650.00 $50.00 Electronic Funds Transfer (payment on account) Monthly service charge Dr. Kevorkian Health Management Insurance NSFcheck - (deposite check returned for insufficient funds) 1.303 39.75 1.122.88 1.419.12 Total checks and other debits 40.69330 Closing bata cons 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 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 137 CashGrabber Realty 138 Makagood Key Corp. 1.39 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 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 $15.90 0.99 436 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 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 21 21 22 22 24 24 27 29 29 30 Other Information Book Balance 31-Mar-20 Total Checks Disbursed 32.529.85 Instructions: Checks Outstanding March 31st 85 251.00 92 122.13 122 99.60 124 153.00 128 224.00 129 998.00 337.00 131 642.85 132 1.100.25 133 941.17 134 521.20 135 357.00 136 65.50 5,812.70 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 130 (all checks disbursed are payments on account) Deposit In Transit 31-Mar-20 $527.00 Problem 84 continued Scrooge National Bank 666 Crooked Hill Road Brentwood, NY 11717 Tummy Tortellini LIE Exit 2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening dance as of 31-Mar-20 $12.375.12 Deposits and other credits: April 1 2 3 9 10 $$27.00 1,620 3.726 2,791 158.5 WT 11 12 16 19 22 23 1.814.4 6.156 4374 1946 3.790 2.235.6 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.00 153.00 224.00 998.00 337.00 1.100.25 941.17 $21.20 357.00 65. SO 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 chock check check check 142 144 145 146 147 148 149 ISO 151 152 153 154 156 157 158 159 SIS.90 463.00 953 80 95 3 1830 231.00 394 54 1,08754 1.395 54 1.703 54 42445 3.127.00 1.350.00 2.650.00 $50.00 Electronic Funds Transfer (payment on account) Monthly service charge Dr. Kevorkian Health Management Insurance NSFcheck - (deposite check returned for insufficient funds) 1.303 39.75 1.122.88 1.419.12 Total checks and other debits 40.69330 Closing bata cons of 30-Apr-20 $819.12 WT - wire transfer (collection on account) Under the 'Instructions' Category, please only complete problem A! Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started