if this can be answered within the day that would be great

Problem #7 Information pertaining to the "books" of Toni's Totellini Company is shown below: Cash Payments Journal all checks are payments on account April 2021 CASH RECEIPTS JOURNAL April 2021 DATE CHK PAYEE Amount Note: ALL cash receipts are collections on ACCOUNT 4 4 1,080.00 7,600.00 508.50 1,292.00 5,548.00 509.20 0.99 463.00 941.41 AMOUNT DATE April 1 7 2 8 10 11 1 137 CashGrabber Realty 2 138 Makagood key Corp. 3 139 Natarnicola's Commissary 140 Jennifer's Supplies & Amenities 141 Columbian Coffee Co. 7 142 Billy's Beans 143 Sister's of the Dreadful LAMS 144 Petty Cash 145 Verizon 13 146 Danielle's Donuts 13 147 The Daily Planet-key 15 148 Man Wa's Cuccina De Casa 16 149 BP-AMOCO 19 150 AMEX 20 151 Maldonado Sisters Trucking 152 Rodriguez Rapid Transit 21 153 Philo kvetch 22 154 1. 22 155 R. Weinstein 24 156 Frank's Yankee Paraphernalia 24 157 Verizon Wireless 27 158 Scrooge National Bank 29 159 S. Arif, CPA 160 Petty Cash 30 161 Squeegy Window Cleaning 15 1,620.00 3,726.00 2,771.00 1,814.40 6,156.00 4,374.00 1,944.00 3,790.80 2,235.60 5,141.88 33,573.68 18 21 22 30 10.92 120.00 278.65 135.60 760.00 74.17 988.00 1,672.00 3,127.00 5.03 1,350.00 463.34 2,650.00 550.00 725.00 65.00 ORANSSON Other Information Book Balance 31-Mar-21 7,689.42 Total Checks Disbursed Checks Outstanding March 31st 85 251.00 92 122.13 30,917.81 Problems 16 Problem 7 27 29 29 2,650.00 550.00 725.00 Book Balance 31-Mar-21 158 Scrooge National Bank 159 S. Arif, CPA 160 Petty Cash 161 Squeegy Window Cleaning 7,689.42 30 65.00 Checks Outstanding March 31st 85 251.00 92 122.13 Total Checks Disbursed 30,917.81 122 99.60 124 153,00 Instructions: 128 224.00 129 998.00 337.00 Based upon the information provided prepare: 130 131 132 42.85 1,100.25 941.17 521:20 A. A bank reconciliation for the month ended April 30, 2021 (assume errors, if any, are made by the company) 133 134 135 136 357.00 65,50 5,212.70 B. The necessary journal entries relative to the reconciliation. (all checks disbursed are payments on account) Deposit in Transit 31-Mar-21 S527.00 Please type solutions below and return as an Excel file Problem #7 continued Scrooge National Bank 666 Crooked Hill Road Brentwood, N.Y. 11717 Toni's Tortellini Company 125 Main Street Commack, New York 11768 Period Opening Period Closing 31-Mar-21 30-Apr-21 Opening Balance as of 31-Mar-21 $12,375.12 Deposits and other credits: April 12 13 1 $527.00 2 1,620.00 3 3,726.00 9 2,717.00 10 158.50 WT 11 1,814,40 L N G G 5 g 16 19 22 23 6,156.00 52.50 BCR 4,374.00 1,944.00 3,790.80 2,235.60 $29,115.80 Total deposits and other credits..... Checks and other debits: 85 142 144 122 124 145 check # check # check # check # check # check # check # check # check # 146 147 148 128 129 130 132 133 134 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,600.00 508.50 1,292.00 5,548.00 check # check # check # check # check # check # check # check # check # check # check # check # check # check # check # check 149 150 151 152 153 154 509.20 436.00 941.41 10.92 120.00 278.65 135.60 760.00 74.17 988.00 1,672.00 3,127.00 1,350.00 463.34 2,650.00 550.00 check # check # check 135 136 137 check # check check # check # 138 139 140 141 156 157 158 159 Electronic Funds Transfer (payment on account) Monthly service charge Dr. Kevorkian Health Management Insurance NSFcheck - (deposite check returned for insufficient fund Total checks and other debits....... 1,303.00 31.29 775.88 1.419.12 38,671.80 $2,819.12 Closing balance as of 30-Apr-21 WT-wire transfer (collection on account) BCR-Bank charge reversal Happy Spring