How to create a Financial Statements for this account?
0 1 T-Mobile Wi-Fi 1:08 AM @ 95% Journal entries, T Accounts and Trial balance :- Sweaty Bands, Inc. Journal Entries N-Date Account N 1 2. Jan Debit Credit Calculation Account No entry 22-Jan 25,000.00 10000 Cash 39003 Common Stock 25,000.00 33-Jan 3,200.00 Jan to April 18000 Prepaid Rent 10000 Cash 3,200.00 43-Jan 1,800.00 6 months 18100 Prepaid insurance 10000 Cash 1,800.00 53-Jan 10,000.00 15000 Store & Office Equipment 21200 Note Payable - Store & Office Supply 4 years & 2,000 residual 10,000.00 1 yr 6% note 65-Jan 7,000.00 6 mnth, 6% note 10000 Cash 21100 Note Payable - Wells Fargo Bank 7,000.00 7 5-Jan 13,000.00 5 years & 1,000 residual 15100 Furniture & Fixtures 10000 Cash 13,000.00 6-Jan 900.00 3 years 15200 Computer Equipment 10000 Cash 900.00 96-Jan 300.00 13100 Office Supplies 10000 Cash 300.00 10 8-Jan 11,000.00 12000 Inventory - Orange Headbands 20000 Account Payable 11,000.00 11 8-Jan 12100 Inventory. Blue Headbands 20000 Account Payable 5,000.00 5,000.00 12 13-Jan 350.00 60100 Legal expense 10000 Cash 350.00 13 13-Jan No entry 8.25% sales tax 14 13-Jan 8,000.00 8,000.00 11000 Account Receivable 40000 Sales 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 4,000.00 2,500.00 1,500.00 15 14-Jan 200.00 13200 Store Supplies 20000 Account Payable 200.00 16 14-Jan 12000 Inventory - Orange Headbands 20000 Account Payable 5,500.00 5,500.00 17 15-Jan 5,953.75 5,500.00 453.75 5500*8.25% 11000 Account Receivable 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 2,750.00 1,500.00 1,250.00 18 20-Jan 20000 Account Payable 10000 Cash 200.00 200.00 19 22-Jan 5,953.75 10000 Cash 11000 Account Receivable 5,953.75 20 22-Jan 16,000.00 11000+5000 20000 Account Payable 10000 Cash 16,000.00 21 22-Jan 12100 Inventory - Blue Headbands 2,900.00 22 23-Jan 850.00 60500 Advertising and Promotion expense 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 100.00 750.00 23 23-Jan 10000 Cash 8,000.00 21 22-Jon 2,900.00 12100 rventory Headbands 20000 Account Payable 2,900.00 22 23-Jan 850.00 60500 Advertising and Promotion expense 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 100.00 750.00 23 23-Jan 8,000.00 10000 Cash 11000 Account Receivable 8,000.00 24 23-Jan 375.00 60400 Delivery expense 10000 Cash 375.00 25 23-Jan 65.00 13100 Office Supplies 10000 Cash 65.00 26 23-Jan 11,496.15 10,620.00 876.15 10620 8.25% 10000 Cash 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 5,310.00 2,655.00 2,655.00 27 23-Jan 8,400.00 5500*2900 20000 Account Payable 10000 Cash 8,400.00 28 25-Jan 4,580.50 4,300.00 280.50 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 2,150.00 2,000.00 150.00 29 28-Jan 277.23 60550 Utility expense 23400 Utility payable 277.23 30 30-Jan 21200 Note Payable - Store & Office Supply 60700 Interest expense 10000 Cash 833.33 50.00 883.33 31 30-Jan 2,782.03 10000 Cash 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 2,570.00 212.03 1,350.00 350.00 1,000.00 32 30-Jan 1,822.43 453.75+876.15+280.5+212.025 23300 Sales Tax payable 10000 Cash 1,822.43 100.00 100.00 33 31-Jan 39007 Dividends 10000 Cash Adjusting entries No. Date Account No. Account a 31 Jan 60350 Wages expense 23100 Wages payable Credit Debit 1,550.00 1,550.00 b 31-Jan 50.00 200-150 60150 Store Supplies expense 13200 Store Supplies 50.00 31 Jan 322.00 300+65-43 60200 Office Supplies expense 13100 Office Supplies 322.00 d 31-Jan 200.00 =(13,000-1,000)/5*1/12 60650 Depreciation expense 17100 Accumulated Depreciation - Furniture & Fixtures 200.00 e 31-Jan 166.67 60650 Depreciation expense 17000 Accumulated Depreciation - Store & Office Equipment =[10,000-2,000)/4-1/12 166.67 31. Jan 25.00 =900/3*1/12 60650 Depreciation expense 17200 Accumulated Depreciation - Computer equipment 25.00 31-Jan 300.00 =1,800/6 60300 Insurance expense 18100 Prepaid Insurance 300.00 h 31-Jan 800.00 =3,200/4 60600 Rent expense 18000 Prepaid Rent 800.00 i 31-Jan 60700 Interest expense 35.00 =7,000*6%*1/12 35.00 Date Debit Date Credit Accounts Receivable 13-Jan $ 8,000 22-Jan $ 5,954 15-Jan $ 5,954 23-Jan $ 8,000 Sweaty Bands, Inc. T Accounts Date Debit Date Credit Cash 2-Jan $ 25,000 3-Jan $ 3,200 5-Jan $ 7,000 3-Jan $ 1,800 22-Jan $ 5,954 5-Jan $ 13,000 23-Jan $ 8,000 6-Jan $ 900 23-Jan $ 11,496 6-Jan $ 300 25-Jan $ 4,581 13-Jan $ 350 30-Jan $ 2,782 20-Jan $ 200 22-Jan $ 16,000 23-Jan $ 375 23-Jan $ 65 23-Jan $ 8,400 30-Jan $ 883 30-Jan $ 1,822 31-Jan $ 100 Date Debit Date Credit Inventory - Orange Headbands 8-Jan $ 11,000 13-Jan $ 2,500 14-Jan $ 5,500 15-Jan $ 1,500 23-Jan 100.00 23-Jan 2,655.00 25-Jan 2,000.00 30-Jan 350.00 Date Debit Date Credit Inventory - Blue Headbands 8-Jan $ 5,000 13-Jan $ 1,500 22-Jan $ 2,900 15-Jan $ 1,250 23-Jan 750.00 23-Jan 2,655.00 25-Jan 150.00 30-Jan 1,000.00 Bal. $ Bal. Bal. Bal. $ 17,417 Office Supplies 6-Jan $ 300 23-Jan $ 65 31-Jan . Store Supplies 200 31-Jan $ 7,395 Prepaid Rent $ 3,200 31-Jan $ $ 595 Prepaid Insurance $ 1,800 31-Jan $ 14-Jan $ 3-Jan 3-Jan 322.00 50.00 800 300 Bal. Bal. $ 1,500 Bal. $ 43 Store & Office Equipment 3-Jan $10,000 Bal. $ 150 iulated Depreciation - Store & Office Equi 31-Jan $ 167 $ 2,400 Furniture & Fixtures -Jan $ 13,000 5 31-Jan $ 200 Bal. $10,000 Computer Equipment 6-Jan $ 900 Bal. $ 167 imulated Depreciation - Computer equipn 31-Jan $ 25 Bal. $ 200 Note Payable - Wells Fargo Bank 5-Jan $ 7,000 Bal. $13,000 Account Payable 20-Jan $ 200 8-Jan $ 11,000 22-Jan $ 16,000 8-Jan $ 5,000 23-Jan $ 8,400 14-Jan $ 200 14-Jan $ 5,500 22-Jan $ 2,900 S . Bal. 7,000 Bal $ 900 Note Payable - Store & Office Supply 30-Jan $ 833 3-Jan $10,000 $ 25 Wages Payable 31-Jan $ 1,550 Interest Payable 31-Jan $ 35 $ Sales Tax Payable 15-Jan $ 23-Jan $ 25-Jan $ 30-Jan $ 1,822 30-Jan $ 454 876 281 212 $ 35 Bal. $ - Bal. $ 9,167 Utility Payable 28-Jan $ 277 Bal. Retained Earnings Common Stock 2-Jan $ 25,000 31-Jan $ Dividends 100 $ 25,000 Legal expense 350 Bal. $ 100 Store Supplies expense 31-Jan $ 50 13-Jan $ Bal. $ 277 Sales 13-Jan $ 8,000 15-Jan $ 5,500 23-Jan $ 10,620 25-Jan $ 4,300 30-Jan $ 2,570 Bal. Cost of goods sold 13-Jan $ 4,000 15-Jan $ 2,750 23-Jan $ 5,310 25-Jan $ 2,150 30-Jan $ 1,350 Bal. $ 30,990 Office Supplies expense 31-Jan $ 322 Bal. $ 15,560 Insurance expense 31-Jan $ 300 Bal. $ 350 Wages expense 31-Jan $ 1,550 Bal. $ 50 Delivery expense 23-Jan $ 375 Bal. Bal. Bal. $ 322 Advertising and Promotion expense 23-Jan $ 850 $ 300 Utility expense $ 277 $ 1,550 Rent expense $ 800 28-Jan 31-Jan Bal. $ 375 Depreciation expense 31-Jan $ 200 31-Jan $ 167 31-Jan $ 25 Bal. Bal. $ 800 Bal. $ 392 $ 277 Bank Service fee Bal. $ 850 Interest expense 30-Jan $ 50 31-Jan $ 35 Bal. $ 85 Bal. $ . Bal. $ 85 Bal. S . Unadjusted TB Debit Credit 17,416.67 Adjusted TB Debit Credit 17,416.67 Post-Closing TB Debit Credit 17,416.67 7,395.00 595.00 365.00 200.00 3,200.00 1,800.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 166.67 166.67 13,000.00 13,000.00 13,000.00 200.00 200.00 900.00 900.00 25.00 25.00 7,000.00 9,166.67 Sweaty Bands, Inc. Account Names Cash Account Receivable Inventory - Orange Headbands Inventory - Blue Headbands Office Supplies Store Supplies Prepaid Rent Prepaid Insurance Store & Office Equipment Accumulated Depreciation - Store & Office Equipment Furniture & Fixtures Accumulated Depreciation - Furniture & Fixtures Computer Equipment Accumulated Depreciation - Computer equipment Account Payable Note Payable - Wells Fargo Bank Note Payable - Store & Office Supply Wages Payable Interest Payable Sales Tax Payable Utility Payable Common Stock Retained Earnings Dividends Sales Cost of goods sold Legal expense Store Supplies expense Office Supplies expense Insurance expense Wages expense Delivery expense Advertising and Promotion expense Utility expense Rent expense Depreciation expense Interest expense Bank Service fee Totals 7,000.00 9,166.67 1,550.00 35.00 7,000.00 9,166.67 1,550.00 35.00 277.23 277.23 25,000.00 25,000.00 277.23 25,000.00 9,979.10 100.00 100.00 30,990.00 30,990.00 15,560.00 350.00 375.00 850.00 277.23 350.00 50.00 322.00 300.00 1,550.00 375.00 850.00 277.23 800.00 391.67 85.00 50.00 72,433.90 72,433.90 74,410.57 74,410.57 53,399.67 53,399.67 0 1 T-Mobile Wi-Fi 1:08 AM @ 95% Journal entries, T Accounts and Trial balance :- Sweaty Bands, Inc. Journal Entries N-Date Account N 1 2. Jan Debit Credit Calculation Account No entry 22-Jan 25,000.00 10000 Cash 39003 Common Stock 25,000.00 33-Jan 3,200.00 Jan to April 18000 Prepaid Rent 10000 Cash 3,200.00 43-Jan 1,800.00 6 months 18100 Prepaid insurance 10000 Cash 1,800.00 53-Jan 10,000.00 15000 Store & Office Equipment 21200 Note Payable - Store & Office Supply 4 years & 2,000 residual 10,000.00 1 yr 6% note 65-Jan 7,000.00 6 mnth, 6% note 10000 Cash 21100 Note Payable - Wells Fargo Bank 7,000.00 7 5-Jan 13,000.00 5 years & 1,000 residual 15100 Furniture & Fixtures 10000 Cash 13,000.00 6-Jan 900.00 3 years 15200 Computer Equipment 10000 Cash 900.00 96-Jan 300.00 13100 Office Supplies 10000 Cash 300.00 10 8-Jan 11,000.00 12000 Inventory - Orange Headbands 20000 Account Payable 11,000.00 11 8-Jan 12100 Inventory. Blue Headbands 20000 Account Payable 5,000.00 5,000.00 12 13-Jan 350.00 60100 Legal expense 10000 Cash 350.00 13 13-Jan No entry 8.25% sales tax 14 13-Jan 8,000.00 8,000.00 11000 Account Receivable 40000 Sales 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 4,000.00 2,500.00 1,500.00 15 14-Jan 200.00 13200 Store Supplies 20000 Account Payable 200.00 16 14-Jan 12000 Inventory - Orange Headbands 20000 Account Payable 5,500.00 5,500.00 17 15-Jan 5,953.75 5,500.00 453.75 5500*8.25% 11000 Account Receivable 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 2,750.00 1,500.00 1,250.00 18 20-Jan 20000 Account Payable 10000 Cash 200.00 200.00 19 22-Jan 5,953.75 10000 Cash 11000 Account Receivable 5,953.75 20 22-Jan 16,000.00 11000+5000 20000 Account Payable 10000 Cash 16,000.00 21 22-Jan 12100 Inventory - Blue Headbands 2,900.00 22 23-Jan 850.00 60500 Advertising and Promotion expense 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 100.00 750.00 23 23-Jan 10000 Cash 8,000.00 21 22-Jon 2,900.00 12100 rventory Headbands 20000 Account Payable 2,900.00 22 23-Jan 850.00 60500 Advertising and Promotion expense 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 100.00 750.00 23 23-Jan 8,000.00 10000 Cash 11000 Account Receivable 8,000.00 24 23-Jan 375.00 60400 Delivery expense 10000 Cash 375.00 25 23-Jan 65.00 13100 Office Supplies 10000 Cash 65.00 26 23-Jan 11,496.15 10,620.00 876.15 10620 8.25% 10000 Cash 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 5,310.00 2,655.00 2,655.00 27 23-Jan 8,400.00 5500*2900 20000 Account Payable 10000 Cash 8,400.00 28 25-Jan 4,580.50 4,300.00 280.50 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 12100 Inventory - Blue Headbands 2,150.00 2,000.00 150.00 29 28-Jan 277.23 60550 Utility expense 23400 Utility payable 277.23 30 30-Jan 21200 Note Payable - Store & Office Supply 60700 Interest expense 10000 Cash 833.33 50.00 883.33 31 30-Jan 2,782.03 10000 Cash 40000 Sales 23300 Sales Tax payable 50000 Cost of goods sold 12000 Inventory - Orange Headbands 2,570.00 212.03 1,350.00 350.00 1,000.00 32 30-Jan 1,822.43 453.75+876.15+280.5+212.025 23300 Sales Tax payable 10000 Cash 1,822.43 100.00 100.00 33 31-Jan 39007 Dividends 10000 Cash Adjusting entries No. Date Account No. Account a 31 Jan 60350 Wages expense 23100 Wages payable Credit Debit 1,550.00 1,550.00 b 31-Jan 50.00 200-150 60150 Store Supplies expense 13200 Store Supplies 50.00 31 Jan 322.00 300+65-43 60200 Office Supplies expense 13100 Office Supplies 322.00 d 31-Jan 200.00 =(13,000-1,000)/5*1/12 60650 Depreciation expense 17100 Accumulated Depreciation - Furniture & Fixtures 200.00 e 31-Jan 166.67 60650 Depreciation expense 17000 Accumulated Depreciation - Store & Office Equipment =[10,000-2,000)/4-1/12 166.67 31. Jan 25.00 =900/3*1/12 60650 Depreciation expense 17200 Accumulated Depreciation - Computer equipment 25.00 31-Jan 300.00 =1,800/6 60300 Insurance expense 18100 Prepaid Insurance 300.00 h 31-Jan 800.00 =3,200/4 60600 Rent expense 18000 Prepaid Rent 800.00 i 31-Jan 60700 Interest expense 35.00 =7,000*6%*1/12 35.00 Date Debit Date Credit Accounts Receivable 13-Jan $ 8,000 22-Jan $ 5,954 15-Jan $ 5,954 23-Jan $ 8,000 Sweaty Bands, Inc. T Accounts Date Debit Date Credit Cash 2-Jan $ 25,000 3-Jan $ 3,200 5-Jan $ 7,000 3-Jan $ 1,800 22-Jan $ 5,954 5-Jan $ 13,000 23-Jan $ 8,000 6-Jan $ 900 23-Jan $ 11,496 6-Jan $ 300 25-Jan $ 4,581 13-Jan $ 350 30-Jan $ 2,782 20-Jan $ 200 22-Jan $ 16,000 23-Jan $ 375 23-Jan $ 65 23-Jan $ 8,400 30-Jan $ 883 30-Jan $ 1,822 31-Jan $ 100 Date Debit Date Credit Inventory - Orange Headbands 8-Jan $ 11,000 13-Jan $ 2,500 14-Jan $ 5,500 15-Jan $ 1,500 23-Jan 100.00 23-Jan 2,655.00 25-Jan 2,000.00 30-Jan 350.00 Date Debit Date Credit Inventory - Blue Headbands 8-Jan $ 5,000 13-Jan $ 1,500 22-Jan $ 2,900 15-Jan $ 1,250 23-Jan 750.00 23-Jan 2,655.00 25-Jan 150.00 30-Jan 1,000.00 Bal. $ Bal. Bal. Bal. $ 17,417 Office Supplies 6-Jan $ 300 23-Jan $ 65 31-Jan . Store Supplies 200 31-Jan $ 7,395 Prepaid Rent $ 3,200 31-Jan $ $ 595 Prepaid Insurance $ 1,800 31-Jan $ 14-Jan $ 3-Jan 3-Jan 322.00 50.00 800 300 Bal. Bal. $ 1,500 Bal. $ 43 Store & Office Equipment 3-Jan $10,000 Bal. $ 150 iulated Depreciation - Store & Office Equi 31-Jan $ 167 $ 2,400 Furniture & Fixtures -Jan $ 13,000 5 31-Jan $ 200 Bal. $10,000 Computer Equipment 6-Jan $ 900 Bal. $ 167 imulated Depreciation - Computer equipn 31-Jan $ 25 Bal. $ 200 Note Payable - Wells Fargo Bank 5-Jan $ 7,000 Bal. $13,000 Account Payable 20-Jan $ 200 8-Jan $ 11,000 22-Jan $ 16,000 8-Jan $ 5,000 23-Jan $ 8,400 14-Jan $ 200 14-Jan $ 5,500 22-Jan $ 2,900 S . Bal. 7,000 Bal $ 900 Note Payable - Store & Office Supply 30-Jan $ 833 3-Jan $10,000 $ 25 Wages Payable 31-Jan $ 1,550 Interest Payable 31-Jan $ 35 $ Sales Tax Payable 15-Jan $ 23-Jan $ 25-Jan $ 30-Jan $ 1,822 30-Jan $ 454 876 281 212 $ 35 Bal. $ - Bal. $ 9,167 Utility Payable 28-Jan $ 277 Bal. Retained Earnings Common Stock 2-Jan $ 25,000 31-Jan $ Dividends 100 $ 25,000 Legal expense 350 Bal. $ 100 Store Supplies expense 31-Jan $ 50 13-Jan $ Bal. $ 277 Sales 13-Jan $ 8,000 15-Jan $ 5,500 23-Jan $ 10,620 25-Jan $ 4,300 30-Jan $ 2,570 Bal. Cost of goods sold 13-Jan $ 4,000 15-Jan $ 2,750 23-Jan $ 5,310 25-Jan $ 2,150 30-Jan $ 1,350 Bal. $ 30,990 Office Supplies expense 31-Jan $ 322 Bal. $ 15,560 Insurance expense 31-Jan $ 300 Bal. $ 350 Wages expense 31-Jan $ 1,550 Bal. $ 50 Delivery expense 23-Jan $ 375 Bal. Bal. Bal. $ 322 Advertising and Promotion expense 23-Jan $ 850 $ 300 Utility expense $ 277 $ 1,550 Rent expense $ 800 28-Jan 31-Jan Bal. $ 375 Depreciation expense 31-Jan $ 200 31-Jan $ 167 31-Jan $ 25 Bal. Bal. $ 800 Bal. $ 392 $ 277 Bank Service fee Bal. $ 850 Interest expense 30-Jan $ 50 31-Jan $ 35 Bal. $ 85 Bal. $ . Bal. $ 85 Bal. S . Unadjusted TB Debit Credit 17,416.67 Adjusted TB Debit Credit 17,416.67 Post-Closing TB Debit Credit 17,416.67 7,395.00 595.00 365.00 200.00 3,200.00 1,800.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 7,395.00 595.00 43.00 150.00 2,400.00 1,500.00 10,000.00 166.67 166.67 13,000.00 13,000.00 13,000.00 200.00 200.00 900.00 900.00 25.00 25.00 7,000.00 9,166.67 Sweaty Bands, Inc. Account Names Cash Account Receivable Inventory - Orange Headbands Inventory - Blue Headbands Office Supplies Store Supplies Prepaid Rent Prepaid Insurance Store & Office Equipment Accumulated Depreciation - Store & Office Equipment Furniture & Fixtures Accumulated Depreciation - Furniture & Fixtures Computer Equipment Accumulated Depreciation - Computer equipment Account Payable Note Payable - Wells Fargo Bank Note Payable - Store & Office Supply Wages Payable Interest Payable Sales Tax Payable Utility Payable Common Stock Retained Earnings Dividends Sales Cost of goods sold Legal expense Store Supplies expense Office Supplies expense Insurance expense Wages expense Delivery expense Advertising and Promotion expense Utility expense Rent expense Depreciation expense Interest expense Bank Service fee Totals 7,000.00 9,166.67 1,550.00 35.00 7,000.00 9,166.67 1,550.00 35.00 277.23 277.23 25,000.00 25,000.00 277.23 25,000.00 9,979.10 100.00 100.00 30,990.00 30,990.00 15,560.00 350.00 375.00 850.00 277.23 350.00 50.00 322.00 300.00 1,550.00 375.00 850.00 277.23 800.00 391.67 85.00 50.00 72,433.90 72,433.90 74,410.57 74,410.57 53,399.67 53,399.67
