How do I close the entries as well as Put numbers into T accounts?
Transaction Analysis Cells highlighted in blue must include formulas and may not be hard coded. Transaction Number Marketable Securities Accounts Receivable Assets Prepaid Insurance Accounts Payable Liabilities Unearned Income Tax Revenue Payable Notes Payable Inventory Other Long Term Assets 17,000 Salaries Payable Cash Interest Payable Land Supplies PP&E (net) O 0 36,400 Income Statement Account Equity Common Retained Stock Earnings 51.000 20,400 Beg. Bal. 100,000 7,700 25,000 21.000 0 11.500 51,000 39,500 50,000 0 0 6,700 (6,700) 1 (6,700) 2a 157.500 157.500 Sales Revenue (17.200|COGS 2b (17,200) 2c (12,600) Sales Commissions 3 28,200 (12,600) (28,200) (25,500) (6,500) 4 25,500 5 26,000 19.500 6 (50,000) 7 (19,500) 8 42.000 50,000 (19,500) 42,000 (15,700) ( (14,300) (14,000) 9a (15,700) R&D Costs (14,300) Marketing Expense 9b 10a 14,000 10b (14.000) 14,000 11 11,000 ( (11,000) 80,000 (24,400) 12 13 80.000 24,400 21,000 21.000 15 (9,000) 12.000 16 (9,000) 2.600 17 (21.000) 18 (21,150) (21,000Salaries Expense (11,600 Income Tax Expense 21.000 Service Revenue (21.150 insurance Expense (13.200 Supplies Expense (1.200 interest Expense 70.950 19 (13,200) 20 1.200 1.200 Totals 96,600 18,700 132,500 29,800 7,050 800 61.900 35.900 17,000 51,000 119,500 71.000 2,600 12.000 72.000 6,700 6,700 157,500 157,500 17,200 17,200 12,600 12,600 28,200 28,200 25,500 25,500 26,000 19,500 6,500 6 50,000 50,000 19,500 19,500 42,000 42,000 15,700 15,700 14,300 14,300 14,000 14,000 1 1-Jan Income Tax Payable Cash 2a 31-Mar Accounts Recievable Sales 2b 31-Mar Cost of Goods Sold Inventory 2c 31-Mar Commission on Sales Cash 3 1-Apr Prepaid Insurance Cash 4 1-Apr PP&E Cash 5 1-Apr Inventory Accounts Payable Cash 6 5-Apr Cash Accounts Receivable 7 1-May Accounts Payable Cash 8 1-May Cash Unearned Revenue 9a 30-Jun R&D Cost Cash 9b 30-Jun Marketing Expense Cash 10a 31-Jul Accounts Receivable Cash 10b 31-Jul Supplies Accounts Receivable 11 30-Aug Marketable Securities Cash 12 1-Oct Cash Notes Payable 1-Oct Land Cash 14 1-Oct Cash Common Stock 15 1-Dec Salaries Expense Cash Salaries Payable 16 31-Dec Income Tax Expense Cash Income Tax Payable ADJUSTING ENTRIES 17 31-Dec Unearned Revenue Service Revenue 18 31-Dec Insurance Expense Prepaid Insurance 19 31-Dec Supplies Expense Supplies 20 31-Dec Interest Expense Interest Expense CLOSING ENTRIES 1 31-Dec 14,000 14,000 11,000 11,000 80,000 80,000 13 24,400 24,400 21,000 21,000 21,000 9,000 12,000 11600 9,000 2,600 21,000 21,000 21,150 21,150 13,200 13,200 1,200 1,200 2 31-Dec HARD Cash URMULAS MUST BE USED. DL PP&E (net) BB DE ANY NUMBER Interest Payable BB Salaries Expense BB BB EB EB EB Land Common Stock Marketing Expense BB BB BB EB EB EB EB Other LT Assets Retained Earnings Service Revenue Marketable Securities BB BB BB BB EB EB | EB Accounts Payable Sales Revenue Rent Expense Accounts Receivable BB BB BB BB EB EB EB EB Notes Payable Cost of Goods Sold Supplies Expense Inventory BB BB BB BB EB EB EB EB Unearned Revenue Sales Commissions Interest Expense Prepaid Insurance BB BB BB BB EB EB EB EB Income Tax Payable R&D Expense Income Tax Expense Supplies BB BB BB BB EB EB EB EB Salaries Payable BB EB
