AB C E F M Bobby Wino's Wingnuts & Bolts 2 3 4 5 Cash Payments Journal Cash receipts Journal February 2021 6 7 8 Note: All cash receipts are collections on account Date Feb 1 1 1 2 2 2 4 4 4 #211.30 DATE AMOUNT 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 4 5 Note: Assume all cash payments are on account Chko Payee Amount 1301 Grablander Realty 2,200.00 1302 Makagood Inc. 1,310.00 1303 PAL Electronics 78.60 1304 Staples 1305 Wino Bolts 5,541.30 1306 Yankee Trader 87.77 1307 Scrooge National Bank 1,035.44 1308 JBP Enterprises 2,199.23 1309 Verizon Wireless 162.27 1310 Merchandising Assoc 119.21 1311 The Daily Planet 80.00 1312 Luigi's Chinese Restaurant 79.28 1313 BP Amoco 90.40 1314 American Express 91.70 1315 Viking Office Products 735.03 1316 Postmaster 170.30 1317 Sisters of the Pitiful LAMS 1.25 1318 J. Pace 3,125.00 1319 R. Weinstein 5.75 1320 RJ Dipnurd 85.00 1321 Verizon Wireless 55.00 1322 Scrooge National Bank 2,450.00 1323 Kal Kewlator 475.00 5 5 1-Feb 2-Feb 3-Feb 7-Feb 8-Feb 9-Feb 14-Feb 20-Feb 22-Feb 26-Feb 28-Feb 1,350.00 3,105.00 2,295.00 1,512.00 1,217.00 5,130.00 3,645.00 1,620.00 3,159.00 1,863.00 4,284.90 5 5 8 8 8 12 29,180.90 27 28 29 30 12 12 12 14 AB G | M N Other Information 31 32 33 14 14 14 14 Book Balance January 31st........ 12,378.79 14 34 35 36 37 Checks Outstanding January 31st 14 17 17 18 18 19 19 38 19 10 1 2 3 4 5 6 7 8 C D E F 1324 NYS Income Tax 1325 Commack Florist 1326 CAN Insurance Co. 1327 Sister of the Hopeless 1328 Costco 1329 UPS 1330 LI Laundry 1331 Philo Kvetch 1332 Good Hands Insurance 1333 POSTMASTER 1334 Exxon Mobil 1335 Verizon FIOS 1336 Federal Express 1337 Suffolk Co. Water Authority 1338 PSE&G 1339 Gregory Ltd 1340 Squeegee Window Service 1341 Suffolk County Clerk 1342 UPS 1343 ). Pace 1344 R. Weinstein 1345 RJ Dipnurd 1346 Barbed Wire Security Corp. 1347 Caitlyn Corp. 1348 Planet Removal Service 19 19 20 21 650.00 150.00 50.00 300.00 168.00 68.00 76.00 232.00 224.00 58.00 + 61.44 156.00 176.40 76.80 338.40 2,694.24 36.00 80.00 265.68 3,125.00 5.75 167.93 55.00 2,809.20 189.00 1225 1239 1269 1277 1283 1288 1289 1295 1296 1297 1298 1299 1300 58.12 123.00 172.00 210.00 3,367.80 76.80 37.00 100.00 3,321.00 3,511.50 210.00 300.00 429.87 22 22 25 25 28 2 28 11,917.09 28 28 Deposit In Transit January 31st.... 28 $4,771.00 Total Checks Disbursed 32,601.67 R S T U w Scrooge National Bank 666 Callfornia Avenue Hempstead, N.Y. 11755 Bobby Wino's Wingnuts & Bolts Exit 52 Rest Stop Long Island Expressway Commack, New York 11788 Period Opening 01-31-21 Period Closing 02-28-21 Opening Balance as of January 31, 2021. $22,990.88 Deposits and other credits: February 1 2 3 4,771.00 1,350.00 3,105.00 2,295.00 1,512.00 1,217.00 10 12 15 21 23 27 5,130.00 53.80 BCR 3,645.00 1,602.00 3,159.00 1,863.00 4 8 9 Total deposits and other credits. $29,702.80 Checks and other debits: check check check check 1239 1277 1283 1288 123.00 210.00 3,367.80 76.80 check check check check 1309 1310 1311 1312 162.27 119.21 80.00 79.28 check check check check 1329 1330 1331 1332 68.00 76.00 232.00 224.00 Q R S U V W X check check check check check check check check check check check check check 1289 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 37.00 3,321.00 3,511.50 210.00 300.00 429.87 2,200.00 1,310.00 78.60 211.30 5,541.30 87.77 1,035.44 check check check check check check check check check check check check check 1313 1314 1315 1317 1318 1320 1321 1322 1323 1324 1325 1326 1327 90.40 91.70 735.03 1.25 3,125.00 85.00 55.00 2,450.00 475.00 650.00 150.00 50.00 300.00 check check check check check check check check check check check check check 1334 1335 1336 1337 1339 1340 1341 1342 1343 1344 1345 1346 1347 61.44 156.00 176.40 76.80 2,694.24 36.00 80.00 265.68 3,152.00 5.75 167.93 55.00 2,809.20 Monthly service charge A/D Kevorkian HMO loan payment (no interest) Totat checks and other debits... 57.82 1,875.00 5000.00 48,019.78 Closing balance as of February 28, 2021. $4,673.90 BCR = Bank charge reversal Total Checks Disbursed 32,601.67 Instructions: a Prepare a bank reconciliation for the month ended Feb. 28, 2021 b Prepare the necessary Journal entries relative to the bank reconciliation -2 AB C E F M Bobby Wino's Wingnuts & Bolts 2 3 4 5 Cash Payments Journal Cash receipts Journal February 2021 6 7 8 Note: All cash receipts are collections on account Date Feb 1 1 1 2 2 2 4 4 4 #211.30 DATE AMOUNT 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 4 5 Note: Assume all cash payments are on account Chko Payee Amount 1301 Grablander Realty 2,200.00 1302 Makagood Inc. 1,310.00 1303 PAL Electronics 78.60 1304 Staples 1305 Wino Bolts 5,541.30 1306 Yankee Trader 87.77 1307 Scrooge National Bank 1,035.44 1308 JBP Enterprises 2,199.23 1309 Verizon Wireless 162.27 1310 Merchandising Assoc 119.21 1311 The Daily Planet 80.00 1312 Luigi's Chinese Restaurant 79.28 1313 BP Amoco 90.40 1314 American Express 91.70 1315 Viking Office Products 735.03 1316 Postmaster 170.30 1317 Sisters of the Pitiful LAMS 1.25 1318 J. Pace 3,125.00 1319 R. Weinstein 5.75 1320 RJ Dipnurd 85.00 1321 Verizon Wireless 55.00 1322 Scrooge National Bank 2,450.00 1323 Kal Kewlator 475.00 5 5 1-Feb 2-Feb 3-Feb 7-Feb 8-Feb 9-Feb 14-Feb 20-Feb 22-Feb 26-Feb 28-Feb 1,350.00 3,105.00 2,295.00 1,512.00 1,217.00 5,130.00 3,645.00 1,620.00 3,159.00 1,863.00 4,284.90 5 5 8 8 8 12 29,180.90 27 28 29 30 12 12 12 14 AB G | M N Other Information 31 32 33 14 14 14 14 Book Balance January 31st........ 12,378.79 14 34 35 36 37 Checks Outstanding January 31st 14 17 17 18 18 19 19 38 19 10 1 2 3 4 5 6 7 8 C D E F 1324 NYS Income Tax 1325 Commack Florist 1326 CAN Insurance Co. 1327 Sister of the Hopeless 1328 Costco 1329 UPS 1330 LI Laundry 1331 Philo Kvetch 1332 Good Hands Insurance 1333 POSTMASTER 1334 Exxon Mobil 1335 Verizon FIOS 1336 Federal Express 1337 Suffolk Co. Water Authority 1338 PSE&G 1339 Gregory Ltd 1340 Squeegee Window Service 1341 Suffolk County Clerk 1342 UPS 1343 ). Pace 1344 R. Weinstein 1345 RJ Dipnurd 1346 Barbed Wire Security Corp. 1347 Caitlyn Corp. 1348 Planet Removal Service 19 19 20 21 650.00 150.00 50.00 300.00 168.00 68.00 76.00 232.00 224.00 58.00 + 61.44 156.00 176.40 76.80 338.40 2,694.24 36.00 80.00 265.68 3,125.00 5.75 167.93 55.00 2,809.20 189.00 1225 1239 1269 1277 1283 1288 1289 1295 1296 1297 1298 1299 1300 58.12 123.00 172.00 210.00 3,367.80 76.80 37.00 100.00 3,321.00 3,511.50 210.00 300.00 429.87 22 22 25 25 28 2 28 11,917.09 28 28 Deposit In Transit January 31st.... 28 $4,771.00 Total Checks Disbursed 32,601.67 R S T U w Scrooge National Bank 666 Callfornia Avenue Hempstead, N.Y. 11755 Bobby Wino's Wingnuts & Bolts Exit 52 Rest Stop Long Island Expressway Commack, New York 11788 Period Opening 01-31-21 Period Closing 02-28-21 Opening Balance as of January 31, 2021. $22,990.88 Deposits and other credits: February 1 2 3 4,771.00 1,350.00 3,105.00 2,295.00 1,512.00 1,217.00 10 12 15 21 23 27 5,130.00 53.80 BCR 3,645.00 1,602.00 3,159.00 1,863.00 4 8 9 Total deposits and other credits. $29,702.80 Checks and other debits: check check check check 1239 1277 1283 1288 123.00 210.00 3,367.80 76.80 check check check check 1309 1310 1311 1312 162.27 119.21 80.00 79.28 check check check check 1329 1330 1331 1332 68.00 76.00 232.00 224.00 Q R S U V W X check check check check check check check check check check check check check 1289 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 37.00 3,321.00 3,511.50 210.00 300.00 429.87 2,200.00 1,310.00 78.60 211.30 5,541.30 87.77 1,035.44 check check check check check check check check check check check check check 1313 1314 1315 1317 1318 1320 1321 1322 1323 1324 1325 1326 1327 90.40 91.70 735.03 1.25 3,125.00 85.00 55.00 2,450.00 475.00 650.00 150.00 50.00 300.00 check check check check check check check check check check check check check 1334 1335 1336 1337 1339 1340 1341 1342 1343 1344 1345 1346 1347 61.44 156.00 176.40 76.80 2,694.24 36.00 80.00 265.68 3,152.00 5.75 167.93 55.00 2,809.20 Monthly service charge A/D Kevorkian HMO loan payment (no interest) Totat checks and other debits... 57.82 1,875.00 5000.00 48,019.78 Closing balance as of February 28, 2021. $4,673.90 BCR = Bank charge reversal Total Checks Disbursed 32,601.67 Instructions: a Prepare a bank reconciliation for the month ended Feb. 28, 2021 b Prepare the necessary Journal entries relative to the bank reconciliation -2