Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me make a balance sheet?!!!!! Paragraph Styles Corporate Tax Return Instructions Part 1 Instructions Fall 2020 You are a newer employee working for Howse

help me make a balance sheet?!!!!! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Paragraph Styles Corporate Tax Return Instructions 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 2019TransactionList.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 2019TransactionList.xlsx and your accrual income statement 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 f a File Edit View Insert Format Data Tools Add-ons Help Last edit was made 3 days ago by barbi bordas % 0.00 123- Default (Ca... 11 - BIGA O. B- na 100% - $ fx 8/24/2019 A B D E F G 1 2. 14100 14100 14100 14100 3 5 6 7 8 9 10 11 1/6/2019 Fabric Liquidators 1/9/2019 Thread Bare LLC 1/17/2019 Carlson Craft Supplies 1/20/2019 Thread Bare LLC 1/23/2019 Howse Fabrics 2/14/2019 Reap Reams of Fabric 3/2/2019 Thread Bare LLC 3/4/2019 Thread Bare LLC 3/24/2019 Fabric Liquidators 4/20/2019 Fabric Liquidators 5/14/2019 Carlson Craft Supplies 6/8/2019 Thread Bare LLC 6/10/2019 Fabric Liquidators 6/13/2019 Carlson Craft Supplies 7/15/2019 Thread Bare LLC 7/23/2019 Thread Bare LLC 7/29/2019 Fabric Liquidators 8/9/2019 Carlson Craft Supplies 8/9/2019 Doxie Threads 8/14/2019 Howse Fabrics 8/19/2019 Thread Bare LLC 8/24/2019 Thread Bare LLC -27622.20 -57146.64 -35362.31 -92913.12 -6000.49 -20124.58 -660.00 - 11742.58 -193.21 -3874.50 -5721.24 -102557.73 -67626.44 -94464.66 -68943.36 -62976.07 -96782.11 -32913.12 -52913.12 -27116.79 -48413.11 -4871.22 12 13 14 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 15 16 10 19 20 ERR Sheet1 Sheet2 Sheet3 81241 B D F G H 22 23 24 25 26 27 28 29 30 -4871.22 -46143.36 -40515.11 -81233.44 -485.54 - 15744.11 -78472.86 - 14896.25 -2435.61 - 12560.11 11770.93 -11052.85 -3255.43 -1007.55 -18596.25 31 8/24/2019 Thread Bare LLC 9/2/2019 Carlson Craft Supplies 9/2/2019 Fabric Liquidators 9/15/2019 Howse Fabrics 10/2/2019 Carlson Craft Supplies 10/4/2019 Thread Bare LLC 10/13/2019 Howse Fabrics 10/25/2019 Fabric Liquidators 11/5/2019 Thread Bare LLC 11/8/2019 Howse Fabrics 11/30/2019 Doxie Threads 12/5/2019 Thread Bare LLC 12/11/2019 Doxie Threads 12/26/2019 Doxie Threads 12/31/2019 Howse Fabrics 3/14/2019 DEPOSIT - CHECK 1/11/2019 Check #789 1/30/2019 La Banque Bank Loan Payment 2/28/2019 La Banque Bank Loan Payment 3/31/2019 La Banque Bank Loan Payment 4/30/2019 La Banque Bank Loan Payment 5/anni Rani Rankinan Daumant 32 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 15200 16100 21000 21000 21000 21000 21 33 34 35 36 37 26400.00 DR -23942.00 -251.58 -251.58 -251.58 -251.58 -7519 42 Shooti Sheet2 Sheets File Edit View Insert Format Data Tools Add-ons Help Last edit was made 3 days ago by barbi bordas 100% - $ .00 123 Default (Ca... - 11 - BISA fx 8/24/2019 A B D E F G 42 43 45 46 -251.58 -251.58 -251.58 -251.58 -251.58 -251.59 -251.59 -251.59 -251.59 47 48 49 50 51 4/30/2019 La Banque Bank Loan Payment 5/30/2019 La Banque Bank Loan Payment 6/30/2019 La Banque Bank Loan Payment 7/30/2019 La Banque Bank Loan Payment 8/30/2019 La Banque Bank Loan Payment 9/30/2019 La Banque Bank Loan Payment 10/30/2019 La Banque Bank Loan Payment 11/30/2019 La Banque Bank Loan Payment 12/30/2019 La Banque Bank Loan Payment 11/16/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 1/20/2019 Check #794 4/17/2019 Check #832 7/16/2019 Check #859 10/18/2019 Check #893 1/17/2019 Deposit - SQUARE 2/2/2019 Deposit - SQUARE 3/18/2019 Deposit - SQUARE 3/28/2019 Deposit - SQUARE 3/31/2019 Deposit - SQUARE 52 21000 21000 21000 21000 21000 21000 21000 21000 21000 22000 31000 31000 33000 33000 33000 33000 41000 41000 41000 41000 41000 3215.00 15000 15000 53 54 55 -3428.75 -3428.75 -3428.75 -3428.75 56 57 58 59 60 47853.12 12587.10 98223.45 35125.99 120118.95 61 62 Tonga 6 Alanna nannet COLARE Cho1 Sheet2 Sheet3 fx 8/24/2019 B D G E F 63 64 65 66 67 68 69 70 71 190998.74 50125.44 60125.12 10225.36 186142.22 211856.80 151221.11 324666.90 164448.11 40887.22 7091.37 900.00 900.00 900.00 900.00 991.50 1050.00 991.50 72 4/20/2019 Deposit - SQUARE 4/25/2019 Deposit - SQUARE 5/3/2019 Deposit - SQUARE 5/6/2019 Deposit - SQUARE 5/29/2019 Deposit - SQUARE 6/20/2019 Deposit - SQUARE 7/21/2019 Deposit - SQUARE 9/5/2019 Deposit - SQUARE 10/13/2019 Deposit - SQUARE 11/5/2019 Deposit - SQUARE 12/26/2019 Deposit - SQUARE 1/22/2019 DEPOSIT - CHECK 4/27/2019 DEPOSIT - CHECK 7/16/2019 DEPOSIT - CHECK 10/28/2019 DEPOSIT - CHECK 1/12/2019 DEPOSIT - CHECK 6/15/2019 DEPOSIT - CHECK 7/10/2019 DEPOSIT - CHECK 1/23/2019 Check #796 2/27/2019 Check #808 3/29/2019 Check #826 Alhonno Chan 096 73 41000 41000 41000 41000 41000 41000 41000 41000 41000 41000 41000 45000 45000 45000 45000 46000 46000 46000 51000 51000 51000 51 74 75 76 77 78 79 80 81 62 -14025.69 -20022.10 - 16785.20 1905 on Sheet1 - Sheet2 Sheet3 - 100% - $ % ro .00 123 Default (Ca. BISA fx 8/24/2019 B D E F G 83 51000 84 85 51000 51000 B6 87 88 51000 51000 51000 51000 89 90 91 92 93 3/29/2019 Check #826 4/28/2019 Check #836 5/27/2019 Check #846 6/26/2019 Check #852 7/26/2019 Check #864 8/25/2019 Check #873 9/26/2019 Check #886 10/27/2019 Check #898 11/27/2019 Check #910 12/20/2019 Check 1919 1/12/2019 Boutsiokos Repairs and Maintenanc 1/20/2019 Adrian Plumbing 2/5/2019 Nichols Equipment Maintenance 2/19/2019 Boutsiokos Repairs and Maintenance 3/10/2019 Boutsiokos Repairs and Maintenance 4/4/2019 Boutsiokos Repairs and Maintenant 4/17/2019 Nichols Equipment Maintenance 5/5/2019 Boutsiokos Repairs and Maintenanc 6/5/2019 Boutsiokos Repairs and Maintenano 7/8/2019 Boutsiokos Repairs and Maintenance 7/18/2019 Adrian Plumbing olanto O DAR AMARA -16785.20 -13025.80 -14157.25 -15875.82 -14131.14 - 16587.12 -12111.81 -15036.22 -10998.15 -9130.70 - 125.00 -74.85 -187.44 - 161.73 -88.73 -152.11 -685,48 -76.32 -185.11 -25.12 -169.22 1941 94 95 96 97 51000 51000 51000 52100 52100 52100 52100 52100 52100 52100 52100 52100 52100 52100 E 98 99 100 100 102 100 Sheet1 - Sheet2 Shoot Type here to search O % 06 123 Default (Ca.. 11 BISA . 141 ilil fx 8/24/2019 A D E F G 104 105 106 107 108 109 110 111 112 113 114 8/6/2019 Boutsiokos Repairs and Maintenance 8/16/2019 Nichols Equipment Maintenance 9/4/2019 Boutsiokos Repairs and Maintenano 10/20/2019 Boutsiokos Repairs and Maintenano 11/13/2019 Boutsiokos Repairs and Maintenance 11/24/2019 Nichols Equipment Maintenance 12/8/2019 Boutsiokos Repairs and Maintenanc 2/2/2019 Adams Property Tax Collection 6/29/2019 Federal Payroll Tax Dept 3/18/2019 SUNBIZ LLC RENEWAL 1/4/2019 Federal Unemployment 1/6/2019 Florida Unemployment Department 4/11/2019 Federal Payroll Tax Dept 4/12/2019 Florida Unemployment Department 7/5/2019 Florida Unemployment Department 10/7/2019 Florida Unemployment Department 10/22/2019 Federal Payroll Tax Dept 11/2/2019 Federal Payroll Tax Dept 12/5/2019 Federal Payroll Tax Dept 1/9/2019 FB Advertising 1/26/2019 GOOGLE" Adwords -12.41 -878.41 -53.74 - 112.41 -105.11 -784.11 -159.99 -4000.00 -2131.56 -161.01 -587.25 -26.75 -3265.57 10.75 -52.11 -45.78 -1546.78 -985.21 -1055.02 -1758.44 -878.80 1007 CE 52100 52100 52100 52100 52100 52100 52100 52200 52200 52300 52400 52400 52400 52400 52400 52400 52400 52400 52400 52700 52700 115 116 117 118 119 120 121 122 123 124 175 hatan And 52 + IN Sheet1 Sheet2 Sheet3 A B D E F co 124 52700 125 52700 126 127 128 -878.80 -1087.55 -781.24 -1056.21 -157.21 -1048.08 -648.22 -988.22 -490.85 -124.55 129 130 131 132 133 134 135 1/26/2019 GOOGLE* Adwords 2/4/2019 GOOGLE Adwords 2/8/2019 FB Advertising 3/4/2019 FB Advertising 3/17/2019 GOOGLE* Adwords 4/14/2019 GOOGLE* Adwords 5/13/2019 FB Advertising 5/23/2019 GOOGLE* Adwords 6/28/2019 GOOGLE* Adwords 7/2/2019 FB Advertising 7/26/2019 GOOGLE* Adwords 8/22/2019 GOOGLE* Adwords 8/30/2019 FB Advertising 9/18/2019 GOOGLE* Adwords 10/5/2019 FB Advertising 10/7/2019 GOOGLE" Adwords 11/24/2019 GOOGLE" Adwords 12/26/2019 FB Advertising 1/6/2019 Insurance Co. 1/30/2019 Insurance Co. 2/27/2019 Insurance Co. Alan10 Iran 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 136 137 138 139 -107.98 -1027.28 -1425.66 -1500.00 -857.55 -1154.82 -1875.15 -765.19 -550.00 -550.00 -550.00 140 141 52700 52700 52700 52700 52800 52800 52800 142 143 cen on + Sheet1 - Sheet2 Sheet3 fx 8/24/2019 B D E F 145 146 52800 52800 52800 52800 147 148 149 150 151 52800 52800 52800 52800 52800 52800 152 153 154 4/6/2019 Insurance Co. 4/30/2019 Insurance Co. 5/25/2019 Insurance Co. 6/21/2019 Insurance Co. 7/24/2019 Insurance Co. 8/22/2019 Insurance Co. 9/19/2019 Insurance Co. 10/10/2019 Insurance Co. 11/7/2019 Insurance Co. 12/16/2019 Insurance Co. 1/19/2019 FPL 1/20/2019 SL Water and Trash 2/16/2019 FPL 2/19/2019 SL Water and Trash 3/18/2019 FPL 3/20/2019 SL Water and Trash 4/2/2019 FPL 4/3/2019 SL Water and Trash 5/14/2019 FPL 5/16/2019 SL Water and Trash 6/26/2019 FPL -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -900.00 -98.12 -50.41 - 190.55 -82.12 -180.78 -43.12 -250.11 -86.94 -166.85 -95.67 -178.12 155 156 157 158 159 160 52900 52900 52900 52900 52900 52900 52900 52900 52900 52900 52900 som 16 162 163 164 165 to CH RAFAT 756 Sheet1 Sheet2 Sheet3 23 D 2 LE . -- LE = fx 8/24/2019 B D E G 165 -178.12 166 167 168 52900 52900 52900 52900 52900 52900 52900 52900 -74.55 -150.42 -95.22 -162.25 -120.66 -129.99 -84.61 169 170 171 172 173 174 175 6/26/2019 FPL 7/2/2019 SL Water and Trash 7/31/2019 FPL 8/8/2019 SL Water and Trash 8/25/2019 FPL 9/2/2019 SL Water and Trash 9/24/2019 FPL 9/27/2019 SL Water and Trash 10/22/2019 FPL 10/25/2019 SL Water and Trash 11/14/2019 FPL 11/22/2019 SL Water and Trash 12/20/2019 FPL 12/20/2019 SL. Water and Trash 1/31/2019 Stant Travel Services 3/18/2019 Stant Travel Services 4/28/2019 Stant Travel Services 5/20/2019 Adams Cruise and Air 5/31/2019 Stant Travel Services 6/29/2019 Stant Travel Services 7/12/2019 Adams Cruise and Air anio Cent Tmn Cantina 176 177 178 179 180 - 105.22 -85.45 -100.02 -94.12 -198.55 -51.15 -357.44 -248.99 -50.00 -2400,00 -298.23 -233.39 -5385.34 3400 52900 52900 52900 52900 52900 52900 53000 53000 53000 53000 53000 53000 53000 son 181 182 183 104 18 TE Sheet1 - Sheet2 Shoot3 B D E F 185 53000 186 -5385.34 -349.87 -698.99 187 53000 53000 188 189 53000 53000 190 53000 191 192 53000 53000 193 194 195 7/12/2019 Adams Cruise and Air 7/23/2019 Stant Travel Services 8/25/2019 Stant Travel Services 9/5/2019 Adams Cruise and Air 9/26/2019 Stant Travel Services 10/22/2019 Stant Travel Services 11/21/2019 Stant Travel Services 12/18/2019 Stant Travel Services 12/23/2019 Adams Cruise and Air 1/29/2019 Staples 2/11/2019 ELOAP, CPAS 2/22/2019 Mimi Cleaning 3/1/2019 Handyman RUS 3/10/2019 Handyman R Us 3/21/2019 Staples 4/14/2019 Mimi Cleaning 5/3/2019 ELOAP, CPAS 5/11/2019 Staples 6/2/2019 Mimi Cleaning 6/18/2019 ELOAP, CPAS 6/21/2019 Handyman R Us 196 - 1904.50 -356.98 -122.10 -84.23 -187.88 -7502.06 - 120.58 - 1900.00 -250.00 -9785.48 - 112.59 -86.12 350.00 -1600.00 -500.42 -350.00 -800.00 - 172.70 70 GA 53000 53100 53100 53100 53100 53100 53100 53100 197 198 199 200 201 202 203 53100 53100 53100 53100 53100 204 205 2 na Chan Sheet1 - Shoot2 - Shoots- Type here to search :D 8/24/2019 B E F G 205 206 53100 53100 207 208 53100 53100 209 210 211 212 213 214 215 216 6/21/2019 Handyman R Us 7/1/2019 Staples 7/26/2019 ELOAP, CPAS 8/1/2019 City of Orlando Tax Office 8/19/2019 Mimi Cleaning 8/19/2019 Staples 9/2/2019 ELOAP, CPAS 9/19/2019 Handyman RUS 9/29/2019 Staples 10/7/2019 ELOAP, CPAS 10/10/2019 Mimi Cleaning 11/4/2019 Handyman RUS 11/5/2019 Staples 11/16/2019 ELOAP, CPAS 12/2/2019 Mimi Cleaning 12/3/2019 Handyman RUS 12/10/2019 ELOAP, CPAS 12/11/2019 Staples 7/12/2019 Check #857 12/31/2019 Check #921 2/22/2019 St. Jude's Hospital -172.70 -758.54 -800.00 -38.99 -350.00 -124.12 -800.00 -26.75 -254.12 -800.00 -350.00 -300.12 -215.99 -790.00 -350.00 -99.99 -800.00 -212.11 -6000.00 -6000.00 -1000.00 217 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 54000 54000 55000 218 219 220 221 222 223 224 225 225 slnlnnio ct want tornital 55 Sheet1 - Sheet2 Shoot3 fx 8/24/2019 B D E F G 226 55000 227 -1000.00 -1000.00 228 55000 55000 229 230 231 232 233 234 235 236 237 238 3/4/2019 St. Jude's Hospital 3/31/2019 St. Jude's Hospital 4/19/2019 St. Jude's Hospital 5/6/2019 St. Jude's Hospital 6/7/2019 St. Jude's Hospital 7/14/2019 St. Jude's Hospital 8/11/2019 St. Jude's Hospital 9/13/2019 St. Jude's Hospital 9/29/2019 St. Jude's Hospital 11/5/2019 St. Jude's Hospital 12/8/2019 St. Jude's Hospital 2/16/2019 Brent Myer, Attorney 2/6/2019 Federal Payroll Tax Dept 3/15/2019 Check #818 6/15/2019 Check #850 9/15/2019 Check #881 12/15/2019 Check 914 12/31/2019 Check #920 1/29/2019 The Payroll People 2/13/2019 Placeholder Company 2/16/2019 Placeholder Company 10 Thinnin -1000.00 -1000.00 -1000.00 - 1000.00 - 1000.00 -1000.00 - 1000.00 -1000.00 -1000.00 -900.00 -1681.22 1450.00 -1450.00 -1450.00 -1450.00 -1000.00 -9405.55 -485.42 -11245.12 55000 55000 55000 55000 55000 55000 55000 55000 56000 57000 57000 57000 57000 57000 57000 50000 50000 50000 ch 239 240 241 242 243 246 Sheet1 - Shoot2 Shoot i Tune here to search d. a 246 50000 247 248 249 250 50000 50000 50000 50000 50000 50000 50000 251 252 253 254 255 256 2/16/2019 Placeholder Company 3/7/2019 Triana Wolf Leasing 3/30/2019 The Payroll People 4/30/2019 The Payroll People 5/11/2019 Placeholder Company 5/17/2019 Placeholder Company 5/31/2019 The Payroll People 6/15/2019 Triana Wolf Leasing 6/29/2019 The Payroll People 7/29/2019 The Payroll People 8/6/2019 Placeholder Company 8/30/2019 The Payroll People 9/12/2019 Placeholder Company 9/21/2019 Triana Wolf Leasing 9/29/2019 The Payroll People 10/18/2019 Placeholder Company 10/28/2019 The Payroll People 11/11/2019 Placeholder Company 11/30/2019 The Payroll People 12/25/2019 Triana Wolf Leasing 12/30/2019 The Payroll People -11245.12 -4000.00 -8152.25 -8422.45 -7851.15 -10447.57 -9575.45 -4000.00 -10484.99 - 15744.11 -4000.00 -9485.84 -9855.21 -4000.00 -8453.54 -6000.00 -5485.52 -4656.09 -5785.84 -4000.00 -12078.98 257 258 259 260 261 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 252 263 264 265 266 25 + Sheetl - Sheet2 Sheet3 - Type here to search O a -1767969.00 1777945.00 References Mailings Review View Help can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 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 - SLO 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 o Paragraph Styles Corporate Tax Return Instructions 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 2019TransactionList.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 2019TransactionList.xlsx and your accrual income statement 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 f a File Edit View Insert Format Data Tools Add-ons Help Last edit was made 3 days ago by barbi bordas % 0.00 123- Default (Ca... 11 - BIGA O. B- na 100% - $ fx 8/24/2019 A B D E F G 1 2. 14100 14100 14100 14100 3 5 6 7 8 9 10 11 1/6/2019 Fabric Liquidators 1/9/2019 Thread Bare LLC 1/17/2019 Carlson Craft Supplies 1/20/2019 Thread Bare LLC 1/23/2019 Howse Fabrics 2/14/2019 Reap Reams of Fabric 3/2/2019 Thread Bare LLC 3/4/2019 Thread Bare LLC 3/24/2019 Fabric Liquidators 4/20/2019 Fabric Liquidators 5/14/2019 Carlson Craft Supplies 6/8/2019 Thread Bare LLC 6/10/2019 Fabric Liquidators 6/13/2019 Carlson Craft Supplies 7/15/2019 Thread Bare LLC 7/23/2019 Thread Bare LLC 7/29/2019 Fabric Liquidators 8/9/2019 Carlson Craft Supplies 8/9/2019 Doxie Threads 8/14/2019 Howse Fabrics 8/19/2019 Thread Bare LLC 8/24/2019 Thread Bare LLC -27622.20 -57146.64 -35362.31 -92913.12 -6000.49 -20124.58 -660.00 - 11742.58 -193.21 -3874.50 -5721.24 -102557.73 -67626.44 -94464.66 -68943.36 -62976.07 -96782.11 -32913.12 -52913.12 -27116.79 -48413.11 -4871.22 12 13 14 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 15 16 10 19 20 ERR Sheet1 Sheet2 Sheet3 81241 B D F G H 22 23 24 25 26 27 28 29 30 -4871.22 -46143.36 -40515.11 -81233.44 -485.54 - 15744.11 -78472.86 - 14896.25 -2435.61 - 12560.11 11770.93 -11052.85 -3255.43 -1007.55 -18596.25 31 8/24/2019 Thread Bare LLC 9/2/2019 Carlson Craft Supplies 9/2/2019 Fabric Liquidators 9/15/2019 Howse Fabrics 10/2/2019 Carlson Craft Supplies 10/4/2019 Thread Bare LLC 10/13/2019 Howse Fabrics 10/25/2019 Fabric Liquidators 11/5/2019 Thread Bare LLC 11/8/2019 Howse Fabrics 11/30/2019 Doxie Threads 12/5/2019 Thread Bare LLC 12/11/2019 Doxie Threads 12/26/2019 Doxie Threads 12/31/2019 Howse Fabrics 3/14/2019 DEPOSIT - CHECK 1/11/2019 Check #789 1/30/2019 La Banque Bank Loan Payment 2/28/2019 La Banque Bank Loan Payment 3/31/2019 La Banque Bank Loan Payment 4/30/2019 La Banque Bank Loan Payment 5/anni Rani Rankinan Daumant 32 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 14100 15200 16100 21000 21000 21000 21000 21 33 34 35 36 37 26400.00 DR -23942.00 -251.58 -251.58 -251.58 -251.58 -7519 42 Shooti Sheet2 Sheets File Edit View Insert Format Data Tools Add-ons Help Last edit was made 3 days ago by barbi bordas 100% - $ .00 123 Default (Ca... - 11 - BISA fx 8/24/2019 A B D E F G 42 43 45 46 -251.58 -251.58 -251.58 -251.58 -251.58 -251.59 -251.59 -251.59 -251.59 47 48 49 50 51 4/30/2019 La Banque Bank Loan Payment 5/30/2019 La Banque Bank Loan Payment 6/30/2019 La Banque Bank Loan Payment 7/30/2019 La Banque Bank Loan Payment 8/30/2019 La Banque Bank Loan Payment 9/30/2019 La Banque Bank Loan Payment 10/30/2019 La Banque Bank Loan Payment 11/30/2019 La Banque Bank Loan Payment 12/30/2019 La Banque Bank Loan Payment 11/16/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 12/31/2019 DEPOSIT - CHECK 1/20/2019 Check #794 4/17/2019 Check #832 7/16/2019 Check #859 10/18/2019 Check #893 1/17/2019 Deposit - SQUARE 2/2/2019 Deposit - SQUARE 3/18/2019 Deposit - SQUARE 3/28/2019 Deposit - SQUARE 3/31/2019 Deposit - SQUARE 52 21000 21000 21000 21000 21000 21000 21000 21000 21000 22000 31000 31000 33000 33000 33000 33000 41000 41000 41000 41000 41000 3215.00 15000 15000 53 54 55 -3428.75 -3428.75 -3428.75 -3428.75 56 57 58 59 60 47853.12 12587.10 98223.45 35125.99 120118.95 61 62 Tonga 6 Alanna nannet COLARE Cho1 Sheet2 Sheet3 fx 8/24/2019 B D G E F 63 64 65 66 67 68 69 70 71 190998.74 50125.44 60125.12 10225.36 186142.22 211856.80 151221.11 324666.90 164448.11 40887.22 7091.37 900.00 900.00 900.00 900.00 991.50 1050.00 991.50 72 4/20/2019 Deposit - SQUARE 4/25/2019 Deposit - SQUARE 5/3/2019 Deposit - SQUARE 5/6/2019 Deposit - SQUARE 5/29/2019 Deposit - SQUARE 6/20/2019 Deposit - SQUARE 7/21/2019 Deposit - SQUARE 9/5/2019 Deposit - SQUARE 10/13/2019 Deposit - SQUARE 11/5/2019 Deposit - SQUARE 12/26/2019 Deposit - SQUARE 1/22/2019 DEPOSIT - CHECK 4/27/2019 DEPOSIT - CHECK 7/16/2019 DEPOSIT - CHECK 10/28/2019 DEPOSIT - CHECK 1/12/2019 DEPOSIT - CHECK 6/15/2019 DEPOSIT - CHECK 7/10/2019 DEPOSIT - CHECK 1/23/2019 Check #796 2/27/2019 Check #808 3/29/2019 Check #826 Alhonno Chan 096 73 41000 41000 41000 41000 41000 41000 41000 41000 41000 41000 41000 45000 45000 45000 45000 46000 46000 46000 51000 51000 51000 51 74 75 76 77 78 79 80 81 62 -14025.69 -20022.10 - 16785.20 1905 on Sheet1 - Sheet2 Sheet3 - 100% - $ % ro .00 123 Default (Ca. BISA fx 8/24/2019 B D E F G 83 51000 84 85 51000 51000 B6 87 88 51000 51000 51000 51000 89 90 91 92 93 3/29/2019 Check #826 4/28/2019 Check #836 5/27/2019 Check #846 6/26/2019 Check #852 7/26/2019 Check #864 8/25/2019 Check #873 9/26/2019 Check #886 10/27/2019 Check #898 11/27/2019 Check #910 12/20/2019 Check 1919 1/12/2019 Boutsiokos Repairs and Maintenanc 1/20/2019 Adrian Plumbing 2/5/2019 Nichols Equipment Maintenance 2/19/2019 Boutsiokos Repairs and Maintenance 3/10/2019 Boutsiokos Repairs and Maintenance 4/4/2019 Boutsiokos Repairs and Maintenant 4/17/2019 Nichols Equipment Maintenance 5/5/2019 Boutsiokos Repairs and Maintenanc 6/5/2019 Boutsiokos Repairs and Maintenano 7/8/2019 Boutsiokos Repairs and Maintenance 7/18/2019 Adrian Plumbing olanto O DAR AMARA -16785.20 -13025.80 -14157.25 -15875.82 -14131.14 - 16587.12 -12111.81 -15036.22 -10998.15 -9130.70 - 125.00 -74.85 -187.44 - 161.73 -88.73 -152.11 -685,48 -76.32 -185.11 -25.12 -169.22 1941 94 95 96 97 51000 51000 51000 52100 52100 52100 52100 52100 52100 52100 52100 52100 52100 52100 E 98 99 100 100 102 100 Sheet1 - Sheet2 Shoot Type here to search O % 06 123 Default (Ca.. 11 BISA . 141 ilil fx 8/24/2019 A D E F G 104 105 106 107 108 109 110 111 112 113 114 8/6/2019 Boutsiokos Repairs and Maintenance 8/16/2019 Nichols Equipment Maintenance 9/4/2019 Boutsiokos Repairs and Maintenano 10/20/2019 Boutsiokos Repairs and Maintenano 11/13/2019 Boutsiokos Repairs and Maintenance 11/24/2019 Nichols Equipment Maintenance 12/8/2019 Boutsiokos Repairs and Maintenanc 2/2/2019 Adams Property Tax Collection 6/29/2019 Federal Payroll Tax Dept 3/18/2019 SUNBIZ LLC RENEWAL 1/4/2019 Federal Unemployment 1/6/2019 Florida Unemployment Department 4/11/2019 Federal Payroll Tax Dept 4/12/2019 Florida Unemployment Department 7/5/2019 Florida Unemployment Department 10/7/2019 Florida Unemployment Department 10/22/2019 Federal Payroll Tax Dept 11/2/2019 Federal Payroll Tax Dept 12/5/2019 Federal Payroll Tax Dept 1/9/2019 FB Advertising 1/26/2019 GOOGLE" Adwords -12.41 -878.41 -53.74 - 112.41 -105.11 -784.11 -159.99 -4000.00 -2131.56 -161.01 -587.25 -26.75 -3265.57 10.75 -52.11 -45.78 -1546.78 -985.21 -1055.02 -1758.44 -878.80 1007 CE 52100 52100 52100 52100 52100 52100 52100 52200 52200 52300 52400 52400 52400 52400 52400 52400 52400 52400 52400 52700 52700 115 116 117 118 119 120 121 122 123 124 175 hatan And 52 + IN Sheet1 Sheet2 Sheet3 A B D E F co 124 52700 125 52700 126 127 128 -878.80 -1087.55 -781.24 -1056.21 -157.21 -1048.08 -648.22 -988.22 -490.85 -124.55 129 130 131 132 133 134 135 1/26/2019 GOOGLE* Adwords 2/4/2019 GOOGLE Adwords 2/8/2019 FB Advertising 3/4/2019 FB Advertising 3/17/2019 GOOGLE* Adwords 4/14/2019 GOOGLE* Adwords 5/13/2019 FB Advertising 5/23/2019 GOOGLE* Adwords 6/28/2019 GOOGLE* Adwords 7/2/2019 FB Advertising 7/26/2019 GOOGLE* Adwords 8/22/2019 GOOGLE* Adwords 8/30/2019 FB Advertising 9/18/2019 GOOGLE* Adwords 10/5/2019 FB Advertising 10/7/2019 GOOGLE" Adwords 11/24/2019 GOOGLE" Adwords 12/26/2019 FB Advertising 1/6/2019 Insurance Co. 1/30/2019 Insurance Co. 2/27/2019 Insurance Co. Alan10 Iran 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 52700 136 137 138 139 -107.98 -1027.28 -1425.66 -1500.00 -857.55 -1154.82 -1875.15 -765.19 -550.00 -550.00 -550.00 140 141 52700 52700 52700 52700 52800 52800 52800 142 143 cen on + Sheet1 - Sheet2 Sheet3 fx 8/24/2019 B D E F 145 146 52800 52800 52800 52800 147 148 149 150 151 52800 52800 52800 52800 52800 52800 152 153 154 4/6/2019 Insurance Co. 4/30/2019 Insurance Co. 5/25/2019 Insurance Co. 6/21/2019 Insurance Co. 7/24/2019 Insurance Co. 8/22/2019 Insurance Co. 9/19/2019 Insurance Co. 10/10/2019 Insurance Co. 11/7/2019 Insurance Co. 12/16/2019 Insurance Co. 1/19/2019 FPL 1/20/2019 SL Water and Trash 2/16/2019 FPL 2/19/2019 SL Water and Trash 3/18/2019 FPL 3/20/2019 SL Water and Trash 4/2/2019 FPL 4/3/2019 SL Water and Trash 5/14/2019 FPL 5/16/2019 SL Water and Trash 6/26/2019 FPL -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -550.00 -900.00 -98.12 -50.41 - 190.55 -82.12 -180.78 -43.12 -250.11 -86.94 -166.85 -95.67 -178.12 155 156 157 158 159 160 52900 52900 52900 52900 52900 52900 52900 52900 52900 52900 52900 som 16 162 163 164 165 to CH RAFAT 756 Sheet1 Sheet2 Sheet3 23 D 2 LE . -- LE = fx 8/24/2019 B D E G 165 -178.12 166 167 168 52900 52900 52900 52900 52900 52900 52900 52900 -74.55 -150.42 -95.22 -162.25 -120.66 -129.99 -84.61 169 170 171 172 173 174 175 6/26/2019 FPL 7/2/2019 SL Water and Trash 7/31/2019 FPL 8/8/2019 SL Water and Trash 8/25/2019 FPL 9/2/2019 SL Water and Trash 9/24/2019 FPL 9/27/2019 SL Water and Trash 10/22/2019 FPL 10/25/2019 SL Water and Trash 11/14/2019 FPL 11/22/2019 SL Water and Trash 12/20/2019 FPL 12/20/2019 SL. Water and Trash 1/31/2019 Stant Travel Services 3/18/2019 Stant Travel Services 4/28/2019 Stant Travel Services 5/20/2019 Adams Cruise and Air 5/31/2019 Stant Travel Services 6/29/2019 Stant Travel Services 7/12/2019 Adams Cruise and Air anio Cent Tmn Cantina 176 177 178 179 180 - 105.22 -85.45 -100.02 -94.12 -198.55 -51.15 -357.44 -248.99 -50.00 -2400,00 -298.23 -233.39 -5385.34 3400 52900 52900 52900 52900 52900 52900 53000 53000 53000 53000 53000 53000 53000 son 181 182 183 104 18 TE Sheet1 - Sheet2 Shoot3 B D E F 185 53000 186 -5385.34 -349.87 -698.99 187 53000 53000 188 189 53000 53000 190 53000 191 192 53000 53000 193 194 195 7/12/2019 Adams Cruise and Air 7/23/2019 Stant Travel Services 8/25/2019 Stant Travel Services 9/5/2019 Adams Cruise and Air 9/26/2019 Stant Travel Services 10/22/2019 Stant Travel Services 11/21/2019 Stant Travel Services 12/18/2019 Stant Travel Services 12/23/2019 Adams Cruise and Air 1/29/2019 Staples 2/11/2019 ELOAP, CPAS 2/22/2019 Mimi Cleaning 3/1/2019 Handyman RUS 3/10/2019 Handyman R Us 3/21/2019 Staples 4/14/2019 Mimi Cleaning 5/3/2019 ELOAP, CPAS 5/11/2019 Staples 6/2/2019 Mimi Cleaning 6/18/2019 ELOAP, CPAS 6/21/2019 Handyman R Us 196 - 1904.50 -356.98 -122.10 -84.23 -187.88 -7502.06 - 120.58 - 1900.00 -250.00 -9785.48 - 112.59 -86.12 350.00 -1600.00 -500.42 -350.00 -800.00 - 172.70 70 GA 53000 53100 53100 53100 53100 53100 53100 53100 197 198 199 200 201 202 203 53100 53100 53100 53100 53100 204 205 2 na Chan Sheet1 - Shoot2 - Shoots- Type here to search :D 8/24/2019 B E F G 205 206 53100 53100 207 208 53100 53100 209 210 211 212 213 214 215 216 6/21/2019 Handyman R Us 7/1/2019 Staples 7/26/2019 ELOAP, CPAS 8/1/2019 City of Orlando Tax Office 8/19/2019 Mimi Cleaning 8/19/2019 Staples 9/2/2019 ELOAP, CPAS 9/19/2019 Handyman RUS 9/29/2019 Staples 10/7/2019 ELOAP, CPAS 10/10/2019 Mimi Cleaning 11/4/2019 Handyman RUS 11/5/2019 Staples 11/16/2019 ELOAP, CPAS 12/2/2019 Mimi Cleaning 12/3/2019 Handyman RUS 12/10/2019 ELOAP, CPAS 12/11/2019 Staples 7/12/2019 Check #857 12/31/2019 Check #921 2/22/2019 St. Jude's Hospital -172.70 -758.54 -800.00 -38.99 -350.00 -124.12 -800.00 -26.75 -254.12 -800.00 -350.00 -300.12 -215.99 -790.00 -350.00 -99.99 -800.00 -212.11 -6000.00 -6000.00 -1000.00 217 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 53100 54000 54000 55000 218 219 220 221 222 223 224 225 225 slnlnnio ct want tornital 55 Sheet1 - Sheet2 Shoot3 fx 8/24/2019 B D E F G 226 55000 227 -1000.00 -1000.00 228 55000 55000 229 230 231 232 233 234 235 236 237 238 3/4/2019 St. Jude's Hospital 3/31/2019 St. Jude's Hospital 4/19/2019 St. Jude's Hospital 5/6/2019 St. Jude's Hospital 6/7/2019 St. Jude's Hospital 7/14/2019 St. Jude's Hospital 8/11/2019 St. Jude's Hospital 9/13/2019 St. Jude's Hospital 9/29/2019 St. Jude's Hospital 11/5/2019 St. Jude's Hospital 12/8/2019 St. Jude's Hospital 2/16/2019 Brent Myer, Attorney 2/6/2019 Federal Payroll Tax Dept 3/15/2019 Check #818 6/15/2019 Check #850 9/15/2019 Check #881 12/15/2019 Check 914 12/31/2019 Check #920 1/29/2019 The Payroll People 2/13/2019 Placeholder Company 2/16/2019 Placeholder Company 10 Thinnin -1000.00 -1000.00 -1000.00 - 1000.00 - 1000.00 -1000.00 - 1000.00 -1000.00 -1000.00 -900.00 -1681.22 1450.00 -1450.00 -1450.00 -1450.00 -1000.00 -9405.55 -485.42 -11245.12 55000 55000 55000 55000 55000 55000 55000 55000 56000 57000 57000 57000 57000 57000 57000 50000 50000 50000 ch 239 240 241 242 243 246 Sheet1 - Shoot2 Shoot i Tune here to search d. a 246 50000 247 248 249 250 50000 50000 50000 50000 50000 50000 50000 251 252 253 254 255 256 2/16/2019 Placeholder Company 3/7/2019 Triana Wolf Leasing 3/30/2019 The Payroll People 4/30/2019 The Payroll People 5/11/2019 Placeholder Company 5/17/2019 Placeholder Company 5/31/2019 The Payroll People 6/15/2019 Triana Wolf Leasing 6/29/2019 The Payroll People 7/29/2019 The Payroll People 8/6/2019 Placeholder Company 8/30/2019 The Payroll People 9/12/2019 Placeholder Company 9/21/2019 Triana Wolf Leasing 9/29/2019 The Payroll People 10/18/2019 Placeholder Company 10/28/2019 The Payroll People 11/11/2019 Placeholder Company 11/30/2019 The Payroll People 12/25/2019 Triana Wolf Leasing 12/30/2019 The Payroll People -11245.12 -4000.00 -8152.25 -8422.45 -7851.15 -10447.57 -9575.45 -4000.00 -10484.99 - 15744.11 -4000.00 -9485.84 -9855.21 -4000.00 -8453.54 -6000.00 -5485.52 -4656.09 -5785.84 -4000.00 -12078.98 257 258 259 260 261 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 50000 252 263 264 265 266 25 + Sheetl - Sheet2 Sheet3 - Type here to search O a -1767969.00 1777945.00 References Mailings Review View Help can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing 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 - SLO 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 o

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Integrated Audit Practice Case

Authors: David S. Kerr, Randal J. Elder, Alvin A. Arens

7th Edition

0912503688, 978-0912503684

More Books

Students also viewed these Accounting questions

Question

1 . What is logistics and what does someone in logistics do ?

Answered: 1 week ago

Question

Identify traditional external recruitment methods.

Answered: 1 week ago

Question

Describe alternatives to recruitment.

Answered: 1 week ago