Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Background: As an owner or a manager of a business, in order to make decisions to either enhance the profitability or take action to reduce
Background: As an owner or a manager of a business, in order to make decisions to either enhance the profitability or take action to reduce losses, one needs timely summary of important financial data from the business' day to day operations. This information can be presented in various formats. However, it should convey information accurately, present patterns or trends, be easy to read, incorporate use of colors so it is visually appealing and be summarized on one page. One way to present this information is through a data dashboard A data dashboard is an information management tool that visually tracks, analyzes and displays key performance indicators (KPI), metrics and key data points to monitor the health of a business. It displays data in the form of line charts, bar charts and gauges A data dashboard is the most efficient way to track multiple data sources because it provides a central location for businesses to monitor and analyze performance. Real-time monitoring reduces the hours of analyzing and long line of communication that previously challenged businesses Requirements: In this assignment, you will be given three tables of data for a restaurant business that is currently operating in Alberta. For businesses in the food industry, key performance indicators are managing the following costs: Food and Labor. Target Rates: Food costs usually represent 32% of sales and labor represents 30% of sales. Ma Your clients, Norm and Karen are seeking your assistance in designing a dashboard for their business. With the help of their accountant, they have obtained some transactional data. It consists of the following: 1 Food & Beverage Purchases 2 Sales 3 Labor Norm and Karen are seeking your assistance in two ways: Part A Using the data provided, they want you to design a dash board in EXCEL to: 1 Provide a monthly sales trend from Jan to Dec for 2020 (Food, Beverage and Merchandise sales can be combined) 2 Calculate the food & beverage purchases on a monthly basis as a percentage of sales. Compare the percentage against the target of 32% of sales, month by month. (Inventory - Food & Paper Products and Beverages can be combined) 3 Calculate labor costs on a monthly basis against the monthly sales. Compare the percentage against the target of 30% of sales, month by month. (Total labor costs include: Wages & Salaries, Vacation Expense, El Expense, CPP Expense) 4 Based on your analysis of their business for 2020, what recommendations would you make to them? Part B Using your experience from Part A, they want you to design a dashboard template for future use in EXCEL so that when they input totals where required, the dashboard would instantly produce the following: 1 A month by month indication of how sales are progressing during any financial year and a Year to Date total against a budget target they want to start implementing. 2 A month by month indication of food & beverage costs as a percentage of sales against the target rate and a Year to Date total against the target rate. 3 A month by month indication of labor costs as a percentage of sales against the target rate and a Year to Date total against the target rate. 4 The dash board should have the target rates for food & beverage and labor costs indicated independently so that when they change, the entire dashboard can be updated instantly. 5 Organization of the dashboard including proper titles, appropriate visuals, use of color, design & usefulness TOTAL 6 Balance Transactions by Account Report 01/01/2020 to 12/31/2020 Date Trans. No. . Debits Credits 1520 Inventory - Food & paper Products 01-01-2020 J673 3250.00 0.00 01-08-2020 J17 1137.36 0.00 Dr 3250.00 Dr 4387.36 Dr 01-13-2020 J126 192.52 0.00 Dr 4579.88 5623.84 01-15-2020 J15 1043.96 0.00 Dr 01-15-2020 J16 1347.32 0.00 6971.16 Dr L01-22-2020 J14 1383.28 0.00 8354.44 Dr J45 920.20 0.00 9274.64 Dr 01-22-2020 01-29-2020 J43 1141.74 0.00 10416.38 Dr 02-01-2020 J219 1072.71 0.00 11489.09 Dr 02-05-2020 J42 1262.96 0.00 12752.05 Dr 02-05-2020 J44 1172.92 0.00 13924.97 Dr 02-12-2020 J24 154.92 0.00 14079.89 Dr 02-12-2020 J83 1175.44 0.00 15255.33 Dr 02-12-2020 J84 1143.56 0.00 16398.89 Dr 02-12-2020 J85 37.00 0.00 16435.89 Dr 02-19-2020 J86 1381.63 0.00 17817.52 Dr J101 1086.56 0.00 18904.08 Dr 02-19-2020 02-26-2020 J100 1593.09 0.00 20497.17 Dr 02-26-2020 J102 1224.95 0.00 21722. 12 Dr 02-26-2020 J124 247.75 0.00 21969.87 Dr 03-04-2020 J103 1436.54 0.00 23406.41 Dr 03-04-2020 J104 1316.33 0.00 24722.74 Dr 03-11-2020 J105 1512.41 26235.15 Dr 0.00 0.00 03-11-2020 J106 1329.52 27564.67 Dr 03-18-2020 J107 1305. 26 0.00 28869.93 Dr 03-25-2020 J122 2721.60 0.00 31591.53 Dr 04-01-2020 J120 967.29 0.00 32558.82 Dr 04-01-2020 J121 796.62 0.00 33355.44 Dr 04-08-2020 J119 2007.63 0.00 35363.07 Dr 04-14-2020 J125 261.30 0.00 35624.37 Dr 04-15-2020 J118 2871.88 0.00 38496.25 Dr 04-22-2020 J173 2970.13 0.00 41466.38 Dr 04-29-2020 J174 1535.66 0.00 43002.04 Dr 04-29-2020 J278 1535.66 0.00 44537.70 Dr 04-29-2020 J321 3275.40 0.00 47813.10 Dr 05-06-2020 J279 3734.49 0.00 Dr 51547.59 53934.68 05-13-2020 J280 2387.09 0.00 Dr 05-13-2020 J281 2177.80 0.00 56112.48 Dr 05-20-2020 J282 5033.16 0.00 Dr 05-27-2020 J283 3973.26 0.00 61145.64 65118.90 65148.84 Dr 06-01-2020 J394 29.94 0.00 Dr J398 381.99 0.00 65530.83 Dr 06-01-2020 06-03-2020 J284 1703.88 0.00 67234.71 Dr 06-03-2020 J322 1852.86 0.00 69087.57 Dr 06-10-2020 J296 2146.79 0.00 71234.36 Dr 06-10-2020 J299 0.00 73093.69 Dr 1859.33 1511.48 06-17-2020 0.00 74605.17 Dr J297 J298 06-17-2020 1714.97 0.00 76320.14 Dr 06-24-2020 J323 2721.42 0.00 79041.56 Dr 06-25-2020 J326 222.45 0.00 79264.01 Dr 07-01-2020 J324 1739.58 0.00 81003.59 Dr 07-01-2020 J325 1439.11 0.00 82442.70 Dr 07-01-2020 J399 585.63 0.00 83028.33 Dr 07-08-2020 J338 1020.40 0.00 84048.73 Dr 07-08-2020 J339 1445.23 0.00 85493.96 Dr 07-15-2020 J340 1010.67 0.00 86504.63 Dr 07-22-2020 J383 811.37 0.00 87316.00 Dr 07-24-2020 J386 161.54 0.00 87477.54 Dr 07-24-2020 J387 14.94 0.00 87492.48 Dr 07-29-2020 J379 1033.41 0.00 88525.89 Dr 08-05-2020 J390 3031.61 0.00 91557.50 Dr 08-12-2020 J391 1770.95 0.00 93328.45 Dr 08-12-2020 J392 1360.22 0.00 94688.67 Dr 08-15-2020 J512 953.41 0.00 95642.08 Dr 08-19-2020 J412 2923.20 0.00 Dr 08-22-2020 J510 1113, 11 0.00 Dr 08-26-2020 J413 1592.48 Dr 0.00 0.00 98565.28 99678.39 101270.87 101426.47 102966.93 103033.81 08-26-2020 J426 155.60 Dr 08-26-2020 J505 1540.46 0.00 Dr 08-28-2020 J422 66.88 0.00 Dr 08-29-2020 J514 1238.89 0.00 104272.70 Dr 09-02-2020 J421 1636.93 0.00 105909.63 Dr 09-02-2020 J557 1585.50 0.00 107495.13 Dr 09-09-2020 J464 0.00 110773.30 Dr 3278.17 2420.24 09-16-2020 J463 0.00 113193.54 Dr 09-23-2020 J459 1345.65 0.00 114539.19 Dr 09-23-2020 J502 1172.93 0.00 115712.12 Dr 09-24-2020 J501 142.27 0.00 115854.39 Dr 09-30-2020 J458 1192.31 0.00 117046.70 Dr 09-30-2020 J460 1192.15 0.00 Dr 118238.85 116703.19 10-01-2020 J665 0.00 1535.66 Dr 10-01-2020 J665 115167.53 Dr 0.00 0.00 10-01-2020 1535.66 1305.26 1511.48 J665 J665 Dr 113862.27 112350.79 10-01-2020 0.00 Dr 10-01-2020 J665 0.00 1714.97 110635.82 Dr 10-07-2020 J504 2161.80 0.00 112797.62 Dr 10-14-2020 J503 1093.65 0.00 113891.27 Dr 10-14-2020 J592 1524.99 0.00 115416.26 Dr 10-21-2020 J544 1614.48 0.00 117030.74 Dr 10-21-2020 J545 1092.96 0.00 118123.70 Dr 10-25-2020 J558 9.39 0.00 118133.09 Dr 10-28-2020 J546 1171.72 0.00 119304.81 Dr 10-28-2020 J547 1101.23 0.00 120406.04 Dr 11-04-2020 J562 3179.91 0.00 123585.95 Dr 11-04-2020 J564 1322.02 0.00 124907.97 Dr 11-04-2020 J566 0.00 3179.91 121728.06 Dr 11-04-2020 J593 1375. 17 0.00 123103.23 Dr 11-11-2020 J563 2681.12 0.00 125784.35 Dr 11-12-2020 J565 88.31 0.00 125872.66 Dr 11-18-2020 J572 3237.38 0.00 129110.04 Dr 11-25-2020 J595 2458.52 0.00 131568.56 Dr 12-01-2020 J621 1526.67 0.00 133095.23 Dr 12-02-2020 J594 1345.96 0.00 134441.19 Dr 12-08-2020 J615 3608.13 0.00 138049.32 Dr 12-08-2020 J616 3290.26 0.00 141339.58 Dr 12-14-2020 J634 92.94 0.00 141432.52 Dr 12-15-2020 J622 3387.46 0.00 144819.98 Dr 12-22-2020 J654 3130.59 0.00 147950.57 Dr 12-29-2020 J653 0.00 150510.59 Dr 2560.02 0.00 12-31-2020 J668 76.07 Dr 150434.52 153851.18 12-31-2020 J669 3416.66 0.00 Dr 12-31-2020 J669 2916.50 0.00 156767.68 Dr 12-31-2020 J676 2711.85 154055.83 Dr 0.00 0.00 12-31-2020 J676 284.69 153771.14 Dr 12-31-2020 J676 0.00 407.58 153363.56 Dr 12-31-2020 J676 0.00 3958.84 149404.72 Dr 1530 Inventory - Beverages Dr 01-01-2020 J673 645.00 0.00 645.00 Dr J17 111.85 0.00 756.85 Dr 01-08-2020 01-15-2020 J15 42.82 0.00 799.67 Dr 01-15-2020 J16 208.11 0.00 1007.78 Dr J14 100.99 0.00 1108.77 Dr 01-22-2020 01-22-2020 01-29-2020 J45 36.97 0.00 1145.74 Dr J43 87.18 0.00 1232.92 Dr 02-01-2020 J219 14.90 0.00 1247.82 Dr 02-05-2020 J42 61.02 0.00 1308.84 Dr 02-05-2020 J44 14.79 0.00 1323.63 Dr 02-12-2020 J83 14.91 0.00 Dr 1338.54 1394.98 02-12-2020 J84 56.44 0.00 Dr 02-12-2020 J85 49.06 0.00 1444.04 Dr 02-19-2020 J86 125.06 0.00 1569. 10 Dr 02-26-2020 J100 230.94 0.00 1800.04 Dr 02-26-2020 J102 107.37 0.00 1907.41 Dr 03-04-2020 J103 85.66 0.00 1993.07 Dr 03-04-2020 J104 207.39 0.00 2200.46 Dr 03-11-2020 J105 180.47 0.00 2380.93 Dr 03-11-2020 J106 39.32 0.00 2420.25 Dr 03-18-2020 J107 188.93 0.00 2609.18 Dr 03-18-2020 J123 0.00 100.01 2509.17 Dr 03-23-2020 J129 0.00 18.80 2490.37 Dr 03-25-2020 J122 220.21 0.00 2710.58 Dr J121 61.74 0.00 2772.32 Dr 04-01-2020 04-08-2020 04-15-2020 J119 68.40 0.00 2840.72 Dr J118 135.73 0.00 Dr 2976.45 3116.34 04-22-2020 J173 139.89 0.00 Dr 04-29-2020 J174 84.33 0.00 3200.67 Dr 04-29-2020 J278 84.33 0.00 3285.00 Dr 04-29-2020 J321 118.67 0.00 3403.67 Dr 05-06-2020 J279 249.74 0.00 3653.41 Dr J280 78.76 0.00 3732.17 Dr 05-13-2020 05-13-2020 05-20-2020 J281 206.56 0.00 3938.73 Dr J282 246.11 0.00 4184.84 Dr 05-27-2020 J283 375.12 0.00 4559.96 Dr 06-01-2020 J398 12.60 0.00 4572.56 Dr 06-03-2020 J284 97.62 0.00 4670.18 Dr 06-03-2020 J322 46.22 0.00 4716.40 Dr 06-10-2020 J296 137.66 0.00 4854.06 Dr Balance Transactions by Account Report 01/01/2020 to 12/31/2020 Date Trans. No. Debits Credits 06-10-2020 J296 137.66 0.00 06-10-2020 J299 61.13 0.00 4854.06 Dr 4915. 19 Dr 06-17-2020 J297 159.10 0.00 5074.29 Dr 06-17-2020 J298 35.88 0.00 5110.17 Dr 06-24-2020 J323 236.63 0.00 5346.80 Dr 06-25-2020 J326 125.90 0.00 5472.70 Dr 07-01-2020 J324 62.75 0.00 5535.45 Dr 07-01-2020 J325 111.03 0.00 5646.48 Dr 07-01-2020 J399 131.24 0.00 5777.72 Dr 07-08-2020 J339 102. 19 0.00 5879.91 Dr 07-15-2020 J340 38.83 0.00 5918.74 Dr 07-22-2020 J383 99.24 0.00 6017.98 Dr 07-24-2020 J386 130.71 0.00 6148.69 Di 07-29-2020 J379 49.66 0.00 6198.35 Dr 08-05-2020 J390 205.11 0.00 6403.46 Dr 08-12-2020 J391 57.94 0.00 6461.40 Dr 08-12-2020 J392 120.24 0.00 6581.64 Dr 08-15-2020 J512 41.53 0.00 6623.17 Dr 08-19-2020 J412 223.90 0.00 6847.07 Dr 08-22-2020 J510 38.83 0.00 6885.90 Dr 08-26-2020 J413 89.38 0.00 6975.28 Dr 08-26-2020 J426 278.53 0.00 7253.81 Dr 08-26-2020 J505 126.97 0.00 7380.78 Dr 08-28-2020 J422 18.53 0.00 7399.31 Dr 08-29-2020 J514 119.93 0.00 7519.24 Dr 09-02-2020 J421 77.65 0.00 7596.89 Dr 09-02-2020 J557 61.36 0.00 7658.25 Dr 09-09-2020 J464 135.59 0.00 7793.84 Dr 09-16-2020 J463 223.27 0.00 8017.11 Dr 09-23-2020 J459 53.07 0.00 8070.18 Dr 09-23-2020 J502 39.85 0.00 8110.03 Dr 09-24-2020 J501 196.16 0.00 8306.19 Dr 09-30-2020 J458 70.22 0.00 8376.41 Dr 09-30-2020 J460 151.89 0.00 8528.30 Dr J665 0.00 84.33 8443.97 Dr 10-01-2020 10-01-2020 J665 0.00 84.33 8359.64 Dr 10-01-2020 J665 0.00 188.93 8170.71 Dr 10-01-2020 J665 0.00 159.10 8011.61 Dr 10-01-2020 J665 0.00 35.88 7975.73 Dr 10-07-2020 J504 191.14 0.00 8166.87 Dr 10-14-2020 J503 18.09 0.00 8184.96 Dr 10-14-2020 J592 64.88 0.00 8249.84 Dr 10-21-2020 J544 137.82 0.00 8387.66 Dr 10-21-2020 J545 53.94 0.00 8441.60 Dr 10-28-2020 J546 57.94 0.00 8499.54 Dr 10-28-2020 J547 49.08 0.00 8548.62 Dr 11-04-2020 J562 151.72 0.00 8700.34 Dr 11-04-2020 J564 113.47 0.00 8813.81 Dr 11-04-2020 J566 0.00 151.72 8662.09 Dr 11-04-2020 J593 79.94 0.00 8742.03 Dr 11-11-2020 J563 126.32 0.00 8868.35 Dr 11-12-2020 J565 271.37 0.00 9139.72 Dr 11-18-2020 J572 104.24 0.00 9243.96 Dr J665 0.00 188.93 Dr 8170.71 8011.61 J665 0.00 159.10 Dr 10-01-2020 10-01-2020 10-01-2020 10-07-2020 J665 0.00 35.88 7975.73 Dr J504 191.14 0.00 8166.87 Dr 10-14-2020 J503 18.09 0.00 8184.96 Dr 10-14-2020 J592 64.88 0.00 8249.84 Dr 10-21-2020 J544 137.82 0.00 8387.66 Dr 10-21-2020 J545 53.94 0.00 8441.60 Dr 10-28-2020 J546 57.94 0.00 8499.54 Dr 10-28-2020 J547 49.08 0.00 8548.62 Dr 11-04-2020 J562 151.72 0.00 8700.34 Dr 11-04-2020 J564 113.47 0.00 8813.81 Dr 11-04-2020 J566 0.00 151.72 8662.09 Dr J593 79.94 0.00 8742.03 Dr 11-04-2020 11-11-2020 11-12-2020 J563 126.32 0.00 8868.35 Dr J565 271.37 0.00 9139.72 Dr J572 104.24 0.00 9243.96 Dr 11-18-2020 11-25-2020 J595 215.74 0.00 9459.70 Dr 12-01-2020 J621 89.91 9549.61 Dr 0.00 0.00 12-02-2020 J594 177.79 9727.40 Dr 12-08-2020 J615 248.43 0.00 9975.83 Dr 12-08-2020 J616 150.37 0.00 Dr 10126.20 10510.67 12-14-2020 J634 384.47 0.00 Dr 12-15-2020 J622 136.58 0.00 10647.25 Dr 12-22-2020 J654 199.98 0.00 Dr 10847.23 10893.61 12-29-2020 J653 46.38 0.00 Dr 12-31-2020 J669 118.65 0.00 Dr 11012.26 11187.90 12-31-2020 J669 175.64 0.00 Dr R21 fx AT T 2 Transaction by Account part oveto 1991 C F G H I M E 11 w 7 42 AC AD AF AF AG AH AL AL AY A PY , 08. She 00 En w WWW 1 TON DE 2 X WITH ir ir vx EU T L PA T 30 LW 7.46 --> 0 X. A-302 S 2 O C TES www.nam WS _ Yr en WW WE MIT CI WAT 2 2 2 AF ar JO-11-30 11 1.0-30 113 E 12.18 LU LOWO PL 90 1024 XL C ww WA 11345 En . 21 Sir WWE Nail w . . keason an wa 5) www. V-LJU 10 2.00 2.1 012-30 PS . 1% LW 2.00 te 600 78% > to CO ca w ARVI U UNTV ASI LIISI WAY wa EN EU nas I FIT Jir 2018 4D or LVG 20 CO LE Em 4: 05-2015 1 WE KETE XX MTV ANT WWW 2 16 WWE. R. E | -30-300 HT 21-300 FOTO TAL LW LOT XD 002 w wa wa wa BY WE IP ka SIN LE 12 w . www. 60 % wy MRT W3 TM OLT IR VOX - NOM 000 E VOR NER 15 MO EX WWW EX nu LW wu. 2010 200 4X214) 00014 2010 G. WHME ir Wi- - 021-38 Instructions Food & Beverage Purchases Data Sales Data Labor Data + 2 Date Trans. No. Debits Credits Balance 0.00 Cr 0.00 Cr 0.00 Cr 0.00 02-14-2020 J64 02-15-2020 J65 02-16-2020 J66 02-17-2020 J67 02-17-2020 J188 02-18-2020 J68 02-19-2020 J69 02-20-2020 J70 02-21-2020 J71 1758.00 46981.80 1130.75 48112.55 1219.65 49332.20 893.05 50225.25 0.00 50021.14 951.00 50972.14 1252.80 52224.94 2208.45 54433.39 1582.90 56016.29 204.11 0.00 Cr Cr 0.00 0.00 0.00 Cr 02-22-2020 J72 0.00 1421.85 57438.14 Cr 02-23-2020 J73 1168.30 58606.44 0.00 0.00 02-24-2020 J74 02-24-2020 J189 160.05 1105.70 59712.14 0.00 59552.09 1897.25 61449.34 02-25-2020 J75 0.00 Cr 02-26-2020 J76 0.00 1402.60 62851.94 Cr 0.00 0.00 0.00 0.00 217.11 1568.45 64420.39 1324.55 65744.94 941.55 66686.49 1176.75 67863.24 0.00 67646.13 1107.05 68753.18 871.30 69624.48 1274.25 70898.73 1333.70 72232.43 1981.25 74213.68 0.00 0.00 0.00 0.00 0.00 0.00 75476.23 1262.55 1083.75 0.00 76559.98 0.00 1439.00 77998.98 99.28 0.00 77899.70 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 02-27-2020 J77 02-28-2020 J87 02-29-2020 J88 03-01-2020 J89 03-01-2020 J190 03-02-2020 J90 03-03-2020 J91 03-04-2020 J92 03-05-2020 J93 03-06-2020 J94 03-07-2020 J95 03-08-2020 J96 03-09-2020 J97 03-09-2020 J191 03-10-2020 J98 03-11-2020 J99 03-12-2020 J133 03-13-2020 J134 03-14-2020 J135 03-15-2020 J136 03-16-2020 J137 03-16-2020 J192 03-17-2020 J138 03-18-2020 J139 03-19-2020 J140 03-20-2020 J141 03-21-2020 J142 03-22-2020 J143 0.00 79004.85 80243.45 0.00 0.00 1105.15 1238.60 1367.55 1329.95 1192.45 81611.00 82940.95 0.00 0.00 84133.40 0.00 85175.60 1042.20 808.15 0.00 85983.75 68.05 0.00 85915.70 0.00 892.15 86807.85 0.00 735.15 87543.00 0.00 1166.40 88709.40 0.00 0.00 0.00 03-23-2020 J144 0.00 1212.35 89921.75 931.6090853.35 929.25 91782.60 816.60 92599.20 0.00 92484.76 859.15 93343.91 806.40 94150.31 114.44 0.00 0.00 0.00 1154.45 95304.76 0.00 0.00 03-23-2020 J193 03-24-2020 J145 03-25-2020 J146 03-26-2020 J147 03-27-2020 J148 03-28-2020 J149 03-29-2020 J150 03-30-2020 J151 03-31-2020 J152 04-01-2020 J153 04-02-2020 J154 04-03-2020 J155 0.00 0.00 1474.75 96779.51 729.65 97509.16 1053,45 98562.61 791.90 99354.51 1161.25 100515.76 1134.30 101650.06 1225.90 102875.96 0.00 0.00 0.00 0.00 2096.75 104972.71 Cr 04-04-2020 156 0.00 1313.30 106286.01 04-05-2020 J157 0.00 1031.50 107317.51 Date Trans. No. Debits Credits 14-06-2020 J158 0.00 0.00 2 119 120 121 122 123 124 0.00 0.00 0.00 14-07-2020 J159 14-08-2020 J160 14-09-2020 J161 14-10-2020 J162 14-11-2020 J163 04-12-2020 J164 04-13-2020 J165 04-14-2020 J166 Balance 983.00 108300.51 1121.65 109422.16 1667.55 111089.71 1743.25 112832.96 1580.80 114413.76 1303.00 115716.76 780.10 116496.86 1345.70 117842.56 1560.70 119403.26 1993.05 121396.31 0.00 125 0.00 0.00 0.00 14-15-2020 J167 0.00 126 127 128 129 130 131 132 14-17-2020 J168 0.00 123610.61 0.00 125046.21 2214.30 1435.60 1664.85 1238.15 0.00 126711.06 127949.21 14-18-2020 J169 14-19-2020 J170 4-20-2020 171 14-21-2020 J172 14-22-2020 J231 14-23-2020 J232 0.00 0.00 133 129692.31 0.00 1743.10 1992.15 1731.60 131684.46 0.00 133416.06 4-24-2020 J233 0.00 2309.75 135725.81 04-25-2020 J234 0.00 137450.21 04-26-2020 J235 0.00 139286.86 14-27-2020 J236 0.00 1724.40 1836.65 1862. 20 1802.10 2345.70 141149.06 5 0.00 142951.16 0.00 145296.86 14-28-2020 J237 14-29-2020 J238 64-30-2020 J239 05-01-2020 J243 05-01-2020 J243 0.00 2287.20 147584.06 0.00 1302.85 148886.91 0.00 148711.87 175.04 0.00 05-01-2020 J247 2911.65 151623.52 05-02-2020 J248 0.00 2215.55 153839.07 J249 0.00 155643.97 05-03-2020 05-04-2020 J250 0.00 1804.90 1882.50 1731.20 157526.47 05-05-2020 J251 159257.67 0.00 0.00 05-06-2020 J252 1894.80 161152.47 163248.57 0.00 0.00 165631.82 05-07-2020 J253 05-08-2020 J254 05-09-2020 J255 05-10-2020 J256 0.00 167819.17 0.00 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 2096.10 2383.25 2187.35 2325.40 1957.60 1749.25 1944.45 170144.57 05-11-2020 J257 0.00 172102.17 05-12-2020 J258 0.00 173851.42 0.00 175795.87 0.00 177823.52 05-13-2020 J259 05-14-2020 J260 05-15-2020 J261 05-16-2020 J262 0.00 180386.77 2027.65 2563.25 1946.10 1664.25 0.00 182332.87 05-17-2020 J263 0.00 183997.12 Cr 0.00 185831.97 Cr 05-18-2020 J264 95-19-2020 J265 05-20-2020 J266 0.00 187835.87 Cr 1834.85 2003.90 2355.20 2049.80 0.00 190191.07 Cr 05-21-2020 J267 0.00 192240.87 Cr 0.00 2432.40 194673.27 Cr 0.00 1751.85 196425.12 Cr 0.00 198393.87 Cr 1968.75 1313.55 199707.42 Cr 05-22-2020 J268 05-23-2020 J269 55-24-2020 J270 15-25-2020 J271 95-26-2020 J272 05-27-2020 J273 55-28-2020 J274 05-29-2020 J275 0.00 0.00 1641.10 201348.52 Cr 0.00 1339.50 202688.02 Cr 0.00 2193.45 204881.47 Cr 0.00 207495.37 2613.90 1683.00 15-30-2020 J276 0.00 209178.37 Cr 05-31-2020 J277 0.00 1536.10 210714.47 Cr 06-01-2020 J240 0.00 2243.30 212957.77 Cr 12 non n na Date Trans. No. Debits Credits Balance J240 0.00 2243.30 212957.77 Cr 06-01-2020 06-02-2020 06-03-2020 J286 0.00 1886. 10 214843.87 Cr J242 0.00 2055.90 216899.77 Cr 06-04-2020 J288 2246.30 219146.07 Cr 0.00 0.00 06-05-2020 J289 1808.65 220954.72 Cr 06-06-2020 J290 0.00 Cr 1595.20 1196.40 222549.92 223746.32 0.00 Cr 06-07-2020 J291 06-08-2020 J292 0.00 225030.92 Cr 06-09-2020 J293 226193.12 Cr 0.00 0.00 1284.60 1162.20 1340.40 1579.80 227533.52 Cr 0.00 229113.32 Cr 0.00 Cr 1403.90 230517.22 889.30 231406.52 0.00 Cr C 06-10-2020 J294 06-11-2020 J295 06-12-2020 J306 06-13-2020 J307 06-14-2020 J308 06-15-2020 J309 06-16-2020 J310 06-17-2020 J311 06-18-2020 J312 0.00 1116.45 232522.97 Cr 0.00 234249.02 Cr 1726.05 1449.40 0.00 235698.42 Cr 0.00 237604.27 Cr 1905.85 1901.30 0.00 239505.57 Cr 06-19-2020 J313 0.00 241204.12 Cr 1698.55 1097.25 0.00 242301.37 Cr 0.00 1176.50 243477.87 Cr 244694.82 Cr 0.00 0.00 1216.95 1668.55 246363.37 Cr 0.00 247701.92 Cr 1338.55 1274.60 0.00 248976.52 Cr 0.00 1421.05 250397.57 Cr 697.60 251095.17 Cr 0.00 0.00 Cr 2 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 0.00 Cr 703.10 251798.27 1103.80 252902.07 1376.75 254278.82 1235.90 255514.72 0.00 Cr 0.00 Cr 0.00 890.80 256405.52 Cr 0.00 Cr 06-20-2020 J314 06-21-2020 J315 06-22-2020 J316 06-23-2020 J317 06-24-2020 J319 06-25-2020 J320 06-26-2020 J327 06-27-2020 J328 06-28-2020 J329 06-29-2020 J330 06-30-2020 J331 07-01-2020 J332 07-02-2020 J333 07-03-2020 J334 07-04-2020 J335 07-05-2020 J336 07-06-2020 J337 07-07-2020 J346 07-08-2020 J347 07-09-2020 J348 07-10-2020 J349 07-11-2020 J350 07-12-2020 J351 07-13-2020 J352 07-14-2020 J353 07-15-2020 J354 07-16-2020 J355 07-17-2020 J356 0.00 1168.05 257573.57 1035.70 258609.27 587.80 259197.07 Cr 0.00 Cr 0.00 Cr 905.90 260102.97 1108.95 261211.92 0.00 Cr 1227.25 262439.17 Cr 0.00 0.00 Cr 0.00 Cr 1606.85 264046.02 1468.65 265514.67 1202.90 266717.57 917.95 267635.52 0.00 Cr 0.00 Cr 0.00 984.45 268619.97 Cr 0.00 1073.90 269693.87 Cr 1452.60 271146.47 Cr 0.00 0.00 1130.45 272276.92 Cr 0.00 1415.35 273692.27 Cr 0.00 1408.80 275101.07 Cr 0.00 1114.75 276215.82 Cr 0.00 277473.47 Cr 1257.65 1247.05 0.00 278720.52 Cr 07-18-2020 J357 07-19-2020 J358 07-20-2020 J359 07-21-2020 2360 07-22-2020 J361 07-23-2020 J362 07-24-2020 J363 07-25-2020 J364 07-26-2020 J365 0.00 1451.90 280172.42 Cr 0.00 1447.50 281619.92 Cr 0.00 1764.55 283384.47 Cr 0.00 1211.80 284596.27 Cr 0.00 1195.75 285792.02 Cr 07-27-2020 J366 0.00 1444.60 287236.62 Cr 07-28-2020 J367 0.00 1497.65 288734.27 Cr 235 1081.85 1837.50 Cr 253 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No. Debits Credits Balance 232 07-27-2020 J366 0.00 1444.60 287236.62 Cr 233 07-28-2020 J367 0.00 1497.65 288734.27 Cr 234 07-29-2020 J368 0.00 1616.05 290350.32 Cr 07-30-2020 J369 0.00 1776.05 292126.37 Cr 236 07-31-2020 J370 0.00 1996.70 294123.07 Cr 237 08-01-2020 J371 0.00 1580.90 295703.97 Cr 238 08-02-2020 J372 0.00 776.90 296480.87 Cr 239 08-03-2020 J373 0.00 297562.72 Cr 240 08-04-2020 J374 0.00 1141.00 298703.72 Cr 241 08-05-2020 J375 0.00 1531.45 300235.17 Cr 242 08-06-2020 J376 0.00 302072.67 Cr 243 08-07-2020 J377 0.00 1701.10 303773.77 Cr 244 08-08-2020 J378 0.00 1038.65 304812.42 Cr 245 08-09-2020 J400 0.00 945.40 305757.82 Cr 246 08-10-2020 J401 0.00 1279.75 307037.57 Cr 247 08-11-2020 J402 0.00 1440.40 308477.97 Cr 248 08-12-2020 J403 0.00 1315.85 309793.82 Cr 249 08-13-2020 J404 0.00 1727.60 311521.42 250 08-14-2020 J405 0.00 2019.40 313540.82 Cr 251 08-15-2020 J406 0.00 1543.91 315084.73 Cr 252 08-16-2020 J407 0.00 1401.10 316485.83 Cr 08-17-2020 J408 0.00 1456.90 317942.73 Cr 254 08-18-2020 J414 0.00 1183.85 319126.58 Cr 255 08-19-2020 J415 0.00 1736.05 320862.63 Cr 256 08-20-2020 J416 0.00 1515.70 322378.33 Cr 257 08-21-2020 J417 0.00 1482.50 323860.83 Cr 258 08-22-2020 J418 0.00 1131.55 324992.38 Cr 259 08-23-2020 J419 0.00 1168.25 326160.63 Cr 260 08-24-2020 J420 0.00 1181.20 327341.83 Cr 261 08-25-2020 J427 0.00 1382.55 328724.38 Cr 262 08-26-2020 J428 0.00 1414.80 330139.18 Cr 263 08-27-2020 J429 0.00 1401.00 331540.18 Cr 264 08-28-2020 J430 0.00 1467.40 333007.58 Cr 265 08-29-2020 J431 0.00 1262.50 334270.08 Cr 266 08-30-2020 J432 0.00 1362.75 335632.83 Cr 267 08-31-2020 J433 0.00 1209.30 336842.13 Cr 268 09-01-2020 J434 0.00 1085.35 337927.48 Cr 269 09-02-2020 J435 0.00 1341.85 339269.33 Cr 270 09-03-2020 J436 0.00 340773.18 Cr 271 09-04-2020 J437 0.00 1700.95 342474.13 Cr 09-05-2020 J438 0.00 1286.70 343760.83 Cr 273 09-06-2020 J439 0.00 1044.90 344805.73 Cr 274 09-07-2020 J440 0.00 1138.90 345944.63 Cr 275 09-08-2020 J441 0.00 993.75 346938.38 Cr 276 09-09-2020 J442 0.00 1029.05 347967.43 Cr 277 09-10-2020 J443 0.00 1172.60 349140.03 Cr 278 09-11-2020 J444 0.00 1982.30 351122.33 Cr 279 09-12-2020 J445 0.00 1183.35 352305.68 280 09-13-2020 J446 0.00 1341.95 353647.63 Cr 281 09-14-2020 J447 0.00 1167.95 354815.58 Cr 282 09-15-2020 J448 0.00 1457.75 356273.33 Cr 283 09-16-2020 J449 0.00 1464.20 357737.53 Cr 284 09-17-2020 J450 0.00 1354.25 359091.78 Cr 285 09-18-2020 J451 0.00 1621.60 360713.38 Cr 286 09-19-2020 J452 0.00 1097.00 361810.38 Cr 1503.85 272 287 09-20-2020 J453 0.00 823.50 362633.88 Cr 288 09-21-2020 J454 0.00 842.20 363476.08 Cr 289 09-22-2020 J455 0.00 820.95 364297.03 Cr 200l LICC 11ACE AAAAA 2020 Date Trans. N. 09-21-2020 J454 Debits 0.00 Credits Balance 842.20 363476.08 Cr J455 0.00 820.95 364297.03 Cr 09-22-2020 09-23-2020 09-24-2020 J456 0.00 365482.78 Cr 1185.75 1391.70 J457 0.00 366874.48 Cr 09-25-2020 J482 0.00 1705.60 368580.08 Cr 09-26-2020 J483 0.00 1419.05 Cr 369999.13 371137.43 0.00 1138.30 0.00 Cr 0.00 Cr 0.00 1155.00 372292.43 885.90 373178.33 1064.50 374242.83 1271.15 375513.98 2 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 Cr C 0.00 Cr 0.00 10.76 375524.74 Cr 18.67 0.00 375506.07 Cr 0.00 377318.02 Cr 378482.92 Cr 0.00 0.00 1811.95 1164.90 1070.10 1515.30 1227.00 379553.02 Cr 0.00 381068.32 Cr 0.00 382295.32 Cr 1669.00 383964.32 Cr 0.00 0.00 385682.87 Cr 1718.55 1360.00 0.00 387042.87 Cr 0.00 1223.70 388266.57 Cr 310 0.00 329.90 388596.47 Cr 0.00 613.95 389210.42 Cr 0.00 934.80 390145.22 Cr 0.00 1235.85 391381.07 Cr 0.00 1378.75 392759.82 Cr 0.00 1457.05 394216.87 Cr 0.00 1260.85 395477.72 Cr 0.00 911.45 396389.17 Cr 0.00 996.75 397385.92 Cr 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 09-27-2020 J484 09-28-2020 J485 09-29-2020 J486 09-30-2020 J487 10-01-2020 J488 10-01-2020 J663 10-01-2020 J663 10-02-2020 J489 10-03-2020 J490 10-04-2020 J491 10-05-2020 J492 10-06-2020 J518 10-07-2020 J519 10-08-2020 J520 10-09-2020 J521 10-10-2020 J522 10-11-2020 J523 10-12-2020 J524 10-13-2020 J525 10-14-2020 J526 10-15-2020 J527 10-16-2020 J528 10-17-2020 3580 10-18-2020 J529 10-19-2020 J530 10-20-2020 J531 10-21-2020 J532 10-22-2020 J533 10-23-2020 J534 10-24-2020 J535 10-25-2020 J536 10-26-2020 J537 10-27-2020 J538 10-28-2020 J539 10-29-2020 J540 10-30-2020 J541 10-31-2020 J542 11-01-2020 J549 11-02-2020 J550 11-03-2020 J551 11-04-2020 552 11-05-2020 553 11-06-2020 J554 11-07-2020 J555 11-08-2020 J567 11-09-2020 J568 11-10-2020 J569 11-11-2020 J570 11-12-2020 J571 11-13-2020 J581 11-14-2020 J582 0.00 1736.95 399122.87 Cr 0.00 1070.85 400193.72 Cr 0.00 1162.30 401356.02 Cr 0.00 1229.15 402585. 17 Cr 0.00 1096.45 403681.62 Cr 1161.70 404843.32 0.00 0.00 827.55 405670.87 Cr 0.00 406961.62 Cr 1290.75 1653.80 0.00 408615.42 328 0.00 1270.90 409886.32 Cr 0.00 1748.55 411634.87 Cr 0.00 1433.10 413067.97 Cr 0.00 Cr 0.00 Cr 0.00 Cr 0.00 957.65 414025.62 1015.85 415041.47 1000.95 416042.42 1095.10 417137.52 1226.15 418363.67 2722.95 421086.62 1301.90 422388.52 Cr 0.00 Cr 0.00 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 Cr 0.00 Cr 0.00 1199.05 423587.57 Cr 0.00 1182.05 424769.62 Cr 0.00 965.20 425734.82 Cr 0.00 1129.40 426864.22 Cr 0.00 1643.90 428508.12 Cr 0.00 2040.10 430548.22 Cr 0.00 1480.95 432029.17 Cr 11-15-2020 J598 0.00 1346.15 433375.32 Cr S 11 16 nnn 1692 non 12705 4 4neta 47 Cr 2 2 Date Trans. No. 1114- TTTY ZUZU JOOZ JUUL 11-15-2020 J598 Debits V.VO Credits Balance T400.00 YUZULU. TT 0.00 1346.15 433375.32 Cr 345 346 11-16-2020 0.00 1237.85 434613.17 Cr J583 J584 347 11-17-2020 0.00 1566.80 436179.97 Cr 1825.85 438005.82 Cr 0.00 0.00 1158.45 439164.27 Cr 0.00 1925.20 441089.47 Cr 0.00 Cr 1240.45 442329.92 968.45 443298.37 0.00 Cr 0.00 1579.25 444877.62 Cr 0.00 1452.45 446330.07 Cr 0.00 1667.85 447997.92 Cr 0.00 450165.21 Cr 2167.29 2223.00 0.00 452388.21 Cr 0.00 454097.51 Cr 11-18-2020 J585 11-19-2020 J586 11-20-2020 J587 11-21-2020 J588 11-22-2020 J589 11-23-2020 J590 11-24-2020 J599 11-25-2020 J600 11-26-2020 J601 11-27-2020 J602 11-28-2020 J603 11-29-2020 J604 11-30-2020 J605 12-01-2020 J606 12-02-2020 J609 12-03-2020 J607 12-04-2020 J610 12-05-2020 J611 12-06-2020 J612 12-07-2020 J613 12-08-2020 J614 12-09-2020 J641 1709.30 1381.20 0.00 455478.71 0.00 1750.85 457229.56 Cr 0.00 1432.95 458662.51 Cr 0.00 1259.65 459922.16 Cr 0.00 1540.50 461462.66 Cr 0.00 1587.20 463049.86 Cr 1721.65 464771.51 Cr 0.00 0.00 1336.80 466108.31 Cr 0.00 1497.05 467605.36 Cr 0.00 1334.60 468939.96 Cr 0.00 1694.85 470634.81 12-10-2020 J642 0.00 1476.15 472110.96 Cr 12-11-2020 J624 0.00 2050.30 474161.26 Cr 12-12-2020 J625 0.00 1393.00 475554.26 Cr 0.00 Cr 0.00 Cr 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 4120 Beverage Sales 395 396 397 398 399 400 401 402 Cr 0.00 0.00 Cr 12-13-2020 J626 12-14-2020 J627 12-15-2020 J628 12-16-2020 J629 12-17-2020 J630 12-18-2020 J631 12-19-2020 J632 12-20-2020 J633 12-21-2020 J643 1174.95 476729.21 1425.75 478154.96 1155.85 479310.81 1767.20 481078.01 1433.05 482511.06 2890.90 485401.96 1405.20 486807.16 877.95 487685.11 0.00 0.00 Cr 0.00 Cr 0.00 Cr 0.00 Cr 12-22-2020 J644 0.00 1033.05 488718.16 779.00 489497.16 491430.81 Cr J645 0.00 1933.65 Cr 12-23-2020 12-24-2020 J646 0.00 492449.76 Cr 1018.95 1275.65 12-26-2020 J647 0.00 493725.41 Cr 12-27-2020 J648 0.00 1759.15 495484.56 Cr 12-28-2020 J649 0.00 1188.40 496672.96 0.00 1658.45 498331.41 Cr 0.00 1837.70 500169.11 Cr 12-29-2020 J650 12-30-2020 J651 12-31-2020 J652 12-31-2020 J676 0.00 Cr 2503.50 502672.61 0.00 498713.77 Cr #*****# 504458.84 0.00 Cr J1 0.00 16.30 16.30 Cr 01-01-2020 01-02-2020 01-03-2020 J2 0.00 42.41 58.71 Cr J3 80.85 139.56 Cr 0.00 0.00 J4 49.82 189.38 Cr J5 0.00 19.00 208.38 Cr 01-04-2020 01-05-2020 01-06-2020 01-07-2020 J6 0.00 238.26 Cr 29.88 29.99 J7 0.00 268.25 Cr 01-08-2020 J8 0.00 36.04 304.29 Cr Balance 377.78 427.72 49.27 Cr 473.52 Cr 498.42 Cr 517.90 Cr 554.97 Cr 612.86 Cr 654.48 Cr 708.93 71.57 826.67 891.71 940.82 1010.17 Cr 1102.93 Cr 1167.84 Cr 1194.46 Cr 1256. 11 Cr 1280.40 Cr 1360.90 Cr 1425.48 Cr 1516.80 Cr 1575.98 Cr 1624.89 Cr 1685.53 Cr 1737.00 Cr 1780.18 Cr 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. N. Debits Credits 403 01-09-2020 J9 0.00 73.49 404 01-10-2020 J10 0.00 49.94 405 01-11-2020 J11 0.00 21.55 406 01-12-2020 J12 0.00 24.25 407 01-13-2020 J13 0.00 24.90 408 01-14-2020 J26 0.00 19.48 409 01-15-2020 J27 0.00 37.07 410 01-16-2020 J28 0.00 57.89 411 01-17-2020 J36 0.00 41.62 412 01-18-2020 J29 0.00 54.45 413 01-19-2020 J30 0.00 62.64 414 01-20-2020 J31 0.00 55.10 415 01-21-2020 J32 0.00 65.04 416 01-22-2020 J33 0.00 49.11 417 01-23-2020 J34 0.00 69.35 418 01-24-2020 J35 0.00 92.76 419 01-25-2020 J37 0.00 64.91 420 01-26-2020 J38 0.00 26.62 421 01-27-2020 J39 0.00 61.65 422 01-28-2020 J40 0.00 24.29 423 01-29-2020 41 0.00 80.50 424 01-30-2020 J47 0.00 64.58 425 01-31-2020 J48 0.00 91.32 426 02-01-2020 J51 0.00 59.18 427 02-02-2020 J52 0.00 48.91 428 02-03-2020 J53 0.00 60.64 429 02-04-2020 J54 0.00 51.47 430 02-05-2020 55 0.00 43.18 431 02-06-2020 J56 0.00 64.46 432 02-07-2020 J57 0.00 102.23 433 02-08-2020 J671 0.00 54.94 434 02-09-2020 J59 0.00 65.58 435 02-10-2020 J60 0.00 49.80 436 02-11-2020 J61 0.00 50.02 437 02-12-2020 J62 0.00 104.05 438 02-13-2020 J63 0.00 88.41 439 02-14-2020 J64 0.00 91.01 440 02-15-2020 J65 0.00 54.31 441 02-16-2020 J66 0.00 59.67 442 02-17-2020 J67 0.00 46.02 443 02-18-2020 J68 0.00 64.15 444 02-19-2020 J69 0.00 78.53 445 02-20-2020 J70 0.00 92.51 446 02-21-2020 J71 0.00 97.45 447 02-22-2020 J72 0.00 79.83 448 02-23-2020 J73 0.00 77.69 449 02-24-2020 J74 0.00 81.80 450 02-25-2020 J75 0.00 78.45 451 02-26-2020 J76 0.00 69.42 452 02-27-2020 J77 0.00 103.76 453 02-28-2020 J87 0.00 47.76 454 02-29-2020 J88 0.00 41.21 455 03-01-2020 389 0.00 52.19 456 03-02-2020 J90 0.00 82.71 457 03-03-2020 J91 0.00 55.67 458 03-04-2020 92 0.00 71.73 459 03-05-2020 93 0.00 96.36 460 03-06-2020 94 0.00 114.93 ACA 1844.64 Cr 1946.87 Cr Cr 2001.81 2067.39 Cr 2117.19 Cr 2167.21 Cr 2271.26 Cr 2359.67 Cr 2450.68 Cr 2504.99 Cr 2564.66 Cr 2610.68 Cr 2674.83 Cr 2753.36 Cr 2845.87 Cr 2943.32 Cr 3023.15 Cr 3100.84 Cr 3182.64 Cr 3261.09 Cr Cr 3330.51 3434.27 Cr 3482.03 Cr 3523, 24 Cr 3575.43 Cr 3658.14 Cr 3713.81 Cr 3785.54 Cr 3881.90 Cr 3996.83 Cr Balance J94 3996.83 Cr Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No Debits Credits 460 03-06-2020 0.00 114.93 03-07-2020 J95 0.00 57.07 462 03-08-2020 J96 0.00 52.34 463 03-09-2020 J97 0.00 87.13 464 03-10-2020 0.00 61.74 461 4053.90 Cr 4106.24 Cr 4193.37 Cr J98 4255.11 CI 465 03-11-2020 J99 0.00 78.37 4333.48 Cr J133 0.00 94.36 4427.84 Cr 03-12-2020 03-13-2020 J134 0.00 67.21 4495.05 Cr 03-14-2020 J135 0.00 85.62 4580.67 Cr J136 0.00 49.71 4630.38 Cr 03-15-2020 03-16-2020 J137 0.00 43.19 4673.57 Cr 03-17-2020 J138 0.00 40.31 4713.88 Cr 466 467 468 469 470 471 472 473 474 475 476 477 478 03-18-2020 J139 0.00 51.77 4765.65 Cr 03-19-2020 J140 0.00 35.76 4801.41 Cr 03-20-2020 J141 0.00 55.02 4856.43 Cr 03-21-2020 J142 0.00 56.02 4912.45 Cr 03-22-2020 J143 0.00 32.13 4944.58 Cr 03-23-2020 J144 0.00 34.38 4978.96 Cr 03-24-2020 J145 0.00 37.61 5016.57 Cr 479 03-25-2020 J146 33.77 5050.34 0.00 0.00 03-26-2020 J147 32.28 5082.62 Cr 03-27-2020 J148 0.00 40.66 5123.28 Cr 03-28-2020 J149 0.00 13.14 5136.42 Cr 03-29-2020 J150 0.00 36.60 5173.02 Cr 03-30-2020 J151 0.00 40.96 5213.98 Cr 03-31-2020 J152 0.00 37.35 Cr 5251.33 5300.08 04-01-2020 0.00 48.75 Cr J153 J154 04-02-2020 0.00 39.84 5339.92 Cr 04-03-2020 J155 0.00 62.21 5402.13 Cr 04-04-2020 J156 0.00 49.39 5451.52 Cr 04-05-2020 J157 0.00 25.97 5477.49 Cr 0.00 46.84 5524.33 Cr 04-06-2020 04-07-2020 0.00 5568.11 Cr J158 J159 J160 J161 43.78 50.87 04-08-2020 0.00 5618.98 Cr 04-09-2020 0.00 44.73 5663.71 Cr 04-10-2020 J162 0.00 46.91 5710.62 04-11-2020 J163 0.00 49.27 5759.89 Cr 04-12-2020 J164 0.00 24.41 5784.30 Cr 0.00 54.25 5838.55 Cr 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 0.00 65.39 5903.94 Cr 0.00 80.78 5984.72 Cr 04-13-2020 J165 04-14-2020 J166 04-15-2020 J167 04-17-2020 J168 04-18-2020 J169 04-19-2020 J170 04-20-2020 J171 0.00 87.10 6071.82 Cr 0.00 42.49 6114.31 Cr 0.00 62.18 6176.49 Cr 0.00 56.64 6233.13 Cr 04-21-2020 J172 0.00 73.13 6306.26 Cr 04-22-2020 J231 0.00 76.89 6383.15 Cr 04-23-2020 J232 0.00 56.65 6439.80 Cr 04-24-2020 J233 0.00 70.48 6510.28 Cr 04-25-2020 J234 0.00 73.70 6583.98 Cr 04-26-2020 J235 0.00 67.03 6651.01 Cr 04-27-2020 J236 0.00 66.34 6717.35 Cr 04-28-2020 J237 0.00 103.88 6821.23 Cr 04-29-2020 J238 0.00 72.12 6893.35 Cr C 04-30-2020 J239 0.00 109.26 7002.61 Cr 05-01-2020 J243 0.00 42.63 7045.24 Cr J247 0.00 93.43 7138.67 Cr 05-01-2020 05-02-2020 J248 0.00 69.31 7207.98 Cr 522 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. N. Debits Credits Balance 518 05-03-2020 J249 0.00 62.37 7270.35 Cr 519 05-04-2020 J250 0.00 102.42 7372.77 Cr 520 05-05-2020 J251 0.00 62.75 7435.52 Cr 521 05-06-2020 J252 0.00 67.25 7502.77 Cr 05-07-2020 J253 0.00 83.22 7585.99 Cr 523 05-08-2020 J254 0.00 78.87 7664.86 Cr 524 05-09-2020 J255 0.00 105.22 7770.08 Cr 525 05-10-2020 J256 0.00 17.80 7787.88 Cr 526 05-11-2020 J257 0.00 78.21 7866.09 Cr 527 05-12-2020 J258 0.00 61.33 7927.42 Cr 528 05-13-2020 J259 0.00 96.99 8024.41 Cr 529 05-14-2020 J260 0.00 91.76 8116, 17 Cr 530 05-15-2020 J261 0.00 71.13 8187.30 Cr 531 05-16-2020 J262 0.00 83.33 8270.63 Cr 532 05-17-2020 J263 0.00 53.01 8323.64 Cr 533 05-18-2020 J264 0.00 75.87 8399.51 Cr 534 05-19-2020 J265 0.00 82.24 8481.75 Cr 535 05-20-2020 J266 0.00 81.75 8563.50 Cr 536 05-21-2020 J267 0.00 104.60 8668.10 537 05-22-2020 J268 0.00 84.97 8753.07 Cr 538 05-23-2020 J269 0.00 42.55 8795.62 Cr 539 05-24-2020 J270 0.00 50.02 8845.64 Cr 540 05-25-2020 J271 0.00 47.53 8893.17 Cr 541 05-26-2020 J272 0.00 108.88 9002.05 Cr 542 05-27-2020 J273 0.00 73. 17 9075.22 Cr 543 05-28-2020 J274 0.00 147.31 9222.53 Cr 544 05-29-2020 J275 0.00 93.84 9316.37 Cr 545 05-30-2020 J276 0.00 45.13 9361.50 Cr 546 05-31-2020 J277 0.00 44.73 9406.23 Cr 547 06-01-2020 J240 0.00 91.74 9497.97 Cr 548 06-02-2020 J286 0.00 77.90 9575.87 Cr 549 06-03-2020 J242 0.00 95.11 9670.98 Cr 550 06-04-2020 J288 0.00 133.74 9804.72 Cr 551 06-05-2020 J289 0.00 52. 19 9856.91 Cr 552 06-06-2020 J290 0.00 49.19 9906.10 Cr 553 06-07-2020 J291 0.00 35.76 9941.86 Cr 554 06-08-2020 J292 0.00 56.01 9997.87 Cr 555 06-09-2020 J293 0.00 103.67 10101.54 Cr 556 06-10-2020 J294 0.00 100.23 10201.77 Cr 557 06-11-2020 J295 0.00 101.50 10303.27 Cr 558 06-12-2020 J306 0.00 75.63 10378.90 Cr 559 06-13-2020 J307 0.00 40.23 10419.13 Cr 560 06-14-2020 J308 0.00 33.45 10452.58 Cr 561 06-15-2020 J309 0.00 93.88 10546.46 Cr 06-16-2020 J310 0.00 107.96 10654.42 Cr 563 06-17-2020 J311 0.00 88.99 10743.41 Cr 564 06-18-2020 J312 0.00 129.59 10873.00 Cr 565 06-19-2020 J313 0.00 143.47 11016.47 Cr 566 06-20-2020 J314 0.00 56.06 11072.53 Cr 567 06-21-2020 J315 0.00 62.69 11135.22 Cr 568 06-22-2020 J316 0.00 97.24 11232.46 Cr 569 06-23-2020 J317 0.00 75.24 11307.70 Cr 570 06-24-2020 J319 0.00 43.26 11350.96 Cr 571 06-25-2020 J320 0.00 96.37 11447.33 Cr 572 06-26-2020 J327 0.00 70.21 11517.54 Cr 573 06-27-2020 J328 0.00 36.71 11554.25 Cr 574 06-28-2020 J329 0.00 28.39 11582.64 Cr 575 06-29-2020 J330 0.00 53.21 11635.85 Cr 562 Transactions by Account Report 01/01 to 12512020 Date Trans. N. . Debits Credits Balance 06-30-2020 J331 0.00 69.50 11705.35 Cr 07-01-2020 J332 0.00 75.95 11781.30 Cr 07-02-2020 J333 0.00 53.42 11834.72 Cr 07-03-2020 J334 0.00 67.44 11902.16 Cr 07-04-2020 J335 0.00 63.38 11965.54 Cr 07-05-2020 J336 0.00 22.42 11987.96 Cr 07-06-2020 J337 0.00 76.32 12064.28 Cr 07-07-2020 J346 0.00 61.16 12125.44 Cr 07-08-2020 J347 0.00 53.61 12179.05 Cr 07-09-2020 J348 0.00 73.42 12252.47 Cr 07-10-2020 J349 0.00 99.59 12352.06 Cr 07-11-2020 J350 0.00 71.51 12423.57 Cr 07-12-2020 J351 0.00 28.07 12451.64 Cr 07-13-2020 J352 0.00 58.53 12510.17 Cr 07-14-2020 J353 0.00 95.48 12605.65 Cr 07-15-2020 J354 0.00 59.98 12665.63 Cr 07-16-2020 J355 0.00 54.62 12720.25 Cr 07-17-2020 J356 0.00 73.76 12794.01 Cr 0.00 70.37 12864.38 Cr 2 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 0.00 61.19 12925.57 Cr 0.00 87.97 13013.54 Cr 0.00 63.27 13076.81 Cr 07-18-2020 J357 07-19-2020 J358 07-20-2020 J359 07-21-2020 J360 07-22-2020 J361 07-23-2020 J362 07-24-2020 J363 07-25-2020 J364 07-26-2020 J365 0.00 76.84 13153.65 Cr 0.00 82.48 13236.13 Cr 0.00 71.93 13308.06 Cr 0.00 52.51 13360.57 Cr 0.00 64.32 13424.89 Cr 07-27-2020 J366 0.00 60.06 13484.95 Cr 0.00 71.34 13556.29 Cr 0.00 111.34 13667.63 Cr 07-28-2020 J367 07-29-2020 J368 07-30-2020 J369 07-31-2020 J370 0.00 81.74 13749.37 Cr 0.00 79.01 13828.38 Cr 08-01-2020 J371 0.00 38.20 13866.58 Cr J372 0.00 31.59 13898, 17 Cr 08-02-2020 08-03-2020 J373 0.00 43.84 13942.01 Cr 0.00 55.16 13997.17 Cr 0.00 94.82 14091.99 Cr 0.00 100.02 14192.01 Cr 0.00 71.89 14263.90 Cr 08-04-2020 J374 08-05-2020 J375 08-06-2020 J376 08-07-2020 J377 08-08-2020 J378 08-09-2020 J400 08-10-2020 J401 08-11-2020 J402 08-12-2020 J403 0.00 45.15 14309.05 Cr 616 0.00 29.00 14338.05 Cr 0.00 88.45 14426.50 Cr 0.00 72.46 14498.96 Cr 0.00 57.85 14556.81 Cr 08-13-2020 J404 0.00 87.42 14644.23 Cr 08-14-2020 J405 0.00 108.33 14752.56 Cr 08-15-2020 J406 0.00 52.93 14805.49 Cr 08-16-2020 J407 0.00 40.29 14845.78 Cr 08-17-2020 J408 0.00 100.22 14946.00 Cr 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 J414 0.00 58.39 15004.39 Cr 08-18-2020 08-19-2020 J415 114.42 15118.81 Cr 0.00 0.00 08-20-2020 J416 108.51 15227.32 Cr 08-21-2020 J417 0.00 102.04 15329.36 Cr 08-22-2020 J418 0.00 45.73 15375.09 Cr 08-23-2020 J419 0.00 53.10 15428.19 Cr 08-24-2020 J420 0.00 108.45 15536.64 Cr 08-25-2020 J427 0.00 104.53 15641.17 Cr 08-26-2020 J428 0.00 71.06 15712.23 Cr Date Trans. N. Debits Credits Balance 08-26-2020 J428 0.00 71.06 15712.23 Cr 08-27-2020 J429 0.00 71.79 Cr 15784.02 15856.07 08-28-2020 J430 72.05 Cr 0.00 0.00 37.72 15893.79 41.05 15934.84 0.00 Cr 08-29-2020 J431 08-30-2020 J432 08-31-2020 J433 09-01-2020 J434 0.00 65.68 16000.52 Cr 0.00 66.17 16066.69 Cr 09-02-2020 J435 0.00 106.86 16173.55 Cr 09-03-2020 J436 0.00 131.75 16305.30 Cr C 09-04-2020 J437 0.00 152.17 16457.47 Cr 09-05-2020 J438 0.00 82.62 16540.09 Cr 09-06-2020 J439 0.00 30.78 16570.87 09-07-2020 440 0.00 58.80 16629.67 Cr 09-08-2020 J441 0.00 44.24 16673.91 Cr 09-09-2020 J442 0.00 75.08 16748.99 Cr J443 0.00 Cr 09-10-2020 09-11-2020 44 0.00 Cr 62.32 16811.31 80.16 16891.47 56.53 16948.00 27.79 16975.79 09-12-2020 J45 0.00 Cr 09-13-2020 J446 Cr 0.00 0.00 09-14-2020 447 46.29 17022.08 Cr 09-15-2020 J448 Cr 0.00 0.00 09-16-2020 449 109.11 17131.19 129.12 17260.31 69.18 17329.49 09-17-2020 J450 0.00 Cr 09-18-2020 J451 0.00 102.61 17432.10 Cr 0.00 40.86 17472.96 0.00 48.00 17520.96 Cr 0.00 57.00 17577.96 Cr 09-19-2020 J452 09-20-2020 J453 09-21-2020 J454 09-22-2020 J455 09-23-2020 J456 09-24-2020 J457 0.00 65.13 17643.09 Cr 0.00 65.78 17708.87 2 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 1 Cr 0.00 50.49 17759.36 09-25-2020 J482 0.00 17842.10 Cr 82.74 52.94 09-26-2020 J483 0.00 17895.04 Cr 09-27-2020 J484 0.00 55.64 17950.68 Cr J485 0.00 90.07 18040.75 Cr 09-28-2020 09-29-2020 J486 0.00 50.64 18091.39 Cr 09-30-2020 J487 0.00 63.06 18154.45 Cr 10-01-2020 J488 63.01 18217.46 Cr 0.00 0.00 127.57 18345.03 Cr 0.00 58.29 18403.32 Cr J491 0.00 50.36 18453.68 0.00 89.16 18542.84 Cr 0.00 41.95 18584.79 Cr 0.00 0.00 Cr 107.96 18692.75 105.81 18798.56 100.22 18898.78 93.49 18992.27 0.00 Cr 0.00 Cr 0.00 15.88 19008.15 Cr 10-02-2020 J489 10-03-2020 J490 10-04-2020 10-05-2020 J492 10-06-2020 J518 10-07-2020 J519 10-08-2020 J520 10-09-2020 J521 10-10-2020 J522 10-11-2020 J523 10-12-2020 J524 10-13-2020 J525 10-14-2020 J526 10-15-2020 J527 10-16-2020 J528 10-17-2020 J580 10-18-2020 J529 10-19-2020 J530 10-20-2020 J531 10-21-2020 J532 0.00 19044.40 Cr 36.25 40.42 0.00 19084.82 Cr 0.00 19146.53 Cr 61.71 108.56 0.00 19255.09 Cr 78.41 19333.50 Cr 0.00 0.00 34.15 19367.65 Cr 0.00 Cr 38.70 19406.35 58.64 19464.99 0.00 Cr 0.00 57.10 19522.09 Cr 0.00 58.75 19580.84 Cr 10-22-2020 J533 0.00 93.59 19674.43 Cr 10 on on nnnn irn HOT on 648 17131.19 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No. . Debits Credits Balance 626 08-19-2020 J415 0.00 114.42 15118.81 Cr 627 08-20-2020 J416 0.00 108.51 15227.32 Cr 628 08-21-2020 J417 0.00 102.04 15329.36 Cr 629 08-22-2020 J418 0.00 45.73 15375.09 Cr 630 08-23-2020 J419 0.00 53. 10 15428.19 Cr 631 08-24-2020 J420 0.00 108.45 15536.64 CI 632 08-25-2020 J427 0.00 104.53 15641.17 Cr 633 08-26-2020 J428 0.00 71.06 15712.23 Cr 634 08-27-2020 J429 0.00 71.79 15784.02 Cr 635 08-28-2020 J430 0.00 72.05 15856.07 Cr 636 08-29-2020 J431 0.00 37.72 15893.79 Cr 637 08-30-2020 J432 0.00 41.05 15934.84 Cr C 638 08-31-2020 J433 0.00 65.68 16000.52 Cr 639 09-01-2020 J434 0.00 66.17 16066.69 Cr 640 09-02-2020 J435 0.00 106.86 16173.55 Cr 641 09-03-2020 J436 0.00 131.75 16305.30 Cr 642 09-04-2020 J437 0.00 152.17 16457.47 Cr 643 09-05-2020 J438 0.00 82.62 16540.09 Cr 644 09-06-2020 J439 0.00 30.78 16570.87 Cr 645 09-07-2020 J440 0.00 58.80 16629.67 Cr 646 09-08-2020 J41 0.00 44.24 16673.91 Cr 647 09-09-2020 442 0.00 75.08 16748.99 Cr 09-10-2020 443 0.00 62.32 16811.31 Cr 649 09-11-2020 44 0.00 80.16 16891.47 Cr 650 09-12-2020 J445 0.00 56.53 16948.00 Cr 651 09-13-2020 446 0.00 27.79 16975.79 Cr 652 09-14-2020 447 0.00 46.29 17022.08 Cr 653 09-15-2020 J448 0.00 109.11 Cr 654 09-16-2020 449 0.00 129.12 17260.31 Cr 655 09-17-2020 J450 0.00 69.18 17329.49 Cr 656 09-18-2020 0.00 102.61 17432.10 Cr 657 09-19-2020 J452 0.00 40.86 17472.96 Cr 658 09-20-2020 J453 0.00 48.00 17520.96 Cr 659 09-21-2020 J454 0.00 57.00 17577.96 Cr 660 09-22-2020 J455 0.00 65.13 17643.09 Cr 661 09-23-2020 J456 0.00 65.78 17708.87 Cr 662 09-24-2020 J457 0.00 50.49 17759.36 Cr 663 09-25-2020 J482 0.00 82.74 17842.10 Cr 664 09-26-2020 J483 0.00 52.94 17895.04 Cr 665 09-27-2020 J484 0.00 55.64 17950.68 Cr 666 09-28-2020 J485 0.00 90.07 18040.75 Cr 667 09-29-2020 J486 0.00 50.64 18091.39 Cr 668 09-30-2020 J487 0.00 63.06 18154.45 Cr 669 10-01-2020 J488 0.00 63.01 18217.46 Cr 670 10-02-2020 J489 0.00 127.57 18345.03 Cr 671 10-03-2020 J490 0.00 58.29 Cr 672 10-04-2020 J491 0.00 50.36 18453.68 Cr 673 10-05-2020 J492 0.00 89.16 18542.84 Cr C 674 10-06-2020 J518 0.00 41.95 18584.79 Cr 675 10-07-2020 J519 0.00 107.96 18692.75 Cr 676 10-08-2020 J520 0.00 105.81 18798.56 Cr 677 10-09-2020 J521 0.00 100.22 18898.78 Cr 678 10-10-2020 J522 0.00 93.49 18992.27 Cr 679 10-11-2020 J523 0.00 15.88 19008.15 Cr 680 10-12-2020 J524 0.00 36.25 19044.40 Cr 681 10-13-2020 J525 0.00 40.42 19084.82 Cr 10-14-2020 J526 0.00 61.71 19146.53 Cr 683 10-15-2020 J527 0.00 108.56 19255.09 Cr co J451 18403.32 682 Date Trans. No. Credits Balance Debits 0.00 10-15-2020 J527 108.56 19255.09 10-16-2020 J528 0.00 78.41 19333.50 Cr 0.00 34.15 19367.65 Cr 2 683 684 685 686 687 688 689 0.00 38.70 19406.35 Cr C 0.00 58.64 19464.99 Cr 10-17-2020 J580 10-18-2020 J529 10-19-2020 J530 10-20-2020 J531 10-21-2020 J532 10-22-2020 J533 0.00 57.10 19522.09 Cr 0.00 58.75 19580.84 Cr 690 0.00 93.59 19674.43 10-23-2020 J534 0.00 40.80 Cr 19715.23 19775.23 10-24-2020 J535 0.00 60.00 Cr 10-25-2020 J536 0.00 55.16 19830.39 Cr 10-26-2020 J537 0.00 46.79 19877.18 Cr C 10-27-2020 J538 0.00 92.62 19969.80 Cr 10-28-2020 J539 0.00 121.10 20090.90 Cr 691 692 693 694 695 696 697 698 699 700 701 702 703 10-29-2020 J540 0.00 63.74 20154.64 Cr J541 0.00 65.49 20220.13 10-30-2020 10-31-2020 11-01-2020 J542 0.00 44.58 20264.71 Cr J549 12.39 20277.10 Cr 0.00 0.00 11-02-2020 550 68.10 20345.20 Cr 0.00 29.38 20374.58 Cr 0.00 75.02 20449.60 Cr 704 0.00 62.60 20512.20 Cr 0.00 127.01 20639.21 Cr 0.00 34.87 20674.08 Cr 0.00 39.17 20713.25 Cr 0.00 108.62 20821.87 0.00 83.97 20905.84 Cr 11-03-2020 551 11-04-2020 552 11-05-2020 553 11-06-2020 J554 11-07-2020 J555 11-08-2020 J567 11-09-2020 J568 11-10-2020 J569 11-11-2020 J570 11-12-2020 J571 11-13-2020 J581 11-14-2020 J582 11-15-2020 J598 11-16-2020 J583 11-17-2020 J584 11-18-2020 J585 0.00 36.27 20942. 11 Cr 0.00 103.73 21045.84 Cr 0.00 107.63 21153.47 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 0.00 49.26 21202.73 Cr 0.00 48.88 21251.61 Cr 0.00 86.34 21337.95 Cr 0.00 94.82 21432.77 0.00 76.80 21509.57 Cr J586 0.00 57.99 21567.56 Cr 11-19-2020 11-20-2020 J587 0.00 105.90 21673.46 Cr 37.33 21710.79 0.00 0.00 31.23 21742.02 Cr 722 0.00 81.96 21823.98 Cr C 0.00 50.27 21874.25 Cr 0.00 56.11 21930.36 Cr 0.00 93.55 22023.91 Cr 0.00 80.09 22104.00 Cr 0.00 74.15 22178.15 Cr 0.00 53.16 22231.31 Cr 11-21-2020 J588 11-22-2020 J589 11-23-2020 J590 11-24-2020 J599 11-25-2020 J600 11-26-2020 J601 11-27-2020 J6O2 11-28-2020 J603 11-29-2020 J604 11-30-2020 J605 12-01-2020 J606 12-02-2020 J609 12-03-2020 J607 12-04-2020 J610 12-05-2020 J611 12-06-2020 J612 12-07-2020 J613 12-08-2020 J614 0.00 62.16 22293.47 Cr 0.00 64.17 22357.64 Cr 0.00 46.00 22403.64 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 Cr 0.00 74.32 22477.96 Cr 0.00 110.01 22587.97 Cr 0.00 60.18 22648.15 0.00 71.60 22719.75 Cr 0.00 62.13 22781.88 Cr 0.00 87.23 22869.11 Cr 12-09-2020 J641 0.00 54.39 22923.50 12-10-2020 J642 0.00 Cr 62.41 22985.91 109.46 23095.37 12-11-2020 J624 0.00 Cr Debits Credits Balance 0.00 47.78 23143.15 0.00 24.45 23167.60 Cr 59.94 23227.54 Cr 0.00 0.00 48.69 23276.23 Cr 0.00 64.10 23340.33 Cr 0.00 50.25 23390.58 Cr 0.00 Cr 70.32 23460.90 81.86 23542.76 0.00 Cr 0.00 57.81 23600.57 Cr 0.00 34.77 23635.34 Cr 0.00 18.81 23654.15 Cr 0.00 63.95 23718.10 Cr 0.00 30.08 23748 18 Cr 0.00 49.55 23797.73 Cr 0.00 53.45 23851.18 Cr 0.00 43.41 23894.59 Cr 0.00 47.05 23941.64 Cr 0.00 82.42 24024.06 Cr Cr 0.00 59.83 24083.89 0.00 24083.89 0.00 Cr 7.40 Cr 0.00 0.00 7.40 5.35 12.75 Cr 0.00 30.65 43.40 Cr 0.00 5.50 48.90 Cr 0.00 61.70 Cr 2 Date Trans. No 741 12-12-2020 J625 742 12-13-2020 J626 743 12-14-2020 J627 744 12-15-2020 J628 745 12-16-2020 J629 746 12-17-2020 J630 747 12-18-2020 J631 748 12-19-2020 J632 749 12-20-2020 J633 750 12-21-2020 J643 751 12-22-2020 J644 752 12-23-2020 J645 753 12-24-2020 J646 754 12-26-2020 J647 755 12-27-2020 J648 756 12-28-2020 J649 757 12-29-2020 J650 758 12-30-2020 J651 759 12-31-2020 J652 760 761 762 763 4240 Merchandise (Market Wall) 764 01-01-2020 J1 765 01-02-2020 J2 766 01-04-2020 J4 767 01-05-2020 J5 768 01-06-2020 J6 769 01-07-2020 J7 770 01-08-2020 J8 771 01-09-2020 J9 772 01-10-2020 J10 773 01-12-2020 J12 774 01-13-2020 J13 775 01-14-2020 J26 776 01-15-2020 J27 777 01-16-2020 J28 778 01-17-2020 J36 779 01-19-2020 J30 780 01-20-2020 J31 781 01-21-2020 J32 782 01-22-2020 J33 783 01-23-2020 J34 784 01-24-2020 J35 785 01-25-2020 J37 786 01-26-2020 J38 787 01-28-2020 J40 788 01-29-2020 J41 789 01-30-2020 J47 790 01-31-2020 J48 791 02-01-2020 J51 792 02-02-2020 352 793 02-05-2020 J55 794 02-06-2020 J56 795 02-07-2020 J57 796 02-08-2020 J671 797 02-09-2020 J59 798 02-12-2020 J62 12.80 6.45 68.15 Cr 0.00 0.00 27.50 95.65 Cr 8.45 104.10 CI 0.00 0.00 64.95 169.05 CI 0.00 11.60 180.65 Cr 183.40 CM 0.00 2.75 0.00 2.95 186.35 Cr 0.00 188.10 Cr 1.75 5.70 193.80 C 0.00 0.00 28.05 221.85 Cr 0.00 14.50 236.35 Cr 0.00 14.50 250.85 Cr 0.00 13.90 264.75 Cr 0.00 7.40 272.15 Cr 0.00 16.25 288.40 Cr 0.00 1.75 290.15 Cr 0.00 5.45 295.60 Cr 0.00 2.75 298.35 Cr 0.00 2.75 301.10 Cr 0.00 3.90 305.00 Cr 0.00 5.25 310.25 Cr 0.00 5.25 315.50 CE 0.00 14.15 329.65 Cr 0.00 15.30 344.95 Cr 0.00 1.95 346.90 Cr 0.00 1.75 348.65 Cr 9.75 358.40 Cr 0.00 0.00 1.95 360.35 Cr 0.00 4.70 365.05 Cr 0.00 28.70 393.75 Cr Balance 798 393.75 Cr 395.50 Cr 399.10 Cr 421.20 Cr 427.10 Cr 441.10 Cr 445.80 Cr 449.70 Cr 806 455.65 Cr 472.05 Cr 477.95 CO 480.90 Cr 504.40 Cr 517.95 Cr 529.45 C 532.40 CM 536.90 Cr 546.85 Cr 551.55 Cr 558.95 Cr 565.40 Cr 567.15 Cr 820 576.35 Cr 579.30 Cr 583.20 C 587.90 Cr 589.85 Cr 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No. Debits Credits 02-12-2020 J62 0.00 28.70 799 02-13-2020 J63 0.00 1.75 800 02-14-2020 J64 0.00 3.60 801 02-15-2020 J65 0.00 22.10 802 02-17-2020 J67 0.00 5.90 803 02-20-2020 J70 0.00 14.00 804 02-21-2020 J71 0.00 4.70 805 02-22-2020 J72 0.00 3.90 02-23-2020 J73 0.00 5.95 807 02-24-2020 J74 0.00 16.40 808 02-25-2020 J75 0.00 5.90 809 02-26-2020 J76 0.00 2.95 810 02-27-2020 J77 0.00 23.50 811 02-28-2020 J87 0.00 13.55 812 02-29-2020 J88 0.00 11.50 813 03-01-2020 J89 0.00 2.95 814 03-02-2020 J90 0.00 4.50 815 03-03-2020 J91 0.00 9.95 816 03-05-2020 J93 0.00 4.70 817 03-06-2020 J94 0.00 7.40 818 03-07-2020 J95 0.00 6.45 819 03-08-2020 J96 0.00 1.75 03-09-2020 J97 0.00 9.20 821 03-11-2020 J99 0.00 2.95 822 03-12-2020 J133 0.00 3.90 823 03-14-2020 J135 0.00 4.70 824 03-15-2020 J136 0.00 1.95 825 03-19-2020 J140 0.00 3.90 826 03-20-2020 J141 0.00 7.20 827 03-22-2020 J143 0.00 1.95 828 03-24-2020 J145 0.00 2.95 829 03-25-2020 J146 0.00 1.95 830 03-27-2020 J148 0.00 12.35 831 03-28-2020 J149 0.00 8.85 832 03-30-2020 J151 0.00 1.95 833 03-31-2020 J152 0.00 7.45 834 04-01-2020 J153 0.00 5.45 835 04-02-2020 J154 0.00 4.70 836 04-03-2020 J155 0.00 1.95 837 04-04-2020 J156 0.00 3.90 04-05-2020 J157 0.00 1.95 839 04-06-2020 J158 0.00 3.90 840 04-08-2020 J160 0.00 18.65 841 04-09-2020 J161 0.00 3.90 842 04-10-2020 J162 0.00 8.60 843 04-11-2020 J163 0.00 5.85 844 04-12-2020 J164 0.00 4.70 845 04-14-2020 J166 0.00 3.90 846 04-15-2020 J167 0.00 3.90 847 04-17-2020 J168 0.00 10.55 848 04-18-2020 J169 0.00 1.95 849 04-19-2020 J170 0.00 5.25 850 04-20-2020 J171 0.00 6.85 851 04-21-2020 J172 0.00 10.35 852 04-22-2020 J231 0.00 13.75 853 04-23-2020 J232 0.00 9.75 854 04-24-2020 J233 0.00 6.25 855 04-25-2020 J234 0.00 15.35 593.75 Cr 600.95 C 602.90 Cr 605.85 Cr 607.80 Cr 620.15 Cr 629.00 CO 630.95 Cr 638.40 Cr 643.85 Cr 648.55 Cr 650.50 Cr 654.40 CO 838 656.35 Cr 660.25 Cr 678.90 Cr 682.80 Cr 691.40 Cr 697.25 Cr 701.95 Cr 705.85 Cr 709.75 CO 720.30 Cr 722.25 Cr 727.50 Cr 734.35 CO 744.70 Cr 758.45 Cr 768.20 Cr 774.45 Cr 789.80 Cr Balance 789.80 CM 796.15 Cr 803.75 Cr 814.45 CT 827.40 Cr 832.90 C 842.25 CT 844.00 CI 852.00 Cr 861.00 Cr 870.40 C 878.00 CI 880.75 Cr 884.65 Cr 894.05 C 897.55 CI 901.45 Cr 903.20 Cr 872 906.70 Cr 915.10 Cr 918.60 CT 922.10 Cr 925.60 Cr 877 932.85 Cr 953.85 Cr 959.55 Cr 966.00 Cr 970.50 Cr 1 Transactions by Account leport 01/01/2020 to 12/31/2020 2 Date Trans. No. Debits Credits 855 14-25-2020 J234 0.00 15.35 856 14-26-2020 J235 0.00 6.35 857 14-27-2020 J236 0.00 7.60 858 94-29-2020 J238 0.00 10.70 859 14-30-2020 J239 0.00 12.95 860 05-01-2020 J243 0.00 5.50 861 05-01-2020 J247 0.00 9.35 862 05-02-2020 J248 0.00 1.75 863 05-03-2020 J249 0.00 8.00 864 05-04-2020 J250 0.00 9.00 865 05-05-2020 J251 0.00 9.40 866 05-06-2020 J252 0.00 7.60 867 05-07-2020 J253 0.00 2.75 868 05-08-2020 J254 0.00 3.90 869 05-09-2020 J255 0.00 9.40 870 05-10-2020 J256 0.00 3.50 871 05-11-2020 J257 0.00 3.90 05-12-2020 J258 0.00 1.75 873 05-13-2020 J259 0.00 3.50 874 05-14-2020 J260 0.00 8.40 875 05-15-2020 J261 0.00 3.50 876 05-16-2020 J262 0.00 3.50 05-17-2020 J263 0.00 3.50 878 05-18-2020 J264 0.00 7.25 879 95-19-2020 J265 0.00 21.00 880 05-20-2020 J266 0.00 5.70 881 05-21-2020 J267 0.00 6.45 882 05-22-2020 J268 0.00 4.50 883 55-23-2020 J269 0.00 9.75 884 55-24-2020 J270 0.00 5.25 885 15-25-2020 J271 0.00 1.75 886 55-27-2020 J273 0.00 5.50 887 95-28-2020 J274 0.00 2.75 888 05-29-2020 J275 0.00 1.75 889 15-31-2020 J277 0.00 1.75 890 06-01-2020 J240 0.00 10.55 891 06-03-2020 J242 0.00 7.00 892 06-05-2020 J289 0.00 1.75 893 06-06-2020 J290 0.00 11.70 894 06-07-2020 J291 0.00 2.75 895 06-08-2020 J292 0.00 17.50 896 06-10-2020 J294 0.00 1.95 897 06-11-2020 J295 0.00 5.25 898 16-12-2020 J306 0.00 58.15 899 06-13-2020 J307 0.00 3.70 900 06-14-2020 J308 0.00 3.50 901 06-16-2020 J310 0.00 12.30 902 16-17-2020 J311 0.00 1.95 903 16-19-2020 J313 0.00 3.70 904 06-20-2020 J314 0.00 2.75 905 16-21-2020 J315 0.00 2.75 906 56-23-2020 J317 0.00 5.25 907 16-25-2020 J320 0.00 3.70 908 06-29-2020 J330 0.00 1.75 909 06-30-2020 J331 0.00 3.50 910 07-01-2020 J332 0.00 1.95 07-03-2020 J334 0.00 4.50 912 07-04-2020 J335 0.00 1.75 980.25 CI 985.50 C | 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 5 987.25 Cr 992.75 Cr 995.50 C 997.25 CT 999.00 1009.55 1016.55 1018.30 1030.00 1032.75 1050.25 1052.20 1057.45 1115.60 1119.30 1122.80 1135.10 1137.05 1140.75 1143.50 1146.25 1151.50 1155.20 1156.95 1160.45 1162.40 911 1166.90 1168.65 Balance 1168.65 Cr 1177.40 Cr 1181.50 Cr 1189.50 Cr 1196.80 Cr 1202.05 Cr 1214.30 Cr 919 1221.30 Cr 1224.80 Cr 1226.55 Cr 1228.60 Cr 1234.75 Cr 1240.90 Cr 1245.00 Cr 1246.75 Cr 1253.30 Cr 1255.35 Cr 1259.15 Cr 1264.40 Cr 1268.50 Cr 1270.25 Cr 933 1272.30 Cr 1276.10 Cr 1277.85 Cr 1281.35 1286.60 Cr 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No. Debits Credits 912 07-04-2020 J335 0.00 1.75 913 07-06-2020 J337 0.00 8.75 914 07-09-2020 J348 0.00 4.10 915 07-10-2020 J349 0.00 8.00 916 07-11-2020 J350 0.00 7.30 917 07-12-2020 J351 0.00 5.25 918 07-13-2020 J352 0.00 12.25 07-14-2020 J353 0.00 7.00 920 07-15-2020 J354 0.00 3.50 921 07-16-2020 J355 0.00 1.75 922 07-17-2020 J356 0.00 2.05 923 07-19-2020 J358 0.00 6.15 924 07-20-2020 J359 0.00 6.15 925 07-22-2020 J361 0.00 4.10 926 07-23-2020 J362 0.00 1.75 927 07-24-2020 J363 0.00 6.55 928 07-25-2020 J364 0.00 2.05 929 07-26-2020 J365 0.00 3.80 930 07-27-2020 J366 0.00 5.25 931 07-29-2020 J368 0.00 4.10 932 07-31-2020 J370 0.00 1.75 08-01-2020 J371 0.00 2.05 934 08-02-2020 J372 0.00 3.80 935 08-03-2020 J373 0.00 1.75 936 08-04-2020 J374 0.00 3.50 937 08-05-2020 J375 0.00 5.25 938 08-08-2020 J378 0.00 1.75 939 08-11-2020 J402 0.00 3.80 940 08-14-2020 J405 0.00 4.50 941 08-15-2020 J406 0.00 2.05 942 08-17-2020 J408 0.00 1.75 943 08-19-2020 J415 0.00 5.25 944 08-20-2020 J416 0.00 3.50 945 08-21-2020 J417 0.00 9.35 946 08-23-2020 J419 0.00 5.55 947 08-27-2020 429 0.00 5.25 948 08-28-2020 J430 0.00 1.75 949 08-29-2020 J431 0.00 2.75 950 08-30-2020 J432 0.00 12.40 08-31-2020 J433 0.00 1.75 952 09-01-2020 J434 0.00 1.75 953 09-02-2020 J435 0.00 5.55 954 09-03-2020 J436 0.00 2.75 955 09-05-2020 J438 0.00 3.80 956 09-07-2020 J440 0.00 3.50 957 09-08-2020 441 0.00 1.75 958 09-09-2020 442 0.00 2.75 959 09-10-2020 J43 0.00 2.05 960 09-11-2020 44 0.00 1.75 961 09-12-2020 J445 0.00 3.80 962 09-14-2020 J447 0.00 3.80 963 09-15-2020 J48 0.00 5.55 964 09-16-2020 J449 0.00 13.55 965 09-19-2020 J452 0.00 1.75 966 09-20-2020 J453 0.00 2.05 1288.35 Cr 1292.15 Cr 1296.65 Cr 1298.70 Cr 1300.45 Cr 1305.70 Cr 1309.20 Cr 1318.55 Cr 1324.10 Cr 1329.35 1331.10 Cr 1333.85 Cr 1346.25 Cr 951 1348.00 Cr 1349.75 Cr 1355.30 Cr 1358.05 Cr 1361.85 Cr 1365.35 Cr 1367.10 1369.85 Cr 1371.90 Cr Cr 1373.65 1377.45 Cr 1381.25 Cr 1386.80 Cr 1400.35 Cr 1402.10 Cr 1404.15 Cr 967 09-21-2020 J454 0.00 1.75 1405.90 Cr 09-23-2020 J456 0.00 2.05 1407.95 Cr 968 969 09-26-2020 J483 0.00 1.75 1409.70 Cr Trans. No. Credits 2 969 970 Date 09-26-2020 Debits 0.00 Balance 1409.70 J483 1.75 0.00 3.50 1413.20 971 0.00 7.00 1420.20 5.50 1425.70 0.00 0.00 1429.20 09-29-2020 J486 09-30-2020 J487 10-01-2020 J488 10-03-2020 J490 10-05-2020 J492 10-06-2020 J518 10-07-2020 J519 10-08-2020 J520 3.50 4.50 1433.70 0.00 0.00 8.75 1442.45 3.50 1445.95 0.00 0.00 1451.20 5.25 1.75 10-09-2020 J521 0.00 1452.95 10-10-2020 J522 0.00 10.05 1463.00 0.00 3.80 1466.80 0.00 1.75 1468.55 0.00 1.75 1470.30 1480.80 10.50 10-12-2020 J524 10-14-2020 J526 10-16-2020 J528 10-17-2020 J580 10-19-2020 J530 10-22-2020 J533 10-23-2020 J534 10-26-2020 J537 10-28-2020 J539 0.00 0.00 0.00 5.25 1486.05 4.10 1490.15 0.00 1.75 1491.90 0.00 11.50 1503.40 0.00 6.25 1509.65 J540 0.00 1.75 1511.40 10-29-2020 10-30-2020 J541 0.00 1.75 1513.15 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 11-03-2020 551 0.00 1515.90 2.75 3.50 11-06-2020 554 1519.40 Cr 0.00 0.00 4.10 1523.50 CI 2.75 1526.25 0.00 0.00 | 5 555555555555555555555 1530.35 4.10 3.50 0.00 1533.85 0.00 5.25 1539.10 Cr 0.00 2.05 1541.15 0.00 3.50 1544.65 9.05 1553.70 0.00 0.00 0.00 3.50 1557.20 5.50 1562.70 11-08-2020 J567 11-09-2020 J568 11-10-2020 J569 11-12-2020 J571 11-13-2020 J581 11-17-2020 J584 11-21-2020 J588 11-24-2020 J599 11-25-2020 J600 11-26-2020 J601 11-27-2020 J602 11-28-2020 J603 11-29-2020 J604 12-01-2020 J606 12-02-2020 J609 12-04-2020 J610 12-06-2020 J612 12-07-2020 J613 12-08-2020 J614 12-09-2020 J641 12-12-2020 J625 Cr 0.00 2.05 1564.75 Cr C 0.00 1568.85 4.10 2.75 0.00 1571.60 0.00 15.30 1586.90 Cr 0.00 1.75 1588.65 0.00 3.50 1592.15 Cr 7.30 1599.45 0.00 0.00 2.75 1602.20 1011 0.00 7.90 1610.10 6.55 1616.65 Cr 0.00 0.00 1.75 1618.40 Cr 12-16-2020 J629 0.00 1620.45 Cr 2.05 6.15 0.00 1626.60 Cr 0.00 3.50 1630.10 Cr 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 0.00 2.05 1632.15 Cr 12-17-2020 J630 12-21-2020 J643 12-24-2020 J646 12-27-2020 J648 12-30-2020 J651 12-31-2020 J652 0.00 5.55 1637.70 Cr 0.00 1.75 1639.45 Cr 0.00 2.05 1641.50 0.00 1641.50 [] size=:::: assr Debits 1 Transactions by Account Report 01/01/2020 to 12/31/2020 2 Date Trans. No. Credits Balance 41 12-31-2020 J676 0.00 665.91 167474.47 Dr 42 208807.10 41332.63 43 44 5415 Vacation Expense 0.00 Dr 45 01-15-2020 J23 287.82 0.00 287.82 Dr 46 02-01-2020 J214 314.27 0.00 602.09 Dr 47 02-28-2020 J109 260.29 0.00 862.38 Dr 48 03-01-2020 J223 300.61 0.00 1162.99 Dr 49 03-13-2020 J108 279.09 0.00 1442.08 Dr 50 03-31-2020 J130 259.14 0.00 1701.22 Dr 51 04-15-2020 J117 205.08 0.00 1906.30 Dr 52 05-01-2020 J245 253.89 0.00 2160.19 Dr 53 06-01-2020 J394 294.03 0.00 2454.22 Dr 54 06-01-2020 J394 8004.96 0.00 10459.18 Dr 55 06-01-2020 J394 320.22 0.00 10779.40 Dr 56 06-15-2020 J304 309.66 0.00 11089.06 Dr 57 06-30-2020 J246 278.45 0.00 11367.51 Dr 58 07-15-2020 230.72 0.00 11598.23 Dr 59 08-01-2020 J4
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