please help me do a balance sheet and income statement thank you!!!!!!

Part 1 Instructions Fall 2020 You are a newer employee working for Howse, Stant, & Chianese, LLC. Oscar Myer Wiener Corporation, a dog sweater manufacturer, is one of your new clients. Their previous accountant was known to have poor record-keeping habits, and as a result, Oscar Myer Wiener Corporation's financial records are incomplete and hard to decipher. 1. Access the 2019 TransactionList.xlsx file and code each transaction. Use your professional judgment to determine the best way to organize this data. 2. Using the information from Step 1, create an accrual income statement and balance sheet. Please ensure that these statements are formatted properly and understandable. You may have to use some professional judgment. Any assumptions made must be noted in your submission. 3. Submit your coded and filtered 2019 TransactionList.xlsx and your accrual income stament and balance sheet in the dropbox provided in Blackboard. Additional information: . Book depreciation for 2019 is $36,057. Bad debt expense for 2019 is $7,152. (Accrual reserve method) Actual debts written off during the year were $8,950. Accrual gross revenue during 2019 was $1,930,000. Sales returns during 2019 was $245,662 (The square deposits in the transaction list are net of returns). You may need to use the information from 2020ClientEmail.docx and 2020ClientEmail2.docx to correctly code each transaction. . . o a Paragraph 2 Styles Chart of Accounts: 11000 Cash 12000 Accounts receivable 12100 Allowance for doubtful accounts 13000 Notes receivable 14100 Raw materials 14200 Work in process 14300 Finished goods 15100 Investment in municipal bonds - SLC 15200 Investment in common stock - Pioneer 15300 Investments - Domestic Corporation 16000 Land 16100 Building 16150 Mineral deposit 16200 Machinery and equipment 16250 Accumulated depreciation 21000 Bank loans 21200 Accounts payable 21300 Accrued expenses 22000 Bonds payable 30000 Preferred stock 31000 Common stock 31100 Additional paid in capital 32000 Retained earnings 33000 Dividends 41000 Sales 41100 Sales returns 45000 Dividend income 46000 Interest income 47000 Gain 50000 Cost of goods sold 51000 Salaries and wages expense 52100 Maintenance 52200 Property taxes 52300 Licenses and fees 52400 Payroll taxes 52500 Depreciation expense 52550 Depletion expense 52600 Bad debt expense 52700 Advertising 52800 Insurance 52900 Utilities 53000 Travel expense 53100 Administrative expense 54000 Interest expense 55000 Charitable contributions 56000 Legal fees 57000 Federal tax 58000 LOSS 70000 Factory overhead Mailings Review View Help aruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Thank you so much for assisting us with our 2019 tax return. I know that we already missed the extension deadline, but I am hoping that we can get this resolved before the end of the year. We asked our previous accountant for as much information as possible, and he sent us the following account balances: Account balances as of 12/31/2018| $3,740 - Cash $44,00 Notes Receivable $32,000 Accounts Receivable $255,890 Allowance for Doubtful Accounts $9,400 Raw Materials $46,980 Finished Goods $110,552 Investment in municipal bonds-St. Lucie County, FL Investment in common stock-Pioneer Corp $18,200 Investments Domestic Corporation $30,000 Land $68,700 Building $182,432 Machinery and Equpment $210,000 Accumulated Depreciation $89,988 Bank Loans $78,982 Accounts Payable $189,990 Accrued Expenses $11,054 Bonds Payable $200,000 Preferred Stock ($10 par) $160,000 Common Stock ($2 par) $180,000 Additional paid in capital $54,000 Retained Earnings $29,080 Here are some other notes that I think will be pertinent: The only cost that is ever on account is raw materials. The only cost that is ever credited to accrued expenses is other factory costs. All other costs are paid for in cash immediately, so they have no relation to accounts payable or accrued expenses The work in process inventory always has a 50 beginning and ending balance. -The 4/5 nment in dam multa ngirinci 4 tror mest Enable Editing ases. Unless you need to edit, it's safer to stay in Protected View The work in process inventory always has a 50 beginning and ending balance The 9/5 payment to Adams Cruise and Air indudes S450 for meals. *The 12/23 payment to Adams Cruise and Air indudes $1,400 for meals. *The 5/20 payment to Adams Cruise and Air indudes $200 for meals. *A list of vendors that service the factory exclusively: Factory Payroll Processing: The Payroll People Other Factory Costs: Nichols Equipment Maintenance Mimi Cleaning Triana Wolf Leasing Placeholder Company *The St. Lucie Bonds that is listed on that 2018 balance sheet are actually Hillsborough County bonds. The Hillsborough County bonds were purchased on July 6, 2004 and were sold on November 16, 2019 for $3,215. *The shares of Pioneer Corp common stock on March 14, 2019 for $26,400. The stock was purchased for $18,200 on May 9, 2001 "We did not purchase or dispose of any machinery and equipment during the year. Again, thank you for your help! My entire staff and I are about to go on vacation until January 2, 2021 so we will be unreachable for questions. I trust that you will be able to file the return on time Best Regards, D F 1 N- 3 4 -587.25 -27622.20 -26.75 -550.00 -1758.44 -57146.64 -23942.00 - 125.00 5 6 7 8 991.50 -35362.31 47853.12 -98.12 - 74.85 -3428.75 -50.41 -92913.12 A B 1/4/2019 Federal Unemployment 1/6/2019 Fabric Liquidators 1/6/2019 Florida Unemployment Departn 1/6/2019 Insurance Co. 1/9/2019 FB Advertising 1/9/2019 Thread Bare LLC 1/11/2019 Check #789 1/12/2019 Boutsiokos Repairs and Mainte 1/12/2019 DEPOSIT - CHECK 1/17/2019 Carlson Craft Supplies 1/17/2019 Deposit - SQUARE 1/19/2019 FPL 1/20/2019 Adrian Plumbing 1/20/2019 Check #794 1/20/2019 SL Water and Trash 1/20/2019 Thread Bare LLC 1/22/2019 DEPOSIT - CHECK 1/23/2019 Check #796 1/23/2019 Howse Fabrics 1/26/2019 GOOGLE" Adwords 1/29/2019 Staples 1/29/2019 The Payroll People 1/30/2019 Insurance Co. 1/30/2019 La Banque Bank Loan Payment 1/31/2019 Stant Travel Services 2/2/2019 Adams Property Tax Collection 2/2/2019 Deposit - SQUARE 2/4/2019 GOOGLE Adwords 2/5/2019 Nichols Equipment Maintenanc 2/6/2019 Federal Payroll Tax Dept 2/8/2019 FB Advertising 2/11/2019 ELOAP, CPAS 2/13/2019 Dinahoider Como Sheet1 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 900.00 -14025.69 -6000.49 -878.80 -120.58 -9405.55 -550.00 -251.58 -357.44 -4000.00 12587.10 -1087.55 .187.44 -1681.22 -781.24 - 1900.00 -4R5 42 B D E F G H 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 A 2/13/2019 Placeholder Company 2/14/2019 Reap Reams of Fabric 2/16/2019 Brent Myer, Attorney 2/16/2019 FPL 2/16/2019 Placeholder Company 2/19/2019 Boutsiokos Repairs and Mainte 2/19/2019 SL Water and Trash 2/22/2019 Mimi Cleaning 2/22/2019 St. Jude's Hospital 2/27/2019 Check #808 2/27/2019 Insurance Co. 2/28/2019 La Banque Bank Loan Payment 3/1/2019 The Payroll People 3/2/2019 Carlson Craft Supplies 3/4/2019 FB Advertising 3/4/2019 St. Jude's Hospital 3/4/2019 Thread Bare LLC 3/7/2019 Triana Wolf Leasing 3/10/2019 Boutsiokos Repairs and Mainte 3/10/2019 Handyman R Us 3/14/2019 DEPOSIT - CHECK 3/15/2019 Check #818 3/17/2019 GOOGLE Adwords 3/18/2019 Deposit - SQUARE 3/18/2019 FPL 3/18/2019 Stant Travel Services 3/18/2019 SUNBIZ LLC RENEWAL 3/20/2019 SL Water and Trash 3/21/2019 Staples 3/24/2019 Fabric Liquidators 3/28/2019 Deposit - SQUARE 3/29/2019 Check #826 3/30/2010 The Daut Dennie Sheet1 -485.42 -20124.58 -900.00 -190.55 - 11245.12 -161.73 -82.12 -250.00 -1000.00 -20022.10 -550.00 -251.58 -9785.48 -660.00 -1056.21 -1000.00 -11742.58 -4000.00 -88.73 - 112.59 26400.00 -1450.00 - 157.21 98223.45 - 180.78 -248.99 -161.01 -43.12 -86.12 - 193.21 35125.99 -16785.20 R15225 HI O Type here to search B D E F G . C - 16785.20 -8152.25 120118.95 64 65 66 67 68 69 70 71 72 73 -251.58 -1000.00 -250.11 -86.94 -152.11 -550.00 -3265.57 -10.75 -1048.08 -350.00 -3228.75 -685.48 -1000.00 74 3/29/2019 Check #826 3/30/2019 The Payroll People 3/31/2019 Deposit - SQUARE 3/31/2019 La Banque Bank Loan Payment 3/31/2019 St. Jude's Hospital 4/2/2019 FPL 4/3/2019 SL Water and Trash 4/4/2019 Boutsiokos Repairs and Mainte 4/6/2019 Insurance Co. 4/11/2019 Federal Payroll Tax Dept 4/12/2019 Florida Unemployment Departn 4/14/2019 GOOGLE* Adwords 4/14/2019 Mimi Cleaning 4/17/2019 Check #832 4/17/2019 Nichols Equipment Maintenanc 4/19/2019 St. Jude's Hospital 4/20/2019 Deposit - SQUARE 4/20/2019 Fabric Liquidators 4/25/2019 Deposit - SQUARE 4/27/2019 DEPOSIT - CHECK 4/28/2019 Check #836 4/28/2019 Stant Travel Services 4/30/2019 Insurance Co. 4/30/2019 La Banque Bank Loan Payment 4/30/2019 The Payroll People 5/3/2019 Deposit - SQUARE 5/3/2019 ELOAP, CPAS 5/5/2019 Boutsiokos Repairs and Mainte 5/6/2019 Deposit. SQUARE 5/6/2019 St. Jude's Hospital 5/11/2019 Placeholder Company 5/11/2019 Staples 5/18/2019 FR Aduertising Sheet1 190998.74 -3874.50 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 06 50125.44 900.00 - 13025.80 -50.00 -550.00 -251.58 -8422.45 60125.12 -1600.00 -76.32 10225.36 -1000.00 -7851.15 -500.42 - AR 22 D E F G 96 -648.22 -5721.24 - 166.85 -95.67 -10447.57 -2400.00 -988.22 -550.00 -14157.25 186142.22 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 B 5/13/2019 FB Advertising 5/14/2019 Carlson Craft Supplies 5/14/2019 FPL 5/16/2019 SL Water and Trash 5/17/2019 Placeholder Company 5/20/2019 Adams Cruise and Air 5/23/2019 GOOGLE* Adwords 5/25/2019 Insurance Co. 5/27/2019 Check #846 5/29/2019 Deposit - SQUARE 5/30/2019 La Banque Bank Loan Payment 5/31/2019 Stant Travel Services 5/31/2019 The Payroll People 6/2/2019 Mimi Cleaning 6/5/2019 Boutsiokos Repairs and Mainte 6/7/2019 St. Jude's Hospital 6/8/2019 Thread Bare LLC 6/10/2019 Fabric Liquidators 6/13/2019 Carlson Craft Supplies 6/15/2019 Check #850 6/15/2019 DEPOSIT - CHECK 6/15/2019 Triana Wolf Leasing 6/18/2019 ELOAP, CPAS 6/20/2019 Deposit - SQUARE 6/21/2019 Handyman R Us 6/21/2019 Insurance Co. 6/26/2019 Check #852 6/26/2019 FPL 6/28/2019 GOOGLE Adwords 6/29/2019 Federal Payroll Tax Dept 6/29/2019 Stant Travel Services 6/29/2019 The Payroll People 6/8/2019 i Ranaue Bank loan Daument Sheet1 -251.58 -298,23 -9575.45 -350.00 -185.11 -1000.00 -102557.73 -67626.44 -94464.66 -1450.00 1050.00 -4000.00 -800.00 211856.80 -172.70 -550.00 -15875.82 -178.12 -490.85 - 2131.56 -233.39 -10484.99 -2515 C D -10484.99 -251.58 -758.54 -124.55 -74.55 -52.11 -25.12 991.50 -5385.34 -6000.00 - 1000.00 -68943.36 -3228.75 900.00 -169.22 127 128 129 130 131 132 133 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 A 6/29/2019 The Payroll People 6/30/2019 La Banque Bank Loan Payment 7/1/2019 Staples 7/2/2019 FB Advertising 7/2/2019 SL Water and Trash 7/5/2019 Florida Unemployment Departn 7/8/2019 Boutsiokos Repairs and Mainte 7/10/2019 DEPOSIT - CHECK 7/12/2019 Adams Cruise and Air 7/12/2019 Check #857 7/14/2019 St. Jude's Hospital 7/15/2019 Thread Bare LLC 7/16/2019 Check #859 7/16/2019 DEPOSIT - CHECK 7/18/2019 Adrian Plumbing 7/21/2019 Deposit - SQUARE 7/23/2019 Stant Travel Services 7/23/2019 Thread Bare LLC 7/24/2019 Insurance Co. 7/26/2019 Check #864 7/26/2019 ELOAP, CPAS 7/26/2019 GOOGLE* Adwords 7/29/2019 Fabric Liquidators 7/29/2019 The Payroll People 7/30/2019 La Banque Bank Loan Payment 7/31/2019 FPL 8/1/2019 City of Orlando Tax Office 8/6/2019 Boutsiokos Repairs and Mainte 8/6/2019 Placeholder Company 8/8/2019 SL Water and Trash 8/9/2019 Carlson Craft Supplies 8/9/2019 Doxie Threads R/11/2010 St Trina Hostal 151221.11 -349.87 -62976.07 -550.00 -14131.14 -800.00 -107.98 -96782.11 - 15744.11 -251.58 - 150.42 -38.99 - 12.41 -4000.00 -95.22 -32913.12 -52913.12 nnnnn B252 Check #919 C D E F 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 8/11/2019 St. Jude's Hospital 8/14/2019 Howse Fabrics 8/16/2019 Nichols Equipment Maintenanc 8/19/2019 Mimi Cleaning 8/19/2019 Staples 8/19/2019 Thread Bare LLC 8/22/2019 GOOGLE Adwords 8/22/2019 Insurance Co. 8/24/2019 Thread Bare LLC 8/25/2019 Check #873 8/25/2019 FPL 8/25/2019 Stant Travel Services 8/30/2019 FB Advertising 8/30/2019 La Banque Bank Loan Payment 8/30/2019 The Payroll People 9/2/2019 Carlson Craft Supplies 9/2/2019 ELOAP, CPAS 9/2/2019 Fabric Liquidators 9/2/2019 SL Water and Trash 9/4/2019 Boutsiokos Repairs and Mainte 9/5/2019 Adams Cruise and Air 9/5/2019 Deposit - SQUARE 9/12/2019 Placeholder Company 9/13/2019 St. Jude's Hospital 9/15/2019 Check #881 9/15/2019 Howse Fabrics 9/18/2019 GOOGLE Adwords 9/19/2019 Handyman R Us 9/19/2019 Insurance Co. 9/21/2019 Triana Wolf Leasing 9/24/2019 FPL 9/26/2019 Check #886 9/26/2019 Stant Travel Services Sheet1 -1000.00 -27116.79 -878.41 -350.00 -124.12 -48413.11 -1027.28 -550.00 -4871.22 -16587.12 - 162.25 -698.99 -1425.66 -251.58 -9485.84 -46143.36 -800.00 -40515.11 - 120.66 -53.74 -1904.50 324666.90 182 183 184 185 186 187 188 189 190 191 -9855.21 - 1000.00 -1450.00 -81233.44 -1500.00 -26.75 -550.00 -4000.00 - 129.99 -12111.81 -356 OR B252 Check #919 D E -356.98 -84.61 -1000.00 -254.12 -8453.54 -251.59 -485.54 -15744.11 -857.55 -800.00 -45.78 -1154.82 -550.00 -350.00 164448.11 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 1214 215 216 217 218 219 220 221 222 223 9/26/2019 Stant Travel Services 9/27/2019 SL Water and Trash 9/29/2019 St. Jude's Hospital 9/29/2019 Staples 9/29/2019 The Payroll People 9/30/2019 La Banque Bank Loan Payment 10/2/2019 Carlson Craft Supplies 10/4/2019 Thread Bare LLC 10/5/2019 FB Advertising 10/7/2019 ELOAP, CPAS 10/7/2019 Florida Unemployment Departn 10/7/2019 GOOGLE* Adwords 10/10/2019 Insurance Co. 10/10/2019 Mimi Cleaning 10/13/2019 Deposit - SQUARE 10/13/2019 Howse Fabrics 10/18/2019 Check #893 10/18/2019 Placeholder Company 10/20/2019 Boutsiokos Repairs and Mainte 10/22/2019 Federal Payroll Tax Dept 10/22/2019 FPL 10/22/2019 Stant Travel Services 10/25/2019 Fabric Liquidators 10/25/2019 SL Water and Trash 10/27/2019 Check #898 10/28/2019 DEPOSIT - CHECK 10/28/2019 The Payroll People 10/30/2019 La Banque Bank Loan Payment 11/2/2019 Federal Payroll Tax Dept 11/4/2019 Handyman R Us 11/5/2019 Deposit - SQUARE 11/5/2019 St. Jude's Hospital 11/5/2019 Staniec Sheet1 -78472.86 -3228.75 -6000.00 - 112.41 -1546.78 - 105.22 -122.10 -14896.25 -85.45 -15036.22 900.00 -5485.52 -251.59 -985.21 -300.12 40887.22 -1000.00 215.99 neck #919 C D E F -215.99 -2435.61 -550.00 -12560.11 -4656.09 -105.11 -100.02 3215.00 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 A B 11/5/2019 Staples 11/5/2019 Thread Bare LLC 11/7/2019 Insurance Co. 11/8/2019 Howse Fabrics 11/11/2019 Placeholder Company 11/13/2019 Boutsiokos Repairs and Mainte 11/14/2019 FPL 11/16/2019 DEPOSIT - CHECK 11/16/2019 ELOAP, CPAS 11/21/2019 Stant Travel Services 11/22/2019 SL Water and Trash 11/24/2019 GOOGLE* Adwords 11/24/2019 Nichols Equipment Maintenanc 11/27/2019 Check #910 11/30/2019 Doxie Threads 11/30/2019 La Banque Bank Loan Payment 11/30/2019 The Payroll People 12/2/2019 Mimi Cleaning 12/3/2019 Handyman R Us 12/5/2019 Federal Payroll Tax Dept 12/5/2019 Thread Bare LLC 12/8/2019 Boutsiokos Repairs and Mainte 12/8/2019 St. Jude's Hospital 12/10/2019 ELOAP, CPAS 12/11/2019 Doxie Threads 12/11/2019 Staples 12/15/2019 Check #914 12/16/2019 Insurance Co. 12/18/2019 Stant Travel Services 12/20/2019 Check #919 12/20/2019 FPL 12/20/2019 SL Water and Trash 12/23/3n10 Adams Cruise and Air Sheet1 -790.00 -84.23 -94.12 -1875.15 -784.11 -10998.15 -11770.93 -251.59 -5785.84 -350.00 -99.99 -1065.02 -11052.85 -159.99 - 1000.00 -800.00 -3255.43 -212.11 -1450.00 -900.00 -187.88 -9130.70 -198.55 -51.15 -7502.05 PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, i B252 Check #919 D E -198.55 -51.15 -7502.06 -4000.00 7091.37 B 12/20/2019 FPL 12/20/2019 SL Water and Trash 12/23/2019 Adams Cruise and Air 12/25/2019 Triana Wolf Leasing 12/26/2019 Deposit - SQUARE 12/26/2019 Doxie Threads 12/26/2019 FB Advertising 12/30/2019 La Banque Bank Loan Payment 12/30/2019 The Payroll People 12/31/2019 Check #920 12/31/2019 Check #921 12/31/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 12/31/2019 Howse Fabrics -1007.55 -765.19 -251.59 - 12078.98 -1000.00 -6000.00 15000 15000 -18596.25 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 Sheet1 B252 X for Check #919 A B C D 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 B02 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 -1767369.00 1777945.00 Sheet1 Part 1 Instructions Fall 2020 You are a newer employee working for Howse, Stant, & Chianese, LLC. Oscar Myer Wiener Corporation, a dog sweater manufacturer, is one of your new clients. Their previous accountant was known to have poor record-keeping habits, and as a result, Oscar Myer Wiener Corporation's financial records are incomplete and hard to decipher. 1. Access the 2019 TransactionList.xlsx file and code each transaction. Use your professional judgment to determine the best way to organize this data. 2. Using the information from Step 1, create an accrual income statement and balance sheet. Please ensure that these statements are formatted properly and understandable. You may have to use some professional judgment. Any assumptions made must be noted in your submission. 3. Submit your coded and filtered 2019 TransactionList.xlsx and your accrual income stament and balance sheet in the dropbox provided in Blackboard. Additional information: . Book depreciation for 2019 is $36,057. Bad debt expense for 2019 is $7,152. (Accrual reserve method) Actual debts written off during the year were $8,950. Accrual gross revenue during 2019 was $1,930,000. Sales returns during 2019 was $245,662 (The square deposits in the transaction list are net of returns). You may need to use the information from 2020ClientEmail.docx and 2020ClientEmail2.docx to correctly code each transaction. . . o a Paragraph 2 Styles Chart of Accounts: 11000 Cash 12000 Accounts receivable 12100 Allowance for doubtful accounts 13000 Notes receivable 14100 Raw materials 14200 Work in process 14300 Finished goods 15100 Investment in municipal bonds - SLC 15200 Investment in common stock - Pioneer 15300 Investments - Domestic Corporation 16000 Land 16100 Building 16150 Mineral deposit 16200 Machinery and equipment 16250 Accumulated depreciation 21000 Bank loans 21200 Accounts payable 21300 Accrued expenses 22000 Bonds payable 30000 Preferred stock 31000 Common stock 31100 Additional paid in capital 32000 Retained earnings 33000 Dividends 41000 Sales 41100 Sales returns 45000 Dividend income 46000 Interest income 47000 Gain 50000 Cost of goods sold 51000 Salaries and wages expense 52100 Maintenance 52200 Property taxes 52300 Licenses and fees 52400 Payroll taxes 52500 Depreciation expense 52550 Depletion expense 52600 Bad debt expense 52700 Advertising 52800 Insurance 52900 Utilities 53000 Travel expense 53100 Administrative expense 54000 Interest expense 55000 Charitable contributions 56000 Legal fees 57000 Federal tax 58000 LOSS 70000 Factory overhead Mailings Review View Help aruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Thank you so much for assisting us with our 2019 tax return. I know that we already missed the extension deadline, but I am hoping that we can get this resolved before the end of the year. We asked our previous accountant for as much information as possible, and he sent us the following account balances: Account balances as of 12/31/2018| $3,740 - Cash $44,00 Notes Receivable $32,000 Accounts Receivable $255,890 Allowance for Doubtful Accounts $9,400 Raw Materials $46,980 Finished Goods $110,552 Investment in municipal bonds-St. Lucie County, FL Investment in common stock-Pioneer Corp $18,200 Investments Domestic Corporation $30,000 Land $68,700 Building $182,432 Machinery and Equpment $210,000 Accumulated Depreciation $89,988 Bank Loans $78,982 Accounts Payable $189,990 Accrued Expenses $11,054 Bonds Payable $200,000 Preferred Stock ($10 par) $160,000 Common Stock ($2 par) $180,000 Additional paid in capital $54,000 Retained Earnings $29,080 Here are some other notes that I think will be pertinent: The only cost that is ever on account is raw materials. The only cost that is ever credited to accrued expenses is other factory costs. All other costs are paid for in cash immediately, so they have no relation to accounts payable or accrued expenses The work in process inventory always has a 50 beginning and ending balance. -The 4/5 nment in dam multa ngirinci 4 tror mest Enable Editing ases. Unless you need to edit, it's safer to stay in Protected View The work in process inventory always has a 50 beginning and ending balance The 9/5 payment to Adams Cruise and Air indudes S450 for meals. *The 12/23 payment to Adams Cruise and Air indudes $1,400 for meals. *The 5/20 payment to Adams Cruise and Air indudes $200 for meals. *A list of vendors that service the factory exclusively: Factory Payroll Processing: The Payroll People Other Factory Costs: Nichols Equipment Maintenance Mimi Cleaning Triana Wolf Leasing Placeholder Company *The St. Lucie Bonds that is listed on that 2018 balance sheet are actually Hillsborough County bonds. The Hillsborough County bonds were purchased on July 6, 2004 and were sold on November 16, 2019 for $3,215. *The shares of Pioneer Corp common stock on March 14, 2019 for $26,400. The stock was purchased for $18,200 on May 9, 2001 "We did not purchase or dispose of any machinery and equipment during the year. Again, thank you for your help! My entire staff and I are about to go on vacation until January 2, 2021 so we will be unreachable for questions. I trust that you will be able to file the return on time Best Regards, D F 1 N- 3 4 -587.25 -27622.20 -26.75 -550.00 -1758.44 -57146.64 -23942.00 - 125.00 5 6 7 8 991.50 -35362.31 47853.12 -98.12 - 74.85 -3428.75 -50.41 -92913.12 A B 1/4/2019 Federal Unemployment 1/6/2019 Fabric Liquidators 1/6/2019 Florida Unemployment Departn 1/6/2019 Insurance Co. 1/9/2019 FB Advertising 1/9/2019 Thread Bare LLC 1/11/2019 Check #789 1/12/2019 Boutsiokos Repairs and Mainte 1/12/2019 DEPOSIT - CHECK 1/17/2019 Carlson Craft Supplies 1/17/2019 Deposit - SQUARE 1/19/2019 FPL 1/20/2019 Adrian Plumbing 1/20/2019 Check #794 1/20/2019 SL Water and Trash 1/20/2019 Thread Bare LLC 1/22/2019 DEPOSIT - CHECK 1/23/2019 Check #796 1/23/2019 Howse Fabrics 1/26/2019 GOOGLE" Adwords 1/29/2019 Staples 1/29/2019 The Payroll People 1/30/2019 Insurance Co. 1/30/2019 La Banque Bank Loan Payment 1/31/2019 Stant Travel Services 2/2/2019 Adams Property Tax Collection 2/2/2019 Deposit - SQUARE 2/4/2019 GOOGLE Adwords 2/5/2019 Nichols Equipment Maintenanc 2/6/2019 Federal Payroll Tax Dept 2/8/2019 FB Advertising 2/11/2019 ELOAP, CPAS 2/13/2019 Dinahoider Como Sheet1 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 900.00 -14025.69 -6000.49 -878.80 -120.58 -9405.55 -550.00 -251.58 -357.44 -4000.00 12587.10 -1087.55 .187.44 -1681.22 -781.24 - 1900.00 -4R5 42 B D E F G H 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 A 2/13/2019 Placeholder Company 2/14/2019 Reap Reams of Fabric 2/16/2019 Brent Myer, Attorney 2/16/2019 FPL 2/16/2019 Placeholder Company 2/19/2019 Boutsiokos Repairs and Mainte 2/19/2019 SL Water and Trash 2/22/2019 Mimi Cleaning 2/22/2019 St. Jude's Hospital 2/27/2019 Check #808 2/27/2019 Insurance Co. 2/28/2019 La Banque Bank Loan Payment 3/1/2019 The Payroll People 3/2/2019 Carlson Craft Supplies 3/4/2019 FB Advertising 3/4/2019 St. Jude's Hospital 3/4/2019 Thread Bare LLC 3/7/2019 Triana Wolf Leasing 3/10/2019 Boutsiokos Repairs and Mainte 3/10/2019 Handyman R Us 3/14/2019 DEPOSIT - CHECK 3/15/2019 Check #818 3/17/2019 GOOGLE Adwords 3/18/2019 Deposit - SQUARE 3/18/2019 FPL 3/18/2019 Stant Travel Services 3/18/2019 SUNBIZ LLC RENEWAL 3/20/2019 SL Water and Trash 3/21/2019 Staples 3/24/2019 Fabric Liquidators 3/28/2019 Deposit - SQUARE 3/29/2019 Check #826 3/30/2010 The Daut Dennie Sheet1 -485.42 -20124.58 -900.00 -190.55 - 11245.12 -161.73 -82.12 -250.00 -1000.00 -20022.10 -550.00 -251.58 -9785.48 -660.00 -1056.21 -1000.00 -11742.58 -4000.00 -88.73 - 112.59 26400.00 -1450.00 - 157.21 98223.45 - 180.78 -248.99 -161.01 -43.12 -86.12 - 193.21 35125.99 -16785.20 R15225 HI O Type here to search B D E F G . C - 16785.20 -8152.25 120118.95 64 65 66 67 68 69 70 71 72 73 -251.58 -1000.00 -250.11 -86.94 -152.11 -550.00 -3265.57 -10.75 -1048.08 -350.00 -3228.75 -685.48 -1000.00 74 3/29/2019 Check #826 3/30/2019 The Payroll People 3/31/2019 Deposit - SQUARE 3/31/2019 La Banque Bank Loan Payment 3/31/2019 St. Jude's Hospital 4/2/2019 FPL 4/3/2019 SL Water and Trash 4/4/2019 Boutsiokos Repairs and Mainte 4/6/2019 Insurance Co. 4/11/2019 Federal Payroll Tax Dept 4/12/2019 Florida Unemployment Departn 4/14/2019 GOOGLE* Adwords 4/14/2019 Mimi Cleaning 4/17/2019 Check #832 4/17/2019 Nichols Equipment Maintenanc 4/19/2019 St. Jude's Hospital 4/20/2019 Deposit - SQUARE 4/20/2019 Fabric Liquidators 4/25/2019 Deposit - SQUARE 4/27/2019 DEPOSIT - CHECK 4/28/2019 Check #836 4/28/2019 Stant Travel Services 4/30/2019 Insurance Co. 4/30/2019 La Banque Bank Loan Payment 4/30/2019 The Payroll People 5/3/2019 Deposit - SQUARE 5/3/2019 ELOAP, CPAS 5/5/2019 Boutsiokos Repairs and Mainte 5/6/2019 Deposit. SQUARE 5/6/2019 St. Jude's Hospital 5/11/2019 Placeholder Company 5/11/2019 Staples 5/18/2019 FR Aduertising Sheet1 190998.74 -3874.50 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 06 50125.44 900.00 - 13025.80 -50.00 -550.00 -251.58 -8422.45 60125.12 -1600.00 -76.32 10225.36 -1000.00 -7851.15 -500.42 - AR 22 D E F G 96 -648.22 -5721.24 - 166.85 -95.67 -10447.57 -2400.00 -988.22 -550.00 -14157.25 186142.22 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 B 5/13/2019 FB Advertising 5/14/2019 Carlson Craft Supplies 5/14/2019 FPL 5/16/2019 SL Water and Trash 5/17/2019 Placeholder Company 5/20/2019 Adams Cruise and Air 5/23/2019 GOOGLE* Adwords 5/25/2019 Insurance Co. 5/27/2019 Check #846 5/29/2019 Deposit - SQUARE 5/30/2019 La Banque Bank Loan Payment 5/31/2019 Stant Travel Services 5/31/2019 The Payroll People 6/2/2019 Mimi Cleaning 6/5/2019 Boutsiokos Repairs and Mainte 6/7/2019 St. Jude's Hospital 6/8/2019 Thread Bare LLC 6/10/2019 Fabric Liquidators 6/13/2019 Carlson Craft Supplies 6/15/2019 Check #850 6/15/2019 DEPOSIT - CHECK 6/15/2019 Triana Wolf Leasing 6/18/2019 ELOAP, CPAS 6/20/2019 Deposit - SQUARE 6/21/2019 Handyman R Us 6/21/2019 Insurance Co. 6/26/2019 Check #852 6/26/2019 FPL 6/28/2019 GOOGLE Adwords 6/29/2019 Federal Payroll Tax Dept 6/29/2019 Stant Travel Services 6/29/2019 The Payroll People 6/8/2019 i Ranaue Bank loan Daument Sheet1 -251.58 -298,23 -9575.45 -350.00 -185.11 -1000.00 -102557.73 -67626.44 -94464.66 -1450.00 1050.00 -4000.00 -800.00 211856.80 -172.70 -550.00 -15875.82 -178.12 -490.85 - 2131.56 -233.39 -10484.99 -2515 C D -10484.99 -251.58 -758.54 -124.55 -74.55 -52.11 -25.12 991.50 -5385.34 -6000.00 - 1000.00 -68943.36 -3228.75 900.00 -169.22 127 128 129 130 131 132 133 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 A 6/29/2019 The Payroll People 6/30/2019 La Banque Bank Loan Payment 7/1/2019 Staples 7/2/2019 FB Advertising 7/2/2019 SL Water and Trash 7/5/2019 Florida Unemployment Departn 7/8/2019 Boutsiokos Repairs and Mainte 7/10/2019 DEPOSIT - CHECK 7/12/2019 Adams Cruise and Air 7/12/2019 Check #857 7/14/2019 St. Jude's Hospital 7/15/2019 Thread Bare LLC 7/16/2019 Check #859 7/16/2019 DEPOSIT - CHECK 7/18/2019 Adrian Plumbing 7/21/2019 Deposit - SQUARE 7/23/2019 Stant Travel Services 7/23/2019 Thread Bare LLC 7/24/2019 Insurance Co. 7/26/2019 Check #864 7/26/2019 ELOAP, CPAS 7/26/2019 GOOGLE* Adwords 7/29/2019 Fabric Liquidators 7/29/2019 The Payroll People 7/30/2019 La Banque Bank Loan Payment 7/31/2019 FPL 8/1/2019 City of Orlando Tax Office 8/6/2019 Boutsiokos Repairs and Mainte 8/6/2019 Placeholder Company 8/8/2019 SL Water and Trash 8/9/2019 Carlson Craft Supplies 8/9/2019 Doxie Threads R/11/2010 St Trina Hostal 151221.11 -349.87 -62976.07 -550.00 -14131.14 -800.00 -107.98 -96782.11 - 15744.11 -251.58 - 150.42 -38.99 - 12.41 -4000.00 -95.22 -32913.12 -52913.12 nnnnn B252 Check #919 C D E F 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 8/11/2019 St. Jude's Hospital 8/14/2019 Howse Fabrics 8/16/2019 Nichols Equipment Maintenanc 8/19/2019 Mimi Cleaning 8/19/2019 Staples 8/19/2019 Thread Bare LLC 8/22/2019 GOOGLE Adwords 8/22/2019 Insurance Co. 8/24/2019 Thread Bare LLC 8/25/2019 Check #873 8/25/2019 FPL 8/25/2019 Stant Travel Services 8/30/2019 FB Advertising 8/30/2019 La Banque Bank Loan Payment 8/30/2019 The Payroll People 9/2/2019 Carlson Craft Supplies 9/2/2019 ELOAP, CPAS 9/2/2019 Fabric Liquidators 9/2/2019 SL Water and Trash 9/4/2019 Boutsiokos Repairs and Mainte 9/5/2019 Adams Cruise and Air 9/5/2019 Deposit - SQUARE 9/12/2019 Placeholder Company 9/13/2019 St. Jude's Hospital 9/15/2019 Check #881 9/15/2019 Howse Fabrics 9/18/2019 GOOGLE Adwords 9/19/2019 Handyman R Us 9/19/2019 Insurance Co. 9/21/2019 Triana Wolf Leasing 9/24/2019 FPL 9/26/2019 Check #886 9/26/2019 Stant Travel Services Sheet1 -1000.00 -27116.79 -878.41 -350.00 -124.12 -48413.11 -1027.28 -550.00 -4871.22 -16587.12 - 162.25 -698.99 -1425.66 -251.58 -9485.84 -46143.36 -800.00 -40515.11 - 120.66 -53.74 -1904.50 324666.90 182 183 184 185 186 187 188 189 190 191 -9855.21 - 1000.00 -1450.00 -81233.44 -1500.00 -26.75 -550.00 -4000.00 - 129.99 -12111.81 -356 OR B252 Check #919 D E -356.98 -84.61 -1000.00 -254.12 -8453.54 -251.59 -485.54 -15744.11 -857.55 -800.00 -45.78 -1154.82 -550.00 -350.00 164448.11 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 1214 215 216 217 218 219 220 221 222 223 9/26/2019 Stant Travel Services 9/27/2019 SL Water and Trash 9/29/2019 St. Jude's Hospital 9/29/2019 Staples 9/29/2019 The Payroll People 9/30/2019 La Banque Bank Loan Payment 10/2/2019 Carlson Craft Supplies 10/4/2019 Thread Bare LLC 10/5/2019 FB Advertising 10/7/2019 ELOAP, CPAS 10/7/2019 Florida Unemployment Departn 10/7/2019 GOOGLE* Adwords 10/10/2019 Insurance Co. 10/10/2019 Mimi Cleaning 10/13/2019 Deposit - SQUARE 10/13/2019 Howse Fabrics 10/18/2019 Check #893 10/18/2019 Placeholder Company 10/20/2019 Boutsiokos Repairs and Mainte 10/22/2019 Federal Payroll Tax Dept 10/22/2019 FPL 10/22/2019 Stant Travel Services 10/25/2019 Fabric Liquidators 10/25/2019 SL Water and Trash 10/27/2019 Check #898 10/28/2019 DEPOSIT - CHECK 10/28/2019 The Payroll People 10/30/2019 La Banque Bank Loan Payment 11/2/2019 Federal Payroll Tax Dept 11/4/2019 Handyman R Us 11/5/2019 Deposit - SQUARE 11/5/2019 St. Jude's Hospital 11/5/2019 Staniec Sheet1 -78472.86 -3228.75 -6000.00 - 112.41 -1546.78 - 105.22 -122.10 -14896.25 -85.45 -15036.22 900.00 -5485.52 -251.59 -985.21 -300.12 40887.22 -1000.00 215.99 neck #919 C D E F -215.99 -2435.61 -550.00 -12560.11 -4656.09 -105.11 -100.02 3215.00 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 A B 11/5/2019 Staples 11/5/2019 Thread Bare LLC 11/7/2019 Insurance Co. 11/8/2019 Howse Fabrics 11/11/2019 Placeholder Company 11/13/2019 Boutsiokos Repairs and Mainte 11/14/2019 FPL 11/16/2019 DEPOSIT - CHECK 11/16/2019 ELOAP, CPAS 11/21/2019 Stant Travel Services 11/22/2019 SL Water and Trash 11/24/2019 GOOGLE* Adwords 11/24/2019 Nichols Equipment Maintenanc 11/27/2019 Check #910 11/30/2019 Doxie Threads 11/30/2019 La Banque Bank Loan Payment 11/30/2019 The Payroll People 12/2/2019 Mimi Cleaning 12/3/2019 Handyman R Us 12/5/2019 Federal Payroll Tax Dept 12/5/2019 Thread Bare LLC 12/8/2019 Boutsiokos Repairs and Mainte 12/8/2019 St. Jude's Hospital 12/10/2019 ELOAP, CPAS 12/11/2019 Doxie Threads 12/11/2019 Staples 12/15/2019 Check #914 12/16/2019 Insurance Co. 12/18/2019 Stant Travel Services 12/20/2019 Check #919 12/20/2019 FPL 12/20/2019 SL Water and Trash 12/23/3n10 Adams Cruise and Air Sheet1 -790.00 -84.23 -94.12 -1875.15 -784.11 -10998.15 -11770.93 -251.59 -5785.84 -350.00 -99.99 -1065.02 -11052.85 -159.99 - 1000.00 -800.00 -3255.43 -212.11 -1450.00 -900.00 -187.88 -9130.70 -198.55 -51.15 -7502.05 PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, i B252 Check #919 D E -198.55 -51.15 -7502.06 -4000.00 7091.37 B 12/20/2019 FPL 12/20/2019 SL Water and Trash 12/23/2019 Adams Cruise and Air 12/25/2019 Triana Wolf Leasing 12/26/2019 Deposit - SQUARE 12/26/2019 Doxie Threads 12/26/2019 FB Advertising 12/30/2019 La Banque Bank Loan Payment 12/30/2019 The Payroll People 12/31/2019 Check #920 12/31/2019 Check #921 12/31/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 12/31/2019 Howse Fabrics -1007.55 -765.19 -251.59 - 12078.98 -1000.00 -6000.00 15000 15000 -18596.25 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 Sheet1 B252 X for Check #919 A B C D 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 B02 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 -1767369.00 1777945.00 Sheet1