based upon the information provided prepare:
a. a bank reconcillation for the minth ended april 30, 2020 ( assume errors, is any, are made by the company)
b. the necessary journal entries relative to the roconcillation
( all checks disbursed are payments on account)
Note : there is a number missing, but here it is
Book Balance
31-Mar-20 ---------------------> 7, 089.42
3:097 CA#2 XLSX - 70 KB Pro Cash Payments Journal wildheks are payments on account April 2020 CASH RECE AL DATE C Am 1 7.700.00 46.00 1,300.00 NatuALLE recole on ACC 1 4 . 7 7 DATE Apel 3130 09 16 ---- 10 PAYEE The Real 138 Mid Key Corp 199 Nami 1:40 Supplies Anne 141 Column 14. Billy's 143 Ster's of the threaded LAM 144 Patty Cush 145 W 145 Duo 147 The Daily Makey IM W CINC 149 OP-AMOCO 150 AMEX 151 Modellen Tringle 152 Radgrapid Trail 15 Mule 154 . 159 kW 156 Frank Yankee Paraphemalia 157 Via Wireless 15% Scrooge National lank 199 L.Nguyen, CPA 140 NYS Income 101 Squee Window 13 11 15 16 19 30 21 21 3x INO 23100 394 1074 1.7914 1,70 43445 3,127.00 18 18 21 23 24 27 1,350.00 4611 2.410.00 350.00 725.00 toliau 31-Mar-2 10 Check ou Total Checks Dunod 32.529.5 Instructions: Based upon the information provided prepare A. A bank reconciliation for the month ended April 30, 2020 me error. Iany, are made by me company The necessary journal entries relative to the reconciation (all check disbursed we payments on con DIT 11-Mar-20 Open Office 3 Problem Cash Payments Journal all checks are payments on account April 2020 CASH RECEIPTS JOURNAL April 2000 DATE CHK PAYLE Amount Note: ALL cash receipts we collections on ACCOUNT DATE AMOUNT April 1 2 3 4 4 7 7 9 9 13 13 15 16 137 CashGrabber Realty 138 Makagood key Corp. 139 Natanicola's Commissary 140 Julia's Supplies & Amenities 141 Columbian Coffee Co 142 dy'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 Cuocina De Casa 149 BP-AMOCO 150 AMEX 151 Maldarell Brothers Trucking Inc. 152 Rodriguez Rapid Transit 153 Philo Kvetch 154 3. Pace 155 R. Weinstein 156 Frank's Yankee Paraphernalis 157 Vervon Wireless 158 Scrooge National Bank 159 L Nguyen, CPA 160 NYS Income Tax 161 Squee Window Cleaning 1,080.00 7,700.00 462.00 1.109.00 5,621.00 $15.90 0.99 436.00 953 80 95.38 183.80 231.00 994.54 1,08754 1.395.54 1,703.54 424 45 3.127.00 5.03 1,350.00 46334 2,650.00 550.00 725.00 65.00 1 2 8 10 11 15 18 21 22 30 1,620.00 3,726.00 2,719.00 1.81440 6.15600 437400 1,94400 3,790.80 2,235.50 5,141.88 3352168 20 21 21 22 22 24 24 22 Other Information Book Balance 31.Mw: 20 RERI 29 30 Total Checks Disbursed 32.529.85 Chacha Qading March 85 22 122 124 128 129 130 111 132 13) 134 135 251.00 12213 99.50 153.00 224.00 098.00 337.00 Instructions ed upon the information provided prepare 1.100 25 A. A bank recondition for the month anded Apr 30, 2000 umerer, Wany, we made by the company 521.30 357.00 65.50 01110 3. The necessary joumal entries relative to the reconciliation (all checks disbursed we payments on count) Deposit 31 Mw30 Problem 21 Problem 2 Problem 3 Problem 4 Ready Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, N.Y. 11717 Tammy Tortellini LIEB S2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opering Balance as of 31-Mar-20 $12375.12 Deposits and other credits: April 1 2 3 9 10 5527.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.00 2,235.60 Total deposits and other credits $29,137:30 Checks and other debits check Check check checke 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 33700 1,100,25 941.17 521,20 357.00 65 50 1,000.00 7.700.00 462.00 1,309.00 5,621.00 check check check check check check check check check checka 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.80 95.38 183.80 231.00 39454 1,087.54 1,395 54 1,703 54 424.45 3.127.00 1,350.00 463 34 2,650.00 S5000 Bectronic Funds Transfer payment on account Monthly service charge Dr. Kevorkian Health Management Insurance Schack deposit check returned for insufficient funda] 1.10300 39.75 1122 1419 12 Total checks and other debit Clong and 30. APRO WT. wire trenere on wou Hapnya Cash Payments acheca are payments on con April 2020 CASH RECEPTS JOURNAL Apot 2826 DATE CH PAYEE Amount 10 Not All recepts wolone ACCOUNT 12 13 AMOUNT DATE Aprit 1 2 1 2 3 4 4 7 2 9 9 11 13 15 16 19 20 21 15 16 17 13 19 20 21 22 23 24 25 26 27 10 127 Cabbert 136 Masood Rey Corp 139 Natanicola's Commissary 140 Supplies & Amen 141 Columbia Colle 142 aytas 143 Sisters of the DLAMS 144 Petty Cash 145 Vento 145 Dan Don 147 The Day Planet Bey 145 Man Wa's Cocina De C 140 POCO 150 AMEX 151 Moldal Brothers Trucking 152 Rodrigo 153 Phoven 154 LP 155 Westen 156 Frank Yanke arahmala 157 Vero Www 156 Scrooge Nation 159 Nyn, CPA 150 income Tax 161 y Window Clering 10 DO 7.70000 462.00 1,309.00 5,621.00 515 90 0.99 43500 95110 15.30 11 30 231.00 39454 1.06754 139554 1,703:54 43445 312700 5.03 1350.00 46334 2.650.00 S50.00 775.00 65.00 11 15 IN 21 22 30 1.520.00 26.00 2,719.00 181440 6,136.00 37400 1900 3.790 35. 5,141. 33,52148 22 22 29 30 31 Other info 24 27 25 29 30 Book Bante 31- M20 12 Total Checks libed 3252935 COM 35 32 123 124 25100 12.13 9. 353.00 33400 990.00 33700 129 the Bepanthenon provided A Actor month ended wowy by the con 132 13 114 115 13 130025 1.17 210 35700 5.30 SO They are inte theon D 30 Problem Probleme Problems Problem 4 Ready 400 esc Share Proced Scrogation and 66 Crooked Brentwood, NY 11 Period Wong 31 Mar 30-Apr-20 LEER Stop Cormack, New York 1176 31. Mar 20 $12.17 Depoh and others Art $52700 1.620.00 3,726.00 2.291.00 158SO WT 1! 12 16 19 22 23 181440 G15600 4174.00 1.00 3.190.00 223560 10 $23,13730 Total points and other credits Checks and other debits checke Check 251.00 60 15.00 22400 99800 33700 1.100 25 941.17 14 144 145 146 147 148 10 check check check chack chake hacka check ch char 515 90 13.00 9580 95. 1 23100 122 124 128 129 13 132 135 134 135 136 137 check check check 5220 10754 1,395.54 1.90354 hacko check check cher checke check. Check check check 151 112 153 154 156 35700 65 50 1,08000 7,300.00 42.00 1.100.00 5621.00 17.00 1.350.00 46334 50 DO 550.00 check check char 139 100 141 158 150 + Electronic Funds Transfer payment on account Moviechan Dr. KH Magent check-depecheck med for insufficient funda] Tot check the 1.10300 39.75 1,122 1418.13 0,30 WT. where Hapay Big 3:097 CA#2 XLSX - 70 KB Pro Cash Payments Journal wildheks are payments on account April 2020 CASH RECE AL DATE C Am 1 7.700.00 46.00 1,300.00 NatuALLE recole on ACC 1 4 . 7 7 DATE Apel 3130 09 16 ---- 10 PAYEE The Real 138 Mid Key Corp 199 Nami 1:40 Supplies Anne 141 Column 14. Billy's 143 Ster's of the threaded LAM 144 Patty Cush 145 W 145 Duo 147 The Daily Makey IM W CINC 149 OP-AMOCO 150 AMEX 151 Modellen Tringle 152 Radgrapid Trail 15 Mule 154 . 159 kW 156 Frank Yankee Paraphemalia 157 Via Wireless 15% Scrooge National lank 199 L.Nguyen, CPA 140 NYS Income 101 Squee Window 13 11 15 16 19 30 21 21 3x INO 23100 394 1074 1.7914 1,70 43445 3,127.00 18 18 21 23 24 27 1,350.00 4611 2.410.00 350.00 725.00 toliau 31-Mar-2 10 Check ou Total Checks Dunod 32.529.5 Instructions: Based upon the information provided prepare A. A bank reconciliation for the month ended April 30, 2020 me error. Iany, are made by me company The necessary journal entries relative to the reconciation (all check disbursed we payments on con DIT 11-Mar-20 Open Office 3 Problem Cash Payments Journal all checks are payments on account April 2020 CASH RECEIPTS JOURNAL April 2000 DATE CHK PAYLE Amount Note: ALL cash receipts we collections on ACCOUNT DATE AMOUNT April 1 2 3 4 4 7 7 9 9 13 13 15 16 137 CashGrabber Realty 138 Makagood key Corp. 139 Natanicola's Commissary 140 Julia's Supplies & Amenities 141 Columbian Coffee Co 142 dy'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 Cuocina De Casa 149 BP-AMOCO 150 AMEX 151 Maldarell Brothers Trucking Inc. 152 Rodriguez Rapid Transit 153 Philo Kvetch 154 3. Pace 155 R. Weinstein 156 Frank's Yankee Paraphernalis 157 Vervon Wireless 158 Scrooge National Bank 159 L Nguyen, CPA 160 NYS Income Tax 161 Squee Window Cleaning 1,080.00 7,700.00 462.00 1.109.00 5,621.00 $15.90 0.99 436.00 953 80 95.38 183.80 231.00 994.54 1,08754 1.395.54 1,703.54 424 45 3.127.00 5.03 1,350.00 46334 2,650.00 550.00 725.00 65.00 1 2 8 10 11 15 18 21 22 30 1,620.00 3,726.00 2,719.00 1.81440 6.15600 437400 1,94400 3,790.80 2,235.50 5,141.88 3352168 20 21 21 22 22 24 24 22 Other Information Book Balance 31.Mw: 20 RERI 29 30 Total Checks Disbursed 32.529.85 Chacha Qading March 85 22 122 124 128 129 130 111 132 13) 134 135 251.00 12213 99.50 153.00 224.00 098.00 337.00 Instructions ed upon the information provided prepare 1.100 25 A. A bank recondition for the month anded Apr 30, 2000 umerer, Wany, we made by the company 521.30 357.00 65.50 01110 3. The necessary joumal entries relative to the reconciliation (all checks disbursed we payments on count) Deposit 31 Mw30 Problem 21 Problem 2 Problem 3 Problem 4 Ready Problem continued Scrooge National Bank 666 Crooked His Road Brentwood, N.Y. 11717 Tammy Tortellini LIEB S2 Rest Stop Commack, New York 11768 Period Opening Period Closing 31-Mar-20 30-Apr-20 Opering Balance as of 31-Mar-20 $12375.12 Deposits and other credits: April 1 2 3 9 10 5527.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.00 2,235.60 Total deposits and other credits $29,137:30 Checks and other debits check Check check checke 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 33700 1,100,25 941.17 521,20 357.00 65 50 1,000.00 7.700.00 462.00 1,309.00 5,621.00 check check check check check check check check check checka 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.80 95.38 183.80 231.00 39454 1,087.54 1,395 54 1,703 54 424.45 3.127.00 1,350.00 463 34 2,650.00 S5000 Bectronic Funds Transfer payment on account Monthly service charge Dr. Kevorkian Health Management Insurance Schack deposit check returned for insufficient funda] 1.10300 39.75 1122 1419 12 Total checks and other debit Clong and 30. APRO WT. wire trenere on wou Hapnya Cash Payments acheca are payments on con April 2020 CASH RECEPTS JOURNAL Apot 2826 DATE CH PAYEE Amount 10 Not All recepts wolone ACCOUNT 12 13 AMOUNT DATE Aprit 1 2 1 2 3 4 4 7 2 9 9 11 13 15 16 19 20 21 15 16 17 13 19 20 21 22 23 24 25 26 27 10 127 Cabbert 136 Masood Rey Corp 139 Natanicola's Commissary 140 Supplies & Amen 141 Columbia Colle 142 aytas 143 Sisters of the DLAMS 144 Petty Cash 145 Vento 145 Dan Don 147 The Day Planet Bey 145 Man Wa's Cocina De C 140 POCO 150 AMEX 151 Moldal Brothers Trucking 152 Rodrigo 153 Phoven 154 LP 155 Westen 156 Frank Yanke arahmala 157 Vero Www 156 Scrooge Nation 159 Nyn, CPA 150 income Tax 161 y Window Clering 10 DO 7.70000 462.00 1,309.00 5,621.00 515 90 0.99 43500 95110 15.30 11 30 231.00 39454 1.06754 139554 1,703:54 43445 312700 5.03 1350.00 46334 2.650.00 S50.00 775.00 65.00 11 15 IN 21 22 30 1.520.00 26.00 2,719.00 181440 6,136.00 37400 1900 3.790 35. 5,141. 33,52148 22 22 29 30 31 Other info 24 27 25 29 30 Book Bante 31- M20 12 Total Checks libed 3252935 COM 35 32 123 124 25100 12.13 9. 353.00 33400 990.00 33700 129 the Bepanthenon provided A Actor month ended wowy by the con 132 13 114 115 13 130025 1.17 210 35700 5.30 SO They are inte theon D 30 Problem Probleme Problems Problem 4 Ready 400 esc Share Proced Scrogation and 66 Crooked Brentwood, NY 11 Period Wong 31 Mar 30-Apr-20 LEER Stop Cormack, New York 1176 31. Mar 20 $12.17 Depoh and others Art $52700 1.620.00 3,726.00 2.291.00 158SO WT 1! 12 16 19 22 23 181440 G15600 4174.00 1.00 3.190.00 223560 10 $23,13730 Total points and other credits Checks and other debits checke Check 251.00 60 15.00 22400 99800 33700 1.100 25 941.17 14 144 145 146 147 148 10 check check check chack chake hacka check ch char 515 90 13.00 9580 95. 1 23100 122 124 128 129 13 132 135 134 135 136 137 check check check 5220 10754 1,395.54 1.90354 hacko check check cher checke check. Check check check 151 112 153 154 156 35700 65 50 1,08000 7,300.00 42.00 1.100.00 5621.00 17.00 1.350.00 46334 50 DO 550.00 check check char 139 100 141 158 150 + Electronic Funds Transfer payment on account Moviechan Dr. KH Magent check-depecheck med for insufficient funda] Tot check the 1.10300 39.75 1,122 1418.13 0,30 WT. where Hapay Big
