based upon the information provided prepare:

a. a bank reconcilliation for the minth ended april 30, 2020

b. the necessary journal wntries relative to the reconcilliation

there is a missing information

Other Information

Book Balance

31-Mar-20 ----------------------> 7,089.42

Problem Cash Paynents Journe Michecia are payments on account April 2020 CASH RECENTS JOURNAL April 2020 RATE CHIK PAYLE Amount Note: All cash recept we collections on ACCOUNT AMOUNT 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 137 CashGrabber Realty 138 Makgood key Corp 129 Natamicola's Commissary 140 Jula's Supplies Ames 141 Columbia Coffee Co 142 B's Beans 143 Sisters of the Dreadful LAMS 144 Petty Cash 145 Verion 146 Daniele's Donuts 147 The Daily Planet-key 148 Man Wa's Cuecina De Casa 149 BP-AMOCO 150 AMDX 151 Maldarell Brothers Trucking 152 Rodrigues Rapid Trans 153 Philo Ketch 154 1. Pace 155 R. Weinstein 156 Frank Yankee Parapher 157 Verizon Wireless 158 Scrooge National Bank 159 L.Nguyen.CPA 160 NS income Tax 161 Sony Window Cleaning 1,080.00 7,700.00 462.00 1,309.00 5,621.00 515 90 0.99 435.00 953.80 95.38 183.80 23100 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 $5.00 DATE April 1 2 8 10 11 15 18 21 22 30 1,520.00 3,726.00 2,719.00 1,814.40 6,156.00 4374.00 1.944.00 3,790.80 2.235.60 5,141.88 33521.65 22 22 Other Information 24 27 20 29 30 Book Balance 31-Mar-20 ERER Total Checa Disbursed 32,529 RS Instructions: Based upon information provided prepare Check Outstanding Marutat 85 251.00 92 122.11 122 99.60 124 153.00 128 224.00 129 9.00 110 33700 111 64235 132 1 100 25 133 94117 134 52110 135 357.00 136 65.50 5.8120 25 SU A Action for the month ended Apr,2030 wany, we made by the company 3. The newryum ante to then 49 50 5 52 D 31-0 STO Problem 1 Problem Probleme Problem 4 Ready U w Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, NY 11217 Tammy Torten UE52 Rest Stop Commack, New York 11768 Period Opening Purid Closing 11.Mar. 20 30-Apr-20 Opening Barce 31-Mar-20 $1237512 Deposits and other credits April 1 3 9 10 5527.00 1.620.00 3,726.00 2.791 00 15850 WT 12 16 19 22 23 1.214.40 6,156.00 4,37400 1,9444.00 3.790.00 2.235.50 Total deposits and other crediti $2913730 Checks and other debit 251.00 chat checko checke 85 122 124 99.00 142 144 145 146 cha check chacko check check check 129 130 112 133 114 153.00 224.00 99DO 337.00 1.10025 94112 52120 35700 6550 1,000.00 7.300 DO 45200 1.109 DD 5.621.00 Check check check check che che check chack Check Check 141 149 150 151 152 153 154 156 157 $15.90 463.00 95380 95.38 30 23100 19454 1,08754 1.191.54 1.7035 42445 1127.00 1 350.00 46334 2.450.00 550.00 130 137 Check check check checke Check Check 139 140 141 check tham 159 130100 Ben Funds Tronto con Moyen Or Kenneth Magnetic 1133 Problem #4 Cash Payments Journal all checks are payments on account April 2020 DATE CHK PAYEE Amount 1 2 3 4 4 7 7 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 Natamicola'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 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 $50.00 725,00 65.00 Total Checks Disbursed 32.529.85 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 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 941.17 521.20 135 357.00 136 5,812.70 65 50 Deposit In Transit 31-Mar-20 $527.00 Problem 54 continued Scrooge National Bank 666 Crooked Hill Road Brentwood, NY 11717 Tammy Tortellini LIE Exit 2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening Bilance as of 31-Mar-20 $12.375.12 Deposits and other credits: April 1 2 3 9 10 S$27.00 1.620 3.726 2.791 138.5 WT 11 12 16 19 22 23 1,814.4 6.156 4.374 1.944 3.790.8 2.235,6 Total deposits and other credits S29,137.30 Checks and other debits 142 144 145 146 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 148 149 150 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 3.621.00 check check check # check check # check # check check check check check check check check check check # SI5.90 463.00 953.80 95 38 183.80 231.00 394.54 1,08754 1.395.54 1.703.54 424.45 3,127.00 1,350.00 463 34 2.650.00 550.00 151 152 153 154 156 157 158 159 141 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,693.30 Closing balance as of 30-Apr-20 5819.12 WT-Wire transfer (collection on account) Happy Spring AutoSave OFF BESUS Draw Page Layout Home Insert Formulas Data Review View Tell me G49 C Problem Cash Payment wiches repayments on Apr 2000 CASH RECETSJOURNAL Apr 2000 DATE CH PAYLE Note ALL the 1 2 3 4 12 15 ACCOUNT AMOUNT DAT Aure 16 17 10 20 21 22 2 7 9 9 13 13 15 16 19 20 21 137 Cabber 138 Med Kay Core 139 Nico's Com 140 Jula's Supplies Amenities 141 Columbia Coco 14. Bi 3 143 Sisters of the Dreadful LAME 144 Petty Cash 145 Verizon 146 Daniel's Donuts 147 The Daily Planet 348 Man Ww Cucina De 149 BP.AMOCO 150 AMEX 151 Mildar Brother Trucking 152 Rodrigo Rapid Transit 153 Philoh 154 Pace 155 R. Weinstein 156 Frank's Yankee Parapherna 157 Von Wines 154 Scrooge Nation 159 LN, CPA 160 NVS Income Tax 161 Window Cleaning 1,080.00 7.700.00 462.00 1.109.00 542100 S150 09 43600 9518 OS 3 183 0 23100 1454 105754 1.39554 1,70154 44.45 3,127.00 5.03 1.350.00 46334 3.650.00 550.00 725.00 65.00 2 3 10 11 15 18 11 22 30 1.620.00 3,726.00 2.703.00 1140 5,356.00 4.00 1344.00 3900 135.60 $141 335216 24 25 26 27 28 29 30 Ow 22 22 24 24 27 29 29 10 book 31- M30 32 33 251.00 32.5295 Toul Checks tuned 35 36 37 38 39 40 Gedung us 92 122 124 120 129 10 131 132 131 99.00 15100 14.00 38.00 33700 Bened up the information provided 43 44 45 45 47 A Abongo for the month Apr 02000 merons, we made by the company 11001 12 30 357.00 50 SO 130 B. The necessary to 49 SO 51 52 53 checks did went on Distro 31 Mar 20 59 56 57 58 59 60 + Problem 14 Problem 3 Problem Problem 2 Sna Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, NY 11717 Tammy Tortellini LE Bdt 52 Rest Stop Commack, New York 11758 Period Opering Period Closing 31-Mar-20 30- A20 31-Mar-20 $12.375 12 Online Balance of Depouts and other credits Apr 1 2 $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 437400 1.944.00 3,790 80 2.235.60 9 10 $29,13710 Total deposits and other credits Checks and other debits M 85 122 124 128 129 130 132 check checks check check check check check Check check checke check check check check check check 251.00 99 60 153.00 224.00 998.00 337.00 1,100 25 941.17 52120 357.00 65.50 1,080.00 7.700.00 462.00 1,309.00 5.621.00 check check check check check check checke checka check Check check check check check check check 142 144 145 146 147 148 149 150 151 152 153 154 156 157 158 159 $15.90 463.00 953.60 9538 183.80 231.00 394 54 1.087.54 1.395.54 1.703.54 42445 3,127.00 1,350.00 46334 2,650.00 550.00 134 135 136 137 139 140 141 Bectronic Funds Transfer payment on account Monthly service charge Dr. Kaverican Health Management insurance NSicheck(deposite check returned for insufficient funds) 1,301.00 39.75 1,122 1419.12 40,693.50 Total checks and other deb 11.12 Closing Date 30-Apr-20 WT. We transfer collection on went) Happy Spring HE E Problem Cash Paynents Journe Michecia are payments on account April 2020 CASH RECENTS JOURNAL April 2020 RATE CHIK PAYLE Amount Note: All cash recept we collections on ACCOUNT AMOUNT 1 2 3 4 4 7 7 9 9 13 13 15 16 19 20 21 21 137 CashGrabber Realty 138 Makgood key Corp 129 Natamicola's Commissary 140 Jula's Supplies Ames 141 Columbia Coffee Co 142 B's Beans 143 Sisters of the Dreadful LAMS 144 Petty Cash 145 Verion 146 Daniele's Donuts 147 The Daily Planet-key 148 Man Wa's Cuecina De Casa 149 BP-AMOCO 150 AMDX 151 Maldarell Brothers Trucking 152 Rodrigues Rapid Trans 153 Philo Ketch 154 1. Pace 155 R. Weinstein 156 Frank Yankee Parapher 157 Verizon Wireless 158 Scrooge National Bank 159 L.Nguyen.CPA 160 NS income Tax 161 Sony Window Cleaning 1,080.00 7,700.00 462.00 1,309.00 5,621.00 515 90 0.99 435.00 953.80 95.38 183.80 23100 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 $5.00 DATE April 1 2 8 10 11 15 18 21 22 30 1,520.00 3,726.00 2,719.00 1,814.40 6,156.00 4374.00 1.944.00 3,790.80 2.235.60 5,141.88 33521.65 22 22 Other Information 24 27 20 29 30 Book Balance 31-Mar-20 ERER Total Checa Disbursed 32,529 RS Instructions: Based upon information provided prepare Check Outstanding Marutat 85 251.00 92 122.11 122 99.60 124 153.00 128 224.00 129 9.00 110 33700 111 64235 132 1 100 25 133 94117 134 52110 135 357.00 136 65.50 5.8120 25 SU A Action for the month ended Apr,2030 wany, we made by the company 3. The newryum ante to then 49 50 5 52 D 31-0 STO Problem 1 Problem Probleme Problem 4 Ready U w Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, NY 11217 Tammy Torten UE52 Rest Stop Commack, New York 11768 Period Opening Purid Closing 11.Mar. 20 30-Apr-20 Opening Barce 31-Mar-20 $1237512 Deposits and other credits April 1 3 9 10 5527.00 1.620.00 3,726.00 2.791 00 15850 WT 12 16 19 22 23 1.214.40 6,156.00 4,37400 1,9444.00 3.790.00 2.235.50 Total deposits and other crediti $2913730 Checks and other debit 251.00 chat checko checke 85 122 124 99.00 142 144 145 146 cha check chacko check check check 129 130 112 133 114 153.00 224.00 99DO 337.00 1.10025 94112 52120 35700 6550 1,000.00 7.300 DO 45200 1.109 DD 5.621.00 Check check check check che che check chack Check Check 141 149 150 151 152 153 154 156 157 $15.90 463.00 95380 95.38 30 23100 19454 1,08754 1.191.54 1.7035 42445 1127.00 1 350.00 46334 2.450.00 550.00 130 137 Check check check checke Check Check 139 140 141 check tham 159 130100 Ben Funds Tronto con Moyen Or Kenneth Magnetic 1133 Problem #4 Cash Payments Journal all checks are payments on account April 2020 DATE CHK PAYEE Amount 1 2 3 4 4 7 7 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 Natamicola'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 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 $50.00 725,00 65.00 Total Checks Disbursed 32.529.85 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 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 941.17 521.20 135 357.00 136 5,812.70 65 50 Deposit In Transit 31-Mar-20 $527.00 Problem 54 continued Scrooge National Bank 666 Crooked Hill Road Brentwood, NY 11717 Tammy Tortellini LIE Exit 2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opening Bilance as of 31-Mar-20 $12.375.12 Deposits and other credits: April 1 2 3 9 10 S$27.00 1.620 3.726 2.791 138.5 WT 11 12 16 19 22 23 1,814.4 6.156 4.374 1.944 3.790.8 2.235,6 Total deposits and other credits S29,137.30 Checks and other debits 142 144 145 146 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 148 149 150 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 3.621.00 check check check # check check # check # check check check check check check check check check check # SI5.90 463.00 953.80 95 38 183.80 231.00 394.54 1,08754 1.395.54 1.703.54 424.45 3,127.00 1,350.00 463 34 2.650.00 550.00 151 152 153 154 156 157 158 159 141 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,693.30 Closing balance as of 30-Apr-20 5819.12 WT-Wire transfer (collection on account) Happy Spring AutoSave OFF BESUS Draw Page Layout Home Insert Formulas Data Review View Tell me G49 C Problem Cash Payment wiches repayments on Apr 2000 CASH RECETSJOURNAL Apr 2000 DATE CH PAYLE Note ALL the 1 2 3 4 12 15 ACCOUNT AMOUNT DAT Aure 16 17 10 20 21 22 2 7 9 9 13 13 15 16 19 20 21 137 Cabber 138 Med Kay Core 139 Nico's Com 140 Jula's Supplies Amenities 141 Columbia Coco 14. Bi 3 143 Sisters of the Dreadful LAME 144 Petty Cash 145 Verizon 146 Daniel's Donuts 147 The Daily Planet 348 Man Ww Cucina De 149 BP.AMOCO 150 AMEX 151 Mildar Brother Trucking 152 Rodrigo Rapid Transit 153 Philoh 154 Pace 155 R. Weinstein 156 Frank's Yankee Parapherna 157 Von Wines 154 Scrooge Nation 159 LN, CPA 160 NVS Income Tax 161 Window Cleaning 1,080.00 7.700.00 462.00 1.109.00 542100 S150 09 43600 9518 OS 3 183 0 23100 1454 105754 1.39554 1,70154 44.45 3,127.00 5.03 1.350.00 46334 3.650.00 550.00 725.00 65.00 2 3 10 11 15 18 11 22 30 1.620.00 3,726.00 2.703.00 1140 5,356.00 4.00 1344.00 3900 135.60 $141 335216 24 25 26 27 28 29 30 Ow 22 22 24 24 27 29 29 10 book 31- M30 32 33 251.00 32.5295 Toul Checks tuned 35 36 37 38 39 40 Gedung us 92 122 124 120 129 10 131 132 131 99.00 15100 14.00 38.00 33700 Bened up the information provided 43 44 45 45 47 A Abongo for the month Apr 02000 merons, we made by the company 11001 12 30 357.00 50 SO 130 B. The necessary to 49 SO 51 52 53 checks did went on Distro 31 Mar 20 59 56 57 58 59 60 + Problem 14 Problem 3 Problem Problem 2 Sna Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, NY 11717 Tammy Tortellini LE Bdt 52 Rest Stop Commack, New York 11758 Period Opering Period Closing 31-Mar-20 30- A20 31-Mar-20 $12.375 12 Online Balance of Depouts and other credits Apr 1 2 $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 437400 1.944.00 3,790 80 2.235.60 9 10 $29,13710 Total deposits and other credits Checks and other debits M 85 122 124 128 129 130 132 check checks check check check check check Check check checke check check check check check check 251.00 99 60 153.00 224.00 998.00 337.00 1,100 25 941.17 52120 357.00 65.50 1,080.00 7.700.00 462.00 1,309.00 5.621.00 check check check check check check checke checka check Check check check check check check check 142 144 145 146 147 148 149 150 151 152 153 154 156 157 158 159 $15.90 463.00 953.60 9538 183.80 231.00 394 54 1.087.54 1.395.54 1.703.54 42445 3,127.00 1,350.00 46334 2,650.00 550.00 134 135 136 137 139 140 141 Bectronic Funds Transfer payment on account Monthly service charge Dr. Kaverican Health Management insurance NSicheck(deposite check returned for insufficient funds) 1,301.00 39.75 1,122 1419.12 40,693.50 Total checks and other deb 11.12 Closing Date 30-Apr-20 WT. We transfer collection on went) Happy Spring HE E