General Ledger : Question 1. Unusual Journal Entries a) Using the data provided, identify any entries made after 9 p.m. and before 6 a.m. in 2022. Use the template below to present your workb) Are there any entries you want to discuss with management? If so, what questions do you have? Are there any additional audit procedures you think need to be performed?a) Hints: Copy and past GL 2022 to a new sheet so your original tab always has a clean copy you can go back to if you have a problem. This question can be answered several ways. The easiest is by sorting (by time), but try the conditional formatting, then sorting by the highlights.

Excel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE U v AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet Insert Draw Page Layout Formulas Data Review View Share Comments Home v 68 Connections Clear *Show Detail Reapply Refresh Properties Stocks Geography ZJ Sort Filter Text to Flash Remove Data Consolidate What - If From From New Database Group Ungroup Subtotal -Hide Detail HTML Text Analysis Query All Edit Links Advanced Columns Fill Duplicates Validation B15 X fx |12/1/2022 K A B C D E F G H 6 00 V General Ledger JE # Date Dr Cr. Acct Name Time Entry by 10288 12/1/22 $2,047.20 1101 Cash: Corporate Accounts 2:22:54 PM Mckenna 10 10288 12/1/22 $2,047.20 1200 Accounts Receivable 2:22:54 PM Mckenna 11 10289 12/1/22 $11,455.20 1101 Cash: Corporate Accounts 2:40:01 PM Mckenna 12 10289 12/1/22 $11,455.20 1200 Accounts Receivable 2:40:01 PM Mckenna 13 10290 12/1/22 $72,605.00 6200 Wage Expense 2:58:40 PM Orr 14 10290 12/1/22 $57,732.20 1102 Cash: Payroll 2:58:40 PM Orr 15 10290 12/1/22 $7,784.69 2100 Federal Tax Payable 2:58:40 PM Orr 16 10290 12/1/22 $3,361.61 2101 Colorado State Tax Payable 2:58:40 PM Orr 17 10290 12/1/22 $3,726.50 2102 FICA Tax Payable 2:58:40 PM Orr 18 10291 12/1/22 $201.60 6205 State Unemployment Tax (SUTA) 3:17:08 PM Orr 19 10291 12/1/22 $3,726.50 6203 FICA Tax Expense 3:17:08 PM Orr 20 10291 12/1/22 $48.00 6204 Federal Unemployment Tax (FUT 3:17:08 PM Orr 21 10291 12/1/22 $3,726.50 2102 FICA Tax Payable 3:17:08 PM Orr 22 10291 12/1/22 $48.00 2103 Federal Unemployment Tax (FUT 3:17:08 PM Orr 23 10291 12/1/22 $201.60 2104 State Unemployment Tax (SUTA) 3:17:08 PM Orr 24 10292 12/1/22 $1,193.08 7003 Interest Expense 3:36:49 PM Orr 25 10292 12/1/22 $551.92 2400 Mortgage Payable 3:36:49 PM Orr 26 10292 12/1/22 $1,745.00 1101 Cash: Corporate Accounts 3:36:49 PM Orr 27 10293 12/1/22 $78.90 7003 Interest Expense 4:17:03 PM Orr 28 10293 12/1/22 $388.10 2500 Notes Payable: Vehicles 4:17:03 PM Orr 29 10293 12/1/22 $467.00 1101 Cash: Corporate Accounts 4:17:03 PM Orr 30 10294 12/1/22 $1.77 7003 Interest Expense 4:38:13 PM Orr 31 10294 12/1/22 $422.23 2500 Notes Payable: Vehicles 4:38:13 PM Orr 32 10294 12/1/22 $424.00 1101 Cash: Corporate Accounts 4:38:13 PM Or Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 GL Ques + + 136% Z10 State Unemployment Tax DUIAl 5:14:08 Page 1 of 30 6053 words X Focus 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE DA GL_For_Students(1) (3) Q Search Sheet U v AutoSave O OFF v = Comments Home Insert Draw Page Layout Formulas Data Review View Share v L8 Connections Clear *Show Detail Properties Reapply Data What - If Group Ungroup Subtotal -Hide Detail From From New Database Refresh Remove Edit Links Stocks Geography ZJ Sort Filte Text to Flash Consolidate HTML Text Query All Advanced Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A B D E F H K 33 10295 12/1/22 $327.89 1100 Cash: Storefront 5:33:59 PM Lopez 34 10295 12/1/22 $24.29 2105 Sales Tax Payable 5:33:59 PM Lopez 35 10295 12/1/22 $303.60 4101 Sales Revenue: Storefront 5:33:59 PM Lopez 36 10296 12/1/22 $609.12 1100 Cash: Storefront 5:45:07 PM Lopez 37 10296 12/1/22 $45.12 2105 Sales Tax Payable 5:45:07 PM Lopez 38 10296 12/1/22 $564.00 4101 Sales Revenue: Storefront 5:45:07 PM Lopez 39 10297 12/1/22 $605.93 1100 Cash: Storefront 6:03:38 PM Lopez 40 10297 12/1/22 $18.74 7022 Credit Card Expense 6:03:38 PM Lopez 41 10297 12/1/22 $46.27 2105 Sales Tax Payable 6:03:38 PM Lopez 42 10297 12/1/22 $578.40 4101 Sales Revenue: Storefront 6:03:38 PM Lopez 43 10298 12/2/22 $10.07 1101 Cash: Corporate Accounts 8:01:06 AM Mckenna 44 10298 12/2/22 $10.07 1200 Accounts Receivable 8:01:06 AM Mckenna 45 10299 12/2/22 $14.22 1101 Cash: Corporate Accounts 8:03:15 AM Mckenna 46 10299 12/2/22 $14.22 1200 Accounts Receivable 8:03:15 AM Mckenna 47 10300 12/2/22 $7.32 1101 Cash: Corporate Accounts 8:07:33 AM Mckenna 48 10300 12/2/22 $7.32 1200 Accounts Receivable 8:07:33 AM Mckenna 49 10301 12/2/22 $10,376.50 1500 Purchases: Ingredients 8:10:55 AM Mckenna 50 10301 12/2/22 $10,376.50 2200 Accounts Payable 8:10:55 AM Mckenna 51 10302 12/2/22 $547.20 1101 Cash: Corporate Accounts 8:14:16 AM Mckenna 52 10302 12/2/22 $547.20 1200 Accounts Receivable 8:14:16 AM Mckenna 53 10303 12/2/22 $1,053.60 1101 Cash: Corporate Accounts 8:18:59 AM Mckenna 54 10303 12/2/22 $1,053.60 1200 Accounts Receivable 8:18:59 AM Mckenna 55 10304 12/2/22 $1,221.60 1101 Cash: Corporate Accounts 8:28:58 AM Mckenna 56 10304 12/2/22 $1,221.60 1200 Accounts Receivable 8:28:58 AM Mckenna 57 10305 12/2/22 $8,450.40 1101 Cash: Corporate Accounts 8:29:52 AM Mckenna 58 10305 12/2/22 $8,450.40 1200 Accounts Receivable 3:29:52 AM Mckenna GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 GL Ques + Worksheet Index GL_2021 GL 2022 Chart of Accounts + 136% Z10 State Unemployment Lax DUIAl 5:17:08 Page 1 of 30 6053 words X Focus 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Page Layout Formulas Data Review View Share Comments Home Insert Draw v 68 Connections Clear X *Show Detail Refresh Properties Reapply Remove Data Group Ungroup Subtotal -Hide Detail Edit Links Stocks Geography Z J Sort Filter Advanced Text to Flash Consolidate What - If From From New Database All Columns Fill Duplicates Validation Analysis HTML Text Query B15 X fx |12/1/2022 E G K A B D F H 59 10306 12/2/22 $5,675.76 1500 Purchases: Ingredients 8:33:24 AM Mckenna 60 10306 12/2/22 $5,675.76 2200 Accounts Payable 8:33:24 AM Mckenna 61 10307 12/2/22 $5,284.80 1101 Cash: Corporate Accounts 12:40:57 PM Mckenna 62 10307 12/2/22 $5,284.80 1200 Accounts Receivable 12:40:57 PM Mckenna 63 10308 12/2/22 $2,620.80 1101 Cash: Corporate Accounts 1:56:09 PM Mckenna 64 10308 12/2/22 $2,620.80 1200 Accounts Receivable 1:56:09 PM Mckenna 65 10309 12/2/22 $4,440.00 1101 Cash: Corporate Accounts 2:16:36 PM Mckenna 66 10309 12/2/22 $4,440.00 1200 Accounts Receivable 2:16:36 PM Mckenna 67 10310 12/2/22 $2,725.00 1250 Office Supplies 3:18:50 PM Mckenna 68 10310 12/2/22 $2,725.00 1101 Cash: Corporate Accounts 3:18:50 PM Mckenna 69 10311 12/2/22 $187.27 1100 Cash: Storefront 5:32:56 PM Lopez 70 10311 12/2/22 $13.87 2105 Sales Tax Payable 5:32:56 PM Lopez 71 10311 12/2/22 $173.40 4101 Sales Revenue: Storefront 5:32:56 PM Lopez 72 10312 12/2/22 $749.74 1100 Cash: Storefront 5:41:00 PM Lopez 73 10312 12/2/22 $55.54 2105 Sales Tax Payable 5:41:00 PM Lopez 74 10312 12/2/22 $694.20 4101 Sales Revenue: Storefront 5:41:00 PM Lopez 75 10313 12/2/22 $605.93 1100 Cash: Storefront 5:56:36 PM Lopez 76 10313 12/2/22 $18.74 7022 Credit Card Expense 5:56:36 PM Lopez 77 10313 12/2/22 $46.27 2105 Sales Tax Payable 5:56:36 PM Lopez 78 10313 12/2/22 $578.40 4101 Sales Revenue: Storefront 5:56:36 PM Lopez 79 10314 12/3/22 $25.00 7024 Bank Fees 3:40:19 PM Orr 80 10314 12/3/22 $14.00 4102 Interest Revenue 3:40:19 PM Orr 81 10314 12/3/22 $11.00 1101 Cash: Corporate Accounts 3:40:19 PM Orr 82 10315 12/3/22 $25.00 7024 Ban 4:47:41 PM Orr 83 10315 12/3/22 $11.00 4102 Interest Revenue 4:47:41 PM Orr 84 10315 12/3/22 $14.00 1100 Cash: Storefront 4:47:41 PM Orr Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 GL Ques + + 136% Z10 | State Unemployment Tax DUIAl 5:14:08 Page 1 of 30 6053 words X Focus 137% 26 WExcel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE DA GL_For_Students(1) (3) Q Search Sheet U v AutoSave O OFF v = Insert Draw Page Layout Formulas Data Review View Share Comments Home v 68 Connections Clear *Show Detail Reapply From From New Database Refresh Properties Stocks Geography ZJ Sort Filte Text to Flash Remove Data Consolidate What - If Group Ungroup Subtotal -Hide Detail All Advanced Columns Fill Duplicates Validation Analysis HTML Text Query Edit Links B15 X fx |12/1/2022 A B C D E F G H K 84 10315 12/3/22 $14.00 1100 Cash: Storefront 4:47:41 PM Orr 85 10316 12/3/22 $25.00 7024 Bank Fees 5:11:17 PM Orr 86 10316 12/3/22 $25.00 1102 Cash: Payroll 5:11:17 PM Orr 87 10317 12/3/22 $233.93 1100 Cash: Storefront 5:31:06 PM Hayes 88 10317 12/3/22 $17.33 2105 Sales Tax Payable 5:31:06 PM Hayes 89 10317 12/3/22 $216.60 4101 Sales Revenue: Storefront 5:31:06 PM Hayes 90 10318 12/3/22 $702.43 1100 Cash: Storefront 5:36:46 PM Hayes 91 10318 12/3/22 $52.03 2105 Sales Tax Payable 5:36:46 PM Hayes 92 10318 12/3/22 $650.40 4101 Sales Revenue: Storefront 5:36:46 PM Hayes 93 10319 12/3/22 $605.51 1100 Cash: Storefront 5:51:02 PM Hayes 94 10319 12/3/22 $18.73 7022 Credit Card Expense 5:51:02 PM Hayes 95 10319 12/3/22 $46.24 2105 Sales Tax Payable 5:51:02 PM Hayes 96 10319 12/3/22 $578.00 4101 Sales Revenue: Storefront 5:51:02 PM Hayes 97 10320 12/4/22 $281.23 1100 Cash: Storefront 5:37:10 PM Hayes 98 10320 12/4/22 $20.83 2105 Sales Tax Payable 5:37:10 PM Hayes 99 10320 12/4/22 $260.40 4101 Sales Revenue: Storefront 5:37:10 PM Hayes 100 10321 12/4/22 $655.78 1100 Cash: Storefront 5:51:55 PM Hayes 101 10321 12/4/22 $48.58 2105 Sales Tax Payable 5:51:55 PM Hayes 102 10321 12/4/22 $607.20 4101 Sales Revenue: Storefront 5:51:55 PM Hayes 103 10322 12/4/22 $605.93 1100 Cash: Storefront 6:12:14 PM Hayes 104 10322 12/4/22 $18.74 7022 Credit Card Expense 6:12:14 PM Hayes 105 10322 12/4/22 $46.27 2105 Sales Tax Payable 6:12:14 PM Hayes 106 10322 12/4/22 $578.40 4101 Sales Revenue: Storefront 6:12:14 PM Hayes 107 10323 12/5/22 $8,583.00 1500 Purchases: Ingredients 8:01:53 AM Mckenna 108 10323 12/5/22 $8,583.00 2200 Accounts Payable 8:01:53 AM Mckenna 109 10324 12/5/22 $2,657.80 2200 Accounts Payable 8:02:50 AM Orr 110 ta cryon 1 10 1 rach . " - - - - A - - GL Ques + Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 + 136% Z10 | State Unemployment Lax DUIAl 5:17:08 Page 1 of 30 6053 words X Focus 137% 26 WExcel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Page Layout Formulas Data Review View Share Comments Home Insert Draw v 68 Connections Clear *Show Detail Properties Reapply X From From New Database Refresh Edit Links Stocks Geography Z J Sort Filter Data What - If Group Ungroup Subtotal -Hide Detail HTML Text Query Advanced Text to Flash Remove Consolidate All Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A B C D E G H K 110 10324 12/5/22 $2,657.80 1101 Cash: Corporate Accounts 8:02:50 AM Orr 111 10325 12/5/22 $1,747.00 1510 Purchases: Cake Boxes, cupcake | 8:07:09 AM Mckenna 112 10325 12/5/22 $1,747.00 2200 Accounts Payable 8:07:09 AM Mckenna 113 10326 12/5/22 $800.00 7005 Liability Insurance Expense 8:09:14 AM Orr 114 10326 12/5/22 $800.00 1101 Cash: Corporate Accounts 8:09:14 AM Orr 115 10327 12/5/22 $345.00 7002 Auto Insurance Expense 8:11:08 AM Orr 116 10327 12/5/22 $345.00 1101 Cash: Corporate Accounts 8:11:08 AM Orr 7004 Electrical & Gas Service Expense 117 10328 12/5/22 $576.80 8:13:00 AM Orr 118 10328 12/5/22 $576.80 1101 Cash: Corporate Accounts 8:13:00 AM Orr 119 10329 12/5/22 $127.50 7006 Telecommunications Expense 8:19:33 AM Orr 120 10329 12/5/22 $127.50 1101 Cash: Corporate Accounts 8:19:33 AM Orr 121 10330 12/5/22 $345.00 7007 Cell Phone Service Expense 8:23:42 AM Orr 122 10330 12/5/22 $345.00 1101 Cash: Corporate Accounts 8:23:42 AM Orr 123 10331 12/5/22 $50.40 7010 Postage Expense 8:27:58 AM Orr 124 10331 12/5/22 $50.40 1101 Cash: Corporate Accounts 8:27:58 AM Orr 125 10332 12/5/22 $265.00 7011 Professional Services Expense 8:32:40 AM Orr 126 10332 12/5/22 $265.00 1101 Cash: Corporate Accounts 8:32:40 AM Orr 127 10333 12/5/22 $270.00 7011 Professional Services Expense 8:38:11 AM Orr 128 10333 12/5/22 $270.00 1101 Cash: Corporate Accounts 8:38:11 AM Orr 129 10334 12/5/22 $444.00 7012 Maintenance Expense 8:44:20 AM Orr 130 10334 12/5/22 $444.00 1101 Cash: Corporate Accounts 8:44:20 AM Orr 131 10335 12/5/22 $426.80 7005 Liability Insurance Expense 8:51:10 AM Orr 132 10335 12/5/22 $426.80 1101 Cash: Corporate Accounts 8:51:10 AM Orr 133 10336 12/5/22 $2,700.00 7001 Medical Insurance Expense 8:58:58 AM Orr 134 10336 12/5/22 $2,700.00 1101 Cash: Corporate Accounts 8:58:58 AM Orr GL Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 Z10 | State Unemployment Lax (UTA Page 1 of 30 6053 words X Focus 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O T O A Thu 10:49 PM QE AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Home Insert Draw Page Layout Formulas Data Review View Share Comments v 68 Connections Clear *Show Detail Properties Reapply X From From New Database Refresh Edit Links Stocks Geography Z J Sort Filte Advanced Text to Flash Remove Data Consolidate What - If Group Ungroup Subtotal -Hide Detail HTML Text Query All Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A B D E G H K 135 10337 12/5/22 $123.25 7014 Dry Cleaning Expense 9:06:56 AM Orr 136 10337 12/5/22 $123.25 1101 Cash: Corporate Accounts 9:06:56 AM Orr 7015 Storefront Paper Supplies 137 10338 12/5/22 $275.00 Expense 9:15:09 AM Mckenna 138 10338 12/5/22 $275.00 1101 Cash: Corporate Accounts 9:15:09 AM Mckenna 139 10339 12/5/22 $1,584.00 7016 Rental Expense 9:24:58 AM Orr 140 10339 12/5/22 $1,584.00 1101 Cash: Corporate Accounts 9:24:58 AM Orr 141 10340 12/5/22 $50.00 7017 Waste Serices Expense 9:34:15 AM Orr 142 10340 12/5/22 $50.00 1101 Cash: Corporate Accounts 9:34:15 AM Orr 7018 Car Maintenance and Fuel 143 10341 12/5/22 $348.54 Expense 1:23:09 PM Orr 144 10341 12/5/22 $348.54 1101 Cash: Corporate Accounts 1:23:09 PM Orr 145 10342 12/5/22 $111.25 7019 Repair Expense 1:24:16 PM Orr 146 10342 12/5/22 $111.25 1101 Cash: Corporate Accounts 1:24:16 PM Orr 147 10343 12/5/22 $165.00 7011 Professional Services Expense 1:41:42 PM Orr 148 10343 12/5/22 $165.00 1101 Cash: Corporate Accounts 1:41:42 PM Orr 149 10344 12/5/22 $143.75 7020 Water Expense 1:43:22 PM Orr 150 10344 12/5/22 $143.75 1101 Cash: Corporate Accounts 1:43:22 PM Orr 7021 Soda Machine Repair and CO2 151 10345 12/5/22 $456.00 Expense 2:42:21 PM Orr 152 10345 12/5/22 $456.00 1101 Cash: Corporate Accounts 2:42:21 PM Orr 153 10346 12/5/22 $3,159.60 1500 Purchases: Ingredients 3:12:02 PM Mckenna 154 10346 12/5/22 $3,159.60 2200 Accounts Payable 3:12:02 PM Mckenna 155 10347 12/5/22 $80.00 2200 Accounts Payable 4:12:23 PM Orr 156 10347 12/5/22 $80.00 1101 Cash: Corporate Accounts 4:12:23 PM Orr 157 10348 12/5/22 $4,284.00 1260 Cooking supplies 4:35:40 PM Mckenna Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 GL Ques + + 136% Z10 State Unemployment Lax DUIAl 5:17:08 Page 1 of 30 6053 words Focus 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O O A Thu 10:50 PM Q AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Home Insert Draw Page Layout Formulas Data Review View Share Comments v 68 Connections Clear X *Show Detail Reapply From From New Database Refresh Properties Stocks Geography ZJ Sort Filter Advanced Text to Flash Remove Data Consolidate What - If Group Ungroup Subtotal -Hide Detail HTML Text Query All Edit Links Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A B C D E F G H K 158 10348 12/5/22 $4,284.00 1101 Cash: Corporate Accounts 4:35:40 PM Mckenna 159 10349 12/5/22 $421.85 1100 Cash: Storefront 5:35:19 PM Lopez 160 10349 12/5/22 $31.25 2105 Sales Tax Payable 5:35:19 PM Lopez 161 10349 12/5/22 $390.60 4101 Sales Revenue: Storefront 5:35:19 PM Lopez 162 10350 12/5/22 $515.16 1100 Cash: Storefront 5:48:40 PM Lopez 163 10350 12/5/22 $38.16 2105 Sales Tax Payable 5:48:40 PM Lopez 164 10350 12/5/22 $477.00 4101 Sales Revenue: Storefront 5:48:40 PM Lopez 165 10351 12/5/22 $605.93 1100 Cash: Storefront 6:10:14 PM Lopez 166 10351 12/5/22 $18.74 7022 Credit Card Expense 6:10:14 PM Lopez 167 10351 12/5/22 $46.27 2105 Sales Tax Payable 6:10:14 PM Lopez 168 10351 12/5/22 $578.40 4101 Sales Revenue: Storefront 6:10:14 PM Lopez 169 10352 12/6/22 $54.00 1500 Purchases: Ingredients 8:01:08 AM Mckenna 170 10352 12/6/22 $54.00 2200 Accounts Payable 8:01:08 AM Mckenna 171 10353 12/6/22 $327.89 1100 Cash: Storefront 5:32:56 PM Lopez 172 10353 12/6/22 $24.29 2105 Sales Tax Payable 5:32:56 PM Lopez 173 10353 12/6/22 $303.60 4101 Sales Revenue: Storefront 5:32:56 PM Lopez 174 10354 12/6/22 $609.12 1100 Cash: Storefront 5:41:48 PM Lopez 175 10354 12/6/22 $45.12 2105 Sales Tax Payable 5:41:48 PM Lopez 176 10354 12/6/22 $564.00 4101 Sales Revenue: Storefront 5:41:48 PM Lopez 177 10355 12/6/22 $605.93 1100 Cash: Storefront 5:57:29 PM Lopez 178 10355 12/6/22 $18.74 7022 Credit Card Expense 5:57:29 PM Lopez 179 10355 12/6/22 $46.27 2105 Sales Tax Payable 5:57:29 PM Lopez 180 10355 12/6/22 $578.40 4101 Sales Revenue: Storefront 5:57:29 PM Lopez 181 10356 12/7/22 $187.27 1100 Cash: Storefront 5:31:28 PM Lopez 182 10356 12/7/22 $13.87 2105 Sales Tax Payable 5:31:28 PM Lopez 183 10356 12/7/22 $173.40 4101 Sales Revenue: Storefront 5:31:28 PM Lopez tarn ne GL Ques + Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 + 136% Z10 | State Unemployment Lax BUTA Page 1 of 30 6053 words OX Focus TE 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O O A Thu 10:50 PM Q AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Home Insert Draw Page Layout Formulas Data Review View Share Comments v L8 Connections Clear *Show Detail Properties Reapply X From From New Database Refresh Stocks Geography ZJ Sort Filte Advanced Text to Flash Remove Data Consolidate What - If Group Ungroup Subtotal -Hide Detail HTML Text Query All Edit Links Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A B D E F G H K 184 10357 12/7/22 $750.06 1100 Cash: Storefront 5:41:19 PM Lopez 185 10357 12/7/22 $55.56 2105 Sales Tax Payable 5:41:19 PM Lopez 186 10357 12/7/22 $694.50 4101 Sales Revenue: Storefront 5:41:19 PM Lopez 187 10358 12/7/22 $606.14 1100 Cash: Storefront 5:59:21 PM Lopez 188 10358 12/7/22 $18.75 7022 Credit Card Expense 5:59:21 PM Lopez 189 10358 12/7/22 $46.29 2105 Sales Tax Payable 5:59:21 PM Lopez 190 10358 12/7/22 $578.60 4101 Sales Revenue: Storefront 5:59:21 PM Lopez 191 10359 12/8/22 $523.80 1100 Cash: Storefront 5:38:00 PM Lopez 192 10359 12/8/22 $38.80 2105 Sales Tax Payable 5:38:00 PM Lopez 193 10359 12/8/22 $485.00 4101 Sales Revenue: Storefront 5:38:00 PM Lopez 194 10360 12/8/22 $348.84 1100 Cash: Storefront 5:54:28 PM Lopez 195 10360 12/8/22 $25.84 2105 Sales Tax Payable 5:54:28 PM Lopez 196 10360 12/8/22 $323.00 4101 Sales Revenue: Storefront 5:54:28 PM Lopez 197 10361 12/8/22 $423.23 1100 Cash: Storefront 6:18:26 PM Lopez 198 10361 12/8/22 $13.09 7022 Credit Card Expense 6:18:26 PM Lopez 199 10361 12/8/22 $32.32 2105 Sales Tax Payable 6:18:26 PM Lopez 200 10361 12/8/22 $404.00 4101 Sales Revenue: Storefront 6:18:26 PM Lopez 201 10362 12/9/22 $348.84 1100 Cash: Storefront 5:32:39 PM Lopez 202 10362 12/9/22 $25.84 2105 Sales Tax Payable 5:32:39 PM Lopez 203 10362 12/9/22 $323.00 4101 Sales Revenue: Storefront 5:32:39 PM Lopez 204 10363 12/9/22 $610.20 1100 Cash: Storefront 5:42:56 PM Lopez 205 10363 12/9/22 $45.20 2105 Sales Tax Payable 5:42:56 PM Lopez 206 10363 12/9/22 $565.00 4101 Sales Revenue: Storefront 5:42:56 PM Lopez 207 10364 12/9/22 $423.23 1100 Cash: Storefront 5:58:39 PM Lopez 208 10364 12/9/22 $13.09 7022 Credit Card Expense 5:58:39 PM Lopez 209 10364 12/9/22 $32.32 2105 Sales Tax Payable 5:58:39 PM Lopez Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question 7 GL Ques + + 136% Z10 | State Unemployment Tax (UIAl 5:14:08 Page 1 of 30 6053 words X Focus 137% 26 wExcel File Edit View Insert Format Tools Data Window Help O O O A Thu 10:50 PM Q AutoSave O OFF v = DA GL_For_Students(1) (3) Q Search Sheet U v Home Insert Draw Page Layout Formulas Data Review View Share Comments v 68 Connections Clear X *Show Detail Refresh Properties Reapply From From New Database Edit Links Stocks Geography Z J Sort Filter Text to Flash Data What - If Group Ungroup Subtotal -Hide Detail HTML Text Query All Advanced Remove Consolidate Columns Fill Duplicates Validation Analysis B15 X fx |12/1/2022 A C D E F G H K B 209 10364 12/9/22 $32.32 2105 Sales Tax Payable 5:58:39 PM Lopez 210 10364 12/9/22 $404.00 4101 Sales Revenue: Storefront 5:58:39 PM Lopez 211 10365 12/10/22 $436.32 1100 Cash: Storefront 5:39:02 PM Hayes 212 10365 12/10/22 $32.32 2105 Sales Tax Payable 5:39:02 PM Hayes 213 10365 12/10/22 $404.00 4101 Sales Revenue: Storefront 5:39:02 PM Hayes 214 10366 12/10/22 $348.84 1100 Cash: Storefront 5:58:02 PM Hayes 215 10366 12/10/22 $25.84 2105 Sales Tax Payable 5:58:02 PM Hayes 216 10366 12/10/22 $323.00 4101 Sales Revenue: Storefront 5:58:02 PM Hayes 217 10367 12/10/22 $254.57 1100 Cash: Storefront 6:24:39 PM Hayes 218 10367 12/10/22 $7.87 7022 Credit Card Expense 6:24:39 PM Hayes 219 10367 12/10/22 $19.44 2105 Sales Tax Payable 6:24:39 PM Hayes 220 10367 12/10/22 $243.00 4101 Sales Revenue: Storefront 6:24:39 PM Hayes 221 10368 12/11/22 $523.80 1100 Cash: Storefront 5:36:18 PM Hayes 222 10368 12/11/22 $38.80 2105 Sales Tax Payable 5:36:18 PM Hayes 223 10368 12/11/22 $485.00 4101 Sales Revenue: Storefront 5:36:18 PM Hayes 224 10369 12/11/22 $523.80 1100 Cash: Storefront 5:44:54 PM Hayes 225 10369 12/11/22 $38.80 2105 Sales Tax Payable 5:44:54 PM Hayes 226 10369 12/11/22 $485.00 4101 Sales Revenue: Storefront 5:44:54 PM Hayes 227 10370 12/11/22 $338.37 1100 Cash: Storefront 5:58:34 PM Hayes 228 10370 12/11/22 $10.47 7022 Credit Card Expense 5:58:34 PM Hayes 229 10370 12/11/22 $25.84 2105 Sales Tax Payable 5:58:34 PM Hayes 230 10370 12/11/22 $323.00 4101 Sales Revenue: Storefront 5:58:34 PM Hayes 231 10371 12/12/22 $436.32 1100 Cash: Storefront 5:36:46 PM Lopez 232 10371 12/12/22 $32.32 2105 Sales Tax Payable 5:36:46 PM Lopez 233 10371 12/12/22 $404.00 4101 Sales Revenue: Storefront 5:36:46 PM Lopez 234 10372 12/12/22 $348.84 1100 Cash: Storefront 5:48:20 PM Lopez 235 10372 17/12/72 $25 84 2105 Sales Tax Pavahle 5.48.20 PM Loner Worksheet Index GL_2021 GL 2022 Chart of Accounts GL Question 1 GL Question 2 GL Question 3 GL Question 4 GL Question 5 GL Question 6 GL Question ZIU State Unemployment Lax DUIAl 5:1/:08 Page 1 of 30 6053 words X Focus TE 137% 26 w