This is a problem I have, I believe I did it right but could use the clarification. Thank you!
M N 0 H NCS.10 December 1, 2023, Ding Conan the following us Det Crede 3200 DO + Acrotectie 600.00 Accumulated Depreciation Cent 1400 Note Receivable S000.00 Accounts Payable 5,250 6 1.2.750.00 Core See More 1500 ples 1.200 Sales and was 1000 2,200.00 Common Stock 11000 22,000.00 Mandamine 1200 TO 60,950. 500.00 11 Owing the company completed the followtions 12 Ore fraid 51, ora and windows, of which is for Decend SD How to do 13 Send was turned from Now 0,7022 en 34 Hech front of cocos 15 10 Sold merchandise for choo costofthedad sold ww $4100 13 Pachthonden tromi Co., 7/10/30 15 Pined for 59,000 I some count $15.00, 1/30, The other 8,000 20 and 3.00 20 25 Paid S1, Hooane fornemme 21 2 dochta con 27 Hecelard collectibles decor, trom automated on Decem 23 2 Received from the town to be preformed in the Iture 29. Purchase oument on account for 2500 > Mendata 20 L Access and payable were $100 22. Depreciation Sperma 28 Stonhand $1.300 2014 O month freded on the site Recewaan Problem GT Accounts france Adjusting Entries Thandal Statement Poulting Entre Closing in 31 7 $500 of merchandise was returned from a November 10, 2022 sale on account 14 8 Received $2,000 cash from customers in payment of account no discount allowed 15 10 Sold merchandise for $8,500. The cost of the merchandise sold was 54,100 17 13 Purchased merchandise on account from Hecht ca. 59.000, terms 2/10/ 17 15 Purchased supplies for cash $2,000 16 18 Sold merchandise on non $15,000, terms 10.30. The cost of the marchandise so was $8,000 19 20 Paid salaries and wapes $2,800 20 21 Paid S1, in advance for next year's annual murance 21 23. Pald Hech Co. in full less discount 22 27 Received collections in full less discounts from customers titled on December 1 23 28 Received from customers for services to be preformed in the future 24 29 Purchase Equipment on account for 2500 25 Adjustment data 26 1. Accrued salaries and wages payable were $700 272 Depreciation was 5400 per month 28. Supplies on hand were $1,500 39.4. One month of interest income should be recorded on the $5000 Note Receivable at an APR of GN 30 5. Services were preformed to satisfy $900 of the earned revenge 316. December's prepondre has been med annual amount was $7200 as recorded in Prepaident 12 33 14 led 35 Complete each tab of this Excel Worksheet: General lournal transactions in December, mapindo T Accountanya caryl prepare Tral Balance 36w the adjusting entries (1-6 abowe Prepare Financial Statements in good for multi-step income statement of Banho 7 prepare the closing entries, prepare the closing trial balance 30 39 Problem General lumal 1 Accounts Tria Bance Adjusting Entries Clow Financial Statements Post Closing in A 8 D E G 1 ACRS. 1 On December 1, 2022, Divine Distributing Company had the following account balances 2 Debit Credit 3. Cash 8,700,00 1 Accounts Receivable 4,600.00 Accumulated Depreciation Equipment 4,400 S Note Receivable 5,000.00 Accounts Payable 5,250 6 Inventory 12,250.00 Uncanned Service Revenue 1500 7 Supplies 1,200.00 Salaries and Wages Payable 1,000 - Prepaid Rent 7,200.00 Common Stock 17.000 9 Equipment 22,000.00 Retained Earning 31,800 10 60,950.00 560,950 11. During December, the company completed the following transactions 12 Doe Paid $1,800 for salaries and wages due employees, of which Soo is for December and $1,000 was acted in November to salaries and wages payable 13 7 $500 of merchandise was returned from a November 30, 2022 sale on account 14 8 Received $2,000 cash from customers in payment of account (no discount allowed) 15 10 Sold merchandise for cash $8,500. The cost of the merchandise sold was 54,300. 16 13 Purchased merchandise on account from Hecht Co. $9,000, terms 2/10, 1/30 17 15 Purchased supplies for cash $2,000. 18 18 Sold merchandise on account $15,000, torms 3/10, 1/30. The cost of the merchandise sold was $8,000, 19 20 Paid salaries and wages $2,800 20 21 Paid $1,800 in advance for next year's annual insurance 21 23 Paid Hecht Co. in full, les discount. 22 27 Received collections in full, loss discounts, from customebilled on December 18 23 28 Received $980 from customers for services to be preformed in the future 24 29 Purchase Equipment on account for $2500 25 Adjustment data: 26 L Accrued salaries and wages payable were $700. 16 13 Purchased merchandise on account from Hecht Co. $9,000, terms 2/10, 1/30 17 15 Purchased supplies for cash $2,000. 18 18 Sold merchandise on account $15,000, terms 3/10, 1/30. The cost of the merchandise sold was $8,000 19 20 Paid salaries and wages $2,800 20 21 Paid $1,800 in advance for next year's annual insurance 22 23 Paid Hecht Co, in full, less discount. 22 27 Received collections in full, less discounts, from customers billed on December 18, 23 28 Received $980 from customers for services to be preformed in the future 24 29 Purchase Equipment on account for $2500 25 Adjustment data: 26 1. Accrued salaries and wages payable were $700. 27 2. Depreciation was $400 per month 28 3. Supplies on hand were $1,500 29 4. One month of interest income should be recorded on the $5000 Note Receivable at an APR of 6% 30 5. Services were preformed to satisfy $900 of the unearned revenue 31 6. December's prepaid rent has been used (annual amount was $7200 as recorded in Prepaid Rent). 32 33 34 Required: 35 Complete each tab of this Excel Worksheet: General Journal (all transactions in December), map into T Accounts (add any if necessaryl, prepare Trial Balance 36 prepare the adjusting entries (1-6 above), Prepare Financial Statements in good form (multi-step income statement, statement of retained earnings, balance sheet) 37 prepare the closing entries, prepare the closing trial balance 38